• Precio rebajado
04 05 Honda Cbr 1000 Rr Pinza Freno
  • 04 05 Honda Cbr 1000 Rr Pinza Freno

04 05 Honda Cbr 1000 Rr Pinza de freno trasero

PI4-14544.2D
Honda

Pinza Freno Posteriore Honda Cbr 1000 Rr 04 / 05 Rear Brake Caliper

54,75 €
43,80 € Guardar 20%
Cantidad
Últimas unidades en stock

 

Compatibilità per il modello indicato garantito !

 

60 giorni per reso e cambio merce

  Assistenza clienti whatsapp

Contatta il nostro Staff

Descripción

2004 2005 Honda Cbr 1000 Rr Pinza Freno Posteriore 

Detalles del producto
PI4-14544.2D
Utilizado

Hoja

Marca de motocicletas
HONDA
Modelo Moto
CBR 1000 RR
Año De Moto
2004
Año De Moto
2005
Especialidades
strada

Pulse aquí para dejar su opinión

Envíanos tu consulta

Sea el primero en hacer una consulta sobre este producto!

Consultar, modificar o revocar datos

Consulta sobre el producto

*Campos Requeridos
(Leer)
6 otros productos de la misma categoría:
Load Time803 ms - OK... for a shared hosting
Querying Time577 ms
Queries459
Memory Peak Usage22.4 Mb
Included Files768 files - 11.70 Mb
PrestaShop Cache- Mb
Global vars1.16 Mb
PrestaShop Version1.7.5.0
PHP Version7.2.33 (OK)
MySQL Version8.0.32 (OK)
Memory Limit15000M
Max Execution Time3000s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 41 ms 41 ms 5.46 Mb 5.50 Mb
__construct 0 ms 41 ms - Mb 5.50 Mb
init 274 ms 315 ms 2.67 Mb 8.25 Mb
checkAccess 0 ms 315 ms - Mb 8.25 Mb
setMedia 3 ms 318 ms 0.19 Mb 8.45 Mb
postProcess 0 ms 318 ms - Mb 8.45 Mb
initHeader 0 ms 318 ms - Mb 8.45 Mb
initContent 110 ms 428 ms 4.85 Mb 13.17 Mb
initFooter 0 ms 428 ms - Mb 13.17 Mb
display 375 ms 803 ms 8.22 Mb 22.39 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 459 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 240.5 31085 /classes/SpecificPrice.php:283 
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("2025-01-16 00:00:00",
INTERVAL 30 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 = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 5 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 5 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` = 5)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 62 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 7
 102.6 3033 Yes /classes/Category.php:1010 
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 62 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
 13.3 3033 /classes/Category.php:939 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayProductListReviews"
 8 1 /modules/ets_superspeed/classes/cache.php:389 
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`)
 7.1 7408 /classes/Configuration.php:160 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionDispatcher"
 6 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionDispatcherBefore"
 5.9 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayAfterBodyOpeningTag"
 5.1 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayProductExtraContent"
 3.8 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionFrontControllerSetMedia"
 3.7 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('845666cc9025ff8584ac98c9b4745957',"ps_categoryproducts|8785|62|1|1|1|5|1|21","", FROM_UNIXTIME(1736991345))
 3.6 1 /classes/Smarty/SmartyCustom.php:265 
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')
 3.6 1 /classes/ObjectModel.php:551 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="moduleRoutes"
 3.5 1 /modules/ets_superspeed/classes/cache.php:389 
UPDATE `ps_ets_superspeed_cache_page` SET `id_cache_page` = '119185',`page` = 'product',`id_object` = '8785',`id_product_attribute` = '0',`ip` = '172.71.223.161',`file_cache` = '0cf967329c67a19a335502781e16e7e58a3dbb7e94c49335fface00e34fc45e6',`request_uri` = '/es/pinzas-de-freno-y-repuestos/04-05-honda-cbr-1000-rr-pinza-de-freno-trasero2004-2005.html',`id_shop` = '1',`id_lang` = '5',`id_currency` = '1',`id_country` = '21',`has_customer` = '0',`has_cart` = '0',`click` = '1',`file_size` = '169.37',`user_agent` = '',`date_add` = '2025-01-16 02:35:45',`date_expired` = '2025-01-31 02:35:45' WHERE `id_cache_page` = 119185
 3.3 1 /classes/ObjectModel.php:718 
