Ultimi articoli in magazzino

Gerolsteiner . Scintillanti

2,00 
Tasse incluse Spedizione esclusa

in addition 0,15  deposit

Sconti sul volume
Quantità Prezzo Salva
60 1,40  Fino a 35,75 
Descrizione

GEROLSTEINER - il @3A5P8

Il marchio con una stella

Gerolstein si trova nella bellissima Vulkaneifel.

L'acqua minerale GEROLSTEINER deve il suo gusto speciale alle condizioni geologiche alla sorgente nel Vulkaneifel. Nella regione di Gerolstein, in particolare, l'acido carbonico di origine vulcanica incontra la roccia dolomitica ricca di calcio e magnesio. Questo crea un'acqua ricca di minerali, ma dal sapore piacevolmente neutro e rinfrescante nonostante la sua elevata mineralizzazione totale.

GEROLSTEINER L'acqua minerale proviene da una profondità massima di 250 metri; occorrono da 50 a 100 anni prima di essere estratta.

La particolarità di GEROLSTEINER Sprudel:
GEROLSTEINER L'acqua minerale ha un buon sapore e fa bene. Solo poche acque in Germania combinano queste due qualità. Perché le acque dal sapore neutro spesso contengono solo pochi minerali. Oppure sono ricche di minerali, ma hanno una nota salata o leggermente amara a causa di un alto contenuto di cloruro di sodio o solfato. Il fattore decisivo non è solo il livello di mineralizzazione, ma anche il tipo e l'equilibrio degli ingredienti, ed è proprio qui che risiede la qualità dell'acqua minerale GEROLSTEINER . Grazie alla sua mineralizzazione, GEROLSTEINER spumante @2T0O8 sapore piacevolmente armonico, senza alcuna nota intrinseca dominante. GEROLSTEINER suo effetto neutralizzante gli acidi, l'idrogenocarbonato garantisce un gusto equilibrato e @3X1Y5 Sprudel ne contiene molto, ovvero 1.800 mg di idrogenocarbonato / l.

Internazionale:
In qualità di più grande esportatore di acqua minerale della Germania, GEROLSTEINER suoi prodotti in tutto il mondo. I paesi limitrofi del Benelux sono paesi di esportazione particolarmente importanti. Inoltre, l'acqua minerale è distribuita principalmente a livello internazionale negli Stati Uniti, Giappone e Corea del Sud. In totale GEROLSTEINER in circa 35 paesi in tutto il mondo.

GEROLSTEINER Sprudel - l'acqua minerale frizzante per ogni occasione nella bottiglia di vetro da 0,7 litri di nuova concezione.

750ml di acqua frizzante 1 bottiglia

TDS2572 mg / l
fattore ph5.9
durezza1299 mg / l
nitrato5,1 mg / l
calcio348 mg / l
magnesio108 mg / l
sodio118 mg / l
potassio11 mg / l
Silice40,2 mg / l
bicarbonato1.816 mg / l
solfato38 mg / l
cloruro40 mg / l

GEROLSTEINER
2020GS07GLSP

Avvisami quando disponibile
ItemPackageQuantity
1
Imballaggio
Vetro
Articolo
Scintillante / Classico
Mineralizzazione
Alta 800-1500mg/l
Capacità
750ml
Vintage

Riferimenti Specifici

I clienti che hanno acquistato questo prodotto hanno comprato anche:

Perlage

ACQUA FINE

Il POLACCO GENTLE FIZZ dal 1979
Prezzo 3,00 

Proprietà VCH . VICHY...

ACQUA FINE

Proprietà VCH . VICHY CATALAN, il classico di Barcellona
Prezzo 2,80 
radius 99 radius 99
  • -0,25 

radius 99

ACQUA FINE

raggio 99 - emozionante ancora
Prezzo base 2,00  -0,25  Prezzo 1,75 
BADOIT rouge 75cl BADOIT rouge 75cl
  • In saldo!

BADOIT rouge 75cl

ACQUA FINE

BADOIT® - intenso frizzante
Prezzo 4,00 
AQUA CARPATICA AQUA CARPATICA
  • In saldo!

AQUA CARPATICA

ACQUA FINE

AQUA CARPATICA - L'acqua più perfetta della natura
Prezzo 5,00 
BADOIT 33cl BADOIT 33cl
  • In saldo!

