Mascota leñador barbudo especial para noches temáticas - MASFR00637 - Mascotas humanas Ver más grande

Mascota leñador barbudo especial para noches temáticas

419,00 €

Nuevo producto

Hombre leñador traje de la mascota a la venta en nuestros trajes de la tienda en línea con todos sus accesorios. Con nuestro hombre disfrazado con barba, organizar fiestas especiales o eventos promocionales primera opción. Con nuestros trajes especiales, diversión, evento será el éxito puro. Envío rápido con los accesorios. Servicio para usted.

Más detalles

TamañoS (160-170 CM) | M (170-175 CM) | L (175-180 CM) | XL (180-185 CM) | XXL (185-190 CM) | XXXL (190-195 CM) | Tamaño Del Niño | XXXXL (195-225 CM)
PaqueteUna
Grupo de edadAdultos
SexoMujer | Hombre | Unisexo
EquipoEspuma De Polietileno | Fibra De Vidrio | Nylon
CalidadPrima | Acabados Incluidos
EntregaNacional | Internationale

Generales características del producto:

Traje de la mascota se vende en nuestro sitio SpotSound especializada en el alquiler de equipos de luz y sonido en París y la región de Ile de France y en la venta de mascotas, disfraces y trajes para Europa en Internet. Nuestros trajes de la mascota son ideales para varias ventas y marketing, o simplemente para su evento público o privado, o simplemente para una noche de fiesta con los amigos. Aclaramos que no hacemos el alquiler de disfraces, disfraces o mascotas de Paris por razones prácticas. Tenemos en stock o en orden de más de 5000 modelos!


Los trajes de la mascota se hacen de tres partes: la cabeza, que cubre la cabeza del polyfoam rígido con el marco para la estabilidad, el cuerpo en nylon y algodón sintético (elija su tamaño) y accesorios que van desde zapatos (opción del tamaño ), guantes o adiciones a su petición. Los accesorios como la tela son lavables a máquina en agua tibia casi tan frío y planchada. Podemos personalizar cualquier mascota de acuerdo a su solicitud: Además del logotipo, cambio de color, ajuste de tamaño o solicitud especial. Nuestro equipo está a su disposición, ya sea por correo electrónico, teléfono o en nuestras diversas plataformas de apoyo en línea.
Nuestras mascotas se entregan principalmente en Europa, pero podemos asegurar las entregas en todo el mundo por repartidores internacionales a menores costos. Los números de seguimiento serán fotos de las mascotas de la acción o de descanso se toman directamente de las instalaciones de fabricación de nuestros trajes. Todos nuestros trajes cumplen con los estándares.


Este producto contiene:

Mascot 1: Tejido interior y lavable luz permeable con el aire
Accesorios incluidos: ropa del cuerpo, zapatos, guantes, (cuerpo de la mascota con la cremallera en la parte posterior). Para otros accesorios, póngase en contacto con nosotros a través de la página de personalización.

El peso aproximado es de alrededor de 6 libras - Embalaje por su parte es: 60 * 60 * 50CM (longitud, anchura, altura)

El traje de la mascota está disponible en propuestas 7.5 tamaños (elegir en el pedido): de S a XXL con la posibilidad de un tamaño menor (foto a petición). Modificado para requisitos particulares a su tamaño de la petición, pero las normas actuales deben ponerse de acuerdo.


Envío:

Off con el número de parcela en 7/10 días laborables siguientes a la recepción y confirmación de su pago dependiendo de la acción día disponibles.
Servicio de antes / vender a usted por correo electrónico.


Nota: se multiplican las características generales anteriores por el número de personas que se ven en las fotos de arriba.

No hay ninguna opinión por el momento.


Solo los usuarios que ya compraron el producto pueden agregar una revisión.

No hay preguntas de clientes por el momento.


Su pregunta ha sido enviada exitosamente a nuestro equipo. Gracias por la pregunta!
Hacer una pregunta
ocultar formulario
Opciones de Producto
  
  Cantidad:
Tamaño
Tamaño
 
Tamaño Niño
[Resta 15,00 €]
 
S (160-170 Cm)
 
 
M (170-180 Cm)
 
 
L (180-190 Cm)
 
 
Xl (190-200 Cm)
 
 
Xxl (200-220 Cm)
 
Cambio de color
Cambio de color
 
Ningún Cambio
 
 
1 Cambio De Color
[Añade 30,00 €]
 
2 Cambios De Color
[Añade 40,00 €]
 
3 Cambios De Color
[Añade 50,00 €]
Comentario de color (código HEX, RGB, etc .. código)
Comentario de color (código HEX, RGB, etc .. código)
Comentario De Color (Si El Cambio Seleccionado) 
 
Adición de logotipo
Adición de logotipo
Sí - Jefe / Sombrero
 
[Añade 20,00 €]
Sí - Hombros X2
 
[Añade 30,00 €]
Sí - Espalda(De Pequeño Formato)
 
[Añade 30,00 €]
Sí - Espalda (De Gran Formato)
 
[Añade 50,00 €]
Sí - En El Pecho (Pequeño Formato)
 
[Añade 30,00 €]
Sí - Torso (De Gran Formato)
 
[Añade 50,00 €]
Sí - Rodillas X2
 
[Añade 20,00 €]
Adición de texto
Adición de texto
Sí - Jefe / Sombrero 
 
[Añade 20,00 €]
Sí - Torso (Pequeño Formato ) 
 
[Añade 30,00 €]
Sí - Torso (De Gran Formato) 
 
