Movilidad reducida

Mostrando 1-24 de 36 artículo(s)

“La información contenida en este mensaje y/o archivo(s) adjunto(s), enviada desde NEW SPEED SL, es confidencial/privilegiada y está destinada a ser leída sólo por la(s) persona(s) a la(s) que va dirigida. Le recordamos que sus datos han sido incorporados en el sistema de tratamiento de NEW SPEED SL y que siempre y cuando se cumplan los requisitos exigidos por la normativa, usted podrá ejercer sus derechos de acceso, rectificación, limitación de tratamiento, supresión, portabilidad y oposición/revocación, en los términos que establece la normativa vigente en materia de protección de datos, dirigiendo su petición a la dirección postal C/ MONCADA 7 BJ IZQUIERDA 12005, CASTELLON (CASTELLÓN) o bien a través de correo electrónico "info@newspeed.es" Si usted lee este mensaje y no es el destinatario señalado, el empleado o el agente responsable de entregar el mensaje al destinatario, o ha recibido esta comunicación por error, le informamos que está totalmente prohibida, y puede ser ilegal, cualquier divulgación, distribución o reproducción de esta comunicación, y le rogamos que nos lo notifique inmediatamente y nos devuelva el mensaje original a la dirección arriba mencionada. Gracias”.

Load Time 489.697 ms
Querying Time 119 ms
Queries 513
Memory Peak Usage 50.5 Mb
Included Files 973 files - 10.16 Mb
PrestaShop Cache - Mb
Global vars 0.15 Mb
PrestaShop Version 8.1.7
PHP Version 7.2.34
MySQL Version 10.5.26-MariaDB
Memory Limit 256M
Max Execution Time 2000s
Smarty Cache disabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0.005 ms 0.005 ms 12.90 Mb 13.2 Mb
__construct 10.665 ms 10.670 ms 1.94 Mb 15.6 Mb
init 69.351 ms 80.021 ms 6.73 Mb 22.6 Mb
checkAccess 0.001 ms 80.022 ms - Mb 22.6 Mb
setMedia 5.833 ms 85.855 ms 0.69 Mb 22.6 Mb
postProcess 0.001 ms 85.856 ms - Mb 22.6 Mb
initHeader 0.002 ms 85.858 ms - Mb 22.6 Mb
initContent 179.123 ms 264.981 ms 11.08 Mb 33.4 Mb
initFooter 0.002 ms 264.983 ms - Mb 33.4 Mb
display 224.714 ms 489.697 ms 16.90 Mb 50.5 Mb
Hook Time Memory Usage
displayProductListReviews 69.642 ms 5.37 Mb
displayHeaderTop 43.137 ms 5.83 Mb
displayMainMenu 10.224 ms 0.56 Mb
DisplayBeforeBodyClosingTag 8.462 ms 0.46 Mb
displayFooter 4.857 ms 0.32 Mb
displayNav1 4.092 ms 0.37 Mb
ProductSearchProvider 3.158 ms 0.23 Mb
DisplayHeader 2.430 ms 0.04 Mb
displayLeftColumn 2.132 ms 0.07 Mb
displayVerticalMenu 1.855 ms 0.08 Mb
renderWidget 1.262 ms 0.07 Mb
ActionFrontControllerSetMedia 1.147 ms 0.13 Mb
displayBeforeBodyClosingTag 0.918 ms 0.05 Mb
displayNav2 0.728 ms 0.08 Mb
displayAfterBreadcrumb 0.470 ms 0.03 Mb
IsJustElementor 0.316 ms 0.02 Mb
DisplayLeftColumn 0.254 ms 0.01 Mb
DisplayTop 0.074 ms - Mb
ActionDispatcher 0.009 ms - Mb
ActionProductSearchAfter 0.005 ms - Mb
20 hook(s) 155.173 ms 13.72 Mb
Module Time Memory Usage
iqitthemeeditor 3.584 ms 0.61 Mb
ps_emailsubscription 3.489 ms 0.37 Mb
ps_emailalerts 2.124 ms 0.33 Mb
ps_shoppingcart 1.843 ms 0.05 Mb
productcomments 55.248 ms 4.56 Mb
ps_googleanalytics 3.362 ms 0.19 Mb
iqitcontactpage 1.596 ms 0.14 Mb
iqitcookielaw 1.519 ms 0.12 Mb
iqitelementor 50.335 ms 6.71 Mb
iqitmegamenu 18.089 ms 1.32 Mb
iqitreviews 17.125 ms 1.17 Mb
ps_facetedsearch 9.514 ms 0.63 Mb
iqitlinksmanager 8.697 ms 0.72 Mb
ps_languageselector 0.661 ms 0.07 Mb
ps_currencyselector 0.613 ms 0.07 Mb
iqitsearch 1.753 ms 0.11 Mb
ps_customersignin 0.231 ms 0.02 Mb
pagesnotfound 0.528 ms 0.05 Mb
iqitproductsnav 0.871 ms 0.07 Mb
ps_categorytree 2.745 ms 0.14 Mb
statsdata 6.141 ms 0.38 Mb
21 module(s) 190.069 ms 17.83 Mb