BADOIT 33cl

ACQUA FINE

BADOIT® - Bolle di gioia francesi dal 1778
Prezzo 3,00 

16 altri prodotti della stessa categoria:

N°1 ROSEMARY WATER . Ancora N°1 ROSEMARY WATER . Ancora
  • In saldo!

N°1 ROSEMARY WATER . Ancora

ACQUA FINE

N°1 ROSEMARY WATER . Un drink da ricordare
Prezzo 4,80 

FILLICO . ultima bottiglia

ACQUA FINE

ATTENZIONE ULTIMO FLASCHE della versione in Europa! Fino a nuovo avviso, nessun accesso al mercato giapponese.
Prezzo 999,00 

MINUS 181 . Ancora

ACQUA FINE

MINUS 181 - Acqua Artesiana Tedesca
Prezzo 29,00 
Proprietà TAU Ancora Proprietà TAU Ancora
  • In saldo!

Proprietà TAU Ancora

ACQUA FINE

TAU - l'acqua di design inglese dalla casa TY NANT.
Prezzo 5,80 
The Continental Box The Continental Box
  • -2,70 
  • Nuovo
  • Pacchetto
Prezzo base 32,60  -2,70  Prezzo 29,90 
SCATOLA N. 2 ACQUA FINE... SCATOLA N. 2 ACQUA FINE...
  • -6,50 
  • Pacchetto

SCATOLA N. 2 ACQUA FINE...

ACQUA FINE

(DE, IT, IT, PO, N.N.) 12 bottiglie
Prezzo base 60,80  -6,50  Prezzo 54,30 

THREE BAYS | still 33cl

ACQUA FINE

Acqua fine australiana premium
Prezzo 4,80 

FILLICO . ANIMALE DOMESTICO

ACQUA FINE

FILLICO l'acqua di gioielleria dal Giappone
Prezzo 12,50 
evian . LE 17-20 evian . LE 17-20
  • -11,00 
  • Pacchetto

evian . LE 17-20

ACQUA FINE

EVIAN Pacchetto: Abloh, Ferragni, Longevial
Prezzo base 110,00  -11,00  Prezzo 99,00 

AQUI-LIVE . frizzante 33cl

ACQUA FINE

Premium Acqua fine australiana
Prezzo 5,00 

FILLICO . RE ROSA

ACQUA FINE

FILLICO l'acqua di gioielleria dal Giappone
Prezzo 999,00 

bling h2o blu chiaro Mhd

ACQUA FINE

bling H2O - Benvenuti nella vita...
Prezzo 449,00 

Perlage

ACQUA FINE

Il POLACCO GENTLE FIZZ dal 1979
Prezzo 3,00 

fromin . Ancora

ACQUA FINE

L'acqua dell'era glaciale
Prezzo 4,00 

healsi . blu ancora

ACQUA FINE

