SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`,
IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2023-10-03 00:00:00",
INTERVAL 120 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_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  )
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`)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND p.`visibility` IN ("both", "catalog")
AND p.`id_product` IN (2541, 2580, 2575, 1900, 1891, 1839, 1721, 301, 740, 386, 373, 2468, 776, 108, 162, 103, 101, 102, 104, 105, 663, 820, 501, 758, 508, 476, 487, 968, 498, 387, 465, 706, 708, 739, 731, 730, 547, 644, 505, 503, 516, 564, 478, 493, 492, 491, 724, 605, 604, 520, 681, 515, 255, 256, 468, 502, 534, 257, 258, 274, 295, 297, 284, 283, 247, 245, 332, 410, 425, 801, 343, 597, 698, 705, 328, 230, 234, 227, 224, 556, 562, 594, 349, 471, 376, 473, 374, 290, 531, 367, 393, 559, 561, 2510, 588, 2660, 2654, 2628, 2589, 2540, 2606, 2605, 2564, 2483, 2393, 2392, 2596, 1442, 307, 308, 330, 331, 348, 593, 599, 1440, 670, 1707, 1924, 2504, 1623, 380, 1405, 296, 1719, 578, 222, 472, 563, 1374, 2330, 1769, 2309, 2260, 2447, 2446, 1902, 1523, 1644, 2507, 674, 595, 1998, 2620, 2024, 2891, 2284, 240, 511, 1802, 2829, 359, 2886, 2108, 1775, 260, 1306, 1546, 2097, 336, 2599, 2436, 2310, 2201, 2216, 2480, 303, 2584, 685, 2313, 314, 351, 2572, 1620, 406, 2563, 1783, 1467, 2560, 1813, 1857, 244, 362, 364, 514, 392, 518, 1283, 1387, 1808, 2434, 2236, 2217, 1657, 1652, 1527, 2211, 1629, 1740, 1389, 1650, 2562, 2520, 2329, 1898, 1785, 1570, 1481, 261, 1765, 803, 355, 1786, 2977, 2210, 779, 786, 783, 2224, 2218, 2219, 2223, 1874, 1625, 1415, 2361, 1308, 3006, 1895, 1933, 2543, 2092, 2405, 1764, 3012, 2991, 2535, 2509, 1484, 2389, 649, 1460, 2193, 2441, 2352, 1475, 1567, 1872, 2017, 1918, 1378, 1262, 1554, 2196, 573, 3018, 1807, 3163, 1495, 3165, 3166, 1534, 3171, 3169, 2191, 2989, 1842, 391, 1643, 2975, 394, 2347, 3286, 2817, 532, 1234, 1204, 1664, 1701, 1892, 2385, 1819, 504, 2558, 3005, 279, 1657, 2825, 3184, 3188, 3189, 3191, 3192, 3180, 3181, 3182, 3002, 1659, 1741, 2878, 2824, 1737, 2321, 1533, 2337, 1539, 2598, 2287, 2288, 3002, 1659, 1273, 2825, 2388, 1741, 1745, 1712, 1553, 2920, 2878, 2567, 2321, 2976, 2384, 2354, 1868, 2444, 1338, 1578, 1518, 2322, 2287, 2288, 970, 1660, 1524, 586, 1974, 971, 1986, 2109, 1713, 524, 242, 396, 496, 555, 569, 571, 610, 720, 1413, 1420, 1447, 1459, 1482, 1486, 1499, 1501, 1514, 1529, 1545, 1551, 1569, 1594, 1577, 1592, 1647, 1663, 1665, 1671, 3191, 3004, 3011, 3009, 3025, 2869, 2888, 2903, 2909, 2875, 2711, 2713, 2828, 2847, 2651, 2655, 2698)
AND EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`)
ORDER BY product_shop.price DESC
LIMIT 0, 4

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1

SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2903
ORDER BY f.position ASC

SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, 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,
product_shop.`date_add` > "2023-06-05" as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
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_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_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_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  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2023-06-05") AND (EXISTS(SELECT 1 FROM `ps_category_product` cp
JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1)
WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 4

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`

