Mascota del hipopótamo de colores - Elefante Traje Marinero - Peluche - MASFR00317 - Mascotas de elefante Ver más grande

Mascota del hipopótamo de colores - Elefante Traje Marinero - Peluche

419,00 €

Nuevo producto

Mascota de Venta hipopótamo colorido! Una mascota de cualquier color en nuestra tienda que complementa nuestra fabulosa colección de trajes coloridos para la fiesta. Con este traje de marinero elefante, también ofrecen promociones de ventas para sus invitados. La estructura de nuestra colorida de la felpa es lavable a máquina y todo será enviado con el seguimiento recomendado!

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 edadNiños
SexoUnisexo
EquipoEspuma De Polietileno | Fibra De Vidrio | Nylon
CalidadAcabados Incluidos | Prima
EntregaInternationale | Nacional

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 Time20266 ms - You'd better run your shop on a toaster
Querying Time7095 ms
Queries2197
Memory Peak Usage82.0 Mb
Included Files409 files - 7.93 Mb
PrestaShop Cache- Mb
Global vars2.94 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 Time120s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 277 ms 277 ms 8.65 Mb 8.87 Mb
__construct 0 ms 277 ms - Mb 8.87 Mb
init 209 ms 487 ms 3.50 Mb 12.40 Mb
checkAccess 0 ms 487 ms - Mb 12.40 Mb
setMedia 30 ms 516 ms 0.07 Mb 12.46 Mb
postProcess 0 ms 516 ms - Mb 12.46 Mb
initHeader 0 ms 517 ms - Mb 12.46 Mb
initContent 13198 ms 13714 ms 55.92 Mb 68.61 Mb
initFooter 688 ms 14403 ms 3.99 Mb 74.64 Mb
display 5864 ms 20266 ms 7.61 Mb 82.04 Mb
Hook Time Memory Usage
hookproductfooter 9650 ms 33.50 Mb
hookdisplayProductListReviews 1807 ms 9.00 Mb
__construct 1008 ms 20.25 Mb
hookdisplayTop 751 ms 3.00 Mb
hookvegamenu 720 ms 1.50 Mb
hookheader 404 ms 2.75 Mb
hookfooter 360 ms 1.75 Mb
hookmegamenu 220 ms 2.00 Mb
hookproducttabcontent 174 ms - Mb
hookdisplayHeader 124 ms - Mb
hookdisplayRightColumnProduct 99 ms 1.00 Mb
hooktop 40 ms 0.25 Mb
hookdisplayNav 38 ms - Mb
hookdisplayFooter 33 ms - Mb
hookdisplayProductTabContent 17 ms 0.25 Mb
hookproducttab 15 ms - Mb
hookproductactions 13 ms - Mb
hookblockFooter1 13 ms - Mb
hookextraright 11 ms - Mb
hookextraleft 6 ms - Mb
hookblockFooter2 6 ms - Mb
hookdisplayLeftColumnProduct 4 ms 0.25 Mb
hookdisplayProductButtons 3 ms - Mb
hookdisplayFooterProduct 3 ms 0.25 Mb
hookDisplayOverrideTemplate 3 ms - Mb
hookblockFooter3 2 ms - Mb
hookblockFooterExtra 2 ms - Mb
hookdisplayProductTab 2 ms - Mb
hookblockFooter4 1 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookactionProductOutOfStock - ms - Mb
31 hooks 15526 ms 75.75 Mb
Module Time Memory Usage
productscategory 7716 ms 30.00 Mb
attributewizardpro 1997 ms 4.50 Mb
contentpack 1531 ms 7.75 Mb
gsnippetsreviews 802 ms 7.50 Mb
possearchcategories 752 ms 2.50 Mb
posvegamenu 723 ms 1.50 Mb
fbloginblock 231 ms 2.25 Mb
posmegamenu 223 ms 2.25 Mb
blockcategories 222 ms - Mb
tawkto 170 ms 0.50 Mb
facebookpsessentials 145 ms 1.00 Mb
htmlboxpro 106 ms 1.50 Mb
internationaltargeting 101 ms - Mb
posstaticfooter 82 ms 1.50 Mb
blockmyaccountfooter 71 ms - Mb
stripe_official 63 ms 1.25 Mb
blockwishlist 50 ms 0.25 Mb
blocknewsletter 43 ms 0.50 Mb
facebookpsshoptab 43 ms 0.25 Mb
pm_modalcart3 36 ms 0.75 Mb
psseobooster 35 ms - Mb
blockcart 34 ms 0.50 Mb
mailalerts 33 ms 2.25 Mb
blockcms 33 ms 0.25 Mb
posspecialproducts 33 ms 0.25 Mb
blockviewed 25 ms 0.25 Mb
seoexpert 25 ms 1.50 Mb
blockuserinfo 22 ms - Mb
posslideshow 22 ms 0.25 Mb
blockcontact 20 ms - Mb
blocklanguages 19 ms - Mb
blockpaymentlogo 16 ms - Mb
blockcurrencies 15 ms 0.50 Mb
pm_multiplefeatures 14 ms - Mb
sendtoafriend 10 ms - Mb
ganalytics 10 ms 0.75 Mb
posthemeoption 9 ms 0.25 Mb
smartblog 7 ms 0.75 Mb
blockmanufacturer 7 ms 0.50 Mb
posstaticblocks 6 ms 0.25 Mb
infinitescroll 6 ms 0.50 Mb
favoriteproducts 6 ms - Mb
artfreegdpr 4 ms 1.75 Mb
blocksupplier 4 ms - Mb
blockmyaccount 3 ms - Mb
45 modules 15526 ms 75.75 Mb

