Mascot representando un gris dientes de tiburón disfrazar el mar - MASFR001991 - Tiburón de mascotas Ver más grande

Mascot representando un gris dientes de tiburón disfrazar el mar

370,00 €

Nuevo producto

Mascot representa el Tiburón a través de un gris tiburón. Personalizable de acuerdo a sus deseos y necesidades, este traje es ideal para celebrar eventos especiales en un parque acuático.Disponible en tamaños è, es esencial para asistir a una fiesta de disfraces en el tema de las naves marítimas rápidas y libres, este traje viene con accesorios.

Más detalles

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

Generales características del producto:

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


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


Este producto contiene:

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

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

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


Envío:

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


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

No hay ninguna opinión por el momento.


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

No hay preguntas de clientes por el momento.


Su pregunta ha sido enviada exitosamente a nuestro equipo. Gracias por la pregunta!
Hacer una pregunta
ocultar formulario
Opciones de Producto
  
  Cantidad:
Tamaño
Tamaño
 
Tamaño Niño
[Resta 15,00 €]
 
S (160-170 Cm)
 
 
M (170-180 Cm)
 
 
L (180-190 Cm)
 
 
Xl (190-200 Cm)
 
 
Xxl (200-220 Cm)
 
Cambio de color
Cambio de color
 
Ningún Cambio
 
 
1 Cambio De Color
[Añade 30,00 €]
 
2 Cambios De Color
[Añade 40,00 €]
 
3 Cambios De Color
[Añade 50,00 €]
Comentario de color (código HEX, RGB, etc .. código)
Comentario de color (código HEX, RGB, etc .. código)
Comentario De Color (Si El Cambio Seleccionado) 
 
Adición de logotipo
Adición de logotipo
Sí - Jefe / Sombrero
 
[Añade 20,00 €]
Sí - Hombros X2
 
[Añade 30,00 €]
Sí - Espalda(De Pequeño Formato)
 
[Añade 30,00 €]
Sí - Espalda (De Gran Formato)
 
[Añade 50,00 €]
Sí - En El Pecho (Pequeño Formato)
 
[Añade 30,00 €]
Sí - Torso (De Gran Formato)
 
[Añade 50,00 €]
Sí - Rodillas X2
 
[Añade 20,00 €]
Adición de texto
Adición de texto
Sí - Jefe / Sombrero 
 
[Añade 20,00 €]
Sí - Torso (Pequeño Formato ) 
 
[Añade 30,00 €]
Sí - Torso (De Gran Formato) 
 
[Añade 40,00 €]
Sí - Espalda(De Pequeño Formato) 
 
[Añade 30,00 €]
Sí - Espalda (De Gran Formato) 
 
[Añade 40,00 €]
Con la ropa ? (si está presente en la foto)
Con la ropa ? (si está presente en la foto)
 
No
 
 
[Añade 20,00 €]
Accesorios
Accesorios
No
 
No
Sombrero
 
Sombrero
[Añade 30,00 €]
Pompones X2
 
Pompones X2
[Añade 15,00 €]
Empate
 
Empate
[Añade 15,00 €]
Gafas
 
Gafas
[Añade 20,00 €]
Relleno Vientre
 
Relleno Vientre
[Añade 60,00 €]
Fan
 
Fan
[Añade 40,00 €]
Zapatos
 
Zapatos
[Añade 50,00 €]
Accesorio De Elección
 
Accesorio De Elección
[Añade 50,00 €]
Boceto (antes de la fabricación)
Boceto (antes de la fabricación)
 
No
 
 
[Añade 40,00 €]
  
  Cantidad:
30 otros productos en la misma categoría:
Load Time19948 ms - You'd better run your shop on a toaster
Querying Time5174 ms
Queries1524
Memory Peak Usage59.0 Mb
Included Files397 files - 7.80 Mb
PrestaShop Cache- Mb
Global vars2.85 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 354 ms 354 ms 8.69 Mb 8.94 Mb
__construct 0 ms 354 ms - Mb 8.94 Mb
init 186 ms 541 ms 3.50 Mb 12.44 Mb
checkAccess 0 ms 541 ms - Mb 12.44 Mb
setMedia 14 ms 555 ms 0.07 Mb 12.49 Mb
postProcess 0 ms 555 ms - Mb 12.49 Mb
initHeader 0 ms 555 ms - Mb 12.49 Mb
initContent 11081 ms 11636 ms 38.19 Mb 51.31 Mb
initFooter 581 ms 12217 ms 1.72 Mb 54.73 Mb
display 7731 ms 19948 ms 4.47 Mb 58.98 Mb
Hook Time Memory Usage
hookproductfooter 7553 ms 21.00 Mb
hookdisplayProductListReviews 1929 ms 9.75 Mb
hookvegamenu 961 ms 1.00 Mb
__construct 903 ms 18.50 Mb
hookmegamenu 690 ms 0.75 Mb
hookdisplayTop 619 ms 2.25 Mb
hookheader 355 ms 1.00 Mb
hookfooter 340 ms - Mb
hookproducttabcontent 268 ms - Mb
hookdisplayRightColumnProduct 163 ms 0.75 Mb
hookdisplayHeader 63 ms - Mb
hookdisplayNav 62 ms - Mb
hookdisplayProductTabContent 29 ms 0.25 Mb
hookdisplayFooter 29 ms - Mb
hookextraleft 27 ms 0.25 Mb
hookproductactions 21 ms - Mb
hooktop 12 ms - Mb
hookdisplayLeftColumnProduct 12 ms - Mb
hookdisplayFooterProduct 9 ms - Mb
hookdisplayProductButtons 9 ms - Mb
hookproducttab 8 ms - Mb
hookblockFooter1 7 ms - Mb
hookdisplayProductTab 6 ms - Mb
hookextraright 6 ms 0.25 Mb
hookblockFooter3 3 ms - Mb
hookblockFooter2 2 ms - Mb
hookblockFooter4 2 ms - Mb
hookDisplayOverrideTemplate 2 ms - Mb
hookblockFooterExtra 1 ms - Mb
hookmoduleRoutes 0 ms - Mb
hookactionProductOutOfStock - ms - Mb
31 hooks 14091 ms 55.50 Mb
Module Time Memory Usage
productscategory 5592 ms 19.50 Mb
attributewizardpro 2038 ms 2.75 Mb
contentpack 1469 ms 7.25 Mb
posvegamenu 968 ms 1.00 Mb
gsnippetsreviews 965 ms 5.50 Mb
posmegamenu 697 ms 0.75 Mb
possearchcategories 618 ms 2.50 Mb
blockcategories 307 ms 0.50 Mb
facebookpsessentials 206 ms 1.00 Mb
fbloginblock 170 ms 0.25 Mb
htmlboxpro 114 ms 1.25 Mb
mailalerts 87 ms 2.75 Mb
internationaltargeting 82 ms - Mb
posstaticfooter 80 ms 1.50 Mb
tawkto 78 ms 0.50 Mb
facebookpsshoptab 50 ms - Mb
sendtoafriend 49 ms 0.25 Mb
pm_modalcart3 43 ms 1.00 Mb
blockcart 43 ms 0.50 Mb
blockcurrencies 39 ms 0.75 Mb
blocklanguages 38 ms - Mb
blockmyaccountfooter 34 ms 1.00 Mb
blockcontact 31 ms - Mb
blockwishlist 27 ms - Mb
blocknewsletter 27 ms 0.50 Mb
posslideshow 25 ms 0.25 Mb
blockuserinfo 24 ms - Mb
stripe_official 21 ms 0.75 Mb
blockcms 20 ms 0.25 Mb
favoriteproducts 19 ms 0.25 Mb
blockviewed 19 ms - Mb
artfreegdpr 17 ms 1.00 Mb
posspecialproducts 16 ms - Mb
smartblog 16 ms 0.75 Mb
blocksupplier 16 ms - Mb
blockmanufacturer 12 ms 0.25 Mb
posthemeoption 10 ms - Mb
posstaticblocks 8 ms 0.25 Mb
blockpaymentlogo 7 ms - Mb
ganalytics 5 ms 0.25 Mb
blockmyaccount 3 ms - Mb
infinitescroll 3 ms 0.50 Mb
pm_multiplefeatures 2 ms - Mb
43 modules 14091 ms 55.50 Mb