SELECT SQL_NO_CACHE `id_product`, `id_product_attribute`
FROM `ps_specific_price`
WHERE	`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND
`from_quantity` = 1 AND
`reduction` > 0
AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' <= `to`)

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 3 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC

SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND `level_depth` <= 4
AND cg.`id_group` IN (1)
ORDER BY `level_depth` ASC, category_shop.`position` ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1

SELECT SQL_NO_CACHE hs.`id_homeslider_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`description`, hssl.`image`
FROM ps_homeslider hs
LEFT JOIN ps_homeslider_slides hss ON (hs.id_homeslider_slides = hss.id_homeslider_slides)
LEFT JOIN ps_homeslider_slides_lang hssl ON (hss.id_homeslider_slides = hssl.id_homeslider_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position

DELETE FROM ps_smarty_cache WHERE name = "df6bce4269b27f3137a6a8a108ccd520b20a6b50" AND (cache_id  = "blockspecials-home|20231003|1|1|1|1|21" OR cache_id LIKE "blockspecials-home|20231003|1|1|1|1|21|%")

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"fd77e71ae35753dc5ce2e222804f7a60869474a2",
"df6bce4269b27f3137a6a8a108ccd520b20a6b50",
"blockspecials-home|20231003|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:164462806861cb3932f26f79-24354081%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'df6bce4269b27f3137a6a8a108ccd520b20a6b50\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockspecials/views/templates/hook/blockspecials-home.tpl\',\n      1 => 1534417072,\n      2 => \'file\',\n    ),\n    \'281da657ca88696630060c4a2470fc467a278ca3\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/product-list.tpl\',\n      1 => 1552654297,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'164462806861cb3932f26f79-24354081\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907ef26b54_12931679\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907ef26b54_12931679\')) {function content_651b907ef26b54_12931679($_smarty_tpl) {?><h2 class=\"modHome-title\">Nos promotions</h2><h3 class=\"modHome-subtitle\">Retrouvez les offres du moment</h3><ul id=\"blockspecials\" class=\"product_list grid blockspecials tab-pane\"><li class=\"ajax_block_product first-in-line last-line first-item-of-tablet-line first-item-of-mobile-line\"><div class=\"product-container\" itemscope itemtype=\"https://schema.org/Product\"><div class=\"left-block\"><div class=\"product-image-container\"> <a class=\"product_img_link\" href=\"https://preprod.witchpaper.com/les-motifs/2713-papier-d-inde-alcazar-gris-370001050384.html\" title=\"Papier d'Inde Alcazar gris\" itemprop=\"url\"> <img class=\"replace-2x img-responsive\" src=\"https://preprod.witchpaper.com/img/p/1/1/1/3/2/1/0/5/11132105-large_default.jpg\" alt=\"Papier d'Inde Alcazar gris\" title=\"Papier d'Inde Alcazar gris\" itemprop=\"image\" /> </a> <a class=\"quick-view\" href=\"https://preprod.witchpaper.com/les-motifs/2713-papier-d-inde-alcazar-gris-370001050384.html\" rel=\"https://preprod.witchpaper.com/les-motifs/2713-papier-d-inde-alcazar-gris-370001050384.html\"> <span>Aperçu rapide</span> </a><div class=\"product-flags\"> <span class=\"discount-flag\">-20%</span></div></div></div><div class=\"right-block\"><h5 itemprop=\"name\"> <a class=\"product-name\" href=\"https://preprod.witchpaper.com/les-motifs/2713-papier-d-inde-alcazar-gris-370001050384.html\" title=\"Papier d'Inde Alcazar gris\" itemprop=\"url\" > Papier d'Inde Alcazar gris </a></h5><div class=\"content_price price-container\"> <span class=\"old_price_display\"> 5,17 € </span> <span class=\"our_price_display\"> 4,13 € </span></div><div class=\"button-container\"> <span class=\"button ajax_add_to_cart_button btn btn-default btn-cart disabled\"> <svg class=\"iconCart\" viewBox=\"0 0 64 64\" xml:space=\"preserve\"> <g> <path d=\"M22.1,26.7c1.4,0,2.5-1.1,2.5-2.4v-9.4c0-4.2,3.5-7.6,7.8-7.6s7.8,3.4,7.8,7.6v9.4c0,1.3,1.1,2.4,2.5,2.4 c1.4,0,2.5-1.1,2.5-2.4v-9.4C45,8,39.3,2.4,32.3,2.4c-7,0-12.7,5.6-12.7,12.5v9.4C19.6,25.6,20.7,26.7,22.1,26.7z\"/> <path d=\"M60.6,21.3H47.5v3c0,2.7-2.2,4.8-4.9,4.8c-2.7,0-4.9-2.2-4.9-4.8v-3H27v3c0,2.7-2.2,4.8-4.9,4.8s-4.9-2.2-4.9-4.8v-3H3.9 c-0.7,0-1.1,0.5-0.9,1.2l8.6,34.4c0.5,1.9,2.6,3.5,4.6,3.5h32c2,0,4.1-1.6,4.6-3.5l8.6-34.4C61.7,21.8,61.2,21.3,60.6,21.3z\"/> </g> </svg> </span></div></div></div></li><li class=\"ajax_block_product last-line last-item-of-mobile-line\"><div class=\"product-container\" itemscope itemtype=\"https://schema.org/Product\"><div class=\"left-block\"><div class=\"product-image-container\"> <a class=\"product_img_link\" href=\"https://preprod.witchpaper.com/les-motifs/2444-papier-nepalais-patine-rouge-360263175306.html\" title=\"Papier népalais Patine rouge\" itemprop=\"url\"> <img class=\"replace-2x img-responsive\" src=\"https://preprod.witchpaper.com/img/p/1/1/1/3/1/8/1/6/11131816-large_default.jpg\" alt=\"Papier népalais Patine rouge\" title=\"Papier népalais Patine rouge\" itemprop=\"image\" /> </a> <a class=\"quick-view\" href=\"https://preprod.witchpaper.com/les-motifs/2444-papier-nepalais-patine-rouge-360263175306.html\" rel=\"https://preprod.witchpaper.com/les-motifs/2444-papier-nepalais-patine-rouge-360263175306.html\"> <span>Aperçu rapide</span> </a><div class=\"product-flags\"> <span class=\"discount-flag\">-20%</span></div></div></div><div class=\"right-block\"><h5 itemprop=\"name\"> <a class=\"product-name\" href=\"https://preprod.witchpaper.com/les-motifs/2444-papier-nepalais-patine-rouge-360263175306.html\" title=\"Papier népalais Patine rouge\" itemprop=\"url\" > Papier népalais Patine rouge </a></h5><div class=\"content_price price-container\"> <span class=\"old_price_display\"> 5,17 € </span> <span class=\"our_price_display\"> 4,13 € </span></div><div class=\"button-container\"> <span class=\"button ajax_add_to_cart_button btn btn-default btn-cart disabled\"> <svg class=\"iconCart\" viewBox=\"0 0 64 64\" xml:space=\"preserve\"> <g> <path d=\"M22.1,26.7c1.4,0,2.5-1.1,2.5-2.4v-9.4c0-4.2,3.5-7.6,7.8-7.6s7.8,3.4,7.8,7.6v9.4c0,1.3,1.1,2.4,2.5,2.4 c1.4,0,2.5-1.1,2.5-2.4v-9.4C45,8,39.3,2.4,32.3,2.4c-7,0-12.7,5.6-12.7,12.5v9.4C19.6,25.6,20.7,26.7,22.1,26.7z\"/> <path d=\"M60.6,21.3H47.5v3c0,2.7-2.2,4.8-4.9,4.8c-2.7,0-4.9-2.2-4.9-4.8v-3H27v3c0,2.7-2.2,4.8-4.9,4.8s-4.9-2.2-4.9-4.8v-3H3.9 c-0.7,0-1.1,0.5-0.9,1.2l8.6,34.4c0.5,1.9,2.6,3.5,4.6,3.5h32c2,0,4.1-1.6,4.6-3.5l8.6-34.4C61.7,21.8,61.2,21.3,60.6,21.3z\"/> </g> </svg> </span></div></div></div></li><li class=\"ajax_block_product last-line last-item-of-tablet-line first-item-of-mobile-line last-mobile-line\"><div class=\"product-container\" itemscope itemtype=\"https://schema.org/Product\"><div class=\"left-block\"><div class=\"product-image-container\"> <a class=\"product_img_link\" href=\"https://preprod.witchpaper.com/les-motifs/2903-papier-nepalais-rameaux-gris-000000999092.html\" title=\"Papier népalais Rameaux gris\" itemprop=\"url\"> <img class=\"replace-2x img-responsive\" src=\"https://preprod.witchpaper.com/img/p/1/1/1/3/2/7/3/5/11132735-large_default.jpg\" alt=\"Papier népalais Rameaux vert\" title=\"Papier népalais Rameaux vert\" itemprop=\"image\" /> </a> <a class=\"quick-view\" href=\"https://preprod.witchpaper.com/les-motifs/2903-papier-nepalais-rameaux-gris-000000999092.html\" rel=\"https://preprod.witchpaper.com/les-motifs/2903-papier-nepalais-rameaux-gris-000000999092.html\"> <span>Aperçu rapide</span> </a><div class=\"product-flags\"> <span class=\"discount-flag\">-25%</span></div></div></div><div class=\"right-block\"><h5 itemprop=\"name\"> <a class=\"product-name\" href=\"https://preprod.witchpaper.com/les-motifs/2903-papier-nepalais-rameaux-gris-000000999092.html\" title=\"Papier népalais Rameaux gris\" itemprop=\"url\" > Papier népalais Rameaux gris </a></h5><div class=\"content_price price-container\"> <span class=\"old_price_display\"> 5,17 € </span> <span class=\"our_price_display\"> 3,88 € </span></div><div class=\"button-container\"> <span class=\"button ajax_add_to_cart_button btn btn-default btn-cart disabled\"> <svg class=\"iconCart\" viewBox=\"0 0 64 64\" xml:space=\"preserve\"> <g> <path d=\"M22.1,26.7c1.4,0,2.5-1.1,2.5-2.4v-9.4c0-4.2,3.5-7.6,7.8-7.6s7.8,3.4,7.8,7.6v9.4c0,1.3,1.1,2.4,2.5,2.4 c1.4,0,2.5-1.1,2.5-2.4v-9.4C45,8,39.3,2.4,32.3,2.4c-7,0-12.7,5.6-12.7,12.5v9.4C19.6,25.6,20.7,26.7,22.1,26.7z\"/> <path d=\"M60.6,21.3H47.5v3c0,2.7-2.2,4.8-4.9,4.8c-2.7,0-4.9-2.2-4.9-4.8v-3H27v3c0,2.7-2.2,4.8-4.9,4.8s-4.9-2.2-4.9-4.8v-3H3.9 c-0.7,0-1.1,0.5-0.9,1.2l8.6,34.4c0.5,1.9,2.6,3.5,4.6,3.5h32c2,0,4.1-1.6,4.6-3.5l8.6-34.4C61.7,21.8,61.2,21.3,60.6,21.3z\"/> </g> </svg> </span></div></div></div></li><li class=\"ajax_block_product last-in-line last-line first-item-of-tablet-line last-item-of-mobile-line last-mobile-line\"><div class=\"product-container\" itemscope itemtype=\"https://schema.org/Product\"><div class=\"left-block\"><div class=\"product-image-container\"> <a class=\"product_img_link\" href=\"https://preprod.witchpaper.com/les-motifs/586-papier-nepalais-carres-cousus-000000019982.html\" title=\"Papier népalais Carrés cousus\" itemprop=\"url\"> <img class=\"replace-2x img-responsive\" src=\"https://preprod.witchpaper.com/img/p/1/1/1/2/9/9/9/2/11129992-large_default.jpg\" alt=\"1\" title=\"1\" itemprop=\"image\" /> </a> <a class=\"quick-view\" href=\"https://preprod.witchpaper.com/les-motifs/586-papier-nepalais-carres-cousus-000000019982.html\" rel=\"https://preprod.witchpaper.com/les-motifs/586-papier-nepalais-carres-cousus-000000019982.html\"> <span>Aperçu rapide</span> </a><div class=\"product-flags\"> <span class=\"discount-flag\">-60%</span></div></div></div><div class=\"right-block\"><h5 itemprop=\"name\"> <a class=\"product-name\" href=\"https://preprod.witchpaper.com/les-motifs/586-papier-nepalais-carres-cousus-000000019982.html\" title=\"Papier népalais Carrés cousus\" itemprop=\"url\" > Papier népalais Carrés cousus </a></h5><div class=\"content_price price-container\"> <span class=\"old_price_display\"> 8,17 € </span> <span class=\"our_price_display\"> 3,27 € </span></div><div class=\"button-container\"> <span class=\"button ajax_add_to_cart_button btn btn-default btn-cart disabled\"> <svg class=\"iconCart\" viewBox=\"0 0 64 64\" xml:space=\"preserve\"> <g> <path d=\"M22.1,26.7c1.4,0,2.5-1.1,2.5-2.4v-9.4c0-4.2,3.5-7.6,7.8-7.6s7.8,3.4,7.8,7.6v9.4c0,1.3,1.1,2.4,2.5,2.4 c1.4,0,2.5-1.1,2.5-2.4v-9.4C45,8,39.3,2.4,32.3,2.4c-7,0-12.7,5.6-12.7,12.5v9.4C19.6,25.6,20.7,26.7,22.1,26.7z\"/> <path d=\"M60.6,21.3H47.5v3c0,2.7-2.2,4.8-4.9,4.8c-2.7,0-4.9-2.2-4.9-4.8v-3H27v3c0,2.7-2.2,4.8-4.9,4.8s-4.9-2.2-4.9-4.8v-3H3.9 c-0.7,0-1.1,0.5-0.9,1.2l8.6,34.4c0.5,1.9,2.6,3.5,4.6,3.5h32c2,0,4.1-1.6,4.6-3.5l8.6-34.4C61.7,21.8,61.2,21.3,60.6,21.3z\"/> </g> </svg> </span></div></div></div></li></ul><?php }} ?>\n"
)

