Nur noch wenige Teile verfügbar

FILLICO | BLACK KING

999,00 €
Zur Wunschliste hinzufügen
Beschreibung

FILLICO Jewelery Water - Excellence of Ultimate Luxury

Fillico wurde im Jahr 2005 mit der Vision gegründet, dass die wertvollste natürliche Ressource der Welt - Wasser - geschätzt und geliebt werden sollte, eingebettet in ein Meisterwerk an Handwerkskunst und Prestige. Natürlich nicht irgendein Wasser, sondern das feinste Mineralwasser der Welt, abgefüllt mit Perfektion, Eleganz, Anmut und Stil.

Fillico produziert eine der teuersten Luxusmarken von Mineralwasser weltweit und ist berühmt für seine außergewöhnlichen Flaschen, die mit Edelsteinen geschmückt sind und in Europa zwischen 150 und 400 Euro kosten.

Die Flaschen sind echte Meisterwerke, basierend auf satiniertem Glas mit Gold-Inlay und den berühmten Swarovski-Kristallen. Es gibt nur begrenzte Auflagen, die regelmäßig erneuert werden.

Das Wasser kommt aus Kobe in Japan. Es entspringt einer berühmten Quelle, die den Japanern als rein und natürlich bekannt ist. Sie verwenden dieses Quellwasser, um einen ihrer besten Sake zu produzieren.

Da die Wasserflaschen in Handarbeit hergestellt werden, ist die Produktion auf 5.000 Flaschen pro Monat begrenzt.

Das Wasser stammt aus der hoch angesehenen Nunobiki Quelle in Kobe, im Rokkou Nationalpark in Japan und ist vor jeder industriellen oder landwirtschaftlichen Entwicklung geschützt.

Das Wasser wird auch durch einen Sake Produzenten in Kobe verwendet. 

Die Geschichte:

2005 gegründet wurden bereits ein Jahr später die original Kronkorken für alle Fillico Wasserflaschen entwickelt. Christian Dior stellte Fillico Jewelry Water bald darauf seinen VIP Kunden vor.

2008 war Fillico Co-Sponsor der 61. Filmfestspiele von Cannes

Zahlreiche neue und limitierte Editionen erschienen und das gehobene Luxus-Schmuckwasser wird von VIPs und königlichen Familien auf der ganzen Welt geliebt und geschätzt.

Filico Jewelry Water wurde 2017 vom New Yorker Insider Monkey in der "Welt der Mineralwassermarke 2017" mit dem ersten Platz ausgezeichnet.

Das Wasser wird auf königlichen Empfängen und anderen glamourösen Events bevorzugt ausgeschenkt. So begleitete es auch den japanischen Kaiser letzten Dezember nach Mailand.

Das Wasser:

Fillico Japan bietet eines der besten natürlichen Mineralwässer der Welt, aus einem Brunnen tief unter den Rokko Mountains in Kobe Japan, in der wohl elegantesten Verpackung im Premium Wasser Bereich.

Eine der größten Ressourcen der Welt ist auch eine der wertvollsten. Japan ist aufgrund seines rauen Bodens und seines ausgeprägten saisonalen Klimas mit sauberem und mineralstoffreichem Wasser gesegnet. Das Wasser aus der Region um Fillicos Quelle wird auch zur Herstellung der besten und hochwertigsten Sake Reisweine Japans verwendet.

Aufgrund der Granit-Sandsteinschicht des Berges Rokko ist das Wasser zwanzig Jahre auf seinem natürlichen Weg.

Als natürliches Antioxidans unterstützt es jeden Tag das Herz und den Körper auf wunderbare Weise und bleibt unabhängig von der Wassertemperatur stabil und klar im Geschmack. Ein mittelhartes, leicht zu trinkendes Wasser, dessen Schönheit und Körper köstlich von innen strahlt.

Ein wahrer Segen für die ganz besonderen Momente im Leben. Es ist ein außergewöhnliches Mineralwasser, das für gelebte Gastfreundschaft und unkonventionelle Geschenke unerlässlich ist. 

Die Philosophie:

Ein Schmuckwasser zur „Inspiration“ und „Vision“

Die Premiummarke möchte den materiellen und fortwährenden natürlichen Ressourcen einen neuen, greifbaren und zeitgemäßen Wert verleihen, der dem Menschen das Wunder und die Freude an diesem Prozess gibt. Fillico zelebriert das Wesen der Natur für den göttlichen Glanz, den sie schenkt, und huldigt ihr mit wahrhaftigen Schätzen um ihr Respekt und Dankbarkeit zurückgeben zu können.