INSERT INTO `ps_ets_superspeed_cache_page` (`page`, `id_object`, `id_product_attribute`, `ip`, `file_cache`, `request_uri`, `id_shop`, `id_lang`, `id_currency`, `id_country`, `has_customer`, `has_cart`, `click`, `file_size`, `user_agent`, `date_add`, `date_expired`) VALUES ('product', '8785', '0', '172.71.223.161', '0cf967329c67a19a335502781e16e7e58a3dbb7e94c49335fface00e34fc45e6', '/es/pinzas-de-freno-y-repuestos/04-05-honda-cbr-1000-rr-pinza-de-freno-trasero2004-2005.html', '1', '5', '1', '21', '0', '0', '1', '0', '', '2025-01-16 02:35:45', '2025-01-31 02:35:45')
 3.1 1 /classes/ObjectModel.php:551 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayAfterTitleTag"
 3.1 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionOutputHTMLBefore"
 3 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayHeader"
 2.8 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayReassurance"
 2.8 1 /modules/ets_superspeed/classes/cache.php:389 
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`
 2.8 1515 Yes Yes /override/classes/Hook.php:155 
UPDATE `ps_smarty_lazy_cache`
SET filepath='ps_categoryproducts/8785/62/1/1/1/5/1/21/6b/3b/10/6b3b107aa97049305f39d4012053ba9ddff61c9e.pscategoryproductsviewste.php'
WHERE `template_hash`='845666cc9025ff8584ac98c9b4745957' AND cache_id="ps_categoryproducts|8785|62|1|1|1|5|1|21" AND compile_id=""
 2.7 1 /classes/Smarty/SmartyCustom.php:184 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayFooter"
 2.6 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('845666cc9025ff8584ac98c9b4745957',"ps_categoryproducts|8785|62|1|1|1|5|1|21","", FROM_UNIXTIME(1736991345))
 2.6 1 /classes/Smarty/SmartyCustom.php:265 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayBeforeBodyClosingTag"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionProductOutOfStock"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionFrontControllerAfterInit"
 2.5 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="overrideLayoutTemplate"
 2.4 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionObjectUpdateAfter"
 2.4 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayFooterProduct"
 2.4 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayNav1"
 2.3 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayNav2"
 2.3 1 /modules/ets_superspeed/classes/cache.php:389 
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
 2.2 558 /classes/Hook.php:413 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayProductAdditionalInfo"
 2.2 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('225352', '12945', '2890391457', '', '1', '1', '2025-01-16 02:35:45')
 2.2 1 /classes/ObjectModel.php:551 
SELECT SQL_NO_CACHE DISTINCT c.id_lgconsultas, c.*, r.respuesta FROM ps_lgconsultas c LEFT JOIN ps_lgconsultas_respuestas r ON c.id_lgconsultas=r.id_lgconsultas WHERE c.id_producto=8785  AND c.active=1 ORDER BY c.date_add DESC
 2.1 59895 Yes /modules/lgconsultas/lgconsultas.php:281 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayNavFullWidth"
 2 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="actionObjectAddAfter"
 1.9 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayFooterBefore"
 1.9 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayFooterAfter"
 1.8 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="DisplayOverrideTemplate"
 1.8 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayTop"
 1.7 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="119185", hook_name="displayProductPriceBlock"
 1.7 1 /modules/ets_superspeed/classes/cache.php:389 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('845666cc9025ff8584ac98c9b4745957',"ps_categoryproducts|8785|62|1|1|1|5|1|21","", FROM_UNIXTIME(1736991345))
 1.5 1 /classes/Smarty/SmartyCustom.php:265 
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 = 1  AND stock.id_shop_group = 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` = 8785
AND al.`id_lang` = 5
AND agl.`id_lang` = 5
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 1.3 1 Yes Yes /classes/Product.php:3915 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 1.3 200 /classes/CartRule.php:467 
(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` = 5) 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` = 5) 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)
 1.1 1 /classes/CartRule.php:400 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 1 1 /classes/Cart.php:4013 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 1 200 /classes/CartRule.php:467 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2025-01-16 00:00:00" AND date_to <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2025-01-16 00:00:00" AND date_from <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2025-01-16 00:00:00" AND date_to > "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 1 1 /classes/CartRule.php:341 
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 0 /classes/Hook.php:200 
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(
"2025-01-16 00:00:00",
INTERVAL 30 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` = 5 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 5 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` = 5)
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` = 8785 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 0.8 1 Yes /classes/Product.php:4003 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 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 = 5
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10010171
 0.7 1 /classes/ProductAssembler.php:90 
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` = 5)
WHERE i.`id_product` = 8785
ORDER BY `position`
 0.7 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgconsultas WHERE id_producto = 8785 AND active = 1 LIMIT 1
 0.7 605 /modules/lgconsultas/lgconsultas.php:301 
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
 0.7 231 Yes /classes/Dispatcher.php:634 