DELETE FROM ps_smarty_cache WHERE name = "edb323ca81846ca0573f9384b8680c5fd9b2f02b" AND (cache_id  = "blockbanner|1|1|1|1|21" OR cache_id LIKE "blockbanner|1|1|1|1|21|%")

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"e2bf847171ca12ec6254feb207751662063657cc",
"edb323ca81846ca0573f9384b8680c5fd9b2f02b",
"blockbanner|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:9518269961cb3932e57177-54166565%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'edb323ca81846ca0573f9384b8680c5fd9b2f02b\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockbanner/blockbanner.tpl\',\n      1 => 1533464410,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'9518269961cb3932e57177-54166565\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907edcd1d6_70684620\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907edcd1d6_70684620\')) {function content_651b907edcd1d6_70684620($_smarty_tpl) {?></div></div></div></div><div id=\"blockbanner\"> <img class=\"img-responsive\" src=\"https://preprod.witchpaper.com/modules/blockbanner/img/36207c687252bdafcb998f399f672369.jpg\" alt=\"Suivez notre actualité, consultez nos DIY, inspirez-vous tout simplement …\" title=\"Suivez notre actualité, consultez nos DIY, inspirez-vous tout simplement …\" width=\"1170\" height=\"65\" /><div class=\"bannerContent\"><h2 class=\"modHome-title\">Le blog witchpaper</h2><h3 class=\"modHome-subtitle\">Suivez notre actualité, consultez nos DIY, inspirez-vous tout simplement …</h3> <a href=\"https://blog.witchpaper.com\" title=\"Suivez notre actualité, consultez nos DIY, inspirez-vous tout simplement …\" class=\"button btn btn-default button-medium\" target=\"_blank\"> Je m\'inspire </a></div></div><div class=\"container\"><div class=\"row\"><div class=\"center_column col-xs-12 col-sm-12\"><div class=\"clearfix\"><?php }} ?>\n"
)

DELETE FROM ps_smarty_cache WHERE name = "6cd96dbcf349de2275f287868395671e635e8521" AND (cache_id  = "blocknewproducts|20231003|1|1|1|1|21" OR cache_id LIKE "blocknewproducts|20231003|1|1|1|1|21|%")

SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 1
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "45d4287b0f934aa4d1d329fd714ff3ae644dc2fd" AND (cache_id  = "blocktopmenu|1|1|1|1|21|index" OR cache_id LIKE "blocktopmenu|1|1|1|1|21|index|%")

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"53f83d7f5b8b9f4ac96bc83d4b21a367651aba7f",
"735a8ab79575c8b901cdb049ba861b5fe25ed7f6",
"blockcmsinfo|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:72103889561cb393311aa64-61954718%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'735a8ab79575c8b901cdb049ba861b5fe25ed7f6\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockcmsinfo/blockcmsinfo.tpl\',\n      1 => 1533466194,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'72103889561cb393311aa64-61954718\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f0b51d0_42202258\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f0b51d0_42202258\')) {function content_651b907f0b51d0_42202258($_smarty_tpl) {?><div id=\"cmsinfo_block\"><div><h2 class=\"modHome-title\">A propos de nous</h2><p>C’est en décembre 2011, que Florence, réservée mais espiègle, a proposé à son équipe lors du thé quotidien, de créer un site de vente en ligne des papiers de l’Atelier de la Sorcière Verte. Enthousiastes mais néophytes en webmastering, les quatre « jedi » de la reliure se sont lancées dans l’aventure exaltante mais semée d’embûches de la construction du site. Le 1er décembre 2013, Witchpaper est lancé avec trac dans l’immensité du net.</p></div></div></div><?php }} ?>\n"
)

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"6bacccff288551a89148d709123d84adc71a1c76",
"d8576c8fe8934689e4606dde4fa25f200123d2cd",
"homeslider|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:200377567861cb3932b9d7e8-26139476%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'d8576c8fe8934689e4606dde4fa25f200123d2cd\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/homeslider/homeslider.tpl\',\n      1 => 1534958646,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'200377567861cb3932b9d7e8-26139476\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907ec0dfe2_61718292\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907ec0dfe2_61718292\')) {function content_651b907ec0dfe2_61718292($_smarty_tpl) {?><div id=\"homepage-slider\"><ul id=\"homeslider\"><li class=\"homeslider-container flipable\"> <a href=\"https://www.witchpaper.com/22-collection-de-bijoux-\" title=\"La Collection !\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/3e38f69b4f549f023948672337e5de95cfd08237_BO.jpg\" width=\"100%\" height=\"auto\" alt=\"La Collection !\" /> </a><div class=\"homeslider-description\"><p style=\"text-align:center;\"><span style=\"color:#ffffff;background-color:#ffffff;\"><span style=\"color:#ffffff;\"><span style=\"color:#000000;\"><span style=\"color:#ffffff;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\">Collection de bijoux<br />en métal recyclé<br />MADE IN<br />LILLE !!</span></span></span></span></span></span></span></span><span style=\"color:#ffffff;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"></span></span></span></p></div></li><li class=\"homeslider-container flipable\"> <a href=\"https://www.witchpaper.com/10-papier-japonais\" title=\"Les papiers japonais !!\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/92da1b4749731de1a7164478492354a9605739f9_japbleu2.jpg\" width=\"100%\" height=\"auto\" alt=\"Les papiers japonais !!\" /> </a><div class=\"homeslider-description\"><p style=\"text-align:center;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\">Collection de papiers japonais<br />en fibres de mûrier et<br />sérigraphiés à<br />la main.</span></span></span></p></div></li><li class=\"homeslider-container flipable\"> <a href=\"https://www.witchpaper.com/4-kits-origami\" title=\"Kits de Papiers Origami !!\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/ac92bf52e28ae6b26e533dddab3c8dc42ffc2a3c_KitsJaune2.jpg\" width=\"100%\" height=\"auto\" alt=\"Kits de Papiers Origami !!\" /> </a><div class=\"homeslider-description\"><div class=\"homeslider-description\" style=\"text-align:center;\">Kits de Papiers<br />assortis pour<br />esprits créatifs !!</div></div></li><li class=\"homeslider-container flipable\"> <a href=\"https://www.witchpaper.com/contactez-nous\" title=\"Contact\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/0b4e6b95c7265bd75db4e4dab2fd88be7117429a_contact.jpg\" width=\"100%\" height=\"auto\" alt=\"Contact\" /> </a><div class=\"homeslider-description\"><p style=\"text-align:center;\">Contactez nous !</p></div></li><li class=\"homeslider-container flipable\"> <a href=\"https://www.witchpaper.com/9-papier-nepalais\" title=\"Les papiers Népalais !!\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/8dd103bc3638981068c6c747077a0f3574e0d16b_papiernép3.jpg\" width=\"100%\" height=\"auto\" alt=\"Les papiers Népalais !!\" /> </a><div class=\"homeslider-description\"><p style=\"text-align:center;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#ffffff;background-color:#ffffff;\"><span style=\"color:#ffffff;\"><span style=\"color:#000000;\"><span style=\"color:#ffffff;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\"><span style=\"color:#000000;\">Collection rare et merveilleuse<br />de papiers en fibres de lokta,<br />faits main au Népal et<br />issus de commerce<br />équitable.</span></span></span></span></span></span></span></span></span></span></span></p></div></li><li class=\"homeslider-container\"> <a href=\"https://www.witchpaper.com/content/1-livraison\" title=\"Retrait Gratuit des Commandes \"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/58d8d2e9b9fd936b79d9184fd89d514b3dfcf764_Retraits2.jpg\" width=\"100%\" height=\"auto\" alt=\"Retrait Gratuit des Commandes \" /> </a></li><li class=\"homeslider-container\"> <a href=\"https://www.witchpaper.com/content/4-qui-sommes-nous-\" title=\"Contact\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/73dc0a0ad7c9effc0b0f7a47a3d11f253a77b231_qui2.jpg\" width=\"100%\" height=\"auto\" alt=\"Contact\" /> </a></li><li class=\"homeslider-container\"> <a href=\"https://www.witchpaper.com/promotions\" title=\"Promos !!\"> <img class=\"homeslider-img\" src=\"https://preprod.witchpaper.com/modules/homeslider/images/d5d4ec8d887610b3ba70b7c2ce155de2e19ea77c_promos5.jpg\" width=\"100%\" height=\"auto\" alt=\"Promos !!\" /> </a><div class=\"homeslider-description\"><p style=\"text-align:center;\">Profitez d\'une sélection<br />d\'articles à prix<br />mini !!!</p></div></li></ul></div><?php }} ?>\n"
)

DELETE FROM ps_smarty_cache WHERE name = "b81c1fce53a2cf9beb279831ca59e54a2d8359df" AND (cache_id  = "blockcategories|1|1|1|1|21|1" OR cache_id LIKE "blockcategories|1|1|1|1|21|1|%")

SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"b2f246c278bab0c1f3db9afaf6ae514570dce134",
"45d4287b0f934aa4d1d329fd714ff3ae644dc2fd",
"blocktopmenu|1|1|1|1|21|index",
"<?php /*%%SmartyHeaderCode:65912149061cb3932ac4a90-22050029%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'45d4287b0f934aa4d1d329fd714ff3ae644dc2fd\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blocktopmenu/blocktopmenu.tpl\',\n      1 => 1552505906,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'65912149061cb3932ac4a90-22050029\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907ebd4b21_01117477\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907ebd4b21_01117477\')) {function content_651b907ebd4b21_01117477($_smarty_tpl) {?><div class=\"sf-contener\" id=\"sf-contener\"><div class=\"sf-overlay\"></div><ul class=\"sf-menu\" id=\"sf-menu\"><li class=\"js-submenu \"><span class=\"sf-menu__item\">Couleurs et motifs<i class=\"icon-angle-down\"></i></span><ul><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/6-les-unis\" title=\"Les unis\">Les unis</a><span class=\"sf_img\"><img src=\"c/6-medium.jpg\" alt=\"Les unis\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/13-simili-cuir-et-matiere\" title=\"Simili cuir et matière\">Simili cuir et matière</a><span class=\"sf_img\"><img src=\"c/13-medium.jpg\" alt=\"Simili cuir et matière\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/14-rouge-rose\" title=\"Rouge-rose\">Rouge-rose</a><span class=\"sf_img\"><img src=\"c/14-medium.jpg\" alt=\"Rouge-rose\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/15-mauve-prune\" title=\"Mauve-prune\">Mauve-prune</a><span class=\"sf_img\"><img src=\"c/15-medium.jpg\" alt=\"Mauve-prune\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/16-jaune-orange\" title=\"Jaune-orange\">Jaune-orange</a><span class=\"sf_img\"><img src=\"c/16-medium.jpg\" alt=\"Jaune-orange\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/17-vert\" title=\"Vert\">Vert</a><span class=\"sf_img\"><img src=\"c/17-medium.jpg\" alt=\"Vert\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/18-bleu\" title=\"Bleu\">Bleu</a><span class=\"sf_img\"><img src=\"c/18-medium.jpg\" alt=\"Bleu\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/19-noir-blanc-gris\" title=\"Noir-blanc-gris\">Noir-blanc-gris</a><span class=\"sf_img\"><img src=\"c/19-medium.jpg\" alt=\"Noir-blanc-gris\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/20-marron-beige\" title=\"Marron-beige\">Marron-beige</a><span class=\"sf_img\"><img src=\"c/20-medium.jpg\" alt=\"Marron-beige\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/21-or-argent\" title=\"Or-argent\">Or-argent</a><span class=\"sf_img\"><img src=\"c/21-medium.jpg\" alt=\"Or-argent\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/26-geometriques\" title=\"Géométriques\">Géométriques</a><span class=\"sf_img\"><img src=\"c/26-medium.jpg\" alt=\"Géométriques\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/25-fleurs\" title=\"Fleurs\">Fleurs</a><span class=\"sf_img\"><img src=\"c/25-medium.jpg\" alt=\"Fleurs\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/27-animaux\" title=\"Animaux\">Animaux</a><span class=\"sf_img\"><img src=\"c/27-medium.jpg\" alt=\"Animaux\"></span></li><li class=\"category-thumbnail\"><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/28-et-plus\" title=\"Et plus...\">Et plus...</a><span class=\"sf_img\"><img src=\"c/28-medium.jpg\" alt=\"Et plus...\"></span></li></ul></li><li ><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/9-papier-nepalais\" title=\"Papier Népalais\">Papier Népalais</a></li><li ><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/10-papier-japonais\" title=\"Papier Japonais\">Papier Japonais</a></li><li ><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/11-papier-d-inde\" title=\"Papier d\'Inde\">Papier d\'Inde</a></li><li ><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/4-kits-origami\" title=\"Kits ORIGAMI\">Kits ORIGAMI</a></li><li ><a class=\"sf-menu__item\" href=\"https://preprod.witchpaper.com/22-collection-de-bijoux-\" title=\"COLLECTION DE BIJOUX !!\">COLLECTION DE BIJOUX !!</a></li></ul></div><?php }} ?>\n"
)

UPDATE `ps_smarty_lazy_cache`
SET filepath='e2bf847171ca12ec6254feb207751662063657cc'
WHERE `template_hash`='524a821603052d651da67a13ffbf9a34' AND cache_id="blockbanner|1|1|1|1|21" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('4278714ff24835b8980d9458c50fb879',"blocknewproducts|20231003|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2903) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2713) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"8e034c04c58b2776eee82be04053eb83ebc0fcad",
"7f744c27484483611a3559db290cbbf0450411bc",
"blockcontactinfos|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:16401378361cb3933354ba6-48673995%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'7f744c27484483611a3559db290cbbf0450411bc\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockcontactinfos/blockcontactinfos.tpl\',\n      1 => 1534693670,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'16401378361cb3933354ba6-48673995\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f1e81a6_54870701\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f1e81a6_54870701\')) {function content_651b907f1e81a6_54870701($_smarty_tpl) {?><section id=\"block_contact_infos\" class=\"footer-block col-xs-12 col-sm-4\"><div><h4>Besoin d\'aide ?</h4><ul class=\"toggle-footer\"><li> <i class=\"icon-phone\"></i>Appelez-nous au : <span>+33 (0)675930572</span></li><li> <i class=\"icon-envelope-alt\"></i>E-mail : <span><a href=\"mailto:%63%6f%6e%74%61%63%74@%77%69%74%63%68%70%61%70%65%72.%63%6f%6d\" >contact@witchpaper.com</a></span></li><li> <i class=\"icon-map-marker\"></i>Witchpaper, 11 rue basse, 59000 Lille</li></ul></div> </section><?php }} ?>\n"
)

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"f921531a882d74a8e590722be68d709083874e51",
"6cd96dbcf349de2275f287868395671e635e8521",
"blocknewproducts|20231003|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:213462310061cb3932d05f03-90978823%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'6cd96dbcf349de2275f287868395671e635e8521\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/modules/blocknewproducts/views/templates/hook/blocknewproducts_home.tpl\',\n      1 => 1533459653,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'213462310061cb3932d05f03-90978823\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907ed24aa5_16750828\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907ed24aa5_16750828\')) {function content_651b907ed24aa5_16750828($_smarty_tpl) {?><ul id=\"blocknewproducts\" class=\"blocknewproducts tab-pane\"><li class=\"alert alert-info\">Aucun nouveau produit à l\'heure actuelle.</li></ul><?php }} ?>\n"
)

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

DELETE FROM ps_smarty_cache WHERE name = "735a8ab79575c8b901cdb049ba861b5fe25ed7f6" AND (cache_id  = "blockcmsinfo|1|1|1|1|21" OR cache_id LIKE "blockcmsinfo|1|1|1|1|21|%")

DELETE FROM ps_smarty_cache WHERE name = "1dbaf2cc833e5dfcd8c05ea9d03f40b4789c51b5" AND (cache_id  = "blocksocial|1|1|1|1|21" OR cache_id LIKE "blocksocial|1|1|1|1|21|%")

