KAMP ÇADIRLARI

10 adet ürün var.

Toplam 10 üründen 1-10 arası gösteriliyor

Aktif filtreler

  • Renk: Bordo
  • Renk: Haki
  • Renk: Lila
  • Renk: Pembe
  • Renk: Su Yeşili
  • Renk: Vişne
  • Renk: Yeşil

Yeni hesap oluştur

Üye misiniz?
Giriş Yapın Veya Şifreyi yenile
Load Time2005 ms - You'd better run your shop on a toaster
Querying Time469 ms
Queries324
Memory Peak Usage38.9 Mb
Included Files528 files - 8.08 Mb
PrestaShop Cache- Mb
Global vars0.18 Mb
PrestaShop Version1.7.5.0
PHP Version7.2.34 (OK)
MySQL Version10.11.13-MariaDB-log (OK)
Memory Limit1024M
Max Execution Time3000s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 260 ms 260 ms 14.81 Mb 15.05 Mb
__construct 0 ms 260 ms - Mb 15.05 Mb
init 332 ms 592 ms 4.39 Mb 19.64 Mb
checkAccess 0 ms 592 ms - Mb 19.64 Mb
setMedia 5 ms 597 ms 0.13 Mb 19.64 Mb
postProcess 0 ms 597 ms - Mb 19.64 Mb
initHeader 0 ms 597 ms - Mb 19.64 Mb
initContent 1028 ms 1625 ms 13.57 Mb 32.95 Mb
initFooter 0 ms 1625 ms - Mb 32.95 Mb
display 379 ms 2005 ms 5.52 Mb 38.85 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 324 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 212
38.9 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
34.4 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77
SELECT SQL_NO_CACHE *
FROM `ps_arcontactus` t
LEFT JOIN ps_arcontactus_lang l ON l.id_contactus = t.id_contactus
WHERE (l.id_lang = 7 AND t.status = 1 AND (always = 1 OR d7 = 1) AND ((time_from <= '01:16:19' AND time_to >= '01:16:19') OR always = 1) AND (registered_only IN (0, 2) OR registered_only IS NULL))
ORDER BY position ASC
32.1 8 Yes /modules/arcontactus/classes/ArContactUsTable.php:167
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 149 LIMIT 1
26.7 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
FROM ps_category_product cp
LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog")
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 7) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 3
AND c.nright < 24
AND c.level_depth <= 3
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
16.3 32 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
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`
15.9 256 Yes Yes /classes/Hook.php:666
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 18 AND ctg.`id_group` = 1 LIMIT 1
13.7 1 /classes/Category.php:1654
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 217
13.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leoquicklogin" LIMIT 1
12.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 210
11.4 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (154) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
11.4 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
11 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE *
FROM `ps_arcontactus_prompt` t
LEFT JOIN ps_arcontactus_prompt_lang l ON l.id_prompt = t.id_prompt
WHERE (l.id_lang = 7 AND t.status = 1)
ORDER BY position ASC
10.7 3 Yes /modules/arcontactus/classes/ArContactUsPromptTable.php:64
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 18
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
10.3 6 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1718
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
8.7 75 /classes/module/Module.php:305
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 62 AND `id_shop` = 1 LIMIT 1
8.6 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 149
5.9 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (149) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
5.6 1 Yes Yes /classes/Product.php:3860
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.2 1948 /classes/Configuration.php:160
SELECT SQL_NO_CACHE p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2025-08-03 00:00:00", INTERVAL 2000 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM  ((SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category = 18
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY cp.id_product) UNION ALL (SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category != 18
AND c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE NOT EXISTS(SELECT * FROM ps_category_product cpe 
WHERE cp.id_product=cpe.id_product AND cpe.id_category = 18)
AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY cp.id_product)) cp
LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 7)
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` = 7)
LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.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 product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY cp.position asc , cp.id_product LIMIT 0,12
5 724451328 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1630
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 211 LIMIT 1
4.3 1 /classes/AddressFormat.php:618
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
4.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 154
3.8 1 /src/Adapter/Database.php:48
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1275086', '28', '3628718326', '', '1', '1', '2025-08-03 01:16:20')
3.7 1 /classes/ObjectModel.php:551
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
3.5 1 /classes/shop/Shop.php:1160
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
3.4 83 /classes/Hook.php:260
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', '', '0')
3.4 1 /classes/ObjectModel.php:551
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
3.4 75 /classes/module/Module.php:305
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (217) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3.2 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
2.9 1 /classes/Cart.php:4013
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 1275086
AND `date_add` > '2025-08-03 00:46:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
2.8 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE COUNT(*) FROM  ((SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category = 18
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY cp.id_product) UNION ALL (SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.id_category != 18
AND c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE NOT EXISTS(SELECT * FROM ps_category_product cpe 
WHERE cp.id_product=cpe.id_product AND cpe.id_category = 18)
AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY cp.id_product)) ps LIMIT 1
2.7 724451328 /modules/ps_facetedsearch/ps_facetedsearch.php:1595
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
2.6 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (224) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2.3 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 7) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 7 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY fv.id_feature_value
2.2 51408 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 7) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 6 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY fv.id_feature_value
2.1 53244 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 5 AND psi.id_shop=1)LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39)
2.1 22032 /modules/ps_facetedsearch/ps_facetedsearch.php:1977
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.1 256 /classes/Hook.php:403
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 7) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 3
GROUP BY fv.id_feature_value
2.1 1296 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 7) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 3
GROUP BY fv.id_feature_value
2 1296 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
FROM (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1 AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
GROUP BY p.id_manufacturer ORDER BY m.name
2 1836 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE c.id_category, c.id_parent, cl.name, (SELECT count(DISTINCT p.id_product) # 
FROM ps_category_product cp
LEFT JOIN ps_product p ON (p.id_product = cp.id_product)  INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE cp.id_category = c.id_category
AND product_shop.active = 1 AND product_shop.`visibility` IN ("both", "catalog") AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = 37 OR fp.`id_feature_value` = 26 OR fp.`id_feature_value` = 21 OR fp.`id_feature_value` = 24 OR fp.`id_feature_value` = 36 OR fp.`id_feature_value` = 30 OR fp.`id_feature_value` = 39) 
) count_products
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.`id_shop` = 1 and cl.id_lang = 7) RIGHT JOIN ps_category_group cg ON (cg.id_category = c.id_category AND cg.`id_group` IN (1)) WHERE c.nleft > 3
AND c.nright < 24
AND c.level_depth <= 3
AND c.active = 1
GROUP BY c.id_category ORDER BY c.nleft, c.position
1.9 544 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
1.9 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 7) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 6
GROUP BY fv.id_feature_value
1.8 3132 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
1.8 1 /classes/Page.php:100
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM ps_feature_product fp
INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
ON p.id_product = fp.id_product
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 7)
INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 7)
LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 7) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 7
GROUP BY fv.id_feature_value
1.7 3024 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 7 AND `id_object` = 18 LIMIT 1
1.6 1 /classes/Page.php:80
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
INNER JOIN `ps_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 5 AND psi.id_shop=1)LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
1.5 1296 /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
FROM (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 3
AND c.nright <= 24
AND c.active = 1)
STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")) p
INNER JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
GROUP BY p.id_manufacturer ORDER BY m.name
1.4 108 Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1977
SELECT SQL_NO_CACHE page from `ps_appagebuilder_page` where id_category = '18' AND id_shop = '1' LIMIT 1
1.4 9 /modules/appagebuilder/appagebuilder.php:3092
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 34) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
1.3 156 Yes /classes/Dispatcher.php:634
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
1.2 0 /classes/Hook.php:190
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leoproductsearch" LIMIT 1
1.1 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
1.1 7 Yes /classes/ImageType.php:109
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` = 7  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 18
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.1 25 Yes Yes /classes/Category.php:872
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 44) AND (b.`id_shop` = 1) LIMIT 1
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `iso_code`
FROM `ps_country`
WHERE `id_country` = 211 LIMIT 1
1 1 /classes/Country.php:272
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
0.9 1 /classes/ObjectModel.php:1453
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 39) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 36) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "appagebuilder" LIMIT 1
0.8 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 211) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'uludagcadircom_x'
AND TABLE_NAME='ps_btmegamenu_lang'
0.7 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1394
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'uludagcadircom_x'
AND TABLE_NAME='ps_btmegamenu_lang'
0.7 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1394
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 145
ORDER BY f.position ASC
0.7 9 Yes /classes/Product.php:4952
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.7 1 Yes /classes/shop/Shop.php:704
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 157
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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` = 145 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` = 145 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
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` = 210 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` = 210 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
0.6 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'uludagcadircom_x'
AND TABLE_NAME='ps_btmegamenu_lang'
AND COLUMN_NAME ='url'
0.6 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1359
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.6 75 /classes/module/Module.php:305
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` = 153 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` = 153 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 149
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang
FROM ps_appagebuilder p
LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1)
LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder)
WHERE
pl.id_lang=7
AND ps.id_shop=1
AND p.id_appagebuilder_positions IN (19,20,21,18)
ORDER BY p.id_appagebuilder
0.6 80 /modules/appagebuilder/classes/ApPageBuilderModel.php:303
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` = 233 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` = 233 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 153
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 210
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 224
0.6 1 /classes/ProductAssembler.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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 210
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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` = 217 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` = 217 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 224
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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` = 149 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` = 149 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 217
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 233
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 212
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 154
0.6 1 /classes/ProductAssembler.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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 154
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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 = 7)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
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 = 153
ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4952
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` = 212 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` = 212 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 38) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 149
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 145
0.6 1 /classes/ProductAssembler.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` = 157 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` = 157 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
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` = 224 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` = 224 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 157
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'uludagcadircom_x'
AND TABLE_NAME='ps_btmegamenu_lang'
AND COLUMN_NAME ='url'
0.6 0 /modules/leobootstrapmenu/leobootstrapmenu.php:1359
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 212
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 217
0.6 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (210) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (212) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 61 AND `id_shop` = 1 LIMIT 1
0.5 1 /classes/module/Module.php:2277
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` = 154 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` = 154 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-08-03 00:00:00',
INTERVAL 2000 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 233
0.5 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (153) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (233) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 211
0.5 8 /src/Adapter/EntityMapper.php:82
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 149) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 30) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 217) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 145) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 153) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 224) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 210
ORDER BY `position`
0.5 8 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (157) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 154) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (145) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 210) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 157) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 145
ORDER BY `position`
0.5 10 Yes /classes/Product.php:3042
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 233) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 154
ORDER BY `position`
0.4 7 Yes /classes/Product.php:3042
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` = 7
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 212) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 217
ORDER BY `position`
0.4 6 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 217
0.4 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 149
ORDER BY `position`
0.4 8 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 212
ORDER BY `position`
0.4 6 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 233
ORDER BY `position`
0.4 8 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 224
ORDER BY `position`
0.4 6 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 157
ORDER BY `position`
0.4 9 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 157 LIMIT 1
0.4 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 210
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 153
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=7
0.4 8 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.4 4 /classes/Language.php:1029
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 149
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 7) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 145
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 154
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 217
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=7
0.4 8 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115
SELECT SQL_NO_CACHE p.*, ps.*,pl.friendly_url
FROM ps_appagebuilder_profiles p
INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=1 AND id_lang=7
0.4 8 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:115
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 153
ORDER BY `position`
0.4 3 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 224
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE p.`id_appagebuilder_profiles` FROM `ps_appagebuilder_profiles` p INNER JOIN `ps_appagebuilder_profiles_lang` pl ON(pl.id_appagebuilder_profiles = p.id_appagebuilder_profiles AND pl.friendly_url='18-kamp-cadirlari' AND id_lang=7 )  INNER JOIN `ps_appagebuilder_profiles_shop` ps ON(ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles AND ps.id_shop =1) LIMIT 1
0.4 8 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:389
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.4 159 /classes/Tab.php:318
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 233
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 3) AND (a0.`nright` > 24) AND (a1.`id_lang` = 7)
ORDER BY a0.`nleft` asc
0.4 6 /classes/PrestaShopCollection.php:373
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE id_category = 18
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.4 6 Yes Yes /modules/ps_facetedsearch/ps_facetedsearch.php:1718
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 = 'uludagcadir.com.tr' OR su.domain_ssl = 'uludagcadir.com.tr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.4 1 Yes /classes/shop/Shop.php:345
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.3 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 157
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 145)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 7
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 211) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 212
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.3 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 217)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 149)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 224)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 210)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 212)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 157)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 153)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 233)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 154)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 210
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE p.*, pl.* from `ps_appagebuilder_profiles` p  INNER JOIN `ps_appagebuilder_profiles_lang` pl ON (pl.id_appagebuilder_profiles = p.id_appagebuilder_profiles) AND id_lang=7 INNER JOIN `ps_appagebuilder_profiles_shop` ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles) WHERE ps.id_shop=1 AND ps.active=1 LIMIT 1
0.3 8 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:227
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 154
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 224
0.3 1 /src/Adapter/Database.php:48
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` = 211
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('20010 ' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '20010 ')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 0 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 149
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 153
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 5) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 224
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_products p
INNER JOIN ps_appagebuilder_products_shop ps on(p.id_appagebuilder_products = ps.id_appagebuilder_products) WHERE  ps.active=1 and ps.id_shop=1 LIMIT 1
0.3 8 /modules/appagebuilder/classes/ApPageBuilderProductsModel.php:116
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 217
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 153 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 47) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 212
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 154
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 212 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 40) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 157
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 145
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 154 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 212
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 224 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 233 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 224
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 233
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.3 1 /classes/shop/Shop.php:201
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 210 LIMIT 1
0.3 1 /classes/Product.php:2535
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` = 211
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 0 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 217 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 145 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 153
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 18 AND `id_shop` = 1
0.3 8 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 149
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 83 /classes/Hook.php:234
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 2 /classes/Language.php:882
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 145
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
0.3 1 /classes/SpecificPrice.php:407
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 233 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 157 LIMIT 1
0.3 1 /classes/Product.php:2535
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 233
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 157
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 210
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE pr.`class` from `ps_appagebuilder_page` pa INNER JOIN `ps_appagebuilder_products` pr ON (pa.`page` = pr.`plist_key`) where pa.id_category = '18' AND pa.id_shop = '1' LIMIT 1
0.2 72 /modules/appagebuilder/appagebuilder.php:1108
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 145
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 157
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 153
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE * FROM ps_product WHERE id_product = 233
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 67 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE page from `ps_appagebuilder_page` where id_category = '18' AND id_shop = '1' LIMIT 1
0.2 9 /modules/appagebuilder/appagebuilder.php:1096
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leobootstrapmenu" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/shop/ShopUrl.php:173
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 5
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.2 6 /classes/Currency.php:661
UPDATE `ps_btmegamenu_group` SET `id_btmegamenu_group` = '2',`active` = '1',`hook` = '',`position` = '0',`id_shop` = '1',`params` = 'eyJncm91cF90eXBlIjoiaG9yaXpvbnRhbCIsInNob3dfY2F2YXMiOiIwIiwidHlwZV9zdWIiOiJhdXRvIiwiZ3JvdXBfY2xhc3MiOiIifQ==',`active_ap` = '1',`randkey` = 'ac70e5b81cccd4671f8c75a464e569bd',`form_id` = '1541900929' WHERE `id_btmegamenu_group` = 2
0.2 1 /classes/ObjectModel.php:718
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 145 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 212) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.2 7 /classes/ImageType.php:147
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 210
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 1 /classes/Image.php:500
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 149 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 224 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE * FROM `ps_appagebuilder_positions` WHERE id_appagebuilder_positions IN(19,20,21,18)
0.2 4 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:318
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 217 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 149) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 224) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 154 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 145) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 153 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 149 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 210 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.2 1 /classes/Image.php:500
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.2 8 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 2 AND id_lang = 7 LIMIT 1
0.2 1 /classes/ObjectModel.php:785
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 217) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE id_btmegamenu_group FROM `ps_btmegamenu_group`  WHERE randkey IN ('ac70e5b81cccd4671f8c75a464e569bd') AND id_shop = 1
0.2 2 /modules/appagebuilder/classes/shortcodes/ApMegamenu.php:121
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 210 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 154) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 157) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE *
FROM `ps_btmegamenu_group` a
WHERE (a.`id_btmegamenu_group` = 2) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE *
FROM `ps_btmegamenu_group_lang`
WHERE `id_btmegamenu_group` = 2
0.2 8 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 217
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 154 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 210) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 157 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 233) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 145 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 212 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 154
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 153) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 224 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 217 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 66 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 233 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 233 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 153 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 157 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 149
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 7
AND cl.id_shop = 1 
AND cl.`id_category` = 30 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 145
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 233
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 224
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 212
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =0 LIMIT 1
0.2 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:77
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 145 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 145 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 153
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 212 LIMIT 1
0.2 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 38 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 7
AND cl.id_shop = 1 
AND cl.`id_category` = 38 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 217 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 30 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 224 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 25 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 154 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 212 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 157
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 157 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 210 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 149 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '2',`title` = 'Megamenu',`title_fo` = 'Categories',`id_lang` = '7' WHERE id_btmegamenu_group = 2 AND id_lang = 7
0.2 1 /classes/ObjectModel.php:786
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 58 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'tr' LIMIT 1
0.2 2 /classes/Language.php:722
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 153 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = 2 AND id_lang = 8 LIMIT 1
0.2 1 /classes/ObjectModel.php:785
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 7
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 217 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2 1 /classes/module/Module.php:2188
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = '2',`title` = 'Megamenu',`title_fo` = 'Categories',`id_lang` = '8' WHERE id_btmegamenu_group = 2 AND id_lang = 8
0.2 1 /classes/ObjectModel.php:786
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
0.2 1 /classes/Group.php:151
SELECT SQL_NO_CACHE `minimal_quantity`
FROM `ps_product_attribute_shop` pas
WHERE `id_shop` = 1
AND `id_product_attribute` = 0 LIMIT 1
0.2 0 /classes/Attribute.php:289
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 212 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 149 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 154 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 224 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 210 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 233 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:151
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 153 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:151

Doubles

30
SELECT * FROM ps_product WHERE id_product = XX
11
SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
10
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
10
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
10
            SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
            FROM `ps_image` i
             INNER JOIN ps_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
            LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
            WHERE i.`id_product` = XX
            ORDER BY `position`
10
            SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc`
            FROM `ps_attribute` a
            LEFT JOIN `ps_attribute_lang` al
                ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
            LEFT JOIN `ps_product_attribute_combination` pac
                ON (pac.`id_attribute` = a.`id_attribute`)
            LEFT JOIN `ps_product_attribute` pa
                ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
             INNER JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            LEFT JOIN `ps_attribute_group_lang` agl
                ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
            WHERE pa.`id_product` = XX
                AND pac.`id_product_attribute` = XX
                AND agl.`id_lang` = XX