Stopwatch SQL - 513 queries

# Query Time (ms) Rows Filesort Group By Location
13 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `psm7_module` m
INNER JOIN psm7_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 `psm7_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `psm7_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `psm7_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
 2.641 ms 144 Yes Yes /classes/Hook.php:1267
2 
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 `psm7_configuration` c
LEFT JOIN `psm7_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
 2.570 ms 1081 /classes/Configuration.php:180
54 
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psm7_product p LEFT JOIN psm7_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psm7_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psm7_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN psm7_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psm7_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psm7_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN psm7_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psm7_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=5 AND c.nright<=6 GROUP BY p.id_product) p INNER JOIN psm7_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC
 1.771 ms 528 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
0 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM psm7_shop_url su
LEFT JOIN psm7_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.newspeed.es' OR su.domain_ssl = 'www.newspeed.es')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 1.742 ms 1 Yes /classes/shop/Shop.php:1364
62 
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `psm7_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `psm7_hook_alias` ha
INNER JOIN `psm7_hook` h ON ha.name = h.name
 1.661 ms 0 /classes/Hook.php:1326
63 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `psm7_hook_module` hm
STRAIGHT_JOIN `psm7_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `psm7_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 1.578 ms 370 /classes/Hook.php:456
12 
SELECT SQL_NO_CACHE lower(name) as name
FROM `psm7_hook` h
WHERE (h.active = 1)
 1.087 ms 950 /classes/Hook.php:1366
56 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-09-15 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM psm7_product p
LEFT JOIN psm7_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN psm7_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN psm7_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24)
 1.033 ms 85 /classes/ProductAssembler.php:95
512 
INSERT INTO `psm7_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('57377', '', 'www.newspeed.es/11-movilidad-reducida', '', '2024-09-15 19:48:28')
 1.032 ms 1 /classes/ObjectModel.php:622
492 
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `psm7_category` c
INNER JOIN `psm7_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
INNER JOIN `psm7_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 6
AND nleft >= 5 AND nright <= 6
AND c.id_category IN (
SELECT id_category
FROM `psm7_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
 0.898 ms 2 Yes /modules/ps_categorytree/ps_categorytree.php:166
419 
SELECT SQL_NO_CACHE *
FROM `psm7_contact` c
LEFT JOIN psm7_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `psm7_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 2
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
 0.856 ms 8 Yes Yes /classes/Contact.php:100
489 
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM psm7_iqitmegamenu_tabs_shop hs
LEFT JOIN psm7_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN psm7_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 2 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position
 0.852 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
506 
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `psm7_category_product` cp
LEFT JOIN `psm7_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `psm7_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24) AND cl.`id_lang` = 2
ORDER BY c.`level_depth` DESC
 0.806 ms 66 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
426 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 11 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.803 ms 2 Yes Yes /classes/Category.php:799
423 
SELECT SQL_NO_CACHE hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`,
hss.`position`,  hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`,
hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access`
FROM psm7_iqitmegamenu_tabs_shop hs
LEFT JOIN psm7_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab)
LEFT JOIN psm7_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab)
WHERE id_shop = 1 AND menu_type = 1 AND active = 1
AND hssl.id_lang = 2
ORDER BY hss.position
 0.798 ms 16 Yes /modules/iqitmegamenu/models/IqitMenuTab.php:178
427 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 12 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.747 ms 3 Yes Yes /classes/Category.php:799
428 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.731 ms 2 Yes Yes /classes/Category.php:799
429 
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `psm7_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `psm7_category` c2 ON c2.`id_category` = 14 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
 0.722 ms 1 Yes Yes /classes/Category.php:799
