Consulte a nuestros Especialistas.
Consulte a nuestros Especialistas.

ASISTENCIA TÉCNICA

902 043 187

sat@fibraclim.com

COVID-19 ¡SEGUIMOS GESTIONANDO TUS PEDIDOS CON NORMALIDAD!

Maquinaria de Hostelería

Si estás buscando maquinaria de hostelería de la mejor calidad, para que puedas equipar tu negocio de pies a cabeza, confía en Fibraclim. Tenemos  maquinaria de cocina profesional, menaje, mobiliario, y todo lo que necesitas a excelentes precios. Descubre rebajas insuperables en el outlet de maquinaria de hostelería de Fibraclim.

En Fibraclim somos más que una tienda especializada, ya que trabajamos de la mano de nuestros clientes para encontrar el producto adecuado, que ayude en el crecimiento de su labor. Te asesoramos al equipar por primera vez tu negocio, en la remodelación  y en la renovación de los elementos necesarios para cada tipo de local. 

PRODUCTOS DESTACADOS

Conoce los productos más populares de Fibraclim, con ofertas especiales para que los adquieras al instante. Todos los elementos para el servicio, equipos de limpieza, refrigeración, exhibición, y mucho más, hacen parte de nuestra selección de productos destacados. Descubre lo mejor del menaje, el mobiliario y la maquinaria industrial de hostelería que le darán un toque muy profesional al establecimiento.

Hornos Gastronomía

Oferta

5 016,66 € 8 361,10 €
Oferta

3 627,10 € 6 045,16 €
Oferta

4 870,73 € 8 117,89 €
Oferta

6 076,80 € 10 128,00 €
Oferta

4 473,61 € 7 456,02 €
Oferta

2 685,60 € 4 476,00 €
Oferta

4 426,20 € 7 377,00 €
Oferta

5 626,80 € 9 378,00 €
Oferta

2 892,38 € 4 820,64 €
Oferta

3 259,74 € 5 432,90 €

Armarios Refrigerados

Oferta

1 972,54 € 3 287,57 €
Oferta

3 415,83 € 5 693,05 €
Oferta

2 490,91 € 4 151,51 €
Oferta

692,60 € 1 154,34 €
Oferta

2 619,41 € 4 365,68 €
Oferta

1 624,06 € 2 706,77 €
Oferta

1 830,25 € 3 050,41 €
Oferta

2 474,93 € 4 124,89 €
Oferta

2 676,76 € 4 461,27 €
Oferta

1 852,75 € 3 087,92 €

Lavavajillas industriales

Oferta

870,47 € 1 450,79 €
Oferta

795,70 € 1 326,16 €
Oferta

754,17 € 1 346,73 €
Oferta

924,92 € 1 541,54 €
Oferta

1 160,87 € 1 934,79 €
Oferta

1 044,71 € 1 741,19 €
Oferta

943,80 € 1 573,00 €
Oferta

1 363,36 € 2 272,26 €
Oferta

1 992,14 € 3 320,24 €
Oferta

1 821,53 € 3 035,89 €

Expositores Refrigerados Verticales

Oferta

1 093,05 € 1 821,75 €
Oferta

778,64 € 1 557,27 €
Oferta

1 206,75 € 2 011,25 €
Oferta

598,95 € 998,25 €
Oferta

444,31 € 740,52 €
Oferta

712,25 € 1 295,00 €
Oferta

612,14 € 1 020,24 €
Oferta

607,96 € 1 013,27 €
Oferta

479,00 € 798,33 €
Oferta

972,46 € 1 620,77 €

COMPRA EN NUESTRA TIENDA O EN LA PÁGINA WEB Y RECIBE:

estrella.png

EXPERIENCIA Y RECONOCIMIENTO

Más de 20 años asesorando personas y empresas en la adquisición de maquinaria de hostelería duradera y con un desempeño superior en utilidades específicas de cada negocio.

rota.png

REPOSICIÓN CONTINUA

Actualizamos permanentemente nuestros stocks para tener a mano los productos que desees en el momento de la compra. En nuestra tienda siempre encontrarás lo que necesitas.

edificios.png

INSTALACIONES ÚNICAS

Contamos con 1500m2 de exposición y 6000m2 de almacén, en los que conocerás cada uno de nuestros productos y escucharás el consejo profesional idóneo para la compra de tu maquinaria de hostelería.

cascos.png

ASESORAMIENTO PROFESIONAL

Nuestro personal experto en equipos de hostelería, está listo para escucharte y ofrecerte la mejor asesoría antes de adquirir cualquiera de nuestros productos. Los especialistas de Fibraclim esperan tu visita.

descarga.png

DISPONIBILIDAD INMEDIATA

No esperes para recibir tus productos. Estamos preparados, con más de 5.000 referencias en maquinaria de hostelería, mobiliario y otros elementos imprescindibles en cualquier negocio de hostelería. Recibirás tus compras al instante.

tarjetas.png

FINANCIACIÓN ONLINE

¡Y por el dinero no te preocupes! Compra ya tu material de hostelería y págalo en 12 meses sin papeleo ni complicaciones. Dale a tu negocio todo lo necesario, en condiciones muy favorables para ti, asegurando su buen funcionamiento.

COMPRA POR CATEGORÍA

Conoce los productos más populares de Fibraclim, con ofertas especiales para que los adquieras al instante. Todos los elementos para el servicio, equipos de limpieza, refrigeración, exhibición, y mucho más, hacen parte de nuestra selección de productos destacados.

Descubre lo mejor del menaje, el mobiliario y la maquinaria industrial de hostelería que le darán un toque muy profesional al establecimiento.