10
                SELECT 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 = XX)
                LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
                LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
                 INNER JOIN ps_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
                WHERE pf.id_product = XX
                ORDER BY f.position ASC
10
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `ps_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX 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` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
10
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
10
SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
10
            SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
            FROM `ps_product_attribute` pa
             INNER JOIN ps_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
            JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
            JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
            JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
10
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX
WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
10
			SELECT `minimal_quantity`
			FROM `ps_product_attribute_shop` pas
			WHERE `id_shop` = XX
			AND `id_product_attribute` = XX LIMIT XX
10
            SELECT COUNT(*)
            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 = XX)
            WHERE pa.`id_product` = XX LIMIT XX
10
                            SELECT `id_tax_rules_group`
                            FROM `ps_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT XX
10
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
10
SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
10
SELECT
                    p.*,
                    pl.*,
                    sa.out_of_stock,
                    IFNULL(sa.quantity, XX) as quantity,
                    (DATEDIFF(
				p.`date_add`,
				DATE_SUB(
					'XX-XX-XX XX:XX:XX',
					INTERVAL XX DAY
				)
			) > XX) as new
                FROM ps_product p
                LEFT JOIN ps_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = XX
                    AND pl.id_lang = XX
                LEFT JOIN ps_stock_available sa
			        ON sa.id_product = p.id_product 
			        AND sa.id_shop = XX
			    WHERE p.id_product = XX
10
SELECT `id_product_attribute`
            FROM `ps_product_attribute`
            WHERE `id_product` = XX
6
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
4
SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
                        COUNT(DISTINCT p.id_product) nbr,
                        lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 

                        FROM ps_feature_product fp
                        INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
                                             STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
                                             c.nleft >= XX
                                             AND c.nright <= XX
                                             AND c.active = XX)
                                             STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
                                             AND product_shop.id_shop = XX)
                                             STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
                                             WHERE product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog")) p
                        ON p.id_product = fp.id_product
                        LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = XX)
                        INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = XX))
                        LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_lang_value lifl
                        ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
                        ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = XX) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = XX
GROUP BY fv.id_feature_value 
4
SELECT * FROM ps_appagebuilder_profiles_shop WHERE id_appagebuilder_profiles =XX LIMIT XX
3
SELECT p.*, ps.*,pl.friendly_url
                        FROM ps_appagebuilder_profiles p
                        INNER JOIN ps_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
                        INNER JOIN ps_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
                        WHERE id_shop=XX AND id_lang=XX
3
                SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                FROM `ps_module` m
                LEFT JOIN `ps_module_shop` ms
                ON m.`id_module` = ms.`id_module`
                AND ms.`id_shop` = XX
2
SELECT page from `ps_appagebuilder_page` where id_category = 'XX' AND id_shop = 'XX' LIMIT XX
2
			SELECT cl.`link_rewrite`
			FROM `ps_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
