Haga clic para más productos.
No se encontraron productos.

Trabuco del siglo XVIII

Trabuco del siglo XVIII. El trabuco es un arma de fuego de avancarga, de grueso calibre, con un cañón corto y usualmente acampanado. Es un predecesor de la escopeta, adaptado para servicio militar y defensivo.

Referencia:
001770001
92,50 €
Favorito
Acabados

in stock  1 unidad para SALIDA INMEDIATA

Cómpralo antes de 7 horas y 41 minutos y te lo enviamos hoy

Puntuaciones y opiniones de nuestros clientes
( 5.0 / 5) - 1 Opinión (es)

Fabricante
Denix

Largo
74 cms.
Material
Madera y zamak
Peso
2-2,1 Kg.
Lugar de fabricación
ESPAÑA
001770001

Referencias específicas

ean13
8435089710946
Referencia Atributos Stock Precio
001770001 Acabados: Plata vieja; 1
92,50 €
001770002 Acabados: Oro viejo; 0
102,95 €

Puntuaciones y opiniones de nuestros clientes

Puntuación:  
 
 -   (Graus, España)
Me quedé sorprendido de lo rápido que ha llegado. Mi opinión... Excelente, un Diez !!!
5 productos en la misma categoría:
Los clientes que adquirieron este producto también compraron:

Menú

Compartir

Código QR

Ajustes

Crear una cuenta gratuita para guardar tus favoritos.

Registrarse
Load Time1545 ms - OK... for a shared hosting
Querying Time713 ms
Queries915
Memory Peak Usage48.0 Mb
Included Files736 files - 13.67 Mb
PrestaShop Cache0.01 Mb
Global vars1.27 Mb
PrestaShop Version1.7.5.2
PHP Version7.1.33 (OK)
MySQL Version10.1.43-MariaDB (OK)
Memory Limit512M
Max Execution Time1800s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 172 ms 172 ms 10.35 Mb 15.92 Mb
__construct 0 ms 172 ms - Mb 15.92 Mb
init 117 ms 289 ms 3.43 Mb 15.92 Mb
checkAccess 0 ms 289 ms - Mb 15.92 Mb
setMedia 3 ms 292 ms 0.28 Mb 15.92 Mb
postProcess 0 ms 292 ms - Mb 15.92 Mb
initHeader 0 ms 292 ms - Mb 15.92 Mb
initContent 541 ms 833 ms 9.35 Mb 23.44 Mb
initFooter 0 ms 833 ms - Mb 23.44 Mb
display 712 ms 1545 ms 23.23 Mb 47.96 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 915 queries