Dieses außergewöhnliche, exotische Produkt ist für Menschen ausgerichtet, die immer nach etwas Neuem und Aufregendem suchen: Fillico Jewelry Water ist fulminant sexy und luxuriös.

Bei Fillico Japan streben wir kontinuierlich danach, sehr exklusive, originelle und personalisierte Designs zu produzieren.

Die Version:

Fillico Black King Cap mit Metal Angel Wing Set

„Fillico Elegant Black“ ist eine luxuriös glänzend mattschwarze Flasche, mit einem schwarzen Verschluss und schwarzen Swarovski-Kristallen. Die insgesamt 57 Kristalle werden elegant mit herausragender Handwerkskunst kombiniert. Die matt gefrostete Flasche ist cool und einzigartig.

Die Flaschenform wurde mit der märchenhaften Andeutung eines schlanken und eleganten weiblichen Körpers kreiert. Nachempfunden den Dächern der italienischen Stadt Alberobello.

Darüber hinaus ziert eine jede Fillico Flasche eine Krone, die als Symbol der höchsten Position eine Autorität darstellt und für "Erfolg", "Schönheit" und "Ruhm" steht. Die Flaschen mit verzierten Kronen sind entsprechend prestigeträchtiger und eignen sich am besten als Premium Geschenk.

King Cap

Die Kaiserkrone des Heiligen Römischen Kaisers "Federico II" in der ersten Hälfte des 13. Jahrhunderts, Vorlagen aus der italienischen Provinz Apulien entsprechend. Insgesamt 30 Swarovski-Kristalle verzieren die Krone, darunter große Perlen, die in der Mitte funkeln. Zeitloses Design, welches Geschichte lebt. Eine Krone, die Kraft geben soll und zu Erfolg und Glück führt - ein beliebtes Motiv im Feng Shui.

Angel Wing

Engelsflügel mit dreidimensionaler und schwerer Haptik, eingebetteten Swarovski – Kristallen strahlen ein zauberhaftes Leuchten aus. Das Motiv von Federn und Flügeln symbolisiert das Erreichen von Glück und die Fähigkeit Dinge gelingen zu lassen. Es ist ein perfektes Motiv als Geschenk für alle, die einen Neuanfang wagen.

Die Flasche ist 360 mm hoch und hat einen Durchmesser von 95 mm, alle Metallteile bestehen aus einer Legierung von 70% Zink und 30% Zinn, die Oberflächen sind nickelfrei versilbert.

Die Exklusivität:

Wir von FINE LIQUIDS freuen uns Ihnen aktuell diese Premiummarke exklusiv in Deutschland anbieten zu können. Sollten Sie bestimmte Flaschen, oder Ausgaben wünschen melden Sie sich bitte bei uns.

Hier ein von uns initiierter Artikel von Andreas Conrad im Magazin der Front Row Society mit Flaschen die wir hierfür zur Verfügung gestellt haben. Zum Artikel

720ml still

TDS 13 mg / l
ph-faktor 6,7
Härte 113 mg / l
Nitrat 0 mg / l
Kalzium 3,33 mg / l
Magnesium 0,73 mg / l
Natrium 2,7 mg / l
Kalium 0,08 mg / l
Silica 3,2 mg / l
Bikarbonat 0 mg / l
Sulfat 2,5 mg / l
Chlorid 0 mg / l

Der deutsche Michel

Late-Night-Show mit Michel Abdollahi zum Thema Luxus im NDR

Samstag, 26. Oktober 2019, 00:10 bis 00:55 Uhr

Unser Produkt FILLICO in der NDR Late Night Show:

In dieser Folge erörtert er mit Désirée Nick und Ralf Möller das Thema Luxus und die Frage: Wie viel Luxus brauchen wir? Wo beginnt Maßlosigkeit? Und wann ist das Maß überschritten? In Einspielfilmen und auf der Bühne bewegt sich Moderator Michel Abdollahi stets nah am Abgrund.

FILLICO
82015K

Wenn lieferbar, bitte benachrichtigen
ItemPackageQuantity
1
Verpackung
Glas
Art
Still
Füllmenge
720ml
Jahrgang
2019