2
SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
                        COUNT(DISTINCT p.id_product) nbr,
                        lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 

                        FROM ps_feature_product fp
                        INNER JOIN (SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category c
                                             STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
                                             c.nleft >= XX
                                             AND c.nright <= XX
                                             AND c.active = XX)
                                             STRAIGHT_JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
                                             AND product_shop.id_shop = XX)
                                             STRAIGHT_JOIN ps_product p ON (p.id_product=cp.id_product)
                                             WHERE product_shop.`active` = XX AND product_shop.`visibility` IN ("both", "catalog")) p
                        ON p.id_product = fp.id_product
                        LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = XX)
                        INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = XX))
                        LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_lang_value lifl
                        ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = XX)
                        LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl
                        ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = XX) 
LEFT JOIN `ps_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = XX AND EXISTS (SELECT * FROM ps_feature_product fp WHERE fp.id_product = p.id_product AND fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX OR fp.`id_feature_value` = XX) 
GROUP BY fv.id_feature_value 
2
SELECT * FROM `ps_hook_alias`
2
                        SELECT * FROM INFORMATION_SCHEMA.COLUMNS
                        WHERE TABLE_SCHEMA = 'uludagcadircom_x'
                        AND TABLE_NAME='ps_btmegamenu_lang'
                
2
SELECT COUNT(*) FROM ps_btmegamenu_group_lang WHERE id_btmegamenu_group = XX AND id_lang = XX LIMIT XX
2
UPDATE `ps_btmegamenu_group_lang` SET `id_btmegamenu_group` = 'XX',`title` = 'Megamenu',`title_fo` = 'Categories',`id_lang` = 'XX' WHERE id_btmegamenu_group = XX AND id_lang = XX
2
SELECT type, id_value, filter_show_limit, filter_type FROM ps_layered_category
			WHERE id_category = XX
				AND id_shop = XX
			GROUP BY `type`, id_value ORDER BY position ASC
2
                        SELECT * FROM INFORMATION_SCHEMA.COLUMNS
                            WHERE TABLE_SCHEMA = 'uludagcadircom_x'
                                AND TABLE_NAME='ps_btmegamenu_lang'
                                AND COLUMN_NAME ='url'
                    

Tables stress

88 product
51 product_attribute_shop
48 product_shop
40 product_attribute
29 category
27 category_lang
25 feature_product
21 cart_product
21 stock_available
21 product_lang
20 product_attribute_combination
20 attribute_lang
20 attribute
20 pack
18 category_product
16 feature_value_lang
16 feature_lang
13 manufacturer
12 category_shop
11 module_shop
11 module
11 image_shop
11 image_lang
11 specific_price
10 feature
10 feature_shop
10 attribute_group_lang
10 image
10 product_group_reduction_cache
10 attribute_group
9 appagebuilder_profiles_shop
6 layered_indexable_feature_value_lang_value
6 layered_indexable_feature_lang_value
6 feature_value
5 appagebuilder_profiles_lang
5 appagebuilder_profiles
4 category_group
4 lang
4 lang_shop
4 hook
4 shop_url
4 shop
4 image_type
3 hook_alias
3 btmegamenu_group_lang
3 currency_shop
3 appagebuilder_page
3 country
2 layered_price_index
2 tax_rules_group
2 tax_rule
2 shop_group
2 configuration
2 group_shop
2 country_lang
2 group
2 btmegamenu_group
2 country_shop
2 hook_module
2 currency
2 appagebuilder_products
2 layered_category
1 arcontactus_prompt_lang
1 page_type
1 connections
1 arcontactus_prompt
1 appagebuilder
1 arcontactus_lang
1 arcontactus
1 appagebuilder_positions
1 appagebuilder_lang
1 appagebuilder_shop
1 appagebuilder_products_shop
1 tab
1 required_field
1 address_format
1 hook_module_exceptions
1 group_lang
1 meta_lang
1 meta
1 module_group
1 configuration_lang
1 page

ObjectModel instances

NameInstancesSource
Product 40 /src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Adapter/Image/ImageRetriever.php [63]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
/src/Core/Foundation/Database/EntityRepository.php [150]
Category 17 /controllers/front/listing/CategoryController.php [85]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/controllers/front/listing/CategoryController.php [201]
/classes/Meta.php [379]
/classes/Link.php [382]
/classes/Link.php [382]
/classes/PrestaShopCollection.php [375]
/classes/PrestaShopCollection.php [375]
/modules/ps_facetedsearch/ps_facetedsearch.php [1712]
/modules/ps_facetedsearch/ps_facetedsearch.php [1380]
/modules/ps_facetedsearch/ps_facetedsearch.php [1712]
Combination 10 /classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
/classes/Product.php [4882]
ApPageBuilderProfilesModel 4 /modules/appagebuilder/appagebuilder.php [2679]
/modules/appagebuilder/appagebuilder.php [1477]
/modules/appagebuilder/appagebuilder.php [2465]
/modules/appagebuilder/classes/ApPageBuilderHookModel.php [31]
Country 4 /config/config.inc.php [141]
/classes/controller/FrontController.php [340]
/classes/AddressFormat.php [353]
/classes/controller/FrontController.php [1620]
Address 4 /classes/shop/Shop.php [466]
/classes/Product.php [3184]
/classes/Product.php [3285]
/classes/Product.php [4904]
Language 3 /config/config.inc.php [194]
/classes/Tools.php [638]
/classes/Tools.php [561]
LeoWidget 2 /modules/leobootstrapmenu/leobootstrapmenu.php [94]
/modules/leobootstrapmenu/leobootstrapmenu.php [94]
ApPageBuilderModel 2 /modules/appagebuilder/appagebuilder.php [1624]
/modules/appagebuilder/appagebuilder.php [1994]
Shop 1 /config/config.inc.php [119]
Guest 1 /modules/statsdata/statsdata.php [83]
BtmegamenuGroup 1 /modules/leobootstrapmenu/leobootstrapmenu.php [1645]
Configuration 1 /modules/appagebuilder/appagebuilder.php [1846]
Risk 1 /classes/controller/FrontController.php [1584]
State 1 /classes/controller/FrontController.php [1619]
AddressFormat 1 /classes/controller/FrontController.php [1614]
Gender 1 /classes/controller/FrontController.php [1581]
Group 1 /classes/Cart.php [244]
Cart 1 /classes/controller/FrontController.php [409]
Currency 1 /classes/Tools.php [685]
Customer 1 /config/config.inc.php [220]
ShopGroup 1 /classes/shop/Shop.php [550]
Connection 1 /modules/statsdata/statsdata.php [117]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/autoload.php
5/vendor/autoload.php
6/vendor/composer/autoload_real.php
7/vendor/composer/ClassLoader.php
8/vendor/composer/include_paths.php
9/vendor/composer/autoload_static.php
10/vendor/symfony/polyfill-ctype/bootstrap.php
11/vendor/react/promise/src/functions_include.php
12/vendor/react/promise/src/functions.php
13/vendor/swiftmailer/swiftmailer/lib/swift_required.php
14/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
15/vendor/paragonie/random_compat/lib/random.php
16/vendor/icanboogie/common/bootstrap.php
17/vendor/icanboogie/common/lib/helpers.php
18/vendor/symfony/polyfill-php70/bootstrap.php
19/vendor/symfony/polyfill-php56/bootstrap.php
20/vendor/symfony/polyfill-mbstring/bootstrap.php
21/vendor/symfony/polyfill-intl-icu/bootstrap.php
22/vendor/symfony/polyfill-apcu/bootstrap.php
23/vendor/smarty/smarty/libs/bootstrap.php
24/vendor/smarty/smarty/libs/Autoloader.php
25/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
26/vendor/ircmaxell/password-compat/lib/password.php
27/vendor/jakeasmith/http_build_url/src/http_build_url.php
28/app/AppKernel.php
29/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
30/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
31/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php
32/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/RebootableInterface.php
33/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/TerminableInterface.php
34/config/alias.php
35/classes/PrestaShopAutoload.php
36/var/cache/prod/class_index.php
37/config/bootstrap.php
38/src/Core/ContainerBuilder.php
39/src/Core/Foundation/IoC/Container.php
40/src/Adapter/ServiceLocator.php
41/vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
42/var/cache/prod/appParameters.php
43/classes/controller/Controller.php
44/classes/ObjectModel.php
45/src/Core/Foundation/Database/EntityInterface.php
46/classes/db/Db.php
47/classes/Tools.php
48/classes/Context.php
49/classes/shop/Shop.php
50/classes/db/DbPDO.php
51/classes/Configuration.php
52/classes/Validate.php
53/classes/cache/Cache.php
54/src/Adapter/EntityMapper.php
55/classes/db/DbQuery.php
56/src/Core/Addon/Theme/ThemeManagerBuilder.php
57/src/Adapter/Configuration.php
58/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
59/src/Core/ConfigurationInterface.php
60/src/Core/Addon/Theme/ThemeRepository.php
61/src/Core/Addon/AddonRepositoryInterface.php
62/src/Core/Addon/Theme/Theme.php
63/src/Core/Addon/AddonInterface.php
64/vendor/shudrum/array-finder/ArrayFinder.php
65/config/defines_uri.inc.php
66/classes/Language.php
67/classes/Country.php
68/classes/PrestaShopCollection.php
69/classes/shop/ShopGroup.php
70/classes/Cookie.php
71/classes/PhpEncryption.php
72/vendor/defuse/php-encryption/src/Core.php
73/classes/PhpEncryptionEngine.php
74/vendor/defuse/php-encryption/src/Key.php
75/vendor/defuse/php-encryption/src/Encoding.php
76/config/smarty.config.inc.php
77/vendor/smarty/smarty/libs/Smarty.class.php
78/vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
79/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
80/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
81/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
82/vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
83/vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
84/vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
85/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
86/vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
87/config/smartyfront.config.inc.php
88/classes/Smarty/SmartyResourceModule.php
89/vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php
90/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php
91/classes/Smarty/SmartyResourceParent.php
92/classes/Smarty/SmartyLazyRegister.php
93/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
94/vendor/smarty/smarty/libs/plugins/modifier.truncate.php
95/classes/Customer.php
96/classes/Group.php
97/classes/Link.php
98/classes/shop/ShopUrl.php
99/classes/Dispatcher.php
100/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Request.php
101/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/FileBag.php
102/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ServerBag.php
103/vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/HeaderBag.php
104/classes/Hook.php
105/src/Adapter/SymfonyContainer.php
106/vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
107/config/db_slave_server.inc.php
108/classes/module/Module.php
109/src/Core/Module/ModuleInterface.php
110/modules/appagebuilder/appagebuilder.php
111/modules/appagebuilder/libs/Helper.php
112/modules/appagebuilder/libs/LeoFrameworkHelper.php
113/modules/appagebuilder/classes/ApPageSetting.php
114/modules/appagebuilder/classes/ApPageBuilderModel.php
115/modules/appagebuilder/classes/shortcodes.php
116/modules/appagebuilder/controllers/admin/AdminApPageBuilderShortcodes.php
117/modules/appagebuilder/controllers/admin/AdminApPageBuilderPositions.php
118/modules/appagebuilder/classes/ApPageBuilderPositionsModel.php
119/classes/controller/ModuleAdminController.php
120/classes/controller/AdminController.php
121/modules/appagebuilder/classes/ApShortCodesBuilder.php
122/modules/appagebuilder/classes/ApPageBuilderProfilesModel.php
123/modules/appagebuilder/classes/ApPageBuilderProductsModel.php
124/modules/appagebuilder/classes/ApPageBuilderShortcodeModel.php
125/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
126/vendor/smarty/smarty/libs/sysplugins/smarty_data.php
127/classes/Translate.php
128/modules/appagebuilder/translations/tr.php
129/src/PrestaShopBundle/Translation/TranslatorComponent.php
130/vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
131/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
132/vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
133/src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
134/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatter.php
135/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatterInterface.php
136/vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/ChoiceMessageFormatterInterface.php
137/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageSelector.php
138/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
139/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
140/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
141/vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
142/vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
143/var/cache/prod/translations/catalogue.tr-TR.NXhscRe.php
144/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
145/vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
146/vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
147/modules/leoblog/leoblog.php
148/modules/leoblog/loader.php
149/modules/leoblog/classes/config.php
150/modules/leoblog/libs/Helper.php
151/modules/leoblog/classes/leoblogcat.php
152/modules/leoblog/classes/blog.php
153/modules/leoblog/classes/link.php
154/modules/leoblog/classes/comment.php
155/modules/leoblog/classes/LeoblogOwlCarousel.php
156/modules/leoblog/translations/tr.php
157/controllers/front/listing/CategoryController.php
158/classes/controller/ProductListingFrontController.php
159/classes/controller/ProductPresentingFrontController.php
160/classes/controller/FrontController.php
161/override/classes/controller/ProductListingFrontController.php
162/override/controllers/front/listing/CategoryController.php
163/src/Adapter/Presenter/Object/ObjectPresenter.php
164/src/Adapter/Presenter/PresenterInterface.php
165/src/Adapter/Presenter/Cart/CartPresenter.php
166/src/Adapter/Product/PriceFormatter.php
167/src/Adapter/Image/ImageRetriever.php
168/classes/tax/TaxConfiguration.php
169/classes/Smarty/TemplateFinder.php
170/classes/assets/StylesheetManager.php
171/classes/assets/AbstractAssetManager.php
172/src/Adapter/Assets/AssetUrlGeneratorTrait.php
173/classes/assets/JavascriptManager.php
174/classes/assets/CccReducer.php
175/classes/Category.php
176/src/Adapter/ContainerBuilder.php
177/var/cache/prod/FrontContainer.php
178/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
179/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
180/vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
181/vendor/psr/container/src/ContainerInterface.php
182/classes/Currency.php
183/src/Core/Cldr/Repository.php
184/vendor/icanboogie/cldr/lib/RunTimeProvider.php
185/vendor/icanboogie/cldr/lib/ProviderChainTrait.php
186/vendor/icanboogie/cldr/lib/ProviderInterface.php
187/vendor/icanboogie/cldr/lib/CacheInterface.php
188/vendor/icanboogie/cldr/lib/FileProvider.php
189/vendor/icanboogie/cldr/lib/WebProvider.php
190/vendor/icanboogie/cldr/lib/Repository.php
191/vendor/icanboogie/cldr/lib/AccessorTrait.php
192/vendor/icanboogie/cldr/lib/LocaleCollection.php
193/vendor/icanboogie/cldr/lib/RepositoryPropertyTrait.php
194/vendor/icanboogie/cldr/lib/CollectionTrait.php
195/vendor/icanboogie/cldr/lib/Locale.php
196/vendor/icanboogie/cldr/lib/CodePropertyTrait.php
197/vendor/icanboogie/cldr/lib/Supplemental.php
198/vendor/icanboogie/cldr/lib/Currency.php
199/vendor/icanboogie/cldr/lib/LocalizedCurrency.php
200/vendor/icanboogie/cldr/lib/LocalizedObjectWithFormatter.php
201/vendor/icanboogie/cldr/lib/LocalizedObject.php
202/vendor/icanboogie/cldr/lib/LocalePropertyTrait.php
203/classes/Cart.php
204/src/Adapter/AddressFactory.php
205/classes/CartRule.php
206/classes/Product.php
207/classes/Pack.php
208/classes/webservice/WebserviceRequest.php
209/modules/ps_socialfollow/ps_socialfollow.php
210/src/Core/Module/WidgetInterface.php
211/classes/ProductDownload.php
212/classes/tax/Tax.php
213/src/Core/Cart/Calculator.php
214/src/Core/Cart/CartRowCollection.php
215/src/Core/Cart/Fees.php
216/src/Core/Cart/CartRuleCollection.php
217/src/Adapter/Product/PriceCalculator.php
218/classes/order/Order.php
219/src/Core/Cart/CartRow.php
220/src/Core/Cart/AmountImmutable.php
221/src/Core/Cart/CartRuleCalculator.php
222/vendor/icanboogie/cldr/lib/Numbers.php
223/vendor/icanboogie/cldr/lib/CurrencyFormatter.php
224/vendor/icanboogie/cldr/lib/NumberFormatter.php
225/vendor/icanboogie/cldr/lib/NumberPattern.php
226/classes/Gender.php
227/classes/Risk.php
228/classes/Meta.php
229/classes/Address.php
230/classes/AddressFormat.php
231/classes/State.php
232/classes/ImageType.php
233/src/Core/Addon/Module/ModuleManagerBuilder.php
234/app/config/config.php
235/vendor/symfony/symfony/src/Symfony/Component/Yaml/Yaml.php
236/vendor/symfony/symfony/src/Symfony/Component/Yaml/Parser.php
237/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php
238/vendor/symfony/symfony/src/Symfony/Component/Yaml/Unescaper.php
239/src/PrestaShopBundle/Service/DataProvider/Marketplace/ApiClient.php
240/vendor/guzzlehttp/guzzle/src/Client.php
241/vendor/guzzlehttp/guzzle/src/Event/HasEmitterTrait.php
242/vendor/guzzlehttp/guzzle/src/ClientInterface.php
243/vendor/guzzlehttp/guzzle/src/Event/HasEmitterInterface.php
244/vendor/guzzlehttp/guzzle/src/Url.php
245/vendor/guzzlehttp/guzzle/src/Utils.php
246/vendor/guzzlehttp/guzzle/src/Message/MessageFactory.php
247/vendor/guzzlehttp/guzzle/src/Event/ListenerAttacherTrait.php
248/vendor/guzzlehttp/guzzle/src/Message/MessageFactoryInterface.php
249/vendor/guzzlehttp/guzzle/src/Subscriber/HttpError.php
250/vendor/guzzlehttp/guzzle/src/Event/SubscriberInterface.php
251/vendor/guzzlehttp/guzzle/src/Subscriber/Redirect.php
252/vendor/guzzlehttp/ringphp/src/Client/CurlHandler.php
253/vendor/guzzlehttp/ringphp/src/Client/CurlFactory.php
254/vendor/guzzlehttp/ringphp/src/Client/CurlMultiHandler.php
255/vendor/guzzlehttp/ringphp/src/Client/Middleware.php
256/vendor/guzzlehttp/ringphp/src/Client/StreamHandler.php
257/vendor/guzzlehttp/guzzle/src/RequestFsm.php
258/src/Adapter/Tools.php
259/app/config/parameters.php
260/src/Adapter/Module/ModuleZipManager.php
261/src/PrestaShopBundle/Event/Dispatcher/NullDispatcher.php
262/vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcherInterface.php
263/src/Core/Hook/HookDispatcherInterface.php
264/src/Adapter/Addons/AddonsDataProvider.php
265/src/PrestaShopBundle/Service/DataProvider/Admin/AddonsInterface.php
266/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
267/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
268/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
269/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
270/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
271/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
272/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
273/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
274/src/Adapter/LegacyLogger.php
275/vendor/psr/log/Psr/Log/LoggerInterface.php
276/src/PrestaShopBundle/Service/DataProvider/Admin/CategoriesProvider.php
277/src/Adapter/LegacyContext.php
278/src/Adapter/Module/ModuleDataProvider.php
279/src/Adapter/Module/AdminModuleDataProvider.php
280/src/PrestaShopBundle/Service/DataProvider/Admin/ModuleInterface.php
281/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocator.php
282/vendor/symfony/symfony/src/Symfony/Component/Config/FileLocatorInterface.php
283/vendor/symfony/symfony/src/Symfony/Component/Routing/Loader/YamlFileLoader.php
284/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/FileLoader.php
285/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/Loader.php
286/vendor/symfony/symfony/src/Symfony/Component/Config/Loader/LoaderInterface.php
287/vendor/symfony/symfony/src/Symfony/Component/Routing/Router.php
288/vendor/symfony/symfony/src/Symfony/Component/Routing/RouterInterface.php
289/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/UrlMatcherInterface.php
290/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContextAwareInterface.php
291/vendor/symfony/symfony/src/Symfony/Component/Routing/Generator/UrlGeneratorInterface.php
292/vendor/symfony/symfony/src/Symfony/Component/Routing/Matcher/RequestMatcherInterface.php
293/vendor/symfony/symfony/src/Symfony/Component/Routing/RequestContext.php
294/src/Adapter/Module/ModuleDataUpdater.php
295/src/Core/Addon/Module/ModuleManager.php
296/src/Core/Addon/AddonManagerInterface.php
297/src/Core/Addon/Module/ModuleRepository.php
298/src/Core/Addon/Module/ModuleRepositoryInterface.php
299/vendor/symfony/symfony/src/Symfony/Component/Finder/Finder.php
300/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ArrayCache.php
301/src/Adapter/Cache/CacheClearer.php
302/classes/Media.php
303/src/Core/Filter/FrontEndObject/MainFilter.php
304/src/Core/Filter/FilterInterface.php
305/src/Core/Filter/FrontEndObject/CartFilter.php
306/src/Core/Filter/HashMapWhitelistFilter.php
307/src/Core/Filter/CollectionFilter.php
308/src/Core/Filter/FrontEndObject/ProductFilter.php
309/src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
310/src/Core/Filter/FrontEndObject/CustomerFilter.php
311/src/Core/Filter/FrontEndObject/ShopFilter.php
312/src/Core/Filter/FrontEndObject/ConfigurationFilter.php
313/modules/ps_searchbar/ps_searchbar.php
314/modules/ps_shoppingcart/ps_shoppingcart.php
315/modules/leobootstrapmenu/leobootstrapmenu.php
316/modules/leobootstrapmenu/classes/Btmegamenu.php
317/modules/leobootstrapmenu/classes/BtmegamenuGroup.php
318/modules/leobootstrapmenu/libs/Helper.php
319/modules/leobootstrapmenu/classes/widgetbase.php
320/modules/leobootstrapmenu/classes/widget.php
321/modules/leobootstrapmenu/translations/tr.php
322/classes/Tab.php
323/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
324/var/cache/prod/smarty/compile/e8/f8/ca/e8f8cac4a8494cda64f8fc175e6948976b5c9490_2.file.javascript_parameter.tpl.php
325/modules/blockgrouptop/blockgrouptop.php
326/modules/blockgrouptop/translations/tr.php
327/modules/leoslideshow/leoslideshow.php
328/modules/leoslideshow/classes/LeoSlideshowConfig.php
329/modules/leoslideshow/classes/LeoSlideshowGroup.php
330/modules/leoslideshow/classes/LeoSlideshowSlide.php
331/modules/leoslideshow/classes/LeoSlideshowStatus.php
332/modules/leoslideshow/libs/Helper.php
333/modules/leoslideshow/translations/tr.php
334/modules/leofeature/leofeature.php
335/modules/leofeature/classes/ProductReviewCriterion.php
336/modules/leofeature/classes/ProductReview.php
337/modules/leofeature/classes/CompareProduct.php
338/modules/leofeature/classes/WishList.php
339/modules/leofeature/translations/tr.php
340/modules/leoquicklogin/leoquicklogin.php
341/modules/leoquicklogin/translations/tr.php
342/modules/leoproductsearch/leoproductsearch.php
343/modules/leoproductsearch/translations/tr.php
344/modules/ps_legalcompliance/ps_legalcompliance.php
345/modules/ps_legalcompliance/entities/AeucCMSRoleEmailEntity.php
346/modules/ps_legalcompliance/entities/AeucEmailEntity.php
347/src/Core/Foundation/Database/EntityManager.php
348/src/Core/Foundation/Database/DatabaseInterface.php
349/src/Adapter/Database.php
350/src/Core/Foundation/Filesystem/FileSystem.php
351/src/Core/Email/EmailLister.php
352/modules/appagebuilder/classes/shortcodes/ApAccordions.php
353/modules/appagebuilder/classes/shortcodes/ApAlert.php
354/modules/appagebuilder/classes/shortcodes/ApBlockCarousel.php
355/modules/appagebuilder/classes/shortcodes/ApBlockLink.php
356/modules/appagebuilder/classes/shortcodes/ApBlog.php
357/modules/appagebuilder/classes/shortcodes/ApButton.php
358/modules/appagebuilder/classes/shortcodes/ApCategoryImage.php
359/modules/appagebuilder/classes/shortcodes/ApColumn.php
360/modules/appagebuilder/classes/shortcodes/ApCountdown.php
361/modules/appagebuilder/classes/shortcodes/ApFacebook.php
362/modules/appagebuilder/classes/shortcodes/ApFontAwesome.php
363/modules/appagebuilder/classes/shortcodes/ApFullSlider.php
364/modules/appagebuilder/classes/shortcodes/ApGenCode.php
365/modules/appagebuilder/classes/shortcodes/ApGmap.php
366/modules/appagebuilder/classes/shortcodes/ApHtml.php
367/modules/appagebuilder/classes/shortcodes/ApImage.php
368/modules/appagebuilder/classes/shortcodes/ApImage360.php
369/modules/appagebuilder/classes/shortcodes/ApImageGallery.php
370/modules/appagebuilder/classes/shortcodes/ApImageGalleryProduct.php
371/modules/appagebuilder/classes/shortcodes/ApImageHotspot.php
372/modules/appagebuilder/classes/shortcodes/ApInstagram.php
373/modules/appagebuilder/classes/shortcodes/ApManuFacturersCarousel.php
374/modules/appagebuilder/classes/shortcodes/ApMegamenu.php
375/modules/appagebuilder/classes/shortcodes/ApModule.php
376/modules/appagebuilder/classes/shortcodes/ApProductCarousel.php
377/modules/appagebuilder/classes/shortcodes/ApProductList.php
378/modules/appagebuilder/classes/shortcodes/ApProductTag.php
379/modules/appagebuilder/classes/shortcodes/ApQuicklogin.php
380/modules/appagebuilder/classes/shortcodes/ApRawHtml.php
381/modules/appagebuilder/classes/shortcodes/ApRow.php
382/modules/appagebuilder/classes/ApPageBuilderHookModel.php
383/modules/appagebuilder/classes/shortcodes/ApSliderLayer.php
384/modules/appagebuilder/classes/shortcodes/ApSlideShow.php
385/modules/appagebuilder/classes/shortcodes/ApTabs.php
386/modules/appagebuilder/classes/shortcodes/ApTwitter.php
387/modules/appagebuilder/classes/shortcodes/ApVideo.php
388/vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php
389/vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php
390/vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php
391/classes/Image.php
392/vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php
393/var/cache/prod/smarty/compile/77/50/95/775095b69ac19f56ba4797b2090a1f585a8a2c9e_2.file.header.tpl.php
394/vendor/smarty/smarty/libs/plugins/modifier.escape.php
395/modules/arcontactus/arcontactus.php
396/modules/arcontactus/classes/ArContactUsGeneralConfig.php
397/modules/arcontactus/classes/ArContactUsAbstract.php
398/modules/arcontactus/classes/ArContactUsModel.php
399/modules/arcontactus/classes/ArContactUsButtonConfig.php
400/modules/arcontactus/classes/ArContactUsMenuConfig.php
401/modules/arcontactus/classes/ArContactUsMenuConfigAbstract.php
402/modules/arcontactus/classes/ArContactUsMenuMobileConfig.php
403/modules/arcontactus/classes/ArContactUsCallbackConfig.php
404/modules/arcontactus/classes/ArContactUsTable.php
405/modules/arcontactus/classes/ArContactUsPromptTable.php
406/modules/arcontactus/classes/ArContactUsCallback.php
407/modules/arcontactus/classes/ArContactUsPromptConfig.php
408/modules/arcontactus/classes/ArContactUsLiveChatConfig.php
409/modules/arcontactus/translations/tr.php
410/var/cache/prod/smarty/cache/arcontactus/1/1/1/7/5/211/3c/bc/36/3cbc360aea75892c4c619516903a8413b6d8c5ec.head.tpl.php
411/src/Core/Product/Search/ProductSearchContext.php
412/src/Core/Product/Search/ProductSearchQuery.php
413/src/Core/Product/Search/SortOrder.php
414/modules/ps_facetedsearch/ps_facetedsearch.php
415/modules/ps_facetedsearch/src/Ps_FacetedsearchProductSearchProvider.php
416/modules/ps_facetedsearch/src/Ps_FacetedsearchFiltersConverter.php
417/modules/ps_facetedsearch/src/Ps_FacetedsearchFacetsURLSerializer.php
418/src/Core/Product/Search/ProductSearchProviderInterface.php
419/modules/ps_facetedsearch/src/Ps_FacetedsearchRangeAggregator.php
420/src/Core/Product/Search/ProductSearchResult.php
421/src/Core/Product/Search/Facet.php
422/src/Core/Product/Search/Filter.php
423/src/Core/Product/Search/URLFragmentSerializer.php
424/src/Core/Product/Search/FacetCollection.php
425/classes/Combination.php
426/classes/stock/StockAvailable.php
427/classes/ProductAssembler.php
428/classes/SpecificPrice.php
429/classes/tax/TaxManagerFactory.php
430/classes/tax/TaxRulesTaxManager.php
431/classes/tax/TaxManagerInterface.php
432/classes/tax/TaxCalculator.php
433/classes/GroupReduction.php
434/classes/Feature.php
435/classes/ProductPresenterFactory.php
436/src/Adapter/Presenter/Product/ProductListingPresenter.php
437/src/Adapter/Presenter/Product/ProductPresenter.php
438/src/Adapter/Product/ProductColorsRetriever.php
439/src/Core/Product/ProductPresentationSettings.php
440/src/Adapter/Presenter/Product/ProductListingLazyArray.php
441/src/Adapter/Presenter/Product/ProductLazyArray.php
442/src/Adapter/Presenter/AbstractLazyArray.php
443/vendor/doctrine/common/lib/Doctrine/Common/Util/Inflector.php
444/vendor/doctrine/inflector/lib/Doctrine/Common/Inflector/Inflector.php
445/classes/ImageManager.php
446/var/cache/prod/smarty/compile/10/f7/40/10f740105659704cda10e5e59e90e2f31f3ca1cf_2.file.facets.tpl.php
447/vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
448/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
449/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
450/var/cache/prod/smarty/compile/1b/70/63/1b7063fa50e2970fc342c20a9a8d4f3fe606b338_2.file.active_filters.tpl.php
451/src/Core/Product/Search/Pagination.php
452/vendor/defuse/php-encryption/src/Crypto.php
453/vendor/defuse/php-encryption/src/KeyOrPassword.php
454/vendor/defuse/php-encryption/src/RuntimeTests.php
455/vendor/defuse/php-encryption/src/DerivedKeys.php
456/vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
457/vendor/defuse/php-encryption/src/Exception/CryptoException.php
458/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/cf/97/ce/cf97ce99ed3de23fafa6d86c3c06856bd2382d68_2.file.category.tpl.php
459/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/bd/7f/16/bd7f1674c690936ccfdcaba53e6f4fc2afc79831_2.file.product-list.tpl.php
460/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/cf/36/97/cf3697b879927eb795abf499563ced594ed1851f_2.file.layout-left-column.tpl.php
461/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/82/9e/7e/829e7e1d4903451ed746d61b2b4e7b791f0898e5_2.file.layout-both-columns.tpl.php
462/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/00/77/ee/0077eea579303554de9c850baf57bd04ac9b8789_2.file.head.tpl.php
463/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/e9/7d/51/e97d5193f24bb7f46ef3356dae42ef49be086941_2.file.setting.tpl.php
464/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_updatescope.php
465/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b7/db/e8/b7dbe82a81b7b00b21f97b34e8fec583f23b87be_2.file.stylesheets.tpl.php
466/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/b1/43/b3/b143b381c9548ee0f9673b269990b31102fb9863_2.file.javascript.tpl.php
467/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/f7/0b/a0/f70ba0fc2d2b23078c74e5745923fa439d9b1e6f_2.file.product-activation.tpl.php
468/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/7b/73/8a/7b738a350507677e94084b428fe695a3fe3a2b4b_2.file.header.tpl.php
469/var/cache/prod/smarty/cache/appagebuilder/displayBanner/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
470/var/cache/prod/smarty/cache/appagebuilder/displayNav1/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
471/var/cache/prod/smarty/cache/appagebuilder/displayNav2/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
472/var/cache/prod/smarty/compile/32/2e/a6/322ea6cc5de043469a179ff71a25dc5c3af1ec6e_2.file.ApGenCode.tpl.php
473/var/cache/prod/smarty/compile/d6/ee/0a/d6ee0acc9f124d5a0aecae10578505ad3978de59_2.file.id_gencode_59848977bf946_1501858167.tpl.php
474/var/cache/prod/smarty/compile/9a/3c/e3/9a3ce3c61e1dc70d2e82f6b74f517ef3fd12c91e_2.file.ApColumn.tpl.php
475/var/cache/prod/smarty/cache/2_1541900929_leobootstrapmenu/20250803/1/1/1/7/5/211/1/11/40/74/114074ceebc7e6dc7a0e8231099806530b916167.leobootstrapmenuviewstemp.php
476/var/cache/prod/smarty/compile/db/73/44/db7344df78f8107efb249cda69ace9190f1d5f27_2.file.ApMegamenu.tpl.php
477/var/cache/prod/smarty/cache/leoproductsearch/1/1/1/7/5/211/ed/7a/43/ed7a43ca78a0dda15cf8db4992beacb950d29485.leoproductsearchviewstemp.php
478/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_tplfunction.php
479/var/cache/prod/smarty/compile/93/0d/be/930dbe808d9c2bdd8b2683031658bfe7233e83d7_2.file.ApModule.tpl.php
480/var/cache/prod/smarty/compile/82/3c/b5/823cb5eb98c5eec574bac150e6020702a1071ca8_2.file.id_gencode_5bde57b041286_1541298096.tpl.php
481/var/cache/prod/smarty/compile/af/e9/74/afe974643c400d6544c0608f1c7aec4ec20d70e3_2.module.leoquickloginviewstemplat.php
482/var/cache/prod/smarty/compile/d1/c7/b3/d1c7b3d9642fd30d312e533fc9c228747f9b05d8_2.file.leoquicklogin.tpl.php
483/src/Adapter/Cart/CartPresenter.php
484/var/cache/prod/smarty/compile/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.psshoppingcartpsshoppingc.php
485/var/cache/prod/smarty/compile/33/58/61/335861ceddbddacf4ce519bcf63ef58ce300cf6f_2.file.ApRow.tpl.php
486/var/cache/prod/smarty/compile/fc/d5/0c/fcd50c9c59a2a4e1b1dc3bed4fc8dce8da33039f_2.module.appagebuilderviewstemplat.php
487/var/cache/prod/smarty/cache/appagebuilder/displayNavFullWidth/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
488/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/f2/e2/b3/f2e2b327580e9bbefa1ed769222111de748700e1_2.file.notifications.tpl.php
489/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/03/2e/88/032e882f84ac170a58a0bfd9130b9b9892b15b98_2.file.breadcrumb.tpl.php
490/var/cache/prod/smarty/compile/81/a1/04/81a1040ed0eeab6f58198f9907167c7fced628c5_2.module.psfacetedsearchpsfaceteds.php
491/var/cache/prod/smarty/cache/appagebuilder/displayLeftColumn/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
492/modules/ps_newproducts/ps_newproducts.php
493/var/cache/prod/smarty/cache/ps_newproducts/1/1/1/7/5/211/e9/eb/91/e9eb91803729d61f310c12ff304bd6c9ee8bfd09.psnewproductsviewstemplat.php
494/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/59/73/1e/59731e46ae10f0313cc9904e8e4fe30ac58caa5e_2.file.category-header.tpl.php
495/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/9e/bb/79/9ebb7987c2d5856db791ca0f91540204edc282d8_2.file.products-top.tpl.php
496/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/97/8c/e7/978ce742c10fe5caee7c89ed92cf361905abd12d_2.file.sort-orders.tpl.php
497/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/94/c0/9b/94c09b6ce777360c263b2674423c31378087cd3f_2.file.products.tpl.php
498/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/32/2e/f2/322ef20ac8e963ae4da5ae9cba45f8752e301ac0_2.file.leo_col_products.tpl.php
499/vendor/smarty/smarty/libs/plugins/function.math.php
500/var/cache/prod/smarty/compile/6b/3a/74/6b3a7428c704a7e4bb62a2d04ed719e31b011517_2.file.plist1544474874.tpl.php
501/var/cache/prod/smarty/compile/1c/c3/60/1cc3608942054eea92268985a73f886b7990f236_2.file.leo_wishlist_button.tpl.php
502/classes/Attribute.php
503/var/cache/prod/smarty/compile/5c/c9/a3/5cc9a3056d5e5e840206f3fb024c55c093da031f_2.file.leo_cart_button.tpl.php
504/var/cache/prod/smarty/compile/50/41/b4/5041b4c0b700007c23b44db54bd73f18b63a133b_2.file.leo_compare_button.tpl.php
505/src/Core/Foundation/Database/EntityRepository.php
506/src/Adapter/EntityMetaDataRetriever.php
507/src/Core/Foundation/Database/EntityMetaData.php
508/src/Core/Foundation/Database/EntityManager/QueryBuilder.php
509/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/3d/d1/e8/3dd1e8051bf3d84caade437f0041368046805d0a_2.file.pagination.tpl.php
510/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/24/74/19/24741925fd5f4d7c2bd0430193ff5ef5ddfc38bf_2.file.products-bottom.tpl.php
511/var/cache/prod/smarty/compile/layouts_layout_left_column_tpl/35/63/a6/3563a6ef98a2eb012fb739d8d5e3902ede18af47_2.file.footer.tpl.php
512/var/cache/prod/smarty/cache/appagebuilder/displayFooterBefore/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
513/var/cache/prod/smarty/cache/appagebuilder/displayFooter/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
514/var/cache/prod/smarty/compile/41/b7/1f/41b71f9aab9142578ace7fe32f99b926bc2c40ee_2.file.footer.tpl.php
515/vendor/smarty/smarty/libs/plugins/modifier.replace.php
516/vendor/smarty/smarty/libs/plugins/shared.mb_str_replace.php
517/var/cache/prod/smarty/cache/appagebuilder/displayFooterAfter/SSL_1/c_group_1/la_7/curcy_5/ctry_211/ab/e9/4f/abe94f7ed45af46ef51037f9d7b6e518f22e296a.appagebuilderviewstemplat.php
518/modules/statsdata/statsdata.php
519/classes/Guest.php
520/classes/Connection.php
521/classes/Page.php
522/classes/ConnectionsSource.php
523/var/cache/prod/smarty/compile/01/53/db/0153dba508ba33b8497625ce148519b6db90fcee_2.module.leoquickloginviewstemplat.php
524/var/cache/prod/smarty/compile/bb/60/7d/bb607db04dfe36af201713ac4e202ee1dd4c7317_2.module.leoquickloginviewstemplat.php