Collier "Galet" Long 2 perles en verre de Murano
search
  • Collier "Galet" Long 2 perles en verre de Murano

Collier "Galet" Long 2 perles en verre de Murano

49,00 €
TTC

Collier en verre de Murano et gomme mousse. Réglable. Pas de fermoir, très facile à porter.

S'adapte à tous les décolletés. Voir vidéo

La première perle ne s'enlève pas du collier. La deuxième perle peut s'enlever et être changée avec une autre.

Couleurs "Galet" 2 perles : Noir brillant - Rouge brillant
Quantité
Disponible

  Conditons Générales de vente

Nos conditions générales de vente vous assure une experience simple et transparente.

Réglable: on peut faire glisser les perles de haut en bas

·         Personnalisation collier

Les combinaisons de couleurs sont infinies, vous pouvez créer votre propre combinaison de couleur : explications dans « collier galet long 1 Perle » (voir la vidéo démonstrative).

Détails

Longueur: 120 cm environ

Diamètre Perle : 3,5 cm environ.

Poids collier: 30 g

Toutes les perles sont réalisées une par une à la main ce qui leur donne un caractère particulier.

Dimension donnée à titre indicatif + ou - quelques millimètres

10 Produits

Vous aimerez aussi

Commentaires (0)
Load Time 1263 ms
Querying Time 981 ms
Queries 884
Memory Peak Usage 23.6 Mb
Included Files 966 files - 10.65 Mb
PrestaShop Cache - Mb
Global vars 0.16 Mb
PrestaShop Version 8.1.5
PHP Version 8.1.29
MySQL Version 10.11.6-MariaDB-0+deb12u1
Memory Limit 256M
Max Execution Time 120s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0.003 ms 0.003 ms 1.94 Mb 2.3 Mb
__construct 5.766 ms 5.769 ms - Mb 2.7 Mb
init 67.477 ms 73.246 ms 1.19 Mb 3.2 Mb
checkAccess 0.002 ms 73.248 ms - Mb 3.2 Mb
setMedia 3.566 ms 76.814 ms 0.11 Mb 3.3 Mb
postProcess 0.005 ms 76.819 ms - Mb 3.3 Mb
initHeader 0.001 ms 76.820 ms - Mb 3.3 Mb
initContent 329.857 ms 406.677 ms 3.56 Mb 6.8 Mb
initFooter 0.003 ms 406.680 ms - Mb 6.8 Mb
display 856 ms 1263 ms 16.45 Mb 23.6 Mb
Hook Time Memory Usage
displayProductAdditionalInfo 31.239 ms 0.31 Mb
displayNav2 28.094 ms 0.19 Mb
displayTop 19.237 ms 0.15 Mb
displayProductListReviews 15.057 ms 0.03 Mb
DisplayFooterProduct 12.190 ms 0.17 Mb
DisplayBeforeBodyClosingTag 8.612 ms 0.22 Mb
displayNav1 8.273 ms 0.06 Mb
displayFooter 5.483 ms 0.11 Mb
DisplayReassurance 5.196 ms 0.05 Mb
displayFooterBefore 3.270 ms 0.10 Mb
DisplayHeader 2.253 ms 0.02 Mb
displayFooterProduct 1.565 ms 0.05 Mb
DisplayFooterAfter 1.116 ms 0.04 Mb
ActionFrontControllerSetMedia 0.597 ms 0.01 Mb
DisplayAfterBodyOpeningTag 0.007 ms - Mb
DisplayNavFullWidth 0.006 ms - Mb
DisplayProductAdditionalInfo 0.006 ms - Mb
DisplayFooterBefore 0.006 ms - Mb
18 hook(s) 142.206 ms 1.51 Mb
Module Time Memory Usage
ps_emailsubscription 3.598 ms 0.11 Mb
blockreassurance 6.720 ms 0.10 Mb
ps_emailalerts 0.261 ms 0.01 Mb
ps_imageslider 0.493 ms 0.01 Mb
ps_searchbar 6.433 ms 0.05 Mb
ps_shoppingcart 9.089 ms 0.05 Mb
ps_googleanalytics 4.211 ms 0.07 Mb
productcomments 50.723 ms 0.43 Mb
ps_contactinfo 11.229 ms 0.10 Mb
ps_languageselector 7.703 ms 0.05 Mb
ps_currencyselector 7.724 ms 0.06 Mb
ps_customersignin 4.283 ms 0.05 Mb
ps_mainmenu 6.943 ms 0.07 Mb
ps_linklist 12.680 ms 0.08 Mb
ps_viewedproduct 7.101 ms 0.10 Mb
psgdpr 0.742 ms 0.03 Mb
ps_socialfollow 1.740 ms 0.06 Mb
ps_customeraccountlinks 2.135 ms 0.07 Mb
statsdata 8.797 ms 0.22 Mb
19 module(s) 152.605 ms 1.73 Mb

Stopwatch SQL - 884 queries