SELECT SQL_NO_CACHE a.`id_ce_content` AS id
FROM `ps_ce_content` a
LEFT JOIN `ps_ce_content_lang` `b` ON a.`id_ce_content` = b.`id_ce_content`
LEFT JOIN `ps_ce_content_shop` `c` ON c.`id_ce_content` = a.`id_ce_content` AND c.`id_shop` = b.`id_shop`
WHERE (b.`id_lang` = 5) AND (c.`id_shop` = 1) AND (a.`hook` LIKE "displayFooterProduct") AND (a.`active` = 1) AND (a.`id_product` = 0 OR a.`id_product` = 8785)
ORDER BY a.`id_product` DESC
 0.7 2 Yes /modules/creativeelements/classes/CEContent.php:138 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 0.6 200 /classes/CartRule.php:467 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10085232 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule ocr ON (ocr.id_order = o.id_order)
WHERE o.id_customer = 0
AND ocr.id_cart_rule = 1154 LIMIT 1
 0.6 1 /classes/order/Order.php:822 
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` = 8785 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` = 8785 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.6 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 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 = 5
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10077543
 0.6 1 /classes/ProductAssembler.php:90 
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` = 5
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.6 8 Yes Yes /classes/Category.php:1098 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 8785
ORDER BY f.position ASC
 0.6 5 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 24010000 AND `name` = "_elementor_page_settings" LIMIT 1
 0.6 1 /modules/creativeelements/classes/wrappers/Post.php:273 
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
 0.6 3 /classes/Currency.php:661 
SELECT SQL_NO_CACHE t.*
FROM `ps_arseopro_meta` t
LEFT JOIN `ps_arseopro_meta_rel` `mr` ON t.id_rule = mr.id_rule
WHERE (mr.rel_object IN (0, '8785') AND t.id_lang IN(0, 5) AND t.rule_type = 'product' AND t.status = 1) LIMIT 1
 0.6 1 /modules/arseopro/classes/meta/models/ArSeoProMetaTable.php:127 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 5 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 179 AND c.`nright` >= 180 AND c.`nleft` >= 2 AND c.`nright` <= 1061 ORDER BY `nleft` DESC
 0.6 91 /classes/Category.php:1538 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 8785 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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 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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10085232
ORDER BY f.position ASC
 0.5 6 Yes /classes/Product.php:4952 
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` = 5  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 62
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.5 1 Yes Yes /classes/Category.php:872 
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` = 5)
WHERE i.`id_product` = 10077543
ORDER BY `position`
 0.5 1 Yes /classes/Product.php:3042 
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` = 5)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
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` = 8785
 0.5 1 /classes/Product.php:6203 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 5 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 179 AND c.`nright` >= 180 AND c.`nleft` >= 2 AND c.`nright` <= 1061 ORDER BY `nleft` DESC
 0.5 91 /classes/Category.php:1538 
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` = 5
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 6) LIMIT 1
 0.5 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5828388db4bc450c21e463ddcb9b23a2' AND cache_id="stcolorname|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.5 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=8785
 0.5 3 /classes/Tag.php:229 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_address`
WHERE `id_customer` = 0
AND `deleted` = 0
 0.5 200 /classes/CartRule.php:467 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgconsultas WHERE id_producto = 8785 AND active = 1 LIMIT 1
 0.5 605 /modules/lgconsultas/lgconsultas.php:301 
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` = 10085232 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` = 10085232 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.5 0 /classes/Cart.php:1234 
(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` = 5) 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` = 5) 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.5 1 /classes/CartRule.php:400 
SELECT SQL_NO_CACHE * FROM `ps_psreassurance` pr
LEFT JOIN ps_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "5"
AND pr.status = 1
ORDER BY pr.position
 0.5 28 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10085232) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.5 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='042be9fe6a5a7c11ed5038619a5d89ff' AND cache_id="angarcontact|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.5 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 8785 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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 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` = 5)