[Añade 40,00 €]
Sí - Espalda(De Pequeño Formato) 
 
[Añade 30,00 €]
Sí - Espalda (De Gran Formato) 
 
[Añade 40,00 €]
Con la ropa ? (si está presente en la foto)
Con la ropa ? (si está presente en la foto)
 
No
 
 
[Añade 20,00 €]
Accesorios
Accesorios
No
 
No
Sombrero
 
Sombrero
[Añade 30,00 €]
Pompones X2
 
Pompones X2
[Añade 15,00 €]
Empate
 
Empate
[Añade 15,00 €]
Gafas
 
Gafas
[Añade 20,00 €]
Relleno Vientre
 
Relleno Vientre
[Añade 60,00 €]
Fan
 
Fan
[Añade 40,00 €]
Zapatos
 
Zapatos
[Añade 50,00 €]
Accesorio De Elección
 
Accesorio De Elección
[Añade 50,00 €]
Boceto (antes de la fabricación)
Boceto (antes de la fabricación)
 
No
 
 
[Añade 40,00 €]
  
  Cantidad:
30 otros productos en la misma categoría:
Load Time14871 ms - You'd better run your shop on a toaster
Querying Time5440 ms
Queries2198
Memory Peak Usage82.4 Mb
Included Files414 files - 8.05 Mb
PrestaShop Cache- Mb
Global vars3.01 Mb
PrestaShop Version1.6.1.8
PHP Version5.6.40-0+deb8u12 (OK)
MySQL Version10.0.38-MariaDB-0+deb8u1 (OK)
Memory Limit4096M
Max Execution Time6000s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 217 ms 217 ms 8.65 Mb 8.88 Mb
__construct 0 ms 217 ms - Mb 8.88 Mb
init 132 ms 350 ms 3.50 Mb 12.40 Mb
checkAccess 0 ms 350 ms - Mb 12.40 Mb
setMedia 7 ms 357 ms 0.07 Mb 12.46 Mb
postProcess 0 ms 357 ms - Mb 12.46 Mb
initHeader 0 ms 357 ms - Mb 12.46 Mb
initContent 10018 ms 10374 ms 56.34 Mb 69.12 Mb
initFooter 385 ms 10759 ms 3.99 Mb 75.15 Mb
display 4112 ms 14871 ms 7.61 Mb 82.45 Mb
Hook Time Memory Usage
hookproductfooter 7939 ms 34.00 Mb
hookdisplayProductListReviews 1058 ms 9.50 Mb
__construct 635 ms 21.50 Mb
hookvegamenu 485 ms 1.50 Mb
hookdisplayTop 469 ms 2.75 Mb
hookheader 286 ms 2.25 Mb
hookfooter 197 ms 1.75 Mb
hookdisplayHeader 115 ms - Mb
hookmegamenu 112 ms 2.00 Mb
hookproducttabcontent 85 ms - Mb
hookdisplayRightColumnProduct 44 ms 0.75 Mb
hooktop 31 ms 0.25 Mb
hookdisplayFooter 25 ms - Mb
hookdisplayNav 17 ms - Mb
hookproductactions 13 ms - Mb
hookdisplayProductTabContent 7 ms - Mb
hookextraleft 4 ms 0.25 Mb
hookdisplayFooterProduct 4 ms - Mb
hookblockFooterExtra 3 ms - Mb
hookextraright 3 ms 0.25 Mb
hookproducttab 3 ms - Mb
hookblockFooter1 3 ms - Mb
hookdisplayLeftColumnProduct 2 ms - Mb
hookblockFooter2 2 ms - Mb
hookdisplayProductTab 1 ms - Mb
hookblockFooter4 1 ms - Mb
hookblockFooter3 1 ms - Mb
hookdisplayProductButtons 1 ms - Mb
hookDisplayOverrideTemplate 1 ms - Mb
hookmoduleRoutes 1 ms - Mb
hookactionProductOutOfStock - ms - Mb
31 hooks 11550 ms 76.75 Mb
Module Time Memory Usage
productscategory 6267 ms 30.50 Mb
attributewizardpro 1685 ms 4.75 Mb
contentpack 730 ms 8.50 Mb
gsnippetsreviews 634 ms 6.25 Mb
posvegamenu 506 ms 1.50 Mb
possearchcategories 473 ms 2.25 Mb
blockcategories 175 ms - Mb
fbloginblock 173 ms 2.00 Mb
posmegamenu 116 ms 2.25 Mb
facebookpsessentials 83 ms 1.00 Mb
stripe_official 72 ms 1.75 Mb
internationaltargeting 64 ms - Mb
tawkto 61 ms 0.50 Mb
posstaticfooter 45 ms 2.00 Mb
seoexpert 40 ms 1.25 Mb
pm_modalcart3 35 ms 0.75 Mb
htmlboxpro 34 ms 1.25 Mb
ganalytics 30 ms 1.00 Mb
blockwishlist 29 ms 0.25 Mb
blockcart 25 ms 0.50 Mb
blockmyaccountfooter 25 ms - Mb
artfreegdpr 21 ms 1.50 Mb
blockcurrencies 20 ms 0.50 Mb
blockviewed 19 ms 0.25 Mb
websitetranslator 19 ms 0.25 Mb
mailalerts 18 ms 2.50 Mb
facebookpsshoptab 18 ms 0.25 Mb
posthemeoption 17 ms 0.25 Mb
blocknewsletter 12 ms 0.50 Mb
smartblog 11 ms 0.75 Mb
favoriteproducts 10 ms - Mb
posstaticblocks 9 ms 0.25 Mb
blocklanguages 9 ms - Mb
blockcms 9 ms 0.25 Mb
blockcontact 8 ms - Mb
sendtoafriend 7 ms 0.25 Mb
blockuserinfo 6 ms - Mb
psseobooster 5 ms - Mb
posspecialproducts 4 ms 0.25 Mb
posslideshow 4 ms - Mb
infinitescroll 3 ms 0.50 Mb
blockmanufacturer 3 ms 0.25 Mb
blocksupplier 3 ms - Mb
blockpaymentlogo 3 ms - Mb
pm_multiplefeatures 3 ms - Mb
blockmyaccount 3 ms - Mb
46 modules 11550 ms 76.75 Mb

