"Six-petal Rosette" leather bracelet
search
  • "Six-petal Rosette" leather bracelet
  • "Six-petal Rosette" leather bracelet
  • "Six-petal Rosette" leather bracelet

"Six-petal Rosette" leather bracelet

€35.00
VAT included

Leather bracelet according to European standards (without harmful substances).

Magnetic  clasp.     

Width: 20 mm

Leather Colour: Navy blue - Petrol - Blue - Water green
Size: 1
Quantity
In Stock

  Conditons Générales de vente

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

·         Personalisation Bracelet:

The size can be personalised free of charge (Max. suggested size + 5 cm)

The personalised articles are non-echangeable and non-refundable.

Details:

Magnetic clasp in zamak

Width: 20 mm

Width rosette 25 mm

Sizes given as an indication + / - 2 millimetres

10 Items

You might also like

Comments (0)
Load Time 297.549 ms
Querying Time 194 ms
Queries 229
Memory Peak Usage 8.2 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.004 ms 0.004 ms 1.95 Mb 2.3 Mb
__construct 3.953 ms 3.957 ms - Mb 2.7 Mb
init 53.640 ms 57.597 ms 1.24 Mb 3.3 Mb
checkAccess 0.002 ms 57.599 ms - Mb 3.3 Mb
setMedia 2.895 ms 60.494 ms 0.11 Mb 3.3 Mb
postProcess 0.006 ms 60.500 ms - Mb 3.3 Mb
initHeader 0.002 ms 60.502 ms - Mb 3.3 Mb
initContent 100.376 ms 160.878 ms 1.38 Mb 4.7 Mb
initFooter 0.003 ms 160.881 ms - Mb 4.7 Mb
display 136.668 ms 297.549 ms 3.28 Mb 8.2 Mb
Hook Time Memory Usage
displayProductAdditionalInfo 18.356 ms 0.31 Mb
DisplayBeforeBodyClosingTag 17.908 ms 0.21 Mb
DisplayFooterProduct 10.597 ms 0.15 Mb
displayNav2 5.558 ms 0.19 Mb
displayTop 4.190 ms 0.16 Mb
displayFooter 2.698 ms 0.12 Mb
displayFooterBefore 2.599 ms 0.10 Mb
displayNav1 1.755 ms 0.06 Mb
DisplayReassurance 1.738 ms 0.05 Mb
displayProductListReviews 1.670 ms - Mb
displayFooterProduct 1.059 ms 0.05 Mb
DisplayHeader 1.029 ms 0.02 Mb
DisplayFooterAfter 0.907 ms 0.04 Mb
ActionFrontControllerSetMedia 0.242 ms 0.01 Mb
DisplayAfterBodyOpeningTag 0.007 ms - Mb
DisplayProductAdditionalInfo 0.006 ms - Mb
DisplayFooterBefore 0.006 ms - Mb
DisplayNavFullWidth 0.005 ms - Mb
18 hook(s) 70.330 ms 1.47 Mb
Module Time Memory Usage
ps_emailsubscription 2.685 ms 0.11 Mb
blockreassurance 2.887 ms 0.10 Mb
ps_emailalerts 0.196 ms 0.01 Mb
ps_imageslider 0.277 ms 0.01 Mb
ps_searchbar 1.465 ms 0.05 Mb
ps_shoppingcart 1.565 ms 0.05 Mb
ps_googleanalytics 3.374 ms 0.07 Mb
productcomments 27.242 ms 0.38 Mb
ps_contactinfo 3.002 ms 0.10 Mb
ps_languageselector 2.016 ms 0.05 Mb
ps_currencyselector 1.251 ms 0.06 Mb
ps_customersignin 1.306 ms 0.05 Mb
ps_mainmenu 1.438 ms 0.07 Mb
ps_linklist 6.038 ms 0.09 Mb
ps_viewedproduct 2.228 ms 0.10 Mb
psgdpr 0.321 ms 0.01 Mb
ps_socialfollow 1.531 ms 0.06 Mb
ps_customeraccountlinks 1.338 ms 0.07 Mb
statsdata 18.052 ms 0.22 Mb
19 module(s) 78.212 ms 1.67 Mb

Stopwatch SQL - 229 queries

