Il y a 94 produits.

Affichage 1-12 de 94 article(s)
Load Time 786.984 ms
Querying Time 469 ms
Queries 1650
Memory Peak Usage 95.7 Mb
Included Files 1287 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 11.071 ms 11.071 ms 6.25 Mb 6.6 Mb
__construct 0.007 ms 11.078 ms - Mb 6.6 Mb
init 14.116 ms 25.194 ms 3.75 Mb 11.2 Mb
setMedia 5.318 ms 30.512 ms 1.93 Mb 12.1 Mb
postProcess 0.001 ms 30.513 ms - Mb 12.1 Mb
initHeader 0.000 ms 30.513 ms - Mb 12.1 Mb
initContent 146.246 ms 176.759 ms 21.63 Mb 33.6 Mb
initFooter 0.001 ms 176.760 ms - Mb 33.6 Mb
display 610.224 ms 786.984 ms 61.35 Mb 95.7 Mb
Hook Time Memory Usage
DisplayMegaMenu 425.755 ms 50.71 Mb
DisplayBlock 336.504 ms 44.34 Mb
DisplayLeftColumn 67.429 ms 2.00 Mb
DisplayHeader 32.296 ms 5.69 Mb
ActionProductFlagsModifier 23.523 ms 0.65 Mb
ActionOutputHTMLBefore 19.263 ms 0.03 Mb
DisplayAfterTitleTag 17.266 ms 2.83 Mb
displayNav2 7.065 ms 0.39 Mb
ActionDispatcherBefore 5.892 ms 0.66 Mb
DisplayBeforeBodyClosingTag 5.551 ms 0.76 Mb
displayFooter 4.035 ms 0.68 Mb
ActionFrontControllerSetMedia 2.401 ms 0.92 Mb
ProductSearchProvider 1.686 ms 0.50 Mb
DisplayFooterCategory 1.367 ms 0.12 Mb
ActionObjectAddAfter 1.092 ms 0.33 Mb
displayFooterAfter 0.885 ms 0.12 Mb
DisplayFooter 0.884 ms 0.04 Mb
DisplayNav1 0.648 ms 0.05 Mb
displayNav1 0.576 ms 0.06 Mb
DisplayAxeptioWidget 0.462 ms 0.14 Mb
DisplayBanner 0.333 ms 0.02 Mb
DisplayProductPriceBlock 0.230 ms 0.04 Mb
DisplayCustomMenu 0.164 ms 0.04 Mb
DisplayWrapperTop 0.163 ms 0.02 Mb
DisplayAfterBodyOpeningTag 0.097 ms 0.02 Mb
ModuleRoutes 0.036 ms 0.03 Mb
DisplayFooterBefore 0.004 ms - Mb
ActionFrontControllerInitAfter 0.002 ms - Mb
28 hook(s) 956 ms 111.19 Mb
Module Time Memory Usage
ps_checkout 4.948 ms 2.57 Mb
klaviyopsautomation 0.405 ms 0.03 Mb
pm_advancedsearch4 74.866 ms 3.66 Mb
ybc_blog 8.382 ms 0.68 Mb
psxdesign 0.730 ms 0.10 Mb
ps_eventbus 5.467 ms 0.62 Mb
ps_accounts 0.505 ms - Mb
ps_mbo 1.559 ms 0.04 Mb
axeptiocookies 1.289 ms 0.21 Mb
blockreassurance 1.005 ms 0.37 Mb
ps_emailsubscription 1.134 ms 0.31 Mb
ps_socialfollow 0.711 ms 0.15 Mb
ps_emailalerts 0.799 ms 0.28 Mb
ps_facebook 4.693 ms 1.36 Mb
ps_shoppingcart 0.470 ms 0.09 Mb
ps_imageslider 0.673 ms 0.23 Mb
psxmarketingwithgoogle 0.898 ms 0.29 Mb
ps_googleanalytics 1.655 ms 0.19 Mb
ets_htmlbox 4.216 ms 0.44 Mb
pm_advancedtopmenu 4.980 ms 1.68 Mb
ets_megamenu 769.053 ms 97.53 Mb
ps_searchbar 0.094 ms 0.03 Mb
ps_customersignin 0.234 ms 0.04 Mb
everblock 47.088 ms 2.11 Mb
ajaxhovercart 5.557 ms 0.20 Mb
netreviews 5.131 ms 1.28 Mb
cdc_googletagmanager 19.186 ms 3.48 Mb
ambjolisearch 5.255 ms 0.38 Mb
gmerchantcenterpro 17.405 ms 2.12 Mb
seoexpert 2.031 ms 0.41 Mb
shopimind 5.560 ms 1.72 Mb
sendcloud 1.076 ms 0.27 Mb
pwfavorites 0.653 ms 0.12 Mb
ps_facetedsearch 1.482 ms 0.41 Mb
ps_languageselector 0.415 ms 0.07 Mb
ps_currencyselector 0.599 ms 0.09 Mb
ps_contactinfo 1.218 ms 0.15 Mb
ps_linklist 4.001 ms 0.78 Mb
zendesk 1.326 ms 0.26 Mb
statsdata 4.134 ms 0.73 Mb
40 module(s) 1011 ms 125.45 Mb

Stopwatch SQL - 1650 queries