UPDATE `ps_smarty_lazy_cache`
SET filepath='fd77e71ae35753dc5ce2e222804f7a60869474a2'
WHERE `template_hash`='ea4ac7d8ffe22eed3c1918833e6add7f' AND cache_id="blockspecials-home|20231003|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 586) AND (b.`id_shop` = 1) LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='6bacccff288551a89148d709123d84adc71a1c76'
WHERE `template_hash`='b7e6ac8b8076306a234c3cc631a55820' AND cache_id="homeslider|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2903)

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"ef8d6243aee65b771f13a39a10b423f6776db48a",
"387de21e5439c83ea6bf42eec919c88d9b8f12d8",
"blocksearch-top|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:31601405161cb3933c227f2-63094016%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'387de21e5439c83ea6bf42eec919c88d9b8f12d8\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blocksearch/blocksearch-top.tpl\',\n      1 => 1534669622,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'31601405161cb3933c227f2-63094016\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f290345_84213394\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f290345_84213394\')) {function content_651b907f290345_84213394($_smarty_tpl) {?><span class=\"only-mobile js-showSearch\"></span><div id=\"search_block_top\" class=\"col-sm-4\"><form id=\"searchbox\" method=\"get\" action=\"//preprod.witchpaper.com/index.php?controller=search\" > <input type=\"hidden\" name=\"controller\" value=\"search\" /> <input type=\"hidden\" name=\"orderby\" value=\"position\" /> <input type=\"hidden\" name=\"orderway\" value=\"desc\" /> <input class=\"search_query form-control\" type=\"search\" id=\"search_query_top\" name=\"search_query\" placeholder=\"Rechercher\" value=\"\" /> <button type=\"submit\" name=\"submit_search\" class=\"btn btn-default button-search\"> OK<span>Rechercher</span> </button></form></div><?php }} ?>\n"
)

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"4ed28b0f4e442911016726136baf042c9f6ff075",
"a6162412c5a51a2bb8fe401eceb95b1f8a0ff92d",
"blockcms|2|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:119224860261cb393326bac6-56989760%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'a6162412c5a51a2bb8fe401eceb95b1f8a0ff92d\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockcms/blockcms.tpl\',\n      1 => 1534764144,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'119224860261cb393326bac6-56989760\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f1991d2_00856977\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f1991d2_00856977\')) {function content_651b907f1991d2_00856977($_smarty_tpl) {?><section class=\"footer-block col-xs-12 col-sm-2\" id=\"block_various_links_footer\"><h4>Informations</h4><ul class=\"toggle-footer\"><li class=\"item\"> <a href=\"https://preprod.witchpaper.com/promotions\" title=\"Promotions\"> Promotions </a></li><li class=\"item\"> <a href=\"https://preprod.witchpaper.com/contactez-nous\" title=\"Contactez-nous\"> Contactez-nous </a></li><li class=\"item\"> <a href=\"https://preprod.witchpaper.com/content/1-livraison\" title=\"Livraison\"> Livraison </a></li><li class=\"item\"> <a href=\"https://preprod.witchpaper.com/content/3-conditions-generales-de-ventes\" title=\"Conditions d'utilisation\"> Conditions d'utilisation </a></li><li class=\"item\"> <a href=\"https://preprod.witchpaper.com/content/4-qui-sommes-nous-\" title=\"Qui sommes nous ?\"> Qui sommes nous ? </a></li><li class=\"item\"> <a href=\"https://preprod.witchpaper.com/content/5-paiement\" title=\"Paiement\"> Paiement </a></li><li> <a href=\"https://preprod.witchpaper.com/plan-du-site\" title=\"Plan du site\"> Plan du site </a></li></ul> </section><?php }} ?>\n"
)

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"5d2a76d3d7415fb10ac25bf877f58e0943eb8495",
"1dbaf2cc833e5dfcd8c05ea9d03f40b4789c51b5",
"blocksocial|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:201676580661cb3933bd8c16-08702549%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'1dbaf2cc833e5dfcd8c05ea9d03f40b4789c51b5\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blocksocial/blocksocial.tpl\',\n      1 => 1534156729,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'201676580661cb3933bd8c16-08702549\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f267c25_30547868\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f267c25_30547868\')) {function content_651b907f267c25_30547868($_smarty_tpl) {?><section id=\"social_block\"><ul><li class=\"facebook\"> <a class=\"_blank\" href=\"https://www.facebook.com/witchpaperofficiel/\"> <i class=\"icon-facebook-f\"></i> </a></li><li class=\"twitter\"> <a class=\"_blank\" href=\"https://twitter.com/witchpaper\"> <i class=\"icon-twitter\"></i> </a></li><li class=\"instagram\"> <a class=\"_blank\" href=\"https://www.instagram.com/witchpaper/\"> <i class=\"icon-instagram\"></i> </a></li></ul> </section><div class=\"clearfix\"></div><?php }} ?>\n"
)

UPDATE `ps_smarty_lazy_cache`
SET filepath='53f83d7f5b8b9f4ac96bc83d4b21a367651aba7f'
WHERE `template_hash`='1b89cc03aedd32075b5a23580bbff353' AND cache_id="blockcmsinfo|1|1|1|1|21" AND compile_id=""

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea4ac7d8ffe22eed3c1918833e6add7f',"blockspecials-home|20231003|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 9 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"7367aa9e584a857fb167a7a3461946de83ce8a6d",
"eaa8cd5c0a0ec249e25b91455e5d70962eeb2904",
"blockmyaccountfooter|1|1|1|1|21",
"<?php /*%%SmartyHeaderCode:56590895661cb393330fe00-85223090%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'eaa8cd5c0a0ec249e25b91455e5d70962eeb2904\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockmyaccountfooter/blockmyaccountfooter.tpl\',\n      1 => 1524743026,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'56590895661cb393330fe00-85223090\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f1beac4_33144644\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f1beac4_33144644\')) {function content_651b907f1beac4_33144644($_smarty_tpl) {?><section class=\"footer-block col-xs-12 col-sm-4\"><h4><a href=\"https://preprod.witchpaper.com/mon-compte\" title=\"Gérer mon compte client\" rel=\"nofollow\">Mon compte</a></h4><div class=\"block_content toggle-footer\"><ul class=\"bullet\"><li><a href=\"https://preprod.witchpaper.com/historique-des-commandes\" title=\"Mes commandes\" rel=\"nofollow\">Mes commandes</a></li><li><a href=\"https://preprod.witchpaper.com/avoirs\" title=\"Mes avoirs\" rel=\"nofollow\">Mes avoirs</a></li><li><a href=\"https://preprod.witchpaper.com/adresses\" title=\"Mes adresses\" rel=\"nofollow\">Mes adresses</a></li><li><a href=\"https://preprod.witchpaper.com/identite\" title=\"Gérer mes informations personnelles\" rel=\"nofollow\">Mes informations personnelles</a></li><li><a href=\"https://preprod.witchpaper.com/bons-de-reduction\" title=\"Mes bons de réduction\" rel=\"nofollow\">Mes bons de réduction</a></li></ul></div> </section><?php }} ?>\n"
)

REPLACE INTO ps_smarty_cache (id_smarty_cache, name, cache_id, content)
VALUES (
"ed3f49f36426b7366419ddd466f0d83f9a3eee2d",
"b81c1fce53a2cf9beb279831ca59e54a2d8359df",
"blockcategories|1|1|1|1|21|1",
"<?php /*%%SmartyHeaderCode:151565157361cb3933204ed3-17032152%%*/if(!defined(\'SMARTY_DIR\')) exit(\'no direct access allowed\');\n$_valid = $_smarty_tpl->decodeProperties(array (\n  \'file_dependency\' => \n  array (\n    \'b81c1fce53a2cf9beb279831ca59e54a2d8359df\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockcategories/blockcategories_footer.tpl\',\n      1 => 1524743021,\n      2 => \'file\',\n    ),\n    \'7e4274bc5b9cd2c230c7424b8b27abe00cfa3e1c\' => \n    array (\n      0 => \'/home/witchpapfj/www/prestashop/themes/witchpaper2.0/modules/blockcategories/category-tree-branch.tpl\',\n      1 => 1534852881,\n      2 => \'file\',\n    ),\n  ),\n  \'nocache_hash\' => \'151565157361cb3933204ed3-17032152\',\n  \'version\' => \'Smarty-3.1.19\',\n  \'unifunc\' => \'content_651b907f161967_59281435\',\n  \'has_nocache_code\' => false,\n  \'cache_lifetime\' => 31536000,\n),true); /*/%%SmartyHeaderCode%%*/?>\n<?php if ($_valid && !is_callable(\'content_651b907f161967_59281435\')) {function content_651b907f161967_59281435($_smarty_tpl) {?><section class=\"blockcategories_footer footer-block col-xs-12 col-sm-2\"><h4>Catégories</h4><div class=\"category_footer toggle-footer\"><div class=\"list\"><ul class=\"dhtml\"><li ></li><li > <a href=\"https://preprod.witchpaper.com/22-collection-de-bijoux-\" title=\"\"> COLLECTION DE BIJOUX !! </a></li><li > <a href=\"https://preprod.witchpaper.com/4-kits-origami\" title=\"Découvrez nos kits de papiers prédécoupés idéals pour l'origami, le scrapbooking, la déco, etc...\"> Kits ORIGAMI </a></li><li > <a href=\"https://preprod.witchpaper.com/29-nouveautes-\" title=\"Retrouvez nos motifs tendances et toutes nos nouveautés papiers...\"> NOUVEAUTÉS ! </a></li><li > <a href=\"https://preprod.witchpaper.com/9-papier-nepalais\" title=\"Collection rare et merveilleuse de papiers en fibres de lokta, faits main au Népal et issus de commerce équitable.\"> Papier Népalais </a></li><li > <a href=\"https://preprod.witchpaper.com/10-papier-japonais\" title=\"Collection de papiers japonais en fibres de mûrier et sérigraphiés à la main.\"> Papier Japonais </a></li><li class=\"last\"> <a href=\"https://preprod.witchpaper.com/11-papier-d-inde\" title=\"Collection de papiers en fibres de coton recyclé, faits main en Inde et issus du commerce équitable\"> Papier d'Inde </a></li></ul></div></div> </section><?php }} ?>\n"
)

