Il y a 136 produits.

Affichage 1-12 de 136 article(s)

Thé Hao Ling

x90 Thés de la Pagode
32,94 €
Load Time 798.406 ms
Querying Time 450 ms
Queries 1608
Memory Peak Usage 94.5 Mb
Included Files 1286 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.633 ms 11.633 ms 6.25 Mb 6.6 Mb
__construct 0.007 ms 11.640 ms - Mb 6.6 Mb
init 15.347 ms 26.987 ms 3.74 Mb 11.2 Mb
checkAccess 0.001 ms 26.988 ms - Mb 11.2 Mb
setMedia 5.675 ms 32.663 ms 1.93 Mb 12.1 Mb
postProcess 0.001 ms 32.664 ms - Mb 12.1 Mb
initHeader 0.000 ms 32.664 ms - Mb 12.1 Mb
initContent 138.598 ms 171.262 ms 21.48 Mb 33.4 Mb
initFooter 0.001 ms 171.263 ms - Mb 33.4 Mb
display 627.143 ms 798.406 ms 60.38 Mb 94.5 Mb
Hook Time Memory Usage
DisplayMegaMenu 439.336 ms 50.76 Mb
DisplayBlock 348.180 ms 44.37 Mb
DisplayLeftColumn 74.448 ms 2.02 Mb
DisplayHeader 31.172 ms 5.70 Mb
ActionProductFlagsModifier 22.408 ms 0.45 Mb
ActionOutputHTMLBefore 19.337 ms 0.03 Mb
DisplayAfterTitleTag 12.961 ms 1.99 Mb
displayNav2 7.400 ms 0.39 Mb
ActionDispatcherBefore 6.120 ms 0.66 Mb
DisplayBeforeBodyClosingTag 5.578 ms 0.77 Mb
displayFooter 4.086 ms 0.67 Mb
ActionFrontControllerSetMedia 2.484 ms 0.92 Mb
ProductSearchProvider 1.583 ms 0.50 Mb
DisplayFooterCategory 1.372 ms 0.12 Mb
ActionObjectAddAfter 1.157 ms 0.33 Mb
displayFooterAfter 0.904 ms 0.12 Mb
DisplayFooter 0.892 ms 0.04 Mb
DisplayNav1 0.680 ms 0.05 Mb
displayNav1 0.637 ms 0.06 Mb
DisplayAxeptioWidget 0.500 ms 0.14 Mb
DisplayBanner 0.356 ms 0.02 Mb
DisplayProductPriceBlock 0.250 ms 0.04 Mb
DisplayCustomMenu 0.192 ms 0.04 Mb
DisplayWrapperTop 0.173 ms 0.02 Mb
DisplayAfterBodyOpeningTag 0.114 ms 0.02 Mb
ModuleRoutes 0.045 ms 0.03 Mb
DisplayFooterBefore 0.003 ms - Mb
ActionFrontControllerInitAfter 0.001 ms - Mb
28 hook(s) 982 ms 110.26 Mb
Module Time Memory Usage
ps_checkout 5.754 ms 2.57 Mb
klaviyopsautomation 0.458 ms 0.03 Mb
pm_advancedsearch4 81.089 ms 3.68 Mb
ybc_blog 7.351 ms 0.68 Mb
psxdesign 0.778 ms 0.10 Mb
ps_eventbus 5.747 ms 0.62 Mb
ps_accounts 0.570 ms - Mb
ps_mbo 1.496 ms 0.04 Mb
axeptiocookies 1.351 ms 0.21 Mb
blockreassurance 1.029 ms 0.37 Mb
ps_emailsubscription 1.176 ms 0.31 Mb
ps_socialfollow 0.732 ms 0.15 Mb
ps_emailalerts 0.917 ms 0.28 Mb
ps_facebook 5.238 ms 1.36 Mb
ps_shoppingcart 0.515 ms 0.09 Mb
ps_imageslider 0.798 ms 0.23 Mb
psxmarketingwithgoogle 1.000 ms 0.29 Mb
ps_googleanalytics 1.691 ms 0.19 Mb
ets_htmlbox 4.480 ms 0.44 Mb
pm_advancedtopmenu 5.741 ms 1.68 Mb
ets_megamenu 794.941 ms 97.62 Mb
ps_searchbar 0.106 ms 0.03 Mb
ps_customersignin 0.252 ms 0.04 Mb
everblock 46.260 ms 1.91 Mb
ajaxhovercart 5.707 ms 0.20 Mb
netreviews 4.775 ms 1.28 Mb
cdc_googletagmanager 15.113 ms 2.64 Mb
ambjolisearch 5.192 ms 0.38 Mb
gmerchantcenterpro 17.913 ms 2.11 Mb
seoexpert 2.082 ms 0.41 Mb
shopimind 6.139 ms 1.72 Mb
sendcloud 1.073 ms 0.27 Mb
pwfavorites 0.621 ms 0.12 Mb
ps_facetedsearch 1.392 ms 0.41 Mb
ps_languageselector 0.487 ms 0.07 Mb
ps_currencyselector 0.645 ms 0.09 Mb
ps_contactinfo 1.261 ms 0.15 Mb
ps_linklist 4.043 ms 0.77 Mb
zendesk 1.394 ms 0.26 Mb
statsdata 4.163 ms 0.74 Mb
40 module(s) 1041 ms 124.52 Mb

