Filtrar

Otros Productos Hay 30 productos.

Mostrando 1 - 30 de 30 items
  • Bacalao desalado cortado en finas lonchas y cubierto de aceite de oliva virgen extra. Gracias al aliño, el aroma es mucho más suave y su tiempo de conservación es mayor. Es un producto refrigerado, envasado al vacío en bandejas de 100 gr.

  • Vista rápida
    4,80 € / unidad / kg

    Carne procedente de la falda, la llana o la aleta. Excelente y muy versátil a la hora de elaborar rellenos, hamburguesas, filetes rusos o albóndigas, resultando unos platos suculentos gracias a su jugosidad. La carne picada de ternera se presenta envasada al vacío, siendo el peso de cada bolsa de 500 gr. aprox.

    4,80 € / unidad / kg
  • Vista rápida
    5,40 € / unidad / unidad

    Pastel de exquisito sabor con productos de primera calidad, sin aditivos ni conservantes. Elaborado con carne de cabracho con el toque único de las Rías Baixas: el Albariño. Ideal para preparar montaditos y rellenos. El pastel de Cabracho se presenta envasado al vacío en barquetas de 200 gr. Una vez abierto, para su mejor conservación se recomienda...

    5,40 € / unidad / unidad
  • Vista rápida
    5,80 € / unidad / unidad

    Elaboradas con carne picada de primera calidad, son un bocado apetitoso para los amantes de la carne ya que resultan muy sabrosas. Su preparación es fácil y rápida, ideales para cocinar a la plancha o en barbacoa. Ingredientes: ternera (50%), cerdo (50%), sal, proteína soja, proteína láctea, maíz, dextrosa, dextrina,especies, antioxidante (E300,E301),...

    5,80 € / unidad / unidad
  • Vista rápida
    6,30 € / unidad / kg

    Carne procedente de la falda o el jarrete, se trata de una carne magra ideal para ser estofada o guisada. Su terneza y jugosidad se debe a que es una pieza gelatinosa y muy sabrosa. Se presenta envasado al vacío en bolsas de 500 gr. aprox.

    6,30 € / unidad / kg
  • Vista rápida
    7,30 € / unidad / unidad

    Elaboradas con carne de buey de primera calidad, son un bocado suculento para los amantes de la carne ya que resultan muy sabrosas. Su preparación es fácil y rápida, ideales para cocinar a la plancha o en barbacoa. Ingredientes: carne de vaca (90%), sal, dextrosa, dextrina, almidón, protéina soja, proteína láctea, especies, conservante (E224),...

    7,30 € / unidad / unidad
  • Vista rápida
    7,50 € / unidad / unidad

    Pastel de exquisito sabor con productos de primera calidad, sin aditivos ni conservantes. Elaborado con carne de centolla y buey extraída artesanalmente. Lo mejor de la gastronomía gallega con el toque único de las Rías Baixas: el Albariño. Ideal para preparar montaditos y rellenos. El pastel de Centolla se presenta envasado al vacío en barquetas de 200...

    7,50 € / unidad / unidad
  • Vista rápida
    7,90 € / unidad / unidad

    Piezas de 300-350 gr. aprox. Carne limpia, jugosa y tierna de la parte delantera del lomo que une la aguja con la quinta o séptima costilla. Una de las piezas más nobles de la ternera después del solomillo. Muy popular por su intenso sabor gracias a la grasa, aportando terneza y jugosidad al plato final. El entrecot de ternera se presenta envasado...

    7,90 € / unidad / unidad
  • Vista rápida
    8,90 € / unidad / kg

    Piezas jugosas, tiernas y con poca grasa, procedentes de la cadera y pierna del vacuno. Ideales para hacer a la plancha, freír o rebozar, ya que su preparación requiere muy poco tiempo resultando muy sabroso. Piezas excelentes para dietas infantiles. Los filetes de ternera se presentan envasados al vacío en bolsas de 500 gr. aprox.

    8,90 € / unidad / kg
  • Vista rápida
    10,90 € / unidad / unidad

    Suculenta carne en una pieza de gran proporción de grasa de buena calidad, extraída del lomo con un corte transversal de manera que en uno de los lados conserve el hueso de la costilla. Aporta un intenso sabor y jugosidad al plato, especialmente si está preparado a la plancha o a la parrilla. El chuletón de ternera se presenta envasado individualmente al...

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

    La picaña se presenta fileteada envasada al vacío en bolsas de 500 gr. aprox.Se trata de una de carne muy demandada en la actualidad, perfecta para cocinarla a la brasa o a la parrilla. Es un corte típico de Brasil, situado en la parte posterior de la vaca, a ambos lados de la espina dorsal. Una pieza tierna, con una capa de grasa que le aporta un sabor...

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

    Elaboradas con carne de ternera de primera calidad, bacon, chorizo, pimiento verde o rojo y cebolla. Una suculenta mezcla de ingredientes que te quitará el sentido. Su preparación es fácil y de rápida cocción para obtener una brocheta más jugosa, ideales para preparar en la barbacoa o a la plancha. Las brochetas de carne se presentan envasadas al vacío en...

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

    Novilunio es un vino 100% albariño, con D.O. Rías Baixas. Es de vista limpia y dorada con tonos de lima madura, aromas frutales, hueso y manzana. En boca es amable, de acidez integrada, recuerdos a manzana y plátano, cuerpo medio y largo postgusto. Temperatura ideal de consumo: 6º - 10ºC. Excelente compañero de mariscos, pescados, carnes blancas y quesos...

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

    Se trata de un delicioso bizcocho con sabor a almendras que se presenta bajo la forma de la cruz de Santiago. Se tiene constancia sobre la elaboración de esta tarta y su consumo en manuscritos que datan del año 1577. Una tarta elaborada de forma artesanal y tradicional con ingredientes 100% naturales (almendra, huevos, azúcar y margarina).

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

    El churrasco o la tira de asado son dos de los nombres con los que popularmente se conoce a la costilla de ternera fileteada, y cortada de forma transversal en tiras. El corte incluye trozos de hueso y carne bien filtrada de grasa, ideal para hacer a la brasa o en la barbacoa. No obstante, también puede utilizarse para hacer guisos y asados. La costilla...

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

    Parte de la pata de la ternera, que va desde la pantorrilla hasta la corva del animal, cortado transversalmente y con el hueso en el centro. Cortado en una pieza de gran grosor, tierna y ligeramente gelatinosa. Este corte se suele elaborar en suculentos guisos, ya que es como más se puede disfrutar de la ternura de su carne. También puede degustarse en...

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

    Carne de intenso sabor por la grasa que la rodea. Una de las piezas más nobles del buey después del solomillo. Una pieza especialmente tierna, sabrosa y de gran jugosidad, ideal para freír, hacer a la plancha, a la brasa o a la parrilla. El entrecot de buey se presenta envasado individualmente al vacío, siendo cada unidad de 500-600 gr. aprox.

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

    Pieza de carne situada sobre el esternón de la ternera. Suele ser algo menos blanda, por lo que se puede rellenar de carne picada acompañada de ingredientes jugosos como la panceta, vegetales, etc. Un plato completo y jugoso. La aleta rellena de ternera se presenta envasada individualmente al vacío, siendo cada unidad de 1,5-1,7 kg. aprox.

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

    Albariño. Val do Salnés. D.O. Rías Baixas. Toda la expresividad de la uva albariño. Vino frutoso con recuerdos marinos que nos seduce con su elegante frescura. Amarillo pálido con irisaciones verdosas. En nariz aparecen notas de melocotón verde y ralladura de limón con herbáceos y toque minerales. Muy fresco en el ataque de paso sedoso y con un largo...

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

    Carne magra, melosa y con muchas fibras, situada en la parte baja de las patas de la ternera. Ideal para preparar guisos y estofados, ya que resulta muy jugosa. El jarrete de ternera, también llamado morcillo, se presenta envasado al vacío, siendo el peso aproximado de la pieza entera de 1,5 a 1,8 kg.

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

    Un sabroso corte de carne de la ternera procedente de los músculos maseteros. Corresponde a las partes grasas que se encuentran a ambos lados de la cara y pertenecen a la casquería. La estructura gelatinosa, debido al contenido de colágeno que posee, permite que puede disfrutarse especialmente en guisos o en deliciosas brasas. Son ideales para preparar...

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

    Carne tierna, su característica forma la define: redonda, sin nervios y con poca grasa, procedente de los cuartos traseros. Es una pieza ideal para asados, guisos, mechados y en la elaboración de productos con carne picada de mayor calidad. El redondo de ternera se presenta envasado al vacío, siendo el peso aproximado de la pieza entera de 2 a 2,5 kg.

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

    100% Albariño. Método Champenoise. Val do Salnés. D.O. Rías Baixas. El Brut Nature Mar de Frades es el primer albariño espumoso, realizado con el método Champenoise. El resultado es sabroso y cremoso, sin perder las notas de la variedad. Amarillo dorado alimonado. En nariz se muestra fino, complejo y expresivo. Primero manifiesta rasgos de la crianza en...

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

    El roastbeef de ternera se presenta envasado individualmente al vacío, siendo el peso aproximado de la pieza entera de 1,5-1,7 kg. Carne limpia, jugosa y tierna procedente del lomo de la ternera, muy apreciada en la cocina inglesa a la hora de elaborar su tradicional asado, aunque también es perfecta para freír, a la plancha o a la parrilla.

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

    Una carne suculenta. El chuletón de buey es una pieza de gran tamaño procedente de la parte alta del lomo, conservando parte del hueso del costillar. Al ser más graso que el solomillo o el entrecot, su carne resulta muy sabrosa y tierna. Es ideal para freír, hacer a la plancha, a la brasa o a la parrilla, añadiendo un poco de sal gorda al final de su...

    23,50 € / unidad / unidad
  • Vista rápida
    24,50 € / unidad / unidad

    Uno de los productos más tradicionales de la gastronomía gallega, en el que se combina la masa con los diferentes ingredientes. Su peso es de 1 kg. aprox., y te ofrecemos la posibilidad de escoger entre los ingredientes más habituales: carne, bonito, bacalao con pasas, chocos y zamburiñas. 

    24,50 € / unidad / unidad
  • Vista rápida
    24,80 € / unidad / unidad

    Albariño. Val do Salnés. D.O. Rías Baixas. Toda la expresividad de la uva albariño. Vino frutoso con recuerdos marinos que nos seduce con su elegante frescura. Amarillo pálido con irisaciones verdosas. En nariz aparecen notas de melocotón verde y ralladura de limón con herbáceos y toque minerales. Muy fresco en el ataque de paso sedoso y con un largo...

    24,80 € / unidad / unidad
  • Vista rápida
    34,00 € / kg / unidad

    Tiene un peso aproximado de 1,8 a 2,2 kg. Indícanos si quieres que lo fileteemos o lo envasemos en varios trozos.  Carne tierna y jugosa, situada entre las costilla inferiores y la columna vertebral, más concretamente debajo del lomo. Una pieza selecta, suave y libre de grasa, con un sabor auténtico que admite infinidad de formas de preparación.

    34,00 € / kg / unidad
  • Vista rápida
    35,00 € / kg / unidad

    Tiene un peso aproximado de 3,5 kg. Indícanos si quieres que lo fileteemos o lo envasemos en varios trozos.  Carne de buey, magra y suculenta de intenso color rojo, situada en la cara interna del lomo bajo. Rica en proteínas y en aminoácidos esenciales para nuestro organismo. Uno de los cortes más valorados por su jugosidad y textura. Una de las...

    35,00 € / kg / unidad
  • Vista rápida
    48,00 € / unidad / unidad

    Variado de carne gallega fresca de excelente calidad y lista para cocinar:  1 kg. Filetes de Ternera, en 2 bolsas de 500 gr. aprox 1 kg. de Carne para guisar, en 2 bolsas de 500 gr. aprox. 1 kg. de Carne picada en 2 bolsas de 500 gr. aprox. 2 bandejas de Hamburguesas de Ternera, de 4 unidades cada una * Envío sujeto a disponibilidad de los productos

    48,00 € / unidad / unidad
