Murano Glass Beads "trio" - Brilliant green
search
  • Murano Glass Beads "trio" - Brilliant green

Murano Glass Beads "trio" - Brilliant green

€57.00
VAT included

A selection of three shiny Murano glass beads in green tones.

Murano glass beads, sold in sets of 3, can be combined with the "Galet" and "Tour de cou câble " necklaces.

Quantity
In Stock

  Conditons Générales de vente

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

Détails:

All the beads are made one by one by hand which gives them a uniqueness.

diameter about 3,5 cm.

Colors: Anis green glossy - Light green glossy - Petrol glossy

weight: 10 g

Dimension given as an indication +/- a few millimeters

10 Items

You might also like

Comments (0)
Load Time 1488 ms
Querying Time 1375 ms
Queries 401
Memory Peak Usage 12.5 Mb
Included Files 965 files - 10.61 Mb
PrestaShop Cache - Mb
Global vars 0.03 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.014 ms 0.014 ms 1.95 Mb 2.3 Mb
__construct 3.187 ms 3.201 ms - Mb 2.7 Mb
init 61.174 ms 64.375 ms 1.18 Mb 3.3 Mb
checkAccess 0.001 ms 64.376 ms - Mb 3.3 Mb
setMedia 4.868 ms 69.244 ms 0.11 Mb 3.3 Mb
postProcess 0.005 ms 69.249 ms - Mb 3.3 Mb
initHeader 0.001 ms 69.250 ms - Mb 3.3 Mb
initContent 181.276 ms 250.526 ms 1.92 Mb 5.2 Mb
initFooter 0.003 ms 250.529 ms - Mb 5.2 Mb
display 1237 ms 1488 ms 7.14 Mb 12.5 Mb
Hook Time Memory Usage
displayNav2 55.706 ms 0.19 Mb
displayTop 31.746 ms 0.16 Mb
displayProductAdditionalInfo 31.314 ms 0.31 Mb
displayFooter 21.102 ms 0.12 Mb
DisplayFooterProduct 20.463 ms 0.13 Mb
DisplayBeforeBodyClosingTag 18.811 ms 0.21 Mb
displayFooterBefore 18.564 ms 0.10 Mb
displayNav1 13.746 ms 0.06 Mb
displayProductListReviews 8.993 ms 0.02 Mb
DisplayFooterAfter 6.520 ms 0.04 Mb
DisplayReassurance 6.079 ms 0.05 Mb
displayFooterProduct 2.251 ms 0.05 Mb
DisplayHeader 0.900 ms 0.02 Mb
ActionFrontControllerSetMedia 0.207 ms 0.01 Mb
DisplayAfterBodyOpeningTag 0.008 ms - Mb
DisplayFooterBefore 0.007 ms - Mb
DisplayNavFullWidth 0.006 ms - Mb
DisplayProductAdditionalInfo 0.006 ms - Mb
18 hook(s) 236.429 ms 1.47 Mb
Module Time Memory Usage
ps_emailsubscription 9.353 ms 0.11 Mb
blockreassurance 12.809 ms 0.10 Mb
ps_emailalerts 0.193 ms 0.01 Mb
ps_imageslider 0.253 ms 0.01 Mb
ps_searchbar 15.920 ms 0.05 Mb
ps_shoppingcart 16.806 ms 0.05 Mb
ps_googleanalytics 9.898 ms 0.05 Mb
productcomments 42.243 ms 0.39 Mb
ps_contactinfo 18.673 ms 0.10 Mb
ps_languageselector 11.974 ms 0.05 Mb
ps_currencyselector 16.179 ms 0.06 Mb
ps_customersignin 11.354 ms 0.05 Mb
ps_mainmenu 7.872 ms 0.07 Mb
ps_linklist 14.058 ms 0.09 Mb
ps_viewedproduct 11.942 ms 0.10 Mb
psgdpr 0.260 ms 0.01 Mb
ps_socialfollow 11.146 ms 0.06 Mb
ps_customeraccountlinks 16.171 ms 0.07 Mb
statsdata 18.934 ms 0.22 Mb
19 module(s) 246.038 ms 1.66 Mb

Stopwatch SQL - 401 queries