Stopwatch SQL - 1608 queries

# Query Time (ms) Rows Filesort Group By Location
1538
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 (1124))
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
19.802 ms 8613 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1550
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 (1124))
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
6.580 ms 3618 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
253
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` >= 1008 AND c.`nright` <= 1019)
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  )
6.046 ms 181536 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1554
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 (1124))
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
5.777 ms 8613 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1546
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 (1124))
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.854 ms 3618 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1525
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 (1124))
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
4.643 ms 3618 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1542
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 (1124))
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.722 ms 3618 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 (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 (1124))
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
3.202 ms 3618 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1557
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 (1124))
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.574 ms 402 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:69
1569
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 5506) AND (id_shop = 1)
ORDER BY id_flag
2.004 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1568
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 14496) AND (id_shop = 1)
ORDER BY id_flag
1.997 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
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.980 ms 276 Yes Yes /classes/Hook.php:1267
1570
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 9987) AND (id_shop = 1)
ORDER BY id_flag
1.931 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1559
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 8086) AND (id_shop = 1)
ORDER BY id_flag
1.828 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1561
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 5508) AND (id_shop = 1)
ORDER BY id_flag
1.804 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1560
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 3233) AND (id_shop = 1)
ORDER BY id_flag
1.797 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1562
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 6563) AND (id_shop = 1)
ORDER BY id_flag
1.797 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1565
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 5501) AND (id_shop = 1)
ORDER BY id_flag
1.795 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1564
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 6481) AND (id_shop = 1)
ORDER BY id_flag
1.792 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1566
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 5497) AND (id_shop = 1)
ORDER BY id_flag
1.791 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1563
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 4120) AND (id_shop = 1)
ORDER BY id_flag
1.789 ms 8865 Yes /modules/everblock/models/EverblockFlagsClass.php:121
1567
SELECT SQL_NO_CACHE id_everblock_flags
FROM `ps_everblock_flags`
WHERE (id_product = 5983) AND (id_shop = 1)
ORDER BY id_flag
1.789 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.652 ms 1432 /classes/Configuration.php:180
240
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.509 ms 0 /classes/Hook.php:1326
1549
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.375 ms 422 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
263
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.332 ms 646 /classes/Hook.php:456
252
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` >= 1008
AND c.`nright` <= 1019
)
WHERE c.`id_category` > 0  AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.241 ms 15128 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1529
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 (1124))
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.219 ms 198 Yes /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1548
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.094 ms 422 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1195
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.889 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1545
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.875 ms 106 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
197
SHOW COLUMNS FROM ps_gmcp_tags LIKE "custom_label_set_postion"
0.824 ms 1 /modules/gmerchantcenterpro/lib/moduleUpdate.php:128
1604
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 (8086,3233,5508,6563,4120,6481,5501,5497,5983,14496,5506,9987) AND cl.`id_lang` = 1
ORDER BY c.`level_depth` DESC
0.773 ms 124 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
1544
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.753 ms 106 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1227
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.720 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1553
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.713 ms 55 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
107
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.711 ms 9 /modules/ybc_blog/classes/ybc_blog_post_class.php:551
1537
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.696 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` = 714
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.689 ms 5 Yes Yes /classes/Category.php:924
200
SELECT SQL_NO_CACHE *
FROM `ps_gmcp_feeds` ff
WHERE (ff.id_shop=1)
ORDER BY ff.feed_is_default ASC
0.687 ms 370 Yes /modules/gmerchantcenterpro/models/Feeds.php:62
1572
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=714  
GROUP BY p.id_post
ORDER BY p.datetime_added DESC,  p.id_post DESC  LIMIT 0, 6
0.675 ms 1 Yes /modules/ybc_blog/classes/ybc_blog_post_class.php:259
1536
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.646 ms 50 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1253
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.641 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1532
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 (1124))
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.629 ms 6 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:67
1552
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.625 ms 55 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
157
SHOW TABLES LIKE "ps_gmcp_1800"
0.604 ms 1 /modules/gmerchantcenterpro/lib/moduleUpdate.php:88
483
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.599 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1239
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=11 
ORDER BY b.sort_order asc,bl.title asc
0.593 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1541
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.588 ms 8 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1523
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.570 ms 4 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
111
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.561 ms 9 /modules/ybc_blog/classes/ybc_blog_post_class.php:551
1191
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.560 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1205
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.559 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1540
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
1524
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.558 ms 4 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
395
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 (8086,3233,5508,6563,4120,6481,5501,5497,5983,14496,5506,9987)
0.558 ms 12 /classes/ProductAssembler.php:95
1601
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1558044', '444', '308349358', '', '1', '1', '2024-12-06 10:50:49')
0.554 ms 1 /classes/ObjectModel.php:622
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` = 9
AND ac.`visible` = 1 LIMIT 1
0.547 ms 7 /modules/pm_advancedsearch4/classes/SearchEngineDb.php:71
1216
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.544 ms 5 Yes /modules/ets_megamenu/classes/MM_Block.php:615
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
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` = 9
AND ac.`visible` = 1 LIMIT 1
0.538 ms 7 /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=47 
ORDER BY b.sort_order asc,bl.title asc
0.525 ms 3 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1211
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.508 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
164
SHOW TABLES LIKE "ps_gmcp_1900"
0.498 ms 1 /modules/gmerchantcenterpro/lib/moduleUpdate.php:88
1279
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.491 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
481
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.486 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1196
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=10 
ORDER BY b.sort_order asc,bl.title asc
0.486 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
558
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.484 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1208
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.484 ms 6 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1236
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.484 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1602
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('1203440', '', 'www.webecologie.com/714-the-bio', '', '2024-12-06 10:50:49')
0.483 ms 1 /classes/ObjectModel.php:622
998
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.480 ms 8 Yes Yes /modules/ets_megamenu/classes/Ets_megamenu_defines.php:176
1228
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.479 ms 2 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1193
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.474 ms 1 Yes /modules/ets_megamenu/classes/MM_Block.php:615
1220
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=34 
ORDER BY b.sort_order asc,bl.title asc
0.474 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=2 
ORDER BY b.sort_order asc,bl.title asc
0.474 ms 4 Yes /modules/ets_megamenu/classes/MM_Block.php:615