Stopwatch SQL - 2197 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` = 9882920 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100
1091.6 182277 Yes /classes/Category.php:783
UPDATE `ps_smarty_lazy_cache`
SET filepath='21990/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21990|1|4|4|14|1|21" AND compile_id=""
176.2 1 /classes/SmartyCustom.php:183
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`=317
51.2 87 /classes/Tag.php:205
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
29.5 245 Yes /classes/Country.php:131
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` = 144857 LIMIT 1
25.8 1 /classes/Combination.php:344
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
23.2 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
22 16 Yes /classes/SpecificPrice.php:361
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
21.1 0 /classes/Category.php:1219
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22072|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
20.5 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='22892/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22892|1|4|4|14|1|21" AND compile_id=""
18.6 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` = 9883048) AND (b.`id_shop` = 1) LIMIT 1
17.7 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
17.4 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` = 22900) AND (b.`id_shop` = 1) LIMIT 1
17.1 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='22893/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22893|1|4|4|14|1|21" AND compile_id=""
16.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='22100/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22100|1|4|4|14|1|21" AND compile_id=""
16.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32543) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
16.1 0 /classes/stock/StockAvailable.php:378
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
15.7 0 /classes/Category.php:1219
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
15.6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32577) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
15.5 0 /classes/stock/StockAvailable.php:378
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21443|1|4|4|14|1|21","", FROM_UNIXTIME(1611159320))
15.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22910|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
15.2 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 = 21479
ORDER BY f.position ASC
15 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
15 776 /classes/SpecificPrice.php:230
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22100|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
14.8 1 /classes/SmartyCustom.php:263
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` = 145079 LIMIT 1
14.7 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22906 AND deleted = 0  
AND id_shop = 1 LIMIT 1
14.5 0 /modules/contentpack/classes/reviewshelp.class.php:413
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22900|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
14 1 /classes/SmartyCustom.php:263
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`)
14 9048 /classes/Configuration.php:148
UPDATE `ps_smarty_lazy_cache`
SET filepath='22899/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22899|1|4|4|14|1|21" AND compile_id=""
13.7 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='productscategory/317/9882920/1/4/4/14/1/21/ea/c0/77/eac0771dfb331f2f2c41ed4186abae6888e44e08.productscategory.tpl.php'
WHERE `template_hash`='83b6732a48d65fe35e1cf970ad056af2' AND cache_id="productscategory|317|9882920|1|4|4|14|1|21" AND compile_id=""
13.7 1 /classes/SmartyCustom.php:183
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 = 317 GROUP BY pac.id_attribute
13.6 37 Yes Yes /modules/attributewizardpro/attributewizardpro.php:2267
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` = 9882964
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
13.5 1 Yes Yes /classes/Category.php:859
UPDATE `ps_smarty_lazy_cache`
SET filepath='21443/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21443|1|4|4|14|1|21" AND compile_id=""
13.4 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='22890/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22890|1|4|4|14|1|21" AND compile_id=""
13.3 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` = 31832) AND (b.`id_shop` = 1) LIMIT 1
13.3 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 = 5187 LIMIT 1
13.3 37 /classes/Product.php:752
UPDATE `ps_smarty_lazy_cache`
SET filepath='22903/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22903|1|4|4|14|1|21" AND compile_id=""
13.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE nleft, nright FROM `ps_category` WHERE id_category = 9882920 LIMIT 1
13.2 1 /classes/Category.php:1512
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 = 22894 LIMIT 1
13.1 37 /classes/Product.php:752
UPDATE `ps_smarty_lazy_cache`
SET filepath='21479/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21479|1|4|4|14|1|21" AND compile_id=""
13 1 /classes/SmartyCustom.php:183
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
12.9 1 /classes/Theme.php:275
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` = 22068)
12.7 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 = 22904 LIMIT 1
12.6 37 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21400|1|4|4|14|1|21","", FROM_UNIXTIME(1611159320))
12.6 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 product_attribute_shop.default_on = 1  AND pa.id_product = 31792 LIMIT 1
12.5 37 /classes/Product.php:765
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 = 32034 LIMIT 1
12.4 38 /classes/Product.php:752
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22895
ORDER BY `id_specific_price_priority` DESC LIMIT 1
12.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 = 22901
ORDER BY f.position ASC
12.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` = 141749 LIMIT 1
12.2 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="22068|1|4|4|14|1|21" AND compile_id="" LIMIT 1
12.2 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22892|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
12.1 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` = 21479)
12.1 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 317) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
12 0 /classes/stock/StockAvailable.php:670
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22068|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
12 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='22901/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22901|1|4|4|14|1|21" AND compile_id=""
12 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
11.9 0 /classes/Category.php:1219
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
11.9 16 Yes /classes/SpecificPrice.php:361
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
11.7 0 /classes/Category.php:1219
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` = 9883004
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
11.7 6 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22902|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
11.5 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21479|1|4|4|14|1|21","", FROM_UNIXTIME(1611159320))
11.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32271) AND (id_product_attribute = 144894) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
11.4 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` = 20819) AND (b.`id_shop` = 1) LIMIT 1
11.3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22903|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
11.3 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
11 16 Yes /classes/SpecificPrice.php:361
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` = 7565)
10.9 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` = 145338 LIMIT 1
10.8 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` = 22900)
10.7 37 /classes/Product.php:2998
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 = 22072
ORDER BY f.position ASC
10.7 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="22893|1|4|4|14|1|21" AND compile_id="" LIMIT 1
10.7 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9882806 AND `id_shop` = 1
10.6 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_awp_attribute_wizard_pro`
10.6 1 /modules/attributewizardpro/attributewizardpro.php:252
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 = 22908 LIMIT 1
10.6 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` = 144561 LIMIT 1
10.6 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 7029
ORDER BY `id_specific_price_priority` DESC LIMIT 1
10.5 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22903 AND deleted = 0  
AND id_shop = 1 LIMIT 1
10.5 0 /modules/contentpack/classes/reviewshelp.class.php:413
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
10.5 0 /classes/Category.php:1219
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` = 5070)
10.4 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
10.4 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22910|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
10.3 1 /classes/SmartyCustom.php:263
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` = 140935 LIMIT 1
10.3 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5186) AND (id_product_attribute = 141971) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
10.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20819) AND (id_product_attribute = 142674) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
10.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22912|1|4|4|14|1|21" AND compile_id="" LIMIT 1
10.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 317
10.2 37 /classes/Product.php:2168
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 = 32637
ORDER BY f.position ASC
10.1 8 Yes /classes/Product.php:4453
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` = "blockFooter1" 
AND `showhook` = 1
10 4 /modules/posstaticfooter/models/Staticfooter.php:51
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22896|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
9.9 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` = 22914) AND (b.`id_shop` = 1) LIMIT 1
9.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 32530
ORDER BY `id_specific_price_priority` DESC LIMIT 1
9.8 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` = 55) LIMIT 1
9.7 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='22913/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22913|1|4|4|14|1|21" AND compile_id=""
9.7 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="22902|1|4|4|14|1|21" AND compile_id="" LIMIT 1
9.7 1 /classes/SmartyCustom.php:215
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.7 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
9.7 1 /classes/shop/ShopUrl.php:169
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
9.6 146 Yes /modules/posmegamenu/posmegamenu.php:997
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.6 16 Yes /classes/SpecificPrice.php:361
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` = 2) LIMIT 1
9.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31829
ORDER BY `id_specific_price_priority` DESC LIMIT 1
9.4 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` = 143747 LIMIT 1
9.4 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 = 5803 LIMIT 1
9.3 37 /classes/Product.php:752
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.3 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22912|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
9.1 1 /classes/SmartyCustom.php:263
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
9 553 /classes/Hook.php:236
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 = 32270
ORDER BY f.position ASC
9 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` = 9882906
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
9 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22904 AND deleted = 0  
AND id_shop = 1 LIMIT 1
9 0 /modules/contentpack/classes/reviewshelp.class.php:413
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.9 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="22911|1|4|4|14|1|21" AND compile_id="" LIMIT 1
8.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31829) AND (id_product_attribute = 144672) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22901 AND deleted = 0  
AND id_shop = 1 LIMIT 1
8.9 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 144524 LIMIT 1
8.9 1 /classes/Combination.php:344
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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32560) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4792
ORDER BY `id_specific_price_priority` DESC LIMIT 1
8.8 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 = 32530 LIMIT 1
8.8 36 /classes/Product.php:765
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32637) AND (id_product_attribute = 145264) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.7 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32669) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.7 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` = 32675) AND (b.`id_shop` = 1) LIMIT 1
8.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 product_attribute_shop.default_on = 1  AND pa.id_product = 4945 LIMIT 1
8.6 36 /classes/Product.php:765
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22890|1|4|4|14|1|21" AND compile_id="" LIMIT 1
8.6 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='22900/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22900|1|4|4|14|1|21" AND compile_id=""
8.5 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
8.5 0 /classes/Category.php:1219
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`
8.5 304 Yes Yes /classes/Hook.php:355
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` = 143155 LIMIT 1
8.4 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` = 9882957) AND (b.`id_shop` = 1) LIMIT 1
8.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pc.*
FROM `ps_blockguestbook` pc
WHERE pc.active = 1 AND pc.`is_deleted` = 0 AND
`id_shop` = '1' AND `id_lang` = '14'
ORDER BY pc.`date_add` DESC LIMIT 0 ,3
8.4 1 Yes /modules/contentpack/classes/guestbook.class.php:206
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.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
8.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31792) AND (id_product_attribute = 144598) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.3 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 = 32675
ORDER BY f.position ASC
8.3 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23687 AND id_shop=1 LIMIT 1
8.3 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` = 9883019
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.2 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` = 144709 LIMIT 1
8.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 74 AND `id_shop` = 1 LIMIT 1
8.2 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
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` = 9883027) LIMIT 1
8.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` = 143821 LIMIT 1
8.1 1 /classes/Combination.php:344
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
8.1 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE pc.*
FROM `ps_reviewsnippets` pc
WHERE pc.`id_product` = 317
AND pc.deleted = 0  AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,5
8.1 0 /modules/contentpack/classes/reviewshelp.class.php:520
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22901|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
8.1 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 32569 AND `id_group` = 4 LIMIT 1
8 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
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 = 31938
ORDER BY f.position ASC
8 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 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22903) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 32519 AND `id_group` = 4 LIMIT 1
7.8 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 = 32669
ORDER BY f.position ASC
7.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22890 AND deleted = 0  
AND id_shop = 1 LIMIT 1
7.8 0 /modules/contentpack/classes/reviewshelp.class.php:413
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 = 32569
ORDER BY f.position ASC
7.8 8 Yes /classes/Product.php:4453
UPDATE `ps_smarty_lazy_cache`
SET filepath='22898/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22898|1|4|4|14|1|21" AND compile_id=""
7.8 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='22902/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22902|1|4|4|14|1|21" AND compile_id=""
7.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31501) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.8 1 /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` = 9882942) AND (b.`id_shop` = 1) LIMIT 1
7.8 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 = 32271 LIMIT 1
7.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` = 55) AND (b.`id_shop` = 1) LIMIT 1
7.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` = 20954)
7.7 36 /classes/Product.php:2998
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22900 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
7.7 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22908 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
7.7 0 /modules/contentpack/classes/reviewshelp.class.php:438
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21400|1|4|4|14|1|21","", FROM_UNIXTIME(1611159320))
7.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21990) AND (id_product_attribute = 143081) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.7 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 31805 AND id_shop=1 LIMIT 1
7.6 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 31938 AND id_shop=1 LIMIT 1
7.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 = 20954
ORDER BY f.position ASC
7.5 8 Yes /classes/Product.php:4453
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` = 9882928) AND (b.`id_shop` = 1) LIMIT 1
7.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` = 9883023) AND (b.`id_shop` = 1) LIMIT 1
7.5 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22896|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
7.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22100 AND deleted = 0  
AND id_shop = 1 LIMIT 1
7.5 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 317) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.5 0 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="22100|1|4|4|14|1|21" AND compile_id="" LIMIT 1
7.5 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 32669
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.5 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.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` = 32558) AND (b.`id_shop` = 1) LIMIT 1
7.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` = 31982) AND (b.`id_shop` = 1) LIMIT 1
7.4 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 = 31600
ORDER BY f.position ASC
7.4 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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="22890|1|4|4|14|1|21" AND compile_id="" LIMIT 1
7.4 1 /classes/SmartyCustom.php:215
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',"22895|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
7.4 1 /classes/SmartyCustom.php:263
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
7.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22892
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.4 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32577) AND (id_product_attribute = 145153) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.3 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` = 141009 LIMIT 1
7.3 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31792
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.3 0 /classes/SpecificPrice.php:198
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` = 9882804
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.3 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22100
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` = 20746) AND (b.`id_shop` = 1) LIMIT 1
7.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 31805 AND `id_group` = 4 LIMIT 1
7.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 28696
ORDER BY `id_specific_price_priority` DESC LIMIT 1
7.3 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 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` = 141712 LIMIT 1
7.2 1 /classes/Combination.php:344
UPDATE `ps_smarty_lazy_cache`
SET filepath='22072/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22072|1|4|4|14|1|21" AND compile_id=""
7.2 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22100|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
7.2 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` = 20746)
7.1 38 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22068|1|4|4|14|1|21" AND compile_id="" LIMIT 1
7.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21210) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.1 1 /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` = ""
7.1 6 /modules/posvegamenu/posvegamenu.php:553
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.1 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 21443 AND deleted = 0  
AND id_shop = 1 LIMIT 1
7.1 0 /modules/contentpack/classes/reviewshelp.class.php:413
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.1 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` = 144302 LIMIT 1
7.1 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` = 144598 LIMIT 1
7.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4125) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7 0 /classes/stock/StockAvailable.php:378
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21479|1|4|4|14|1|21","", FROM_UNIXTIME(1611159320))
7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22910) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7 0 /classes/stock/StockAvailable.php:378
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 = 317
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
7 0 /classes/Product.php:1278
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` = 144894 LIMIT 1
7 1 /classes/Combination.php:344
UPDATE `ps_smarty_lazy_cache`
SET filepath='22894/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22894|1|4|4|14|1|21" AND compile_id=""
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 = 5750 LIMIT 1
7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22915 AND `id_group` = 4 LIMIT 1
7 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22915) AND (id_product_attribute = 144191) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.9 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` = 22896) AND (b.`id_shop` = 1) LIMIT 1
6.9 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.9 16 Yes /classes/SpecificPrice.php:361
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"
6.9 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 = 22892
ORDER BY f.position ASC
6.9 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21479 AND `id_group` = 4 LIMIT 1
6.9 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22912 AND `id_group` = 4 LIMIT 1
6.9 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22892) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5750) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.9 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` = 31982)
6.9 38 /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` = 142822 LIMIT 1
6.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 20815
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.8 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
6.8 86 /classes/Hook.php:187
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` = 9882907
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.8 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` = 28696) AND (b.`id_shop` = 1) LIMIT 1
6.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31074) AND (id_product_attribute = 144376) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.8 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` = 31832)
6.8 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 31829 AND `id_group` = 4 LIMIT 1
6.8 0 /classes/GroupReduction.php:149
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` = 9883029) AND (b.`id_shop` = 1) LIMIT 1
6.8 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22906|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
6.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31600
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.7 0 /classes/SpecificPrice.php:198
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` = 6626)
6.7 36 /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` = 31792) AND (b.`id_shop` = 1) LIMIT 1
6.7 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` = 23687) AND (b.`id_shop` = 1) LIMIT 1
6.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`id_category_default`
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` = 317 LIMIT 1
6.7 1 /classes/Product.php:5910
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22890
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.7 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 21400 AND deleted = 0  
AND id_shop = 1 LIMIT 1
6.7 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22443
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.7 0 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22909|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
6.7 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_right"
6.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 = 5187
ORDER BY f.position ASC
6.6 8 Yes /classes/Product.php:4453
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
6.6 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22911|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
6.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="22908|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 9882920 LIMIT 1
6.6 1 /classes/Category.php:1054
UPDATE `ps_smarty_lazy_cache`
SET filepath='22904/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22904|1|4|4|14|1|21" AND compile_id=""
6.6 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` = 31500)
6.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` = 3126) AND (b.`id_shop` = 1) LIMIT 1
6.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22905 AND deleted = 0  
AND id_shop = 1 LIMIT 1
6.6 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 902)
6.6 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21443|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.6 1 /classes/SmartyCustom.php:215
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` = 32519)
6.6 37 /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` = 9882892) AND (b.`id_shop` = 1) LIMIT 1
6.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22898) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.6 0 /classes/stock/StockAvailable.php:378
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.5 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` = 32669)
6.5 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32639) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.5 0 /classes/stock/StockAvailable.php:378
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` = 9882816) LIMIT 1
6.5 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22899|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
6.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` = 22898) AND (b.`id_shop` = 1) LIMIT 1
6.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22891|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.5 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5750 AND id_shop=1 LIMIT 1
6.4 1 /classes/Product.php:5032
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 = 6626 LIMIT 1
6.4 37 /classes/Product.php:752
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` = 9882924
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.4 1 Yes Yes /classes/Category.php:859
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 = 7029 LIMIT 1
6.4 37 /classes/Product.php:752
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 23 AND `id_shop` = 1 LIMIT 1
6.4 1 /modules/fbloginblock/classes/facebookhelp.class.php:110
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` = 31938) AND (b.`id_shop` = 1) LIMIT 1
6.3 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22894|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
6.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` = 9882804) AND (b.`id_shop` = 1) LIMIT 1
6.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22913) AND (id_product_attribute = 144117) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32639) AND (id_product_attribute = 145301) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 1 AND `id_shop` = 1 LIMIT 1
6.3 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
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` = 32519) AND (b.`id_shop` = 1) LIMIT 1
6.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22910 AND deleted = 0  
AND id_shop = 1 LIMIT 1
6.3 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22911|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.3 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` = 141971 LIMIT 1
6.3 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 = 22912 LIMIT 1
6.2 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 = 2320 LIMIT 1
6.2 37 /classes/Product.php:752
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` = 9882948
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.2 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 32270 AND `id_group` = 4 LIMIT 1
6.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE id_product FROM `ps_category_product` WHERE `id_product` = 317 AND `id_category` IN (9882920) LIMIT 1
6.2 4 /classes/Product.php:4885
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 20692
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.2 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 = 20954 LIMIT 1
6.2 37 /classes/Product.php:752
SELECT SQL_NO_CACHE count(o.id_order) as count FROM ps_orders as o 
LEFT JOIN ps_order_detail as od ON(o.id_order = od.id_order)
WHERE o.id_customer = 0 AND od.product_id = 317
AND o.id_shop = 1 AND od.id_shop = 1
6.2 1 /modules/contentpack/classes/reviewshelp.class.php:984
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31500
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.2 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22912) AND (id_product_attribute = 144080) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.2 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` = 32560) AND (b.`id_shop` = 1) LIMIT 1
6.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 32675 AND `id_group` = 4 LIMIT 1
6.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21443 AND id_shop=1 LIMIT 1
6.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31217
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6.1 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` = 9883042) LIMIT 1
6.1 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21990|1|4|4|14|1|21","", FROM_UNIXTIME(1611159320))
6.1 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` = 32271)
6.1 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22910 AND `id_group` = 4 LIMIT 1
6.1 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 = 4148 LIMIT 1
6.1 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 = 4792 LIMIT 1
6.1 37 /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
6.1 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21990|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.1 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` = 9883063
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.1 3 Yes Yes /classes/Category.php:859
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` = 22443)
6 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="22898|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6 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 = 22911
ORDER BY f.position ASC
6 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2320) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
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` = 7005) AND (b.`id_shop` = 1) LIMIT 1
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` = 32578) AND (b.`id_shop` = 1) LIMIT 1
6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32560) AND (id_product_attribute = 145079) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
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 product_attribute_shop.default_on = 1  AND pa.id_product = 21210 LIMIT 1
6 38 /classes/Product.php:765
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 20
AND cl.id_shop = 1 
AND cl.`id_category` = 9882920 LIMIT 1
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` = 9883033) LIMIT 1
6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 7029 AND id_shop=1 LIMIT 1
6 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 32639
ORDER BY `id_specific_price_priority` DESC LIMIT 1
6 0 /classes/SpecificPrice.php:198
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22913|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
5.9 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22898|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
5.9 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` = 22911)
5.9 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 9882920 AND ctg.`id_group` = 4 LIMIT 1
5.9 1 /classes/Category.php:1309
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22100|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22900
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.8 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
5.8 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22072|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
5.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 317 AND deleted = 0  
AND id_shop = 1 LIMIT 1
5.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` = 20
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 317) AND (b.`id_shop` = 1) LIMIT 1
5.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` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 32270) AND (b.`id_shop` = 1) LIMIT 1
5.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32578) AND (id_product_attribute = 145190) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.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` = 144931 LIMIT 1
5.7 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22912 AND deleted = 0  
AND id_shop = 1 LIMIT 1
5.7 0 /modules/contentpack/classes/reviewshelp.class.php:413
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 = 21443 LIMIT 1
5.7 36 /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` = 9883035) LIMIT 1
5.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22906
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.6 0 /classes/SpecificPrice.php:198
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` = 5086)
5.6 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 20358 AND id_shop=1 LIMIT 1
5.5 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` = 145116 LIMIT 1
5.5 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 317) AND (id_product_attribute = 140898) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.5 0 /classes/stock/StockAvailable.php:378
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
5.5 197 /classes/module/Module.php:277
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` = 9883031) AND (b.`id_shop` = 1) LIMIT 1
5.5 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` = 142970 LIMIT 1
5.5 1 /classes/Combination.php:344
UPDATE `ps_smarty_lazy_cache`
SET filepath='22909/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22909|1|4|4|14|1|21" AND compile_id=""
5.5 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 = 20746 LIMIT 1
5.4 38 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 28696) AND (id_product_attribute = 144339) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32578) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.4 0 /classes/stock/StockAvailable.php:378
UPDATE `ps_smarty_lazy_cache`
SET filepath='22895/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22895|1|4|4|14|1|21" AND compile_id=""
5.4 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22891 AND deleted = 0  
AND id_shop = 1 LIMIT 1
5.4 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 142785 LIMIT 1
5.4 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31600) AND (id_product_attribute = 144561) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.4 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` = 22899) AND (b.`id_shop` = 1) LIMIT 1
5.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 24
AND cl.id_shop = 1 
AND cl.`id_category` = 9882920 LIMIT 1
5.3 1 /classes/Category.php:1054
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` = 9883087) AND (b.`id_shop` = 1) LIMIT 1
5.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22901|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.3 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` = 9882964) AND (b.`id_shop` = 1) LIMIT 1
5.3 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` = 9882816
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.3 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31832) AND (id_product_attribute = 144709) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.3 0 /classes/stock/StockAvailable.php:378
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` = 9882920
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.3 1 Yes Yes /classes/Category.php:859
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 = 31805 LIMIT 1
5.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` = 31600) AND (b.`id_shop` = 1) LIMIT 1
5.3 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` = 4148)
5.2 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22072|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 31074 LIMIT 1
5.2 38 /classes/Product.php:765
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22907
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.2 0 /classes/SpecificPrice.php:198
UPDATE `ps_smarty_lazy_cache`
SET filepath='22891/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22891|1|4|4|14|1|21" AND compile_id=""
5.2 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='22905/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22905|1|4|4|14|1|21" AND compile_id=""
5.2 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 product_attribute_shop.default_on = 1  AND pa.id_product = 902 LIMIT 1
5.1 37 /classes/Product.php:765
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 = 21243
ORDER BY f.position ASC
5.1 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22908) AND (id_product_attribute = 143932) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.1 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 = 31074
ORDER BY f.position ASC
5.1 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22908
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.1 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22911) AND (id_product_attribute = 144043) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.1 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='083720f0af31d239edd1031b3d29245f' AND cache_id="blockcontact|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22898|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 32271 LIMIT 1
5 37 /classes/Product.php:765
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 22905 AND id_shop=1 LIMIT 1
5 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 = 28592
ORDER BY f.position ASC
5 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31805
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5 0 /classes/SpecificPrice.php:198
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` = 9883042) AND (b.`id_shop` = 1) LIMIT 1
5 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 = 2320
ORDER BY f.position ASC
5 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22892 AND deleted = 0  
AND id_shop = 1 LIMIT 1
5 0 /modules/contentpack/classes/reviewshelp.class.php:413
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 = 22906
ORDER BY f.position ASC
5 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` = 143414 LIMIT 1
5 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` = 22894)
5 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 = 3112 LIMIT 1
4.9 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 = 7031 LIMIT 1
4.9 37 /classes/Product.php:752
UPDATE `ps_smarty_lazy_cache`
SET filepath='22896/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22896|1|4|4|14|1|21" AND compile_id=""
4.9 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` = 9883049) AND (b.`id_shop` = 1) LIMIT 1
4.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21243) AND (id_product_attribute = 142822) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.9 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 = 32636
ORDER BY f.position ASC
4.9 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 7005 AND `id_group` = 4 LIMIT 1
4.9 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22068 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
4.9 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 1 LIMIT 1
4.8 1 /classes/Category.php:1477
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` = 32569) AND (b.`id_shop` = 1) LIMIT 1
4.8 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 = 22900 LIMIT 1
4.8 37 /classes/Product.php:752
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22891|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
4.8 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 21400
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.8 1 /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.8 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 60 AND `id_shop` = 1 LIMIT 1
4.8 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
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
4.8 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` = 9882945) AND (b.`id_shop` = 1) LIMIT 1
4.7 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` = 144265 LIMIT 1
4.7 1 /classes/Combination.php:344
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
4.7 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22892|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
4.7 1 /classes/SmartyCustom.php:263
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` = 317
ORDER BY `position`
4.7 1 Yes /classes/Product.php:2723
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22895|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
4.7 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 = 22909
ORDER BY f.position ASC
4.7 8 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22895|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
4.7 1 /classes/SmartyCustom.php:263
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` = 142267 LIMIT 1
4.7 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 = 20692
ORDER BY f.position ASC
4.7 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` = 15
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 317) AND (b.`id_shop` = 1) LIMIT 1
4.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 = 22911 LIMIT 1
4.7 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20746) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.7 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
4.7 192 Yes /classes/Country.php:137
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.6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 317 AND `id_shop` = 1
4.6 11 /Adapter/Adapter_EntityMapper.php:68
UPDATE `ps_smarty_lazy_cache`
SET filepath='22906/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22906|1|4|4|14|1|21" AND compile_id=""
4.6 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 32558
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.6 0 /classes/SpecificPrice.php:198
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` = 9882936
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.6 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 69 AND `id_shop` = 1 LIMIT 1
4.6 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 22901 AND id_shop=1 LIMIT 1
4.6 1 /classes/Product.php:5032
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 *
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` = 9883048) 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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22890|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
4.6 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` = 22894) AND (b.`id_shop` = 1) LIMIT 1
4.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21243 AND id_shop=1 LIMIT 1
4.6 1 /classes/Product.php:5032
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 = 6605 LIMIT 1
4.6 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 32270) AND (id_product_attribute = 144857) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.6 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 7565
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.6 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` = 19
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 317) AND (b.`id_shop` = 1) LIMIT 1
4.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 28589) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.5 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3126) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.5 0 /classes/stock/StockAvailable.php:378
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` = 9883027
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.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 = 22908
ORDER BY f.position ASC
4.5 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883024 AND `id_shop` = 1
4.5 14 /Adapter/Adapter_EntityMapper.php:68
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 = 23687
ORDER BY f.position ASC
4.5 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` = 4945) AND (b.`id_shop` = 1) LIMIT 1
4.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22908 AND deleted = 0  
AND id_shop = 1 LIMIT 1
4.5 0 /modules/contentpack/classes/reviewshelp.class.php:413
UPDATE `ps_smarty_lazy_cache`
SET filepath='22910/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22910|1|4|4|14|1|21" AND compile_id=""
4.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` = 143636 LIMIT 1
4.5 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22890|1|4|4|14|1|21","", FROM_UNIXTIME(1611159321))
4.5 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 32034 AND `id_group` = 4 LIMIT 1
4.5 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE round(AVG(`rating`),2) AS "avg_rating_decimal"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 317 AND deleted = 0 AND id_shop = 1 LIMIT 1
4.5 0 /modules/contentpack/classes/reviewshelp.class.php:385
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31409
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.5 0 /classes/SpecificPrice.php:198
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` = 9883034) AND (b.`id_shop` = 1) LIMIT 1
4.5 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 = 3126 LIMIT 1
4.4 36 /classes/Product.php:752
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` = 145042 LIMIT 1
4.4 1 /classes/Combination.php:344
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` = 9883082
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 *, ( 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.4 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` = 143525 LIMIT 1
4.4 1 /classes/Combination.php:344
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.4 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"22909|1|4|4|14|1|21","", FROM_UNIXTIME(1611159322))
4.4 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` = 9882927) AND (b.`id_shop` = 1) LIMIT 1
4.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` = 9882907) 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.4 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` = 22905) AND (b.`id_shop` = 1) LIMIT 1
4.4 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` = 9882950
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_theme` a
WHERE (a.`id_theme` = 7) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php