Fale conosco

Controle Remoto Receptor Azamerica S1009 - Paralelo

controle remoto
Pronta Entrega
R$ 24,90
  • 1x R$ 24,90
  • 2x R$ 12,75
  • 3x R$ 8,70
  • 4x R$ 6,67
  • 5x R$ 5,43
  • 6x R$ 4,59
  • 7x R$ 3,98
  • 8x R$ 3,50
  • 9x R$ 3,13
  • 10x R$ 2,85
  • 11x R$ 2,63
  • 12x R$ 2,44
R$ 21,17 à vista com 15% de desconto via Depósito Bancário ou boleto bancário.
2

Controle Remoto para Receptor Digital

Média das Avaliações
0 / 5
Nota : 0 / 5
com base em 0 análises de clientes.

Compatível com os modelos: 

Azamerica S1009

Características

O que nossos clientes dizem

Apenas usuários cadastrados podem postar um comentário. Logar ou criar uma conta .

Sem comentários neste momento.

Controle Remoto Receptor Azamerica S1009 - Paralelo (24.9 BRL)
Load Time3887 ms - You'd better run your shop on a toaster
Querying Time2678 ms
Queries1468
Memory Peak Usage50.3 Mb
Included Files673 files - 9.81 Mb
PrestaShop Cache- Mb
Global vars0.67 Mb
PrestaShop Version1.7.4.2
PHP Version7.0.33-29+0~20200514.36+debian9~1.gbp126f6f (Consider upgrading)
MySQL Version10.3.23-MariaDB-1:10.3.23+maria~stretch-log (OK)
Memory Limit1024M
Max Execution Time720s
Smarty Cachedisabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 127 ms 127 ms 4.65 Mb 4.90 Mb
__construct 9 ms 136 ms 0.08 Mb 4.90 Mb
init 278 ms 414 ms 3.31 Mb 8.29 Mb
checkAccess 0 ms 414 ms - Mb 8.29 Mb
setMedia 18 ms 431 ms 0.21 Mb 8.29 Mb
postProcess 0 ms 431 ms - Mb 8.29 Mb
initHeader 0 ms 431 ms - Mb 8.29 Mb
initContent 672 ms 1104 ms 7.00 Mb 15.33 Mb
initFooter 0 ms 1104 ms - Mb 15.33 Mb
display 2783 ms 3887 ms 34.67 Mb 50.28 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 1468 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE hc.`id`, hc.`id_shop`, s.`name` as shop_name, hc.id_customer,
CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1), '.') customer_name,
CONCAT(c.`firstname`, ' ', c.`lastname`) customer_fullname,
TIMESTAMPDIFF(YEAR,c.birthday,CURDATE()) customer_age,
hc.`pseudo`, hc.`title`, hc.`comment` as review, hc.`image_file` as customer_image, hc.`image_file_min` as customer_image_miniature, hc.`message` moderation_message, hc.`reason_of_refusal`, hc.`is_report_abuse`,
hc.`id_product`, hc.`rate`, hc.`date_add` review_date, hc.`status` review_status, hc.`moderated_date`, hc.`date_update`, 
hc.`discount`,
hc.id_order hc_id_order , o.`date_add` order_date, o.`reference` order_reference   , 0 as count_products_purchased    
FROM `ps_lineven_home_comments` hc 
LEFT JOIN `ps_shop` s ON (s.`id_shop` = hc.`id_shop`)
LEFT JOIN `ps_customer` c ON (c.`id_customer` = hc.`id_customer`)LEFT JOIN `ps_orders` o ON (o.`id_order` = hc.`id_order`) LEFT JOIN `ps_order_detail` od ON (hc.`id_order` = od.`id_order`  AND od.`product_id` = 395 )  WHERE  hc.`id_shop` = 1  AND  hc.`is_archived` = 0  AND  hc.`is_report_abuse` = 0  AND  hc.`status` = "VAL"  AND  ((hc.`id_order` is not null AND hc.`id_order` != 0 AND (hc.`id_product` is null OR hc.`id_product` = 0) AND od.`product_id` = 395) OR hc.`id_product` = 395) GROUP BY hc.`id` 
ORDER BY hc.`date_add` DESC  LIMIT 15
51.6 1118 Yes Yes /modules/homecomments/classes/review/Review.php:814
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `active` = 1 ORDER BY position
40.3 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (224, 225) AND il.`id_lang` = 2 ORDER by i.`position`
38.9 2 Yes /classes/Product.php:2434
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
37.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
29.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
29.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 358
ORDER BY `position`
27.8 7 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM `ps_ngpayment_simulator_payment_mode`
WHERE (active=1) AND (payment_mode=1)
ORDER BY position ASC
26.5 13 Yes /modules/ngpaymentsimulator/classes/PaymentMode.php:114
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
26 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE pa.`id_product_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 395
AND product_attribute_shop.default_on = 1 LIMIT 1
25.9 1 /classes/Product.php:3536
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2020-08-10 00:00:00" AND date_to <= "2020-08-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2020-08-10 00:00:00" AND date_from <= "2020-08-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2020-08-10 00:00:00" AND date_to > "2020-08-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
25.5 1 /classes/CartRule.php:335
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 242)
25 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
24.3 1 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
23 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_ngconfig`
WHERE (name="TmxxT2QvNGpWb1ZGM0xyNHo5UjJIQT09") AND (id_shop=1) LIMIT 1
22.6 10 /modules/ngcliente/classes/NeogestConfig.php:226
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
22.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2020-08-10 00:00:00",
INTERVAL 90 DAY
)
) > 0 AS new
FROM  `ps_product` p 
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (68,83,202,214,217,283,358,369,404,477,634,484,487,338,126) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
21.8 15 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
20.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
19.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
17.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 83 AND `id_group` = 1 LIMIT 1
17.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
15.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
14.8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 259
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
14.6 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
14.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
14.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 281 LIMIT 1
14.1 1 /classes/Product.php:832
SELECT SQL_NO_CACHE *
FROM `ps_ngpayment_simulator_fixed_interest_ratio`
WHERE (payment_mode_id=1) AND (number_of_payments=6) LIMIT 1
14 36 /modules/ngpaymentsimulator/classes/FixedInterestRatio.php:38
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
13.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "top" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
13.1 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 395 AND `id_shop` = 1
12.8 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2020-08-10 00:00:00",
INTERVAL 90 DAY
)
) > 0 AS new
FROM  `ps_product` p 
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (242,245,279,280,488,512,591,636,256,604) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
12.8 10 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
12.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 256 AND `id_group` = 1 LIMIT 1
12.4 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
12.3 1 /classes/ObjectModel.php:1548
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
12.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
11.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
11.4 1 /classes/Country.php:191
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
11.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 2
AND id_shop = 1 LIMIT 1
10.9 1 /classes/ObjectModel.php:1548
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
10.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 53
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 202 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 53
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 202 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
10.6 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 2) WHERE 1 = 1 AND `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position
10.4 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
10.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 395) LIMIT 1
10.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 395
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-08-10 00:00:00",
INTERVAL 90 DAY
)
) > 0
10.3 0 /classes/Product.php:1369
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
10.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
10.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 395
ORDER BY `position`
10.1 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
10 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
9.9 2 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
9.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
9.5 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
9.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
9.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
9.4 0 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 68) AND (id_product_attribute = 101) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
9.1 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 38
AND `active` = 1 LIMIT 1
9 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
8.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
8.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 47 LIMIT 1
8.6 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
8.5 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 235
ORDER BY f.position ASC
8.4 6 Yes /classes/Product.php:4860
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
8.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 395
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-08-10 00:00:00",
INTERVAL 90 DAY
)
) > 0
8.3 0 /classes/Product.php:1369
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
8.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
8.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE hc.`id`, hc.`id_shop`, s.`name` as shop_name, hc.id_customer,
CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1), '.') customer_name,
CONCAT(c.`firstname`, ' ', c.`lastname`) customer_fullname,
TIMESTAMPDIFF(YEAR,c.birthday,CURDATE()) customer_age,
hc.`pseudo`, hc.`title`, hc.`comment` as review, hc.`image_file` as customer_image, hc.`image_file_min` as customer_image_miniature, hc.`message` moderation_message, hc.`reason_of_refusal`, hc.`is_report_abuse`,
hc.`id_product`, hc.`rate`, hc.`date_add` review_date, hc.`status` review_status, hc.`moderated_date`, hc.`date_update`, 
hc.`discount`,
hc.id_order hc_id_order , o.`date_add` order_date, o.`reference` order_reference   , 0 as count_products_purchased    
FROM `ps_lineven_home_comments` hc 
LEFT JOIN `ps_shop` s ON (s.`id_shop` = hc.`id_shop`)
LEFT JOIN `ps_customer` c ON (c.`id_customer` = hc.`id_customer`)LEFT JOIN `ps_orders` o ON (o.`id_order` = hc.`id_order`) LEFT JOIN `ps_order_detail` od ON (hc.`id_order` = od.`id_order`  AND od.`product_id` = 395 )  WHERE  hc.`id_shop` = 1  AND  hc.`is_archived` = 0  AND  hc.`is_report_abuse` = 0  AND  hc.`status` = "VAL"  AND  ((hc.`id_order` is not null AND hc.`id_order` != 0 AND (hc.`id_product` is null OR hc.`id_product` = 0) AND od.`product_id` = 395) OR hc.`id_product` = 395) GROUP BY hc.`id` 
ORDER BY hc.`date_add` DESC  LIMIT 15
8.1 1118 Yes Yes /modules/homecomments/classes/review/Review.php:814
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 214) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.8 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 214 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 214 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
7.5 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 217 AND id_shop=1 LIMIT 1
7.4 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
7.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
7.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 487 LIMIT 1
7.2 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ngcorreios" LIMIT 1
7.1 1 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 143
7 1 /classes/Product.php:2416
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
7 1 /classes/module/Module.php:2066
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 10
AND `active` = 1 LIMIT 1
6.9 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
6.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayNav1" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
6.8 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ngsimuladorfrete" LIMIT 1
6.7 1 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 128) LIMIT 1
6.6 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 2 LIMIT 1
6.5 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 395) AND (b.`id_shop` = 1) LIMIT 1
6.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 78) LIMIT 1
6.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 484 AND id_shop=1 LIMIT 1
6.4 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 270
ORDER BY `position`
6.3 3 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 195) LIMIT 1
6.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 12 LIMIT 1
6.3 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 115 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
6.1 46 Yes Yes /classes/Category.php:747
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 484 AND `id_group` = 1 LIMIT 1
6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2020-08-10 00:00:00",
INTERVAL 90 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 395 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
6 1 Yes /classes/Product.php:3927
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
6 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
6 0 /src/Adapter/Module/ModuleDataProvider.php:169
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
5.9 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 256 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 256 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
5.9 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
5.7 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
5.6 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 404 LIMIT 1
5.6 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 634) AND (id_product_attribute = 378) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.6 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 484) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.6 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 634) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
5.5 2 /classes/Currency.php:657
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 15 LIMIT 1
5.4 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 68 LIMIT 1
5.4 2 /classes/Product.php:832
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) LIMIT 1
5.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.2 1 /classes/shop/Shop.php:573
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`)
5.1 2949 /classes/Configuration.php:157
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 369 LIMIT 1
5.1 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE COUNT(sc.`hc_id`) as count_reviews, SUM(sc.`hc_rate`) as sum_reviews,
MAX(sc.`hc_best`) as best_rating, MIN(sc.`hc_worst`) as worst_rating
FROM (
SELECT distinct hc.`id` as hc_id, hc.`rate` as hc_rate,
hc.`rate` hc_best, hc.`rate` as hc_worst
FROM `ps_lineven_home_comments` hc LEFT JOIN `ps_orders` o ON (o.`id_order` = hc.`id_order`) LEFT JOIN `ps_order_detail` od ON (hc.`id_order` = od.`id_order`  AND od.`product_id` = 395 )
WHERE hc.`status` = "VAL" AND hc.`is_report_abuse` = 0  AND hc.`id_shop` = 1  AND hc.`is_archived` = 0  AND ((hc.`id_order` is not null AND hc.`id_order` != 0  AND (hc.`id_product` is null OR hc.`id_product` = 0) AND od.`id_order_detail` is not null) OR hc.`id_product` = 395)
) as sc
5 1249924 /modules/homecomments/classes/review/Review.php:1094
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 395
ORDER BY `position`
5 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 280
ORDER BY `position`
4.9 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 634
AND pac.`id_product_attribute` = 378
AND agl.`id_lang` = 2
4.9 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
4.8 88 /classes/Hook.php:249
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
4.7 1 /classes/Group.php:150
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 202) LIMIT 1
4.7 1 /src/Adapter/EntityMapper.php:67
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, 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
4.7 496 /classes/Hook.php:374
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (126) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.6 2 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 131) LIMIT 1
4.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 206 AND `id_shop` = 1
4.4 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 68
4.3 2 /classes/Product.php:2416
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayNav2" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
4.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 52) LIMIT 1
4.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (68) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.2 2 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 358 LIMIT 1
4.2 2 /classes/Product.php:845
SELECT SQL_NO_CACHE *
FROM `ps_state` a
WHERE (a.`id_state` = 337) LIMIT 1
4.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.1 1 /classes/shop/Shop.php:573
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
4.1 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
4.1 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
4.1 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 17
AND `active` = 1 LIMIT 1
4 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
4 2 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayBanner" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
3.9 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
3.9 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
3.8 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 235) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 270) AND (b.`id_shop` = 1) LIMIT 1
3.8 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 636
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 2
3.8 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 94 LIMIT 1
3.8 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 404) AND (b.`id_shop` = 1) LIMIT 1
3.6 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
3.6 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 53 LIMIT 1
3.6 1 /classes/Combination.php:444
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 488 AND id_shop=1 LIMIT 1
3.6 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
3.6 109 /classes/module/Module.php:301
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 15 LIMIT 1
3.6 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
3.5 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 280) LIMIT 1
3.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 2 LIMIT 1
3.5 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.5 1 /classes/shop/Shop.php:573
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_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "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`
3.4 400 Yes Yes /classes/Hook.php:629
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
3.4 1 /classes/Category.php:1867
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 126 AND id_shop=1 LIMIT 1
3.4 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 22 LIMIT 1
3.4 1 /classes/Category.php:1321
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 45
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 217 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 45
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 217 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
3.4 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 280 LIMIT 1
3.4 1 /classes/Combination.php:444
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 219 LIMIT 1
3.4 1 /classes/Combination.php:444
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM ps_iqit_link_block cb
INNER JOIN ps_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 324
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
3.4 10 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 235)
3.3 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
3.3 0 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 16 LIMIT 1
3.3 1 /classes/Category.php:1321
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 202
ORDER BY `position`
3.3 3 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 239) LIMIT 1
3.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
3.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3.2 1 Yes /classes/Country.php:146
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 2) WHERE `id_hook` = "hookDisplayAfterBodyOpeningTag" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
3.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 58 LIMIT 1
3.2 1 /classes/AddressFormat.php:616
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 258 AND `id_group` = 1 LIMIT 1
3.2 0 /classes/GroupReduction.php:149
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2020-08-10 00:00:00" AND date_to <= "2020-08-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2020-08-10 00:00:00" AND date_from <= "2020-08-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2020-08-10 00:00:00" AND date_to > "2020-08-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
3.1 1 /classes/CartRule.php:335
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 219) LIMIT 1
3.1 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2020-08-10 00:00:00",
INTERVAL 90 DAY
)
) > 0 AS new
FROM  `ps_product` p 
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE p.id_product IN (235,258,259,369,270) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
3.1 5 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
3.1 8 /classes/SpecificPrice.php:276
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 270
AND pac.`id_product_attribute` = 9
AND agl.`id_lang` = 2
3.1 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 5 LIMIT 1
3 1 /classes/Combination.php:444
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 75 AND `id_shop` = 1
3 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 83) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 404
AND pac.`id_product_attribute` = 227
AND agl.`id_lang` = 2
3 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 2) AND (a0.`nright` > 369) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
3 1 /classes/PrestaShopCollection.php:357
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
3 185 /classes/Tab.php:314
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 22 LIMIT 1
3 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.9 1 /classes/shop/Shop.php:573