WHERE i.`id_product` = 10010171
ORDER BY `position`
 0.5 1 Yes /classes/Product.php:3042 
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 101 /classes/module/Module.php:305 
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.rimotoshop.com' OR su.domain_ssl = 'www.rimotoshop.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.5 1 Yes /classes/shop/Shop.php:345 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 62 AND ctg.`id_group` = 1 LIMIT 1
 0.5 1 /classes/Category.php:1654 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10050903) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 1 Yes Yes /classes/Product.php:3860 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 5)
WHERE `level_depth` = 1
 0.4 4 /classes/Category.php:2130 
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.4 101 /classes/module/Module.php:305 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10010171) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.4 1 Yes Yes /classes/Product.php:3860 
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` = 62) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10010171 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.4 2 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10078819 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.4 1 Yes /classes/SpecificPrice.php:549 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 179) AND (a0.`nright` > 180) AND (a1.`id_lang` = 5)
ORDER BY a0.`nleft` asc
 0.4 364 /classes/PrestaShopCollection.php:373 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10050903 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.4 1 Yes /classes/SpecificPrice.php:549 
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.4 101 /classes/module/Module.php:305 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10078016
ORDER BY f.position ASC
 0.4 5 Yes /classes/Product.php:4952 
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.4 101 /classes/module/Module.php:305 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.4 3 Yes /classes/Currency.php:302 
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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8785) AND (b.`id_shop` = 1) LIMIT 1
 0.4 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 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, 21) AND
`id_group` IN (0, 1) AND `id_product` = 10077543 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-01-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-16 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.4 1 Yes /classes/SpecificPrice.php:549 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10085232
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.4 0 /classes/Product.php:6176 
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` = 5)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5)
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` = 8785
 0.4 1 /classes/Product.php:6203 
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2025-01-16 00:00:00" AND date_to <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2025-01-16 00:00:00" AND date_from <= "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2025-01-16 00:00:00" AND date_to > "2025-01-16 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
 0.4 1 /classes/CartRule.php:341 
SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page`
WHERE page="product" 
AND id_lang="5"
AND id_country = "21"
AND id_currency = "1"
AND id_shop="1"
AND user_agent=""
AND date_add > "2025-01-16 02:20:45"AND id_object="8785" AND has_customer=0 AND has_cart=0 LIMIT 1
 0.4 2 /modules/ets_superspeed/classes/cache.php:273 
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1
 0.4 1 /modules/lgcookieslaw/lgcookieslaw.php:161 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2025-01-16 00:00:00' AND '2025-01-16 23:59:59' LIMIT 1
 0.4 1 /classes/SpecificPrice.php:358 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 8785 LIMIT 1
 0.4 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE pc.*, CONCAT(c.firstname, ' ', (SUBSTRING(c.lastname,1,1)), '.') as customer,  ROUND( ( pc.stars / 2 ), 1) AS rating FROM ps_lgcomments_productcomments pc LEFT JOIN ps_customer as c ON pc.id_customer = c.id_customer WHERE pc.id_product = 8785  AND pc.active = 1 ORDER BY pc.position DESC
 0.4 1 Yes /modules/lgcomments/classes/LGProductComment.php:125 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8785   AND active = 1 LIMIT 1
 0.4 1 /modules/lgcomments/classes/LGProductComment.php:72 
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` = 8785
AND image_shop.`cover` = 1 LIMIT 1
 0.4 1 /classes/Product.php:3064 
SELECT SQL_NO_CACHE crc.id_cart_rule
FROM ps_cart_rule_country crc
WHERE crc.id_cart_rule = 1154
AND crc.id_country = 10 LIMIT 1
 0.4 1 /classes/CartRule.php:477 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.4 8 Yes /classes/ImageType.php:109 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 24010000 AND `name` = "_elementor_css" LIMIT 1
 0.4 1 /modules/creativeelements/classes/wrappers/Post.php:273 
SELECT SQL_NO_CACHE cp.`id_product` as id
FROM `ps_category_product` cp
WHERE cp.`id_category` = 0
ORDER BY `position` ASC
 0.4 1 /classes/Category.php:1955 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 61
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.4 1 Yes /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_orders` o
LEFT JOIN ps_order_cart_rule ocr ON (ocr.id_order = o.id_order)
WHERE o.id_customer = 0
AND ocr.id_cart_rule = 1174 LIMIT 1
 0.4 1 /classes/order/Order.php:822 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 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 = 5
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10085232
 0.4 1 /classes/ProductAssembler.php:90 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.4 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='14f3e6d3f5719f729bfd1d7275ccfb82' AND cache_id="ps_linklist|displayFooter|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.4 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9dd148274295a11b4e73a2d53e0a5215' AND cache_id="angarcontact|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.4 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 10 LIMIT 1
 0.4 1 /classes/Country.php:272 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 225352