lavavajillas_industriales
expositores_refrigerados
maquinaria_refregerada
equipamiento-inoxidable.png
maquinaria.png
nuestra-empresa.png
nuestra-tienda
outlet
distribuidor.jpg
catalogo.jpg
Load Time551 ms - Unicorn powered webserver!
Querying Time183 ms
Queries373
Memory Peak Usage11.4 Mb
Included Files248 files - 4.37 Mb
PrestaShop Cache- Mb
Global vars0.89 Mb
PrestaShop Version1.6.1.18
PHP Version7.2.18 (OK)
MySQL Version5.5.62-0ubuntu0.14.04.1 (Consider upgrading)
Memory Limit128M
Max Execution Time30s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 36 ms 36 ms 2.08 Mb 2.12 Mb
__construct 0 ms 36 ms - Mb 2.12 Mb
init 9 ms 44 ms 0.45 Mb 2.55 Mb
checkAccess 0 ms 44 ms - Mb 2.55 Mb
setMedia 2 ms 46 ms 0.07 Mb 2.64 Mb
postProcess - ms 46 ms - Mb 2.64 Mb
initHeader 0 ms 46 ms - Mb 2.64 Mb
initContent 382 ms 428 ms 5.98 Mb 8.73 Mb
initFooter 41 ms 469 ms 0.27 Mb 8.97 Mb
display 82 ms 551 ms 0.97 Mb 11.37 Mb
Hook Time Memory Usage
hookdisplayHome 180 ms - Mb
__construct 20 ms - Mb
hookHeader 16 ms - Mb
hookdisplayHeader 15 ms - Mb
hookdisplayFooter 5 ms - Mb
hooktop 5 ms - Mb
hookhome 5 ms - Mb
hookdisplayTop 4 ms - Mb
hookdisplayTopColumn 3 ms - Mb
hookfooter 2 ms - Mb
hookdisplayTptnHead 2 ms - Mb
hookdisplayNav 1 ms - Mb
hookdisplayFooterTop 1 ms - Mb
hookdisplayBanner 0 ms - Mb
hookmoduleRoutes - ms - Mb
hookdisplayTptnBody - ms - Mb
16 hooks 260 ms - Mb
Module Time Memory Usage
tptnprodcarousel 177 ms - Mb
whatsappchat 15 ms - Mb
paseocenterbulkedition 10 ms - Mb
ganalytics 5 ms - Mb
blockcart 4 ms - Mb
gdprpro 4 ms - Mb
tptnhomeslider 4 ms - Mb
blocksearch 4 ms - Mb
blockcategories 3 ms - Mb
blocktopmenu 3 ms - Mb
tptnmobilemenu 3 ms - Mb
paypal 3 ms - Mb
paylater 3 ms - Mb
blockcms 2 ms - Mb
advancedpopupcreator 2 ms - Mb
redsys 2 ms - Mb
contentboxfootertop 2 ms - Mb
tptnsocial 2 ms - Mb
tptnthemeconfig 2 ms - Mb
contentboxafter 2 ms - Mb
tptnfooterblock1 2 ms - Mb
contentbox 2 ms - Mb
contentboxhead 2 ms - Mb
contentboxfooter 1 ms - Mb
tptnheaderlinks 1 ms - Mb
quantitypack 1 ms - Mb
blocklayered 0 ms - Mb
mailalerts 0 ms - Mb
blockbestsellers 0 ms - Mb
sendtoafriend 0 ms - Mb
30 modules 260 ms - Mb