39 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `psm7_category` c
INNER JOIN psm7_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `psm7_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `psm7_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 11
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.705 ms 1 Yes Yes /classes/Category.php:924
15 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `psm7_meta` m
LEFT JOIN `psm7_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.653 ms 59 Yes /classes/Dispatcher.php:654
454 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (7) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.628 ms 1 Yes Yes /classes/Product.php:4520
16 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psm7_hook`
 0.616 ms 950 /classes/Hook.php:1326
446 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.592 ms 1 Yes Yes /classes/Product.php:4520
462 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (11) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.587 ms 1 Yes Yes /classes/Product.php:4520
478 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (19) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.576 ms 1 Yes Yes /classes/Product.php:4520
480 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (20) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.572 ms 1 Yes Yes /classes/Product.php:4520
456 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.569 ms 1 Yes Yes /classes/Product.php:4520
444 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.561 ms 1 Yes Yes /classes/Product.php:4520
442 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (1) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.545 ms 1 Yes Yes /classes/Product.php:4520
468 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (14) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.524 ms 1 Yes Yes /classes/Product.php:4520
452 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.515 ms 1 Yes Yes /classes/Product.php:4520
507 
INSERT INTO `psm7_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 0.501 ms 1 /classes/ObjectModel.php:622
11 
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psm7_lang` l
JOIN psm7_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.494 ms 1 /classes/Language.php:1216
450 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.481 ms 1 Yes Yes /classes/Product.php:4520
484 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (22) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.481 ms 1 Yes Yes /classes/Product.php:4520
464 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (12) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.480 ms 1 Yes Yes /classes/Product.php:4520
482 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (21) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.474 ms 1 Yes Yes /classes/Product.php:4520
458 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (9) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.473 ms 1 Yes Yes /classes/Product.php:4520
460 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (10) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.465 ms 1 Yes Yes /classes/Product.php:4520
466 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.462 ms 1 Yes Yes /classes/Product.php:4520
486 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (23) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.462 ms 1 Yes Yes /classes/Product.php:4520
470 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (15) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.461 ms 1 Yes Yes /classes/Product.php:4520
448 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.449 ms 1 Yes Yes /classes/Product.php:4520
476 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (18) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.446 ms 1 Yes Yes /classes/Product.php:4520
488 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (24) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.440 ms 1 Yes Yes /classes/Product.php:4520
335 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.412 ms 1 /src/Adapter/EntityMapper.php:71
132 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 6 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 6 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.410 ms 0 /classes/Cart.php:1426
18 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psm7_module` m
LEFT JOIN `psm7_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.403 ms 93 /classes/module/Module.php:345
51 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM psm7_layered_category
WHERE controller = 'category'
AND id_category = 11
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 0.398 ms 1 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
142 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 7 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.397 ms 0 /classes/Cart.php:1426
73 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.396 ms 0 /classes/Cart.php:1426
255 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 18) AND (b.`id_shop` = 1) LIMIT 1
 0.393 ms 1 /src/Adapter/EntityMapper.php:71
262 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 18 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 18 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.391 ms 0 /classes/Cart.php:1426
207 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 13 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.389 ms 0 /classes/Cart.php:1426
163 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 9 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 9 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.387 ms 0 /classes/Cart.php:1426
330 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 1) AND (b.`id_shop` = 1) LIMIT 1
 0.387 ms 1 /src/Adapter/EntityMapper.php:71
493 
SELECT SQL_NO_CACHE cb.`id_iqit_link_block`
FROM psm7_iqit_link_block cb
INNER JOIN psm7_iqit_link_block_shop cs ON (cb.`id_iqit_link_block` = cs.`id_iqit_link_block`)
WHERE `id_hook` = 45
AND cs.`id_shop` = 1
ORDER BY cb.position ASC
 0.384 ms 2 Yes /modules/iqitlinksmanager/src/IqitLinkBlockRepository.php:174