Stopwatch SQL - 2198 queries

Query Time (ms) Rows Filesort Group By Location
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("2021-01-20 00:00:00",
INTERVAL 1000 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` = 14 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 14 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` = 14)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 9883003 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100
2055.6 182277 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 369669 LIMIT 1
103.3 1 /classes/Combination.php:344
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`)
21.2 9048 /classes/Configuration.php:148
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 637 AND `id_shop` = 1
14.4 12 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 368633 LIMIT 1
13 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23723|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
12.6 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='blockcategories/1/4/4/14/1/21/9883003/4/5b/d8/37/5bd837ac47c60610a5a73dbb2f6ed98c86ed7173.blockcategories_footer.tpl.php'
WHERE `template_hash`='f19000fcda7f38bfdc7cff8c81c5dd1d' AND cache_id="blockcategories|1|4|4|14|1|21|9883003|4" AND compile_id=""
12.2 1 /classes/SmartyCustom.php:183
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
12.1 13 /classes/Language.php:894
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23548
ORDER BY `id_specific_price_priority` DESC LIMIT 1
12.1 0 /classes/SpecificPrice.php:198
UPDATE `ps_smarty_lazy_cache`
SET filepath='23760/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23760|1|4|4|14|1|21" AND compile_id=""
11.7 1 /classes/SmartyCustom.php:183
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 = 28577 LIMIT 1
11.6 37 /classes/Product.php:752
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 20439
ORDER BY f.position ASC
11.4 8 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21597|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
11.3 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='productscategory/637/9883003/1/4/4/14/1/21/ea/c0/77/eac0771dfb331f2f2c41ed4186abae6888e44e08.productscategory.tpl.php'
WHERE `template_hash`='83b6732a48d65fe35e1cf970ad056af2' AND cache_id="productscategory|637|9883003|1|4|4|14|1|21" AND compile_id=""
11.3 1 /classes/SmartyCustom.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` = 20404)
11.1 37 /classes/Product.php:2998
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 = 637
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
10.9 0 /classes/Product.php:1278
SET wait_timeout = 10000
10.9 1 /modules/websitetranslator/websitetranslator.php:120
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 21597 AND deleted = 0  
AND id_shop = 1 LIMIT 1
10.8 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21008) AND (b.`id_shop` = 1) LIMIT 1
10.3 1 /Adapter/Adapter_EntityMapper.php:61
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
10.3 300 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 21487
ORDER BY `id_specific_price_priority` DESC LIMIT 1
10 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
9.8 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='23723/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23723|1|4|4|14|1|21" AND compile_id=""
9.5 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371223 LIMIT 1
9.4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 20003
ORDER BY f.position ASC
9.3 8 Yes /classes/Product.php:4453
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
9.3 0 /classes/Category.php:1219
UPDATE `ps_smarty_lazy_cache`
SET filepath='23346/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23346|1|4|4|14|1|21" AND compile_id=""
9.2 1 /classes/SmartyCustom.php:183
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882814) AND (b.`id_shop` = 1) LIMIT 1
9.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371260 LIMIT 1
9.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 23554 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
9.1 0 /modules/contentpack/classes/reviewshelp.class.php:438
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 = 637
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
9 0 /classes/Product.php:1278
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20474) AND (b.`id_shop` = 1) LIMIT 1
9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22317
ORDER BY `id_specific_price_priority` DESC LIMIT 1
9 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23760
ORDER BY `id_specific_price_priority` DESC LIMIT 1
9 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23971
ORDER BY f.position ASC
8.9 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
8.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE id_product FROM `ps_category_product` WHERE `id_product` = 637 AND `id_category` IN (9883003) LIMIT 1
8.9 2 /classes/Product.php:4885
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
8.7 0 /classes/Category.php:1219
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23633|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
8.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23708|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
8.7 1 /classes/SmartyCustom.php:263
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
8.6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE * FROM `ps_hbp_block` AS a INNER JOIN `ps_hbp_block_lang` AS b ON a.id=b.id WHERE a.hook="productActions" AND active=1 AND b.id_lang=14  ORDER BY a.position
8.6 45 Yes /modules/htmlboxpro/htmlboxpro.php:233
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` = 14
AND c.`id_parent` = 9883048
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
8.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
8.4 16 Yes /classes/SpecificPrice.php:361
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21842) AND (b.`id_shop` = 1) LIMIT 1
8.4 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='23378/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23378|1|4|4|14|1|21" AND compile_id=""
8.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21348) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.3 0 /classes/stock/StockAvailable.php:378
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` = 24047)
8.2 37 /classes/Product.php:2998
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
8.2 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 17
AND cl.id_shop = 1 
AND cl.`id_category` = 9883003 LIMIT 1
8.1 1 /classes/Category.php:1054
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 = 24083 LIMIT 1
7.8 37 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22096|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
7.8 1 /classes/SmartyCustom.php:263
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` = 23754)
7.8 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370224 LIMIT 1
7.8 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21616|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
7.8 1 /classes/SmartyCustom.php:263
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 = 20813 LIMIT 1
7.7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21597) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.7 0 /classes/stock/StockAvailable.php:378
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"23723|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
7.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9883004"
7.6 6 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23633
ORDER BY f.position ASC
7.6 8 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"23994|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
7.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 2076
ORDER BY f.position ASC
7.5 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23994 AND `id_group` = 4 LIMIT 1
7.4 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.4 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23657|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
7.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20003 AND `id_group` = 4 LIMIT 1
7.4 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 21348
ORDER BY f.position ASC
7.4 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22204
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22199) AND (id_product_attribute = 370187) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23554
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.3 0 /classes/SpecificPrice.php:198
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22096) AND (b.`id_shop` = 1) LIMIT 1
7.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372777 LIMIT 1
7.2 1 /classes/Combination.php:344
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883004) AND (b.`id_shop` = 1) LIMIT 1
7.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22064
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.2 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.2 16 Yes /classes/SpecificPrice.php:361
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22437) AND (b.`id_shop` = 1) LIMIT 1
7.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21686) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.2 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24297 AND id_shop=1 LIMIT 1
7.2 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 22437
ORDER BY f.position ASC
7.2 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23723 AND `id_group` = 4 LIMIT 1
7.2 0 /classes/GroupReduction.php:149
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23346) AND (b.`id_shop` = 1) LIMIT 1
7.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370520 LIMIT 1
7.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20439) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.1 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23992
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.1 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23493 AND `id_group` = 4 LIMIT 1
7.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24083 AND `id_group` = 4 LIMIT 1
7.1 0 /classes/GroupReduction.php:149
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23554|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
7.1 1 /classes/SmartyCustom.php:263
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882934) AND (b.`id_shop` = 1) LIMIT 1
7.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20898) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.1 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21616) AND (id_product_attribute = 369632) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
6.9 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
6.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 369225 LIMIT 1
6.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371334 LIMIT 1
6.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370557 LIMIT 1
6.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372222 LIMIT 1
6.9 1 /classes/Combination.php:344
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` = 14
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 44) LIMIT 1
6.8 1 /Adapter/Adapter_EntityMapper.php:61
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` = 637) AND (b.`id_shop` = 1) LIMIT 1
6.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
6.8 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20813) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24297 AND `id_group` = 4 LIMIT 1
6.7 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21487 AND id_shop=1 LIMIT 1
6.7 1 /classes/Product.php:5032
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` = 14
AND c.`id_parent` = 9882943
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.7 1 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24084|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
6.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 1 LIMIT 1
6.7 1 /classes/Category.php:1477
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23346|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
6.7 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='23554/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23554|1|4|4|14|1|21" AND compile_id=""
6.7 1 /classes/SmartyCustom.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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21597) AND (b.`id_shop` = 1) LIMIT 1
6.6 1 /Adapter/Adapter_EntityMapper.php:61
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` = 23554)
6.6 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 28583 AND `id_group` = 4 LIMIT 1
6.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 22204
ORDER BY f.position ASC
6.6 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21564|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.6 1 /classes/SmartyCustom.php:215
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882940) AND (b.`id_shop` = 1) LIMIT 1
6.5 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883082) AND (b.`id_shop` = 1) LIMIT 1
6.5 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
AND c.`id_parent` = 9883039
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 22064
ORDER BY f.position ASC
6.5 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 7 AND `id_shop` = 1 LIMIT 1
6.5 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20849) AND (id_product_attribute = 369077) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.5 0 /classes/stock/StockAvailable.php:378
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 = 21686 LIMIT 1
6.5 37 /classes/Product.php:752
SELECT SQL_NO_CACHE nleft, nright FROM `ps_category` WHERE id_category = 9883003 LIMIT 1
6.4 1 /classes/Category.php:1512
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21616) AND (b.`id_shop` = 1) LIMIT 1
6.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882889) AND (b.`id_shop` = 1) LIMIT 1
6.4 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='23657/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23657|1|4|4|14|1|21" AND compile_id=""
6.4 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23378|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372703 LIMIT 1
6.2 1 /classes/Combination.php:344
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883019) AND (b.`id_shop` = 1) LIMIT 1
6.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23378|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
6.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
6.1 16 Yes /classes/SpecificPrice.php:361
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` = 14
AND c.`id_parent` = 9883034
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.1 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372370 LIMIT 1
6.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 24065 LIMIT 1
6.1 37 /classes/Product.php:765
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22102 AND `id_group` = 4 LIMIT 1
6.1 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 28577
ORDER BY f.position ASC
6 8 Yes /classes/Product.php:4453
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` = 14
AND c.`id_parent` = 9882930
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6 1 Yes Yes /classes/Category.php:859
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20849) AND (b.`id_shop` = 1) LIMIT 1
6 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22199|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 44
AND `active` = 1 LIMIT 1
5.9 1 /classes/Manufacturer.php:248
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` = 14
AND c.`id_parent` = 9882944
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.9 1 Yes Yes /classes/Category.php:859
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882951) AND (b.`id_shop` = 1) LIMIT 1
5.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371593 LIMIT 1
5.8 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21616|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
5.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
5.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 24045
ORDER BY f.position ASC
5.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.8 0 /classes/stock/StockAvailable.php:378
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 = 21905 LIMIT 1
5.7 37 /classes/Product.php:752
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` = 55) LIMIT 1
5.7 1 /Adapter/Adapter_EntityMapper.php:61
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 = 24297 LIMIT 1
5.7 37 /classes/Product.php:752
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883011) AND (b.`id_shop` = 1) LIMIT 1
5.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 20266
ORDER BY f.position ASC
5.7 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23550 AND `id_group` = 4 LIMIT 1
5.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21236) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.6 0 /classes/stock/StockAvailable.php:378
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 = 2076 LIMIT 1
5.6 37 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23563|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
5.6 1 /classes/SmartyCustom.php:263
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883032) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pa.id_product, pas.price, pas.weight, pas.minimal_quantity, pac.id_attribute
FROM `ps_product_attribute` AS pa,`ps_product_attribute_shop` AS pas, `ps_product_attribute_combination` AS pac
WHERE pas.id_shop = 1 AND (pas.default_on = 0 OR pas.default_on IS NULL) AND pas.id_product_attribute = pac.id_product_attribute AND pas.id_product_attribute = pa.id_product_attribute AND pa.id_product = 637 GROUP BY pac.id_attribute
5.5 38 Yes Yes /modules/attributewizardpro/attributewizardpro.php:2267
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20439) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
AND c.`id_parent` = 9882810
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24093 AND `id_group` = 4 LIMIT 1
5.5 0 /classes/GroupReduction.php:149
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` = 14
AND c.`id_parent` = 9882811
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24064 AND id_shop=1 LIMIT 1
5.5 1 /classes/Product.php:5032
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"24065|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
5.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23970) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371556 LIMIT 1
5.4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="23378|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 28684
ORDER BY f.position ASC
5.4 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 20867 AND id_shop=1 LIMIT 1
5.4 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24083) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23708 AND id_shop=1 LIMIT 1
5.3 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f19000fcda7f38bfdc7cff8c81c5dd1d' AND cache_id="blockcategories|1|4|4|14|1|21|9883003|4" AND compile_id="" LIMIT 1
5.3 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='21236/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21236|1|4|4|14|1|21" AND compile_id=""
5.2 1 /classes/SmartyCustom.php:183
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
5.2 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23973 AND `id_group` = 4 LIMIT 1
5.2 0 /classes/GroupReduction.php:149
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 = 637 LIMIT 1
5.2 38 /classes/Product.php:752
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`,
ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, pa.`unit_price_impact`, IFNULL(stock.quantity, 0) as quantity
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` AND al.`id_lang` = 14)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 14)
WHERE pa.`id_product` = 637 
GROUP BY pa.`id_product_attribute`, a.`id_attribute`
ORDER BY pa.`id_product_attribute`
5.2 38 Yes Yes /modules/attributewizardpro/attributewizardpro.php:1941
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24047|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
5.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 14
AND `active` = 1
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
5.1 153 Yes /modules/possearchcategories/possearchcategories.php:306
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
5.1 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23754) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.1 0 /classes/stock/StockAvailable.php:378
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882916) AND (b.`id_shop` = 1) LIMIT 1
5.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24083|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23799|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2021-01-20 00:00:00' AND '2021-01-20 23:59:59' LIMIT 1
5 775 /classes/SpecificPrice.php:305
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="24083|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5 1 /classes/SmartyCustom.php:215
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` = 14)
WHERE i.`id_product` = 637
ORDER BY `position`
4.9 1 Yes /classes/Product.php:2723
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21597|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370187 LIMIT 1
4.8 1 /classes/Combination.php:344
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
4.8 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 23974 LIMIT 1
4.8 37 /classes/Product.php:765
SELECT SQL_NO_CACHE `link_rewrite` FROM `ps_category_lang` WHERE `id_category` = 1 LIMIT 1
4.8 13 /modules/facebookpsshoptab/facebookpsshoptab.php:1845
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882946) AND (b.`id_shop` = 1) LIMIT 1
4.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (367932, 367933, 367934, 367935, 367936, 367937, 367938, 367939, 367940, 367941, 367942, 367943, 367944, 367945, 367946, 367947, 367948, 367949, 367950, 367951, 367952, 367953, 367954, 367955, 367956, 367957, 367958, 367959, 367960, 367961, 367962, 367963, 367964, 367965, 367966, 367967, 367968, 792640) AND il.`id_lang` = 14 ORDER by i.`position`
4.8 1 Yes /classes/Product.php:2186
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 28685 LIMIT 1
4.8 37 /classes/Product.php:765
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371186 LIMIT 1
4.7 1 /classes/Combination.php:344
UPDATE `ps_smarty_lazy_cache`
SET filepath='23971/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23971|1|4|4|14|1|21" AND compile_id=""
4.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='24093/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24093|1|4|4|14|1|21" AND compile_id=""
4.7 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 22102
ORDER BY f.position ASC
4.7 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
4.7 139 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
4.7 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 637) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.7 1 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882959 AND `id_shop` = 1
4.7 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24084
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.7 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 23982 LIMIT 1
4.6 37 /classes/Product.php:765
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21746 AND id_shop=1 LIMIT 1
4.6 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 24025
ORDER BY f.position ASC
4.6 8 Yes /classes/Product.php:4453
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22353) AND (b.`id_shop` = 1) LIMIT 1
4.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
4.6 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371667 LIMIT 1
4.6 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23548
ORDER BY f.position ASC
4.6 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_58"
4.5 6 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21842 AND id_shop=1 LIMIT 1
4.5 1 /classes/Product.php:5032
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 = 637
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
4.5 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23364 AND `id_group` = 4 LIMIT 1
4.5 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372333 LIMIT 1
4.5 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 21597
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.5 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23723
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.5 0 /classes/SpecificPrice.php:198
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 28650) AND (b.`id_shop` = 1) LIMIT 1
4.5 1 /Adapter/Adapter_EntityMapper.php:61
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`=637
4.4 53 /classes/Tag.php:205
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24007
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.4 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21842 AND `id_group` = 4 LIMIT 1
4.4 0 /classes/GroupReduction.php:149
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` = 14
AND c.`id_parent` = 9883081
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 14) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20913 AND `id_group` = 4 LIMIT 1
4.4 0 /classes/GroupReduction.php:149
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` = 14
AND c.`id_parent` = 9882922
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.4 1 Yes Yes /classes/Category.php:859
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` = 14
AND c.`id_parent` = 9883028
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 23760 AND deleted = 0  
AND id_shop = 1 LIMIT 1
4.4 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20898) AND (b.`id_shop` = 1) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 28577) AND (b.`id_shop` = 1) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
4.3 0 /classes/Category.php:1219
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23993|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
4.3 1 /classes/SmartyCustom.php:263
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882911) AND (b.`id_shop` = 1) LIMIT 1
4.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24083
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23994
ORDER BY f.position ASC
4.3 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372740 LIMIT 1
4.3 1 /classes/Combination.php:344
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` = 28576)
4.3 37 /classes/Product.php:2998
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 = 21008 LIMIT 1
4.2 37 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21236|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
4.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23378
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.2 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
4.2 198 /classes/module/Module.php:277
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23563
ORDER BY f.position ASC
4.2 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23550
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.2 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
4.2 16 Yes /classes/SpecificPrice.php:361
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` = 9883082) LIMIT 1
4.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 369447 LIMIT 1
4.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20266 AND `id_group` = 4 LIMIT 1
4.1 0 /classes/GroupReduction.php:149
UPDATE `ps_smarty_lazy_cache`
SET filepath='23800/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23800|1|4|4|14|1|21" AND compile_id=""
4.1 1 /classes/SmartyCustom.php:183
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` = 14
AND c.`id_parent` = 54
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.1 6 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21616|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
4.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
4.1 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='23799/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23799|1|4|4|14|1|21" AND compile_id=""
4 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371038 LIMIT 1
4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 369484 LIMIT 1
4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24007) AND (id_product_attribute = 371778) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24482 AND `id_group` = 4 LIMIT 1
3.9 0 /classes/GroupReduction.php:149
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 24064) AND (b.`id_shop` = 1) LIMIT 1
3.9 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882957) AND (b.`id_shop` = 1) LIMIT 1
3.9 1 /Adapter/Adapter_EntityMapper.php:61
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` = 637)
3.9 38 /classes/Product.php:2998
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883033) AND (b.`id_shop` = 1) LIMIT 1
3.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 21564
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.9 0 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22199|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
3.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23723
ORDER BY f.position ASC
3.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23992
ORDER BY f.position ASC
3.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23378) AND (id_product_attribute = 370594) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 0 /classes/stock/StockAvailable.php:378
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23765) AND (b.`id_shop` = 1) LIMIT 1
3.8 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882941) AND (b.`id_shop` = 1) LIMIT 1
3.8 1 /Adapter/Adapter_EntityMapper.php:61
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` = 9883015) LIMIT 1
3.8 1 /Adapter/Adapter_EntityMapper.php:61
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 = 637
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
3.8 0 /classes/Product.php:1278
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
3.8 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883015 AND `id_shop` = 1
3.8 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23758) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 28684
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.8 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.8 554 /classes/Hook.php:236
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 23758 LIMIT 1
3.8 37 /classes/Product.php:765
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20813) AND (b.`id_shop` = 1) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
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` = 28683)
3.7 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
3.7 1 /classes/shop/Shop.php:1067
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 637) AND (b.`id_shop` = 1) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
3.7 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23758 AND id_shop=1 LIMIT 1
3.7 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
3.7 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9882816_right"
3.7 6 /modules/posvegamenu/posvegamenu.php:553
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882932) AND (b.`id_shop` = 1) LIMIT 1
3.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 28576 AND id_shop=1 LIMIT 1
3.6 1 /classes/Product.php:5032
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21348) AND (b.`id_shop` = 1) LIMIT 1
3.6 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
AND c.`id_parent` = 9882928
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.6 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 6 AND `id_shop` = 1 LIMIT 1
3.6 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 23760 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
3.5 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 4
AND id_shop = 1 LIMIT 1
3.5 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.5 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='23993/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23993|1|4|4|14|1|21" AND compile_id=""
3.5 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='24065/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24065|1|4|4|14|1|21" AND compile_id=""
3.5 1 /classes/SmartyCustom.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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 24040) AND (b.`id_shop` = 1) LIMIT 1
3.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21564) AND (id_product_attribute = 369521) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.5 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
3.5 0 /classes/module/Module.php:2568
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` = 14
AND c.`id_parent` = 45
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.5 15 Yes Yes /classes/Category.php:859
UPDATE `ps_smarty_lazy_cache`
SET filepath='24084/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24084|1|4|4|14|1|21" AND compile_id=""
3.5 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370742 LIMIT 1
3.4 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23765|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
3.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 21564
ORDER BY f.position ASC
3.4 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 50 AND `id_shop` = 1 LIMIT 1
3.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1) AND (b.`id_shop` = 1) LIMIT 1
3.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 3 AND `id_shop` = 1 LIMIT 1
3.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 14)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3.4 245 Yes /classes/Country.php:131
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 20867
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.4 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24005) AND (id_product_attribute = 371741) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.4 0 /classes/stock/StockAvailable.php:378
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883038) AND (b.`id_shop` = 1) LIMIT 1
3.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 22064)
3.4 37 /classes/Product.php:2998
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` = 14
AND c.`id_parent` = 9882950
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.4 1 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"23378|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
3.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20867) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9882806_right"
3.3 6 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23617
ORDER BY f.position ASC
3.3 8 Yes /classes/Product.php:4453
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 = 637
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
3.3 0 /classes/Product.php:1278
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` = 14
AND c.`id_parent` = 9882949
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.3 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22096 AND `id_group` = 4 LIMIT 1
3.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21746 AND `id_group` = 4 LIMIT 1
3.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 637 AND `id_group` = 4 LIMIT 1
3.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE * FROM ps_pos_staticfooter AS psb 
LEFT JOIN ps_pos_staticfooter_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticfooter_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1
AND id_lang =14
AND `hook_position` = "blockFooterExtra" 
AND `showhook` = 1
3.2 4 /modules/posstaticfooter/models/Staticfooter.php:51
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 = 20003 LIMIT 1
3.2 37 /classes/Product.php:752
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 `name` ASC
3.2 16 Yes /classes/Currency.php:231
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 = 637
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
3.2 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9883082"
3.2 6 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23765) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.2 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 21905
ORDER BY f.position ASC
3.2 8 Yes /classes/Product.php:4453
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` = 14
AND c.`id_parent` = 9883042
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.1 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="23970|1|4|4|14|1|21" AND compile_id="" LIMIT 1
3.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883048 AND `id_shop` = 1
3.1 14 /Adapter/Adapter_EntityMapper.php:68
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` = 23563)
3.1 38 /classes/Product.php:2998
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9883027_right"
3.1 6 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE * FROM `ps_awp_attribute_wizard_pro`
3.1 1 /modules/attributewizardpro/attributewizardpro.php:252
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` = 637
AND al.`id_lang` = 14
AND agl.`id_lang` = 14
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
3.1 38 Yes Yes /override/classes/Product.php:28
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23974) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.1 16 Yes /classes/SpecificPrice.php:361
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` = 9883063) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20867) AND (b.`id_shop` = 1) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21616 AND `id_group` = 4 LIMIT 1
3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 20898
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 14 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 9883001)
AND `level_depth` <= 4
AND cg.`id_group` IN (4)
ORDER BY `level_depth` ASC, cl.`name` ASC
3 147 Yes /modules/blockcategories/blockcategories.php:304
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23981) AND (b.`id_shop` = 1) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 4) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24093|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
3 1 /classes/SmartyCustom.php:263
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` = 9883089) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `hook_position` = "top" 
AND `showhook` = 1 ORDER BY `posorder` ASC
3 6 Yes /modules/posstaticblocks/models/Staticblock.php:51
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23554) AND (b.`id_shop` = 1) LIMIT 1
3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21635 AND id_shop=1 LIMIT 1
3 1 /classes/Product.php:5032
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(
"2021-01-20 00:00:00",
INTERVAL 1000 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` = 14 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 14 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` = 14)
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` = 637 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
3 9 Yes Yes /classes/Product.php:3598
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 369188 LIMIT 1
3 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 21635
ORDER BY f.position ASC
2.9 8 Yes /classes/Product.php:4453
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23754) AND (b.`id_shop` = 1) LIMIT 1
2.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23765
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.9 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 24040
ORDER BY f.position ASC
2.9 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21008 AND `id_group` = 4 LIMIT 1
2.9 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
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` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (4))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.9 306 Yes Yes /classes/Hook.php:355
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"23994|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
2.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 22096 AND id_shop=1 LIMIT 1
2.9 1 /classes/Product.php:5032
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` = 14
AND c.`id_parent` = 9882914
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.9 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.9 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='22096/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22096|1|4|4|14|1|21" AND compile_id=""
2.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23364
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.8 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 20962
ORDER BY f.position ASC
2.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23949) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE pc.*
FROM `ps_reviewsnippets` pc
WHERE pc.`id_product` = 637
AND pc.deleted = 0  AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,5
2.8 0 /modules/contentpack/classes/reviewshelp.class.php:520
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2076) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.8 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23754
ORDER BY f.position ASC
2.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 1182
ORDER BY f.position ASC
2.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a1297ed277cb58a582cfd72c4a862fb9' AND cache_id="blockcms|2|1|4|4|14|1|21" AND compile_id="" LIMIT 1
2.8 1 /classes/SmartyCustom.php:215
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` = 14
AND c.`id_parent` = 9883033
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.8 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24093|1|4|4|14|1|21" AND compile_id="" LIMIT 1
2.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20003) AND (id_product_attribute = 368152) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.7 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =7 AND m.page = "product" LIMIT 1
2.7 1 /classes/Theme.php:275
UPDATE `ps_smarty_lazy_cache`
SET filepath='22199/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22199|1|4|4|14|1|21" AND compile_id=""
2.7 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24047 AND id_shop=1 LIMIT 1
2.7 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 28576
ORDER BY f.position ASC
2.7 8 Yes /classes/Product.php:4453
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 = 20266 LIMIT 1
2.7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
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 = 23378
ORDER BY f.position ASC
2.7 8 Yes /classes/Product.php:4453
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` = 21867)
2.7 37 /classes/Product.php:2998
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
2.7 0 /classes/Category.php:1219
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23760) AND (b.`id_shop` = 1) LIMIT 1
2.7 1 /Adapter/Adapter_EntityMapper.php:61
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 = 22199 LIMIT 1
2.7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24082) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.7 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370668 LIMIT 1
2.7 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371112 LIMIT 1
2.7 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 368300 LIMIT 1
2.7 1 /classes/Combination.php:344
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 = 24056 LIMIT 1
2.7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23970
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.7 0 /classes/SpecificPrice.php:198
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` = 9883087) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 23633
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.6 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 14 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 1)
AND c.`id_category` != 9883001
AND `level_depth` <= 4
AND c.id_category IN (SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (4))
ORDER BY `level_depth` ASC, cl.`name` ASC
2.6 146 Yes /modules/posvegamenu/posvegamenu.php:983
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` = 23981)
2.6 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 22
AND cl.id_shop = 1 
AND cl.`id_category` = 9883003 LIMIT 1
2.6 1 /classes/Category.php:1054
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` = 9883035) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882923) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
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` = 24007)
2.6 37 /classes/Product.php:2998
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 28684) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9882816"
2.6 6 /modules/posvegamenu/posvegamenu.php:553
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` = 14
AND c.`id_parent` = 9883009
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.6 9 Yes Yes /classes/Category.php:859
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` = 14
AND c.`id_parent` = 9882954
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.6 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23982) AND (id_product_attribute = 371556) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.6 0 /classes/stock/StockAvailable.php:378
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 24297) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2076) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /Adapter/Adapter_EntityMapper.php:61
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 = 23765 LIMIT 1
2.6 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23617) AND (id_product_attribute = 370816) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.6 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24019) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.6 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23970) AND (id_product_attribute = 371334) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.5 0 /classes/stock/StockAvailable.php:378
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` = 14  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 9883003
AND `active` = 1
AND cg.`id_group` =4
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
2.5 9 Yes Yes /classes/Category.php:658
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370113 LIMIT 1
2.5 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24065|1|4|4|14|1|21","", FROM_UNIXTIME(1611159124))
2.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23723) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.5 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23970 AND id_shop=1 LIMIT 1
2.5 1 /classes/Product.php:5032
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` = 22204)
2.5 38 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23760) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.5 0 /classes/stock/StockAvailable.php:378
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 = 24052 LIMIT 1
2.5 36 /classes/Product.php:752
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` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
2.5 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 637) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.5 1 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
2.5 1 /classes/shop/ShopUrl.php:169
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21616|1|4|4|14|1|21","", FROM_UNIXTIME(1611159123))
2.5 1 /classes/SmartyCustom.php:263
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23493) AND (b.`id_shop` = 1) LIMIT 1
2.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22096
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.5 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 371149 LIMIT 1
2.5 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21635) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.5 0 /classes/stock/StockAvailable.php:378
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 = 23971 LIMIT 1
2.5 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24093) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 369114 LIMIT 1
2.4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23754 AND `id_group` = 4 LIMIT 1
2.4 0 /classes/GroupReduction.php:149
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`=637
2.4 53 /classes/Tag.php:205
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 20821 AND `id_group` = 4 LIMIT 1
2.4 0 /classes/GroupReduction.php:149
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` = 20813)
2.4 37 /classes/Product.php:2998
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` = 14
AND c.`id_parent` = 9882958
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
2.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.4 16 Yes /classes/SpecificPrice.php:361
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` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882950) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:61
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 = 21779 LIMIT 1
2.4 37 /classes/Product.php:752
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24065|1|4|4|14|1|21" AND compile_id="" LIMIT 1
2.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22353) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.4 0 /classes/stock/StockAvailable.php:378
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` = 23633)
2.4 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 372185 LIMIT 1
2.4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 23633 AND `id_group` = 4 LIMIT 1
2.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23633) AND (id_product_attribute = 370853) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24056 AND id_shop=1 LIMIT 1
2.3 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24482) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.3 0 /classes/stock/StockAvailable.php:378
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 = 23754 LIMIT 1
2.3 37 /classes/Product.php:752
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20266) AND (b.`id_shop` = 1) LIMIT 1
2.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22096) AND (id_product_attribute = 370113) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 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, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 14
AND cl.id_shop = 1 
AND cl.`id_category` = 9883003 LIMIT 1
2.3 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23563) AND (id_product_attribute = 370779) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22096) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.3 1 /classes/stock/StockAvailable.php:378
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 24047) AND (b.`id_shop` = 1) LIMIT 1
2.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24482
ORDER BY `id_specific_price_priority` DESC LIMIT 1
2.3 0 /classes/SpecificPrice.php:198
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 = 23708 LIMIT 1
2.3 37 /classes/Product.php:752
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 = 21842 LIMIT 1
2.3 37 /classes/Product.php:752
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24045 AND id_shop=1 LIMIT 1
2.3 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 367967 LIMIT 1
2.3 1 /classes/Combination.php:344
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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23949) AND (b.`id_shop` = 1) LIMIT 1
2.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 370853 LIMIT 1
2.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24064 AND `id_group` = 4 LIMIT 1
2.2 0 /classes/GroupReduction.php:149
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` = 22
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 637) AND (b.`id_shop` = 1) LIMIT 1
2.2 1 /Adapter/Adapter_EntityMapper.php:61