DELETE FROM ps_smarty_cache WHERE name = "a6162412c5a51a2bb8fe401eceb95b1f8a0ff92d" AND (cache_id  = "blockcms|2|1|1|1|1|21" OR cache_id LIKE "blockcms|2|1|1|1|1|21|%")

DELETE FROM ps_smarty_cache WHERE name = "d8576c8fe8934689e4606dde4fa25f200123d2cd" AND (cache_id  = "homeslider|1|1|1|1|21" OR cache_id LIKE "homeslider|1|1|1|1|21|%")

DELETE FROM ps_smarty_cache WHERE name = "387de21e5439c83ea6bf42eec919c88d9b8f12d8" AND (cache_id  = "blocksearch-top|1|1|1|1|21" OR cache_id LIKE "blocksearch-top|1|1|1|1|21|%")

INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('3373855', '1', '317240101', '', '1', '1', '2023-10-03 05:54:39')

DELETE FROM ps_smarty_cache WHERE name = "7f744c27484483611a3559db290cbbf0450411bc" AND (cache_id  = "blockcontactinfos|1|1|1|1|21" OR cache_id LIKE "blockcontactinfos|1|1|1|1|21|%")

UPDATE `ps_smarty_lazy_cache`
SET filepath='5d2a76d3d7415fb10ac25bf877f58e0943eb8495'
WHERE `template_hash`='a4718b48c2e16bb03aa85c4d6934ae20' AND cache_id="blocksocial|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2713
ORDER BY f.position ASC

UPDATE `ps_smarty_lazy_cache`
SET filepath='7367aa9e584a857fb167a7a3461946de83ce8a6d'
WHERE `template_hash`='b4dcf89035e0510d0c54f7e5158b5e52' AND cache_id="blockmyaccountfooter|1|1|1|1|21" AND compile_id=""

UPDATE `ps_smarty_lazy_cache`
SET filepath='f921531a882d74a8e590722be68d709083874e51'
WHERE `template_hash`='4278714ff24835b8980d9458c50fb879' AND cache_id="blocknewproducts|20231003|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m

UPDATE `ps_smarty_lazy_cache`
SET filepath='ed3f49f36426b7366419ddd466f0d83f9a3eee2d'
WHERE `template_hash`='7415787b38e7988dc3424c280737b40f' AND cache_id="blockcategories|1|1|1|1|21|1" AND compile_id=""

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 11 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

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', 'en', '0')

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 586
ORDER BY f.position ASC

SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2713)

SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "index" LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 4 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 10 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 44 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2444) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 2713 LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 45 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 39 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2023-10-03 00:00:00' AND '2023-10-03 23:59:59' LIMIT 1

SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 3373855
AND `date_add` > '2023-10-03 05:24:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'preprod.witchpaper.com' OR su.domain_ssl = 'preprod.witchpaper.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

SELECT SQL_NO_CACHE r.`id_info`, r.`id_shop`, rl.`text`
FROM `ps_info` r
LEFT JOIN `ps_info_lang` rl ON (r.`id_info` = rl.`id_info`)
WHERE `id_lang` = 1 AND  `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2903) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 22 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC

UPDATE `ps_smarty_lazy_cache`
SET filepath='b2f246c278bab0c1f3db9afaf6ae514570dce134'
WHERE `template_hash`='0bab1e6e041c3b5a15e617604aa18125' AND cache_id="blocktopmenu|1|1|1|1|21|index" AND compile_id=""

SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2713) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 2444
ORDER BY f.position ASC

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 2444) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "6cd96dbcf349de2275f287868395671e635e8521" AND (cache_id  = "blocknewproducts|20231003|1|1|1|1|21" OR cache_id LIKE "blocknewproducts|20231003|1|1|1|1|21|%")

SELECT SQL_NO_CACHE * FROM `ps_hook_alias`

UPDATE `ps_smarty_lazy_cache`
SET filepath='8e034c04c58b2776eee82be04053eb83ebc0fcad'
WHERE `template_hash`='549b2475696f2ea787f78ee810388313' AND cache_id="blockcontactinfos|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'home' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2713
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 586) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-10-03 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1

SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'index' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2444)

SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC

SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'home' AND hm.`id_module` = 38 LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 2903 LIMIT 1

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 *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2903 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 586)

SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 1 LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='ef8d6243aee65b771f13a39a10b423f6776db48a'
WHERE `template_hash`='bf872834a1b82a1073630ccb1b79c089' AND cache_id="blocksearch-top|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 7
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

DELETE FROM ps_smarty_cache WHERE name = "eaa8cd5c0a0ec249e25b91455e5d70962eeb2904" AND (cache_id  = "blockmyaccountfooter|1|1|1|1|21" OR cache_id LIKE "blockmyaccountfooter|1|1|1|1|21|%")

SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 586) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='524a821603052d651da67a13ffbf9a34' AND cache_id="blockbanner|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1

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

SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`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`='0bab1e6e041c3b5a15e617604aa18125' AND cache_id="blocktopmenu|1|1|1|1|21|index" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) AND (b.`id_shop` = 1) LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "edb323ca81846ca0573f9384b8680c5fd9b2f02b" AND (cache_id  = "blockbanner|1|1|1|1|21" OR cache_id LIKE "blockbanner|1|1|1|1|21|%")

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 586 LIMIT 1

UPDATE `ps_smarty_lazy_cache`
SET filepath='4ed28b0f4e442911016726136baf042c9f6ff075'
WHERE `template_hash`='be0c13c6e0793a48a9428094d686fa7d' AND cache_id="blockcms|2|1|1|1|1|21" AND compile_id=""

SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "e2bf847171ca12ec6254feb207751662063657cc" LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2713) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) AND (b.`id_shop` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('524a821603052d651da67a13ffbf9a34',"blockbanner|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "fd77e71ae35753dc5ce2e222804f7a60869474a2" LIMIT 1

SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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)
WHERE pa.id_product = 2444 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2444) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 586
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) AND (b.`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`='7415787b38e7988dc3424c280737b40f' AND cache_id="blockcategories|1|1|1|1|21|1" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a4718b48c2e16bb03aa85c4d6934ae20' AND cache_id="blocksocial|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2903
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='4278714ff24835b8980d9458c50fb879' AND cache_id="blocknewproducts|20231003|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 17 AND `id_shop` = 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='1b89cc03aedd32075b5a23580bbff353' AND cache_id="blockcmsinfo|1|1|1|1|21" AND compile_id="" LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "735a8ab79575c8b901cdb049ba861b5fe25ed7f6" AND (cache_id  = "blockcmsinfo|1|1|1|1|21" OR cache_id LIKE "blockcmsinfo|1|1|1|1|21|%")

SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

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 modified FROM ps_smarty_cache WHERE id_smarty_cache = "ed3f49f36426b7366419ddd466f0d83f9a3eee2d" LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "45d4287b0f934aa4d1d329fd714ff3ae644dc2fd" AND (cache_id  = "blocktopmenu|1|1|1|1|21|index" OR cache_id LIKE "blocktopmenu|1|1|1|1|21|index|%")

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) LIMIT 1

SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "e2bf847171ca12ec6254feb207751662063657cc" LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "53f83d7f5b8b9f4ac96bc83d4b21a367651aba7f" LIMIT 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 27 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1

SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 7 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('4278714ff24835b8980d9458c50fb879',"blocknewproducts|20231003|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2903 AND id_shop=1 LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "d8576c8fe8934689e4606dde4fa25f200123d2cd" AND (cache_id  = "homeslider|1|1|1|1|21" OR cache_id LIKE "homeslider|1|1|1|1|21|%")

SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2023-10-03 00:00:00' AND '2023-10-03 23:59:59' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 26 AND `id_shop` = 1

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 25) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 20 AND `id_shop` = 1

SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2903) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

SELECT SQL_NO_CACHE * FROM `ps_image_type`

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('524a821603052d651da67a13ffbf9a34',"blockbanner|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('b7e6ac8b8076306a234c3cc631a55820',"homeslider|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2444
ORDER BY `id_specific_price_priority` DESC LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "53f83d7f5b8b9f4ac96bc83d4b21a367651aba7f" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocknewproducts" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "1dbaf2cc833e5dfcd8c05ea9d03f40b4789c51b5" AND (cache_id  = "blocksocial|1|1|1|1|21" OR cache_id LIKE "blocksocial|1|1|1|1|21|%")

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 7) LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 586 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 11 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "f921531a882d74a8e590722be68d709083874e51" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 44 AND `id_shop` = 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('0bab1e6e041c3b5a15e617604aa18125',"blocktopmenu|1|1|1|1|21|index","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 7 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 3) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 28 AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2713 AND id_shop=1 LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2713 AND `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 16 AND `id_shop` = 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "6bacccff288551a89148d709123d84adc71a1c76" LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "f921531a882d74a8e590722be68d709083874e51" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9) LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "b81c1fce53a2cf9beb279831ca59e54a2d8359df" AND (cache_id  = "blockcategories|1|1|1|1|21|1" OR cache_id LIKE "blockcategories|1|1|1|1|21|1|%")

SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "8e034c04c58b2776eee82be04053eb83ebc0fcad" LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('7415787b38e7988dc3424c280737b40f',"blockcategories|1|1|1|1|21|1","", FROM_UNIXTIME(1696305279))

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 10 AND `id_shop` = 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('1b89cc03aedd32075b5a23580bbff353',"blockcmsinfo|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "b2f246c278bab0c1f3db9afaf6ae514570dce134" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 3 AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "homefeatured" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 29) AND (b.`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`='ea4ac7d8ffe22eed3c1918833e6add7f' AND cache_id="blockspecials-home|20231003|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 44) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('bf872834a1b82a1073630ccb1b79c089',"blocksearch-top|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a4718b48c2e16bb03aa85c4d6934ae20',"blocksocial|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 25 AND `id_shop` = 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "6bacccff288551a89148d709123d84adc71a1c76" LIMIT 1

SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2444 AND `id_group` = 1 LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "df6bce4269b27f3137a6a8a108ccd520b20a6b50" AND (cache_id  = "blockspecials-home|20231003|1|1|1|1|21" OR cache_id LIKE "blockspecials-home|20231003|1|1|1|1|21|%")

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 22 AND `id_shop` = 1

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockbestsellers" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('a4718b48c2e16bb03aa85c4d6934ae20',"blocksocial|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

DELETE FROM ps_smarty_cache WHERE name = "a6162412c5a51a2bb8fe401eceb95b1f8a0ff92d" AND (cache_id  = "blockcms|2|1|1|1|1|21" OR cache_id LIKE "blockcms|2|1|1|1|1|21|%")

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 21) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 6 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 3) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4) LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "b2f246c278bab0c1f3db9afaf6ae514570dce134" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 4 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1

SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) LIMIT 1

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

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('0bab1e6e041c3b5a15e617604aa18125',"blocktopmenu|1|1|1|1|21|index","", FROM_UNIXTIME(1696305278))

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1

DELETE FROM ps_smarty_cache WHERE name = "eaa8cd5c0a0ec249e25b91455e5d70962eeb2904" AND (cache_id  = "blockmyaccountfooter|1|1|1|1|21" OR cache_id LIKE "blockmyaccountfooter|1|1|1|1|21|%")

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 39 AND `id_shop` = 1

DELETE FROM ps_smarty_cache WHERE name = "387de21e5439c83ea6bf42eec919c88d9b8f12d8" AND (cache_id  = "blocksearch-top|1|1|1|1|21" OR cache_id LIKE "blocksearch-top|1|1|1|1|21|%")

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 26) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 21 AND `id_shop` = 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 22) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea4ac7d8ffe22eed3c1918833e6add7f',"blockspecials-home|20231003|1|1|1|1|21","", FROM_UNIXTIME(1696305278))

DELETE FROM ps_smarty_cache WHERE name = "7f744c27484483611a3559db290cbbf0450411bc" AND (cache_id  = "blockcontactinfos|1|1|1|1|21" OR cache_id LIKE "blockcontactinfos|1|1|1|1|21|%")

SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 4
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 27) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "ed3f49f36426b7366419ddd466f0d83f9a3eee2d" LIMIT 1

SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 3
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1

SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'home' AND hm.`id_module` = 19 LIMIT 1

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b7e6ac8b8076306a234c3cc631a55820' AND cache_id="homeslider|1|1|1|1|21" 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`='be0c13c6e0793a48a9428094d686fa7d' AND cache_id="blockcms|2|1|1|1|1|21" AND compile_id="" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1

SELECT SQL_NO_CACHE cl.`meta_title`, cl.`link_rewrite`
FROM `ps_cms_lang` cl
INNER JOIN `ps_cms` c
ON (cl.`id_cms` = c.`id_cms`)
WHERE cl.`id_cms` = 5
AND (c.`active` = 1 OR c.`id_cms` = 1) AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 45 AND `id_shop` = 1

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "7367aa9e584a857fb167a7a3461946de83ce8a6d" LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('7415787b38e7988dc3424c280737b40f',"blockcategories|1|1|1|1|21|1","", FROM_UNIXTIME(1696305279))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('1b89cc03aedd32075b5a23580bbff353',"blockcmsinfo|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 45) LIMIT 1

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('bf872834a1b82a1073630ccb1b79c089',"blocksearch-top|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('549b2475696f2ea787f78ee810388313',"blockcontactinfos|1|1|1|1|21","", FROM_UNIXTIME(1696305279))

SELECT SQL_NO_CACHE modified FROM ps_smarty_cache WHERE id_smarty_cache = "fd77e71ae35753dc5ce2e222804f7a60869474a2" LIMIT 1

SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 39) LIMIT 1