122 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.377 ms 0 /classes/Cart.php:1426
511 
INSERT INTO `psm7_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('58636', '6', '65790478', '', '1', '1', '2024-09-15 19:48:28')
 0.377 ms 1 /classes/ObjectModel.php:622
508 
SELECT SQL_NO_CACHE `id_guest`
FROM `psm7_connections`
WHERE `id_guest` = 58636
AND `date_add` > '2024-09-15 19:18:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.375 ms 1 Yes /classes/Connection.php:168
152 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 8 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.374 ms 0 /classes/Cart.php:1426
218 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 14 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 14 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.364 ms 0 /classes/Cart.php:1426
112 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.363 ms 0 /classes/Cart.php:1426
477 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 19 LIMIT 1
 0.363 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
87 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.361 ms 0 /classes/Cart.php:1426
443 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 2 LIMIT 1
 0.359 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
445 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 3 LIMIT 1
 0.358 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
40 
SELECT SQL_NO_CACHE 1 FROM psm7_cart_product cp INNER JOIN psm7_product p
ON (p.id_product = cp.id_product) INNER JOIN psm7_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.355 ms 1 /classes/Cart.php:4243
453 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 7 LIMIT 1
 0.354 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
20 
SELECT SQL_NO_CACHE *
FROM `psm7_category` a
LEFT JOIN `psm7_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `psm7_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) AND (b.`id_shop` = 1) LIMIT 1
 0.351 ms 1 /src/Adapter/EntityMapper.php:71
340 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4) AND (b.`id_shop` = 1) LIMIT 1
 0.348 ms 1 /src/Adapter/EntityMapper.php:71
1 
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 psm7_shop_group gs
LEFT JOIN psm7_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN psm7_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.346 ms 1 Yes /classes/shop/Shop.php:715
99 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.343 ms 0 /classes/Cart.php:1426
196 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 12 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.343 ms 0 /classes/Cart.php:1426
349 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7) AND (b.`id_shop` = 1) LIMIT 1
 0.339 ms 1 /src/Adapter/EntityMapper.php:71
174 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.339 ms 0 /classes/Cart.php:1426
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM psm7_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.339 ms 1 /classes/shop/ShopUrl.php:182
8 
SELECT SQL_NO_CACHE *
FROM `psm7_lang` a
LEFT JOIN `psm7_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
 0.338 ms 1 /src/Adapter/EntityMapper.php:71
472 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (16) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.336 ms 1 Yes Yes /classes/Product.php:4520
317 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 23 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 23 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.332 ms 0 /classes/Cart.php:1426
306 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 22 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 22 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.330 ms 0 /classes/Cart.php:1426
273 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 19 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 19 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.330 ms 0 /classes/Cart.php:1426
229 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 15 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 15 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.329 ms 0 /classes/Cart.php:1426
346 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 6) AND (b.`id_shop` = 1) LIMIT 1
 0.328 ms 1 /src/Adapter/EntityMapper.php:71
185 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 11 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 11 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.325 ms 0 /classes/Cart.php:1426
64 
SELECT SQL_NO_CACHE tr.*
FROM `psm7_tax_rule` tr
JOIN `psm7_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` = 53
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.323 ms 1 /classes/tax/TaxRulesTaxManager.php:109
251 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 17 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 17 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.323 ms 0 /classes/Cart.php:1426
211 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14) AND (b.`id_shop` = 1) LIMIT 1
 0.322 ms 1 /src/Adapter/EntityMapper.php:71
240 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 16 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 16 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.322 ms 0 /classes/Cart.php:1426
284 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 20 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.319 ms 0 /classes/Cart.php:1426
156 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9) AND (b.`id_shop` = 1) LIMIT 1
 0.317 ms 1 /src/Adapter/EntityMapper.php:71
434 
SELECT SQL_NO_CACHE *
FROM `psm7_currency` c
INNER JOIN psm7_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
 0.317 ms 2 Yes /classes/Currency.php:694
461 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 11 LIMIT 1
 0.316 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
328 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 24 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 24 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.316 ms 0 /classes/Cart.php:1426
422 
SELECT SQL_NO_CACHE `width`, `height`
FROM psm7_image_type
WHERE `name` = 'small_default' LIMIT 1
 0.314 ms 1 /classes/Image.php:563
474 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `psm7_product_attribute` pa
INNER JOIN psm7_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `psm7_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `psm7_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `psm7_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `psm7_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (17) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.313 ms 1 Yes Yes /classes/Product.php:4520
295 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `psm7_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `psm7_cart_product` cp JOIN `psm7_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psm7_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 21 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.313 ms 0 /classes/Cart.php:1426
123 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5
ORDER BY f.position ASC
 0.309 ms 2 Yes /classes/Product.php:6017
447 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 4 LIMIT 1
 0.306 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
455 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 8 LIMIT 1
 0.303 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
34 
SELECT SQL_NO_CACHE *
FROM `psm7_group` a
LEFT JOIN `psm7_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.303 ms 1 /src/Adapter/EntityMapper.php:71
409 
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "revsliderprestashop" LIMIT 1
 0.302 ms 1 /classes/module/Module.php:2636
310 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23) AND (b.`id_shop` = 1) LIMIT 1
 0.299 ms 1 /src/Adapter/EntityMapper.php:71
92 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3) AND (b.`id_shop` = 1) LIMIT 1
 0.298 ms 1 /src/Adapter/EntityMapper.php:71
126 
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, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `psm7_product` p
INNER JOIN `psm7_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `psm7_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` = 6)
 0.297 ms 1 /classes/Product.php:3860
