Après-shampoing bio

Il y a 31 produits.

Prix, décroissant Prix, croissant Pertinence Nom, Z à A Nom, A à Z Meilleures ventes en premier
Affichage 1-12 de 31 article(s)
Retour en haut
Load Time 732.712 ms
Querying Time 414 ms
Queries 1596
Memory Peak Usage 94.4 Mb
Included Files 1285 files - 17.94 Mb
PrestaShop Cache - Mb
Global vars 1.21 Mb
PrestaShop Version 8.2.0
PHP Version 8.1.31
MySQL Version 10.6.18-MariaDB-0ubuntu0.22.04.1
Memory Limit 1024M
Max Execution Time 0s
Smarty Cache disabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 12.868 ms 12.868 ms 6.25 Mb 6.6 Mb
__construct 0.008 ms 12.876 ms - Mb 6.6 Mb
init 12.844 ms 25.720 ms 3.69 Mb 11.2 Mb
checkAccess 0.001 ms 25.721 ms - Mb 11.2 Mb
setMedia 5.412 ms 31.133 ms 1.93 Mb 12.0 Mb
postProcess 0.000 ms 31.133 ms - Mb 12.0 Mb
initHeader 0.001 ms 31.134 ms - Mb 12.0 Mb
initContent 128.548 ms 159.682 ms 21.45 Mb 33.4 Mb
initFooter 0.001 ms 159.683 ms - Mb 33.4 Mb
display 573.029 ms 732.712 ms 60.37 Mb 94.4 Mb
Hook Time Memory Usage
DisplayMegaMenu 421.157 ms 50.86 Mb
DisplayBlock 334.514 ms 44.47 Mb
DisplayLeftColumn 42.210 ms 1.95 Mb
DisplayHeader 29.625 ms 5.70 Mb
ActionProductFlagsModifier 22.373 ms 0.45 Mb
ActionOutputHTMLBefore 19.125 ms 0.03 Mb
DisplayAfterTitleTag 11.456 ms 1.91 Mb
ActionDispatcherBefore 7.258 ms 0.66 Mb
displayNav2 7.142 ms 0.39 Mb
DisplayBeforeBodyClosingTag 5.399 ms 0.76 Mb
displayFooter 4.041 ms 0.67 Mb
ActionFrontControllerSetMedia 2.435 ms 0.92 Mb
DisplayFooterCategory 1.852 ms 0.12 Mb
ProductSearchProvider 1.471 ms 0.50 Mb
ActionObjectAddAfter 1.137 ms 0.33 Mb
DisplayFooter 0.883 ms 0.04 Mb
displayFooterAfter 0.859 ms 0.12 Mb
DisplayNav1 0.657 ms 0.05 Mb
displayNav1 0.608 ms 0.06 Mb
DisplayAxeptioWidget 0.462 ms 0.14 Mb
DisplayBanner 0.313 ms 0.02 Mb
DisplayProductPriceBlock 0.229 ms 0.04 Mb
DisplayCustomMenu 0.172 ms 0.04 Mb
DisplayWrapperTop 0.162 ms 0.02 Mb
DisplayAfterBodyOpeningTag 0.097 ms 0.02 Mb
ModuleRoutes 0.040 ms 0.03 Mb
DisplayFooterBefore 0.003 ms - Mb
ActionFrontControllerInitAfter 0.002 ms - Mb
28 hook(s) 916 ms 110.30 Mb
Module Time Memory Usage
ps_checkout 4.993 ms 2.57 Mb
klaviyopsautomation 0.387 ms 0.03 Mb
pm_advancedsearch4 48.370 ms 3.61 Mb
ybc_blog 8.093 ms 0.68 Mb
psxdesign 0.726 ms 0.10 Mb
ps_eventbus 6.754 ms 0.62 Mb
ps_accounts 0.513 ms - Mb
ps_mbo 2.013 ms 0.04 Mb
axeptiocookies 1.310 ms 0.21 Mb
blockreassurance 1.008 ms 0.37 Mb
ps_emailsubscription 1.114 ms 0.31 Mb
ps_socialfollow 0.707 ms 0.15 Mb
ps_emailalerts 0.813 ms 0.28 Mb
ps_facebook 4.777 ms 1.36 Mb
ps_shoppingcart 0.471 ms 0.09 Mb
ps_imageslider 0.683 ms 0.23 Mb
psxmarketingwithgoogle 0.944 ms 0.29 Mb
ps_googleanalytics 1.489 ms 0.19 Mb
ets_htmlbox 4.113 ms 0.44 Mb
pm_advancedtopmenu 4.990 ms 1.68 Mb
ets_megamenu 762.504 ms 97.82 Mb
ps_searchbar 0.094 ms 0.03 Mb
ps_customersignin 0.240 ms 0.04 Mb
everblock 45.548 ms 1.91 Mb
ajaxhovercart 5.625 ms 0.20 Mb
netreviews 4.561 ms 1.28 Mb
cdc_googletagmanager 13.404 ms 2.56 Mb
ambjolisearch 5.040 ms 0.38 Mb
gmerchantcenterpro 16.866 ms 2.11 Mb
seoexpert 1.992 ms 0.41 Mb
shopimind 5.279 ms 1.72 Mb
sendcloud 0.936 ms 0.27 Mb
pwfavorites 0.594 ms 0.12 Mb
ps_facetedsearch 1.296 ms 0.41 Mb
ps_languageselector 0.412 ms 0.07 Mb
ps_currencyselector 0.591 ms 0.09 Mb
ps_contactinfo 1.161 ms 0.15 Mb
ps_linklist 3.965 ms 0.77 Mb
zendesk 1.262 ms 0.26 Mb
statsdata 4.158 ms 0.74 Mb
40 module(s) 970 ms 124.55 Mb