# Query Time (ms) Rows Filesort Group By Location
1576
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 (1278))
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
18.814 ms 8613 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
254
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` >= 234 AND c.`nright` <= 247)
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  )
8.058 ms 464820 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1588
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 (1278))
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
5.718 ms 2889 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1584
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 (1278))
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
4.379 ms 2889 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1592
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 (1278))
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
3.863 ms 8613 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1564
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 (1278))
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
3.703 ms 2889 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1580
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 (1278))
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
3.044 ms 2889 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1573
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 (1278))
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
2.530 ms 2889 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1594
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 (1278))
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
2.305 ms 321 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:69
1596
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 1807) AND (id_shop = 1)
ORDER BY id_flag
1.927 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1602
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 12336) AND (id_shop = 1)
ORDER BY id_flag
1.914 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1600
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 5418) AND (id_shop = 1)
ORDER BY id_flag
1.912 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1601
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 1816) AND (id_shop = 1)
ORDER BY id_flag
1.911 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1599
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 9324) AND (id_shop = 1)
ORDER BY id_flag
1.905 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1598
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 9497) AND (id_shop = 1)
ORDER BY id_flag
1.903 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1597
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 9257) AND (id_shop = 1)
ORDER BY id_flag
1.893 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
264
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.792 ms 646 /classes/Hook.php:456
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.789 ms 1432 /classes/Configuration.php:180
1610
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 12559) AND (id_shop = 1)
ORDER BY id_flag
1.775 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1608
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 12801) AND (id_shop = 1)
ORDER BY id_flag
1.773 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1609
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 13701) AND (id_shop = 1)
ORDER BY id_flag
1.765 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1612
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 12811) AND (id_shop = 1)
ORDER BY id_flag
1.763 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1611
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 11998) AND (id_shop = 1)
ORDER BY id_flag
1.758 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
253
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` >= 234
AND c.`nright` <= 247
)
WHERE c.`id_category` > 0  AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.641 ms 38735 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
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.543 ms 276 Yes Yes /classes/Hook.php:1267
241
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.435 ms 0 /classes/Hook.php:1326
1587
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.367 ms 422 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1567
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 (1278))
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.239 ms 198 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1586
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.067 ms 422 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1230
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
1.004 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1583
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.872 ms 106 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
117
DESCRIBE ps_ybc_blog_post
0.831 ms 1 /modules/ybc_blog/ybc_blog_defines.php:3166
201
SELECT SQL_NO_CACHE *
FROM `ps_gmcp_feeds` ff
WHERE (ff.id_shop=1)
ORDER BY ff.feed_is_default ASC
0.804 ms 370 Yes /modules/gmerchantcenterpro/models/Feeds.php:62
1646
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 (1807,9257,9497,9324,5418,1816,12336,12801,13701,12559,11998,12811) AND cl.`id_lang` = 1
ORDER BY c.`level_depth` DESC
0.800 ms 137 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
1582
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.771 ms 106 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
410
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 (1807,9257,9497,9324,5418,1816,12336,12801,13701,12559,11998,12811)
0.724 ms 12 /classes/ProductAssembler.php:95
1591
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.706 ms 55 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1562
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.702 ms 4 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1575
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.692 ms 50 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
108
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.685 ms 9 /modules/ybc_blog/classes/ybc_blog_post_class.php:551
1614
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=1322  
GROUP BY p.id_post
ORDER BY p.datetime_added DESC,  p.id_post DESC  LIMIT 0, 6
0.649 ms 1 Yes /modules/ybc_blog/classes/ybc_blog_post_class.php:259
1574
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.635 ms 50 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
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` = 1322
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.627 ms 6 Yes Yes /classes/Category.php:924
546
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=30 
ORDER BY b.sort_order asc,bl.title asc
0.621 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1590
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.621 ms 55 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
557
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=43 
ORDER BY b.sort_order asc,bl.title asc
0.620 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1563
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.620 ms 4 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
112
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.611 ms 9 /modules/ybc_blog/classes/ybc_blog_post_class.php:551
1570
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 (1278))
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.611 ms 6 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
598
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.601 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
525
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.594 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
158
SHOW TABLES LIKE "ps_gmcp_1800"
0.591 ms 1 /modules/gmerchantcenterpro/lib/moduleUpdate.php:88
1644
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('1203412', '', 'www.webecologie.com/1322-salle-de-bain-solide-zero-dechet', '', '2024-12-06 10:46:31')
0.591 ms 1 /classes/ObjectModel.php:622
1579
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.577 ms 8 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
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(591,937,600,955,954,616,683,609,613,617,586,1173,1172,596,597,598,653,942)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.568 ms 18 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
617
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=41 
ORDER BY b.sort_order asc,bl.title asc
0.564 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1578
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.559 ms 8 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
553
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=39 
ORDER BY b.sort_order asc,bl.title asc
0.555 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
599
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=30 
ORDER BY b.sort_order asc,bl.title asc
0.553 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
543
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=25 
ORDER BY b.sort_order asc,bl.title asc
0.550 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
538
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.545 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
547
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=29 
ORDER BY b.sort_order asc,bl.title asc
0.543 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1572
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.543 ms 7 /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.540 ms 1121 /classes/Hook.php:1366
965
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(629,624,1208,673,555,556,570,549,623,1123,632,633,970,647,648,1387)
AND cg.`id_group` IN (1)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.539 ms 16 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
554
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=38 
ORDER BY b.sort_order asc,bl.title asc
0.538 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
541
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.536 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1571
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.534 ms 7 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
620
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=44 
ORDER BY b.sort_order asc,bl.title asc
0.532 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
621
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=47 
ORDER BY b.sort_order asc,bl.title asc
0.529 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
622
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.522 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
600
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=29 
ORDER BY b.sort_order asc,bl.title asc
0.518 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
623
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=45 
ORDER BY b.sort_order asc,bl.title asc
0.513 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
548
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=32 
ORDER BY b.sort_order asc,bl.title asc
0.512 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615