Query Time (ms) Rows Filesort Group By Location
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`)
57.3 52370 /classes/Configuration.php:160
SELECT SQL_NO_CACHE fb.*, fb.id_feedback AS id, c.email, c.firstname, c.lastname, r.feedback as reply, fb.posted,
fbr.id_criterion, sum(fbr.star) / count(fbr.id_feedback) as stars
FROM `ps_ifb_feedback` fb
INNER JOIN `ps_ifb_rating` `fbr` ON fbr.id_feedback = fb.id_feedback
LEFT JOIN `ps_customer` `c` ON fb.id_customer = c.id_customer
LEFT JOIN `ps_ifb_reply` `r` ON fb.id_feedback = r.id_feedback
WHERE (fb.id_product = 1600) AND (fb.approved = 1) AND (fb.id_shop = 1) AND (fb.id_lang = 4)
GROUP BY fb.id_feedback
ORDER BY fb.date_add DESC
LIMIT 5 OFFSET 0
42.3 1396901 Yes /modules/ifeedback/classes/IfeedbackClass.php:239
SELECT SQL_NO_CACHE `ps_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`,
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`,
`custom_css`, `custom_js`, `offline_link`
FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 4) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1
19.6 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:106
SELECT SQL_NO_CACHE fb.*, fb.id_feedback AS id, c.email, c.firstname, c.lastname, r.feedback as reply, fb.posted,
fbr.id_criterion, sum(fbr.star) / count(fbr.id_feedback) as stars
FROM `ps_ifb_feedback` fb
INNER JOIN `ps_ifb_rating` `fbr` ON fbr.id_feedback = fb.id_feedback
LEFT JOIN `ps_customer` `c` ON fb.id_customer = c.id_customer
LEFT JOIN `ps_ifb_reply` `r` ON fb.id_feedback = r.id_feedback
WHERE (fb.id_product = 1600) AND (fb.approved = 1) AND (fb.id_shop = 1) AND (fb.id_lang = 4)
GROUP BY fb.id_feedback
ORDER BY fb.id_feedback DESC
19.1 1396901 Yes /modules/ifeedback/classes/IfeedbackClass.php:239
SELECT SQL_NO_CACHE DISTINCT od.product_id
FROM ps_order_detail od
LEFT JOIN ps_product p ON (p.id_product = od.product_id)
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` pa ON (p.`id_product` = pa.`id_product`)
LEFT 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 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN ps_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN ps_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN ps_image i ON (i.id_product = od.product_id)
WHERE od.id_order IN (3689,9543,9976,10475,10720,16398,18922,19674,19767,19984,20882,21163,21197,21774,21951,24515,24543,24586,26236,28318,30055,31527,34275,34659,36192,36974,37486,37552,37738,37747,43272,46306,53489,55611,58728,59535,60817,61424,64956,1790,2194,4659,5577,5640,9052,16375,16604,16866,17215,17812,18406,19622,19851,21056,25562,28316,31883,32218,35386,35973,36356,36445,38495,39338,42359,45105,49356,52616,59307,60485)
AND pl.id_lang = 4
AND cl.id_lang = 4
AND od.product_id NOT IN (1600)
AND i.cover = 1
AND product_shop.active = 1
ORDER BY RAND()
LIMIT 5
14.5 1260 Yes /modules/ps_crossselling/ps_crossselling.php:307
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2020-02-25 00:00:00',
INTERVAL 45 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 9588
14.4 1 /classes/ProductAssembler.php:90
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`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
13.6 3834 Yes Yes /classes/Hook.php:666
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` = 4
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
13.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_feature` a
LEFT JOIN `ps_feature_lang` `b` ON a.`id_feature` = b.`id_feature` AND b.`id_lang` = 4
LEFT JOIN `ps_feature_shop` `c` ON a.`id_feature` = c.`id_feature` AND c.`id_shop` = 1
WHERE (a.`id_feature` = 61) LIMIT 1
13.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
13.1 88 /classes/Hook.php:260
SELECT SQL_NO_CACHE `ps_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`,
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`,
`custom_css`, `custom_js`, `offline_link`
FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 4) WHERE `id_hook` = "header" AND `id_shop` = 1 AND `active` = 1
13 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:106
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_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)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
WHERE pa.`id_product` = 1600
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
13 2 Yes Yes /classes/Product.php:2389
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
12.9 0 /classes/module/Module.php:2752
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` = 1) LIMIT 1
12.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 9586
12.8 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1600 LIMIT 1
12.8 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 4 AND id_category = 148 LIMIT 1
12.7 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2020-02-25 07:48:47" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2020-02-25 07:48:47" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
12.6 6 /modules/groupinc/classes/GroupincConfiguration.php:2111
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
12.6 0 /src/Adapter/Module/ModuleDataProvider.php:185
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2020-02-25 07:48:47" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2020-02-25 07:48:47" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1
12.6 6 /modules/groupinc/classes/GroupincConfiguration.php:2111
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
12.5 12 /classes/Language.php:882
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "shiptopay" LIMIT 1
12.3 0 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 1600 LIMIT 1
12.2 1 /classes/Pack.php:401
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stwishlist" LIMIT 1
12.2 0 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2020-02-25 07:48:46" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2020-02-25 07:48:46" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(61, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = ""  OR FIND_IN_SET(56, REPLACE(gi.suppliers, ";", ",")) > 0) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(4, REPLACE(gi.languages, ";", ",")) > 0) AND (gi.countries = "" OR FIND_IN_SET(6, REPLACE(gi.countries, ";", ",")) > 0)
11.6 6 /modules/groupinc/classes/GroupincConfiguration.php:413
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
11.4 88 /classes/Hook.php:234
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 4 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) AND cs.`id_shop` = 1 AND c.`id_parent` != 0 WHERE c.`id_category` = 188 LIMIT 1
10.4 1 /classes/Category.php:1523
SELECT SQL_NO_CACHE COUNT(id_product)
FROM `ps_ifb_feedback`
WHERE (id_product = 1600) AND (approved = 1) LIMIT 1
8.5 9307 /modules/ifeedback/ifeedback.php:3343
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi WHERE gi.`id_shop` = 1
AND gi.`active` = 1
8.4 6 /modules/groupinc/groupinc.php:929
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
8.2 639 /classes/Hook.php:403
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
6.8 2719 /classes/SpecificPrice.php:283
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 4 AND sec.`active`=1  AND sec.`type`=9 AND ((sec.id_manufacturer = 0 AND sec.id_category = 0 AND sec.id_product = "") OR (sec.id_manufacturer > 0 AND sec.id_manufacturer=17) OR (sec.id_category > 0 AND sec.id_category IN(188,187,22,1)) OR (sec.id_product LIKE "%,1600,%"))
ORDER BY sec.`position`
6.3 2189 Yes /modules/steasycontent/classes/StEasyContentClass.php:328
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
6 1 /classes/Cart.php:4013
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 208 LIMIT 1
5.2 1 /classes/Category.php:1322
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` = 4)
WHERE i.`id_product` = 9586
ORDER BY `position`
5.1 1 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE *
FROM `ps_customer` a
WHERE (a.`id_customer` = 56968) LIMIT 1
4.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 1600 LIMIT 1
4.3 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE t.type, tc.*, tcs.*, tcl.content, tl.name AS name_tab, pl.name AS name_product
FROM `ps_pet_tab_content` tc
INNER JOIN `ps_pet_tab_content_shop` `tcs` ON tcs.id_tab_content = tc.id_tab_content
INNER JOIN `ps_pet_tab_content_lang` `tcl` ON tc.id_tab_content = tcl.id_tab_content AND tcl.id_lang = 4
INNER JOIN `ps_pet_tab` `t` ON t.id_tab = tc.id_tab
INNER JOIN `ps_pet_tab_lang` `tl` ON t.id_tab = tl.id_tab AND tl.id_lang = 4
INNER JOIN `ps_pet_tab_shop` `ts` ON t.id_tab = ts.id_tab
LEFT JOIN `ps_product_lang` `pl` ON pl.id_product = tcs.id_product AND pl.id_lang = 4
WHERE (tcs.id_product IN (1600, -1)) AND (tcs.id_shop = 1 AND ts.id_shop = 1) AND (ts.active = 1) AND (tcs.customer_group_show IN (1, -1))
GROUP BY tc.id_tab_content, tcs.id_product
ORDER BY CAST(ts.position AS unsigned) ASC
3.3 5832 Yes Yes /modules/productextratabs/classes/PETTabContentClass.php:277
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 4 AND id_category = 82 LIMIT 1
2.9 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE *
FROM `ps_st_loved_product`
WHERE `type`=1
AND `id_shop`=1
AND `id_customer`=0
ORDER BY date_add DESC
LIMIT 6
2.9 3191 Yes /modules/stlovedproduct/classes/StLovedProductClass.php:132
SELECT SQL_NO_CACHE *
FROM `ps_st_loved_product`
WHERE `type`=2
AND `id_shop`=1
AND `id_customer`=0
ORDER BY date_add DESC
LIMIT 6
2.6 3191 Yes /modules/stlovedproduct/classes/StLovedProductClass.php:132
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 9586
ORDER BY f.position ASC
2.5 3 Yes /classes/Product.php:4952
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2018) AND (id_product_attribute = 1633) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
2.4 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 9586 LIMIT 1
2.3 5 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 9589)
GROUP BY a0.`id_supplier`
2.2 1 Yes Yes /classes/PrestaShopCollection.php:373
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
2.1 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 82 LIMIT 1
2.1 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 9589)
GROUP BY a0.`id_supplier`
2.1 1 Yes Yes /classes/PrestaShopCollection.php:373
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
2.1 342 Yes /classes/Dispatcher.php:636
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 9588
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2 1 /classes/SpecificPrice.php:246
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-02-25 00:00:00",
INTERVAL 45 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
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_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 AND pl.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` = 4)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 188 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 6
1.9 4 Yes /classes/Category.php:1010
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 9588
ORDER BY f.position ASC
1.8 3 Yes /classes/Product.php:4952
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.6 0 /classes/Hook.php:190
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 4  AND cl.id_shop = 1 )
WHERE `id_parent` = 188
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.5 1 Yes Yes /classes/Category.php:872
SELECT SQL_NO_CACHE * FROM ps_carrier_shop AS cs NATURAL JOIN ps_carrier LEFT JOIN ps_ed_carriers USING (id_reference, id_shop) LEFT JOIN ps_carrier_lang AS cl USING (id_carrier, id_shop) NATURAL JOIN ps_carrier_zone AS cz WHERE `id_zone` IN (SELECT id_zone FROM `ps_country` AS tmpz WHERE tmpz.`iso_code` LIKE 'US%' AND tmpz.`active` = 1 AND tmpz.id_zone > 0 GROUP BY tmpz.id_zone) AND `active` = 1 AND deleted = 0 AND cl.`id_lang` = 4 AND cs.id_shop = 1 GROUP BY id_reference ORDER BY position ASC, id_carrier DESC
1.4 25 Yes Yes /modules/estimateddelivery/estimateddelivery.php:1472
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-02-25 00:00:00",
INTERVAL 45 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` = 4 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 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` = 4)
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_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 1600 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.4 1 Yes Yes /classes/Product.php:4003
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 (1600)
1.4 33 /modules/ps_crossselling/ps_crossselling.php:252
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-02-25 00:00:00",
INTERVAL 45 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` = 4 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 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` = 4)
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_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 1600 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.2 1 Yes Yes /classes/Product.php:4003
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` = 4)
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` = 4)
WHERE pa.`id_product` = 2545
AND pac.`id_product_attribute` = 1925
AND agl.`id_lang` = 4
1 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*
FROM `ps_feature` f
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 4)
ORDER BY f.`position` ASC
1 59 Yes /classes/Feature.php:91
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_st_brands_slider` sbs
LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = sbs.`id_manufacturer` 
LEFT JOIN `ps_manufacturer_lang` ml ON (
m.`id_manufacturer` = ml.`id_manufacturer`
AND ml.`id_lang` = 4
)
INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) WHERE sbs.`id_shop` = 1 AND m.`active` = 1 
GROUP BY m.id_manufacturer  ORDER BY RAND()  LIMIT 42
1 21 Yes Yes /modules/stbrandsslider/stbrandsslider.php:703
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 9588)
GROUP BY a0.`id_supplier`
1 1 Yes Yes /classes/PrestaShopCollection.php:373
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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 p.`id_product` = 2545 AND pa.`id_product` = 2545 AND pa.`id_product_attribute` = 1925 LIMIT 1
1 1 /classes/Product.php:938
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1600
AND al.`id_lang` = 4
AND agl.`id_lang` = 4
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 2 Yes Yes /classes/Product.php:3915
SELECT SQL_NO_CACHE * FROM (SELECT c.id_carrier, c.id_reference, c.name, c.position, c.is_free, c.range_behavior, c.shipping_method, edc.picking_limit, edc.picking_days, edc.shippingdays, edc.min, edc.max, edc.ignore_picking, edc.ed_active, edc.ed_alias FROM `ps_carrier_shop` AS cs NATURAL JOIN ps_carrier AS c LEFT JOIN `ps_ed_carriers` AS edc USING (id_reference, id_shop) LEFT JOIN `ps_carrier_lang` AS cl USING (id_carrier, id_shop) WHERE cl.id_lang = 4 AND active = 1 AND deleted=0 AND cl.id_shop = 1 AND cs.id_shop = 1 ORDER BY c.id_reference DESC, c.id_carrier DESC) AS tmp GROUP BY id_reference
1 25 Yes Yes /modules/estimateddelivery/estimateddelivery.php:705
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*
FROM `ps_feature` f
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 4)
ORDER BY f.`position` ASC
0.9 59 Yes /classes/Feature.php:91
SELECT SQL_NO_CACHE fbr.*,
fbcl.name
FROM `ps_ifb_rating` fbr
INNER JOIN `ps_ifb_criterion` `fbc` ON fbc.id_ifb_criterion = fbr.id_criterion
INNER JOIN `ps_ifb_criterion_lang` `fbcl` ON fbcl.id_ifb_criterion = fbr.id_criterion AND fbcl.id_lang = 4
WHERE (fbc.deleted = 0) AND (fbr.id_feedback = 8670)
0.9 1 /modules/ifeedback/classes/IfeedbackClass.php:436
(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` = 4) 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` = 4) 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_%")
0.8 1 /classes/CartRule.php:400
SELECT SQL_NO_CACHE id_manufacturer FROM `ps_product` WHERE id_product = 2545 LIMIT 1
0.8 1 /modules/groupinc/classes/GroupincConfiguration.php:2604
(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` = 4) 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` = 4) 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)
0.8 1 /classes/CartRule.php:400
SELECT SQL_NO_CACHE *
FROM `ps_product_supplier` a0
WHERE (a0.`id_product` = 2545)
GROUP BY a0.`id_supplier`
0.8 1 Yes Yes /classes/PrestaShopCollection.php:373
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1600
AND al.`id_lang` = 4
AND agl.`id_lang` = 4
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.8 2 Yes Yes /classes/Product.php:3915
(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` = 4) 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` = 4) 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_%")
0.7 1 /classes/CartRule.php:400
(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` = 4) 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` = 4) 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_%")
0.7 1 /classes/CartRule.php:400
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` = 1925) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1600
AND al.`id_lang` = 4
AND agl.`id_lang` = 4
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 2 Yes Yes /classes/Product.php:3915
(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` = 4) 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` = 4) 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_%")
0.7 1 /classes/CartRule.php:400
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2020-02-25 07:48:46" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2020-02-25 07:48:46" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(17, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = ""  OR FIND_IN_SET(0, REPLACE(gi.suppliers, ";", ",")) > 0) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(4, REPLACE(gi.languages, ";", ",")) > 0) AND (gi.countries = "" OR FIND_IN_SET(6, REPLACE(gi.countries, ";", ",")) > 0)
0.7 6 /modules/groupinc/classes/GroupincConfiguration.php:413
SELECT SQL_NO_CACHE DISTINCT a.*, cl.`name` AS country, s.name AS state, s.iso_code AS state_iso
FROM `ps_address` a
LEFT JOIN `ps_country` c ON (a.`id_country` = c.`id_country`)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country`)
LEFT JOIN `ps_state` s ON (s.`id_state` = a.`id_state`)
INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
WHERE `id_lang` = 4 AND `id_customer` = 56968 AND a.`deleted` = 0
0.6 1 /classes/Customer.php:578
SELECT SQL_NO_CACHE id_manufacturer FROM `ps_product` WHERE id_product = 1600 LIMIT 1
0.6 1 /modules/groupinc/classes/GroupincConfiguration.php:2604
SELECT SQL_NO_CACHE sms.*, smsl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `ps_st_page_banner` sms
LEFT JOIN `ps_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner`)
INNER JOIN ps_st_page_banner_shop st_page_banner_shop
ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1)
WHERE smsl.`id_lang` = 4 AND sms.`active`=1  AND sms.`item_k`=11 AND sms.`item_v`="1" ORDER BY sms.`position`
LIMIT 1
0.6 1 Yes /modules/stpagebanner/classes/StPageBannerClass.php:197
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 9589 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:549
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2545) AND (id_product_attribute = 1925) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_sidebar` snl
INNER JOIN ps_st_sidebar_shop st_sidebar_shop
ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = 1)
LEFT JOIN `ps_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`)
WHERE snll.`id_lang` = 4 AND snl.`active`=1 
ORDER BY snl.`location`, snl.`position`
0.6 5 Yes /modules/stsidebar/classes/StSidebarClass.php:116
SELECT SQL_NO_CACHE id_manufacturer FROM `ps_product` WHERE id_product = 9586 LIMIT 1
0.6 1 /modules/groupinc/classes/GroupincConfiguration.php:2604
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 9588 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 4 Yes /classes/SpecificPrice.php:549
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_sidebar` snl
INNER JOIN ps_st_sidebar_shop st_sidebar_shop
ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = 1)
LEFT JOIN `ps_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`)
WHERE snll.`id_lang` = 4 AND snl.`active`=1 
ORDER BY snl.`location`, snl.`position`
0.6 5 Yes /modules/stsidebar/classes/StSidebarClass.php:116
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` = 1925
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2545 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` = 1925
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2545 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_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)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
WHERE pa.`id_product` = 1600
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.5 2 Yes Yes /classes/Product.php:2389
SELECT SQL_NO_CACHE COUNT(*)
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` = 2018 LIMIT 1
0.5 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1600
0.5 2 /classes/Product.php:6203
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2020-02-25 07:48:46" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2020-02-25 07:48:46" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(17, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = ""  OR FIND_IN_SET(0, REPLACE(gi.suppliers, ";", ",")) > 0) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(4, REPLACE(gi.languages, ";", ",")) > 0) AND (gi.countries = "" OR FIND_IN_SET(6, REPLACE(gi.countries, ";", ",")) > 0)
0.5 6 /modules/groupinc/classes/GroupincConfiguration.php:413
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
0.5 146 /classes/module/Module.php:305
SELECT SQL_NO_CACHE gi.* FROM `ps_groupinc_configuration` gi  WHERE (date_from <= "2020-02-25 07:48:46" OR date_from = "0000-00-00 00:00:00") AND (date_to >= "2020-02-25 07:48:46" OR date_to = "0000-00-00 00:00:00") AND gi.`id_shop` = 1 AND gi.`active` = 1  AND show_on_sale = 1  AND (gi.groups = ""  OR FIND_IN_SET(1, REPLACE(gi.groups, ";", ",")) > 0) AND (gi.manufacturers = "" OR FIND_IN_SET(17, REPLACE(gi.manufacturers, ";", ",")) > 0) AND (gi.suppliers = ""  OR FIND_IN_SET(0, REPLACE(gi.suppliers, ";", ",")) > 0) AND (gi.currencies = "" OR FIND_IN_SET(1, REPLACE(gi.currencies, ";", ",")) > 0) AND (gi.languages = "" OR FIND_IN_SET(4, REPLACE(gi.languages, ";", ",")) > 0) AND (gi.countries = "" OR FIND_IN_SET(6, REPLACE(gi.countries, ";", ",")) > 0)
0.5 6 /modules/groupinc/classes/GroupincConfiguration.php:413
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 89) AND (a0.`nright` > 90) AND (a1.`id_lang` = 4)
ORDER BY a0.`nleft` asc
0.5 1476 /classes/PrestaShopCollection.php:373
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 2545 LIMIT 1
0.5 1 /classes/Pack.php:85
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` = 4) WHERE 1 = 1 AND `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 20 AND `active` = 1 ORDER BY position
0.5 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:71
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 1600 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.5 1 Yes /classes/SpecificPrice.php:612
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 4)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1600
0.5 2 /classes/Product.php:6203
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 4
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 10 Yes Yes /classes/Category.php:1098
SELECT SQL_NO_CACHE id_zone FROM `ps_country` AS tmpz WHERE tmpz.`iso_code` LIKE 'US%' AND tmpz.`active` = 1 AND tmpz.id_zone > 0 GROUP BY tmpz.id_zone
0.5 1 Yes Yes /modules/estimateddelivery/estimateddelivery.php:1461
SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 )
WHERE p.`id_product` = 1600
AND l.`active` = 1
0.5 3 /classes/Product.php:5600
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
0.5 146 /classes/module/Module.php:305
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 1785 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:549
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 4111 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-02-25 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 7 Yes /classes/SpecificPrice.php:549
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2020-02-25 00:00:00',
INTERVAL 45 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 4
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 9589
0.4 1 /classes/ProductAssembler.php:90