Bracelet "Navy" tressé
search
  • Bracelet "Navy" tressé
  • Bracelet "Navy" tressé
  • Bracelet "Navy" tressé
  • Bracelet "Navy" tressé

Bracelet "Navy" tressé

22,00 €
TTC

Elégant bracelet "Navy" tressé.

Fermoir aimanté en acier inoxydable, finition mate

Unisexe

Taille : 17 cm
Quantité
Disponible

  Conditons Générales de vente

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

·         Personnalisation

Taille personnalisable à la demande (max taille proposées + 5 cm).Les bracelets sont personnalisés gratuitement. Les articles personnalisés ne sont pas échangeables ni remboursables.

Détails:

tressage en coton très résistant.

Fermoir aimanté en acier inoxydable mat.

Diamètre: 6 mm.

Unisexe

10 Produits

Vous aimerez aussi

Commentaires (0)
Load Time 495.659 ms
Querying Time 450 ms
Queries 290
Memory Peak Usage 10.4 Mb
Included Files 966 files - 10.65 Mb
PrestaShop Cache - Mb
Global vars 0.15 Mb
PrestaShop Version 8.1.5
PHP Version 8.1.29
MySQL Version 10.11.6-MariaDB-0+deb12u1
Memory Limit 256M
Max Execution Time 120s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0.003 ms 0.003 ms 1.94 Mb 2.3 Mb
__construct 1.746 ms 1.749 ms - Mb 2.7 Mb
init 44.473 ms 46.222 ms 1.19 Mb 3.2 Mb
checkAccess 0.002 ms 46.224 ms - Mb 3.2 Mb
setMedia 2.499 ms 48.723 ms 0.11 Mb 3.3 Mb
postProcess 0.004 ms 48.727 ms - Mb 3.3 Mb
initHeader 0.001 ms 48.728 ms - Mb 3.3 Mb
initContent 122.969 ms 171.697 ms 1.32 Mb 4.6 Mb
initFooter 0.002 ms 171.699 ms - Mb 4.6 Mb
display 323.960 ms 495.659 ms 5.61 Mb 10.4 Mb
Hook Time Memory Usage
displayProductAdditionalInfo 23.514 ms 0.31 Mb
DisplayBeforeBodyClosingTag 19.494 ms 0.21 Mb
displayNav2 10.993 ms 0.19 Mb
displayTop 10.792 ms 0.15 Mb
DisplayFooterProduct 9.994 ms 0.17 Mb
displayFooterBefore 6.285 ms 0.10 Mb
displayNav1 6.034 ms 0.07 Mb
DisplayFooterAfter 3.934 ms 0.04 Mb
displayFooter 3.642 ms 0.11 Mb
DisplayReassurance 2.677 ms 0.05 Mb
displayProductListReviews 1.411 ms - Mb
displayFooterProduct 1.185 ms 0.05 Mb
DisplayHeader 1.112 ms 0.02 Mb
ActionFrontControllerSetMedia 0.207 ms 0.01 Mb
DisplayNavFullWidth 0.010 ms - Mb
DisplayAfterBodyOpeningTag 0.007 ms - Mb
DisplayProductAdditionalInfo 0.005 ms - Mb
DisplayFooterBefore 0.005 ms - Mb
18 hook(s) 101.301 ms 1.48 Mb
Module Time Memory Usage
ps_emailsubscription 6.492 ms 0.11 Mb
blockreassurance 6.829 ms 0.10 Mb
ps_emailalerts 0.217 ms 0.01 Mb
ps_imageslider 0.293 ms 0.01 Mb
ps_searchbar 2.714 ms 0.05 Mb
ps_shoppingcart 1.250 ms 0.05 Mb
ps_googleanalytics 3.564 ms 0.07 Mb
productcomments 26.188 ms 0.40 Mb
ps_contactinfo 7.891 ms 0.10 Mb
ps_languageselector 1.943 ms 0.05 Mb
ps_currencyselector 7.073 ms 0.06 Mb
ps_customersignin 1.334 ms 0.05 Mb
ps_mainmenu 6.129 ms 0.07 Mb
ps_linklist 4.496 ms 0.08 Mb
ps_viewedproduct 7.590 ms 0.10 Mb
psgdpr 0.382 ms 0.03 Mb
ps_socialfollow 1.293 ms 0.06 Mb
ps_customeraccountlinks 1.554 ms 0.07 Mb
statsdata 19.600 ms 0.22 Mb
19 module(s) 106.833 ms 1.69 Mb

Stopwatch SQL - 290 queries

