Broscuta muzicala Baby Neptune Baby Einstein-Bright Starts


Bright Starts-90574

BRIGHT STARTS

Referinte specifice

159,00 lei
cu TVA
Stoc epuizat





Cantitate:

Cei mici vor compune propria lor simfonie de melodii, alaturi de Broscuta muzicala Baby Neptune, cea care va coordona Orchestra Oceanului.

Caracteristici:

  • Broscuta va dezvalui doua modalitati de joaca:
  • 1. Prin apasarea unui buton se vor activa sunetele diferitelor intrumente (tobe, harpa, pian, xylofon etc). In aceasta varianta cel mic va deveni compozitor si va crea propria simfonie.
  • 2. Cand va dori cel mic va putea asculta 8 melodii clasice si isi va alege preferata.
  • De asemenea, Broscuta va activa si lumini de fiecare data cand butonul cu instrumentul respectiv - va fi activat.
  • Despre Baby Einstein: Istoria Baby Einstein a inceput in urma cu peste 15 ani. cand o mamica ambitioasa si-a propus sa ii transmita bebelusului ei dragostea sa pentru arta si muzica. Produsele au evoluat de-a lungul timpului, insa fara a-si pierde farmecul si caracteristicile inconfundabile. Ce le deosebeste de alte jucarii? Faptul ca acestea au fost create din perspectiva bebelusilor! Fiecare jucarie Baby Einstein dezvolta o combinatie unica de obiecte, muzica, arta, limbaj, forme, numere si natura, iar bebelusii adora sa descopere fiecare activitate si sa devina la randul lor un 'Baby Einstein'! Melodiile alese pentru jucariile Baby Einstein sunt linistitoare si stimulative, iar imaginile viu colorate si texturile diferite ale jucariilor ii vor ajuta pe bebelusi la stimularea vizuala si tactila. Toate aceste caracteristici unice, fac ca jucariile Baby Einstein sa fie perfecte pentru primii ani de viata ai micutului.
Producator Bright Starts
Specificatii
Dimensiuni: 20.3 cm x 23.2 cm x 27.9 cm
Varsta: 3 -36 luni


Bright Starts-90574

BRIGHT STARTS

Referinte specifice