Besondere Bestellnummern

16 andere Artikel in der gleichen Kategorie:

EVIAN | Ines Longevial 2018

FINE WATER

EVIAN |   Editionsjahrgang Ines Longevial 2018
Preis 22,50 €

MINUS 181 | BOX

FINE WATER

MINUS 181 - German Artesian Water
Preis 99,00 €

ISKILDE | still

FINE WATER

ISKILDE - Nordic Artesian, mehr als nur Wasser...
Preis 4,80 €

FILLICO | BLACK QUEEN

FINE WATER

FILLICO Das Jewelery Water aus Japan
Preis 999,00 €

VCH | Vichy Catalan

FINE WATER

VCH  |  Vichy Catalan, der Klassiker aus Barcelona
Preis 3,50 €

FIJI | 1l

FINE WATER

FIJI - EARTH'S FINEST WATER
Preis 4,00 €
NEVAS WATER | Paket N°1 NEVAS WATER | Paket N°1
  • -10%

NEVAS WATER | Paket N°1

FINE WATER

Das NEVASWATER Paket N°1
Verkaufspreis 99,00 € -10% Preis 89,10 €

EVIAN | Alexander Wang 2016

FINE WATER

EVIAN |   Editionsjahrgang Alexander Wang 2016
Preis 79,00 €

EVIAN | Jean Paul Gaultier...

FINE WATER

EVIAN |   Editionsjahrgang Jean Paul Gaultier 2009
Preis 59,00 €
EVIAN | new deal 17-19 EVIAN | new deal 17-19
  • -15,50 €
  • Artikelbündel

EVIAN | new deal 17-19

FINE WATER

EVIAN | new deal 17-19
Verkaufspreis 69,00 € -15,50 € Preis 53,50 €

NEVAS WATER | Magnum...

FINE WATER

NEVASWATER Der erste Quellwasser Cuvee
Preis 62,50 €
AQUAGEN | still AQUAGEN | still
  • Neu

AQUAGEN | still

FINE WATER

AQUAGEN - Das Tiefseewasser aus Taiwan.
Preis 3,50 €

LOFOTEN | still

FINE WATER

pur, arktisch und majestätisch
Preis 8,50 €

MINUS 181 | still

FINE WATER