La fonte dell'eternità
Prezzo 2,00 
Load Time2662 ms - You'd better run your shop on a toaster
Querying Time442 ms
Queries783
Memory Peak Usage36.4 Mb
Included Files1557 files - 15.73 Mb
PrestaShop Cache0.01 Mb
Global vars1.23 Mb
PrestaShop Version1.7.6.3
PHP Version7.3.27 (OK)
MySQL Version10.2.36-MariaDB-1:10.2.36+maria~bionic (OK)
Memory Limit512M
Max Execution Time120s
Smarty Cacheenabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 72 ms 72 ms 5.14 Mb 5.31 Mb
__construct 0 ms 72 ms - Mb 5.31 Mb
init 336 ms 408 ms 8.36 Mb 13.77 Mb
checkAccess 0 ms 408 ms - Mb 13.77 Mb
setMedia 9 ms 418 ms 0.49 Mb 14.31 Mb
postProcess 0 ms 418 ms - Mb 14.31 Mb
initHeader 0 ms 418 ms - Mb 14.31 Mb
initContent 1197 ms 1615 ms 7.35 Mb 21.64 Mb
initFooter 0 ms 1615 ms - Mb 21.64 Mb
display 1047 ms 2662 ms 14.32 Mb 36.37 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 783 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE id_address
FROM `ps_address`
WHERE  `id_customer` = 0 AND `alias` = 3408403 LIMIT 1
44.4 17420 /modules/shippingaddress/shippingaddress.php:402
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`)
18 6717 /classes/Configuration.php:160
SELECT SQL_NO_CACHE id_address
FROM `ps_address`
WHERE  `alias` = 3408403 LIMIT 1
12.3 34840 /modules/shippingaddress/shippingaddress.php:336
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
7.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "socialloginizer" LIMIT 1
6.5 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 126 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
5.8 24 Yes /classes/Category.php:783
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 143) AND (b.`id_shop` = 1) LIMIT 1
5.5 1 /src/Adapter/EntityMapper.php:75
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_module_shop` `ms` ON ms.`id_module` = m.`id_module`
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`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
4.7 545 Yes Yes /classes/Hook.php:670
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 124) AND (b.`id_shop` = 1) LIMIT 1
4.2 1 /src/Adapter/EntityMapper.php:75
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
4.2 1 /classes/CartRule.php:401
INSERT INTO `ps_eventbus_incremental_sync` (`id_shop`, `id_object`, `type`, `created_at`, `lang_iso`) VALUES ('1', '', 'carts', '2021-05-14T00:15:22+02:00', 'de') ON DUPLICATE KEY UPDATE `id_shop` = '1',`id_object` = '',`type` = 'carts',`created_at` = '2021-05-14T00:15:22+02:00',`lang_iso` = 'de'
3.1 1 /modules/ps_eventbus/src/Repository/IncrementalSyncRepository.php:51
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, 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 752 /classes/Hook.php:407
INSERT INTO `ps_address`
SET `id_customer` = 0,
`alias` = 3408403,
`deleted` = 1,
`date_add` = "2021-05-14 00:15:22",
`date_upd` = "2021-05-14 00:15:22",
`lastname` = "-",
`firstname` = "-",
`address1` = "-",
`city` = "-",
`postcode` = "",
`id_state` = 0,
`id_country` = 1
2.9 1 /modules/shippingaddress/shippingaddress.php:366
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` = 236
AND image_shop.`cover` = 1 LIMIT 1
2.8 6 /classes/Product.php:3081
SHOW TABLES FROM `uw0fah6ohngov5fo`
2.6 1 /modules/amazon/common/tools.class.php:180
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.5 1 /classes/ObjectModel.php:559
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('3408403', '387', '2886926340', '', '1', '1', '2021-05-14 00:15:25')
2.4 1 /classes/ObjectModel.php:559
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 145) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /src/Adapter/EntityMapper.php:75
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 129) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /src/Adapter/EntityMapper.php:75
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
2.3 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.2 75 Yes /classes/Category.php:783
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` = 6
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 236) AND (b.`id_shop` = 1) LIMIT 1
2.2 1 /src/Adapter/EntityMapper.php:75
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 75) AND (b.`id_shop` = 1) LIMIT 1
2.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM ps_cms_role WHERE name = 'LEGAL_SHIP_PAY'
2.1 1 /src/Adapter/Database.php:48
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
2.1 207 Yes /classes/Dispatcher.php:640
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_amazon_configuration` c
LEFT JOIN `ps_amazon_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.1 134 /classes/Configuration.php:160
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 82) AND (b.`id_shop` = 1) LIMIT 1
1.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 6)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.9 244 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item
FROM `ps_pack` a
LEFT JOIN `ps_product` p ON p.id_product = a.id_product_item
LEFT JOIN `ps_product_lang` pl
ON p.id_product = pl.id_product
AND pl.`id_lang` = 6 AND pl.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` = 6)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl
ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 6 AND cl.id_shop = 1 
WHERE product_shop.`id_shop` = 1
AND a.`id_product_pack` = 241
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
1.7 12 Yes /classes/Pack.php:345
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 123) AND (b.`id_shop` = 1) LIMIT 1
1.7 1 /src/Adapter/EntityMapper.php:75
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
1.7 0 /classes/Hook.php:194
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 131) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 132 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE jeb.*, jebl.*
FROM ps_jxmegalayout_extra_banner jeb
LEFT JOIN ps_jxmegalayout_extra_banner_lang jebl
ON(jeb.`id_extra_banner` = jebl.`id_extra_banner`)
WHERE jeb.`id_extra_banner` = 11
AND jebl.`id_lang` = 6 LIMIT 1
1.5 1 /modules/jxmegalayout/classes/extra/JXMegaLayoutExtraBanner.php:74
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 124 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 27 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`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` = 6  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 2
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.3 11 Yes Yes /classes/Category.php:909
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 128 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.3 28 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 75 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.3 26 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE *
FROM `ps_shop_url` a0
WHERE (a0.`id_shop` = 1) AND (a0.`main` = 1)
1.2 1 /classes/PrestaShopCollection.php:381
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 126) AND (b.`id_shop` = 1) LIMIT 1
1.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 94 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.2 24 Yes /classes/Category.php:783
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
1.2 4 Yes /classes/shop/Shop.php:705
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
1.2 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 6 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 2
AND nleft >= 2 AND nright <= 193
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
1.2 13 Yes /modules/ps_categorytree/ps_categorytree.php:149
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facebook" LIMIT 1
1.2 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 109 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.2 34 Yes /classes/Category.php:783
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` = 236) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
1.1 376 /classes/SpecificPrice.php:283
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 138 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 9 Yes /classes/Category.php:783
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 6) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
1.1 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1 352 Yes /classes/Country.php:154
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 = 'fine-liquids.com' OR su.domain_ssl = 'fine-liquids.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
1 4 Yes /classes/shop/Shop.php:345
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 57 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 2)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC
1 56 Yes /classes/Manufacturer.php:207
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute
FROM `ps_product` p
NATURAL LEFT JOIN `ps_product_lang` pl
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_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` = 6)
WHERE pl.`id_lang` = 6
AND pl.id_shop = 1 
AND p.`id_product` IN (241,299)
GROUP BY p.id_product LIMIT 1
1 2 Yes /classes/Pack.php:426
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 133 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 7 Yes /classes/Category.php:783
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(
"2021-05-14 00:00:00",
INTERVAL 100 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` = 6 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 6 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` = 6)
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` = 236 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1 1 Yes /classes/Product.php:4031
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
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 105 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 8 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 121 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 17 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 146 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 29 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 187 AND `id_shop` = 1 LIMIT 1
0.9 1 /classes/module/Module.php:2311
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.9 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 84 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 1 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 112 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 137 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 6)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
0.9 244 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 2
0.9 7 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 140 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.9 352 Yes /classes/Country.php:154
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.9 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 63 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 16 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 107 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 35 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 119 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 9 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 56 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 2 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 71 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 26 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 136 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 142 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 14 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 72 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 143 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 25 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 130 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 11 Yes /classes/Category.php:783
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.8 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE DISTINCT h.id_hook as id, h.name as name
FROM ps_hook h
LEFT JOIN ps_hook_module hm
ON(h.id_hook = hm.`id_hook`)
INNER JOIN ps_module m
ON(hm.`id_module` = m.`id_module`)
WHERE (lower(h.`name`) LIKE 'display%')
AND m.`name` = 'jxmanufacturerblock'
ORDER BY h.name ASC
0.8 14 Yes /modules/jxmanufacturerblock/src/JXManufacturersPresenter.php:44
SELECT SQL_NO_CACHE p.id_product
FROM ps_product p
WHERE p.active = 1
0.8 253 /modules/ps_viewedproduct/ps_viewedproduct.php:306
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 97 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 30 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 87 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 5 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 76 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 61 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 98 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 139 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 36 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 127 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 10 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.id_category, cl.name, c.id_parent
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON cl.id_category = c.id_category AND cl.id_shop = 1
WHERE (cl.id_lang = 6)
ORDER BY cl.id_category
0.8 97 /modules/ps_facebook/classes/Repository/GoogleCategoryRepository.php:278
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 113 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 30 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 125 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 114 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 29 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 95 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 32 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 80 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 33 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 59 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 17 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 93 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 14 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
0.8 3 Yes /classes/Currency.php:507
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 66 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
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.8 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 144 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 32 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 106 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 34 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 69 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 24 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 134 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 13 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 77 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 36 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 86 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 15 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 102 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 27 Yes /classes/Category.php:783
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`
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` = 6)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
WHERE pa.`id_product` = 236
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.8 1 Yes Yes /classes/Product.php:2397
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 79 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 31 Yes /classes/Category.php:783
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.8 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 82 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 31 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE tl.`id_unique`, tl.`id_item`
FROM ps_jxmegalayout_items tl
JOIN ps_jxmegalayout t
ON(t.`id_layout`=tl.`id_layout`)
LEFT JOIN ps_jxmegalayout_pages tp
ON(t.`id_layout`=tp.`id_layout`)
WHERE t.`id_shop` = 1
AND (t.`status` = 1 OR tp.`status` = 1)
0.8 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:120
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 131 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 33 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 62 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 15 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE `id_country`, `id_state`, `vat_number`, `postcode` FROM `ps_address`
WHERE `id_address` = 5829393 LIMIT 1
0.8 1 /classes/Address.php:421
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 141 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 4 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 70 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 16 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 123 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 35 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 120 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 6 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 89 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 5 Yes /classes/Category.php:783
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` = 2) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 129 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 28 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 83 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 7 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 135 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 10 Yes /classes/Category.php:783
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` = 9
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 236) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 236 AND `id_shop` = 1
0.8 7 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 108 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 12 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 65 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 6 Yes /classes/Category.php:783
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` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 236) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 64 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 13 Yes /classes/Category.php:783
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` = 6
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.7 1 /src/Adapter/EntityMapper.php:75
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` = 6
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 118 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 11 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 104 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 8 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 58 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 3 Yes /classes/Category.php:783
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`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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_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` = 236
AND al.`id_lang` = 6
AND agl.`id_lang` = 6
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 1 Yes Yes /classes/Product.php:3942
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 101 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 12 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 236
0.7 1 /src/Adapter/Database.php:48
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.7 135 /classes/module/Module.php:307
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.7 135 /classes/module/Module.php:307
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.7 135 /classes/module/Module.php:307
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.7 135 /classes/module/Module.php:307
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` = 5
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 236) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php: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` = 8
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 236) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 1
0.7 7 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.7 1 /classes/shop/Shop.php:1164
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 107) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.7 375 /classes/SpecificPrice.php:291
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 81 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 6
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 5 Yes /classes/Category.php:783
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` = 6
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
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`
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` = 6)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
WHERE pa.`id_product` = 236
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 1 Yes Yes /classes/Product.php:2397
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`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 6)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
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` = 236
0.6 1 /classes/Product.php:6285
SELECT SQL_NO_CACHE DISTINCT h.id_hook as id, h.name as name
FROM ps_hook h
LEFT JOIN ps_hook_module hm
ON(h.id_hook = hm.`id_hook`)
INNER JOIN ps_module m
ON(hm.`id_module` = m.`id_module`)
WHERE (lower(h.`name`) LIKE 'display%')
AND m.`name` = 'jxmegamenu'
ORDER BY h.name ASC
0.6 52 Yes /modules/jxmegamenu/src/JXMegaMenuRepository.php:205
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 16
0.6 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
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`
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` = 6)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
WHERE pa.`id_product` = 236
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.6 1 Yes Yes /classes/Product.php:2397
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 236 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 236 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.6 1 Yes /classes/SpecificPrice.php:620
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 7
0.6 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
UPDATE `ps_cart` SET `id_shop_group` = '1',`id_shop` = '1',`id_address_delivery` = '5829393',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '2',`id_customer` = '0',`id_guest` = '0',`id_lang` = '6',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '2021-05-14 00:15:22',`date_upd` = '2021-05-14 00:15:22' WHERE `id_cart` = 0
0.6 1 /classes/ObjectModel.php:737
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 232 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 3 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 188) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 2
AND id_shop = 1 LIMIT 1
0.6 1 /classes/ObjectModel.php:1610
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 241 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 3 Yes /classes/SpecificPrice.php:557
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` = 241 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` = 241 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1238
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` = 1
AND tr.`id_tax_rules_group` = 66
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.6 1 /classes/tax/TaxRulesTaxManager.php:108
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`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 6)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
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` = 236
0.6 1 /classes/Product.php:6285
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 2) AND (a0.`nright` > 193) AND (a1.`id_lang` = 6)
ORDER BY a0.`nleft` asc
0.6 7 /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE a.id_ce_content as id FROM ps_ce_content a
LEFT JOIN ps_ce_content_lang AS b ON a.id_ce_content = b.id_ce_content
LEFT JOIN ps_ce_content_shop sa ON sa.id_ce_content = a.id_ce_content AND sa.id_shop = b.id_shop
WHERE b.id_lang = 6 AND sa.id_shop = 1 AND a.hook LIKE 'displayAfterBodyOpeningTag' AND (a.id_product = 0 OR a.id_product = 236) AND a.active = 1 ORDER BY a.id_product DESC
0.6 121 Yes /modules/creativeelements/classes/CEContent.php:150
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 104) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php: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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 213) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.5 7 /src/Adapter/EntityMapper.php: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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 236 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` = 236 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 41 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE jx.*, jxl.`title`, jxl.`badge`, jxl.`url`
FROM `ps_jxmegamenu` jx
LEFT JOIN `ps_jxmegamenu_lang` jxl
ON (jx.`id_item` = jxl.`id_item`)
WHERE jx.`id_shop` = 1
AND jx.`hook_name` = "displayTop"
AND jxl.`id_lang` = 6
AND jx.`active` = 1
ORDER BY jx.`sort_order`
0.5 83 Yes /modules/jxmegamenu/src/MegaMenu.php:159
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.5 248 /classes/Tab.php:320
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` = 6
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.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.id_product
FROM ps_product p
WHERE p.active = 1
0.5 253 /modules/ps_viewedproduct/ps_viewedproduct.php:306
SELECT SQL_NO_CACHE *
FROM ps_jxcategoryproducts jxcp
JOIN ps_jxcategoryproducts_lang jxcpl
ON jxcp.id_tab = jxcpl.id_tab
AND jxcpl.id_lang = 6
AND jxcp.id_shop = 1 AND `active` = 1 ORDER BY `sort_order`
0.5 1 Yes /modules/jxcategoryproducts/src/JXCategoryProductsRepository.php:144
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`
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` = 6)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 6)
WHERE pa.`id_product` = 236
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.5 1 Yes Yes /classes/Product.php:2397
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 3408403
AND `date_add` > '2021-05-13 23:45:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.5 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE *
FROM `ps_guest` a
WHERE (a.`id_guest` = 3408403) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.5 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE `value`
FROM `ps_jxmanufacturers_settings`
WHERE `hook_name` = 'displayHome'
AND `setting_name` = 'JX_MANUFACTURER_DISPLAY_IMAGE_TYPE'
AND `id_shop` = 1 LIMIT 1
0.5 16 /modules/jxmanufacturerblock/src/JXManufacturersSettingsRepository.php:81
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 50 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE DISTINCT h.id_hook as id, h.name as name
FROM ps_hook h
LEFT JOIN ps_hook_module hm
ON(h.id_hook = hm.`id_hook`)
INNER JOIN ps_module m
ON(hm.`id_module` = m.`id_module`)
WHERE (lower(h.`name`) LIKE 'display%')
AND m.`name` = 'jxcategoryproducts'
ORDER BY h.name ASC
0.5 18 Yes /modules/jxcategoryproducts/src/JXCategoryProductsRepository.php:102
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 6)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 6)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 6)
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 = 241
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 6)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 6)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 6)
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 = 236
ORDER BY f.position ASC
0.5 6 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 1
0.5 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'USD') LIMIT 1
0.5 1 /classes/Currency.php:677
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` = 236) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
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` = 6)
WHERE i.`id_product` = 236
ORDER BY `position`
0.5 6 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'EUR') LIMIT 1
0.5 1 /classes/Currency.php:677
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 84 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.5 1 /classes/ObjectModel.php:1610
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 128) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "trustedshopsintegration" LIMIT 1
0.5 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 52 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 1 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 13
0.5 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 5 AND `id_object` = 236 LIMIT 1
0.5 1 /classes/Page.php:83
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` = 41) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php: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` = 6
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 241) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 199 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:557
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` = 232) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 175 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 234 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 2 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `locale` = 'it-it' LIMIT 1
0.5 6 /classes/Language.php:744
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` = 241 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` = 241 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 241 AND `id_shop` = 1
0.5 7 /src/Adapter/EntityMapper.php:82
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` = 6
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 11 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 1 LIMIT 1
0.5 1 /classes/AddressFormat.php:629
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'GBP') LIMIT 1
0.5 1 /classes/Currency.php:677
SELECT SQL_NO_CACHE a.id_ce_content as id FROM ps_ce_content a
LEFT JOIN ps_ce_content_lang AS b ON a.id_ce_content = b.id_ce_content
LEFT JOIN ps_ce_content_shop sa ON sa.id_ce_content = a.id_ce_content AND sa.id_shop = b.id_shop
WHERE b.id_lang = 6 AND sa.id_shop = 1 AND a.hook LIKE 'displayFooterProduct' AND (a.id_product = 0 OR a.id_product = 236) AND a.active = 1 ORDER BY a.id_product DESC
0.4 121 Yes /modules/creativeelements/classes/CEContent.php:150
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 70) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE jeb.*, jebl.*
FROM ps_jxmegalayout_extra_banner jeb
LEFT JOIN ps_jxmegalayout_extra_banner_lang jebl
ON(jeb.`id_extra_banner` = jebl.`id_extra_banner`)
WHERE jeb.`id_extra_banner` = 18
AND jebl.`id_lang` = 6 LIMIT 1
0.4 0 /modules/jxmegalayout/classes/extra/JXMegaLayoutExtraBanner.php:74
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 236) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:788
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 6 AND uuid = "a60da06dbdcc9903b139bc35325d06f8") LIMIT 1
0.4 1 /modules/trustedshopsintegration/trustedshopsintegration.php:650
SELECT SQL_NO_CACHE jx.*, jxl.`title`, jxl.`badge`, jxl.`url`
FROM `ps_jxmegamenu` jx
LEFT JOIN `ps_jxmegamenu_lang` jxl
ON (jx.`id_item` = jxl.`id_item`)
WHERE jx.`id_shop` = 1
AND jx.`hook_name` = "displayTop"
AND jxl.`id_lang` = 6
AND jx.`active` = 1
ORDER BY jx.`sort_order`
0.4 83 Yes /modules/jxmegamenu/src/MegaMenu.php:159
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 115 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:557
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` = 202) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 127) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 6 AND uuid = "a60da06dbdcc9903b139bc35325d06f8") LIMIT 1
0.4 1 /modules/trustedshopsintegration/trustedshopsintegration.php:650
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` = 234) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 132) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 213 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 2 Yes /classes/SpecificPrice.php:557
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.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_cms` c
JOIN `ps_cms_lang` cl ON c.`id_cms`= cl.`id_cms`
WHERE c.`id_cms` = 11
AND cl.`id_lang` = 6
AND cl.`id_shop` = 1
LIMIT 0 , 1
0.4 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.4 83 /classes/Hook.php:238
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 236030601 AND name = '_elementor_edit_mode' LIMIT 1
0.4 1 /modules/creativeelements/classes/wrappers/Post.php:259
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` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 190) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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` = 6
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php: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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 236) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php: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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 50) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 1, 4, 0) +  IF (`id_currency` = 2, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 2) AND
`id_country` IN (0, 1) AND
`id_group` IN (0, 1) AND `id_product` = 202 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-14 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 1 Yes /classes/SpecificPrice.php:557
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
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` = 236)
0.4 1 /classes/Product.php:3364
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 236 LIMIT 1
0.4 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE 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 = 236
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-05-14 00:00:00",
INTERVAL 100 DAY
)
) > 0
0.4 0 /classes/Product.php:1403
SELECT SQL_NO_CACHE c.*, cl.*
FROM ps_jxblog_category c
LEFT JOIN ps_jxblog_category_lang cl
ON(c.`id_jxblog_category` = cl.`id_jxblog_category`)
LEFT JOIN ps_jxblog_category_shop cs
ON(c.`id_jxblog_category` = cs.`id_jxblog_category`)
LEFT JOIN ps_jxblog_category_group cg
ON(c.`id_jxblog_category` = cg.`id_jxblog_category`)
WHERE c.`active` = 1
AND c.`id_parent_category` = 6
AND cs.`id_shop` = 1
AND cg.`id_group` = 1
AND cl.`id_lang` = 1
ORDER BY c.`position`
LIMIT 9990,10
0.4 3 Yes /modules/jxblog/classes/JXBlogCategory.php:334
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` = 115) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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` = 1
AND tr.`id_tax_rules_group` = 66
AND tr.`id_state` IN (0, 0)
AND ('74934' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '74934')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.4 1 /classes/tax/TaxRulesTaxManager.php:108
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` = 279) LIMIT 1
0.4 1 /src/Adapter