Stopwatch SQL - 1596 queries

# Query Time (ms) Rows Filesort Group By Location
248 
SELECT SQL_NO_CACHE p.*, product_shop.*, image_shop.`id_image` id_image,
stock.`out_of_stock`, IFNULL( stock.`quantity`, 0 ) AS quantity
FROM (
SELECT product_shop.*, IFNULL(product_attribute_shop.`id_product_attribute`, 0) AS id_product_attribute,
product_attribute_shop.`minimal_quantity` AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-12-06 00:00:00",
INTERVAL 60 DAY)) > 0 AS new,
(product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice
FROM `ps_category_product` cp
STRAIGHT_JOIN ps_product_shop product_shop
ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (product_shop.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.`id_shop`=1)
LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category`
AND c.`nleft` >= 167 AND c.`nright` <= 168)
LEFT JOIN `ps_product_lang` pl
ON (product_shop.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_product_sale` p_sale ON (p_sale.`id_product` = product_shop.`id_product`) 
WHERE c.`id_category` > 0 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product` ORDER BY p_sale.`quantity` DESC
LIMIT 0,12) AS `product_shop`
LEFT JOIN `ps_product` p ON (p.`id_product` = product_shop.`id_product`)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = product_shop.`id_product` AND image_shop.`cover`=1 AND image_shop.`id_shop`=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `product_shop`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
 4.120 ms 60024 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1535 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa14 ON (pa14.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa14.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 14
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 3.394 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1539 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (11,33,41,47,49,51,53,59,61,63,67,69,73,75,77,79,83,85,87,89,93,95,101,103,105,107,109,111,117,119,121,123,125,135,143,145,149,153,167,171,183,185,189,195,197,199,201,203,205,213,215,223,225,227,229,231,237,241,243,245,247,249,251,255,257,259,261,269,271,273,275,277,279,283,285,289,291,297,303,307,309,311,313,315,317,319,321,323,325,331,333,337,339,341,349,351,353,355,361,363,365,367,369,373,383,385,387,389,391,393,397,399,405,409,411,417,419,421,423,425,427,429,441,443,453,455,457,463,471,473,475,483,487,489,493,497,501,503,505,507,511,515,523,525,527,531,537,539,541,543,545,549,553,559,561,563,569,571,573,577,583,585,587,595,599,601,605,617,623,625,629,631,633,637,641,643,645,649,651,653,657,659,663,665,667,669,671,673,675,679,683,687,691,695,701,703,705,711,713,715,717,721,723,729,731,735,737,741,745,747,751,759,761,765,769,773,779,783,785,789,791,801,803,805,807,809,811,813,815,817,819,821,823,825,827,829,831,837,839,841,845,847,849,851,857,861,863,865,867,869,871,879,881,885,889,893,895,897,901,903,905,907,909,911,913,915,917,919,921,923,925,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa5 ON (pa5.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa5.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (11,33,41,47,49,51,53,59,61,63,67,69,73,75,77,79,83,85,87,89,93,95,101,103,105,107,109,111,117,119,121,123,125,135,143,145,149,153,167,171,183,185,189,195,197,199,201,203,205,213,215,223,225,227,229,231,237,241,243,245,247,249,251,255,257,259,261,269,271,273,275,277,279,283,285,289,291,297,303,307,309,311,313,315,317,319,321,323,325,331,333,337,339,341,349,351,353,355,361,363,365,367,369,373,383,385,387,389,391,393,397,399,405,409,411,417,419,421,423,425,427,429,441,443,453,455,457,463,471,473,475,483,487,489,493,497,501,503,505,507,511,515,523,525,527,531,537,539,541,543,545,549,553,559,561,563,569,571,573,577,583,585,587,595,599,601,605,617,623,625,629,631,633,637,641,643,645,649,651,653,657,659,663,665,667,669,671,673,675,679,683,687,691,695,701,703,705,711,713,715,717,721,723,729,731,735,737,741,745,747,751,759,761,765,769,773,779,783,785,789,791,801,803,805,807,809,811,813,815,817,819,821,823,825,827,829,831,837,839,841,845,847,849,851,857,861,863,865,867,869,871,879,881,885,889,893,895,897,901,903,905,907,909,911,913,915,917,919,921,923,925,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 5
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 3.316 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1527 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa11 ON (pa11.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa11.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 11
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 2.663 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1515 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (2712,2713,2714,2715,2716)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa12 ON (pa12.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa12.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (2712,2713,2714,2715,2716)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 12
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 2.555 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1543 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa10 ON (pa10.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa10.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 10
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 2.221 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1549 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 9081) AND (id_shop = 1)
ORDER BY id_flag
 2.030 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1558 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 10481) AND (id_shop = 1)
ORDER BY id_flag
 1.874 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1557 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 8572) AND (id_shop = 1)
ORDER BY id_flag
 1.865 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1555 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 8181) AND (id_shop = 1)
ORDER BY id_flag
 1.862 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1556 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 9299) AND (id_shop = 1)
ORDER BY id_flag
 1.860 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1554 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 8983) AND (id_shop = 1)
ORDER BY id_flag
 1.850 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1553 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 7204) AND (id_shop = 1)
ORDER BY id_flag
 1.847 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1552 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 6314) AND (id_shop = 1)
ORDER BY id_flag
 1.846 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
2 
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`)
 1.826 ms 1432 /classes/Configuration.php:180
