Pendant "Boule" Murano glas beads
search
  • Pendant "Boule" Murano glas beads

Pendant "Boule" Murano glas beads

€9.90
VAT included

The pendants can be worn individually, in pairs or three at a time on stainless steel chains.

The pendants "Boule" can be combined with the stainless steel pendants: "Feather", "Tree of life", "Paw print".

Beads colours: Rose
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:

Diameter of the pearl 10 mm approx.

Weight: 3 gramms

All the beads are made one by one by hand which gives them a uniqueness a slight variation in color is possible.

10 Items

You might also like

Comments (0)
Load Time 1024 ms
Querying Time 822 ms
Queries 381
Memory Peak Usage 11.4 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.009 ms 0.009 ms 1.95 Mb 2.3 Mb
__construct 6.619 ms 6.628 ms - Mb 2.7 Mb
init 90.610 ms 97.238 ms 1.23 Mb 3.3 Mb
checkAccess 0.002 ms 97.240 ms - Mb 3.3 Mb
setMedia 3.558 ms 100.798 ms 0.11 Mb 3.3 Mb
postProcess 0.006 ms 100.804 ms - Mb 3.3 Mb
initHeader 0.001 ms 100.805 ms - Mb 3.3 Mb
initContent 225.376 ms 326.181 ms 1.97 Mb 5.3 Mb
initFooter 0.002 ms 326.183 ms - Mb 5.3 Mb
display 697.619 ms 1024 ms 5.93 Mb 11.4 Mb
Hook Time Memory Usage
displayProductAdditionalInfo 31.760 ms 0.31 Mb
DisplayBeforeBodyClosingTag 31.101 ms 0.22 Mb
DisplayFooterProduct 21.101 ms 0.15 Mb
displayFooterBefore 14.461 ms 0.10 Mb
displayTop 12.827 ms 0.16 Mb
displayNav1 11.955 ms 0.06 Mb
displayFooter 10.421 ms 0.12 Mb
displayNav2 7.734 ms 0.19 Mb
displayProductListReviews 6.879 ms 0.01 Mb
displayFooterProduct 6.510 ms 0.05 Mb
DisplayFooterAfter 5.244 ms 0.04 Mb
DisplayReassurance 5.133 ms 0.05 Mb
DisplayHeader 1.251 ms 0.02 Mb
ActionFrontControllerSetMedia 0.320 ms 0.01 Mb
DisplayProductAdditionalInfo 0.015 ms - Mb
DisplayNavFullWidth 0.010 ms - Mb
DisplayFooterBefore 0.008 ms - Mb
DisplayAfterBodyOpeningTag 0.007 ms - Mb
18 hook(s) 166.737 ms 1.49 Mb
Module Time Memory Usage
ps_emailsubscription 8.777 ms 0.11 Mb
blockreassurance 10.632 ms 0.10 Mb
ps_emailalerts 0.454 ms 0.01 Mb
ps_imageslider 0.303 ms 0.01 Mb
ps_searchbar 2.107 ms 0.05 Mb
ps_shoppingcart 1.826 ms 0.05 Mb
ps_googleanalytics 10.110 ms 0.07 Mb
productcomments 45.596 ms 0.39 Mb
ps_contactinfo 15.364 ms 0.10 Mb
ps_languageselector 2.884 ms 0.05 Mb
ps_currencyselector 1.731 ms 0.06 Mb
ps_customersignin 2.008 ms 0.05 Mb
ps_mainmenu 2.869 ms 0.07 Mb
ps_linklist 19.886 ms 0.09 Mb
ps_viewedproduct 12.006 ms 0.10 Mb
psgdpr 0.909 ms 0.01 Mb
ps_socialfollow 7.890 ms 0.06 Mb
ps_customeraccountlinks 6.644 ms 0.07 Mb
statsdata 31.284 ms 0.22 Mb
19 module(s) 183.280 ms 1.68 Mb

Stopwatch SQL - 381 queries