MINUS 181 - German Artesian Water
Preis 29,00 €
Load Time17131 ms - You'd better run your shop on a toaster
Querying Time15747 ms
Queries841
Memory Peak Usage37.7 Mb
Included Files1499 files - 15.84 Mb
PrestaShop Cache0.01 Mb
Global vars1.28 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 48 ms 48 ms 5.14 Mb 5.31 Mb
__construct 0 ms 48 ms - Mb 5.31 Mb
init 15259 ms 15307 ms 5.90 Mb 11.24 Mb
checkAccess 0 ms 15307 ms - Mb 11.24 Mb
setMedia 12 ms 15319 ms 0.42 Mb 11.94 Mb
postProcess 0 ms 15319 ms - Mb 11.94 Mb
initHeader 0 ms 15319 ms - Mb 11.94 Mb
initContent 682 ms 16000 ms 7.79 Mb 19.53 Mb
initFooter 0 ms 16000 ms - Mb 19.53 Mb
display 1131 ms 17131 ms 17.85 Mb 37.74 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 841 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE id_address
FROM `ps_address`
WHERE  `id_customer` = 0 AND `alias` = 3390390 LIMIT 1
13243.9 1476953 /modules/shippingaddress/shippingaddress.php:402
SELECT SQL_NO_CACHE id_address
FROM `ps_address`
WHERE  `alias` = 3390390 LIMIT 1
1835.3 2953907 /modules/shippingaddress/shippingaddress.php:336
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log`
WHERE
`message` = 'Exception on hook displayProductExtraContent for module . Notice: Undefined index: date_start'
AND `severity` = '3'
AND `error_code` = '0'
AND `object_type` = ''
AND `object_id` = '' LIMIT 1
70.2 34457 /classes/PrestaShopLogger.php:198
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log`
WHERE
`message` = 'Exception on hook displayProductExtraContent for module . Notice: Undefined index: date_start'
AND `severity` = '3'
AND `error_code` = '0'
AND `object_type` = ''
AND `object_id` = '' LIMIT 1
34.7 34457 /classes/PrestaShopLogger.php:198
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2021-05-13 00:00:00",
INTERVAL 100 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
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_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  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 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` = 2)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`date_add` ASC
LIMIT 0,4
12.9 224 Yes /classes/Category.php:1047
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout
WHERE `hook_name` = "displayHeader"
AND `id_shop` =1
AND `status` = 1 LIMIT 1
11.6 19 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:63
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_facebook" LIMIT 1
10.4 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` = 58 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
10.1 3 Yes /classes/Category.php:783
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')
9.8 1 /classes/ObjectModel.php:559
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
9.5 18 Yes /modules/jxcategoryproducts/src/JXCategoryProductsRepository.php:102
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` = 39 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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
9.1 1 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE jxl.`id_layout`
FROM ps_jxmegalayout jxl
LEFT JOIN ps_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "product"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayHeader"
AND jxlp.`status` = 1 LIMIT 1
8.6 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347
INSERT INTO `ps_address`
SET `id_customer` = 0,
`alias` = 3390390,
`deleted` = 1,
`date_add` = "2021-05-13 02:00:30",
`date_upd` = "2021-05-13 02:00:30",
`lastname` = "-",
`firstname` = "-",
`address1` = "-",
`city` = "-",
`postcode` = "",
`id_state` = 0,
`id_country` = 1
8.1 1 /modules/shippingaddress/shippingaddress.php:366
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 1
7.9 7 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
7.7 6717 /classes/Configuration.php:160
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 22) LIMIT 1
7.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
7.2 1 /classes/module/Module.php:2786
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` = 168) AND (b.`id_shop` = 1) LIMIT 1
6.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_layout`, `layout_name`, `hook_name`, `status`
FROM ps_jxmegalayout
WHERE `id_shop` = 1
6.2 19 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:130
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` = 168) AND (b.`id_shop` = 1) LIMIT 1
6.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
6.2 7 /src/Adapter/EntityMapper.php:82
SHOW TABLES FROM `uw0fah6ohngov5fo`
5.9 1 /modules/amazon/common/tools.class.php:180
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
5.5 52 Yes /modules/jxmegamenu/src/JXMegaMenuRepository.php:205
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 232) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.3 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 204) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
5.2 1 /classes/stock/StockAvailable.php:760
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_item = 242 LIMIT 1
5.1 1 /classes/Pack.php:110
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` = 2)
WHERE i.`id_product` = 168
ORDER BY `position`
4.4 11 Yes /classes/Product.php:3059
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.3 545 Yes Yes /classes/Hook.php:670
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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
4 8 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 170) LIMIT 1
3.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 268) LIMIT 1
3.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` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3.8 244 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 168) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.8 1 /classes/stock/StockAvailable.php:760
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 196) LIMIT 1
3.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 128) LIMIT 1
3.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 129) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.5 1 /classes/stock/StockAvailable.php:444
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`)
3.4 134 /classes/Configuration.php:160
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 9
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
3.3 1 /classes/Category.php:1360
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
3.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` = 87 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
3.1 5 Yes /classes/Category.php:783
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('3390390', '286', '2886926340', '', '1', '1', '2021-05-13 02:00:32')
3 1 /classes/ObjectModel.php:559
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
SELECT SQL_NO_CACHE *
FROM `ps_jxmegalayout_items` a
WHERE (a.`id_item` = 10) LIMIT 1
2.3 1 /src/Adapter/EntityMapper.php:75
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` = 2 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
2.3 13 Yes /modules/ps_categorytree/ps_categorytree.php:149
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` = 242 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` = 242 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
2.2 0 /classes/Cart.php:1238
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` = 2 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` = 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_category_lang` cl
ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
WHERE product_shop.`id_shop` = 1
AND a.`id_product_pack` = 242
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
2.2 12 Yes /classes/Pack.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` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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_jxmegalayout_items
WHERE `id_layout` = 1
2.1 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
(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` = 2) 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` = 2) 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 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 168 LIMIT 1
2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 168 AND `id_shop` = 1
2 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` = 134 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.9 13 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 22
AND `active` = 1 LIMIT 1
1.7 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 219) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.7 1 /classes/stock/StockAvailable.php:760
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 39
ORDER BY `id_specific_price_priority` DESC LIMIT 1
1.6 1 /classes/SpecificPrice.php:246
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-13 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` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 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` = 2)
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` = 168 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.5 1 Yes /classes/Product.php:4031
INSERT INTO `ps_eventbus_incremental_sync` (`id_shop`, `id_object`, `type`, `created_at`, `lang_iso`) VALUES ('1', '', 'carts', '2021-05-13T02:00:30+02:00', 'de') ON DUPLICATE KEY UPDATE `id_shop` = '1',`id_object` = '',`type` = 'carts',`created_at` = '2021-05-13T02:00:30+02:00',`lang_iso` = 'de'
1.5 1 /modules/ps_eventbus/src/Repository/IncrementalSyncRepository.php:51
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
1.5 18 Yes /classes/Currency.php:492
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 231) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1.5 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (168)
1.4 1 /modules/ps_crossselling/ps_crossselling.php:251
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` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
1.4 244 Yes /classes/Country.php:147
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.4 0 /classes/Hook.php:194
(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` = 2) 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` = 2) 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)
1.3 1 /classes/CartRule.php:401
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
1.3 207 Yes /classes/Dispatcher.php:640
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `id_parent` = 0 LIMIT 1
1.3 1 /classes/Category.php:2206
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 7
1.3 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 13
1.3 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
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` = 2
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 *
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 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.2 56 Yes /classes/Manufacturer.php:207
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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 83) AND (b.`id_shop` = 1) LIMIT 1
1.2 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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 168
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
1.2 1 Yes Yes /classes/Product.php:2397
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` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 12
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.2 3 Yes Yes /classes/Category.php:909
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 = 2)
ORDER BY cl.id_category
1.2 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` = 140 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 24 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` = 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
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` = 64 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 13 Yes /classes/Category.php:783
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 = 2 AND sa.id_shop = 1 AND a.hook LIKE 'displayFooterProduct' AND (a.id_product = 0 OR a.id_product = 168) AND a.active = 1 ORDER BY a.id_product DESC
1.1 121 Yes /modules/creativeelements/classes/CEContent.php:150
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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 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` = 83 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 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` = 142 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.1 14 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.1 352 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE p.id_product
FROM ps_product p
WHERE p.active = 1
1.1 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` = 141 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 4 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` = 2) 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` = 2) 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 /classes/CartRule.php:401
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` = 2
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
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 168030201 AND name = '_elementor_edit_mode' LIMIT 1
1 1 /modules/creativeelements/classes/wrappers/Post.php:259
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` = 2
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 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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 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` = 135 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 10 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` = 2
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 COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 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` = 118 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 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` = 93 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 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` = 63 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 16 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 168 LIMIT 1
1 1 /classes/Product.php:847
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 160) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
1 1 /classes/stock/StockAvailable.php:788
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` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
1 0 /classes/tax/TaxRulesTaxManager.php:108
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` = 2
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 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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 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` = 105 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 119 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 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` = 13 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1 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` = 133 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 7 Yes /classes/Category.php:783
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 = 2 AND sa.id_shop = 1 AND a.hook LIKE 'displayAfterBodyOpeningTag' AND (a.id_product = 0 OR a.id_product = 168) AND a.active = 1 ORDER BY a.id_product DESC
0.9 121 Yes /modules/creativeelements/classes/CEContent.php:150
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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 130 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 138 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 * FROM `ps_state` ORDER BY `name` ASC
0.9 352 Yes /classes/Country.php:154
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` = 2
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_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` = 204) AND (b.`id_shop` = 1) LIMIT 1
0.9 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` = 136 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 *,
( 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` = 168 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.9 1 Yes /classes/SpecificPrice.php:620
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` = 2
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` = 109 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 86 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 56 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 123 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 121 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 59 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 106 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 129 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 120 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 6 Yes /classes/Category.php:783
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 168
0.9 1 /classes/Product.php:2473
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` = 2
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 jxl.`id_layout`
FROM ps_jxmegalayout jxl
LEFT JOIN ps_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "product"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayFooter"
AND jxlp.`status` = 1 LIMIT 1
0.9 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347
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` = 2
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 jxl.`id_layout`
FROM ps_jxmegalayout jxl
LEFT JOIN ps_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "product"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayFooterProduct"
AND jxlp.`status` = 1 LIMIT 1
0.9 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 231) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.9 1 /classes/stock/StockAvailable.php:760
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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 65 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.9 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` = 146 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 114 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 89 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 location
FROM `ps_stock_available`
WHERE (id_product = 231) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.8 1 /classes/stock/StockAvailable.php:788
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` = 2
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` = 101 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 75 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 26 Yes /classes/Category.php:783
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` = 127 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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.*, 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` = 2
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` = 94 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 97 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 144 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 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` = 2)
WHERE pl.`id_lang` = 2
AND pl.id_shop = 1 
AND p.`id_product` IN (242)
GROUP BY p.id_product LIMIT 1
0.8 0 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` = 139 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 107 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 69 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 168
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` = 126 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 124 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 *
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` = 168) 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` = 77 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 128 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 61 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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` = 79 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 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` = 2
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` = 82 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 value FROM ps_ce_meta WHERE id = 76020201 AND name = '_elementor_data' LIMIT 1
0.8 3 /modules/creativeelements/classes/wrappers/Post.php:259
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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 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` = 102 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 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` = 2
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 * FROM `ps_image_type`
0.8 9 /classes/ImageType.php:147
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 76020201 AND name = '_elementor_data' LIMIT 1
0.8 3 /modules/creativeelements/classes/wrappers/Post.php:259
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` = 168
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.8 1 Yes Yes /classes/Product.php:3942
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 168 LIMIT 1
0.8 1 /classes/SpecificPrice.php:416
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` = 242) 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` = 81 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 2
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 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` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7 24 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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 168
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 depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 231) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:735
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 3390390
AND `date_add` > '2021-05-13 01:30:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.7 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE *
FROM ps_jxcategoryproducts jxcp
JOIN ps_jxcategoryproducts_lang jxcpl
ON jxcp.id_tab = jxcpl.id_tab
AND jxcpl.id_lang = 2
AND jxcp.id_shop = 1 AND `active` = 1 ORDER BY `sort_order`
0.7 1 Yes /modules/jxcategoryproducts/src/JXCategoryProductsRepository.php:144
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 168030201 AND name = '_wp_page_template' LIMIT 1
0.7 1 /modules/creativeelements/classes/wrappers/Post.php:259
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 204) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer_lang`
WHERE `id_manufacturer` = 22
0.7 7 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 22) LIMIT 1
0.7 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` = 204 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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.7 3 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 76020201 AND name = '_elementor_edit_mode' LIMIT 1
0.7 3 /modules/creativeelements/classes/wrappers/Post.php:259
SELECT SQL_NO_CACHE jxm.*, jxml.`title`, jxml.`description`
FROM `ps_jxmegamenu_map` jxm
LEFT JOIN `ps_jxmegamenu_map_lang` jxml
ON (jxm.`id_item` = jxml.`id_item`)
WHERE jxm.`id_shop` = 1
AND jxml.`id_lang` = 2
0.7 1 /modules/jxmegamenu/src/MegaMenuMap.php:71
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.7 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:120
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` = 2 LIMIT 1
0.7 1 /modules/jxmegalayout/classes/extra/JXMegaLayoutExtraBanner.php:74
SELECT SQL_NO_CACHE jxl.`id_layout`
FROM ps_jxmegalayout jxl
LEFT JOIN ps_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "subpages"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayFooterProduct"
AND jxlp.`status` = 1 LIMIT 1
0.7 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
0.7 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-13 00:00:00',
INTERVAL 100 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 40
0.7 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `name`
FROM `ps_country_lang`
WHERE `id_lang` = 2
AND `id_country` = 1 LIMIT 1
0.7 1 /classes/Country.php:251
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout
WHERE `hook_name` = "displayFooter"
AND `id_shop` =1
AND `status` = 1 LIMIT 1
0.7 19 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:63
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
0.7 1 /src/Adapter/Module/ModuleDataProvider.php:174
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` = 242 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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.7 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` = 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-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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 out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 168) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:760
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-13 00:00:00',
INTERVAL 100 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 42
0.6 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE psgdprl.message FROM `ps_psgdpr_consent` psgdpr
LEFT JOIN ps_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 1 AND psgdprl.id_lang =2 LIMIT 1
0.6 6 /modules/psgdpr/classes/GDPRConsent.php:111
SELECT SQL_NO_CACHE jxl.`id_layout`
FROM ps_jxmegalayout jxl
LEFT JOIN ps_jxmegalayout_pages jxlp
ON(jxl.`id_layout` = jxlp.`id_layout`)
WHERE jxlp.`page_name` = "subpages"
AND jxl.`id_shop` = 1
AND jxl.`hook_name` = "displayFooter"
AND jxlp.`status` = 1 LIMIT 1
0.6 1 /modules/jxmegalayout/classes/JXMegaLayoutLayouts.php:347
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2021-05-13 00:00:00',
INTERVAL 100 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 2
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 41
0.6 2 /classes/ProductAssembler.php:90
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
0.6 4 Yes /classes/shop/Shop.php:345
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1
0.6 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
0.6 1 /classes/module/Module.php:2786
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` = 168 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` = 168 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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 141) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
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` = 168
0.6 1 /classes/Product.php:6285
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` = 129) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 ('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 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` = 39 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` = 39 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 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.6 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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 40) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 168) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 /classes/stock/StockAvailable.php:788
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.6 14 Yes /modules/jxmanufacturerblock/src/JXManufacturersPresenter.php:44
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "a60da06dbdcc9903b139bc35325d06f8") LIMIT 1
0.6 1 /modules/trustedshopsintegration/trustedshopsintegration.php:650
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.6 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "trustedshopsintegration" LIMIT 1
0.6 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.6 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 168
0.6 1 /classes/Pack.php:160
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.6 135 /classes/module/Module.php:307
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` = 2
AND jx.`active` = 1
ORDER BY jx.`sort_order`
0.6 83 Yes /modules/jxmegamenu/src/MegaMenu.php:159
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.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.6 375 /classes/SpecificPrice.php:291
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` = 42) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 83 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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 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` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 168
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 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` = 39)
0.6 1 /classes/Product.php:3364
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "braintreeofficial" LIMIT 1
0.6 0 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE jeh.*, jehl.*
FROM ps_jxmegalayout_extra_html jeh
LEFT JOIN ps_jxmegalayout_extra_html_lang jehl
ON(jeh.`id_extra_html` = jehl.`id_extra_html`)
WHERE jeh.`id_extra_html` = 6
AND jehl.`id_lang` = 2 LIMIT 1
0.6 1 /modules/jxmegalayout/classes/extra/JXMegaLayoutExtraHtml.php:71
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 76020201 AND name = '_elementor_css' LIMIT 1
0.6 3 /modules/creativeelements/classes/wrappers/Post.php:259
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.6 248 /classes/Tab.php:320
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 5 AND `id_object` = 168 LIMIT 1
0.6 1 /classes/Page.php:83
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` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 134) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 242 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` = 242 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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE value FROM ps_ce_meta WHERE id = 76020201 AND name = '_elementor_edit_mode' LIMIT 1
0.6 3 /modules/creativeelements/classes/wrappers/Post.php:259
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.5 135 /classes/module/Module.php:307
SELECT SQL_NO_CACHE `value`
FROM `ps_jxmanufacturers_settings`
WHERE `hook_name` = 'displayHome'
AND `setting_name` = 'JX_MANUFACTURER_ORDER'
AND `id_shop` = 1 LIMIT 1
0.5 16 /modules/jxmanufacturerblock/src/JXManufacturersSettingsRepository.php:81
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 168 LIMIT 1
0.5 1 /classes/Pack.php:401
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` = 2
AND cl.`id_shop` = 1
LIMIT 0 , 1
0.5 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 16 LIMIT 1
0.5 6 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.5 4 Yes /classes/shop/Shop.php:705
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` = 205 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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 *
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` = 168) 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` = 242) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.`id_jxblog_post`, pl.`name`, pl.`link_rewrite`
FROM `ps_jxblog_product_post` pp
LEFT JOIN `ps_jxblog_post` p
ON(p.`id_jxblog_post` = pp.`id_jxblog_post`)
LEFT JOIN `ps_jxblog_post_lang` pl
ON(p.`id_jxblog_post` = pl.`id_jxblog_post` AND pl.`id_lang` = 2)
WHERE pp.`id_product` = 168
0.5 51 /modules/jxblogpostproducts/src/JXBlogPostProductsRepository.php:175
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.5 1 /classes/shop/Shop.php:1164
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-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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 `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
0.5 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE *
FROM ps_jxmegalayout_items
WHERE `id_layout` = 16
0.5 315 /modules/jxmegalayout/classes/JXMegaLayoutItems.php:96
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` = 168 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-13 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 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` = 2
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 `id_module` FROM `ps_module` WHERE `name` = "jxsearch" LIMIT 1
0.5 1 /classes/module/Module.php:2786