# Query Time (ms) Rows Filesort Group By Location
405
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2082) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.392 ms 1 /classes/stock/StockAvailable.php:453
406
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2083) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.699 ms 1 /classes/stock/StockAvailable.php:453
490
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
6.453 ms 84 /classes/Product.php:2752
371
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (9) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
5.884 ms 42 Yes Yes /classes/Product.php:4520
429
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2107) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.663 ms 1 /classes/stock/StockAvailable.php:453
435
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2113) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.541 ms 1 /classes/stock/StockAvailable.php:453
428
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2106) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.393 ms 1 /classes/stock/StockAvailable.php:453
313
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 10
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
5.010 ms 12 Yes Yes /classes/Product.php:4594
432
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2110) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.990 ms 1 /classes/stock/StockAvailable.php:453
343
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 24 AND `id_shop` = 1 LIMIT 1
4.793 ms 1 /classes/module/Module.php:2109
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 `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.788 ms 42 Yes Yes /classes/Product.php:4520
407
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2085) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.741 ms 1 /classes/stock/StockAvailable.php:453
698
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 20 AND `id_shop` = 1
4.732 ms 3 /src/Adapter/EntityMapper.php:79
350
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10) LIMIT 1
4.688 ms 1 /src/Adapter/EntityMapper.php:71
394
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 9
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
4.600 ms 42 Yes /classes/Product.php:2734
377
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2080
AND agl.`id_lang` = 1
4.588 ms 2 /classes/Product.php:7528
353
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 10
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
4.565 ms 12 Yes /classes/Product.php:2734
386
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2090
AND agl.`id_lang` = 1
4.412 ms 2 /classes/Product.php:7528
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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
4.403 ms 701 /classes/Configuration.php:180
374
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2083
AND agl.`id_lang` = 1
4.362 ms 2 /classes/Product.php:7528
370
SELECT SQL_NO_CACHE * FROM `ps_psreassurance` pr
LEFT JOIN ps_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "1"
AND pr.status = 1
ORDER BY pr.position
4.342 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
438
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 12
AND pac.`id_product_attribute` = 2239
AND agl.`id_lang` = 1
4.214 ms 1 /classes/Product.php:7528
404
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2081) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.212 ms 1 /classes/stock/StockAvailable.php:453
389
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2092
AND agl.`id_lang` = 1
4.199 ms 2 /classes/Product.php:7528
382
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2088
AND agl.`id_lang` = 1
4.152 ms 2 /classes/Product.php:7528
315
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (2753, 2754, 2755, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2763, 2764) AND il.`id_lang` = 1 ORDER by i.`position`
4.136 ms 23 Yes /classes/Product.php:2921
395
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
4.093 ms 84 /classes/Product.php:2752
65
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-07-16 00:00:00",
INTERVAL 0 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 10 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
4.023 ms 11 Yes /classes/Product.php:4698
37
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 `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
4.014 ms 433 /classes/Hook.php:456
399
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2075) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.010 ms 1 /classes/stock/StockAvailable.php:453
346
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_mainmenu" LIMIT 1
3.983 ms 1 /classes/module/Module.php:2636
329
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
3.948 ms 1 /classes/ObjectModel.php:1592
376
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2073
AND agl.`id_lang` = 1
3.911 ms 2 /classes/Product.php:7528
325
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 1 LIMIT 1
3.909 ms 1 /classes/AddressFormat.php:656
318
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
3.795 ms 0 /classes/module/Module.php:2109
416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2094) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.792 ms 1 /classes/stock/StockAvailable.php:453
436
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2114) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.707 ms 1 /classes/stock/StockAvailable.php:453
433
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2111) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.684 ms 1 /classes/stock/StockAvailable.php:453
332
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
3.682 ms 1 /classes/module/Module.php:2636
398
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2074) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.674 ms 1 /classes/stock/StockAvailable.php:453
408
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2086) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.655 ms 1 /classes/stock/StockAvailable.php:453
363
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2762) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.634 ms 1 /classes/stock/StockAvailable.php:453
437
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (12) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3.597 ms 12 Yes Yes /classes/Product.php:4520
15
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
3.568 ms 108 Yes Yes /classes/Hook.php:1233
684
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2338
AND agl.`id_lang` = 1
3.566 ms 1 /classes/Product.php:7528
685
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2339
AND agl.`id_lang` = 1
3.560 ms 1 /classes/Product.php:7528
419
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2097) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.558 ms 1 /classes/stock/StockAvailable.php:453
361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2760) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.551 ms 1 /classes/stock/StockAvailable.php:453
330
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 10) AND (a0.`nright` > 11) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
3.528 ms 14 Yes /classes/PrestaShopCollection.php:383
326
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
3.492 ms 1 /classes/Country.php:405
342
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
3.449 ms 1 /classes/module/Module.php:2636
388
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2091
AND agl.`id_lang` = 1
3.384 ms 2 /classes/Product.php:7528
356
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2755) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.365 ms 1 /classes/stock/StockAvailable.php:453
412
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2090) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.359 ms 1 /classes/stock/StockAvailable.php:453
373
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2074
AND agl.`id_lang` = 1
3.357 ms 2 /classes/Product.php:7528
431
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2109) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.350 ms 1 /classes/stock/StockAvailable.php:453
425
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2103) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.345 ms 1 /classes/stock/StockAvailable.php:453
366
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
3.330 ms 1 /classes/module/Module.php:2636
557
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
3.322 ms 84 /classes/Product.php:2752
336
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
3.312 ms 1 /classes/module/Module.php:2109
359
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2758) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.311 ms 1 /classes/stock/StockAvailable.php:453
321
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 10) AND (b.`id_shop` = 1) LIMIT 1
3.301 ms 1 /src/Adapter/EntityMapper.php:71
420
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2098) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.282 ms 1 /classes/stock/StockAvailable.php:453
401
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2078) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.279 ms 1 /classes/stock/StockAvailable.php:453
348
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
3.264 ms 1 /classes/module/Module.php:2636
379
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2079
AND agl.`id_lang` = 1
3.213 ms 2 /classes/Product.php:7528
364
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2763) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.191 ms 1 /classes/stock/StockAvailable.php:453
424
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2102) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.180 ms 1 /classes/stock/StockAvailable.php:453
434
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2112) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.179 ms 1 /classes/stock/StockAvailable.php:453
312
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (2753, 2754, 2755, 2756, 2757, 2758, 2759, 2760, 2761, 2762, 2763, 2764) AND il.`id_lang` = 1 ORDER by i.`position`
3.177 ms 23 Yes /classes/Product.php:2921
322
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 18 LIMIT 1
3.149 ms 1 /classes/Category.php:1378
338
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
3.144 ms 1 /classes/module/Module.php:2109
372
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2075
AND agl.`id_lang` = 1
3.136 ms 2 /classes/Product.php:7528
380
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2081
AND agl.`id_lang` = 1
3.104 ms 2 /classes/Product.php:7528
392
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 9) LIMIT 1
3.080 ms 1 /src/Adapter/EntityMapper.php:71
355
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2754) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.066 ms 1 /classes/stock/StockAvailable.php:453
439
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 12
AND pac.`id_product_attribute` = 2240
AND agl.`id_lang` = 1
3.057 ms 1 /classes/Product.php:7528
344
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
3.026 ms 1 /classes/module/Module.php:2636
383
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2086
AND agl.`id_lang` = 1
2.997 ms 2 /classes/Product.php:7528
465
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2122
AND agl.`id_lang` = 1
2.990 ms 2 /classes/Product.php:7528
335
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
2.979 ms 1 /classes/module/Module.php:2636
427
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2105) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.950 ms 1 /classes/stock/StockAvailable.php:453
64
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 10
2.946 ms 12 /classes/Product.php:7557
683
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2337
AND agl.`id_lang` = 1
2.920 ms 1 /classes/Product.php:7528
331
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 10 LIMIT 1
2.903 ms 1 /classes/Hook.php:244
354
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
2.903 ms 12 /classes/Product.php:2752
468
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2125
AND agl.`id_lang` = 1
2.892 ms 2 /classes/Product.php:7528
367
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 94 AND `id_shop` = 1 LIMIT 1
2.868 ms 1 /classes/module/Module.php:2109
369
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 88 AND `id_shop` = 1 LIMIT 1
2.865 ms 1 /classes/module/Module.php:2109
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
2.827 ms 934 /classes/Hook.php:1332
362
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 10) AND (id_product_attribute = 2761) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.827 ms 1 /classes/stock/StockAvailable.php:453
36
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
2.825 ms 0 /classes/Hook.php:1292
294
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 10
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 2753 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
2.779 ms 1 Yes Yes /classes/Product.php:4594
792
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2547,2548,2549,2550,2551,2552,2553,2554,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
2.760 ms 127 /classes/Product.php:2752
391
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2078
AND agl.`id_lang` = 1
2.753 ms 2 /classes/Product.php:7528
451
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 12
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
2.741 ms 12 Yes /classes/Product.php:2734
452
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2765)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
2.739 ms 12 /classes/Product.php:2752
445
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 12
AND pac.`id_product_attribute` = 2246
AND agl.`id_lang` = 1
2.726 ms 1 /classes/Product.php:7528
446
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 12
AND pac.`id_product_attribute` = 2247
AND agl.`id_lang` = 1
2.694 ms 1 /classes/Product.php:7528
317
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
2.691 ms 1 /classes/module/Module.php:2636
411
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2089) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.649 ms 1 /classes/stock/StockAvailable.php:453
444
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 12
AND pac.`id_product_attribute` = 2245
AND agl.`id_lang` = 1
2.645 ms 1 /classes/Product.php:7528
449
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12) LIMIT 1
2.643 ms 1 /src/Adapter/EntityMapper.php:71
323
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_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
2.642 ms 1 /src/Adapter/EntityMapper.php:71
440
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 12
AND pac.`id_product_attribute` = 2241
AND agl.`id_lang` = 1
2.634 ms 1 /classes/Product.php:7528