Fale conosco

Controle Remoto TV Sky H67 - Paralelo

H67
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 Original Sky Claro H67

Média das Avaliações
0 / 5
Nota : 0 / 5
com base em 0 análises de clientes.
Controle Remoto Original Sky Claro H67
Compatível com todos os modelo da SKY

MARCAS CÓDIGOS
Equipamento SKY HDTV 00001

LG 
10030, 10056, 10178, 10442, 10700, 10823, 10829, 10856, 11178, 11265, 11325, 11423, 11758, 11993

Philips 
10012, 10013, 10037, 10054, 10556, 10690, 11154, 11454, 11483, 11961

Samsung
10019, 10030, 10032, 10037, 10056, 10060, 10178, 10329, 10408, 10427, 10702, 10812, 11060, 11312, 11575, 11903, 11959

Semp
10156, 11356

CCE 
10037, 10217, 10329

Toshiba
10036, 10060, 10070, 10093, 10149, 10154, 10156, 10650, 10822, 10832, 10845, 11156, 11164, 11256, 11265, 11306, 11325, 11343, 11356, 11369, 11524, 11635, 11656, 11704, 11918, 11935, 11936, 11945, 12006

Philco
10019, 10020, 10028, 10030, 10054, 10096, 10145, 10302, 10463, 10786, 11029, 11661, 11911

AOC 
10003, 10019, 10030, 10052, 10137, 10185, 11365

Gradiente
10053, 10056, 10170, 10392, 11804

Sony 
10000, 10010, 10011, 10080, 10111, 10273, 10353, 10505, 10810, 10834, 11100, 11317, 11685, 11904, 11925

Panasonic
10051, 10226, 10250, 10337, 10375, 10650, 11291, 11310, 11410, 11480, 11510, 11919, 11941, 11946, 11947

Mitsubishi
10093, 10098, 10150, 10155, 10178, 10331, 10358, 10535, 10836, 10868, 11151, 11250, 11392, 11522, 11550, 11917

Caso a marca de seu televisor não esteja nessa tabela, verifique o código pressionando Menu no controle remoto, selecione Config. e Controle dos Pais, acesse Configurações do Sistema, selecione Contr. Remoto e em seguida Config. Controle. Agora basta escolher a marca do televisor desejada e seguir as instruções para a configuração.

Como configurar seu controle SKY H67
Ligue sua TV e o equipamento SKY;
Para cada modelo de TV existe um código de 5 dígitos. Escolha a marca da sua TV para verificar os códigos disponíveis*, pois precisará testar um por um no passo 3;

Outras Marcas de TV
Aperte os botões ?Confirma? e ?Mute? juntos, mantendo-os pressionados por 5 segundos. 
A luz entre os botões ?On? e ?Off? piscará duas vezes. Insira imediatamente um dos códigos de 5 dígitos correspondente a marca de sua TV. A luz piscará duas vezes novamente;
Para testar se funcionou, aperte o volume para aumentar ou diminuir o áudio de sua TV. Se o volume não mudar, repita a operação informada no passo 3 utilizando outro código de 5 dígitos.
Você também pode verificar os códigos pelo seu equipamento SKYHDTV. Para isso, pressione Menu no Controle remoto, selecione Ajustes e Ajuda, após acesse Ajustes, selecione Controle Remoto, em seguida Config. Controle e selecione TV. Agora basta escolher a marca do televisor e seguir as instruções.