Load Time3858 ms - You'd better run your shop on a toaster
Querying Time1703 ms
Queries1236
Memory Peak Usage53.2 Mb
Included Files1018 files - 9.56 Mb
PrestaShop Cache- Mb
Global vars0.07 Mb
PrestaShop Version1.7.6.5
PHP Version7.2.34 (OK)
MySQL Version5.7.33-cll-lve (OK)
Memory Limit512M
Max Execution Time300s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 1777 ms 1777 ms 24.88 Mb 26.38 Mb
__construct 0 ms 1777 ms - Mb 26.38 Mb
init 265 ms 2042 ms 4.28 Mb 29.18 Mb
checkAccess 0 ms 2042 ms - Mb 29.18 Mb
setMedia 8 ms 2050 ms 0.18 Mb 29.88 Mb
postProcess 0 ms 2050 ms - Mb 29.88 Mb
initHeader 0 ms 2050 ms - Mb 29.88 Mb
initContent 275 ms 2325 ms 3.48 Mb 32.87 Mb
initFooter 0 ms 2325 ms - Mb 32.87 Mb
display 1533 ms 3858 ms 20.00 Mb 53.21 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 1236 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE *
FROM `ps_an_productfields_product` a0
WHERE (a0.`id_product` = 15538) AND (a0.`is_enabled` = 1)
ORDER BY a0.`position` asc
622.5 147697 Yes /classes/PrestaShopCollection.php:381
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`
102.1 1296 Yes Yes /classes/Hook.php:670
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` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 15
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
59.7 5 Yes Yes /classes/Category.php:909
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
25.8 1 Yes /classes/shop/Shop.php:705
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
21.4 2 /classes/Language.php:911
INSERT IGNORE INTO `ps_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('126568', '1805', '2021-05-10 08:33:05')
17.5 1 /classes/Connection.php:122
UPDATE ps_kb_top_visited SET visits =74 WHERE id_product = 15538
15.4 1 /modules/kbrelatedproducts/kbrelatedproducts.php:1346
INSERT INTO `ps_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('1', '1', '0', '0', '0', '1', '0', '0', '1', '0', '0', '', '0', '', '', '0', '2021-05-10 08:33:04', '2021-05-10 08:33:04')
14.8 1 /classes/ObjectModel.php:559
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')
14.4 1 /classes/ObjectModel.php:559
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
14.3 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 5 AND `id_object` = 15538 LIMIT 1
13.7 1 /classes/Page.php:83
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
11.3 49 Yes /classes/Dispatcher.php:640
SELECT SQL_NO_CACHE * FROM `ps_spfooterlinks` b
LEFT JOIN `ps_spfooterlinks_shop` bs ON (b.`id_spfooterlinks` = bs.`id_spfooterlinks`)
LEFT JOIN `ps_spfooterlinks_lang` bl ON (b.`id_spfooterlinks` = bl.`id_spfooterlinks`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1)
AND (bl.`id_lang` = 1)
AND b.`hook` = 570 ORDER BY b.`ordering`
10.5 3 Yes /modules/spfooterlinks/spfooterlinks.php:715
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('189424', '1805', '65973713', '', '1', '1', '2021-05-10 08:33:05')
10.5 1 /classes/ObjectModel.php:559
INSERT INTO `ps_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('633', '1805', '1', '1', '1')
9 1 /classes/Page.php:142
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 189424
AND `date_add` > '2021-05-10 08:03:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
7.8 1 Yes /classes/Connection.php:163
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 = 'alinut.ro' OR su.domain_ssl = 'alinut.ro')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
7.4 1 Yes /classes/shop/Shop.php:345
UPDATE `ps_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 633
AND `id_page` = 1805
AND `id_shop` = 1
7.2 1 /classes/Page.php:131
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `ps_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `ps_date_range`) LIMIT 1
6.2 350464 /classes/DateRange.php:60
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
5.9 955 /classes/Configuration.php:160
SELECT SQL_NO_CACHE `id_similar_product`
FROM `ps_cdcompare_similar_product`
WHERE `id_product` = 15538
GROUP BY `id_similar_product`
ORDER BY `position` ASC
5.3 1 Yes Yes /modules/cdproductcomparisonplus/classes/CdSimilarProduct.php:107
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")
WHERE 1  AND cl.`id_lang` = 1
AND (c.`active` = 1 OR c.`is_root_category` = 1)
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
4.7 320 Yes /modules/spsearchpro/spsearchpro.php:693
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
4.2 1 /classes/Page.php:104
SELECT SQL_NO_CACHE * FROM `ps_spcustomhtml` b
LEFT JOIN `ps_spcustomhtml_shop` bs ON (b.`id_spcustomhtml` = bs.`id_spcustomhtml`)
LEFT JOIN `ps_spcustomhtml_lang` bl ON (b.`id_spcustomhtml` = bl.`id_spcustomhtml`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1)
AND (bl.`id_lang` = 1)
AND b.`hook` = 523 ORDER BY b.`ordering`
3.8 21 Yes /modules/spcustomhtml/spcustomhtml.php:1125
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 15538 AND ctg.`id_group` = 1 LIMIT 1
3.3 3 /override/classes/Product.php:5580
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
3.2 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2.9 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
2.9 0 /classes/Hook.php:194
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
2.9 83 /classes/Hook.php:264
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-10 00:00:00",
INTERVAL 31 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 15538 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2.8 6 Yes Yes /override/classes/Product.php:4035
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 296 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.6 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM `ps_spcustomhtml` b
LEFT JOIN `ps_spcustomhtml_shop` bs ON (b.`id_spcustomhtml` = bs.`id_spcustomhtml`)
LEFT JOIN `ps_spcustomhtml_lang` bl ON (b.`id_spcustomhtml` = bl.`id_spcustomhtml`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1)
AND (bl.`id_lang` = 1)
AND b.`hook` = 525 ORDER BY b.`ordering`
2.6 21 Yes /modules/spcustomhtml/spcustomhtml.php:1125
SELECT SQL_NO_CACHE * FROM `ps_spcustomhtml` b
LEFT JOIN `ps_spcustomhtml_shop` bs ON (b.`id_spcustomhtml` = bs.`id_spcustomhtml`)
LEFT JOIN `ps_spcustomhtml_lang` bl ON (b.`id_spcustomhtml` = bl.`id_spcustomhtml`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1)
AND (bl.`id_lang` = 1)
AND b.`hook` = 526 ORDER BY b.`ordering`
2.4 21 Yes /modules/spcustomhtml/spcustomhtml.php:1125
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
2.3 445 /classes/Hook.php:407
SELECT SQL_NO_CACHE visits FROM ps_kb_top_visited where id_product = 15538 LIMIT 1
2.3 5077 /modules/kbrelatedproducts/kbrelatedproducts.php:1342
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 116 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2.1 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.1 1496 /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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
2 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 117 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.9 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.9 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 115 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.9 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE k.id_product as id FROM ps_product k INNER JOIN `ps_stock_available` p ON (k.id_product=p.id_product) where p.id_product_attribute=0 AND p.quantity>0 AND k.id_category_default=15 and k.id_product !=15538 limit 5
1.8 74 /modules/kbrelatedproducts/kbrelatedproducts.php:3763
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.8 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 143) AND (a0.`nright` > 190) AND (a1.`id_lang` = 1)
ORDER BY a0.`nleft` asc
1.7 320 Yes /classes/PrestaShopCollection.php:381
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 145 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 152 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 122 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 154 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 147 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 41 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 150 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.6 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM ps_sfkproducttab WHERE sfk_status=1 AND sfk_product='15538'
1.6 506 /modules/sfkproducttab/sfkproducttab.php:166
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 299 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 148 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 310 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes Yes /classes/Category.php:783
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` = 1 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` <= 6
AND nleft >= 143 AND nright <= 190
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
1.5 301 Yes /modules/ps_categorytree/ps_categorytree.php:149
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 149 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 224 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 226 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 36 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 151 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 90 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 43 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 227 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 39 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 38 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 40 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 298 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 304 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 230 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.5 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 228 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 225 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 229 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 44 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 300 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 91 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 37 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 42 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 231 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 60 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes Yes /classes/Category.php:783
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` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 15538
1.4 1 /override/classes/Product.php:6289
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 68 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 67 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 291 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 74 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 153 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.4 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 92 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.3 320 Yes 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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
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` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.3 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE * FROM `ps_spcustomhtml` b
LEFT JOIN `ps_spcustomhtml_shop` bs ON (b.`id_spcustomhtml` = bs.`id_spcustomhtml`)
LEFT JOIN `ps_spcustomhtml_lang` bl ON (b.`id_spcustomhtml` = bl.`id_spcustomhtml`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1)
AND (bl.`id_lang` = 1)
AND b.`hook` = 527 ORDER BY b.`ordering`
1.3 21 Yes /modules/spcustomhtml/spcustomhtml.php:1125
SELECT SQL_NO_CACHE * FROM `ps_spcustomhtml` b
LEFT JOIN `ps_spcustomhtml_shop` bs ON (b.`id_spcustomhtml` = bs.`id_spcustomhtml`)
LEFT JOIN `ps_spcustomhtml_lang` bl ON (b.`id_spcustomhtml` = bl.`id_spcustomhtml`)
WHERE bs.`active` = 1 AND (bs.`id_shop` = 1)
AND (bl.`id_lang` = 1)
AND b.`hook` = 511 ORDER BY b.`ordering`
1.3 21 Yes /modules/spcustomhtml/spcustomhtml.php:1125
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 73 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.3 320 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 15538
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.3 1 Yes Yes /override/classes/Product.php:3946
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1.2 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1.2 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1.2 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 15538
ORDER BY f.position ASC
1.2 1 Yes /override/classes/Product.php:5024
SELECT SQL_NO_CACHE m.*, ml.title,ml.sub_title, ml.html, ml.url, ml.short_description, ml.label
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1 WHERE id_parent=1 AND m.`active`=1  AND m.`id_spverticalmenu_group`=1 ORDER BY `position`
1.2 197 Yes /modules/spverticalmenu/Verticalmenu.php:145
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.1 366 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1.1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1.1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1.1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE *
FROM `ps_an_productfields` a0
LEFT JOIN `ps_an_productfields_lang` `a1` ON (a0.`id_an_productfields` = a1.`id_an_productfields`)
WHERE (a0.`is_enabled` = 1) AND (a0.`categories` != '') AND (a1.`id_lang` = 1)
ORDER BY a0.`sort_order` asc
1.1 12 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1.1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1.1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE *
FROM `ps_an_productfields` a0
LEFT JOIN `ps_an_productfields_lang` `a1` ON (a0.`id_an_productfields` = a1.`id_an_productfields`)
WHERE (a0.`is_enabled` = 1) AND (a0.`apply_for_all_products` = 1) AND (a1.`id_lang` = 1)
ORDER BY a0.`sort_order` asc
1.1 12 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 343
1.1 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
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` = 15538 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` = 15538 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE c.id_cms, cl.link_rewrite, cl.meta_title
FROM ps_cms c
LEFT JOIN ps_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 1)
INNER JOIN ps_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE 1
AND c.id_cms IN (16) AND c.`active` = 1 GROUP BY c.id_cms
ORDER BY c.`position`
1 1 Yes /classes/CMS.php:151
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` = 15538) AND (b.`id_shop` = 1) LIMIT 1
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 341
1 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 340
1 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
1 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 346
1 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 36, 4, 0) +  IF (`id_shop` = 1, 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, 1) AND
`id_country` IN (0, 36) AND
`id_group` IN (0, 1) AND `id_product` = 15538 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-05-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-05-10 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
1 1 Yes /classes/SpecificPrice.php:620
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 344
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE * FROM `ps_an_productfields_shop`
WHERE `id_shop` = 1
ORDER BY `id_an_productfields`
0.9 12 /modules/an_productfields/classes/AnProductFieldsProduct.class.php:105
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 345
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 342
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2021-05-10 00:00:00" AND date_to <= "2021-05-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2021-05-10 00:00:00" AND date_from <= "2021-05-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2021-05-10 00:00:00" AND date_to > "2021-05-10 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.9 1 /classes/CartRule.php:342
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` = 36
AND tr.`id_tax_rules_group` = 59
AND tr.`id_state` IN (0, 354)
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.9 2 Yes /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 350
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 379
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 352
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 354
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 349
0.9 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.9 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 369
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
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 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 26 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.8 8 Yes Yes /classes/Category.php:783
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 297
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 359
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 366
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 313
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title,ml.sub_title, ml.html, ml.url, ml.short_description, ml.label
FROM ps_spmegamenu m
LEFT JOIN ps_spmegamenu_lang ml ON m.id_spmegamenu = ml.id_spmegamenu AND ml.id_lang = 1 JOIN ps_spmegamenu_shop ms ON m.id_spmegamenu = ms.id_spmegamenu AND ms.id_shop = 1 WHERE id_parent=1 AND m.`active`=1  AND m.`id_spmegamenu_group`=1 ORDER BY `position`
0.8 8 Yes /modules/spmegamenu/Megamenu.php:143
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 353
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 367
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 348
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 398
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 401
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 402
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
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` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.8 26 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 304
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 358
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 321
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 363
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 347
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 316
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 362
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 324
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title,ml.sub_title, ml.html, ml.url, ml.short_description, ml.label
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1 WHERE id_parent=339 AND m.`active`=1  AND m.`id_spverticalmenu_group`=1 ORDER BY `position`
0.8 197 Yes /modules/spverticalmenu/Verticalmenu.php:145
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 403
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 299
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 302
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:81
SELECT SQL_NO_CACHE `key`, `translation`, `domain`
FROM `ps_translation`
WHERE `id_lang` = 1
AND theme = 'sp_shopping'
0.8 162 /src/PrestaShopBundle/Translation/Loader/SqlTranslationLoader.php:90
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 365
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 310
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 364
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276
SELECT SQL_NO_CACHE m.*, ml.title, ml.sub_title , ml.html, ml.url
FROM ps_spverticalmenu m
LEFT JOIN ps_spverticalmenu_lang ml ON m.id_spverticalmenu = ml.id_spverticalmenu AND ml.id_lang = 1 JOIN ps_spverticalmenu_shop ms ON m.id_spverticalmenu = ms.id_spverticalmenu AND ms.id_shop = 1
WHERE m.id_parent = 325
0.8 197 /modules/spverticalmenu/Verticalmenu.php:276