# Query Time (ms) Rows Filesort Group By Location
13
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
6.628 ms 934 /classes/Hook.php:1332
15
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
6.376 ms 108 Yes Yes /classes/Hook.php:1233
161
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (18) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
6.195 ms 96 Yes Yes /classes/Product.php:4520
105
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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 21
AND pa.`id_product_attribute` = 3002
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
6.006 ms 1 Yes /classes/Product.php:2862
155
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21) AND (id_product_attribute = 3007) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.774 ms 1 /classes/stock/StockAvailable.php:453
108
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 (3002, 3003, 3004, 3005, 3006, 3007) AND il.`id_lang` = 1 ORDER by i.`position`
5.423 ms 24 Yes /classes/Product.php:2921
17
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
5.415 ms 934 /classes/Hook.php:1292
146
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` = 21) LIMIT 1
5.324 ms 1 /src/Adapter/EntityMapper.php:71
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`)
5.111 ms 701 /classes/Configuration.php:180
176
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2445,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
5.100 ms 192 /classes/Product.php:2752
289
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('638770', '', 'b-latitude.com/fr/bracelets/21-bracelet-navy-tresse.html', '', '2024-07-16 02:30:34')
4.750 ms 1 /classes/ObjectModel.php:622
106
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` = 1)
WHERE i.`id_product` = 21
ORDER BY `position`
4.720 ms 4 Yes /classes/Product.php:3545
65
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-07-16 00:00:00",
INTERVAL 0 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 21 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
4.716 ms 1 Yes /classes/Product.php:4698
159
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 88 AND `id_shop` = 1 LIMIT 1
4.611 ms 1 /classes/module/Module.php:2109
246
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2435) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
4.181 ms 1 /classes/stock/StockAvailable.php:453
14
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
4.164 ms 41 Yes /classes/Dispatcher.php:654
142
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_mainmenu" LIMIT 1
4.013 ms 1 /classes/module/Module.php:2636
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
3.975 ms 1 /src/Adapter/EntityMapper.php:71
85
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 (2365, 2366, 2367, 2368, 2369, 2370, 2371, 2372, 2373, 2374, 2375, 2376, 2377, 2378, 2379, 2380, 2381, 2382, 2383, 2384, 2385, 2386, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2394, 2395, 2396, 2397, 2398, 2399, 2400, 2401, 2402, 2403, 2404, 2405, 2406, 2407, 2408, 2409, 2410, 2411, 2412, 2413, 2414, 2415, 2416, 2417, 2418, 2419, 2420, 2421, 2422, 2423, 2424, 2425, 2426, 2427, 2428, 2429, 2430, 2431, 2432, 2433, 2434, 2435, 2436, 2437, 2438, 2439, 2440, 2441, 2442, 2443, 2444, 2445, 2446, 2447, 2448, 2449, 2450, 2451, 2452, 2453, 2454, 2455, 2456, 2457, 2458, 2459, 2460) AND il.`id_lang` = 1 ORDER by i.`position`
3.960 ms 96 Yes /classes/Product.php:2921
189
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2378) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.808 ms 1 /classes/stock/StockAvailable.php:453
171
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2375
AND agl.`id_lang` = 1
3.746 ms 2 /classes/Product.php:7528
37
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.730 ms 433 /classes/Hook.php:456
283
SELECT SQL_NO_CACHE * FROM `ps_psreassurance` pr
LEFT JOIN ps_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "1"
AND pr.status = 1
ORDER BY pr.position
3.652 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
109
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 21
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
3.554 ms 6 Yes Yes /classes/Product.php:4594
257
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2446) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.539 ms 1 /classes/stock/StockAvailable.php:453
165
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2369
AND agl.`id_lang` = 1
3.513 ms 2 /classes/Product.php:7528
92
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 21
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 3002 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
3.508 ms 1 Yes Yes /classes/Product.php:4594
286
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
3.504 ms 1 /classes/Page.php:104
100
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 21
ORDER BY f.position ASC
3.462 ms 5 Yes /classes/Product.php:6015
60
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` = 1  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
3.441 ms 1 Yes Yes /classes/Category.php:924
164
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2368
AND agl.`id_lang` = 1
3.317 ms 2 /classes/Product.php:7528
12
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr' LIMIT 1
3.312 ms 3 /classes/Language.php:854
173
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` = 18) LIMIT 1
3.298 ms 1 /src/Adapter/EntityMapper.php:71
135
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
3.238 ms 1 /classes/Currency.php:1136
120
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
3.192 ms 1 /classes/Category.php:1378
36
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
3.146 ms 0 /classes/Hook.php:1292
119
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` = 21) AND (b.`id_shop` = 1) LIMIT 1
3.102 ms 1 /src/Adapter/EntityMapper.php:71
18
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
3.071 ms 1 /classes/module/Module.php:2018
259
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2448) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.040 ms 1 /classes/stock/StockAvailable.php:453
170
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2374
AND agl.`id_lang` = 1
3.038 ms 2 /classes/Product.php:7528
99
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` = 21 AND pa.`id_product` = 21 AND pa.`id_product_attribute` = 3002 LIMIT 1
2.964 ms 1 /classes/Product.php:1209
277
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 15 AND `id_shop` = 1 LIMIT 1
2.815 ms 1 /classes/module/Module.php:2109
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
2.812 ms 9 /classes/Language.php:1216
284
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.784 ms 1 /classes/ObjectModel.php:622
156
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
2.746 ms 1 /classes/module/Module.php:2636
172
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2376
AND agl.`id_lang` = 1
2.684 ms 2 /classes/Product.php:7528
134
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 11 AND `id_shop` = 1 LIMIT 1
2.676 ms 1 /classes/module/Module.php:2109
129
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
2.667 ms 1 /classes/module/Module.php:2109
288
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('674127', '22', '65161410', '', '1', '1', '2024-07-16 02:30:34')
2.665 ms 1 /classes/ObjectModel.php:622
9
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
2.605 ms 1 /classes/ObjectModel.php:1729
168
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2372
AND agl.`id_lang` = 1
2.592 ms 2 /classes/Product.php:7528
247
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2436) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.574 ms 1 /classes/stock/StockAvailable.php:453
256
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2445) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.551 ms 1 /classes/stock/StockAvailable.php:453
223
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2412) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.537 ms 1 /classes/stock/StockAvailable.php:453
162
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2366
AND agl.`id_lang` = 1
2.481 ms 2 /classes/Product.php:7528
248
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2437) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.469 ms 1 /classes/stock/StockAvailable.php:453
287
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 3 AND `id_object` = 21 LIMIT 1
2.440 ms 1 /classes/Page.php:83
253
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2442) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.439 ms 1 /classes/stock/StockAvailable.php:453
270
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2459) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.392 ms 1 /classes/stock/StockAvailable.php:453
128
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
2.377 ms 1 /classes/module/Module.php:2636
16
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
2.327 ms 88 /classes/Hook.php:287
237
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2426) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.327 ms 1 /classes/stock/StockAvailable.php:453
243
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2432) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.317 ms 1 /classes/stock/StockAvailable.php:453
224
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2413) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.308 ms 1 /classes/stock/StockAvailable.php:453
80
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2365
AND agl.`id_lang` = 1
2.293 ms 2 /classes/Product.php:7528
242
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2431) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.276 ms 1 /classes/stock/StockAvailable.php:453
206
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2395) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.238 ms 1 /classes/stock/StockAvailable.php:453
236
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2425) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.234 ms 1 /classes/stock/StockAvailable.php:453
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
2.215 ms 1 /classes/shop/Shop.php:218
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
2.214 ms 1 Yes /classes/shop/Shop.php:1364
178
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2367) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.214 ms 1 /classes/stock/StockAvailable.php:453
7
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
2.206 ms 1 /src/Adapter/EntityMapper.php:71
258
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2447) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.172 ms 1 /classes/stock/StockAvailable.php:453
167
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2371
AND agl.`id_lang` = 1
2.165 ms 2 /classes/Product.php:7528
285
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 674127
AND `date_add` > '2024-07-16 02:00:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
2.163 ms 1 Yes /classes/Connection.php:168
229
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2418) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.148 ms 1 /classes/stock/StockAvailable.php:453
163
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2367
AND agl.`id_lang` = 1
2.129 ms 2 /classes/Product.php:7528
160
SELECT SQL_NO_CACHE * FROM `ps_psreassurance` pr
LEFT JOIN ps_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "1"
AND pr.status = 1
ORDER BY pr.position
2.119 ms 3 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
169
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2373
AND agl.`id_lang` = 1
2.118 ms 2 /classes/Product.php:7528
154
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 21) AND (id_product_attribute = 3006) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.115 ms 1 /classes/stock/StockAvailable.php:453
225
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2414) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.112 ms 1 /classes/stock/StockAvailable.php:453
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
2.097 ms 1 /src/Adapter/EntityMapper.php:71
235
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2424) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.095 ms 1 /classes/stock/StockAvailable.php:453
241
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2430) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.093 ms 1 /classes/stock/StockAvailable.php:453
252
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2441) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.086 ms 1 /classes/stock/StockAvailable.php:453
64
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 21
2.075 ms 6 /classes/Product.php:7557
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
2.054 ms 1 Yes /classes/shop/Shop.php:715
260
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2449) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.050 ms 1 /classes/stock/StockAvailable.php:453
245
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2434) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.009 ms 1 /classes/stock/StockAvailable.php:453
249
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2438) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.950 ms 1 /classes/stock/StockAvailable.php:453
276
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
1.949 ms 1 /classes/module/Module.php:2636
244
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2433) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.880 ms 1 /classes/stock/StockAvailable.php:453
93
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` = 21
AND image_shop.`cover` = 1 LIMIT 1
1.871 ms 4 /classes/Product.php:3570
59
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 17
AND id_shop = 1 LIMIT 1
1.860 ms 1 /classes/ObjectModel.php:1729
238
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2427) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.858 ms 1 /classes/stock/StockAvailable.php:453
166
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`,
pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`,
pal.`available_now`, pal.`available_later`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_lang` pal
ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 18
AND pac.`id_product_attribute` = 2370
AND agl.`id_lang` = 1
1.819 ms 2 /classes/Product.php:7528
232
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2421) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.812 ms 1 /classes/stock/StockAvailable.php:453
240
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2429) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.797 ms 1 /classes/stock/StockAvailable.php:453
190
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2379) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.779 ms 1 /classes/stock/StockAvailable.php:453
90
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 21
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 3002 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.773 ms 1 Yes Yes /classes/Product.php:4594
127
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 10 LIMIT 1
1.769 ms 1 /classes/Hook.php:244
207
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2396) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.747 ms 1 /classes/stock/StockAvailable.php:453
239
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2428) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.743 ms 1 /classes/stock/StockAvailable.php:453
255
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2444) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.727 ms 1 /classes/stock/StockAvailable.php:453
234
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2423) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.725 ms 1 /classes/stock/StockAvailable.php:453
231
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2420) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.719 ms 1 /classes/stock/StockAvailable.php:453
230
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2419) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.716 ms 1 /classes/stock/StockAvailable.php:453
175
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` = 18
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
1.707 ms 96 Yes /classes/Product.php:2734
261
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2450) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.680 ms 1 /classes/stock/StockAvailable.php:453
254
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2443) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.679 ms 1 /classes/stock/StockAvailable.php:453
10
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
1.678 ms 1 /classes/shop/ShopUrl.php:182
177
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2366) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.676 ms 1 /classes/stock/StockAvailable.php:453
79
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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 18
ORDER BY f.position ASC
1.628 ms 5 Yes /classes/Product.php:6015
141
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
1.583 ms 1 /classes/module/Module.php:2109
33
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` = 21) AND (b.`id_shop` = 1) LIMIT 1
1.580 ms 1 /src/Adapter/EntityMapper.php:71
3
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
1.578 ms 1 /src/Adapter/EntityMapper.php:71
158
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_viewedproduct" LIMIT 1
1.526 ms 1 /classes/module/Module.php:2636
221
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2410) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.498 ms 1 /classes/stock/StockAvailable.php:453
222
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2411) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.469 ms 1 /classes/stock/StockAvailable.php:453
75
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` = 18 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` = 18 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.469 ms 0 /classes/Cart.php:1423
89
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` = 21
1.461 ms 6 /classes/Product.php:7490
113
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
1.404 ms 1 /classes/module/Module.php:2636
268
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2457) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.403 ms 1 /classes/stock/StockAvailable.php:453
226
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2415) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.345 ms 1 /classes/stock/StockAvailable.php:453
271
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2460) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.344 ms 1 /classes/stock/StockAvailable.php:453
217
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2406) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.341 ms 1 /classes/stock/StockAvailable.php:453
72
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` = 18)
1.321 ms 96 /classes/Product.php:3860
157
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 94 AND `id_shop` = 1 LIMIT 1
1.316 ms 1 /classes/module/Module.php:2109
282
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 1 LIMIT 1
1.307 ms 1 /classes/Country.php:405
91
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 21
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 3002 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.298 ms 1 Yes Yes /classes/Product.php:4594
98
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` = 3002
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21 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` = 3002
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 21 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1.279 ms 0 /classes/Cart.php:1423
38
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.273 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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)
1.272 ms 3 /classes/Language.php:1080
150
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (3002,3003,3004,3005,3006,3007)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
1.268 ms 6 /classes/Product.php:2752
143
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1
1.256 ms 1 /classes/module/Module.php:2109
262
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2451) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.201 ms 1 /classes/stock/StockAvailable.php:453
233
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2422) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.191 ms 1 /classes/stock/StockAvailable.php:453
215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2404) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.185 ms 1 /classes/stock/StockAvailable.php:453
114
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 86 AND `id_shop` = 1 LIMIT 1
1.184 ms 0 /classes/module/Module.php:2109
250
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 18) AND (id_product_attribute = 2439) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.176 ms 1 /classes/stock/StockAvailable.php:453