AND `date_add` > '2025-01-16 02:05:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.4 1 Yes /classes/Connection.php:163 
SELECT SQL_NO_CACHE * FROM `ps_image_type`
 0.4 8 /classes/ImageType.php:147 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 8785030501 AND `name` = "_elementor_page_settings" LIMIT 1
 0.4 1 /modules/creativeelements/classes/wrappers/Post.php:273 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE * FROM `ps_arseopro_canonical_product` WHERE `id_product`=8785 AND `id_lang`=5 AND `id_shop` = 1 LIMIT 1
 0.3 1 /modules/arseopro/classes/canonical/ArSeoProCanonicalProduct.php:50 
SELECT SQL_NO_CACHE DISTINCT pl.name as name
FROM `ps_product_lang` pl
WHERE (pl.id_product = 8785) AND (pl.id_lang = 5 AND pl.id_shop = 1 ) LIMIT 1
 0.3 1 /classes/Product.php:6393 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.3 1 /classes/shop/ShopUrl.php:173 
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` = 10010171 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` = 10010171 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
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` = 10078819 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` = 10078819 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang` t
LEFT JOIN `ps_product_shop` ps ON t.`id_product` = ps.`id_product` AND t.`id_shop` = ps.`id_shop`
WHERE ((t.`link_rewrite` = '04-05-honda-cbr-1000-rr-pinza-de-freno-trasero2004-2005' OR t.`link_rewrite` = '04-05-honda-cbr-1000-rr-pinza-de-freno-trasero2004-2005') AND t.`id_lang` = 5 AND ps.`id_shop` = 1 AND ps.`active` = 1) LIMIT 1
 0.3 1 /modules/arseopro/classes/url/ArSeoProURLProduct.php:140 
SELECT SQL_NO_CACHE * FROM `ps_fbpsc_connector_position`
 0.3 7 /modules/facebookpsconnect/lib/module-dao_class.php:366 
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` = 10077867 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` = 10077867 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10010171
ORDER BY f.position ASC
 0.3 8 Yes /classes/Product.php:4952 
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` = 5)
WHERE i.`id_product` = 10050903
ORDER BY `position`
 0.3 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 62 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
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` = 5
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 161) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10078016) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 1 Yes Yes /classes/Product.php:3860 
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` = 10077543 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` = 10077543 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10085232 LIMIT 1
 0.3 1 /classes/SpecificPrice.php:416 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10050903
ORDER BY f.position ASC
 0.3 8 Yes /classes/Product.php:4952 
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` = 10078016 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` = 10078016 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
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` = 10050903 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` = 10050903 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
 0.3 0 /classes/Cart.php:1234 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 10078016 LIMIT 1
 0.3 1 /classes/Pack.php:85 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1
 0.3 0 /src/Adapter/Module/ModuleDataProvider.php:185 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 179) AND (a0.`nright` > 180) AND (a1.`id_lang` = 5)
ORDER BY a0.`nleft` asc
 0.3 364 /classes/PrestaShopCollection.php:373 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 19 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
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
 0.3 1 Yes /classes/shop/Shop.php:704 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 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 = 5
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10050903
 0.3 1 /classes/ProductAssembler.php:90 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10085232) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10077867) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 1 Yes Yes /classes/Product.php:3860 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10078819
ORDER BY f.position ASC
 0.3 8 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 10077543
 0.3 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='845666cc9025ff8584ac98c9b4745957' AND cache_id="ps_categoryproducts|8785|62|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.3 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 8785030501 AND `name` = "_elementor_edit_mode" LIMIT 1
 0.3 1 /modules/creativeelements/classes/wrappers/Post.php:273 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10077543
ORDER BY f.position ASC
 0.3 7 Yes /classes/Product.php:4952 
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 = 5)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5)
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 = 10077867
ORDER BY f.position ASC
 0.3 4 Yes /classes/Product.php:4952 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 2 AND `id_shop` = 1
 0.3 4 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 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 = 5
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10078016
 0.3 1 /classes/ProductAssembler.php:90 
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` = 2) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-16 00:00:00',
INTERVAL 30 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 = 5
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 10077867
 0.3 1 /classes/ProductAssembler.php:90 
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` = 5 AND cl.id_shop = 1 ) WHERE c.`id_category` = 62 LIMIT 1
 0.3 1 /classes/Category.php:1523 
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` = 5)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10077543) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.3 1 Yes Yes /classes/Product.php:3860 
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` = 10085232)
 0.3 1 /classes/Product.php:3342 
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` = 5)
WHERE i.`id_product` = 10085232
ORDER BY `position`
 0.3 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE `value` FROM ps_ce_meta WHERE `id` = 8785030501 AND `name` = "_wp_page_template" LIMIT 1
 0.3 1 /modules/creativeelements/classes/wrappers/Post.php:273 
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 8785 AND id_lang = 5 LIMIT 1
 0.3 1 /modules/lgconsultas/lgconsultas.php:257 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang` t
LEFT JOIN `ps_product_shop` ps ON t.`id_product` = ps.`id_product` AND t.`id_shop` = ps.`id_shop`
WHERE ((t.`link_rewrite` = '04-05-honda-cbr-1000-rr-pinza-de-freno-trasero2004-2005' OR t.`link_rewrite` = '04-05-honda-cbr-1000-rr-pinza-de-freno-trasero2004-2005') AND t.`id_lang` = 5 AND ps.`id_shop` = 1 AND ps.`id_category_default` IN (62) AND ps.`active` = 1) LIMIT 1
 0.3 1 /modules/arseopro/classes/url/ArSeoProURLProduct.php:172 
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` = 19) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
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` = 12) LIMIT 1
 0.3 1 /src/Adapter/EntityMapper.php:75 
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 = 8785 LIMIT 1
 0.3 1 /classes/Product.php:845 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 8785
 0.3 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 10010171
 0.3 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
 0.3 185 /classes/Tab.php:318 
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` = 5 AND cl.id_shop = 1 ) WHERE c.`id_category` = 62 LIMIT 1
 0.3 1 /classes/Category.php:1523 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 8785
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.3 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa
WHERE pa.`id_product` = 8785
 0.3 1 /classes/Product.php:6145 