451 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 6 LIMIT 1
 0.296 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
497 
SELECT SQL_NO_CACHE *
FROM psm7_meta m
LEFT JOIN psm7_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
 0.292 ms 2 /classes/Meta.php:193
167 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10) AND (b.`id_shop` = 1) LIMIT 1
 0.292 ms 1 /src/Adapter/EntityMapper.php:71
266 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 19) AND (b.`id_shop` = 1) LIMIT 1
 0.290 ms 1 /src/Adapter/EntityMapper.php:71
222 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 15) AND (b.`id_shop` = 1) LIMIT 1
 0.289 ms 1 /src/Adapter/EntityMapper.php:71
189 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12) AND (b.`id_shop` = 1) LIMIT 1
 0.289 ms 1 /src/Adapter/EntityMapper.php:71
5 
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `psm7_lang` l
LEFT JOIN `psm7_lang_shop` ls ON (l.id_lang = ls.id_lang)
 0.288 ms 1 /classes/Language.php:1080
244 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 17) AND (b.`id_shop` = 1) LIMIT 1
 0.287 ms 1 /src/Adapter/EntityMapper.php:71
420 
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitsearch" LIMIT 1
 0.287 ms 1 /classes/module/Module.php:2636
459 
SELECT SQL_NO_CACHE (SUM(pr.`rating`) / COUNT(pr.`rating`)) AS avarageRating, COUNT(pr.`rating`) as reviewsNb
FROM `psm7_iqitreviews_products` pr
WHERE pr.`status` = 1  AND pr.`id_product` = 10 LIMIT 1
 0.284 ms 1 /modules/iqitreviews/src/IqitProductReview.php:116
388 
SELECT SQL_NO_CACHE `id_module` FROM `psm7_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
 0.284 ms 1 /classes/module/Module.php:2636
233 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 16) AND (b.`id_shop` = 1) LIMIT 1
 0.283 ms 1 /src/Adapter/EntityMapper.php:71
178 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 11) AND (b.`id_shop` = 1) LIMIT 1
 0.282 ms 1 /src/Adapter/EntityMapper.php:71
343 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1
 0.278 ms 1 /src/Adapter/EntityMapper.php:71
352 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8) AND (b.`id_shop` = 1) LIMIT 1
 0.278 ms 1 /src/Adapter/EntityMapper.php:71
277 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20) AND (b.`id_shop` = 1) LIMIT 1
 0.277 ms 1 /src/Adapter/EntityMapper.php:71
408 
SELECT SQL_NO_CACHE *
FROM `psm7_iqit_elementor_content` a
LEFT JOIN `psm7_iqit_elementor_content_lang` `b` ON a.`id_elementor` = b.`id_elementor` AND b.`id_lang` = 2
LEFT JOIN `psm7_iqit_elementor_content_shop` `c` ON a.`id_elementor` = c.`id_elementor` AND c.`id_shop` = 1
WHERE (a.`id_elementor` = 1) AND (b.`id_shop` = 1) LIMIT 1
 0.277 ms 1 /src/Adapter/EntityMapper.php:71
200 
SELECT SQL_NO_CACHE *
FROM `psm7_product` a
LEFT JOIN `psm7_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `psm7_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13) AND (b.`id_shop` = 1) LIMIT 1
 0.276 ms 1 /src/Adapter/EntityMapper.php:71
50 
SELECT SQL_NO_CACHE `id_category`
FROM `psm7_category_shop`
WHERE `id_category` = 11
AND `id_shop` = 1 LIMIT 1
 0.275 ms 1 /classes/Category.php:2450
74 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1
ORDER BY f.position ASC
 0.275 ms 2 Yes /classes/Product.php:6017
133 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 6
ORDER BY f.position ASC
 0.273 ms 2 Yes /classes/Product.php:6017
357 
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psm7_image` i
INNER JOIN psm7_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `psm7_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 10
ORDER BY `position`
 0.271 ms 1 Yes /classes/Product.php:3545
143 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM psm7_feature_product pf
LEFT JOIN psm7_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN psm7_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN psm7_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN psm7_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7
ORDER BY f.position ASC
 0.268 ms 2 Yes /classes/Product.php:6017