SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`,
pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2018-10-18 00:00:00",
INTERVAL 220 DAY
)
) > 0 AS new FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` = 1)JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_manufacturer` = 15
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY p.`date_add` desc
LIMIT 0,18

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('96989494db6263c9f1d8e698f786f041',"appagebuilder|displayLeftColumn|1|1|6","", FROM_UNIXTIME(1539851334))

SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 15) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/1/1/6/2/1/77/71/a7/7771a71f2a6dda2d5bf24073f2d25b1f1b28f343.blockcategories.tpl.php'
WHERE `template_hash`='12700bcf0b3cca2722aa3bb693081b21' AND cache_id="blockcategories|1|1|1|6|2|1" AND compile_id=""

SELECT SQL_NO_CACHE p.`id_product`
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_manufacturer = 15 AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS (
SELECT 1
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` = 1
)

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d41d8cd98f00b204e9800998ecf8427e',"appagebuilder|displayLeftColumn|1|1|6","", FROM_UNIXTIME(1539851334))

SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_manufacturer_lang` ml
LEFT JOIN `ps_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`)
WHERE ml.id_lang = 1
AND ml.id_manufacturer = 15 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5c3fbc1689934724484225b06f33c6f3' AND cache_id="leobootstrapmenu||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_manufacturer_shop`
WHERE `id_manufacturer` = 15
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='12700bcf0b3cca2722aa3bb693081b21' AND cache_id="blockcategories|1|1|1|6|2|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4f88731fdbfa0629c3777bd6cb44c9f6' AND cache_id="blocksearch-top|1|1|1|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 277788
AND `date_add` > '2018-10-18 09:58:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2325) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d41d8cd98f00b204e9800998ecf8427e' AND cache_id="appagebuilder|displayBanner|1|1|6" AND compile_id="" LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('12700bcf0b3cca2722aa3bb693081b21',"blockcategories|1|1|1|6|2|1","", FROM_UNIXTIME(1539851334))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ff6acc7654d685e7894914d9a6259e25' AND cache_id="productlist_colors|2325|1|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d41d8cd98f00b204e9800998ecf8427e' AND cache_id="appagebuilder|displayLeftColumn|1|1|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="topNavigation_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="displaySlideshow_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d41d8cd98f00b204e9800998ecf8427e' AND cache_id="appagebuilder|displayHeader|1|1|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="displayFooterTop_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ff6acc7654d685e7894914d9a6259e25',"productlist_colors|2325|1|1","", FROM_UNIXTIME(1539851334))

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="displayBottom_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='c8058427f6498348d9f4ba841efb5923' AND cache_id="appagebuilder|displayHeader|1|1|6" AND compile_id="" LIMIT 1

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('277788', '1909', '920672546', '', '1', '1', '2018-10-18 10:28:54')

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="displayFooterBottom_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="displayContentBottom_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9ba87a07cce7234e015e208ac98e494b' AND cache_id="displayFootNav_leoslideshow||20181018|1|1|1|1|1|6|1" AND compile_id="" LIMIT 1

INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('12700bcf0b3cca2722aa3bb693081b21',"blockcategories|1|1|1|6|2|1","", FROM_UNIXTIME(1539851334))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d41d8cd98f00b204e9800998ecf8427e' AND cache_id="appagebuilder|displayFooter|1|1|6" AND compile_id="" LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ff6acc7654d685e7894914d9a6259e25',"productlist_colors|2325|1|1","", FROM_UNIXTIME(1539851334))

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='96989494db6263c9f1d8e698f786f041' AND cache_id="appagebuilder|displayBanner|1|1|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 18 AND `id_object` = 15 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='96989494db6263c9f1d8e698f786f041' AND cache_id="appagebuilder|displayLeftColumn|1|1|6" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='96989494db6263c9f1d8e698f786f041' AND cache_id="appagebuilder|displayFooter|1|1|6" AND compile_id="" LIMIT 1