SELECT SQL_NO_CACHE *
FROM `ps_ce_template` a
WHERE (a.`id_ce_template` = 24) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
 0.2 1 /classes/Smarty/SmartyCustom.php:96 
SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page` WHERE file_cache = "0cf967329c67a19a335502781e16e7e58a3dbb7e94c49335fface00e34fc45e6" AND id_shop="1" LIMIT 1
 0.2 1 /modules/ets_superspeed/classes/cache.php:302 
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` = 8785)
 0.2 1 /classes/Product.php:3342 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10078016) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8785 AND active = 1  AND stars >= 10 AND stars < 11 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:183 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10077867) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 363 AND `id_shop` = 1 LIMIT 1
 0.2 1 /classes/module/Module.php:2277 
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` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8785) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' LIMIT 1
 0.2 1 /classes/Country.php:192 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
 0.2 1 /classes/Page.php:100 
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` = 5)
WHERE i.`id_product` = 10077867
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 10 LIMIT 1
 0.2 1 /classes/AddressFormat.php:618 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 10050903
 0.2 1 /classes/Product.php:2465 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leoproductsearch" LIMIT 1
 0.2 0 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE SUM(stars) FROM ps_lgcomments_productcomments WHERE id_product = 8785   AND active = 1 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:93 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 8785 AND ctg.`id_group` = 1 LIMIT 1
 0.2 1 /classes/Product.php:5502 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c 
WHERE c.`id_category` = 2 LIMIT 1
 0.2 1 /classes/Category.php:1529 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.2 1 /classes/module/Module.php:2752 
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` = 5
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 42) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
 0.2 1 /classes/Smarty/SmartyCustom.php:143 
SELECT SQL_NO_CACHE COUNT(id_productcomment) FROM ps_lgcomments_productcomments WHERE id_customer = 0 AND id_product = 8785 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:196 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 10085232
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.2 0 /classes/SpecificPrice.php:246 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 10085232 LIMIT 1
 0.2 1 /classes/Pack.php:85 
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` = 5)
WHERE i.`id_product` = 10078016
ORDER BY `position`
 0.2 1 Yes /classes/Product.php:3042 
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 8785 LIMIT 1
 0.2 1 /classes/Page.php:80 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8785) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 8785) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10077867
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.2 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8785 AND active = 1 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:144 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
 0.2 1 /classes/Category.php:1870 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10078819) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 8785) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10077543) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10050903) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
 0.2 5 /classes/Language.php:1029 