Mostrando 1 - 30 de 30 items
Load Time14738 ms - You'd better run your shop on a toaster
Querying Time1921 ms
Queries767
Memory Peak Usage26.5 Mb
Included Files272 files - 4.93 Mb
PrestaShop Cache- Mb
Global vars0.97 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.95 Mb 5.08 Mb
__construct 0 ms 33 ms - Mb 5.08 Mb
init 10 ms 43 ms 1.23 Mb 6.31 Mb
checkAccess 0 ms 43 ms - Mb 6.31 Mb
setMedia 4 ms 47 ms 0.20 Mb 6.50 Mb
postProcess 0 ms 47 ms - Mb 6.50 Mb
initHeader 0 ms 48 ms - Mb 6.50 Mb
initContent 4618 ms 4666 ms 13.34 Mb 19.78 Mb
initFooter 539 ms 5204 ms 0.61 Mb 20.45 Mb
display 9534 ms 14738 ms 5.30 Mb 26.51 Mb
Hook Time Memory Usage
hookproductlistassign 161 ms 7.25 Mb
hookfooter 96 ms - Mb
__construct 49 ms 4.50 Mb
hookHeader 14 ms - Mb
hookleftcolumn 8 ms 0.50 Mb
hooktop 8 ms - Mb
hookdisplayHeader 6 ms - Mb
hookdisplayTop 4 ms - Mb
hookdisplayFooter 3 ms - Mb
hookdisplayNav 3 ms - Mb
hookdisplayProductPriceBlock 1 ms - Mb
hookdisplayLeftColumn 1 ms - Mb
hookdisplayTopColumn - ms - Mb
13 hooks 354 ms 12.25 Mb
Module Time Memory Usage
blocklayered 172 ms 8.00 Mb
statsdata 85 ms 0.50 Mb
blocknewsletter 14 ms 1.00 Mb
blockcart 10 ms - Mb
paypal 8 ms 0.25 Mb
uecookie 6 ms - Mb
blocktopmenu 6 ms 0.25 Mb
pproperties 5 ms 0.25 Mb
themeconfigurator 4 ms - Mb
blocksearch 4 ms 0.25 Mb
blockcms 4 ms 0.25 Mb
blocktags 3 ms - Mb
blockuserinfo 3 ms - Mb
sofortbanking 3 ms 0.50 Mb
blocksocial 3 ms - Mb
blockcontactinfos 3 ms - Mb
ganalytics 2 ms - Mb
deliverydays 2 ms 0.25 Mb
homefeatured 1 ms - Mb
sekeywords 1 ms - Mb
pagesnotfound 1 ms 0.25 Mb
blockviewed 1 ms - Mb
blockstore 1 ms - Mb
blocksupplier 1 ms - Mb
ppb 1 ms - Mb
mailalerts 1 ms - Mb
blockcontact 1 ms - Mb
blockcurrencies 1 ms 0.25 Mb
blockmanufacturer 1 ms - Mb
blockmyaccount 1 ms 0.25 Mb
blocklanguages 1 ms - Mb
blockbestsellers 1 ms - Mb
blockfacebook 1 ms - Mb
33 modules 354 ms 12.25 Mb