1547 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 6772) AND (id_shop = 1)
ORDER BY id_flag
 1.781 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1518 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (16,21)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa7 ON (pa7.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa7.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (16,21)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 7
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 1.766 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1550 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 1839) AND (id_shop = 1)
ORDER BY id_flag
 1.761 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1551 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 4871) AND (id_shop = 1)
ORDER BY id_flag
 1.757 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1548 
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 7203) AND (id_shop = 1)
ORDER BY id_flag
 1.756 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1531 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (2717,2718,2719,2720,2721,2722,2723,2724,2725)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa13 ON (pa13.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa13.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (2717,2718,2719,2720,2721,2722,2723,2724,2725)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 13
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 1.698 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1524 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (2587,2588,2589,2590,2591,2593,2594,2595)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa9 ON (pa9.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa9.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (2587,2588,2589,2590,2591,2593,2594,2595)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 9
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 1.635 ms 864 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
258 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.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
 1.516 ms 646 /classes/Hook.php:456
14 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
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_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` != "paymentOptions") 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`
 1.509 ms 276 Yes Yes /classes/Hook.php:1267
1538 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 5
AND ac.`visible` = 1 LIMIT 1
 1.384 ms 422 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
235 
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
 1.257 ms 0 /classes/Hook.php:1326
1560 
SELECT SQL_NO_CACHE p.*,pc.id_category, pl.image,pl.thumb, pl.title, pl.description, pl.short_description, pl.meta_keywords, pl.meta_description,pl.url_alias,e.firstname, e.lastname,pc.position,count(pcm.id_comment) as total_comment,IFNULL(ybe.status,1) as status
FROM `ps_ybc_blog_post` p
INNER JOIN `ps_ybc_blog_post_shop` ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN `ps_ybc_blog_post_lang` pl ON p.id_post = pl.id_post AND pl.id_lang = 1
LEFT JOIN `ps_ybc_blog_post_category` pc ON (p.id_post = pc.id_post ) 
LEFT JOIN `ps_ybc_blog_post_related_categories` rpc ON (p.id_post = rpc.id_post)
LEFT JOIN `ps_customer` c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN `ps_employee` e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN `ps_ybc_blog_employee` ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN `ps_ybc_blog_comment` pcm on (pcm.id_post=p.id_post)
WHERE 1  AND p.enabled=1 AND rpc.id_category=326  
GROUP BY p.id_post
ORDER BY p.datetime_added DESC,  p.id_post DESC  LIMIT 0, 6
 1.206 ms 1 Yes /modules/ybc_blog/classes/ybc_blog_post_class.php:259
1537 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 5
AND ac.`visible` = 1 LIMIT 1
 1.090 ms 422 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1534 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 14
AND ac.`visible` = 1 LIMIT 1
 0.930 ms 106 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
102 
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM `ps_ybc_blog_post` p
INNER JOIN `ps_ybc_blog_post_shop` ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN `ps_ybc_blog_post_lang` pl ON p.id_post = pl.id_post
LEFT JOIN `ps_ybc_blog_post_category` pc ON p.id_post = pc.id_post
LEFT JOIN `ps_customer` c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN `ps_employee` e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN `ps_ybc_blog_employee` ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN `ps_ybc_blog_comment` pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 1 AND pc.id_category="1" AND p.enabled=1
 0.870 ms 9 /modules/ybc_blog/classes/ybc_blog_post_class.php:551
1545 
SELECT SQL_NO_CACHE COUNT(DISTINCT acp.`id_product`) as total
FROM `ps_pm_advancedsearch_cache_product_1` acp
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_tax_rule` tr ON (ps.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 8 AND tr.`id_state` = 0)
LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `ps_group_reduction` grc ON (grc.`id_group`=1 AND ps.`id_category_default` = grc.`id_category`)
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1))) LIMIT 1
 0.844 ms 96 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:69
1533 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 14
AND ac.`visible` = 1 LIMIT 1
 0.798 ms 106 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
247 
SELECT SQL_NO_CACHE COUNT(DISTINCT cp.`id_product`) AS total
FROM `ps_category_product` cp
STRAIGHT_JOIN ps_product_shop product_shop
ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category` c ON (
c.`id_category` = cp.`id_category`
AND c.`nleft` >= 167
AND c.`nright` <= 168
)
WHERE c.`id_category` > 0  AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
 0.777 ms 5002 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
195 
SELECT SQL_NO_CACHE *
FROM `ps_gmcp_feeds` ff
WHERE (ff.id_shop=1)
ORDER BY ff.feed_is_default ASC
 0.735 ms 370 Yes /modules/gmerchantcenterpro/models/Feeds.php:62
1542 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 10
AND ac.`visible` = 1 LIMIT 1
 0.708 ms 55 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1526 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 11
AND ac.`visible` = 1 LIMIT 1
 0.703 ms 50 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
386 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-06 00:00:00',
INTERVAL 60 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (6772,7203,9081,1839,4871,6314,7204,8983,8181,9299,8572,10481)
 0.662 ms 12 /classes/ProductAssembler.php:95
1525 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 11
AND ac.`visible` = 1 LIMIT 1
 0.648 ms 50 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1592 
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (6772,7203,9081,1839,4871,6314,7204,8983,8181,9299,8572,10481) AND cl.`id_lang` = 1
ORDER BY c.`level_depth` DESC
 0.641 ms 97 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
1513 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 12
AND ac.`visible` = 1 LIMIT 1
 0.635 ms 4 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1185 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=9 
ORDER BY b.sort_order asc,bl.title asc
 0.630 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1521 
SELECT SQL_NO_CACHE ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc3.`id_cache_product`)) AS nb_product
FROM `ps_pm_advancedsearch_criterion_1` ac
LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (
ac.`id_criterion` = acpc.`id_criterion`
AND ac.`id_criterion` IN (17)
)
LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`)
JOIN `ps_product_shop` ps ON (
ps.id_shop IN (1)
AND ps.`id_product` = acp.`id_product`
)
JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc3 ON ( acp.`id_cache_product` = acpc3.`id_cache_product` AND acpc3.`id_criterion` IN (1380))
LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0  AND sa1.id_shop = 1  AND sa1.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` pa8 ON (pa8.`id_product` = acp.`id_product` )
LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa8.`id_product_attribute`, 0)  AND sa2.id_shop = 1  AND sa2.id_shop_group = 0 )
STRAIGHT_JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (
aclink.`id_criterion` = ac.`id_criterion`
AND aclink.`id_criterion` IN (17)
) WHERE ps.`active` = 1
AND ps.`visibility` IN ("both", "catalog")
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` = ps.`id_product`
)
AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 0 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 0 = 1, sa2.`out_of_stock` = 1)))
AND ac.`id_criterion_group` = 8
AND ac.`visible` = 1 GROUP BY ac.`id_criterion`
ORDER BY `position` ASC
 0.627 ms 6 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1541 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 10
AND ac.`visible` = 1 LIMIT 1
 0.620 ms 55 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
469 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=6 
ORDER BY b.sort_order asc,bl.title asc
 0.601 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1514 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 12
AND ac.`visible` = 1 LIMIT 1
 0.595 ms 4 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
106 
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM `ps_ybc_blog_post` p
INNER JOIN `ps_ybc_blog_post_shop` ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN `ps_ybc_blog_post_lang` pl ON p.id_post = pl.id_post
LEFT JOIN `ps_ybc_blog_post_category` pc ON p.id_post = pc.id_post
LEFT JOIN `ps_customer` c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN `ps_employee` e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN `ps_ybc_blog_employee` ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN `ps_ybc_blog_comment` pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 1 AND pc.id_category="1" AND p.enabled=1
 0.581 ms 9 /modules/ybc_blog/classes/ybc_blog_post_class.php:551
1530 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 13
AND ac.`visible` = 1 LIMIT 1
 0.571 ms 8 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1529 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 13
AND ac.`visible` = 1 LIMIT 1
 0.561 ms 8 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
13 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 0.548 ms 1121 /classes/Hook.php:1366
1523 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclink.`id_criterion`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`)
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 9
AND ac.`visible` = 1 LIMIT 1
 0.547 ms 7 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1522 
SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT aclist.`id_criterion_parent`) AS `concatened_id_criterion_list`
FROM `ps_pm_advancedsearch_criterion_1` ac
JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`)
WHERE ac.`id_criterion_group` = 9
AND ac.`visible` = 1 LIMIT 1
 0.541 ms 7 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1590 
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('1203388', '', 'www.webecologie.com/326-apres-shampoing-bio', '', '2024-12-06 10:43:25')
 0.539 ms 1 /classes/ObjectModel.php:622
152 
SHOW TABLES LIKE "ps_gmcp_1800"
 0.537 ms 1 /modules/gmerchantcenterpro/lib/moduleUpdate.php:88
511 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=6 
ORDER BY b.sort_order asc,bl.title asc
 0.525 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
485 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=21 
ORDER BY b.sort_order asc,bl.title asc
 0.515 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
61 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
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 `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 326
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.509 ms 1 Yes Yes /classes/Category.php:924
159 
SHOW TABLES LIKE "ps_gmcp_1900"
 0.508 ms 1 /modules/gmerchantcenterpro/lib/moduleUpdate.php:88
1245 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=22 
ORDER BY b.sort_order asc,bl.title asc
 0.505 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1436 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(981,982,983,984,985,986,987,988,989,990,991,992,1013,1014)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.504 ms 14 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