# Query Time (ms) Rows Filesort Group By Location
302
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` = 42
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
7.594 ms 18 Yes /classes/Product.php:2734
380
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('638805', '', 'b-latitude.com/gb/pendants/40-2793-boucles-d-oreille-galet.html', '', '2024-07-16 02:47:42')
7.290 ms 1 /classes/ObjectModel.php:622
269
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
6.052 ms 21 /classes/Product.php:2752
55
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 2793) LIMIT 1
5.959 ms 1 /src/Adapter/EntityMapper.php:71
190
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 1) LIMIT 1
5.897 ms 1 /src/Adapter/EntityMapper.php:71
376
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 674162
AND `date_add` > '2024-07-16 02:17:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
5.545 ms 1 Yes /classes/Connection.php:168
315
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2902) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.372 ms 1 /classes/stock/StockAvailable.php:453
335
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 (2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
5.314 ms 55 /classes/Product.php:2752
303
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 (2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
5.151 ms 36 /classes/Product.php:2752
174
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` = 3)
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` = 40
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
5.059 ms 22 Yes Yes /classes/Product.php:4594
191
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 1
5.030 ms 3 /src/Adapter/EntityMapper.php:79
189
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
4.958 ms 1 /classes/Country.php:405
287
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
4.822 ms 1 /classes/stock/StockAvailable.php:453
196
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
4.795 ms 1 /classes/module/Module.php:2109
171
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` = 40
ORDER BY `position`
4.779 ms 22 Yes /classes/Product.php:3545
264
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` = 2350
AND agl.`id_lang` = 3
4.761 ms 1 /classes/Product.php:7528
288
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
4.733 ms 1 /classes/stock/StockAvailable.php:453
364
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 (40) AND cl.`id_lang` = 3
ORDER BY c.`level_depth` DESC
4.726 ms 2 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
379
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('674162', '41', '65161410', '', '1', '1', '2024-07-16 02:47:42')
4.699 ms 1 /classes/ObjectModel.php:622
243
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
4.641 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
217
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 (2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
4.586 ms 22 /classes/Product.php:2752
218
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2777) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.547 ms 1 /classes/stock/StockAvailable.php:453
330
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` = 43
AND pac.`id_product_attribute` = 2841
AND agl.`id_lang` = 3
4.537 ms 2 /classes/Product.php:7528
374
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
4.514 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
70
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` = 3 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 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` = 3)
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` = 40 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
4.506 ms 4 Yes /classes/Product.php:4698
328
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` = 43
AND pac.`id_product_attribute` = 2835
AND agl.`id_lang` = 3
4.479 ms 2 /classes/Product.php:7528
290
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 (41) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.408 ms 3 Yes Yes /classes/Product.php:4520
175
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 40
4.378 ms 22 /classes/Product.php:2902
361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2843) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.370 ms 1 /classes/stock/StockAvailable.php:453
251
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
4.352 ms 1 /classes/Product.php:7528
261
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` = 2347
AND agl.`id_lang` = 3
4.349 ms 1 /classes/Product.php:7528
321
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 (43) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.344 ms 28 Yes Yes /classes/Product.php:4520
322
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` = 43
AND pac.`id_product_attribute` = 2817
AND agl.`id_lang` = 3
4.296 ms 2 /classes/Product.php:7528
234
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2794) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.283 ms 1 /classes/stock/StockAvailable.php:453
181
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
4.278 ms 0 /classes/module/Module.php:2109
248
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
4.276 ms 1 /classes/Product.php:7528
177
SELECT SQL_NO_CACHE pac.`id_product_attribute`
FROM `ps_product_attribute_combination` pac
INNER JOIN `ps_product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
WHERE id_product = 40 AND id_attribute IN (24)
GROUP BY id_product_attribute
HAVING COUNT(id_product) = 1
4.266 ms 22 /controllers/front/ProductController.php:772
216
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` = 40
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
4.237 ms 22 Yes /classes/Product.php:2734
222
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2781) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.186 ms 1 /classes/stock/StockAvailable.php:453
214
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 40 AND `id_shop` = 1
4.185 ms 3 /src/Adapter/EntityMapper.php:79
211
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
4.151 ms 1 /classes/module/Module.php:2636
305
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2891) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.096 ms 1 /classes/stock/StockAvailable.php:453
273
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
4.088 ms 1 /classes/stock/StockAvailable.php:453
319
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2906) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.083 ms 1 /classes/stock/StockAvailable.php:453
259
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
4.071 ms 1 /classes/Product.php:7528
193
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 21) AND (a0.`nright` > 22) AND (a1.`id_lang` = 3) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
4.014 ms 4 Yes /classes/PrestaShopCollection.php:383
253
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` = 2339
AND agl.`id_lang` = 3
3.949 ms 1 /classes/Product.php:7528
318
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2905) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.943 ms 1 /classes/stock/StockAvailable.php:453
194
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 10 LIMIT 1
3.891 ms 1 /classes/Hook.php:244
260
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` = 2346
AND agl.`id_lang` = 3
3.889 ms 1 /classes/Product.php:7528
378
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 40 LIMIT 1
3.882 ms 1 /classes/Page.php:83
266
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 20 AND `id_shop` = 1
3.874 ms 3 /src/Adapter/EntityMapper.php:79
294
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` = 41
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
3.837 ms 3 Yes Yes /classes/Product.php:2734
184
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 40) AND (b.`id_shop` = 1) LIMIT 1
3.818 ms 1 /src/Adapter/EntityMapper.php:71
352
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2834) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.803 ms 1 /classes/stock/StockAvailable.php:453
262
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
3.792 ms 1 /classes/Product.php:7528
173
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 (2777, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2785, 2786, 2787, 2788, 2789, 2790, 2791, 2792, 2793, 2794, 2795, 2796, 2797, 2798) AND il.`id_lang` = 3 ORDER by i.`position`
3.783 ms 22 Yes /classes/Product.php:2921
231
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2790) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.767 ms 1 /classes/stock/StockAvailable.php:453
334
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` = 43
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
3.750 ms 28 Yes /classes/Product.php:2734
327
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` = 43
AND pac.`id_product_attribute` = 2832
AND agl.`id_lang` = 3
3.718 ms 2 /classes/Product.php:7528
359
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2841) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.691 ms 1 /classes/stock/StockAvailable.php:453
348
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2830) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.649 ms 1 /classes/stock/StockAvailable.php:453
316
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2903) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.640 ms 1 /classes/stock/StockAvailable.php:453
240
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 94 AND `id_shop` = 1 LIMIT 1
3.637 ms 1 /classes/module/Module.php:2109
375
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
3.637 ms 1 /classes/ObjectModel.php:622
230
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2789) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.636 ms 1 /classes/stock/StockAvailable.php:453
344
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2826) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.634 ms 1 /classes/stock/StockAvailable.php:453
367
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
3.631 ms 1 /classes/module/Module.php:2636
227
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2786) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.625 ms 1 /classes/stock/StockAvailable.php:453
295
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 (2845,2846,2847)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
3.598 ms 3 /classes/Product.php:2752
228
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2787) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.584 ms 1 /classes/stock/StockAvailable.php:453
300
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 42 AND `id_shop` = 1
3.584 ms 3 /src/Adapter/EntityMapper.php:79
192
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
3.583 ms 1 /classes/ObjectModel.php:1592
195
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
3.578 ms 1 /classes/module/Module.php:2636
370
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
3.540 ms 1 /classes/module/Module.php:2109
178
SELECT SQL_NO_CACHE pac2.`id_attribute` FROM `ps_product_attribute_combination` pac2 WHERE pac2.`id_product_attribute` IN (0,2793)
AND pac2.id_attribute NOT IN (24)
3.539 ms 4 /controllers/front/ProductController.php:783
353
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2835) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.538 ms 1 /classes/stock/StockAvailable.php:453
354
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2836) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.537 ms 1 /classes/stock/StockAvailable.php:453
355
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2837) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.524 ms 1 /classes/stock/StockAvailable.php:453
293
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
3.523 ms 0 /classes/Category.php:1378
313
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2900) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.520 ms 1 /classes/stock/StockAvailable.php:453
180
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
3.510 ms 1 /classes/module/Module.php:2636
226
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2785) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.496 ms 1 /classes/stock/StockAvailable.php:453
366
SELECT SQL_NO_CACHE p.id_product
FROM ps_product p
WHERE p.active = 1
3.493 ms 31 /modules/ps_viewedproduct/ps_viewedproduct.php:317
298
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 (42) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3.488 ms 18 Yes Yes /classes/Product.php:4520
356
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2838) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.484 ms 1 /classes/stock/StockAvailable.php:453
238
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2798) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.481 ms 1 /classes/stock/StockAvailable.php:453
257
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` = 2343
AND agl.`id_lang` = 3
3.472 ms 1 /classes/Product.php:7528
372
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 12 AND `id_shop` = 1 LIMIT 1
3.470 ms 1 /classes/module/Module.php:2109
347
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2829) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.468 ms 1 /classes/stock/StockAvailable.php:453
215
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 20 LIMIT 1
3.456 ms 0 /classes/Category.php:1378
358
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2840) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.452 ms 1 /classes/stock/StockAvailable.php:453
338
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2820) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.449 ms 1 /classes/stock/StockAvailable.php:453
336
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2817) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.440 ms 1 /classes/stock/StockAvailable.php:453
176
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 (2777, 2778, 2779, 2780, 2781, 2782, 2783, 2784, 2785, 2786, 2787, 2788, 2789, 2790, 2791, 2792, 2793, 2794, 2795, 2796, 2797, 2798) AND il.`id_lang` = 3 ORDER by i.`position`
3.433 ms 22 Yes /classes/Product.php:2921
308
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2894) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.419 ms 1 /classes/stock/StockAvailable.php:453
341
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2823) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.411 ms 1 /classes/stock/StockAvailable.php:453
357
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2839) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.407 ms 1 /classes/stock/StockAvailable.php:453
351
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 43) AND (id_product_attribute = 2833) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.395 ms 1 /classes/stock/StockAvailable.php:453
325
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` = 43
AND pac.`id_product_attribute` = 2826
AND agl.`id_lang` = 3
3.392 ms 2 /classes/Product.php:7528
284
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2345) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.392 ms 1 /classes/stock/StockAvailable.php:453
170
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
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_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` 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 pa.`id_product` = 40
AND pa.`id_product_attribute` = 2793
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
3.386 ms 1 Yes /classes/Product.php:2862
224
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2783) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.381 ms 1 /classes/stock/StockAvailable.php:453
15
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
3.372 ms 934 /classes/Hook.php:1332
276
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2337) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.364 ms 1 /classes/stock/StockAvailable.php:453
281
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
3.352 ms 1 /classes/stock/StockAvailable.php:453
312
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 42) AND (id_product_attribute = 2899) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.339 ms 1 /classes/stock/StockAvailable.php:453
299
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` = 42) LIMIT 1
3.338 ms 1 /src/Adapter/EntityMapper.php:71
272
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2333) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.336 ms 1 /classes/stock/StockAvailable.php:453
254
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
3.322 ms 1 /classes/Product.php:7528
369
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
3.322 ms 1 /classes/module/Module.php:2636
229
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 40) AND (id_product_attribute = 2788) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.314 ms 1 /classes/stock/StockAvailable.php:453
285
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 20) AND (id_product_attribute = 2346) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.310 ms 1 /classes/stock/StockAvailable.php:453
245
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` = 2331
AND agl.`id_lang` = 3
3.304 ms 1 /classes/Product.php:7528
333
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 43 AND `id_shop` = 1
3.303 ms 3 /src/Adapter/EntityMapper.php:79
267
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 16 LIMIT 1
3.286 ms 0 /classes/Category.php:1378