# Query Time (ms) Rows Filesort Group By Location
294
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
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
12.712 ms 84 /classes/Product.php:2752
226
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
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
12.411 ms 84 /classes/Product.php:2752
270
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2123
AND agl.`id_lang` = 3
11.069 ms 2 /classes/Product.php:7528
365
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2334) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
10.617 ms 1 /classes/stock/StockAvailable.php:453
201
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` = 3)
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;
10.307 ms 42 Yes Yes /classes/Product.php:4520
361
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pac.id_product_attribute IN (2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2344,2345,2346,2347,2348,2349,2350,2351)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
10.297 ms 21 /classes/Product.php:2752
391
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
10.035 ms 1 /classes/module/Module.php:2636
239
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
9.845 ms 1 /classes/stock/StockAvailable.php:453
217
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2085
AND agl.`id_lang` = 3
9.703 ms 2 /classes/Product.php:7528
183
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1
9.636 ms 1 /classes/module/Module.php:2636
236
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
9.374 ms 1 /classes/stock/StockAvailable.php:453
319
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2147) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
9.144 ms 1 /classes/stock/StockAvailable.php:453
312
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2140) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.866 ms 1 /classes/stock/StockAvailable.php:453
188
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
8.825 ms 1 /classes/module/Module.php:2636
205
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2072
AND agl.`id_lang` = 3
8.806 ms 2 /classes/Product.php:7528
276
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2129
AND agl.`id_lang` = 3
8.672 ms 2 /classes/Product.php:7528
329
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2158) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.570 ms 1 /classes/stock/StockAvailable.php:453
384
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` IN (25) AND cl.`id_lang` = 3
ORDER BY c.`level_depth` DESC
8.550 ms 1 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
351
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2345
AND agl.`id_lang` = 3
8.526 ms 1 /classes/Product.php:7528
344
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2338
AND agl.`id_lang` = 3
8.482 ms 1 /classes/Product.php:7528
251
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
8.448 ms 1 /classes/stock/StockAvailable.php:453
322
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2151) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.199 ms 1 /classes/stock/StockAvailable.php:453
247
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
8.197 ms 1 /classes/stock/StockAvailable.php:453
261
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2108) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.103 ms 1 /classes/stock/StockAvailable.php:453
374
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2343) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
8.078 ms 1 /classes/stock/StockAvailable.php:453
207
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2080
AND agl.`id_lang` = 3
8.023 ms 2 /classes/Product.php:7528
272
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2125
AND agl.`id_lang` = 3
7.943 ms 2 /classes/Product.php:7528
268
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` = 3)
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;
7.881 ms 42 Yes Yes /classes/Product.php:4520
295
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2122) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.839 ms 1 /classes/stock/StockAvailable.php:453
191
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
7.741 ms 1 /classes/module/Module.php:2109
258
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
7.671 ms 1 /classes/stock/StockAvailable.php:453
190
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
7.597 ms 1 /classes/module/Module.php:2636
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`)
7.458 ms 701 /classes/Configuration.php:180
363
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2332) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.429 ms 1 /classes/stock/StockAvailable.php:453
189
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 24 AND `id_shop` = 1 LIMIT 1
7.425 ms 1 /classes/module/Module.php:2109
289
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2130
AND agl.`id_lang` = 3
7.376 ms 2 /classes/Product.php:7528
160
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 25
ORDER BY `position`
7.372 ms 1 Yes /classes/Product.php:3545
259
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
7.285 ms 1 /classes/stock/StockAvailable.php:453
317
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2145) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.188 ms 1 /classes/stock/StockAvailable.php:453
297
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2124) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.171 ms 1 /classes/stock/StockAvailable.php:453
170
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` = 13 LIMIT 1
7.162 ms 1 /classes/Category.php:1378
379
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2348) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
7.069 ms 1 /classes/stock/StockAvailable.php:453
232
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
7.063 ms 1 /classes/stock/StockAvailable.php:453
260
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
7.040 ms 1 /classes/stock/StockAvailable.php:453
314
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2142) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.941 ms 1 /classes/stock/StockAvailable.php:453
372
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2341) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.757 ms 1 /classes/stock/StockAvailable.php:453
320
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2148) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.752 ms 1 /classes/stock/StockAvailable.php:453
380
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2349) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.581 ms 1 /classes/stock/StockAvailable.php:453
274
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2127
AND agl.`id_lang` = 3
6.556 ms 2 /classes/Product.php:7528
275
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2128
AND agl.`id_lang` = 3
6.504 ms 2 /classes/Product.php:7528
213
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2086
AND agl.`id_lang` = 3
6.465 ms 2 /classes/Product.php:7528
330
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2159) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.452 ms 1 /classes/stock/StockAvailable.php:453
235
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
6.411 ms 1 /classes/stock/StockAvailable.php:453
299
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2126) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.347 ms 1 /classes/stock/StockAvailable.php:453
389
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
6.331 ms 1 /classes/module/Module.php:2636
186
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1
6.279 ms 1 /classes/module/Module.php:2636
371
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2340) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.270 ms 1 /classes/stock/StockAvailable.php:453
366
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2335) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.269 ms 1 /classes/stock/StockAvailable.php:453
340
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2334
AND agl.`id_lang` = 3
6.232 ms 1 /classes/Product.php:7528
223
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 9 AND `id_shop` = 1
6.193 ms 3 /src/Adapter/EntityMapper.php:79
394
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 = "3"
AND pr.status = 1
ORDER BY pr.position
6.176 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
313
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2141) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.148 ms 1 /classes/stock/StockAvailable.php:453
229
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
6.100 ms 1 /classes/stock/StockAvailable.php:453
373
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2342) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
6.084 ms 1 /classes/stock/StockAvailable.php:453
346
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2340
AND agl.`id_lang` = 3
6.067 ms 1 /classes/Product.php:7528
287
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2142
AND agl.`id_lang` = 3
6.042 ms 2 /classes/Product.php:7528
181
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
5.993 ms 1 /classes/module/Module.php:2636
334
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2163) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.910 ms 1 /classes/stock/StockAvailable.php:453
210
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2081
AND agl.`id_lang` = 3
5.902 ms 2 /classes/Product.php:7528
199
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 88 AND `id_shop` = 1 LIMIT 1
5.901 ms 1 /classes/module/Module.php:2109
339
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2333
AND agl.`id_lang` = 3
5.898 ms 1 /classes/Product.php:7528
296
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2123) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.867 ms 1 /classes/stock/StockAvailable.php:453
202
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2075
AND agl.`id_lang` = 3
5.819 ms 2 /classes/Product.php:7528
370
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2339) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.788 ms 1 /classes/stock/StockAvailable.php:453
237
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
5.771 ms 1 /classes/stock/StockAvailable.php:453
169
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` = 25) AND (b.`id_shop` = 1) LIMIT 1
5.740 ms 1 /src/Adapter/EntityMapper.php:71
309
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2137) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.692 ms 1 /classes/stock/StockAvailable.php:453
200
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 = "3"
AND pr.status = 1
ORDER BY pr.position
5.631 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
343
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2337
AND agl.`id_lang` = 3
5.630 ms 1 /classes/Product.php:7528
350
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2344
AND agl.`id_lang` = 3
5.629 ms 1 /classes/Product.php:7528
306
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2133) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.608 ms 1 /classes/stock/StockAvailable.php:453
388
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
5.602 ms 1 /classes/module/Module.php:2109
13
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 3) LIMIT 1
5.570 ms 1 /src/Adapter/EntityMapper.php:71
341
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2335
AND agl.`id_lang` = 3
5.562 ms 1 /classes/Product.php:7528
184
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
5.557 ms 1 /classes/module/Module.php:2109
369
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2338) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.517 ms 1 /classes/stock/StockAvailable.php:453
277
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 13
AND pac.`id_product_attribute` = 2131
AND agl.`id_lang` = 3
5.507 ms 2 /classes/Product.php:7528
347
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2341
AND agl.`id_lang` = 3
5.502 ms 1 /classes/Product.php:7528
338
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2332
AND agl.`id_lang` = 3
5.496 ms 1 /classes/Product.php:7528
230
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
5.495 ms 1 /classes/stock/StockAvailable.php:453
333
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2162) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.437 ms 1 /classes/stock/StockAvailable.php:453
231
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2077) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.427 ms 1 /classes/stock/StockAvailable.php:453
316
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2144) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.419 ms 1 /classes/stock/StockAvailable.php:453
336
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` = 3)
JOIN `ps_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;
5.415 ms 21 Yes Yes /classes/Product.php:4520
204
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2083
AND agl.`id_lang` = 3
5.410 ms 2 /classes/Product.php:7528
392
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
5.407 ms 1 /classes/module/Module.php:2109
326
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 13) AND (id_product_attribute = 2155) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.397 ms 1 /classes/stock/StockAvailable.php:453
172
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
5.395 ms 1 /classes/Country.php:405
220
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 9
AND pac.`id_product_attribute` = 2105
AND agl.`id_lang` = 3
5.385 ms 2 /classes/Product.php:7528
234
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 9) AND (id_product_attribute = 2080) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.378 ms 1 /classes/stock/StockAvailable.php:453
238
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
5.354 ms 1 /classes/stock/StockAvailable.php:453
180
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
5.305 ms 1 /classes/Country.php:405
354
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` = 3)
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` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 20
AND pac.`id_product_attribute` = 2348
AND agl.`id_lang` = 3
5.280 ms 1 /classes/Product.php:7528