1249 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=27 
ORDER BY b.sort_order asc,bl.title asc
 0.504 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
537 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=24 
ORDER BY b.sort_order asc,bl.title asc
 0.500 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
544 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=31 
ORDER BY b.sort_order asc,bl.title asc
 0.478 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
231 
SELECT SQL_NO_CACHE COUNT(1)
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = "webecologie"
AND TABLE_NAME = "ps_tab"
AND COLUMN_NAME = "hide_host_mode" LIMIT 1
 0.476 ms 0 /modules/seoexpert/seoexpert.php:391
1248 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=24 
ORDER BY b.sort_order asc,bl.title asc
 0.474 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1181 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=2 
ORDER BY b.sort_order asc,bl.title asc
 0.467 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
467 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=2 
ORDER BY b.sort_order asc,bl.title asc
 0.465 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
552 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=33 
ORDER BY b.sort_order asc,bl.title asc
 0.463 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
983 
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_shop` cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN `ps_category_lang` cl ON c.id_category=cl.id_category AND cl.id_lang=1
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` 
WHERE c.active=1 
AND  c.id_category IN(972,973,974,975,976,977,978,979)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
 0.462 ms 8 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
512 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=7 
ORDER BY b.sort_order asc,bl.title asc
 0.459 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
520 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=3 
ORDER BY b.sort_order asc,bl.title asc
 0.458 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
480 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=18 
ORDER BY b.sort_order asc,bl.title asc
 0.457 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1243 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=20 
ORDER BY b.sort_order asc,bl.title asc
 0.455 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
528 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=17 
ORDER BY b.sort_order asc,bl.title asc
 0.455 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
561 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=40 
ORDER BY b.sort_order asc,bl.title asc
 0.451 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
501 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=37 
ORDER BY b.sort_order asc,bl.title asc
 0.450 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
568 
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link,bl.image
FROM `ps_ets_mm_block` b
LEFT JOIN `ps_ets_mm_block_lang` bl
ON b.id_block=bl.id_block AND bl.id_lang=1
WHERE 1  AND b.id_column=46 
ORDER BY b.sort_order asc,bl.title asc
 0.448 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615