Fale conosco

Controle Remoto Receptor Alphasat Chroma - 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: 

Alphasat Chroma HD

Alphasat Chroma Plus + HD

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 Alphasat Chroma - Paralelo (24.9 BRL)
Load Time5001 ms - You'd better run your shop on a toaster
Querying Time2517 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 974 ms 974 ms 4.65 Mb 4.90 Mb
__construct 13 ms 988 ms 0.08 Mb 4.90 Mb
init 1043 ms 2030 ms 3.31 Mb 8.29 Mb
checkAccess 0 ms 2030 ms - Mb 8.29 Mb
setMedia 21 ms 2051 ms 0.21 Mb 8.29 Mb
postProcess 0 ms 2051 ms - Mb 8.29 Mb
initHeader 0 ms 2051 ms - Mb 8.29 Mb
initContent 1075 ms 3127 ms 7.00 Mb 15.33 Mb
initFooter 0 ms 3127 ms - Mb 15.33 Mb
display 1874 ms 5001 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 *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
556.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
206.2 4 Yes /classes/shop/Shop.php:692
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
162 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.satcia.com.br' OR su.domain_ssl = 'www.satcia.com.br')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
104.7 4 Yes /classes/shop/Shop.php:344
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1
95.9 2 /classes/shop/Shop.php:1128
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
93 1 /classes/shop/Shop.php:1127
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`)
54 2948 /classes/Configuration.php:157
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` = 401 )  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` = 401) OR hc.`id_product` = 401) GROUP BY hc.`id` 
ORDER BY hc.`date_add` DESC  LIMIT 15
37 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` = 401 )  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` = 401) OR hc.`id_product` = 401) GROUP BY hc.`id` 
ORDER BY hc.`date_add` DESC  LIMIT 15
36.3 1118 Yes Yes /modules/homecomments/classes/review/Review.php:814
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
15.6 52 Yes Yes /classes/Category.php:747
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
14.1 1 Yes /classes/Language.php:819
(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 free_shipping = 1 AND carrier_restriction = 1) 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 free_shipping = 1 AND carrier_restriction = 1)
13 1 /classes/CartRule.php:393
(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_%")
12.5 1 /classes/CartRule.php:393
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` = 401) AND (b.`id_shop` = 1) LIMIT 1
11.8 1 /src/Adapter/EntityMapper.php:67
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` = 93 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
10.9 29 Yes Yes /classes/Category.php:747
alter table ps_ngcorreios_services drop index unique_service
9.8 1 /modules/ngcorreios/base.php:140
SELECT SQL_NO_CACHE *
FROM `ps_ngconfig`
WHERE (name="TmxxT2QvNGpWb1ZGM0xyNHo5UjJIQT09") AND (id_shop=1) LIMIT 1
9.3 10 /modules/ngcliente/classes/NeogestConfig.php:226
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM ps_iqitmegamenu_tabs_shop hs
LEFT JOIN ps_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN ps_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position
8.7 15 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON
(cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 2
AND c.nright >= 369
AND c.nleft >= 2
AND c.nright <= 369
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
8.2 1 Yes /modules/homecomments/controllers/hook/ProductPage.php:276
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` = 117) LIMIT 1
6.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
6 2 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
5.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
5.3 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` = 184) LIMIT 1
5.1 1 /src/Adapter/EntityMapper.php:67
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')
5.1 1 /classes/ObjectModel.php:529
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
4.6 10 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
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 = 358
ORDER BY f.position ASC
4.5 15 Yes /classes/Product.php:4860
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 *
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.4 1 /src/Adapter/EntityMapper.php:67
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`
4.3 400 Yes Yes /classes/Hook.php:629
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` = 401 )
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` = 401)
) as sc
4 1249924 /modules/homecomments/classes/review/Review.php:1094
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` = 401) LIMIT 1
4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_hook_module` hm
LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'moduleRoutes' AND hm.`id_module` = 412 LIMIT 1
3.9 2 /classes/module/Module.php:2170
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-homecomments-reviews"
OR m.page = "modulehomecommentsreviews"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
3.7 2 /classes/Meta.php:190
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 184 AND `id_shop` = 1
3.7 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
3.6 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.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
3.4 1 /classes/ObjectModel.php:1548
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
3.3 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
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
3.3 2 /classes/Product.php:845
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
3.2 496 /classes/Hook.php:374
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 /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
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 *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.8 1 /classes/shop/Shop.php:573
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 (401) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2.8 1 Yes Yes /classes/Product.php:3788
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 *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.7 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 115 AND `id_shop` = 1
2.7 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE *
FROM `ps_shop_url` a0
WHERE (a0.`id_shop` = 1) AND (a0.`main` = 1)
2.6 1 /classes/PrestaShopCollection.php:357
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
2.6 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 61
AND `active` = 1 LIMIT 1
2.6 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.6 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`
2.6 4 Yes /classes/Product.php:2984
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
2.6 2 /classes/Currency.php:657
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.5 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
2.5 15 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
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` = 477)
2.5 2 /classes/Product.php:3280
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
2.4 1 /classes/Country.php:191
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.4 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` = 214) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.4 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 401
AND image_shop.`cover` = 1 LIMIT 1
2.4 1 /classes/Product.php:3006
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` = 401 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2.3 1 Yes /classes/Product.php:3927
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.3 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.3 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` = 149) LIMIT 1
2.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
2.3 1 /classes/shop/Shop.php:573
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 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
2.2 46 Yes Yes /classes/Category.php:747
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 1 FROM `ps_specific_price` WHERE id_product = 258 LIMIT 1
2.1 1 /classes/SpecificPrice.php:408
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 option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
2.1 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "history"
OR m.page = "history"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
2.1 1 /classes/Meta.php:190
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` = 401 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` = 401 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
2.1 0 /classes/Cart.php:1225
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 235 LIMIT 1
2.1 1 /classes/SpecificPrice.php:408
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 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` = 24 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
2.1 17 Yes Yes /classes/Category.php:747
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
2.1 1 /classes/ObjectModel.php:1548
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 option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
2 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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
2 109 /classes/module/Module.php:301
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 2)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (14) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
2 2 Yes /classes/CMS.php:145
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 5
AND `active` = 1 LIMIT 1
2 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` = 281
ORDER BY `position`
2 2 Yes /classes/Product.php:2984
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 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` = 191 LIMIT 1
2 1 /classes/Combination.php:444
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` = 93) LIMIT 1
2 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` = 484
AND pac.`id_product_attribute` = 280
AND agl.`id_lang` = 2
2 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 131 AND `id_shop` = 1
1.9 1 /src/Adapter/EntityMapper.php:74
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` = 47 LIMIT 1
1.9 1 /classes/Category.php:1321
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` = 94 LIMIT 1
1.9 1 /classes/Category.php:1321
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` = 45 LIMIT 1
1.9 1 /classes/Combination.php:444
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 100 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 1 FROM `ps_specific_price` WHERE id_product = 279 LIMIT 1
1.8 1 /classes/SpecificPrice.php:408
(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_%")
1.8 1 /classes/CartRule.php:393
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 (369) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.8 2 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 45
AND `active` = 1 LIMIT 1
1.8 1 /classes/Manufacturer.php:308
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 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 (279) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.8 1 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` = 477
AND pac.`id_product_attribute` = 239
AND agl.`id_lang` = 2
1.7 1 /classes/Product.php:6020
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
1.7 15 Yes Yes /classes/Category.php:747
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
1.7 1 /src/Adapter/EntityMapper.php:67
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 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 (143,281,302,303,316) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.7 5 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
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` = 227
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 404 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` = 227
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 404 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1.7 0 /classes/Cart.php:1225
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('957', '608', '598534615', '', '1', '1', '2020-08-10 12:46:46')
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.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.6 1 /classes/shop/Shop.php:573
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
1.6 2 /modules/revsliderprestashop/includes/revslider_db.class.php:215
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
1.6 2 /classes/Product.php:832
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 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` = 143)
1.6 1 /classes/Product.php:3280
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` = 214
AND pac.`id_product_attribute` = 5
AND agl.`id_lang` = 2
1.6 1 /classes/Product.php:6020
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` = 17) LIMIT 1
1.6 1 /src/Adapter/EntityMapper.php:67
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` = 401
AND product_attribute_shop.default_on = 1 LIMIT 1
1.6 1 /classes/Product.php:3536
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 `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 281 AND `id_group` = 1 LIMIT 1
1.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 512 LIMIT 1
1.6 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 242 LIMIT 1
1.6 1 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 636 AND `id_group` = 1 LIMIT 1
1.6 0 /classes/GroupReduction.php:149
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
1.5 1 /classes/Category.php:1321
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` = 487) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 591 LIMIT 1
1.5 1 /classes/SpecificPrice.php:408
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` = 140) LIMIT 1
1.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
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_category_lang`
WHERE `id_category` = 193 AND `id_shop` = 1
1.5 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 217 LIMIT 1
1.5 1 /classes/SpecificPrice.php:408
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
1.5 1 /src/Adapter/EntityMapper.php:67
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 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` = 9 LIMIT 1
1.5 1 /classes/Combination.php:444
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 487) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.5 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` = 191
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` = 191
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.5 0 /classes/Cart.php:1225
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_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` = 488) AND (b.`id_shop` = 1) LIMIT 1
1.5 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 (369) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.5 2 Yes Yes /classes/Product.php:3788
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.5 67 Yes Yes /classes/Category.php:747
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 `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 11
AND `active` = 1 LIMIT 1
1.5 1 /classes/Manufacturer.php:308
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 42
AND `active` = 1 LIMIT 1
1.5 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 (488) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.5 1 Yes Yes /classes/Product.php:3788
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 `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 7
AND `active` = 1 LIMIT 1
1.5 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` = 484
ORDER BY `position`
1.5 7 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` = 185) LIMIT 1
1.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` = 37) LIMIT 1
1.5 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` = 239) 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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 512) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.4 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` = 488 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` = 488 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1.4 0 /classes/Cart.php:1225
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 *
FROM ps_shop_url
WHERE active = 1
AND id_shop = 1
1.4 1 /classes/shop/Shop.php:573
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` = 44 LIMIT 1
1.4 1 /classes/Category.php:1321
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 `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 4
AND `active` = 1 LIMIT 1
1.4 1 /classes/Manufacturer.php:308
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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 358) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.4 1 /classes/stock/StockAvailable.php:383
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` = 235
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 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
1.4 1 /classes/Product.php:6020
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` = 258
ORDER BY `position`
1.4 6 Yes /classes/Product.php:2984
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` = 12 LIMIT 1
1.4 1 /classes/Category.php:1321
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 143
1.4 1 /classes/Product.php:2416
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 1 FROM `ps_specific_price` WHERE id_product = 488 LIMIT 1
1.4 1 /classes/SpecificPrice.php:408
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` = 404 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` = 404 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1.4 0 /classes/Cart.php:1225
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_category_lang`
WHERE `id_category` = 91 AND `id_shop` = 1
1.4 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 (235,258,259,369,270) AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.4 5 Yes /modules/iqitmegamenu/iqitmegamenu.php:3634
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_lang`
WHERE `id_cms` = 14 AND `id_shop` = 1
1.4 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
1.3 0 /src/Adapter/Module/ModuleDataProvider.php:169
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` = 202)
1.3 2 /classes/Product.php:3280
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` = 378 LIMIT 1
1.3 1 /classes/Combination.php:444
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 `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 22
AND `active` = 1 LIMIT 1
1.3 1 /classes/Manufacturer.php:308
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
1.3 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` = 147) LIMIT 1
1.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 259 LIMIT 1
1.3 1 /classes/SpecificPrice.php:408
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 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` = 242 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` = 242 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
1.3 0 /classes/Cart.php:1225
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` = 187) LIMIT 1
1.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
1.3 11 /modules/revsliderprestashop/includes/revslider_db.class.php:193
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.3 1 /classes/Combination.php:444
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` = 358) AND (b.`id_shop` = 1) 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 1 FROM `ps_specific_price` WHERE id_product = 358 LIMIT 1
1.3 1 /classes/SpecificPrice.php:408
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` = 9) LIMIT 1
1.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 477) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.3 1 /classes/stock/StockAvailable.php:383
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
1.3 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` = 25) LIMIT 1
1.3 1 /src/Adapter/EntityMapper.php:67