Stopwatch SQL - 1524 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` = 9882950 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC
LIMIT 0,100
1133.8 182277 Yes /classes/Category.php:783
UPDATE `ps_smarty_lazy_cache`
SET filepath='5718/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="5718|1|4|4|14|1|21" AND compile_id=""
21.9 1 /classes/SmartyCustom.php:183
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 = 1991
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
21.3 0 /classes/Product.php:1278
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 = 20528 LIMIT 1
21 36 /classes/Product.php:752
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
20.9 139 /classes/module/Module.php:2141
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 = 1991
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
20.6 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` = 58869 LIMIT 1
18.1 1 /classes/Combination.php:344
UPDATE `ps_smarty_lazy_cache`
SET filepath='24119/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24119|1|4|4|14|1|21" AND compile_id=""
17.9 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` = 22205)
17.8 37 /classes/Product.php:2998
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`
16.6 304 Yes Yes /classes/Hook.php:355
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`=1991
16.2 46 /classes/Tag.php:205
UPDATE `ps_smarty_lazy_cache`
SET filepath='6275/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="6275|1|4|4|14|1|21" AND compile_id=""
16 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24166|1|4|4|14|1|21","", FROM_UNIXTIME(1611162508))
15.9 1 /classes/SmartyCustom.php:263
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
15.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` = 9882935) AND (b.`id_shop` = 1) LIMIT 1
15.4 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='24186/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24186|1|4|4|14|1|21" AND compile_id=""
15.4 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='22462/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22462|1|4|4|14|1|21" AND compile_id=""
15.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9883025
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
14.9 2 Yes Yes /classes/Category.php:859
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"5718|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
14.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21492|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
14.7 1 /classes/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='21492/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21492|1|4|4|14|1|21" AND compile_id=""
14.6 1 /classes/SmartyCustom.php:183
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 = 1991
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
14.4 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2249 AND `id_group` = 4 LIMIT 1
14.4 0 /classes/GroupReduction.php:149
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.4 9060 /classes/Configuration.php:148
UPDATE `ps_smarty_lazy_cache`
SET filepath='6422/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="6422|1|4|4|14|1|21" AND compile_id=""
14.3 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24096|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
13.8 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21288|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
13.8 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
13.6 529 /classes/Hook.php:236
UPDATE `ps_smarty_lazy_cache`
SET filepath='24194/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24194|1|4|4|14|1|21" AND compile_id=""
13.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 = 6272 LIMIT 1
13.3 73 /classes/Product.php:752
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 1991 AND `id_shop` = 1
13.3 11 /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 = 1845
ORDER BY f.position ASC
13 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1991) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
13 0 /classes/stock/StockAvailable.php:670
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 = 24194
ORDER BY f.position ASC
12.7 8 Yes /classes/Product.php:4453
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"2249|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
12.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` = 9882845) AND (b.`id_shop` = 1) LIMIT 1
12.4 1 /Adapter/Adapter_EntityMapper.php:61
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
12.4 196 /classes/module/Module.php:277
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
12.3 776 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 21810
ORDER BY `id_specific_price_priority` DESC LIMIT 1
12.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
12.3 16 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="6273|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 ('ea733b57dc2f56f5a2c707343aacf254',"24117|1|4|4|14|1|21","", FROM_UNIXTIME(1611162508))
12 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
11.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`='083720f0af31d239edd1031b3d29245f' AND cache_id="blockcontact|1|4|4|14|1|21" AND compile_id="" LIMIT 1
11.7 1 /classes/SmartyCustom.php:215
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` = 9883004) LIMIT 1
11.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 24096 AND deleted = 0  
AND id_shop = 1 LIMIT 1
11.6 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
11.6 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE pc.*
FROM `ps_reviewsnippets` pc
WHERE pc.`id_product` = 1991
AND pc.deleted = 0  AND id_shop = 1
ORDER BY pc.`date_add` DESC LIMIT 0 ,5
11.6 0 /modules/contentpack/classes/reviewshelp.class.php:520
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
11.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883009) LIMIT 1
11.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` = 58906 LIMIT 1
11.3 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
11.2 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` = 5025)
11.1 37 /classes/Product.php:2998
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22190|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
11 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6422) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
11 0 /classes/stock/StockAvailable.php:378
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"21941|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
11 1 /classes/SmartyCustom.php:263
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`=1991
11 46 /classes/Tag.php:205
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`=1991
10.8 46 /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
10.7 245 Yes /classes/Country.php:131
UPDATE `ps_smarty_lazy_cache`
SET filepath='24096/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24096|1|4|4|14|1|21" AND compile_id=""
10.5 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='2249/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="2249|1|4|4|14|1|21" AND compile_id=""
10.4 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"6422|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
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` = 735948 LIMIT 1
10.3 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 14
AND `active` = 1
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
10.2 153 Yes /modules/possearchcategories/possearchcategories.php:306
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 = 21288
ORDER BY f.position ASC
10 8 Yes /classes/Product.php:4453
UPDATE `ps_smarty_lazy_cache`
SET filepath='22307/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22307|1|4|4|14|1|21" AND compile_id=""
10 1 /classes/SmartyCustom.php:183
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` = 9882844) LIMIT 1
9.9 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` = 9883011
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
9.8 13 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883027 AND `id_shop` = 1
9.7 13 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"6273|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
9.6 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 55) LIMIT 1
9.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
9.6 300 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
9.5 1 /classes/shop/ShopUrl.php:169
UPDATE `ps_smarty_lazy_cache`
SET filepath='5808/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="5808|1|4|4|14|1|21" AND compile_id=""
9.5 1 /classes/SmartyCustom.php:183
UPDATE `ps_smarty_lazy_cache`
SET filepath='24182/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24182|1|4|4|14|1|21" AND compile_id=""
9.3 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE nleft, nright FROM `ps_category` WHERE id_category = 9882950 LIMIT 1
9.3 1 /classes/Category.php:1512
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="24186|1|4|4|14|1|21" AND compile_id="" LIMIT 1
9.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `link_rewrite` FROM `ps_category_lang` WHERE `id_category` = 1 LIMIT 1
9.2 13 /modules/facebookpsshoptab/facebookpsshoptab.php:1845
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883032) AND (b.`id_shop` = 1) LIMIT 1
9.2 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
9.1 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='f19000fcda7f38bfdc7cff8c81c5dd1d' AND cache_id="blockcategories|1|4|4|14|1|21|9882950|4" AND compile_id="" LIMIT 1
9.1 1 /classes/SmartyCustom.php:215
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` = 9883003) LIMIT 1
9.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
9 0 /classes/Hook.php:131
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` = 9883041) LIMIT 1
9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 14 AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE (c.`active` = 1 OR c.`id_category` = 9883001)
AND `level_depth` <= 4
AND cg.`id_group` IN (4)
ORDER BY `level_depth` ASC, cl.`name` ASC
9 147 Yes /modules/blockcategories/blockcategories.php:304
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 *
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
8.8 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
8.8 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="24194|1|4|4|14|1|21" AND compile_id="" LIMIT 1
8.8 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21255 AND id_shop=1 LIMIT 1
8.7 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4415
ORDER BY f.position ASC
8.7 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.6 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.6 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.5 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` = 58351 LIMIT 1
8.4 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22462|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
8.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 57 AND `id_shop` = 1
8.4 13 /Adapter/Adapter_EntityMapper.php:68
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.4 0 /classes/Category.php:1219
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24186|1|4|4|14|1|21","", FROM_UNIXTIME(1611162508))
8.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 6272 AND id_shop=1 LIMIT 1
8.3 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="5718|1|4|4|14|1|21" AND compile_id="" LIMIT 1
8.3 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 = 21255
ORDER BY f.position ASC
8.3 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1991
ORDER BY f.position ASC
8.3 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 5025 LIMIT 1
8.2 37 /classes/Product.php:765
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21492) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.1 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21492) AND (id_product_attribute = 58462) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 19
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1991) AND (b.`id_shop` = 1) LIMIT 1
8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1991 AND id_shop=1 LIMIT 1
8 1 /classes/Product.php:5032
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"20528|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
7.9 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 33382) 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 ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON a.`id_attribute` = al.`id_attribute`
LEFT JOIN `ps_attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group`
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 1991
AND al.`id_lang` = 14
AND agl.`id_lang` = 14
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
7.9 36 Yes Yes /override/classes/Product.php:28
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` = 710909 LIMIT 1
7.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6273) AND (id_product_attribute = 58018) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.8 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` = 45
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.8 15 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 = 24166
ORDER BY f.position ASC
7.8 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 24186 LIMIT 1
7.6 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 34248) AND (id_product_attribute = 735948) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.6 1 /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 = 1845 LIMIT 1
7.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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="5084|1|4|4|14|1|21" AND compile_id="" LIMIT 1
7.6 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
7.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9882923
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.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 = 5808
ORDER BY f.position ASC
7.5 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9882816_right"
7.5 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 27 AND `id_shop` = 1 LIMIT 1
7.5 1 /modules/fbloginblock/classes/facebookhelp.class.php:110
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE * FROM `ps_awp_attribute_wizard_pro`
7.5 1 /modules/attributewizardpro/attributewizardpro.php:252
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 = 22190
ORDER BY f.position ASC
7.5 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` = 9882890
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.5 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 33548) AND (id_product_attribute = 710909) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.5 0 /classes/stock/StockAvailable.php:378
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 = 1991
AND o.id_shop = 1 AND od.id_shop = 1
7.4 1 /modules/contentpack/classes/reviewshelp.class.php:984
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` = 9882844) AND (b.`id_shop` = 1) LIMIT 1
7.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24119 AND id_shop=1 LIMIT 1
7.4 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2249) AND (b.`id_shop` = 1) LIMIT 1
7.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883087 AND `id_shop` = 1
7.4 14 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 57574 LIMIT 1
7.4 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` = 9882959) LIMIT 1
7.4 1 /Adapter/Adapter_EntityMapper.php:61
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` = 9882950 LIMIT 1
7.3 1 /classes/Category.php:1054
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24186) AND (id_product_attribute = 58943) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
7.3 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"5808|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
7.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5718
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.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21255|1|4|4|14|1|21" AND compile_id="" LIMIT 1
7.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
7.2 16 /classes/Currency.php:472
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_1_right"
7.2 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2249 AND id_shop=1 LIMIT 1
7.1 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 31139) AND (id_product_attribute = 59054) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.1 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 21941 AND id_shop=1 LIMIT 1
7.1 1 /classes/Product.php:5032
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` = 9883024) LIMIT 1
7.1 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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="5718|1|4|4|14|1|21" AND compile_id="" LIMIT 1
7 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 pa.id_product = 33382 LIMIT 1
7 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
7 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9882934
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.9 1 Yes Yes /classes/Category.php:859
UPDATE `ps_smarty_lazy_cache`
SET filepath='21255/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21255|1|4|4|14|1|21" AND compile_id=""
6.9 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 = 1991 GROUP BY pac.id_attribute
6.9 36 Yes Yes /modules/attributewizardpro/attributewizardpro.php:2267
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` = 9883041) AND (b.`id_shop` = 1) LIMIT 1
6.9 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` = 21941) AND (b.`id_shop` = 1) LIMIT 1
6.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883089 AND `id_shop` = 1
6.8 14 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop
WHERE image_shop.`id_product` = 1991
AND image_shop.`cover`= 1 LIMIT 1
6.8 1 /classes/Image.php:295
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
6.8 13 /classes/Language.php:894
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 7) LIMIT 1
6.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 product_attribute_shop.default_on = 1  AND pa.id_product = 6513 LIMIT 1
6.8 37 /classes/Product.php:765
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` = 21288)
6.7 37 /classes/Product.php:2998
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` = 3581)
6.7 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 24117 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
6.7 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="24117|1|4|4|14|1|21" AND compile_id="" LIMIT 1
6.7 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21810|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
6.6 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` = 24182)
6.6 38 /classes/Product.php:2998
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 9882950
AND id_shop = 1 LIMIT 1
6.6 1 /classes/ObjectModel.php:1451
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` = 9883015) AND (b.`id_shop` = 1) LIMIT 1
6.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9882803
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.6 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5748) AND (id_product_attribute = 57870) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.6 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 = 5718
ORDER BY f.position ASC
6.6 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 5748 LIMIT 1
6.5 45 /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
6.5 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1991) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.5 0 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
6.5 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 1991 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
6.4 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` = 6422 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
6.4 0 /modules/contentpack/classes/reviewshelp.class.php:438
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` = ""
6.4 7 /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
6.4 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9883004
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
6.4 6 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
6.3 16 Yes /classes/SpecificPrice.php:361
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"6513|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
6.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
6.3 0 /classes/Category.php:1219
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883087) LIMIT 1
6.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883089) LIMIT 1
6.2 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` = 9882903
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 COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22205 AND deleted = 0  
AND id_shop = 1 LIMIT 1
6.2 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 45) LIMIT 1
6.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"24186|1|4|4|14|1|21","", FROM_UNIXTIME(1611162508))
6.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 5084 AND deleted = 0  
AND id_shop = 1 LIMIT 1
6.2 0 /modules/contentpack/classes/reviewshelp.class.php:413
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"24149|1|4|4|14|1|21","", FROM_UNIXTIME(1611162508))
6.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"24182|1|4|4|14|1|21","", FROM_UNIXTIME(1611162508))
6.1 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` = 57611 LIMIT 1
6.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` = 57870 LIMIT 1
6.1 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 21941 LIMIT 1
6.1 37 /classes/Product.php:765
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
6.1 1 /Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='productscategory/1991/9882950/1/4/4/14/1/21/ea/c0/77/eac0771dfb331f2f2c41ed4186abae6888e44e08.productscategory.tpl.php'
WHERE `template_hash`='83b6732a48d65fe35e1cf970ad056af2' AND cache_id="productscategory|1991|9882950|1|4|4|14|1|21" AND compile_id=""
6 1 /classes/SmartyCustom.php:183
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 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='24117/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24117|1|4|4|14|1|21" AND compile_id=""
6 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`=1991
6 46 /classes/Tag.php:205
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 14  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 9882950
AND `active` = 1
AND cg.`id_group` =4
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
5.9 1 Yes Yes /classes/Category.php:658
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 76 AND `id_shop` = 1 LIMIT 1
5.9 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="5808|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.9 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 43773 LIMIT 1
5.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3108) AND (id_product_attribute = 57389) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883081) AND (b.`id_shop` = 1) LIMIT 1
5.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
5.8 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` = 9882816) LIMIT 1
5.8 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"6275|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
5.8 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_9883049"
5.8 7 /modules/posvegamenu/posvegamenu.php:553
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` = 58536 LIMIT 1
5.8 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21810) 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` = 33548) AND (b.`id_shop` = 1) LIMIT 1
5.7 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` = 9883029) AND (b.`id_shop` = 1) LIMIT 1
5.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 24117 AND `id_group` = 4 LIMIT 1
5.7 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 = 6272
ORDER BY f.position ASC
5.7 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 24182 LIMIT 1
5.7 38 /classes/Product.php:752
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 33382
ORDER BY f.position ASC
5.7 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
5.6 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 = 5025
ORDER BY f.position ASC
5.6 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 18
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1991) AND (b.`id_shop` = 1) LIMIT 1
5.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` = 5808) AND (b.`id_shop` = 1) LIMIT 1
5.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
5.6 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
5.6 1 Yes /modules/contentpack/classes/guestbook.class.php:206
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24117) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.6 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21066) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.6 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_attribute_shop.`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` = 57463 LIMIT 1
5.6 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6513) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.6 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE product_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` = 1845)
5.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` = 9883089) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 68 AND `id_shop` = 1 LIMIT 1
5.5 1 /modules/fbloginblock/classes/facebookhelp.class.php:132
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21288 AND `id_group` = 4 LIMIT 1
5.5 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22190) AND (id_product_attribute = 58573) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.5 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883035) AND (b.`id_shop` = 1) LIMIT 1
5.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 product_attribute_shop.default_on = 1  AND pa.id_product = 4415 LIMIT 1
5.5 37 /classes/Product.php:765
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.4 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 33382
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.4 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` = 9883065) AND (b.`id_shop` = 1) LIMIT 1
5.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 = 3581 LIMIT 1
5.3 38 /classes/Product.php:752
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21066|1|4|4|14|1|21" AND compile_id="" LIMIT 1
5.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24186) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
5.3 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` = 4415) AND (b.`id_shop` = 1) LIMIT 1
5.3 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
5.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 22190
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6585) AND (id_product_attribute = 58166) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
5.2 16 Yes /classes/SpecificPrice.php:361
UPDATE `ps_smarty_lazy_cache`
SET filepath='21941/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="21941|1|4|4|14|1|21" AND compile_id=""
5.2 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` = 33382) AND (b.`id_shop` = 1) LIMIT 1
5.2 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
5.2 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9883027
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5.2 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` = 9882942) AND (b.`id_shop` = 1) LIMIT 1
5.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2249
ORDER BY `id_specific_price_priority` DESC LIMIT 1
5.2 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
5.1 775 /classes/SpecificPrice.php:238
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` = 6273)
5.1 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 product_attribute_shop.default_on = 1  AND pa.id_product = 28528 LIMIT 1
5.1 37 /classes/Product.php:765
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 14 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 14 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 14)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 1991 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
5.1 9 Yes Yes /classes/Product.php:3598
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 = 5748 LIMIT 1
5.1 45 /classes/Product.php:765
SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 )
WHERE p.`id_product` = 1991
AND l.`active` = 1
5 13 /classes/Product.php:5014
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` = 31139) AND (b.`id_shop` = 1) LIMIT 1
5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 60 AND `id_shop` = 1 LIMIT 1
5 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` = 9883029
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
5 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` = 9882896) AND (b.`id_shop` = 1) LIMIT 1
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` = 9882951) AND (b.`id_shop` = 1) LIMIT 1
4.9 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` = 20528) AND (b.`id_shop` = 1) LIMIT 1
4.9 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
4.9 1 /classes/shop/Shop.php:1067
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` = 54392 LIMIT 1
4.9 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 57389 LIMIT 1
4.8 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5808
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.8 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 1991 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
4.8 0 /modules/contentpack/classes/reviewshelp.class.php:438
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` = 22205) AND (b.`id_shop` = 1) LIMIT 1
4.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 58092 LIMIT 1
4.8 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 33415) AND (b.`id_shop` = 1) LIMIT 1
4.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
4.8 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` = 3108) AND (b.`id_shop` = 1) LIMIT 1
4.8 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
4.8 1 /classes/ObjectModel.php:1451
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('f19000fcda7f38bfdc7cff8c81c5dd1d',"blockcategories|1|4|4|14|1|21|9882950|4","", FROM_UNIXTIME(1611162510))
4.7 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` = 9882925) AND (b.`id_shop` = 1) LIMIT 1
4.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
where id_shop =1 
AND id_lang =14
AND `identify` like "pt_ver_item_menu%"
4.7 7 /modules/posvegamenu/posvegamenu.php:567
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 31139
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.7 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22205 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
4.7 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1991) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.7 0 /classes/stock/StockAvailable.php:670
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 = 5808 LIMIT 1
4.7 36 /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 product_attribute_shop.default_on = 1  AND pa.id_product = 33382 LIMIT 1
4.6 37 /classes/Product.php:765
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
4.6 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.6 0 /classes/Category.php:1219
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` = 57833 LIMIT 1
4.6 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34248) AND (b.`id_shop` = 1) LIMIT 1
4.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22205 AND `id_group` = 4 LIMIT 1
4.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 22190 AND id_shop=1 LIMIT 1
4.5 1 /classes/Product.php:5032
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 6273) AND (b.`id_shop` = 1) LIMIT 1
4.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 21255 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
4.5 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_prodquestions` pc
WHERE `id_product` = 1991 AND is_active = 1 
AND  id_shop = 1 AND id_lang = 14 LIMIT 1
4.5 40 /modules/contentpack/classes/prodquestionshelp.class.php:65
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24149|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4.5 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 24119 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
4.5 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9883082"
4.5 7 /modules/posvegamenu/posvegamenu.php:553
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5084 AND id_shop=1 LIMIT 1
4.5 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` = 58
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
4.5 2 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` = 9882891) AND (b.`id_shop` = 1) LIMIT 1
4.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 22190 AND `id_group` = 4 LIMIT 1
4.4 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 = 5084 LIMIT 1
4.4 37 /classes/Product.php:752
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 24194
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.4 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24119|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4.4 1 /classes/SmartyCustom.php:215
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` = 21066) AND (b.`id_shop` = 1) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_ver_menu_idcat_9883042"
4.4 7 /modules/posvegamenu/posvegamenu.php:553
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"6273|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
4.4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883011) LIMIT 1
4.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2021-01-20 00:00:00' AND '2021-01-20 23:59:59' LIMIT 1
4.4 775 /classes/SpecificPrice.php:301
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` = 6275) AND (b.`id_shop` = 1) LIMIT 1
4.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 21941 AND deleted = 0  
AND id_shop = 1 LIMIT 1
4.3 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` = 58018 LIMIT 1
4.3 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 1991) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.3 0 /classes/stock/StockAvailable.php:670
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 6585
ORDER BY `id_specific_price_priority` DESC LIMIT 1
4.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883042 AND `id_shop` = 1
4.3 14 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22205|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4.3 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
4.3 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
4.3 196 /classes/module/Module.php:277
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 21810 AND `id_group` = 4 LIMIT 1
4.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24194) AND (id_product_attribute = 58980) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.3 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 28528 AND id_shop=1 LIMIT 1
4.3 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 product_attribute_shop.default_on = 1  AND pa.id_product = 1991 LIMIT 1
4.3 36 /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 = 24117
ORDER BY f.position ASC
4.2 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 1991 AND deleted = 0  
AND id_shop = 1 LIMIT 1
4.2 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 9883088) AND (b.`id_shop` = 1) LIMIT 1
4.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 1991
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
4.2 0 /classes/Product.php:1278
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 11 AND `id_shop` = 1 LIMIT 1
4.2 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
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 = 33415
ORDER BY f.position ASC
4.2 8 Yes /classes/Product.php:4453
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 4 AND `id_shop` = 1 LIMIT 1
4.2 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
4.2 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE 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 = 1 AND pas.id_product_attribute = pac.id_product_attribute AND pas.id_product_attribute = pa.id_product_attribute AND pa.id_product = 1991 GROUP BY pac.id_attribute
4.2 36 Yes Yes /modules/attributewizardpro/attributewizardpro.php:2271
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`,
ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, pa.`unit_price_impact`, IFNULL(stock.quantity, 0) as quantity
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 14)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 14)
WHERE pa.`id_product` = 1991 
GROUP BY pa.`id_product_attribute`, a.`id_attribute`
ORDER BY pa.`id_product_attribute`
4.2 36 Yes Yes /modules/attributewizardpro/attributewizardpro.php:1941
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 14
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
4.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_currency`
WHERE `deleted` = 0
AND `id_currency` = 1 LIMIT 1
4.1 1 /classes/Currency.php:304
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22190|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4.1 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` = 9883038) AND (b.`id_shop` = 1) LIMIT 1
4.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 1991) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.1 0 /classes/stock/StockAvailable.php:646
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="24166|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4 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="21810|1|4|4|14|1|21" AND compile_id="" LIMIT 1
4 1 /classes/SmartyCustom.php:215
UPDATE `ps_smarty_lazy_cache`
SET filepath='5748/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="5748|1|4|4|14|1|21" AND compile_id=""
4 1 /classes/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"5084|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
4 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 24119 AND deleted = 0  
AND id_shop = 1 LIMIT 1
4 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 6275 AND `id_group` = 4 LIMIT 1
4 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2249)
4 72 /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` = 23
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1991) AND (b.`id_shop` = 1) LIMIT 1
4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882889) AND (b.`id_shop` = 1) LIMIT 1
4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM ps_pos_staticblock AS psb 
LEFT JOIN ps_pos_staticblock_lang AS psl ON psb.id_posstaticblock = psl.id_posstaticblock
LEFT JOIN ps_pos_staticblock_shop AS pss ON psb.id_posstaticblock = pss.id_posstaticblock
WHERE id_shop =1 
AND id_lang =14
AND `identify` = "pt_menu_idcat_45_right"
3.9 7 /modules/posmegamenu/posmegamenu.php:556
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` = 3108)
3.9 38 /classes/Product.php:2998
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 21492 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.9 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 24149 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.9 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5025) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5084) AND (id_product_attribute = 57759) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.9 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.9 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 58943 LIMIT 1
3.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
3.8 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883009) AND (b.`id_shop` = 1) LIMIT 1
3.8 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` = 9883028
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.8 1 Yes Yes /classes/Category.php:859
UPDATE `ps_smarty_lazy_cache`
SET filepath='22205/1/4/4/14/1/21/da/fd/63/dafd633a9574a03e984838ffab1c1b610d57c447.liststars.tpl.php'
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="22205|1|4|4|14|1|21" AND compile_id=""
3.8 1 /classes/SmartyCustom.php:183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 34248) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 1 /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` = 9883063
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.8 3 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 78 AND `id_shop` = 1 LIMIT 1
3.8 1 /modules/fbloginblock/classes/facebookhelp.class.php:87
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` = 20528)
3.8 36 /classes/Product.php:2998
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
3.8 4 /modules/posstaticfooter/models/Staticfooter.php:51
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 1991 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.8 0 /modules/contentpack/classes/reviewshelp.class.php:413
SELECT SQL_NO_CACHE * FROM `ps_fbloginblock_img`
WHERE `type` = 77 AND `id_shop` = 1 LIMIT 1
3.8 1 /modules/fbloginblock/classes/facebookhelp.class.php:66
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 6273 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.8 0 /modules/contentpack/classes/reviewshelp.class.php:413
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` = 9883036) AND (b.`id_shop` = 1) LIMIT 1
3.8 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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="22462|1|4|4|14|1|21" AND compile_id="" LIMIT 1
3.7 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"21941|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
3.7 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('ea733b57dc2f56f5a2c707343aacf254',"22190|1|4|4|14|1|21","", FROM_UNIXTIME(1611162507))
3.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` = 58388 LIMIT 1
3.7 1 /classes/Combination.php:344
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"6275|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
3.7 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
3.7 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883038 AND `id_shop` = 1
3.7 13 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883011 AND `id_shop` = 1
3.7 13 /Adapter/Adapter_EntityMapper.php:68
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` = 9882950 LIMIT 1
3.7 1 /classes/Category.php:1054
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` = 3354)
3.7 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 5084 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
3.6 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1991) AND (b.`id_shop` = 1) LIMIT 1
3.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3108 AND `id_group` = 4 LIMIT 1
3.6 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 4) LIMIT 1
3.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 14
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9883087) AND (b.`id_shop` = 1) LIMIT 1
3.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 1991
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-01-20 00:00:00",
INTERVAL 1000 DAY
)
) > 0
3.5 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` = 58499 LIMIT 1
3.5 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="21810|1|4|4|14|1|21" AND compile_id="" LIMIT 1
3.5 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6422) AND (id_product_attribute = 58092) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.5 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 33415) AND (id_product_attribute = 706025) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.5 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` = 22462)
3.5 36 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 24149) AND (id_product_attribute = 58832) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.5 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 = 22462
ORDER BY f.position ASC
3.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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1991) AND (b.`id_shop` = 1) LIMIT 1
3.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9883038
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.4 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` = 9882959) AND (b.`id_shop` = 1) LIMIT 1
3.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` = 9883032
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 14
AND c.`id_parent` = 9882883
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.4 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6275) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.4 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 6422
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.4 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE ceil(AVG(`rating`)) AS "avg_rating"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 6513 AND deleted = 0 AND active = 1  AND id_shop = 1 LIMIT 1
3.4 0 /modules/contentpack/classes/reviewshelp.class.php:438
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='61f05a93af7fd62c675c5e05d1570a22' AND cache_id="24166|1|4|4|14|1|21" AND compile_id="" LIMIT 1
3.4 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 14)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 14)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 14)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 22307
ORDER BY f.position ASC
3.4 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` = 5718) AND (b.`id_shop` = 1) LIMIT 1
3.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` = 24182) AND (b.`id_shop` = 1) LIMIT 1
3.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5748) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.3 1 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 24
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1991) AND (b.`id_shop` = 1) LIMIT 1
3.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 product_attribute_shop.default_on = 1  AND pa.id_product = 4414 LIMIT 1
3.3 36 /classes/Product.php:765
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 6513
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 21492 LIMIT 1
3.3 38 /classes/Product.php:765
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
3.3 1 Yes Yes /classes/Category.php:859
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` = 64) LIMIT 1
3.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 33415
ORDER BY `id_specific_price_priority` DESC LIMIT 1
3.3 0 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4414 LIMIT 1
3.3 36 /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 = 1845 LIMIT 1
3.3 36 /classes/Product.php:752
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 1991 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.3 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',"5084|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
3.3 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` = 22190) AND (b.`id_shop` = 1) LIMIT 1
3.2 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`='ea733b57dc2f56f5a2c707343aacf254' AND cache_id="21941|1|4|4|14|1|21" AND compile_id="" LIMIT 1
3.2 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` = 9882842) AND (b.`id_shop` = 1) LIMIT 1
3.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5025 AND id_shop=1 LIMIT 1
3.2 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` = 57426 LIMIT 1
3.2 1 /classes/Combination.php:344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21941) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.2 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 9883025 AND `id_shop` = 1
3.2 13 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('61f05a93af7fd62c675c5e05d1570a22',"6422|1|4|4|14|1|21","", FROM_UNIXTIME(1611162506))
3.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 21941 LIMIT 1
3.2 37 /classes/Product.php:752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5808) AND (id_product_attribute = 57907) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.2 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 24186 AND id_shop=1 LIMIT 1
3.2 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 = 34248 LIMIT 1
3.2 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` = 9883042) AND (b.`id_shop` = 1) LIMIT 1
3.2 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
3.2 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5748) AND (b.`id_shop` = 1) LIMIT 1
3.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22205) AND (id_product_attribute = 58610) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.2 0 /classes/stock/StockAvailable.php:378
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5025) AND (id_product_attribute = 57722) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.2 0 /classes/stock/StockAvailable.php:378
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
3.2 146 Yes /modules/posmegamenu/posmegamenu.php:997
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `ps_reviewsnippets` pc
WHERE `id_product` = 22462 AND deleted = 0  
AND id_shop = 1 LIMIT 1
3.2 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` = 1991)
3.2 37 /classes/Product.php:2998
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 4, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 4) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-01-20 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.1 16 Yes /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1991
3.1 36 /classes/Product.php:2168
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 14 AND cl.id_shop = 1 ) WHERE c.`id_category` = 0 LIMIT 1
3.1 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` = 9883042
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
3.1 1 Yes Yes /classes/Category.php:859
SELECT SQL_NO_CACHE 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` = 59054 LIMIT 1
3.1 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
3.1 16 Yes /classes/SpecificPrice.php:361
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 = 24149 LIMIT 1
3.1 37 /classes/Product.php:752
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 9882832) LIMIT 1
3.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
3.1 1 /classes/Image.php:472
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` = 6272)
3.1 73 /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` = 21288) AND (b.`id_shop` = 1) LIMIT 1
3.1 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`='8c84b522ca0dfbb3eb634d8cc07c1576' AND cache_id="blockmyaccountfooter|1|4|4|14|1|21" AND compile_id="" LIMIT 1
3.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 14)
WHERE `level_depth` = 1
3.1 24 /classes/Category.php:1673