Stopwatch SQL - 373 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `fibra_specific_price` WHERE `id_product` != 0 LIMIT 1
4.8 4099 /classes/SpecificPrice.php:230
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-10-21 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `fibra_category_product` cp
LEFT JOIN `fibra_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN fibra_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `fibra_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 fibra_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `fibra_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `fibra_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `fibra_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 `fibra_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `fibra_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 10244  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
LIMIT 0,10
4.6 376 Yes /classes/Category.php:811
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-10-21 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `fibra_category_product` cp
LEFT JOIN `fibra_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN fibra_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `fibra_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 fibra_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `fibra_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `fibra_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `fibra_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 `fibra_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `fibra_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 10219  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
LIMIT 0,10
4.6 448 Yes /classes/Category.php:811
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-10-21 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `fibra_category_product` cp
LEFT JOIN `fibra_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN fibra_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `fibra_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 fibra_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `fibra_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `fibra_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `fibra_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 `fibra_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `fibra_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 10219  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
LIMIT 0,10
3.7 448 Yes /classes/Category.php:811
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-10-21 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `fibra_category_product` cp
LEFT JOIN `fibra_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN fibra_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `fibra_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 fibra_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `fibra_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `fibra_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `fibra_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 `fibra_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `fibra_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 10466  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
LIMIT 0,10
3.6 220 Yes /classes/Category.php:811
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38900)
2.6 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 39477)
2.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-10-21 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `fibra_category_product` cp
LEFT JOIN `fibra_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN fibra_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `fibra_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 fibra_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `fibra_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `fibra_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `fibra_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 `fibra_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `fibra_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 10463  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
LIMIT 0,10
2.2 96 Yes /classes/Category.php:811
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 39479)
2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 39478)
2 1 /classes/Product.php:2998
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 `fibra_configuration` c
LEFT JOIN `fibra_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1.8 743 /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 `fibra_module` m
INNER JOIN fibra_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 `fibra_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `fibra_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `fibra_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.5 80 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 `fibra_hook_module` hm
STRAIGHT_JOIN `fibra_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `fibra_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.5 405 /classes/Hook.php:235
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 39478 AND id_shop=1 LIMIT 1
1.5 1 /classes/Product.php:5037
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 `fibra_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` IN (0, 39477) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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
1.5 2 Yes /classes/SpecificPrice.php:362
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 2035)
1.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `fibra_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `fibra_hook_alias` ha
INNER JOIN `fibra_hook` h ON ha.name = h.name
1.4 0 /classes/Hook.php:131
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 34988)
1.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 34988 AND id_shop=1 LIMIT 1
1.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 2035 AND id_shop=1 LIMIT 1
1.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 39479 AND id_shop=1 LIMIT 1
1.1 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38900 AND id_shop=1 LIMIT 1
1.1 1 /classes/Product.php:5037
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38571)
1 1 /classes/Product.php:2998
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 `fibra_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` IN (0, 1677) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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
1 2 Yes /classes/SpecificPrice.php:362
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 39475)
0.9 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `fibra_meta` m
LEFT JOIN `fibra_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.9 43 Yes /classes/Dispatcher.php:452
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 `fibra_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` IN (0, 1713) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 34944) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38671) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38657) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1776) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38571 AND id_shop=1 LIMIT 1
0.8 1 /classes/Product.php:5037
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 `fibra_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` IN (0, 39479) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38670) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `fibra_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `fibra_module` m
0.8 109 /classes/module/Module.php:277
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 35048)
0.8 1 /classes/Product.php:2998
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 `fibra_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` IN (0, 39478) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38571) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1673) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1925) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 3 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1674) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 2035) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 3 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38659) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38900) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38675) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 39474) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1717) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 3 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1712) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38669) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.8 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1929) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 34223) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38674) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1670) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1661) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 34988) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1704) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 39475) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1668) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 34941) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 38658) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1675) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 1669) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 35048) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 34942) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_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` IN (0, 34943) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `fibra_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `fibra_module` m
0.7 109 /classes/module/Module.php:277
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 `fibra_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` IN (0, 1676) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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.7 2 Yes /classes/SpecificPrice.php:362
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 39474)
0.7 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM fibra_shop_url su
LEFT JOIN fibra_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'fibraclim.com' OR su.domain_ssl = 'fibraclim.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.6 1 Yes /classes/shop/Shop.php:334
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 fibra_shop_group gs
LEFT JOIN fibra_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN fibra_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.6 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE id_paseocenter_metas
FROM `fibra_paseocenter_metas`
WHERE (id_entity = 14) AND (type = 7) AND (id_shop = 1) LIMIT 1
0.6 1597 /modules/paseocenterbulkedition/classes/PaMeta.php:126
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `fibra_lang` l
JOIN fibra_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.6 4 /classes/Language.php:892
SELECT SQL_NO_CACHE *
FROM `fibra_country` a
LEFT JOIN `fibra_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `fibra_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 6) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_currency` c
INNER JOIN fibra_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.6 1 Yes /classes/Currency.php:231
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM fibra_theme t
LEFT JOIN fibra_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN fibra_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "index" LIMIT 1
0.6 1 /classes/Theme.php:275
SELECT SQL_NO_CACHE value FROM `fibra_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.6 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE id_paseocenter_metas
FROM `fibra_paseocenter_metas`
WHERE (id_entity = 14) AND (type = 7) AND (id_shop = 1) LIMIT 1
0.5 1597 /modules/paseocenterbulkedition/classes/PaMeta.php:126
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `fibra_smarty_last_flush` WHERE type='compile' LIMIT 1
0.5 1 /classes/SmartyCustom.php:95
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 `fibra_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` IN (0, 1672) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-10-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-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 2 Yes /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE domain, domain_ssl
FROM fibra_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.5 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `fibra_lang` l
LEFT JOIN `fibra_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.5 2 /classes/Language.php:777
SELECT SQL_NO_CACHE *
FROM `fibra_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "header" AND `id_shop` = 1 AND `active` = 1
0.5 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE *
FROM `fibra_currency` a
LEFT JOIN `fibra_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1925)
0.5 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM fibra_shop s
LEFT JOIN fibra_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN fibra_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.5 1 /classes/shop/Shop.php:202
SELECT SQL_NO_CACHE *
FROM `fibra_group` a
LEFT JOIN `fibra_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
show tables like 'fibra_quantity_pack'
0.5 1 /modules/quantitypack/quantitypack.php:24
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 39479
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1
0.5 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1
0.5 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE *
FROM `fibra_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 39477) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `fibra_hook_alias`
0.5 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE * FROM `fibra_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.5 4 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE *
FROM `fibra_group_lang`
WHERE `id_group` = 1
0.5 4 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1776) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM fibra_meta m
LEFT JOIN fibra_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.5 1 /classes/Meta.php:149
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `fibra_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.5 2 Yes /classes/Language.php:717
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2035) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_shop
FROM `fibra_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.5 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE *
FROM `fibra_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_country`
FROM `fibra_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.5 1 /classes/Country.php:173
SELECT SQL_NO_CACHE *
FROM `fibra_category` a
LEFT JOIN `fibra_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `fibra_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1661) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_lang` a
LEFT JOIN `fibra_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1
0.4 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE id_paseocenter_metas
FROM `fibra_paseocenter_metas`
WHERE (id_entity = 14) AND (type = 7) AND (id_shop = 1) LIMIT 1
0.4 1597 /modules/paseocenterbulkedition/classes/PaMeta.php:126
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38900) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_shop
FROM `fibra_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.4 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1670) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34942) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_shop
FROM `fibra_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.4 1 /classes/ObjectModel.php:1458
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 39474) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 39475 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38657) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "top" AND `id_shop` = 1 AND `active` = 1
0.4 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38571) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1925 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_paseocenter_metas
FROM `fibra_paseocenter_metas`
WHERE (id_entity = 14) AND (type = 7) AND (id_shop = 1) LIMIT 1
0.4 1597 /modules/paseocenterbulkedition/classes/PaMeta.php:126
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38669) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34223) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 39474 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1925) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1676) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `price_display_method`
FROM `fibra_group`
WHERE `id_group` = 3 LIMIT 1
0.4 1 /classes/Group.php:144
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38659) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_category` a
LEFT JOIN `fibra_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `fibra_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10466) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE tr.*
FROM `fibra_tax_rule` tr
JOIN `fibra_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` = 1
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.4 1 Yes /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38658) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1717) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1668) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34943) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 39478) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34944) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38674) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1713)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1675) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1673) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38657)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 34944)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1669) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1713) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1677) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1717)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1712)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38671) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 35048) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 34943)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 39475) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_currency` c
INNER JOIN fibra_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.4 1 Yes /classes/Currency.php:231
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1704)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38657) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='6a13ea0fbe9fdb5a09359bc362af80a0' AND cache_id="blockcategories|1|6|2|3" AND compile_id="" LIMIT 1
0.4 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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 34942)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 39479) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38670) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1661)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38658)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1674) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38674)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1
0.4 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38670)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38671)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1704) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1676)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34941) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1675)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1673)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1669)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE *
FROM `fibra_whatsappchatblock_agent` LEFT JOIN `fibra_whatsappchatblock_agent_lang` ON (`fibra_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `fibra_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `fibra_whatsappchatblock_agent`.`id_whatsappchatblock` = 2 AND `active` = 1 ORDER BY position
0.4 8 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:75
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayBanner" AND `id_shop` = 1 AND `active` = 1
0.4 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38675
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 38675) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "home" AND `id_shop` = 1 AND `active` = 1
0.4 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE * FROM fibra_contentboxafter WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.4 1 /modules/contentboxafter/contentboxafter.php:775
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 34988) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38657
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1712) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1929) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1929)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayNav" AND `id_shop` = 1 AND `active` = 1
0.4 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 34223)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 34941)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1670)
0.4 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38675)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1670
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `fibra_category` a
LEFT JOIN `fibra_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `fibra_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10219) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `fibra_category` a
LEFT JOIN `fibra_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `fibra_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10244) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38671
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38659) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38669)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1713
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1
0.3 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1776)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38675) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 38659)
0.3 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 34988
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38674
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38669) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38670) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1713) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1925) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `fibra_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 10466 LIMIT 1
0.3 1 /classes/Category.php:1082
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38670
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 34943
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM fibra_meta m
LEFT JOIN fibra_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.3 1 /classes/Meta.php:149
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38671) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 34942
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 39475) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38669
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 39477
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 2035) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38659
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE * FROM fibra_contentboxhead WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.3 1 /modules/contentboxhead/contentboxhead.php:775
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1704) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1929) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE 1 FROM `fibra_specific_price` WHERE `from` BETWEEN '2020-10-21 00:00:00' AND '2020-10-21 23:59:59' LIMIT 1
0.3 1 /classes/SpecificPrice.php:302
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1704
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1669
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1929
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `fibra_currency` c
INNER JOIN fibra_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 `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38658
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 34941
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 34942) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38571) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM fibra_meta m
LEFT JOIN fibra_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "index"
OR m.page = "index"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
0.3 1 /classes/Meta.php:149
SELECT SQL_NO_CACHE tr.*
FROM `fibra_tax_rule` tr
JOIN `fibra_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.3 0 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1717
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 34223
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38674) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1712) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1670) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1717) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1712
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 2035
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE ctg.`id_group`
FROM fibra_category_group ctg
WHERE ctg.`id_category` = 10466 AND ctg.`id_group` = 1 LIMIT 1
0.3 1 /classes/Category.php:1337
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module` WHERE `name` = "paypal" LIMIT 1
0.3 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38571
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 34223) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1676) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE ctg.`id_group`
FROM fibra_category_group ctg
WHERE ctg.`id_category` = 10244 AND ctg.`id_group` = 1 LIMIT 1
0.3 1 /classes/Category.php:1337
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 39479) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='5a902fb47a9a330c26f2c4056d3d93f8' AND cache_id="tptnprodcarousel|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.3 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 34943) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 34988) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `width`, `height`
FROM fibra_image_type
WHERE `name` = 'home_default' LIMIT 1
0.3 1 /classes/Image.php:471
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 34944
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1675
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `fibra_meta` a
LEFT JOIN `fibra_meta_lang` `b` ON a.`id_meta` = b.`id_meta` AND b.`id_lang` = 1
WHERE (a.`id_meta` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 39474) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.3 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 35048) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1776) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1673) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1673
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1712 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1661 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38658) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 34944) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1776 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 34943 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `fibra_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 10244 LIMIT 1
0.3 1 /classes/Category.php:1082
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 39478) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 39475
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1661
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE * FROM fibra_contentboxfooter WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.3 1 /modules/contentboxfooter/contentboxfooter.php:775
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `fibra_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 10463 LIMIT 1
0.3 1 /classes/Category.php:1082
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1675) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='9fe1f350ee952dab0ed69764338b3137' AND cache_id="blockcms|2|1|6" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 39478
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38659 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 35048
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `fibra_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 10219 LIMIT 1
0.3 1 /classes/Category.php:1082
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 38900) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1661) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 38900
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1677
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1925
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38658 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE * from fibra_hook_module where 
id_module = '111' and 
id_shop = '1' and 
id_hook = '10'
0.3 1 /modules/paylater/paylater.php:190
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 39474
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1674 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.3 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `fibra_smarty_last_flush` WHERE type='template' LIMIT 1
0.3 1 /classes/SmartyCustom.php:142
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 34941) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1776
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 35048 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.3 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.3 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 39477) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1669 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 39477 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE * FROM `fibra_image_type`
0.3 9 /classes/ImageType.php:143
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38669 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38674 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_lang`, `text`, `url` FROM fibra_tptnfooterblock1_lang WHERE `id_blocklink`=3
0.3 1 /modules/tptnfooterblock1/tptnfooterblock1.php:122
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 34944 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE version FROM `fibra_module` WHERE name = 'paypal' LIMIT 1
0.3 1 /modules/paypal/paypal.php:227
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1677 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1672) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ctg.`id_group`
FROM fibra_category_group ctg
WHERE ctg.`id_category` = 10219 AND ctg.`id_group` = 1 LIMIT 1
0.3 1 /classes/Category.php:1337
SELECT SQL_NO_CACHE * from fibra_pmt_config
0.3 13 /modules/paylater/paylater.php:212
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 34223 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1669) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 34941 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1717 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.2 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE 1 FROM `fibra_specific_price` WHERE `to` BETWEEN '2020-10-21 00:00:00' AND '2020-10-21 23:59:59' LIMIT 1
0.2 1 /classes/SpecificPrice.php:306
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayTopColumn" AND `id_shop` = 1 AND `active` = 1
0.2 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE *
FROM `fibra_tax_lang`
WHERE `id_tax` = 1
0.2 4 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.2 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1929 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
CREATE TABLE IF NOT EXISTS  `fibra_pmt_log` (
`id` INT NOT NULL AUTO_INCREMENT,
`log` TEXT,
`createdAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE = InnoDB
0.2 1 /modules/paylater/paylater.php:245
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1675 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1668 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1672 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38670 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1704 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38675 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_category` a
LEFT JOIN `fibra_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `fibra_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 10463) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.2 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE * FROM fibra_contentboxfootertop WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.2 1 /modules/contentboxfootertop/contentboxfootertop.php:775
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='e098e242fa3f4ac4fd450c1f89e250c5' AND cache_id="tptnsocial|1|6" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1670 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_paseocenter_pages` a
WHERE (a.`id_paseocenter_pages` = 14) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1713 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.2 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `fibra_currency` c
LEFT JOIN fibra_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.2 1 /classes/Currency.php:470
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1673 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38671 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_tax` a
WHERE (a.`id_tax` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 1676 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 34942 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `fibra_whatsappchatblock_agent` LEFT JOIN `fibra_whatsappchatblock_agent_lang` ON (`fibra_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `fibra_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `fibra_whatsappchatblock_agent`.`id_whatsappchatblock` = 2 AND `active` = 1 ORDER BY position
0.2 8 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:75
SELECT SQL_NO_CACHE `id_lang`, `text`, `url` FROM fibra_tptnfooterblock1_lang WHERE `id_blocklink`=1
0.2 1 /modules/tptnfooterblock1/tptnfooterblock1.php:122
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1672)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `fibra_whatsappchatblock`.`id_whatsappchatblock`, `message`, `def_message`,
`offline_message`, `position`, `open_chat`, `mobile_phone`, `color`, `only_home`, `chat_group`, 
`customer_groups`, `only_mobile`, `share_option`, `schedule`, `only_desktop`, `only_tablet`, 
`custom_css`, `custom_js`, `offline_link`
FROM `fibra_whatsappchatblock` LEFT JOIN `fibra_whatsappchatblock_lang` ON (`fibra_whatsappchatblock`.`id_whatsappchatblock` = `fibra_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "footer" AND `id_shop` = 1 AND `active` = 1
0.2 1 /modules/whatsappchat/classes/WhatsappChatBlock.php:110
SELECT SQL_NO_CACHE COUNT(*)
FROM `fibra_hook_module` hm
LEFT JOIN `fibra_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'home' AND hm.`id_module` = 4 LIMIT 1
0.2 0 /classes/module/Module.php:2237
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 `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1674)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1668)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `fibra_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` = 1677)
0.2 1 /classes/Product.php:2998
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module` WHERE `name` = "homefeatured" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module` WHERE `name` = "shiptopay" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='4061db1a8ee57d74ddd0b99afd0123ae' AND cache_id="blocktopmenu|1|index|1|1|1|0|0|0|0|0" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `fibra_product_shop`
WHERE `id_product` = 38657 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5037
SELECT SQL_NO_CACHE * FROM fibra_contentbox WHERE `id_lang` = "1" and `id_store`="1" LIMIT 1
0.2 1 /modules/contentbox/contentbox.php:775
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='82b0b85f1da8cfe3bf75061ce82e01e5' AND cache_id="blocktopmenu|1|6|index" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1668) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1676
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='f48fe985ddecd1e8da0f964d33a9109f' AND cache_id="tptnhomeslider|1|6" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module` WHERE `name` = "blockbestsellers" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `fibra_smarty_lazy_cache`
WHERE `template_hash`='3063de0ff1cd5c58240c8d1130a0a7c6' AND cache_id="blocksearch-top|1|6" AND compile_id="" LIMIT 1
0.1 1 /classes/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1674) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.1 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.1 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1672
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
CREATE TABLE IF NOT EXISTS `fibra_pmt_cart_process` (
`id` INT NOT NULL ,
`timestamp` INT NOT NULL ,
PRIMARY KEY (`id`)
) ENGINE = InnoDB
0.1 1 /modules/paylater/paylater.php:245
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1672) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module` WHERE `name` = "paylater" LIMIT 1
0.1 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1674
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE ctg.`id_group`
FROM fibra_category_group ctg
WHERE ctg.`id_category` = 10463 AND ctg.`id_group` = 1 LIMIT 1
0.1 1 /classes/Category.php:1337
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `fibra_specific_price_priority`
WHERE `id_product` = 1668
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 1 /classes/SpecificPrice.php:196
SELECT SQL_NO_CACHE id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT 1
0.1 81 /modules/paseocenterbulkedition/classes/PaPage.php:92
SELECT SQL_NO_CACHE b.`id_blocklink`, b.`new_window` FROM `fibra_tptnfooterblock1` b
0.1 2 /modules/tptnfooterblock1/tptnfooterblock1.php:113
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module_shop` WHERE `id_module` = 4 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = 1677) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:380
CREATE TABLE IF NOT EXISTS `fibra_pmt_order` (
`id` INT NOT NULL ,
`order_id` VARCHAR(60) NOT NULL ,
PRIMARY KEY (`id`)
) ENGINE = InnoDB
0.1 1 /modules/paylater/paylater.php:245
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module` WHERE `name` = "blocknewproducts" LIMIT 1
0.1 1 /classes/module/Module.php:2568
CREATE TABLE IF NOT EXISTS  `fibra_pmt_config` (
`id` INT NOT NULL AUTO_INCREMENT,
`config` VARCHAR(60) NOT NULL,
`value` VARCHAR(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB
0.1 1 /modules/paylater/paylater.php:245
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module_shop` WHERE `id_module` = 38 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE `id_module` FROM `fibra_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2218

Doubles

40
							SELECT `id_tax_rules_group`
							FROM `fibra_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
40
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `fibra_product` p
INNER JOIN `fibra_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `fibra_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
40
SELECT SUM(quantity)
FROM `fibra_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
40
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `fibra_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
40
				SELECT `priority`, `id_specific_price_priority`
				FROM `fibra_specific_price_priority`
				WHERE `id_product` = XX
				ORDER BY `id_specific_price_priority` DESC LIMIT XX
40
SELECT *
FROM `fibra_product` a
LEFT JOIN `fibra_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `fibra_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
12
SELECT id_paseocenter_pages
FROM `fibra_paseocenter_pages`
WHERE (page like 'index') LIMIT XX
5
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, XX) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, XX) AS id_product_attribute,
					product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
					pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
					il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
					DATEDIFF(product_shop.`date_add`, DATE_SUB("XX-XX-XX XX:XX:XX",
					INTERVAL XX DAY)) > XX AS new, product_shop.price AS orderprice
				FROM `fibra_category_product` cp
				LEFT JOIN `fibra_product` p
					ON p.`id_product` = cp.`id_product`
				 INNER JOIN fibra_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) LEFT JOIN `fibra_product_attribute_shop` product_attribute_shop
				ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = XX AND product_attribute_shop.id_shop=XX)
				 LEFT JOIN fibra_stock_available stock
			ON (stock.id_product = p.id_product AND stock.id_product_attribute = XX AND stock.id_shop = XX  AND stock.id_shop_group = XX  )
				LEFT JOIN `fibra_category_lang` cl
					ON (product_shop.`id_category_default` = cl.`id_category`
					AND cl.`id_lang` = XX AND cl.id_shop = XX )
				LEFT JOIN `fibra_product_lang` pl
					ON (p.`id_product` = pl.`id_product`
					AND pl.`id_lang` = XX AND pl.id_shop = XX )
				LEFT JOIN `fibra_image_shop` image_shop
					ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX)
				LEFT JOIN `fibra_image_lang` il
					ON (image_shop.`id_image` = il.`id_image`
					AND il.`id_lang` = XX)
				LEFT JOIN `fibra_manufacturer` m
					ON m.`id_manufacturer` = p.`id_manufacturer`
				WHERE product_shop.`id_shop` = XX
					AND cp.`id_category` = XX  AND product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog") ORDER BY pl.`name` DESC
			LIMIT XX,XX
5
SELECT *
FROM `fibra_category` a
LEFT JOIN `fibra_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `fibra_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
4
			SELECT cl.`link_rewrite`
			FROM `fibra_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
4
SELECT id_paseocenter_metas
FROM `fibra_paseocenter_metas`
WHERE (id_entity = XX) AND (type = XX) AND (id_shop = XX) LIMIT XX
4
				SELECT ctg.`id_group`
				FROM fibra_category_group ctg
				WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
3
SELECT `id_module` FROM `fibra_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
3
		SELECT *
		FROM fibra_meta m
		LEFT JOIN fibra_meta_lang ml ON m.id_meta = ml.id_meta
		WHERE (
			m.page = "index"
			OR m.page = "index"
		)
		AND ml.id_lang = XX
		 AND ml.id_shop = XX LIMIT XX
3
		SELECT *
		FROM `fibra_currency` c
		 INNER JOIN fibra_currency_shop currency_shop
		ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX ORDER BY `name` ASC
2
SELECT `id_lang`, `text`, `url` FROM fibra_tptnfooterblockXX_lang WHERE `id_blocklink`=XX
2
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `fibra_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `fibra_module` m
2
SELECT *
            FROM `fibra_whatsappchatblock_agent` LEFT JOIN `fibra_whatsappchatblock_agent_lang` ON (`fibra_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `fibra_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = XX) WHERE XX = XX AND `fibra_whatsappchatblock_agent`.`id_whatsappchatblock` = XX AND `active` = XX ORDER BY position
2
				SELECT tr.*
				FROM `fibra_tax_rule` tr
				JOIN `fibra_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
				WHERE trg.`active` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

Tables stress

125 product_shop
85 product
45 product_lang
45 stock_available
45 product_attribute_shop
43 specific_price
40 specific_price_priority
14 category_lang
13 paseocenter_pages
12 whatsappchatblock
12 whatsappchatblock_lang
11 module
8 smarty_lazy_cache
7 module_shop
6 currency_shop
6 meta
5 manufacturer
5 category
5 image_lang
5 category_shop
5 currency
5 meta_lang
5 category_product
5 image_shop
5 hook
4 category_group
4 shop
4 paseocenter_metas
4 shop_url
4 lang_shop
4 lang
4 hook_module
3 theme
2 country
2 tptnfooterblock1_lang
2 image_type
2 tax_rules_group
2 tax_rule
2 shop_group
2 configuration
2 whatsappchatblock_agent
2 whatsappchatblock_agent_lang
2 hook_alias
2 group
2 group_shop
2 smarty_last_flush
1 country_lang
1 pmt_config
1 contentboxhead
1 contentboxfooter
1 tptnfooterblock1
1 contentboxafter
1 hook_module_exceptions
1 tax_lang
1 tax
1 country_shop
1 contentbox
1 group_lang
1 configuration_lang
1 theme_meta
1 contentboxfootertop

ObjectModel instances

NameInstancesSource
Product 40 /classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
WhatsappChatBlock 12 /modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
/modules/whatsappchat/whatsappchat.php [438]
WhatsappChatBlockAgent 12 /modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
/modules/whatsappchat/whatsappchat.php [439]
Meta 8 /modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
/modules/paseocenterbulkedition/classes/PaPage.php [47]
PaPage 8 /modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
/modules/paseocenterbulkedition/classes/PaMeta.php [164]
Category 6 /modules/tptnprodcarousel/tptnprodcarousel.php [263]
/modules/tptnprodcarousel/tptnprodcarousel.php [263]
/modules/tptnprodcarousel/tptnprodcarousel.php [263]
/modules/tptnprodcarousel/tptnprodcarousel.php [263]
/modules/tptnprodcarousel/tptnprodcarousel.php [263]
/modules/blockcategories/blockcategories.php [371]
PaMeta 4 /modules/paseocenterbulkedition/paseocenterbulkedition.php [141]
/modules/paseocenterbulkedition/paseocenterbulkedition.php [144]
/modules/paseocenterbulkedition/paseocenterbulkedition.php [244]
/modules/paseocenterbulkedition/paseocenterbulkedition.php [248]
Country 2 /config/config.inc.php [142]
/classes/controller/FrontController.php [279]
Address 2 /classes/Product.php [2937]
/classes/Product.php [4408]
Language 2 /config/config.inc.php [195]
/classes/Tools.php [498]
Shop 1 /config/config.inc.php [114]
Theme 1 /config/config.inc.php [115]
Group 1 /classes/Cart.php [184]
Cart 1 /classes/controller/FrontController.php [348]
Currency 1 /classes/Tools.php [615]
Customer 1 /config/config.inc.php [221]
ShopGroup 1 /classes/shop/Shop.php [518]
Tax 1 /classes/tax/TaxRulesTaxManager.php [115]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/settings.inc.php
5/config/autoload.php
6/config/alias.php
7/classes/PrestaShopAutoload.php
8/cache/class_index.php
9/config/bootstrap.php
10/Core/Business/Core_Business_ContainerBuilder.php
11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12/Adapter/Adapter_ServiceLocator.php
13/classes/controller/Controller.php
14/classes/ObjectModel.php
15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16/classes/db/Db.php
17/classes/Tools.php
18/classes/Context.php
19/classes/shop/Shop.php
20/classes/db/DbPDO.php
21/classes/Configuration.php
22/classes/Validate.php
23/classes/cache/Cache.php
24/Adapter/Adapter_EntityMapper.php
25/classes/db/DbQuery.php
26/classes/Theme.php
27/config/defines_uri.inc.php
28/classes/Language.php
29/classes/Country.php
30/classes/PrestaShopCollection.php
31/classes/shop/ShopGroup.php
32/classes/Cookie.php
33/classes/Rijndael.php
34/config/smarty.config.inc.php
35/tools/smarty/Smarty.class.php
36/tools/smarty/sysplugins/smarty_internal_data.php
37/tools/smarty/sysplugins/smarty_internal_templatebase.php
38/tools/smarty/sysplugins/smarty_internal_template.php
39/tools/smarty/sysplugins/smarty_resource.php
40/tools/smarty/sysplugins/smarty_internal_resource_file.php
41/tools/smarty/sysplugins/smarty_cacheresource.php
42/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
43/classes/SmartyCustom.php
44/config/smartyfront.config.inc.php
45/classes/Customer.php
46/classes/Group.php
47/classes/Link.php
48/override/classes/Link.php
49/classes/shop/ShopUrl.php
50/classes/Dispatcher.php
51/classes/Hook.php
52/override/classes/Hook.php
53/modules/gdprpro/src/GdprProCookie.php
54/modules/gdprpro/src/GdprProConfig.php
55/tools/mobile_Detect/Mobile_Detect.php
56/config/db_slave_server.inc.php
57/classes/module/Module.php
58/modules/gdprpro/gdprpro.php
59/classes/Translate.php
60/themes/MegaShop/modules/gdprpro/translations/es.php
61/modules/gdprpro/translations/es.php
62/modules/gdprpro/vendor/autoload.php
63/modules/gdprpro/vendor/composer/autoload_real.php
64/modules/gdprpro/vendor/composer/ClassLoader.php
65/modules/gdprpro/vendor/composer/autoload_namespaces.php
66/modules/gdprpro/vendor/composer/autoload_psr4.php
67/modules/gdprpro/vendor/composer/autoload_classmap.php
68/controllers/front/IndexController.php
69/classes/controller/FrontController.php
70/themes/MegaShop/lang/es.php
71/classes/Currency.php
72/classes/Cart.php
73/classes/CartRule.php
74/classes/Meta.php
75/classes/Product.php
76/classes/webservice/WebserviceRequest.php
77/classes/Media.php
78/modules/blocksearch/blocksearch.php
79/themes/MegaShop/modules/blocksearch/translations/es.php
80/modules/blocksearch/translations/es.php
81/modules/blockcart/blockcart.php
82/themes/MegaShop/modules/blockcart/translations/es.php
83/modules/blockcart/translations/es.php
84/modules/blocktopmenu/blocktopmenu.php
85/modules/blocktopmenu/menutoplinks.class.php
86/themes/MegaShop/modules/blocktopmenu/translations/es.php
87/modules/blocktopmenu/translations/es.php
88/modules/tptnhomeslider/tptnhomeslider.php
89/modules/tptnhomeslider/TptnHomeSlide.php
90/themes/MegaShop/modules/tptnhomeslider/translations/es.php
91/modules/tptnhomeslider/translations/es.php
92/cache/smarty/compile/77/7c/33/777c33cabbd63d2c7cfa6f2d63fcf0b7f551097e.file.tptnhomeslider_header.tpl.php
93/tools/smarty/sysplugins/smarty_internal_filter_handler.php
94/tools/minify_html/minify_html.class.php
95/tools/js_minify/jsmin.php
96/modules/blockcategories/blockcategories.php
97/themes/MegaShop/modules/blockcategories/translations/es.php
98/modules/blockcategories/translations/es.php
99/modules/tptnthemeconfig/tptnthemeconfig.php
100/themes/MegaShop/modules/tptnthemeconfig/translations/es.php
101/modules/tptnthemeconfig/translations/es.php
102/modules/sendtoafriend/sendtoafriend.php
103/themes/MegaShop/modules/sendtoafriend/translations/es.php
104/modules/sendtoafriend/translations/es.php
105/modules/mailalerts/mailalerts.php
106/modules/mailalerts/MailAlert.php
107/override/modules/mailalerts/mailalerts.php
108/themes/MegaShop/modules/mailalerts/translations/es.php
109/modules/mailalerts/translations/es.php
110/modules/paypal/paypal.php
111/modules/paypal/api/paypal_lib.php
112/modules/paypal/api/paypal_connect.php
113/modules/paypal/paypal_logos.php
114/modules/paypal/paypal_orders.php
115/modules/paypal/paypal_tools.php
116/modules/paypal/paypal_login/paypal_login.php
117/modules/paypal/paypal_login/PayPalLoginUser.php
118/modules/paypal/paypalCore.php
119/classes/PaymentModule.php
120/themes/MegaShop/modules/paypal/translations/es.php
121/modules/paypal/es.php
122/cache/smarty/compile/cc/a5/63/cca5636fc6910b8265dd26fbc0be0aab1da21360.file.paypal.js.php
123/modules/whatsappchat/whatsappchat.php
124/modules/whatsappchat/classes/WhatsappChatBlock.php
125/modules/whatsappchat/classes/array_column.php
126/modules/whatsappchat/classes/WhatsappChatBlockAgent.php
127/themes/MegaShop/modules/whatsappchat/translations/es.php
128/modules/whatsappchat/translations/es.php
129/cache/smarty/compile/1f/c3/ea/1fc3eae2711f7e8d0db3c345bc9f6d0efdc1c994.file.template.tpl.php
130/modules/advancedpopupcreator/advancedpopupcreator.php
131/modules/advancedpopupcreator/classes/AdvancedPopupCreatorConfiguration.php
132/themes/MegaShop/modules/advancedpopupcreator/translations/es.php
133/modules/advancedpopupcreator/translations/es.php
134/cache/smarty/compile/33/e1/90/33e190d0d72b18ac2a0f3487c4a0073fad063ff3.file.apc_functions_front.tpl.php
135/modules/redsys/redsys.php
136/modules/redsys/apiRedsys/apiRedsysFinal.php
137/modules/redsys/apiRedsys/json.php
138/modules/redsys/apiRedsys/hmac.php
139/modules/redsys/apiRedsys/hash.php
140/modules/redsys/apiRedsys/apiRedsysWs.php
141/modules/redsys/apiRedsys/idnovateUtils.php
142/modules/redsys/classes/RedsysTpv.php
143/themes/MegaShop/modules/redsys/translations/es.php
144/modules/redsys/translations/es.php
145/modules/blocklayered/blocklayered.php
146/themes/MegaShop/modules/blocklayered/translations/es.php
147/modules/blocklayered/translations/es.php
148/modules/quantitypack/quantitypack.php
149/themes/MegaShop/modules/quantitypack/translations/es.php
150/modules/ganalytics/ganalytics.php
151/themes/MegaShop/modules/ganalytics/translations/es.php
152/modules/ganalytics/translations/es.php
153/modules/ganalytics/es.php
154/modules/tptnmobilemenu/tptnmobilemenu.php
155/modules/tptnmobilemenu/tptnmobilemenuClass.php
156/themes/MegaShop/modules/tptnmobilemenu/translations/es.php
157/modules/tptnmobilemenu/translations/es.php
158/modules/paseocenterbulkedition/paseocenterbulkedition.php
159/modules/paseocenterbulkedition/classes/PaMeta.php
160/modules/paseocenterbulkedition/classes/PaPage.php
161/modules/paseocenterbulkedition/translations/es.php
162/cache/smarty/compile/d0/ef/c5/d0efc55fc5c884a2d0fe99b99c596e996a101d1b.file.header.tpl.php
163/tools/smarty/plugins/modifier.escape.php
164/modules/paylater/paylater.php
165/modules/paylater/vendor/autoload.php
166/modules/paylater/vendor/composer/autoload_real.php
167/modules/paylater/vendor/composer/autoload_static.php
168/themes/MegaShop/modules/paylater/translations/es.php
169/modules/paylater/translations/es.php
170/cache/smarty/cache/blocksearch_top/1/6/9f/4e/38/9f4e3856f7cd720452e0e628a5a069fa1ef4d538.blocksearch-top.tpl.php
171/Adapter/Adapter_AddressFactory.php
172/Adapter/Adapter_ProductPriceCalculator.php
173/Adapter/Adapter_Configuration.php
174/Core/Business/Core_Business_ConfigurationInterface.php
175/classes/Customization.php
176/cache/smarty/compile/60/d7/8e/60d78eb79aecceec1f57a330a903df4c4724da88.file.blockcart.tpl.php
177/tools/smarty/plugins/modifier.replace.php
178/tools/smarty/plugins/function.counter.php
179/cache/smarty/cache/blocktopmenu/1/6/index/c0/bf/9c/c0bf9ce0014fe3f2c8b5f5df726725535e948d32.blocktopmenu.tpl.php
180/cache/smarty/cache/blocktopmenu/1/index/1/1/1/0/0/0/0/0/b1/62/f0/b162f0976e79f7e2f542abad678a7eca820f9831.tptnmobilemenu.tpl.php
181/cache/smarty/cache/tptnhomeslider/1/6/6a/36/88/6a368846e83d35dc0460a87fb4dfe537778f53d0.tptnhomeslider.tpl.php
182/modules/contentbox/contentbox.php
183/themes/MegaShop/modules/contentbox/translations/es.php
184/cache/smarty/compile/cc/4a/5c/cc4a5cc702978874746402c2b4a055df4f38351f.file.template.tpl.php
185/modules/tptnprodcarousel/tptnprodcarousel.php
186/themes/MegaShop/modules/tptnprodcarousel/translations/es.php
187/modules/tptnprodcarousel/translations/es.php
188/classes/Category.php
189/override/classes/Category.php
190/classes/Combination.php
191/classes/stock/StockAvailable.php
192/classes/tax/Tax.php
193/classes/Address.php
194/classes/SpecificPrice.php
195/classes/tax/TaxManagerFactory.php
196/classes/tax/TaxRulesTaxManager.php
197/classes/tax/TaxManagerInterface.php
198/classes/tax/TaxCalculator.php
199/classes/GroupReduction.php
200/classes/Feature.php
201/classes/Image.php
202/classes/ImageType.php
203/cache/smarty/cache/tptnprodcarousel/1/6/0d/9f/da/0d9fdac7d2545a1528cdaf8c948198cdfd53fc5a.tptnprodcarousel.tpl.php
204/modules/contentboxafter/contentboxafter.php
205/themes/MegaShop/modules/contentboxafter/translations/es.php
206/cache/smarty/compile/c3/f2/5e/c3f25e6750a7ca257f01c3d7db4c7a660e48c645.file.template.tpl.php
207/modules/blockbestsellers/blockbestsellers.php
208/themes/MegaShop/modules/blockbestsellers/translations/es.php
209/modules/blockbestsellers/translations/es.php
210/modules/blockcms/blockcms.php
211/modules/blockcms/BlockCMSModel.php
212/themes/MegaShop/modules/blockcms/translations/es.php
213/modules/blockcms/translations/es.php
214/cache/smarty/cache/blockcms/2/1/6/c5/56/84/c55684646d816db26bfeefb8650d2f5940e7fbb4.blockcms.tpl.php
215/modules/tptnfooterblock1/tptnfooterblock1.php
216/themes/MegaShop/modules/tptnfooterblock1/translations/es.php
217/modules/tptnfooterblock1/translations/es.php
218/cache/smarty/compile/0a/87/7e/0a877ebc21d186c1df4e842dd038316230f1c252.file.tptnfooterblock1.tpl.php
219/modules/tptnsocial/tptnsocial.php
220/themes/MegaShop/modules/tptnsocial/translations/es.php
221/modules/tptnsocial/translations/es.php
222/cache/smarty/cache/tptnsocial/1/6/bc/7b/c6/bc7bc622708fd6398deedc645fc6efdc21414ffc.tptnsocial.tpl.php
223/cache/smarty/compile/3a/0d/4a/3a0d4a53bf3c654a9888bcd8437e715cdf4aaf88.file.footer.tpl.php
224/modules/contentboxfooter/contentboxfooter.php
225/themes/MegaShop/modules/contentboxfooter/translations/es.php
226/cache/smarty/compile/71/44/2c/71442cb5974889351d86b5774538c680b3809a3b.file.template.tpl.php
227/cache/smarty/compile/a5/c5/ca/a5c5ca68769d730396d3e2fcd91ebd2168abf764.file.index.tpl.php
228/cache/smarty/compile/14/c2/68/14c26805c63df9ccdf778f6b321ca8dffc0c6a98.file.layout.tpl.php
229/cache/smarty/compile/04/a1/93/04a193dba6f74bf31736a3b18c8d65d9ca9e8b09.file.header.tpl.php
230/tools/smarty/plugins/function.implode.php
231/cache/smarty/compile/d8/44/04/d84404ca1b3a4af7eeeea542b5d127082c3ae808.file.tptnhead.tpl.php
232/modules/contentboxhead/contentboxhead.php
233/cache/smarty/compile/f7/d0/1b/f7d01b91c82ca732956d11721e31e69d734e08d3.file.template.tpl.php
234/modules/tptnheaderlinks/tptnheaderlinks.php
235/themes/MegaShop/modules/tptnheaderlinks/translations/es.php
236/modules/tptnheaderlinks/translations/es.php
237/cache/smarty/compile/a3/a2/18/a3a21815a34bfefe9ae3db7cecac7f18c04bbbd9.file.tptnheaderlinks.tpl.php
238/cache/smarty/cache/blockcategories/1/6/2/3/28/74/ce/2874ce1fa450ee1a5b01a07551f032af8943fb05.blockcategories.tpl.php
239/cache/smarty/compile/e3/ec/0e/e3ec0e91521454adb47b28d583e095bda30fb4f4.file.footer.tpl.php
240/modules/contentboxfootertop/contentboxfootertop.php
241/cache/smarty/compile/c7/9c/92/c79c92a2ee809b43e6a547c2179b198af95bb7c1.file.template.tpl.php
242/cache/smarty/compile/b6/aa/ec/b6aaec8ff560061e3daeaa3740481c43d11a820c.file.global.tpl.php
243/cache/smarty/compile/86/4a/38/864a38f92e8c8a6c6e5a81ab294eafafdadd4a24.file.javascript.tpl.php
244/tools/smarty/plugins/shared.mb_str_replace.php