Stopwatch SQL - 767 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|141|1|1%"
290.5 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|105|1|1%"
173.6 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|98|1|1%"
165.8 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|106|1|1%"
57.8 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|127|1|1%"
40.7 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|102|1|1%"
40.7 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|140|1|1","", FROM_UNIXTIME(1571669263))
40.7 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|113|1|1%"
40.6 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|111|1|1","", FROM_UNIXTIME(1571669264))
40.6 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|96|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|104|1|1%"
40.6 1 /classes/SmartyCustom.php:295
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|114|1|1","", FROM_UNIXTIME(1571669264))
40.6 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|214|1|1","", FROM_UNIXTIME(1571669264))
40.6 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|103|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|97|1|1%"
40.4 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|100|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|101|1|1","", FROM_UNIXTIME(1571669264))
40.4 1 /classes/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|142|1|1","", FROM_UNIXTIME(1571669264))
40.4 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|107|1|1%"
40.4 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|108|1|1%"
40.3 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')
40.1 1 /classes/ObjectModel.php:487
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('489517', '20', '315669417', '', '1', '1', '2019-10-21 16:47:47')
38.5 1 /classes/ObjectModel.php:487
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|109|1|1","", FROM_UNIXTIME(1571669265))
33 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|93|1|1%"
32.3 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|115|1|1%"
32.3 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|95|1|1%"
32.3 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|116|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|112|1|1","", FROM_UNIXTIME(1571669264))
32.3 1 /classes/SmartyCustom.php:263
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|94|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|59|1|1%"
32 1 /classes/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='d63c75e73bcb123020602ff98bee144e' AND cache_id LIKE "productlist_colors|91|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|110|1|1","", FROM_UNIXTIME(1571669264))
31.7 1 /classes/SmartyCustom.php:263
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-10-21 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.3 30 Yes /modules/blocklayered/blocklayered.php:2048
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
3 929 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.6 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 662 /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 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
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.5 0 /classes/Hook.php:131
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 >= 101
AND c.nright <= 114
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.2 1 /modules/blocklayered/blocklayered.php:2136
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 >= 101
AND c.nright <= 114
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
0.9 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 > 101
AND c.nright < 114
AND c.level_depth <= 3
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
0.9 96 Yes /modules/blocklayered/blocklayered.php:2376
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 (140,105,141,98,106,110,142,101,100,103,214,107,113,127,102,96,111,108,114,97,104,95,116,94,112,59,115,93,109,91) 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 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` = 40
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.8 6 Yes Yes /classes/Category.php:658
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` = 40
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.8 6 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 (140,105,141,98,106,110,142,101,100,103,214,107,113,127,102,96,111,108,114,97,104,95,116,94,112,59,115,93,109,91) 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.6 1 Yes Yes /classes/Supplier.php:127
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 489517
AND `date_add` > '2019-10-21 16:17:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.6 1 Yes /classes/Connection.php:138
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 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 <= 101
AND c.nright >= 114
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.6 32 Yes /classes/Tools.php:1301
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 <= 101
AND c.nright >= 114
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.6 32 Yes /classes/Tools.php:1301
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
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` = 105) LIMIT 1
0.5 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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.5 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` = 116) 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` = 112) 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` = 102) 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` = 141) 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` = 91) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
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 *
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` = 115) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.5 80 /classes/module/Module.php:277
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` = 127) 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` = 214) 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` = 114) 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` = 111) 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` = 59) 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 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 *
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` = 109) 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` = 94) 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` = 100) 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` = 142) 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` = 101) 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` = 98) 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` = 96) 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` = 108) 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` = 103) 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` = 110) 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` = 106) 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` = 93) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 59 AND `id_shop` = 1
0.4 2 /Adapter/Adapter_EntityMapper.php:68
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` = 107) 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` = 113) 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 95) 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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.3 1 /classes/shop/Shop.php:203
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.3 1 /classes/Tag.php:195
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 105 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 91 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 116 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
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` = 142) 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` = 106) 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` = 101) 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` = 110) 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` = 112 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 102 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 141 AND `id_shop` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68
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 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 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 = 40
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
0.3 1 Yes /classes/Scene.php:226
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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 127 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 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 *
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` = 40) 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_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 97) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|108|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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 type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 40
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|141|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|97|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|116|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|59|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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 *
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` = 104) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|96|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|94|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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|104|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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 id_attribute_group FROM ps_layered_indexable_attribute_group WHERE indexable = 0
0.3 4 /modules/blocklayered/blocklayered.php:739
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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 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 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 111 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 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` = 4
0.3 4 /classes/PP.php:711
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 `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 * 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` = 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` = 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 * FROM `ps_pp_template` WHERE `id_pp_template` = 100 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 214 AND `id_shop` = 1
0.3 2 /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` = 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` = 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` = 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` = 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 `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` = 8 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` = 3
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` = 1 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 `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` = 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` = 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` = 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|115|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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` = 1
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_product_lang`
WHERE `id_product` = 142 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
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|102|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` = 106 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 94 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 115 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 101 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
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 *
FROM `ps_product_lang`
WHERE `id_product` = 108 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 109 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 98 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 100 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 103 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 114 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|110|1|1" AND compile_id="" LIMIT 1
0.3 1 /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 *
FROM `ps_product_lang`
WHERE `id_product` = 96 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 110 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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|109|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|103|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|142|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 * FROM `ps_hook_alias`
0.3 86 /classes/Hook.php:187
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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 1 LIMIT 1
0.3 1 /classes/PP.php:907
SELECT SQL_NO_CACHE COUNT(*)
FROM ps_layered_category
WHERE id_category = 40
AND id_shop = 1 LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:637
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_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.3 1 /Adapter/Adapter_EntityMapper.php:61
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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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_pp_template` WHERE `id_pp_template` = 1 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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_pp_template` WHERE `id_pp_template` = 1 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 5
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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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|106|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` = 107 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`='aafa0be5528ebf6588d87340a16c3d45' AND cache_id="blocktopmenu|1|1|6|category|40|category|40" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 113 AND `id_shop` = 1
0.3 2 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 40 LIMIT 1
0.3 0 /classes/Category.php:1054
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` = 96) 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` = 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 `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 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.3 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 40 LIMIT 1
0.3 1 /classes/Page.php:77
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` = 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 `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 id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
0.3 8 /modules/blocklayered/blocklayered.php:741
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` = 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 `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 COUNT(*)
FROM ps_layered_category
WHERE id_category = 40
AND id_shop = 1 LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:637
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 *, ( 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-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-10-21 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` = 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` = 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` = 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 `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` = 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` = 1
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`='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` = 8 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 `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` = 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 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` = 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` = 1
0.3 4 /classes/PP.php:711
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|140|1|1","", FROM_UNIXTIME(1571669265))
0.3 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|91|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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 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 * FROM `ps_pp_template` WHERE `id_pp_template` = 4 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|107|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` = 93 AND `id_shop` = 1
0.3 3 /Adapter/Adapter_EntityMapper.php:68
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|110|1|1","", FROM_UNIXTIME(1571669267))
0.3 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`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|95|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|93|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|105|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|113|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` = 1
0.3 4 /classes/PP.php:711
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|110|1|1","", FROM_UNIXTIME(1571669265))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 111) 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` = 100) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='86a667a2f01889f448c89b1211938fcc' AND cache_id="blocksocial|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` = 1 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` = 141) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/shop/ShopUrl.php:169
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|111|1|1","", FROM_UNIXTIME(1571669265))
0.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|101|1|1","", FROM_UNIXTIME(1571669265))
0.3 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 98) AND (b.`id_shop` = 1) LIMIT 1
0.3 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|214|1|1","", FROM_UNIXTIME(1571669265))
0.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|142|1|1","", FROM_UNIXTIME(1571669265))
0.3 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.3 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.3 1 /Adapter/Adapter_EntityMapper.php:61
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` = 1
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|98|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215
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` = 8 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` = 5 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 `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` = 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` = 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 `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` = 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` = 3
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 `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 `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` = 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 * 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` = 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` = 8 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_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` = 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 `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 * 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` = 8 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` = 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` = 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` = 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 * 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` = 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 `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` = 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 `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 * 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` = 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` = 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` = 1
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` = 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` = 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` = 8
0.3 4 /classes/PP.php:711
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 `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` = 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` = 8 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 * FROM `ps_pp_template` WHERE `id_pp_template` = 8 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 `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` = 100
0.3 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` = 140)
0.3 1 /classes/Product.php:3001
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` = 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 *
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` = 103) AND (b.`id_shop` = 1) 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 `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` = 95 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` = 1
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|100|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` = 214) 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` = 1
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` = 140) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|127|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` = 108) 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` = 107) 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` = 3 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` = 5
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|101|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` = 113) 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` = 127) 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|114|1|1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d63c75e73bcb123020602ff98bee144e' AND cache_id="productlist_colors|214|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|112|1|1" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 5 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` = 5
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` = 102) 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` = 1
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` = 98)
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` = 105) 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` = 1
0.2 4 /classes/PP.php:711
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 `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` = 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` = 97) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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 `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_theme` a
WHERE (a.`id_theme` = 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` = 114) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`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` = 6 LIMIT 1
0.2 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.2 1 /classes/Image.php:470
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` = 95) 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` = 94) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'm_scene_default' LIMIT 1
0.2 1 /classes/Image.php:470
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` = 104) 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` = 116) 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`='27a088319b090a59be4c6e199cbc91af' AND cache_id="blockcontactinfos|1|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|109|1|1","", FROM_UNIXTIME(1571669267))
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` = 105)
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` = 6
0.2 4 /classes/PP.php:711
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 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` = 101)
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` = 141)
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` = 93) 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` = 109) 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` = 115) 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` = 59) 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` = 91) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 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` = 102)
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` = 112) 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|111|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` = 110)
0.2 1 /classes/Product.php:3001
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 `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_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` = 106)
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 = 140 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 97 AND `id_shop` = 1
0.2 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` = 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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|114|1|1","", FROM_UNIXTIME(1571669267))
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|112|1|1","", FROM_UNIXTIME(1571669267))
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|142|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
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 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` = 100)
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|110|1|1","", FROM_UNIXTIME(1571669267))
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` = 142)
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` = 113)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_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|214|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
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` = 40 AND cl.id_shop = 1 LIMIT 1
0.2 1 /classes/Meta.php:291
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 40 LIMIT 1
0.2 1 /classes/Category.php:1477
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 id_required_field, object_name, field_name
FROM ps_required_field
0.2 1 /classes/ObjectModel.php:1368
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.2 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.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` = 214)
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` = 103)
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` = 96)
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|142|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.2 4 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 40
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|140|1|1","", FROM_UNIXTIME(1571669267))
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` = 107)
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|111|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'es' LIMIT 1
0.2 1 /classes/Language.php:680
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|114|1|1","", FROM_UNIXTIME(1571669265))
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|112|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
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.2 24 /modules/blocklayered/blocklayered.php:2725
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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|112|1|1","", FROM_UNIXTIME(1571669265))
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|140|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 40 AND `id_shop` = 1
0.2 2 /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.2 4 /classes/PP.php:711
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.2 12 /modules/blocklayered/blocklayered.php:2715
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 DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.2 1 /classes/SpecificPrice.php:238
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 40 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Category.php:1309
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` = 127)
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` = 3
0.2 4 /classes/PP.php:711
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_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 = 98 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` = 114)
0.2 1 /classes/Product.php:3001
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 * FROM `ps_image_type`
0.2 10 /classes/ImageType.php:143
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` = 97)
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|111|1|1","", FROM_UNIXTIME(1571669267))
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|114|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
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 id_shop
FROM `ps_group_shop`
WHERE `id_group` = 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|101|1|1","", FROM_UNIXTIME(1571669267))
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|214|1|1","", FROM_UNIXTIME(1571669267))
0.2 1 /classes/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 104 AND `id_shop` = 1
0.2 3 /Adapter/Adapter_EntityMapper.php:68
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|109|1|1","", FROM_UNIXTIME(1571669267))
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` = 59)
0.2 5 /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 = 106 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 = 105 LIMIT 1
0.2 1 /classes/Product.php:755
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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|101|1|1","", FROM_UNIXTIME(1571669267))
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` = 108)
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` = 111)
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 = 100 LIMIT 1
0.2 1 /classes/Product.php:755
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` = 8 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 * 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` = 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` = 91)
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 = 141 LIMIT 1
0.2 1 /classes/Product.php:755
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('d63c75e73bcb123020602ff98bee144e',"productlist_colors|109|1|1","", FROM_UNIXTIME(1571669265))
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` = 40) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
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 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 = 110 LIMIT 1
0.2 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|140|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` = 93)
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` = 109)
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` = 112)
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 = 103 LIMIT 1
0.2 1 /classes/Product.php:755
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 * 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 = 142 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 = 113 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` = 115)
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` = 95)
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` = 116)
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 = 101 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` = 104)
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` = 94)
0.2 1 /classes/Product.php:3001
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 2) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 107 LIMIT 1
0.2 1 /classes/Product.php:755
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_pp_template` WHERE `id_pp_template` = 3 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 = 96 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 2
0.2 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 110 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5035
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 = 102 LIMIT 1
0.2 1 /classes/Product.php:755
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1 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 = 127 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.1 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 106
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 98
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2019-10-21 00:00:00' AND '2019-10-21 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:301
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 98 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 101 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction
0.1 1 /modules/blocklayered/blocklayered.php:2126
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 100
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 140 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2019-10-21 00:00:00' AND '2019-10-21 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:305
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 105
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 106 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 98 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 110) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 142) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
0.1 3 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 106) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 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.1 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.1 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 = 108 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 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.1 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 = 214 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 141
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 110
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 106 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
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 = 111 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 98) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
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 = 97 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 96 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
0.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 114 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 101
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 100 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 113 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 142 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 142
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 113
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 105) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 103
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 140 LIMIT 1
0.1 1 /classes/PP.php:679
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 = 109 LIMIT 1
0.1 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 = 93 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 96) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 101) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 141 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 110 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 105 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 102
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 111) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 3 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 107 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 113 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 142 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 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.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 214 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 3
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 141) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 96
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 107
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 1
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 102 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 127 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 100 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 114 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5035
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE `id_pp_template` FROM `ps_product` WHERE `id_product` = 101 LIMIT 1
0.1 1 /classes/PP.php:679
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.1 4 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 127
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 103) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 140
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:198
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 100) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /override/classes/stock/StockAvailable.php:179
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 113) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 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` = 1
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE SUM(quantity + quantity_remainder)
FROM `ps_stock_available`
WHERE (id_product = 214) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 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` = 1
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE `pp_name`, `id_pp_property` FROM `ps_pp_template_property` WHERE `id_pp_template` = 8
0.1 4 /classes/PP.php:711
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 4 LIMIT 1
0.1 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 = 104 LIMIT 1
0.1 1 /classes/Product.php:755
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 1 LIMIT 1
0.1 1 /classes/PP.php:907
SELECT SQL_NO_CACHE * FROM `ps_pp_template` WHERE `id_pp_template` = 8 LIMIT 1
0.1 1