Colocamos todas as informações Possíveis, lembrando que o controle remoto é uma peça de reposição, que comprar deve conhecer o produto, qualquer dúvidas veja o manual de seu receptor. 

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 TV Sky H67 - Paralelo (24.9 BRL)
Load Time1466 ms - OK... for a shared hosting
Querying Time941 ms
Queries1469
Memory Peak Usage50.4 Mb
Included Files674 files - 9.82 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 36 ms 36 ms 4.65 Mb 4.90 Mb
__construct 1 ms 36 ms 0.08 Mb 4.90 Mb
init 31 ms 67 ms 3.31 Mb 8.30 Mb
checkAccess 0 ms 67 ms - Mb 8.30 Mb
setMedia 3 ms 70 ms 0.21 Mb 8.30 Mb
postProcess 0 ms 70 ms - Mb 8.30 Mb
initHeader 0 ms 70 ms - Mb 8.30 Mb
initContent 214 ms 284 ms 7.01 Mb 15.35 Mb
initFooter 0 ms 284 ms - Mb 15.35 Mb
display 1182 ms 1466 ms 34.71 Mb 50.37 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 1469 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` = 362 )  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` = 362) OR hc.`id_product` = 362) GROUP BY hc.`id` 
ORDER BY hc.`date_add` DESC  LIMIT 15
10.7 1118 Yes Yes /modules/homecomments/classes/review/Review.php:814
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` = 362 )  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` = 362) OR hc.`id_product` = 362) GROUP BY hc.`id` 
ORDER BY hc.`date_add` DESC  LIMIT 15
10 1118 Yes Yes /modules/homecomments/classes/review/Review.php:814
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
9.3 1 /classes/module/Module.php:2603
(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_%")
9.2 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
9 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
7.8 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` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
7.5 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 120
AND `active` = 1 LIMIT 1
7 1 /classes/Manufacturer.php:308
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` = 256
ORDER BY `position`
7 7 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 270) AND (id_product_attribute = 9) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.4 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE *
FROM `ps_ngpayment_simulator_payment_mode`
WHERE (id=1) LIMIT 1
6.4 1 /modules/ngpaymentsimulator/classes/PaymentMode.php:102
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
6.3 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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` = 512
ORDER BY `position`
6.2 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 119
AND `active` = 1 LIMIT 1
6.2 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 68) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.1 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
6 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` = 362) LIMIT 1
5.6 1 /src/Adapter/EntityMapper.php:67
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.4 2948 /classes/Configuration.php:157
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.3 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` = "hookDisplayWhatsAppProductSocialButtons" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
5.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
5.2 2 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `ps_ngpayment_simulator_payment_mode`
WHERE (id=1) LIMIT 1
4.9 1 /modules/ngpaymentsimulator/classes/PaymentMode.php:102
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 6
AND `active` = 1 LIMIT 1
4.7 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.7 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` = 279
ORDER BY `position`
4.5 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
4.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ngcorreios" LIMIT 1
4.4 1 /classes/module/Module.php:2603
(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
4.4 1 /classes/CartRule.php:335
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 115 AND `id_shop` = 1
4.3 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 604) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.3 1 /classes/stock/StockAvailable.php:383
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` = 362
AND product_attribute_shop.default_on = 1 LIMIT 1
4.2 1 /classes/Product.php:3536
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 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 = 279 LIMIT 1
4 1 /classes/Product.php:832
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 256 AND id_shop=1 LIMIT 1
4 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 83 AND `id_group` = 1 LIMIT 1
3.9 0 /classes/GroupReduction.php:149
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` = 26 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
3.9 15 Yes Yes /classes/Category.php:747
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 235 AND id_shop=1 LIMIT 1
3.9 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
3.8 2 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 2
AND `active` = 1 LIMIT 1
3.7 1 /classes/Manufacturer.php:308
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.7 400 Yes Yes /classes/Hook.php:629
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
3.6 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` = 362 )
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` = 362)
) as sc
3.6 1249924 /modules/homecomments/classes/review/Review.php:1094
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 (143) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3.5 1 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
3.2 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 11
AND `active` = 1 LIMIT 1
3.2 1 /classes/Manufacturer.php:308
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 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 = 235 LIMIT 1
3 1 /classes/Product.php:832
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 4) LIMIT 1
3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 259 LIMIT 1
2.9 1 /classes/SpecificPrice.php:408
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
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` = 68 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` = 68 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
2.8 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 258 LIMIT 1
2.5 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
2.5 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 143 LIMIT 1
2.4 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 6) LIMIT 1
2.3 1 /src/Adapter/EntityMapper.php:67
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 = 126 LIMIT 1
2.3 2 /classes/Product.php:832
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` = 362
AND product_attribute_shop.default_on = 1 LIMIT 1
2.3 1 /classes/Product.php:3536
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 54
AND `active` = 1 LIMIT 1
2.2 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
2.2 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` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
2.1 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (362)
2.1 1 /modules/iqitcrossselling/iqitcrossselling.php:154
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` = 338) AND (b.`id_shop` = 1) LIMIT 1
2.1 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2 1 /classes/shop/Shop.php:573
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
1.9 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
1.9 1 /classes/ObjectModel.php:529
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.9 1 /classes/shop/Shop.php:573
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 = 217
ORDER BY f.position ASC
1.9 13 Yes /classes/Product.php:4860
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1.9 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 190 AND `id_shop` = 1
1.8 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.8 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 206 AND `id_shop` = 1
1.7 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.7 1 /classes/shop/Shop.php:573
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
1.7 496 /classes/Hook.php:374
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` = "hookDisplayProductAdditionalInfo" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
1.7 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1049', '556', '598534615', '', '1', '1', '2020-08-10 12:55:41')
1.7 1 /classes/ObjectModel.php:529
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.6 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
1.6 15 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_ngconfig`
WHERE (name="TmxxT2QvNGpWb1ZGM0xyNHo5UjJIQT09") AND (id_shop=1) LIMIT 1
1.6 10 /modules/ngcliente/classes/NeogestConfig.php:226
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
1.5 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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` = 369
ORDER BY `position`
1.5 7 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 35 LIMIT 1
1.5 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.5 1 /classes/shop/Shop.php:573
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
1.5 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE id_elementor FROM ps_iqit_elementor_product WHERE id_product = 362 LIMIT 1
1.5 144 /modules/iqitelementor/src/IqitElementorProduct.php:57
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` = 338)
1.5 2 /classes/Product.php:3280
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
1.5 10 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.5 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.4 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` = 404
ORDER BY `position`
1.4 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.4 1 /classes/shop/Shop.php:573
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` = 13 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
1.4 67 Yes Yes /classes/Category.php:747
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 14) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 50) LIMIT 1
1.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "braintreeofficial" LIMIT 1
1.4 0 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.4 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` = 488
ORDER BY `position`
1.4 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.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` = 214
ORDER BY `position`
1.3 3 Yes /classes/Product.php:2984
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.3 0 /classes/Hook.php:186
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 58 LIMIT 1
1.3 1 /classes/AddressFormat.php:616
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 60
AND `active` = 1 LIMIT 1
1.3 1 /classes/Manufacturer.php:308
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` = "hookDisplayFooterProduct" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
1.3 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:130
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
1.3 1 /classes/Cart.php:3921
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 42
AND `active` = 1 LIMIT 1
1.3 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 50
AND `active` = 1 LIMIT 1
1.3 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 11) LIMIT 1
1.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.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` = 217
ORDER BY `position`
1.3 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 46
AND `active` = 1 LIMIT 1
1.3 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
1.3 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 22) LIMIT 1
1.2 1 /src/Adapter/EntityMapper.php:67
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`
1.2 3 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.2 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 44
AND `active` = 1 LIMIT 1
1.2 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
1.2 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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` = 26
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
1.2 10 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
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`
1.2 7 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM `ps_ngpayment_simulator_fixed_interest_ratio`
WHERE (payment_mode_id=1) AND (number_of_payments=10) LIMIT 1
1.2 36 /modules/ngpaymentsimulator/classes/FixedInterestRatio.php:38
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
1.2 5 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 58) LIMIT 1
1.2 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` = 280 LIMIT 1
1.2 1 /classes/Combination.php:444
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 (202) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.2 2 Yes Yes /classes/Product.php:3788
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` = 338
AND pac.`id_product_attribute` = 191
AND agl.`id_lang` = 2
1.2 1 /classes/Product.php:6020
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` = 127) LIMIT 1
1.2 1 /src/Adapter/EntityMapper.php:67
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` = 19 LIMIT 1
1.2 1 /classes/Category.php:1321
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` = 305
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
1.1 10 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
1.1 88 /classes/Hook.php:226
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 5
AND `active` = 1 LIMIT 1
1.1 1 /classes/Manufacturer.php:308
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` = 68)
1.1 2 /classes/Product.php:3280
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 19 AND `id_shop` = 1
1.1 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 83 LIMIT 1
1.1 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 281) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.1 1 /classes/stock/StockAvailable.php:383
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 = 68 LIMIT 1
1.1 2 /classes/Product.php:845
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` = 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` = 0
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
1.1 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 45
AND `active` = 1 LIMIT 1
1.1 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.1 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 37
AND `active` = 1 LIMIT 1
1.1 1 /classes/Manufacturer.php:308
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` = 47 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
1.1 52 Yes Yes /classes/Category.php:747
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` = 83
ORDER BY `position`
1.1 4 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 9
AND `active` = 1 LIMIT 1
1.1 1 /classes/Manufacturer.php:308
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 (214) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.1 2 Yes Yes /classes/Product.php:3788
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` = 123) LIMIT 1
1.1 1 /src/Adapter/EntityMapper.php:67
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
1.1 0 /classes/Cart.php:1225
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` = 93
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 83 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` = 93
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 83 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1.1 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
1.1 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
1.1 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` = 93) LIMIT 1
1.1 1 /src/Adapter/EntityMapper.php:67
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` = 101) LIMIT 1
1.1 1 /src/Adapter/EntityMapper.php:67
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` = 258) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /src/Adapter/EntityMapper.php:67
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 = 338
ORDER BY f.position ASC
1 15 Yes /classes/Product.php:4860
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 38) LIMIT 1
1 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 = 15 LIMIT 1
1 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
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` = 484
ORDER BY `position`
1 7 Yes /classes/Product.php:2984
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` = 126
ORDER BY `position`
1 4 Yes /classes/Product.php:2984
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
1 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
1 0 /classes/module/Module.php:2151
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
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` = 487
ORDER BY `position`
1 4 Yes /classes/Product.php:2984
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 (404) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1 2 Yes Yes /classes/Product.php:3788
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 (217) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1 2 Yes Yes /classes/Product.php:3788
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` = 338 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` = 338 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1 0 /classes/Cart.php:1225