Pescado Hay 37 productos.

Mostrando 1 - 37 de 37 items
  • Vista rápida
    6,50 € / unidad / kg

    Cada pieza entera pesa entre 400 - 600 gr., indícanos cómo deseas recibirla. Pescado blanco tradicional en la cocina española. Recibe su nombre por la mancha del mismo color presente en los ojos. Una de las especies por excelencia de la acuicultura marina. La dorada de cultivo se diferencia de la salvaje por tener una coloración más apagada y mayor nivel...

    6,50 € / unidad / kg
  • Vista rápida
    6,50 € / unidad / kg

    Piezas de 400-600 gr. Pescado blanco, es una de las especies con más tradición dentro de la acuicultura marina. La lubina de cultivo, a diferencia de la salvaje, está presente en el mercado a lo largo de todo el año. Se puede considerar uno de los pescados más magros que hay, lo que significa que es un alimento bajo en grasas. Espinas grandes aunque...

    6,50 € / unidad / kg
  • Vista rápida
    9,90 € / unidad / unidad

    Patas enteras y cocidas, 2 patas en cada bolsa de 250 gr. El precio indicado es por bolsa. Con este producto evitamos el trastorno de cocer el pulpo en casa, y podemos disfrutar de este exquisito cefalópodo sin apenas trabajo, como si estuviésemos en cualquier rincón de Galicia. Basta con abrir la bolsa, y prepararlo a nuestro gusto. Calentándolo y...

    9,90 € / unidad / unidad
  • Vista rápida
    11,50 € / unidad / kg

    Pescado blanco, de forma plana procedente de fondos arenosos a media profundidad. Muy apreciado por su carne blanca y fina, de sabor delicado. Su preparación varía según el tamaño, los pequeños son ideales enharinados y a la plancha, los más grandes al horno. Muchos ejemplares que se ven en los mercados son procedentes de Francia y Senegal, pero el nivel...

    11,50 € / unidad / kg
  • Vista rápida
    12,50 € / kg / unidad

    Cada pieza de salmón pesa entre 3 y 4 kg., indícanos cómo deseas recibirla: entera, limpia, filetes, lomitos, rodajas... Pescado azul procedente de cultivo en Noruega muy popular en toda Europa gracias a sus propiedades alimenticias, ya que es rico en ácidos grasos omega3 y proteínas por lo que es el complemento perfecto para deportistas. Para disfrutar...

    12,50 € / kg / unidad
  • Vista rápida
    12,80 € / unidad / unidad

    Patas enteras y cocidas en su jugo, 2 patas en cada bolsa de 300 a 400 gr. El precio indicado es por bolsa. Con este producto evitamos el trastorno de cocer el pulpo en casa y preparar de una manera y rápida una exquisita tapa de Pulpo "á feira" como si de una "Pulpeira" se tratase, bien a baño maría o en el microondas. 100% natural, sin conservantes ni...

    12,80 € / unidad / unidad
  • Pescado azul procedente de las profundidades del océano atlántico y capturado artesanalmente en la llamada "Campaña Costera del Bonito". Pescado rico en grasas saludables y proteínas, que ayudan a reducir los niveles de colesterol y la prevención de afecciones cardiacas. Cada pieza entera de bonito pesan entre 5 y 6 kg., indícanos cómo deseas recibirla:...

  • Vista rápida
    13,50 € / kg / unidad

    Piezas de 2,5 kg. aprox. El pescado blanco más consumido en la cocina española, ideal para dietas bajas en grasa y dietas infantiles. Entre todas las variantes de merluza, la de pincho es la de mayor calidad ya que su carne es mucho más consistente, en parte gracias a su sistema de pesca más selectivo. Disponemos de piezas de diferentes tamaños...

    13,50 € / kg / unidad
  • Vista rápida
    14,50 € / kg / unidad

    El pescado blanco más consumido en la cocina española, ideal para dietas bajas en grasa y dietas infantiles. Entre todas las variantes de merluza, la de pincho es la de mayor calidad ya que su carne es mucho más consistente, en parte gracias a su sistema de pesca más selectivo. Disponemos de piezas de diferentes tamaños ajustándonos a tus necesidades....

    14,50 € / kg / unidad
  • Vista rápida
    14,90 € / kg / unidad

    Piezas de 2,5 a 3 kg. aprox. El pescado blanco más apreciado por nuestros clientes. A pesar de su feo aspecto es un auténtico manjar. Su alimentación está basada en pescados y moluscos y por ese motivo su carne tiene esa textura y sabor tan especial. A diferencia del rape blanco o juliana, la carne del rape negro no encoje al cocinarse. La cola del rape...

    14,90 € / kg / unidad
  • Vista rápida
    15,50 € / kg / unidad

    Piezas de 3,5 kg. aprox. El pescado blanco más consumido en la cocina española, ideal para dietas bajas en grasa y dietas infantiles. Entre todas las variantes de merluza, la de pincho es la de mayor calidad ya que su carne es mucho más consistente, en parte gracias a su sistema de pesca más selectivo. Disponemos de piezas de diferentes tamaños...

    15,50 € / kg / unidad
  • Vista rápida
    15,80 € / kg / unidad

    Piezas de 4 kilos aprox. El pescado blanco más apreciado por nuestros clientes. A pesar de su feo aspecto es un auténtico manjar. Su alimentación está basada en pescados y moluscos y por ese motivo su carne tiene esa textura y sabor tan especial. A diferencia del rape blanco o juliana, la carne del rape negro no encoje al cocinarse. La cola del rape negro...

    15,80 € / kg / unidad
  • Vista rápida
    16,50 € / kg / unidad

    Piezas de 4,5 kg. aprox. El pescado blanco más consumido en la cocina española, ideal para dietas bajas en grasa y dietas infantiles. Entre todas las variantes de merluza, la de pincho es la de mayor calidad ya que su carne es mucho más consistente, en parte gracias a su sistema de pesca más selectivo. Disponemos de piezas de diferentes tamaños...

    16,50 € / kg / unidad
  • Vista rápida
    18,50 € / kg / unidad

    Pieza de lomo entero de salmón sin cabeza. Cada lomo pesa 1,2 kg. apróx. Pescado azul procedente de cultivo en Noruega muy popular en toda Europa gracias a sus propiedades alimenticias, ya que es rico en ácidos grasos omega3 y proteínas por lo que es el complemento perfecto para deportistas. Para disfrutar al máximo de su jugosa carne, el principal...

    18,50 € / kg / unidad
  • Vista rápida
    18,50 € / kg / unidad

    Piezas de 1,8 a 2 kg. aprox. Pescado blanco de gran presencia en el mercado, que se diferencia del salvaje en la coloración de su piel y por la ausencia de los bultitos duros que le caracterizan. Diseñado para abastecer la demanda de este apreciado pescado de forma estable, a un precio asequible y una calidad verificada. Te lo enviamos a casa como desees:...

    18,50 € / kg / unidad
  • Vista rápida
    19,50 € / kg / kg

    Unas 3 ó 4 piezas completan el kilo de calamar. Producto estrella para muchos de nuestros clientes. Presente en casi todo el mundo, es un producto que ofrece una alta variedad de estilos de cocina. De fácil y rápida preparación, es por tanto muy utilizado por padres preocupados de ofrecerles a sus hijos un pescado sabroso y nutritivo, sin poder dedicar...

    19,50 € / kg / kg
  • Piezas de 800 gramos, ocasionalmente pueden rondar el kilo. Se sirve entero y limpio. Pescado semigraso, rico en minerales y vitaminas. Posee una carne con muchas espinas, por lo que es muy común en la elaboración de sopas o cremas, aunque acepta otras muchas recetas como el llamado pastel de cabracho. También es frecuente prepararlo a la plancha o a la...

  • Vista rápida
    21,50 € / kg / unidad

    Se envía la pieza entera congelada sin cocer. Cada pieza tiene un peso de entre 2,5 y 3 kg. Cefalópodo muy popular en España, y fácilmente reconocible para la mayoría, tanto si está cocido como si no. Para cocinar un pulpo entero debemos congelarlo previamente, para romper las fibras y evitar que su textura al cocinarlo sea demasiado dura.

    21,50 € / kg / unidad
  • Cada pieza pesa 200 -300gr. Indícanos cómo quieres recibirlos: enteros o limpios. Pescado pequeño, de carne blanca y semigrasa. La época de captura aumenta en primavera y verano, protagonizando numerosos platos ideales para la época estival.

  • Vista rápida
    22,50 € / kg / unidad

    Piezas de 1 kg aprox. Es el gallo ideal para preparar en filetes. Indícanos cómo deseas recibirlo: entero, limpio, filetes… En las Rías Baixas le llamamos "rapante", y "meiga" un poco más al norte. Pescado blanco muy apropiado para dietas infantiles, gracias a su textura y sabor suaves, especialmente las piezas más grandes que son más fáciles de limpiar.

    22,50 € / kg / unidad
  • Vista rápida
    22,50 € / kg / kg

    Pescado azul rico en ácidos omega 3 muy recomendado para personas que necesitan cuidar su dieta por problemas coronarios. Existe una docena de variedades de atún, de entre todas ellas en Mariskito te ofrecemos del llamado atún de aleta amarilla, una especie de excelente calidad y variados usos culinarios. Te enviamos el lomo limpio y sin piel ni espinas...

    22,50 € / kg / kg
  • Las rodajas de salmón se presentan en bandejas (entre 4 y 6 rodajas), siendo el peso de cada bandeja de 1 kg. Pescado azul procedente de cultivo en Noruega muy popular en toda Europa gracias a sus propiedades alimenticias, ya que es rico en ácidos grasos omega3 y proteínas por lo que es el complemento perfecto para deportistas. Para disfrutar al máximo de...

  • Vista rápida
    23,50 € / kg / kg

    También llamado "emperador". Pescado azul de carne magra con alto contenido vitamínico y muy bajo en grasas, fácilmente reconocible por su característico pico. Su sabor suave y textura consistente permite un sinfín de posibilidades en la cocina familiar. De los grandes lomos limpios y sin espinas, preparamos la cantidad que desees en rodajas.

    23,50 € / kg / kg
  • Cefalópodo de carne más gruesa que el calamar, muy apreciado en la gastronomía. En Galicia, muy presente en sus rías, se le hace llamar “choco”. Se pesca durante los meses más fríos, de Octubre a Abril. En su tinta, a la plancha, cocido… tú decides cómo disfrutarlo. Te lo enviamos limpio, entero y con piel.

  • Piezas entre 2,5 y 3 kg. Pescado blanco tradicional en la cocina española. Recibe su nombre por la mancha del mismo color presente entre los ojos. Con menor presencia en las costas gallegas que la lubina, su pesca es más frecuente en el Mar Mediterráneo. La dorada salvaje, puede llegar a los 70 centímetros, tiene una carne firme y de un sabor muy especial...

  • Vista rápida
    27,50 € / kg / unidad

    La auténtica lubina salvaje es la gran desconocida para muchos y que la presencia de las de cultivo ha capturado una buena parte del mercado en las plazas debido a su precio. El sabor y textura de la lubina salvaje está muy por encima de las procedentes de piscifactoría, debido a su alimentación rica en crustáceos y peces pequeños, lo que adquiere un...

    27,50 € / kg / unidad
  • Vista rápida
    28,50 € / kg / unidad

    Piezas de 1,3 a 2 kg. aprox. Pescado blanco de extraordinaria calidad y muy cotizado por nuestros clientes. El ejemplar salvaje, debido a su escasa presencia en el mercado, es el más apreciado; su sabrosa carne invita a la menor manipulación posible: a la plancha, entero al horno, cocido o al vapor. Opción ideal para fiestas y celebraciones. Disponemos de...

    28,50 € / kg / unidad
  • Vista rápida
    29,50 € / kg / unidad

    La auténtica lubina salvaje es la gran desconocida para muchos y que la presencia de las de cultivo ha capturado una buena parte del mercado en las plazas debido a su precio. El sabor y textura de la lubina salvaje está muy por encima de las procedentes de piscifactoría, debido a su alimentación rica en crustáceos y peces pequeños, lo que adquiere un...

    29,50 € / kg / unidad
  • Vista rápida
    31,50 € / kg / unidad

    La auténtica lubina salvaje es la gran desconocida para muchos y que la presencia de las de cultivo ha capturado una buena parte del mercado en las plazas debido a su precio. El sabor y textura de la lubina salvaje está muy por encima de las procedentes de piscifactoría, debido a su alimentación rica en crustáceos y peces pequeños, lo que adquiere un...

    31,50 € / kg / unidad
  • Vista rápida
    31,50 € / kg / unidad

    La auténtica lubina salvaje es la gran desconocida para muchos y que la presencia de las de cultivo ha capturado una buena parte del mercado en las plazas debido a su precio. El sabor y textura de la lubina salvaje está muy por encima de las procedentes de piscifactoría, debido a su alimentación rica en crustáceos y peces pequeños, lo que adquiere un...

    31,50 € / kg / unidad
  • Vista rápida
    31,50 € / kg / unidad

    El pescado blanco más apreciado por nuestros clientes. A pesar de su feo aspecto es un auténtico manjar. Su alimentación está basada en pescados y moluscos y por ese motivo su carne tiene esa textura y sabor tan especial. A diferencia del rape blanco o juliana, la carne del rape negro no encoje al cocinarse. La cola del rape negro supone aproximadamente...

    31,50 € / kg / unidad
  • Vista rápida
    32,00 € / kg / unidad

    El peso de la pieza es de 1,5 kg. aprox. Pescado blanco, de leyenda bíblica, procedente de los fondos rocosos del Mediterráneo y del Atlántico. Tiene un sabor parecido al lenguado, la carne es muy fina aportando un sabor delicado al paladar. Los más culinarios, recomiendan su consumo en filetes, eliminando todas las espinas, rebozados y fritos. También...

    32,00 € / kg / unidad
  • Vista rápida
    32,50 € / kg / unidad

    Piezas de 2 a 2,5 kg. aprox. Pescado blanco de extraordinaria calidad y muy cotizado por nuestros clientes. El ejemplar salvaje, debido a su escasa presencia en el mercado, es el más apreciado; su sabrosa carne invita a la menor manipulación posible: a la plancha, entero al horno, cocido o al vapor. Opción ideal para fiestas y celebraciones. Disponemos de...

    32,50 € / kg / unidad
  • Pescado muy habitual en las costas del Atlántico y del Mediterráneo. Físicamente similar a la dorada salvaje, su apetitoso sabor se debe a una alimentación rica en moluscos y percebes. Pescado perfecto para hacer al horno ya que realza su sabor natural. También se consume frito, a la plancha o a la brasa. Indícanos como te gustaría recibirlo: entero,...

  • Vista rápida
    42,00 € / kg / unidad

    Piezas de 4 kg. aprox. Pescado de cuerpo robusto y voluminoso de carne firme y sabrosa. Con el nombre genérico de mero se identifica numerosas especies. El mero gris o cherna es el más común en la costa Atlántica, caracterizado por su color gris oscuro y más claro en el vientre. Debido a su gran tamaño y alto valor comercial (las piezas más pequeñas son...

    42,00 € / kg / unidad
  • Vista rápida
    49,00 € / kg / unidad

    Piezas de 1,5 kg. aprox. Pescado blanco muy apreciado en nuestra gastronomía, muy presente en menús navideños. También conocido como "besugo de la pinta", por las manchas negras que posee sobre los costados, se pesca mayoritariamente en el occidente del Mar Mediterráneo y parte oriental del Océano Atlántico, su presencia aumenta durante los meses fríos....

    49,00 € / kg / unidad
  • Vista rápida
    72,00 € / unidad / unidad

    Variado de pescado fresco de excelente calidad: 1 kg. de Calamar 2,5 - 3 kg. de Merluza 1 kg. de Lomo de Atún * Envío sujeto a disponibilidad de los productos Puedes consultar la información de cada pescado en sus respectivas fichas de producto. Indícanos en el cuadro de preparación como quieres que te lo preparemos.

    72,00 € / unidad / unidad
Mostrando 1 - 37 de 37 items
Load Time15196 ms - You'd better run your shop on a toaster
Querying Time1525 ms
Queries928
Memory Peak Usage28.5 Mb
Included Files272 files - 4.93 Mb
PrestaShop Cache- Mb
Global vars0.98 Mb
PrestaShop Version1.6.1.6
PHP Version5.6.30-0+deb8u1 (OK)
MySQL Version5.5.47-0+deb8u1 (Consider upgrading)
Memory Limit256M
Max Execution Time60s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 33 ms 33 ms 4.87 Mb 5.00 Mb
__construct 0 ms 33 ms - Mb 5.00 Mb
init 11 ms 44 ms 1.23 Mb 6.22 Mb
checkAccess 0 ms 44 ms - Mb 6.22 Mb
setMedia 4 ms 48 ms 0.14 Mb 6.36 Mb
postProcess 0 ms 48 ms - Mb 6.36 Mb
initHeader 0 ms 48 ms - Mb 6.36 Mb
initContent 4397 ms 4445 ms 15.24 Mb 21.54 Mb
initFooter 453 ms 4898 ms 0.62 Mb 22.22 Mb
display 10298 ms 15196 ms 5.39 Mb 28.47 Mb
Hook Time Memory Usage
hookproductlistassign 205 ms 8.75 Mb
hookfooter 79 ms - Mb
__construct 51 ms 5.00 Mb
hookleftcolumn 42 ms - Mb
hookHeader 14 ms - Mb
hooktop 8 ms - Mb
hookdisplayHeader 6 ms - Mb
hookdisplayTop 4 ms - Mb
hookdisplayNav 3 ms - Mb
hookdisplayFooter 3 ms - Mb
hookdisplayProductPriceBlock 1 ms - Mb
hookdisplayLeftColumn 1 ms - Mb
hookdisplayTopColumn - ms - Mb
13 hooks 417 ms 13.75 Mb
Module Time Memory Usage
blocklayered 218 ms 9.25 Mb
statsdata 68 ms 0.50 Mb
blocktags 36 ms - Mb
blocknewsletter 14 ms 1.75 Mb
blockcart 11 ms - Mb
paypal 8 ms 0.50 Mb
uecookie 7 ms - Mb
pproperties 6 ms - Mb
blocktopmenu 6 ms 0.25 Mb
themeconfigurator 4 ms - Mb
blocksearch 4 ms - Mb
blockcms 4 ms - Mb
blockuserinfo 3 ms - Mb
blocksocial 3 ms - Mb
blockcontactinfos 3 ms - Mb
deliverydays 2 ms - Mb
ganalytics 2 ms - Mb
sekeywords 2 ms 0.25 Mb
sofortbanking 2 ms 0.50 Mb
pagesnotfound 1 ms - Mb
homefeatured 1 ms - Mb
mailalerts 1 ms - Mb
blockstore 1 ms - Mb
blockviewed 1 ms - Mb
ppb 1 ms - Mb
blocksupplier 1 ms - Mb
blockcontact 1 ms 0.25 Mb
blocklanguages 1 ms 0.25 Mb
blockcurrencies 1 ms - Mb
blockmyaccount 1 ms - Mb
blockmanufacturer 1 ms - Mb
blockbestsellers 1 ms 0.25 Mb
blockfacebook 1 ms - Mb
33 modules 417 ms 13.75 Mb

Stopwatch SQL - 928 queries

Query Time (ms) Rows Filesort Group By Location
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|80|1|1%"
40.6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|89|1|1%"
40.4 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|150|1|1","", FROM_UNIXTIME(1576304075))
40.3 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|144|1|1%"
40.3 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|151|1|1%"
32.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='3408af4f9f4825f050f024b3548bac05' AND cache_id LIKE "blocktags|1|1|6%"
32.3 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|136|1|1%"
32.3 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|58|1|1","", FROM_UNIXTIME(1576304074))
32.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|83|1|1","", FROM_UNIXTIME(1576304074))
32.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|73|1|1","", FROM_UNIXTIME(1576304075))
32.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|66|1|1","", FROM_UNIXTIME(1576304074))
32.3 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|78|1|1","", FROM_UNIXTIME(1576304074))
32.3 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|155|1|1%"
32.2 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|154|1|1%"
32.2 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|79|1|1%"
32.2 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|133|1|1%"
32.2 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|70|1|1","", FROM_UNIXTIME(1576304074))
32.2 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|67|1|1%"
32.2 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|143|1|1","", FROM_UNIXTIME(1576304074))
32.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|75|1|1","", FROM_UNIXTIME(1576304074))
32.2 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|85|1|1%"
32.2 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|87|1|1","", FROM_UNIXTIME(1576304075))
32.2 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|82|1|1%"
32.2 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|81|1|1","", FROM_UNIXTIME(1576304074))
32.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|76|1|1","", FROM_UNIXTIME(1576304074))
32.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|65|1|1","", FROM_UNIXTIME(1576304074))
32.1 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|68|1|1%"
32 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|63|1|1%"
32 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|156|1|1%"
32 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|71|1|1%"
32 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|157|1|1%"
32 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|137|1|1%"
32 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|61|1|1","", FROM_UNIXTIME(1576304074))
32 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|152|1|1%"
31.9 1 /classes/SmartyCustom.php:295
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
31.9 1 /classes/ObjectModel.php:487
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|90|1|1%"
31.9 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|64|1|1","", FROM_UNIXTIME(1576304074))
31.9 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|86|1|1%"
31.9 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|69|1|1%"
31.7 1 /classes/SmartyCustom.php:295
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('496332', '9', '56322783', '', '1', '1', '2019-12-14 07:14:38')
30.5 1 /classes/ObjectModel.php:487
SELECT SQL_NO_CACHE p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2019-12-14 00:00:00", INTERVAL 0 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM ps_cat_filter_restriction 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_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 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` = 1)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.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 product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY p.price asc , cp.id_product LIMIT 0,1000000000
4.1 37 Yes /modules/blocklayered/blocklayered.php:2048
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
3 1093 Yes /classes/Country.php:137
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` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2.5 244 Yes /classes/Country.php:131
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`)
2.4 609 /classes/Configuration.php:148
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`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
1.8 132 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.6 0 /classes/Hook.php:131
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
1.5 316 /classes/Hook.php:236
CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 51
AND c.nright <= 100
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
1.4 1 /modules/blocklayered/blocklayered.php:2136
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` = 1  AND cl.id_shop = 1 )
WHERE `id_parent` = 13
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.2 24 Yes Yes /classes/Category.php:658
CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 51
AND c.nright <= 100
AND c.active = 1)
STRAIGHT_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)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY cp.id_product ORDER BY position, id_product
1.2 1 /modules/blocklayered/blocklayered.php:1942
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
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)
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 1) WHERE c.nleft > 51
AND c.nright < 100
AND c.level_depth <= 3
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
1.2 111 Yes /modules/blocklayered/blocklayered.php:2376
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` = 1  AND cl.id_shop = 1 )
WHERE `id_parent` = 13
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1 24 Yes Yes /classes/Category.php:658
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (65,69,78,68,85,143,61,71,154,79,155,81,156,136,83,64,63,76,86,67,58,137,75,90,66,157,82,70,152,151,80,87,150,89,73,144,133) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.9 20 Yes Yes /classes/Product.php:3469
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (65,69,78,68,85,143,61,71,154,79,155,81,156,136,83,64,63,76,86,67,58,137,75,90,66,157,82,70,152,151,80,87,150,89,73,144,133) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 20 Yes Yes /classes/Product.php:3469
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
0.8 1 Yes Yes /classes/Supplier.php:127
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.6 39 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
0.5 1 Yes Yes /classes/Supplier.php:127
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
0.5 80 /classes/module/Module.php:277
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'desarrollo.mariskito.com' OR su.domain_ssl = 'desarrollo.mariskito.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.5 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.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 c.nleft <= 51
AND c.nright >= 100
AND c.nleft >= 2
AND c.nright <= 127
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.5 32 Yes /classes/Tools.php:1301
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 496332
AND `date_add` > '2019-12-14 06:44:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.5 1 Yes /classes/Connection.php:138
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 68) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 13
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
0.5 1 Yes /classes/Scene.php:226
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 75) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product),
ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
ADD KEY `weight` (`weight`,`id_product`) USING BTREE
0.5 1 /modules/blocklayered/blocklayered.php:2142
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 80) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 73) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.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 c.nleft <= 51
AND c.nright >= 100
AND c.nleft >= 2
AND c.nright <= 127
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.5 32 Yes /classes/Tools.php:1301
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 157) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 136) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 133) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 82) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 58) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 155) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 67) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.4 1 /classes/Currency.php:472
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 85) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 151) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 70) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 64) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 150) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 79) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 154) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 156) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 71) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 78) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 144) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 152) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 76) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 87) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 83) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.4 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 81) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE t.name, counter AS times
FROM `ps_tag_count` pt
LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag)
WHERE pt.id_group = 0 AND pt.`id_lang` = 1 AND pt.`id_shop` = 1
ORDER BY times DESC
LIMIT 10
0.4 1 /classes/Tag.php:195
SELECT SQL_NO_CACHE name
FROM `ps_feature_lang` fl
LEFT JOIN  `ps_layered_indexable_feature` lif
ON lif.id_feature = fl.id_feature
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.4 24 /modules/blocklayered/blocklayered.php:2725
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 69) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.4 1 /classes/shop/Shop.php:203
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 73) AND (b.`id_shop` = 1) LIMIT 1
0.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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 144) AND (b.`id_shop` = 1) LIMIT 1
0.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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 89) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 133) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE public_name
FROM `ps_attribute_group_lang` agl
LEFT JOIN `ps_layered_indexable_attribute_group` liag
ON liag.id_attribute_group = agl.id_attribute_group
WHERE indexable IS NULL OR indexable = 0
AND id_lang = 1
0.4 12 /modules/blocklayered/blocklayered.php:2715
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.4 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 80 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 68 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 13
AND id_shop = 1 LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:637
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 82 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 4
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='aafa0be5528ebf6588d87340a16c3d45' AND cache_id="blocktopmenu|1|1|6|category|13|category|13" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 157 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 13
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.3 1 Yes Yes /modules/blocklayered/blocklayered.php:2122
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.3 1 /modules/blocklayered/blocklayered.php:1954
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 75 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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
0.3 1 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 73 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 76 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.3 4 /classes/Language.php:894
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|63|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|69|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 2 /classes/Language.php:777
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 13
AND id_shop = 1 LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:637
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 81 AND `id_shop` = 1
0.3 3 /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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|67|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|157|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='86a667a2f01889f448c89b1211938fcc' AND cache_id="blocksocial|1|1|6" AND compile_id="" LIMIT 1
0.3 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|156|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 100
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 136 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 58 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 78 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 107
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 7 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 67 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 70 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 151 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.3 15 Yes /modules/themeconfigurator/themeconfigurator.php:376
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 101 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 7
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 107 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 71 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 85 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 79 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 87 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 64 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 5
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|78|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 155 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 152 AND `id_shop` = 1
0.3 2 /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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|76|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 154 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 156 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 5
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 150 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 133 AND `id_shop` = 1
0.3 2 /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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|150|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 6
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 107
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 107
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
0.3 15 Yes /modules/themeconfigurator/themeconfigurator.php:376
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 107 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 107 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|66|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 144 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 65) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE version FROM `ps_module` WHERE name = 'paypal' LIMIT 1
0.3 1 /modules/paypal/paypal.php:256
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 100
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypal" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|90|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 83 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "category" LIMIT 1
0.3 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pproperties" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|83|1|1" AND compile_id="" LIMIT 1
0.3 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|82|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|89|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 117 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 117 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 115 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 115 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 117
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 117
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 0, `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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 115
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 115
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='895a3e1504defebb2019f511332cd5e7' AND cache_id="blockcms|2|1|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 7 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 65) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 117
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|79|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|155|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|86|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|144|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|137|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|71|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|154|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|85|1|1" AND compile_id="" LIMIT 1
0.3 0 /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 = 65 LIMIT 1
0.3 1 /classes/Product.php:755
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|68|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|80|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|152|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|151|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|133|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='dad73e5955d7e7a9c27813d073c91dd3' AND cache_id="blocksearch-top|1|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 7 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3408af4f9f4825f050f024b3548bac05' AND cache_id="blocktags|1|1|6" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 6, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 6) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-12-14 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
0.3 1 Yes /override/classes/SpecificPrice.php:72
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 143) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'm_scene_default' LIMIT 1
0.3 1 /classes/Image.php:470
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 58) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 107 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 109 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 107
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 109
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 82) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 101
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 112
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.3 1 /classes/Image.php:470
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 5
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.3 4 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 101
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 101 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 107 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 112 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 109 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 109
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 2
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 101 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 112
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 112 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 5
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 117 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 107
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.3 1 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 112
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 67) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 112 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 5
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 100
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 2 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 107
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 100
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 107 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 109 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 2 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 7
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 101 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 13 AND ctg.`id_group` = 1 LIMIT 1
0.3 1 /classes/Category.php:1309
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 109
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 101
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 2
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 5
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 100
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 101
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 157) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 7
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE id_attribute_group FROM ps_layered_indexable_attribute_group WHERE indexable = 0
0.3 4 /modules/blocklayered/blocklayered.php:739
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|143|1|1" AND compile_id="" LIMIT 1
0.3 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 71) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 69 AND `id_shop` = 1
0.3 3 /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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|136|1|1" AND compile_id="" LIMIT 1
0.3 0 /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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 78) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 61) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 101
0.3 4 /classes/PP.php:711
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|81|1|1" AND compile_id="" LIMIT 1
0.2 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|75|1|1" AND compile_id="" LIMIT 1
0.2 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|70|1|1" AND compile_id="" LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 85) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 143) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 68) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 100
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 115
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 101
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2 1 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'category_default' LIMIT 1
0.2 1 /classes/Image.php:470
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|87|1|1" AND compile_id="" LIMIT 1
0.2 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|61|1|1" AND compile_id="" LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 154) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 6
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|64|1|1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ppropertiesmultidimensional" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 101 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.2 1 /classes/PP.php:907
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|65|1|1","", FROM_UNIXTIME(1576304078))
0.2 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` = 13) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 69) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 65)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 155) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 81) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 136) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 115 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 79) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 64) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 68)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 83) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 13 LIMIT 1
0.2 1 /classes/Page.php:77
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` = 85)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 63) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 69)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.2 1 /classes/Image.php:470
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|78|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 76) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 143)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 86) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 137) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.2 1 /classes/PP.php:907
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|70|1|1","", FROM_UNIXTIME(1576304075))
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 75) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|65|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|76|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='27a088319b090a59be4c6e199cbc91af' AND cache_id="blockcontactinfos|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
0.2 1 /classes/Page.php:97
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 152) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 70) AND (b.`id_shop` = 1) LIMIT 1
0.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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|58|1|1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 66) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|70|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 90) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 78)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|73|1|1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 61)
0.2 1 /classes/Product.php:3001
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` = 71)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.2 1 /classes/PP.php:907
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|78|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|143|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 80) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.2 10 /classes/ImageType.php:143
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 87) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 150) AND (b.`id_shop` = 1) LIMIT 1
0.2 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 156) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|81|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|75|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 64)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'es' LIMIT 1
0.2 1 /classes/Language.php:680
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 151) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 6
AND tr.`id_tax_rules_group` = 5
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|65|1|1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.2 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/shop/ShopUrl.php:169
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` = 81)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 101 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 1
AND cl.`id_category` = 13 AND cl.id_shop = 1 LIMIT 1
0.2 1 /classes/Meta.php:291
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 89) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.2 4 /classes/PP.php:711
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` = 155)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.2 1 /classes/SmartyCustom.php:95
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` = 154)
0.2 1 /classes/Product.php:3001
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` = 79)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 13 LIMIT 1
0.2 1 /classes/Category.php:1477
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` = 137)
0.2 1 /classes/Product.php:3001
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|81|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 65 AND `id_shop` = 1
0.2 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 82)
0.2 1 /classes/Product.php:3001
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|58|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|61|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|65|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 83)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.2 1 /classes/SmartyCustom.php:142
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` = 66)
0.2 1 /classes/Product.php:3001
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` = 136)
0.2 1 /classes/Product.php:3001
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 = 69 LIMIT 1
0.2 1 /classes/Product.php:755
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` = 75)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1451
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` = 156)
0.2 1 /classes/Product.php:3001
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|83|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|73|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.2 4 /classes/PP.php:711
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|78|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|81|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|83|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|150|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|143|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
0.2 8 /modules/blocklayered/blocklayered.php:741
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|87|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|64|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|73|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|76|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1451
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.2 1 /classes/Category.php:1477
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|150|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|58|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|87|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 58)
0.2 1 /classes/Product.php:3001
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` = 76)
0.2 1 /classes/Product.php:3001
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|143|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.2 4 /classes/PP.php:711
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` = 86)
0.2 1 /classes/Product.php:3001
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|76|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.2 1 /classes/ObjectModel.php:1368
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 143 AND `id_shop` = 1
0.2 2 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|83|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|87|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|66|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|70|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|150|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 67)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1451
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|61|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|73|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|66|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|75|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|58|1|1","", FROM_UNIXTIME(1576304078))
0.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 = 85 LIMIT 1
0.2 1 /classes/Product.php:755
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` = 63)
0.2 1 /classes/Product.php:3001
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` = 152)
0.2 1 /classes/Product.php:3001
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|75|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|64|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|66|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `ps_customization_field`
WHERE `id_product` = 89
AND `required` = 1
0.2 1 /classes/Product.php:4835
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|64|1|1","", FROM_UNIXTIME(1576304075))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.2 1 /classes/PP.php:907
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` = 157)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 13
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1451
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 = 81 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 115 LIMIT 1
0.2 1 /classes/PP.php:907
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` = 133)
0.2 1 /classes/Product.php:3001
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` = 144)
0.2 1 /classes/Product.php:3001
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` = 73)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.2 4 /classes/PP.php:711
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|61|1|1","", FROM_UNIXTIME(1576304078))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 150) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.2 4 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 6 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.2 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.2 1 /classes/PP.php:907
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` = 90)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 144) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.2 1 /classes/PP.php:907
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 = 68 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 133) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.2 1 /classes/PP.php:907
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 = 156 LIMIT 1
0.2 1 /classes/Product.php:755
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` = 70)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `ps_customization_field`
WHERE `id_product` = 73
AND `required` = 1
0.2 1 /classes/Product.php:4835
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` = 151)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `ps_customization_field`
WHERE `id_product` = 150
AND `required` = 1
0.2 1 /classes/Product.php:4835
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 115
0.2 4 /classes/PP.php:711
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` = 150)
0.2 1 /classes/Product.php:3001
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` = 87)
0.2 1 /classes/Product.php:3001
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` = 80)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `ps_customization_field`
WHERE `id_product` = 144
AND `required` = 1
0.2 1 /classes/Product.php:4835
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` = 89)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `id_customization_field`, `type`
FROM `ps_customization_field`
WHERE `id_product` = 133
AND `required` = 1
0.2 1 /classes/Product.php:4835
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2019-12-14 00:00:00' AND '2019-12-14 23:59:59' LIMIT 1
0.2 1 /classes/SpecificPrice.php:301
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 = 154 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 4
0.2 4 /classes/PP.php:711
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 = 79 LIMIT 1
0.2 1 /classes/Product.php:755
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 = 155 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 73) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /override/cl