SELECT SQL_NO_CACHE link_rewrite FROM ps_product_lang WHERE id_product = 8785 AND id_lang = 5 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:209 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='058b80ee450a0518c27219c45cd7a0d3' AND cache_id="ps_customeraccountlinks|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.2 1 /classes/Smarty/SmartyCustom.php:216 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10010171
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.2 0 /classes/Product.php:6176 
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10010171) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10077543
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.2 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "gformbuilderpro" LIMIT 1
 0.2 1 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a8764711b3c842f7de5222ce4c150c7c' AND cache_id="ps_socialfollow|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.2 1 /classes/Smarty/SmartyCustom.php:216 
SELECT SQL_NO_CACHE *
FROM `ps_state` a
WHERE (a.`id_state` = 130) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10050903
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.2 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ba_ajax_search" LIMIT 1
 0.2 0 /classes/module/Module.php:2752 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10078016
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.2 0 /classes/Product.php:6176 
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` = 5)
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` = 5)
WHERE pa.`id_product` = 10078819
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 5
 0.2 0 /classes/Product.php:6176 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 10
 0.2 4 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE cl.`id_category` FROM `ps_category_lang` cl LEFT JOIN `ps_category` c ON cl.id_category = c.id_category WHERE cl.`id_shop` = 1 AND cl.`link_rewrite` = "pinzas-de-freno-y-repuestos" AND cl.`id_lang` = 5
 0.2 1 /modules/arseopro/classes/url/ArSeoProURLCategory.php:375 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8785 AND active = 1  AND stars >= 2 AND stars < 4 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:183 
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` = 10078819)
 0.2 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 5 AND id_category = 62 LIMIT 1
 0.2 1 /classes/Product.php:4725 
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` = 10050903)
 0.2 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1
 0.2 0 /classes/module/Module.php:2752 
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 62) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 8785 AND active = 1  AND stars >= 0 AND stars < 2 LIMIT 1
 0.2 1 /modules/lgcomments/classes/LGProductComment.php:183 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 327 AND `id_shop` = 1 LIMIT 1
 0.2 1 /classes/module/Module.php:2277 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.2 1 /classes/Country.php:192 
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` = 10077543)
 0.2 1 /classes/Product.php:3342 
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` = 10010171)
 0.2 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c 
WHERE c.`id_category` = 2 LIMIT 1
 0.2 1 /classes/Category.php:1529 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
 0.2 1 /src/Adapter/Module/ModuleDataProvider.php:185 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.2 0 /classes/module/Module.php:2277 
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 62
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/ObjectModel.php:1588 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 5 AND id_category = 62 LIMIT 1
 0.2 1 /classes/Product.php:4725 
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
 0.2 1 /classes/ObjectModel.php:1453 
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` = 10077867)
 0.2 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 53) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 42
AND `active` = 1 LIMIT 1
 0.2 1 /classes/Manufacturer.php:310 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 53
 0.2 7 /src/Adapter/EntityMapper.php:82 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ffa1d4adc0c9ac5814180b89d03157e2' AND cache_id="angarcontact|1|1|1|5|1|21" AND compile_id="" LIMIT 1
 0.2 1 /classes/Smarty/SmartyCustom.php:216 
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` = 10078016)
 0.2 1 /classes/Product.php:3342 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.2 83 /classes/Hook.php:244 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.2 1 /classes/module/Module.php:2188 
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 8785
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-01-16 00:00:00",
INTERVAL 30 DAY
)
) > 0
 0.2 0 /classes/Product.php:1399 
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` = 3) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
 0.2 1 /classes/Country.php:192 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10085232) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:441 
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)
 0.2 5 /classes/Language.php:882 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 10085232 AND `id_group` = 1 LIMIT 1
 0.2 0 /classes/GroupReduction.php:151 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /classes/shop/Shop.php:201 
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 8785
 0.2 1 /classes/Pack.php:160 
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 0 LIMIT 1
 0.2 0 /classes/Country.php:272 
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 161
AND `active` = 1 LIMIT 1
 0.2 1 /classes/Manufacturer.php:310 
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` = 5
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 111) LIMIT 1
 0.2 1 /src/Adapter/EntityMapper.php:75