# Query Time (ms) Rows Filesort Group By Location
228
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('638634', '', 'b-latitude.com/gb/bracelets/23-2597-six-petal-rosette-leather-bracelet.html', '', '2024-07-16 01:06:40')
9.031 ms 1 /classes/ObjectModel.php:622
88
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` = 22
ORDER BY `position`
4.889 ms 5 Yes /classes/Product.php:3545
94
SELECT SQL_NO_CACHE pa.id_product_attribute
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` = 23
4.393 ms 35 /classes/Product.php:7490
161
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2603) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.834 ms 1 /classes/stock/StockAvailable.php:453
39
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.230 ms 433 /classes/Hook.php:456
92
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
3.116 ms 8 Yes /classes/ImageType.php:109
155
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2355) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.112 ms 1 /classes/stock/StockAvailable.php:453
111
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` = 23
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
2.707 ms 35 Yes Yes /classes/Product.php:4594
91
SELECT SQL_NO_CACHE state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
2.675 ms 1 /classes/FeatureFlag.php:105
223
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')
2.674 ms 1 /classes/ObjectModel.php:622
38
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
2.624 ms 0 /classes/Hook.php:1292
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` = 23 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2.604 ms 1 Yes /classes/Product.php:4698
69
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 23
2.591 ms 35 /classes/Product.php:7557
128
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 1
2.454 ms 3 /src/Adapter/EntityMapper.php:79
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`)
2.452 ms 701 /classes/Configuration.php:180
95
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` = 23
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
AND product_attribute_shop.`id_product_attribute` = 2597 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
2.322 ms 2 Yes Yes /classes/Product.php:4594
99
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 17 LIMIT 1
2.226 ms 1 /classes/Product.php:5655
150
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` = 23) LIMIT 1
2.149 ms 1 /src/Adapter/EntityMapper.php:71
154
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 (2355,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2675)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
1.997 ms 68 /classes/Product.php:2752
129
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
1.910 ms 1 /classes/ObjectModel.php:1592
151
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 23 AND `id_shop` = 1
1.907 ms 3 /src/Adapter/EntityMapper.php:79
17
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
1.870 ms 108 Yes Yes /classes/Hook.php:1233
113
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 (2355, 2597, 2598, 2599, 2600, 2601, 2602, 2603, 2604, 2605, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2614, 2615, 2616, 2617, 2618, 2619, 2620, 2621, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2675) AND il.`id_lang` = 3 ORDER by i.`position`
1.767 ms 92 Yes /classes/Product.php:2921
65
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3  AND cl.id_shop = 1 )
WHERE `id_parent` = 17
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.757 ms 1 Yes Yes /classes/Category.php:924
156
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2598) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.680 ms 1 /classes/stock/StockAvailable.php:453
224
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 673989
AND `date_add` > '2024-07-16 00:36:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
1.626 ms 1 Yes /classes/Connection.php:168
57
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` = 23
AND pac.`id_product_attribute` = 2597
AND agl.`id_lang` = 3
1.620 ms 2 /classes/Product.php:7528
194
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 (22) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1.620 ms 10 Yes Yes /classes/Product.php:4520
110
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 (2355, 2597, 2598, 2599, 2600, 2601, 2602, 2603, 2604, 2605, 2606, 2607, 2608, 2609, 2610, 2611, 2612, 2613, 2614, 2615, 2616, 2617, 2618, 2619, 2620, 2621, 2622, 2623, 2624, 2625, 2626, 2627, 2628, 2629, 2675) AND il.`id_lang` = 3 ORDER by i.`position`
1.547 ms 92 Yes /classes/Product.php:2921
15
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
1.494 ms 934 /classes/Hook.php:1332
19
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
1.369 ms 934 /classes/Hook.php:1292
227
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('673989', '34', '65161410', '', '1', '1', '2024-07-16 01:06:40')
1.363 ms 1 /classes/ObjectModel.php:622
96
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` = 23
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
AND product_attribute_shop.`id_product_attribute` = 2597 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.320 ms 2 Yes Yes /classes/Product.php:4594
162
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2604) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.308 ms 1 /classes/stock/StockAvailable.php:453
35
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23) AND (b.`id_shop` = 1) LIMIT 1
1.275 ms 1 /src/Adapter/EntityMapper.php:71
193
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
1.261 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
195
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` = 22
AND pac.`id_product_attribute` = 3011
AND agl.`id_lang` = 3
1.252 ms 2 /classes/Product.php:7528
209
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3016) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.250 ms 1 /classes/stock/StockAvailable.php:453
84
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 22
ORDER BY f.position ASC
1.233 ms 5 Yes /classes/Product.php:6015
196
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` = 22
AND pac.`id_product_attribute` = 3014
AND agl.`id_lang` = 3
1.228 ms 2 /classes/Product.php:7528
80
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 22 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 22 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.197 ms 0 /classes/Cart.php:1423
200
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` = 22
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
1.189 ms 10 Yes /classes/Product.php:2734
198
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` = 22) LIMIT 1
1.155 ms 1 /src/Adapter/EntityMapper.php:71
98
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 23
AND image_shop.`cover` = 1 LIMIT 1
1.152 ms 27 /classes/Product.php:3570
44
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 = 23 LIMIT 1
1.148 ms 35 /classes/Product.php:1106
40
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 11
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
1.145 ms 1 /classes/tax/TaxRulesTaxManager.php:109
90
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 (3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3018) AND il.`id_lang` = 3 ORDER by i.`position`
1.117 ms 23 Yes /classes/Product.php:2921
153
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` = 23
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
1.106 ms 35 Yes /classes/Product.php:2734
97
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` = 23
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
AND product_attribute_shop.`id_product_attribute` = 2597 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.098 ms 2 Yes Yes /classes/Product.php:4594
197
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` = 22
AND pac.`id_product_attribute` = 3018
AND agl.`id_lang` = 3
1.084 ms 1 /classes/Product.php:7528
75
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22) AND (b.`id_shop` = 1) LIMIT 1
1.013 ms 1 /src/Adapter/EntityMapper.php:71
59
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 17) AND (b.`id_shop` = 1) LIMIT 1
1.006 ms 1 /src/Adapter/EntityMapper.php:71
201
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 (3008,3009,3010,3011,3012,3013,3014,3015,3016,3018)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
1.005 ms 19 /classes/Product.php:2752
73
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 22
AND image_shop.`cover` = 1 LIMIT 1
0.978 ms 5 /classes/Product.php:3570
85
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` = 22
AND pac.`id_product_attribute` = 3008
AND agl.`id_lang` = 3
0.968 ms 2 /classes/Product.php:7528
82
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 3008
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 22 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 3008
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 22 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.893 ms 0 /classes/Cart.php:1423
46
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 23)
0.882 ms 35 /classes/Product.php:3860
226
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 23 LIMIT 1
0.868 ms 1 /classes/Page.php:83
107
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` = 23
AND pa.`id_product_attribute` = 2597
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.861 ms 2 Yes /classes/Product.php:2862
108
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` = 23
ORDER BY `position`
0.845 ms 27 Yes /classes/Product.php:3545
120
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` = 23
AND pa.`id_product_attribute` = 2597
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.806 ms 2 Yes /classes/Product.php:2862
49
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.797 ms 1 /classes/stock/StockAvailable.php:453
211
SELECT SQL_NO_CACHE al.`name` AS attribute_name
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
)
WHERE pac.`id_product_attribute` = 2597
ORDER BY ag.`position` ASC, a.`position` ASC
0.795 ms 2 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:241
66
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`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 `id_lang` = 3
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.785 ms 14 Yes Yes /classes/Category.php:1151
60
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.783 ms 86 /classes/module/Module.php:345
130
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 19) AND (a0.`nright` > 20) AND (a1.`id_lang` = 3) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
0.782 ms 14 Yes /classes/PrestaShopCollection.php:383
16
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.780 ms 41 Yes /classes/Dispatcher.php:654
101
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 23 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 23 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.780 ms 0 /classes/Cart.php:1423
212
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 (23) AND cl.`id_lang` = 3
ORDER BY c.`level_depth` DESC
0.729 ms 2 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
48
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=23
0.718 ms 1 /classes/Tag.php:244
121
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.715 ms 1 /src/Adapter/EntityMapper.php:71
56
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute_lang`
WHERE `id_product_attribute` = 2597
0.709 ms 3 /src/Adapter/EntityMapper.php:79
123
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.689 ms 1 /src/Adapter/EntityMapper.php:71
225
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
0.680 ms 1 /classes/Page.php:104
54
SELECT SQL_NO_CACHE pa.id_product_attribute
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` = 23
0.675 ms 35 /classes/Product.php:7490
181
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2623) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.666 ms 1 /classes/stock/StockAvailable.php:453
18
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
0.665 ms 88 /classes/Hook.php:287
45
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 product_attribute_shop.default_on = 1  AND pa.id_product = 23 LIMIT 1
0.656 ms 35 /classes/Product.php:1121
103
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 2597
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 23 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 2597
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 23 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.651 ms 0 /classes/Cart.php:1423
67
SELECT SQL_NO_CACHE pa.id_product_attribute
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` = 23
0.642 ms 35 /classes/Product.php:7490
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` = 2597) LIMIT 1
0.640 ms 1 /src/Adapter/EntityMapper.php:71
1
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.638 ms 1 Yes /classes/shop/Shop.php:715
199
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 22 AND `id_shop` = 1
0.622 ms 3 /src/Adapter/EntityMapper.php:79
171
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2613) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.621 ms 1 /classes/stock/StockAvailable.php:453
81
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3008) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.607 ms 1 /classes/stock/StockAvailable.php:453
87
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute_lang`
WHERE `id_product_attribute` = 3008
0.605 ms 3 /src/Adapter/EntityMapper.php:79
61
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
0.600 ms 88 /classes/Hook.php:339
148
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
0.597 ms 1 /classes/module/Module.php:2636
83
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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 p.`id_product` = 22 AND pa.`id_product` = 22 AND pa.`id_product_attribute` = 3008 LIMIT 1
0.596 ms 1 /classes/Product.php:1209
119
SELECT SQL_NO_CACHE pa.id_product_attribute
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` = 23
0.592 ms 35 /classes/Product.php:7490
173
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2615) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.566 ms 1 /classes/stock/StockAvailable.php:453
28
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 3
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.564 ms 1 /src/Adapter/EntityMapper.php:71
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
0.564 ms 1 /src/Adapter/EntityMapper.php:71
53
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 17 LIMIT 1
0.563 ms 1 /classes/Category.php:1378
86
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` = 3008) LIMIT 1
0.559 ms 1 /src/Adapter/EntityMapper.php:71
188
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2675) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.556 ms 1 /classes/stock/StockAvailable.php:453
157
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2599) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.550 ms 1 /classes/stock/StockAvailable.php:453
71
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 = 22 LIMIT 1
0.547 ms 10 /classes/Product.php:1106
77
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
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 (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 22)
0.536 ms 10 /classes/Product.php:3860
29
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.534 ms 1 /src/Adapter/EntityMapper.php:71
152
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` = 17 LIMIT 1
0.531 ms 0 /classes/Category.php:1378
0
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'b-latitude.com' OR su.domain_ssl = 'b-latitude.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.529 ms 1 Yes /classes/shop/Shop.php:1364
127
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
0.528 ms 1 /src/Adapter/EntityMapper.php:71
172
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2614) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.525 ms 1 /classes/stock/StockAvailable.php:453
8
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` = 1) LIMIT 1
0.524 ms 1 /src/Adapter/EntityMapper.php:71
142
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
0.523 ms 1 /classes/module/Module.php:2636
41
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 10) LIMIT 1
0.521 ms 1 /src/Adapter/EntityMapper.php:71
51
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.518 ms 1 /classes/stock/StockAvailable.php:753
158
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2600) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.515 ms 1 /classes/stock/StockAvailable.php:453
36
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
0.514 ms 0 /classes/Manufacturer.php:316
42
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 10
0.510 ms 3 /src/Adapter/EntityMapper.php:79
222
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
0.509 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
105
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 23
ORDER BY f.position ASC
0.503 ms 5 Yes /classes/Product.php:6015
12
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'gb' LIMIT 1
0.502 ms 3 /classes/Language.php:854
76
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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_attribute` = 3008 LIMIT 1
0.498 ms 1 /classes/Combination.php:564
115
SELECT SQL_NO_CACHE pac2.`id_attribute` FROM `ps_product_attribute_combination` pac2 WHERE pac2.`id_product_attribute` IN (0,2597,2598,2599)
AND pac2.id_attribute NOT IN (117)
0.498 ms 8 /controllers/front/ProductController.php:783
174
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2616) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.497 ms 1 /classes/stock/StockAvailable.php:453
114
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 = 23 AND id_attribute IN (117)
GROUP BY id_product_attribute
HAVING COUNT(id_product) = 1
0.495 ms 3 /controllers/front/ProductController.php:772
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.494 ms 1 /classes/shop/ShopUrl.php:182
187
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2629) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.488 ms 1 /classes/stock/StockAvailable.php:453
25
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 3
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.487 ms 1 /src/Adapter/EntityMapper.php:71
30
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
0.485 ms 3 /src/Adapter/EntityMapper.php:79
180
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2622) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.482 ms 1 /classes/stock/StockAvailable.php:453
21
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.481 ms 1 Yes /classes/Currency.php:709
72
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 product_attribute_shop.default_on = 1  AND pa.id_product = 22 LIMIT 1
0.479 ms 10 /classes/Product.php:1121
37
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.475 ms 0 /classes/Supplier.php:243
62
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.475 ms 0 /classes/tax/TaxRulesTaxManager.php:109
6
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
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
0.473 ms 1 /src/Adapter/EntityMapper.php:71
89
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 22
0.473 ms 10 /classes/Product.php:2902
4
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.472 ms 1 /classes/shop/Shop.php:218
210
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3018) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.471 ms 1 /classes/stock/StockAvailable.php:453
32
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.471 ms 1 /src/Adapter/EntityMapper.php:71
100
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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_attribute` = 2597 LIMIT 1
0.470 ms 1 /classes/Combination.php:564
79
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.468 ms 1 /classes/stock/StockAvailable.php:453
64
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 17
AND id_shop = 1 LIMIT 1
0.467 ms 1 /classes/ObjectModel.php:1729
78
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 22 AND id_shop=1 LIMIT 1
0.466 ms 1 /classes/Product.php:6870
106
SELECT SQL_NO_CACHE pa.id_product_attribute
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` = 23
0.465 ms 35 /classes/Product.php:7490
143
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 24 AND `id_shop` = 1 LIMIT 1
0.464 ms 1 /classes/module/Module.php:2109
93
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.460 ms 8 /classes/ImageType.php:161
5
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.458 ms 3 /classes/Language.php:1080
14
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 3
AND id_shop = 1 LIMIT 1
0.453 ms 1 /classes/ObjectModel.php:1729
52
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.453 ms 1 /classes/stock/StockAvailable.php:806
63
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
0.452 ms 1 /classes/Category.php:1974
185
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2627) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.451 ms 1 /classes/stock/StockAvailable.php:453
202
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3009) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.450 ms 1 /classes/stock/StockAvailable.php:453
31
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.446 ms 1 /classes/ObjectModel.php:1729
7
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.445 ms 1 /src/Adapter/EntityMapper.php:71
11
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.445 ms 9 /classes/Language.php:1216
191
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_viewedproduct" LIMIT 1
0.445 ms 1 /classes/module/Module.php:2636
218
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
0.445 ms 1 /classes/module/Module.php:2109
58
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 23
AND id_shop = 1 LIMIT 1
0.440 ms 1 /classes/ObjectModel.php:1729
9
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.438 ms 1 /classes/ObjectModel.php:1729
24
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.438 ms 1 /classes/Currency.php:893
182
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2624) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.437 ms 1 /classes/stock/StockAvailable.php:453
206
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3013) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.434 ms 1 /classes/stock/StockAvailable.php:453
192
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 88 AND `id_shop` = 1 LIMIT 1
0.433 ms 1 /classes/module/Module.php:2109
189
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
0.432 ms 1 /classes/module/Module.php:2636
117
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.431 ms 1 /classes/module/Module.php:2636
184
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2626) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.431 ms 1 /classes/stock/StockAvailable.php:453
109
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 23
0.429 ms 35 /classes/Product.php:2902
149
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 20 AND `id_shop` = 1 LIMIT 1
0.429 ms 1 /classes/module/Module.php:2109
74
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 17 LIMIT 1
0.429 ms 1 /classes/Product.php:5655
190
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 94 AND `id_shop` = 1 LIMIT 1
0.428 ms 1 /classes/module/Module.php:2109
170
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2612) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.427 ms 1 /classes/stock/StockAvailable.php:453
27
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.426 ms 1 /classes/Country.php:194
20
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.421 ms 1 /classes/module/Module.php:2018
116
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.419 ms 1 /classes/Cart.php:4210
183
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2625) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.416 ms 1 /classes/stock/StockAvailable.php:453
132
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
0.416 ms 1 /classes/module/Module.php:2636
178
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2620) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.415 ms 1 /classes/stock/StockAvailable.php:453
131
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 10 LIMIT 1
0.415 ms 1 /classes/Hook.php:244
23
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.413 ms 1 /classes/shop/Shop.php:1183
126
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
0.412 ms 1 /classes/Country.php:405
141
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 13 AND `id_shop` = 1 LIMIT 1
0.407 ms 1 /classes/module/Module.php:2109
135
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
0.405 ms 1 /classes/module/Module.php:2636
207
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3014) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.405 ms 1 /classes/stock/StockAvailable.php:453
144
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.404 ms 1 /classes/module/Module.php:2636
102
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2597) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.402 ms 1 /classes/stock/StockAvailable.php:453
33
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.401 ms 3 /src/Adapter/EntityMapper.php:79
179
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2621) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.400 ms 1 /classes/stock/StockAvailable.php:453
159
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2601) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.399 ms 1 /classes/stock/StockAvailable.php:453
136
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 19 AND `id_shop` = 1 LIMIT 1
0.397 ms 1 /classes/module/Module.php:2109
47
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 23 AND id_shop=1 LIMIT 1
0.395 ms 1 /classes/Product.php:6870
205
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3012) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.394 ms 1 /classes/stock/StockAvailable.php:453
204
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3011) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.393 ms 1 /classes/stock/StockAvailable.php:453
104
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) 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 p.`id_product` = 23 AND pa.`id_product` = 23 AND pa.`id_product_attribute` = 2597 LIMIT 1
0.392 ms 1 /classes/Product.php:1209
118
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
0.392 ms 0 /classes/module/Module.php:2109
216
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
0.391 ms 1 /classes/module/Module.php:2109
186
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2628) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.388 ms 1 /classes/stock/StockAvailable.php:453
217
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
0.388 ms 1 /classes/module/Module.php:2636
160
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2602) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.386 ms 1 /classes/stock/StockAvailable.php:453
169
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2611) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.383 ms 1 /classes/stock/StockAvailable.php:453
133
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
0.382 ms 1 /classes/module/Module.php:2109
140
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1
0.382 ms 1 /classes/module/Module.php:2636
176
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2618) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.378 ms 1 /classes/stock/StockAvailable.php:453
219
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
0.378 ms 1 /classes/module/Module.php:2636
166
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2608) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.375 ms 1 /classes/stock/StockAvailable.php:453
203
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 22) AND (id_product_attribute = 3010) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.375 ms 1 /classes/stock/StockAvailable.php:453
134
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
0.372 ms 1 /classes/Country.php:405
145
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
0.372 ms 1 /classes/module/Module.php:2109
175
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2617) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.370 ms 1 /classes/stock/StockAvailable.php:453
125
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 1 LIMIT 1
0.367 ms 1 /classes/AddressFormat.php:656
164
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2606) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.366 ms 1 /classes/stock/StockAvailable.php:453
163
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2605) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.365 ms 1 /classes/stock/StockAvailable.php:453
43
SELECT SQL_NO_CACHE COUNT(p.id_product)
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 23
AND DATEDIFF("2024-07-16 00:00:00", product_shop.`date_add`) < 0 LIMIT 1
0.362 ms 0 /classes/Product.php:1732
221
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
0.362 ms 1 /classes/Country.php:405
112
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 23
0.360 ms 35 /classes/Product.php:2902
139
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.359 ms 1 /classes/Currency.php:1136
177
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2619) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.357 ms 1 /classes/stock/StockAvailable.php:453
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.352 ms 1 /src/Adapter/EntityMapper.php:71
165
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 2607) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.352 ms 1 /classes/stock/StockAvailable.php:453