Peony & Blush Suede Fragrance Oil

FRAG0108-50
£8.39
£8.39 vat incl.
( £6.99 vat excl. )
VAT included
Size
Quantity
In Stock

favorite Add to wishlist
Product features
  • Vegan Vegan
  • Cruelty Free Cruelty Free
Spend £120.00 more and get FREE UK delivery, including Offshore, Highlands & ROI (product exclusions apply)!
  • 100% Secure payments 100% Secure payments
  • Free shipping on all orders over £120 Free shipping on all orders over £120
  • 30 days refund policy 30 days refund policy

Peony & Blush Suede Fragrance Oil

Peony & Blush Suede Fragrance Oil is similar in notes and identity to the popular scent.

Peony & Blush Suede fragrance oil features peonies in bloom with the bite of red apple and the opulence of jasmine, rose and gillyflower. Mingling with the sensuality of soft, blush suede. Luxurious and seductive. Top note is red apple; middle notes are peony, jasmine, carnation and rose; base note is suede.

This product is produced by Supplies For Candles to deliver a scent reminiscent to a popular perfume scent. This product is not made by, endorsed by or in any way connected with any other brands.

Want to know what this is a dupe of? View our dupe chart here.

Product Specification

Our fragrance oils are 100% concentrated. Compatible with our waxes up to 10%. Compatible with our reed diffuser base between 10% to 25% depending on the IFRA. (please note for diffusers the fragrance oil and diffuser base SDS will need to be combined for your CLP label).

This fragrance is compatible with Gel Wax. 

We always suggest testing all your candles and reed diffusers before placing bulk fragrance orders.

The safety data sheet for this fragrance is available to download under the data sheets tab. Check out our brand new FREE CLP Label Generator

Here you will be able to use our drop-down menu to select any fragrance oil that we stock. You can then select which percentage you require for your product - 10% or 25%.

Disclaimer

As we measure our fragrance oils in grams and not millilitres, some bottles may have different levels of fragrance, this is due to the density of some of our oils which can be thicker and therefore heavier than others.

Our Fragrances oils are sold primarily for use in candles, wax melts, reed diffusers, air fresheners, and room sprays.

!! favorite Add to wishlist
Product features
  • Vegan Vegan
  • Cruelty Free Cruelty Free
!!
Supplies for Candles
FRAG0108-50
28 Items

Download

Peony & Blush Suede IFRA Conformity Certificate

Peony & Blush Suede IFRA Conformity Certificate

Download (90.5k)

Peony & Blush Suede CLP Label

Peony & Blush Suede CLP Label

Download (330.33k)

Peony & Blush Suede Allergen Declaration

Peony & Blush Suede Allergen Declaration

Download (64k)

Peony & Blush Suede SDS @ 100%

Peony & Blush Suede SDS @ 100%

Download (495.14k)

Peony & Blush Suede SDS @ 10%

Peony & Blush Suede SDS @ 10%

Download (60.13k)

PLEASE NOTE: If you cannot find the COA you require below, please email customerservice@suppliesforcandles.co.uk with the batch number detail and they will be happy to help.

Download

What Our Customers Say About This Product

Load Time1674 ms - You'd better run your shop on a toaster
Querying Time505 ms
Queries672
Memory Peak Usage34.6 Mb
Included Files1011 files - 14.80 Mb
PrestaShop Cache- Mb
Global vars0.32 Mb
PrestaShop Version1.7.4.2
PHP Version7.2.34 (OK)
MySQL Version10.2.25-MariaDB-log (OK)
Memory Limit-1
Max Execution Time0s
Smarty Cachedisabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 399 ms 399 ms 8.65 Mb 17.94 Mb
__construct 0 ms 399 ms - Mb 17.94 Mb
init 254 ms 653 ms 5.94 Mb 17.94 Mb
checkAccess 0 ms 653 ms - Mb 17.94 Mb
setMedia 13 ms 666 ms 0.20 Mb 17.94 Mb
postProcess 0 ms 666 ms - Mb 17.94 Mb
initHeader 0 ms 666 ms - Mb 17.94 Mb
initContent 727 ms 1393 ms 7.18 Mb 23.46 Mb
initFooter 0 ms 1393 ms - Mb 23.46 Mb
display 280 ms 1674 ms 11.71 Mb 34.57 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 672 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="3" AND p.enabled=1
52 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="3" AND p.enabled=1
51.8 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="1" AND p.enabled=1
44.1 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="1" AND p.enabled=1
42.3 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="2" AND p.enabled=1
38 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="2" AND p.enabled=1
37.6 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="4" AND p.enabled=1
19.6 2601024 /modules/ybc_blog/ybc_blog.php:4610
SELECT SQL_NO_CACHE DISTINCT p.*, pl.title, pl.description
FROM ps_ybc_blog_post p
INNER JOIN ps_ybc_blog_post_shop ps ON (p.id_post=ps.id_post AND ps.id_shop='1')
LEFT JOIN ps_ybc_blog_post_lang pl ON p.id_post = pl.id_post
LEFT JOIN ps_ybc_blog_post_category pc ON p.id_post = pc.id_post
LEFT JOIN ps_customer c ON (c.id_customer=p.added_by AND p.is_customer=1)
LEFT JOIN ps_employee e ON (e.id_employee=p.added_by AND p.is_customer=0)
LEFT JOIN ps_ybc_blog_employee ybe ON ((ybe.id_employee=c.id_customer AND ybe.is_customer=1) OR (ybe.id_employee=e.id_employee AND ybe.is_customer=0))
LEFT JOIN ps_ybc_blog_comment pcm on (pcm.id_post=p.id_post)
WHERE (p.enabled=1 OR p.enabled=-1) AND (ybe.status>=0 OR ybe.status is NULL OR e.id_profile=1) AND pl.id_lang = 2 AND pc.id_category="4" AND p.enabled=1
16.7 2601024 /modules/ybc_blog/ybc_blog.php:4610
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`)
16.1 3813 /classes/Configuration.php:157
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`
7.5 1608 Yes Yes /classes/Hook.php:629
SELECT SQL_NO_CACHE id_category FROM ps_category_lang
WHERE link_rewrite = "peony-blush-suede-fragrance-oil" AND id_lang = 2 AND id_shop = 1 LIMIT 1
3.3 3230 /override/classes/Dispatcher.php:1060
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3.3 1155 /classes/Hook.php:374
SELECT SQL_NO_CACHE *
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 2
AND `active` = 1
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
3 341 Yes /modules/dor_searchcategories/dor_searchcategories.php:147
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.6 850 /classes/SpecificPrice.php:276
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2 244 Yes /classes/Country.php:146
SHOW TABLES FROM `suppliesforcandles`
1.9 1 /modules/amazon/common/tools.class.php:214
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
1.7 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
1.6 2121 /classes/module/Module.php:2066
SELECT SQL_NO_CACHE `id_product`
FROM ps_product_lang
WHERE `link_rewrite` = "peony-blush-suede-fragrance-oil"
AND `id_lang` = 2
AND `id_shop` = 1 LIMIT 1
1.5 3457 /override/classes/Dispatcher.php:1112
SELECT SQL_NO_CACHE id_category FROM ps_category_lang
WHERE link_rewrite = "peony-blush-suede-fragrance-oil" AND id_lang = 2 AND id_shop = 1 LIMIT 1
1.5 3230 /override/classes/Dispatcher.php:1060
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
LEFT JOIN `ps_sc_link_categories` lc
ON (lc.`id_category` = c.`id_category` AND lc.`id_parent_category` = 357)
WHERE (`id_parent` = 357
OR c.`id_category` IN (SELECT lc.`id_category` FROM `ps_sc_link_categories` lc WHERE lc.`id_parent_category` = 357)        )
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC, lc.`id_sc_link_categories` ASC
1.4 8525 Yes Yes /override/classes/Category.php:174
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
1.3 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE *
FROM ps_product_attachment pa
LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 2)
WHERE pa.id_product = 19728
1.3 9 /classes/Product.php:4892
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 0 /classes/Hook.php:186
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
1 7 /classes/Product.php:6059
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pa.low_stock_alert
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 7 Yes Yes /override/classes/Product.php:488
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-09-10 00:00:00",
INTERVAL 7 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 19728 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1 1 Yes /classes/Product.php:3940
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
0.9 84 Yes /override/classes/Dispatcher.php:211
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
0.9 437 Yes /classes/Country.php:153
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pa.low_stock_alert
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.8 7 Yes Yes /override/classes/Product.php:488
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pa.low_stock_alert
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.8 7 Yes Yes /override/classes/Product.php:488
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=19728
0.8 7 /classes/Tag.php:228
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 19728
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 7 Yes Yes /classes/Product.php:2349
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` = 19733
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 19728 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` = 19733
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 19728 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1226
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.7 186 /classes/module/Module.php:301
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pa.low_stock_alert
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 7 Yes Yes /override/classes/Product.php:488
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
0.7 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE t.`class_name`, t.`module`
FROM `ps_tab` t
WHERE t.`module` IS NOT NULL AND t.`module` != ""
0.7 287 /classes/Tab.php:250
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.7 186 /classes/module/Module.php:301
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.7 186 /classes/module/Module.php:301
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 19728
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 7 Yes Yes /classes/Product.php:2349
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pa.low_stock_alert
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 7 Yes Yes /override/classes/Product.php:488
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.7 186 /classes/module/Module.php:301
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
0.7 84 Yes /override/classes/Dispatcher.php:211
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` = 17
AND tr.`id_tax_rules_group` = 19
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.6 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE t.name, counter AS times
FROM `ps_tag_count` pt
LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag)
WHERE pt.`id_group` = 1
AND pt.`id_lang` = 2 AND pt.`id_shop` = 1
ORDER BY times ASC
LIMIT 3
0.6 1254 /classes/Tag.php:203
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_amazon_configuration` c
LEFT JOIN `ps_amazon_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
0.6 150 /classes/Configuration.php:157
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 19728
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.6 7 Yes Yes /classes/Product.php:2349
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.6 9 Yes /classes/shop/Shop.php:692
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 = 'suppliesforcandlesstaging.shopcreator.com' OR su.domain_ssl = 'suppliesforcandlesstaging.shopcreator.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.6 9 Yes /classes/shop/Shop.php:344
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.6 3 Yes /classes/SpecificPrice.php:541
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 186 /classes/module/Module.php:301
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` = 19728 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` = 19728 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:1226
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 186 /classes/module/Module.php:301
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 441) AND (a0.`nright` > 458) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
0.5 1308 Yes /classes/PrestaShopCollection.php:357
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 3 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 186 /classes/module/Module.php:301
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
0.5 7 /classes/Product.php:6059
SELECT SQL_NO_CACHE cp.`id_category`, cl.`name`, cl.`link_rewrite` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cp.`id_product` = 19728
AND cl.`id_lang` = 2
0.5 10 /classes/Product.php:2913
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1083
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
GROUP BY pa.`id_product_attribute`
0.5 7 Yes Yes /classes/Product.php:2276
SELECT SQL_NO_CACHE id_product
FROM ps_product_lang
WHERE link_rewrite = 'peony-blush-suede-fragrance-oil' AND id_lang = 2 AND id_shop = 1 LIMIT 1
0.5 3457 /override/controllers/front/ProductController.php:19
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 186 /classes/module/Module.php:301
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` = 17
AND tr.`id_tax_rules_group` = 19
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.5 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 186 /classes/module/Module.php:301
SELECT SQL_NO_CACHE `id_product`
FROM ps_product_lang
WHERE `link_rewrite` = "peony-blush-suede-fragrance-oil"
AND `id_lang` = 2
AND `id_shop` = 1 LIMIT 1
0.5 3457 /override/classes/Dispatcher.php:1112
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.5 3 /classes/Language.php:881
SELECT SQL_NO_CACHE * FROM ps_dor_blockfooter AS psb 
LEFT JOIN ps_dor_blockfooter_lang AS psl ON psb.id_dor_blockfooter = psl.id_dor_blockfooter
LEFT JOIN ps_dor_blockfooter_shop AS pss ON psb.id_dor_blockfooter = pss.id_dor_blockfooter
WHERE id_shop =1
AND id_lang =2
AND `hook_position` = "displayFooter" 
AND `showhook` = 1 ORDER BY psb.order  ASC
0.5 7 Yes /modules/dor_managerblockfooter/models/Managerblockfooter.php:51
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 19728) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
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` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (19728) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 7 Yes Yes /classes/Product.php:3801
DESCRIBE ps_ybc_blog_post
0.4 1 /modules/ybc_blog/ybc_blog.php:13267
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 19728) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-09-10 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.4 3 Yes /classes/SpecificPrice.php:604
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
0.4 287 /classes/Tab.php:314
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 3  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.4 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 0  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.4 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
0.4 1 Yes /classes/Currency.php:300
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 4  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.4 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.4 4 /classes/shop/Shop.php:1127
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 19728
0.4 7 /classes/Product.php:6059
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 19728
ORDER BY `position`
0.4 1 Yes /classes/Product.php:2992
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 2  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.4 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ':',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pac.id_product_attribute IN (19729,19730,19731,19732,19733,118870,118871)
GROUP BY pac.id_product_attribute
0.4 7 /classes/Product.php:2294
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` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (19728) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 7 Yes Yes /classes/Product.php:3801
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:67
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` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 17) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 19733) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.4 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE id_meta 
FROM ps_meta_lang
WHERE url_rewrite = "product"
AND `id_lang` = 2 AND `id_shop` = 1 LIMIT 1
0.4 234 /override/classes/Dispatcher.php:1096
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 21 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 357 LIMIT 1
0.4 1 /classes/Category.php:1328
SELECT SQL_NO_CACHE cr.`id_cart_rule`
FROM `ps_cart_cart_rule` cd
LEFT JOIN `ps_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `ps_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 2
)
WHERE `id_cart` = 0
AND free_shipping = 1
ORDER BY cr.priority ASC
0.4 1 Yes /classes/Cart.php:560
SELECT SQL_NO_CACHE * FROM ps_memcached_servers
0.4 1 /classes/cache/CacheMemcached.php:256
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.4 83 /classes/Hook.php:249
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pagecache" LIMIT 1
0.4 1 /classes/module/Module.php:2645
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` = 17
AND tr.`id_tax_rules_group` = 19
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.4 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
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 = 19728
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:4873
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 357) AND (b.`id_shop` = 1) LIMIT 1
0.3 0 /src/Adapter/EntityMapper.php:67
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 1 /modules/appagebuilder/classes/ApPageBuilderProductsModel.php:147
SELECT SQL_NO_CACHE p.*, ps.*,pl.*
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=2
0.3 1 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:137
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 71521) AND (b.`id_shop` = 1) LIMIT 1
0.3 0 /src/Adapter/EntityMapper.php:67
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.3 6 /classes/Language.php:1028
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 19728 LIMIT 1
0.3 7 /classes/Product.php:831
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` = 17
AND tr.`id_tax_rules_group` = 19
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 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE bp.*
FROM `ps_wk_bundle_product` bp
INNER JOIN ps_wk_bundle_product_shop wk_bundle_product_shop
ON (wk_bundle_product_shop.id_wk_bundle_product = bp.id_wk_bundle_product AND wk_bundle_product_shop.id_shop = 1)
WHERE bp.`id_ps_product` = 19728 LIMIT 1
0.3 30 /modules/wkbundleproduct/classes/WkBundle.php:71
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 3  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.3 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1049
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 8 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 1  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.3 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
UPDATE ps_ybc_blog_post SET enabled=1 WHERE datetime_active!="0000-00-00" AND datetime_active is not NULL AND enabled=2 AND datetime_active<=NOW()
0.3 1 /modules/ybc_blog/ybc_blog.php:6386
SELECT SQL_NO_CACHE *
FROM `ps_shop_url` a0
WHERE (a0.`id_shop` = 1) AND (a0.`main` = 1)
0.3 1 /classes/PrestaShopCollection.php:357
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 71521) AND (b.`id_shop` = 1) LIMIT 1
0.3 0 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 19728 AND ctg.`id_group` = 1 LIMIT 1
0.3 10 /classes/Product.php:5412
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1048
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 8 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE il.*,it.`dir`,it.`tag_link` FROM `ps_icontags_lang` il LEFT JOIN `ps_icontags` it ON il.`id_tag` = it.`id_tag` WHERE id_lang = 2 and name IN ("jo malone","Vegan","Cruelty Free","Peony and Blush Suede","Peony & Blush Suede")
0.3 42 /modules/tagsicons/tagsicons.php:910
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` = 17
AND tr.`id_tax_rules_group` = 19
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 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 19728)
0.3 7 /override/classes/Product.php:83
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 1  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.3 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE ps1.*
FROM `ps_fmm_stickers` ps1
LEFT JOIN ps_fmm_stickers_products ps2 ON (ps1.sticker_id = ps2.sticker_id)
WHERE ps2.`id_product` = 19728
AND ps1.`product` > 0
AND
(
(ps1.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= ps1.`start_date`)
AND
(ps1.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= ps1.`expiry_date`)
)
0.3 2 /modules/productlabelsandstickers/models/Stickers.php:203
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`, t.`id_tag`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=19728
0.3 7 /modules/tagsicons/Tags.php:200
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `id_product` FROM `ps_wk_bundle_sub_product` WHERE `id_shop` =1
0.3 300 /modules/wkbundleproduct/classes/WkBundleSubProduct.php:108
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bvkseodispatcher" LIMIT 1
0.3 0 /classes/module/Module.php:2645
SELECT SQL_NO_CACHE `id_product` FROM `ps_wk_bundle_sub_product` WHERE `id_shop` =1
0.3 300 /modules/wkbundleproduct/classes/WkBundleSubProduct.php:108
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` = 2)
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` = 2)
WHERE pa.`id_product` = 19728
AND pac.`id_product_attribute` = 19733
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:6033
SELECT SQL_NO_CACHE r.`id_reassurance`, r.`id_shop`, r.`file_name`, rl.`text`
FROM `ps_reassurance` r
LEFT JOIN `ps_reassurance_lang` rl ON (r.`id_reassurance` = rl.`id_reassurance`)
WHERE `id_lang` = 2  AND id_shop = 1
0.3 8 /modules/blockreassurance/blockreassurance.php:237
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1107
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 2 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 2  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.3 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1052
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 10 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.3 83 /classes/Hook.php:226
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1558
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` = 17
AND tr.`id_tax_rules_group` = 19
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 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1051
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 5 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1077
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 19728) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE b.*, bl.`title`
FROM `ps_fmm_stickersbanners` b
LEFT JOIN ps_fmm_stickersbanners_products bp
ON (b.stickersbanners_id = bp.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_lang bl
ON (b.stickersbanners_id = bl.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_shop ssh
ON (b.stickersbanners_id = ssh.stickersbanners_id)
WHERE bp.`id_product` = 19728
AND `id_lang` = 2
AND ssh.id_shop = 1
AND
(
(b.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= b.`start_date`)
AND
(b.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= b.`expiry_date`)
) LIMIT 1
0.3 1 /modules/productlabelsandstickers/models/Stickers.php:335
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 19728
ORDER BY `position`
0.3 1 Yes /classes/Product.php:2992
SELECT SQL_NO_CACHE b.*, bl.`title`
FROM `ps_fmm_stickersbanners` b
LEFT JOIN ps_fmm_stickersbanners_products bp
ON (b.stickersbanners_id = bp.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_lang bl
ON (b.stickersbanners_id = bl.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_shop ssh
ON (b.stickersbanners_id = ssh.stickersbanners_id)
WHERE bp.`id_product` = 19728
AND `id_lang` = 2
AND ssh.id_shop = 1
AND
(
(b.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= b.`start_date`)
AND
(b.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= b.`expiry_date`)
) LIMIT 1
0.3 1 /modules/productlabelsandstickers/models/Stickers.php:335
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` = 17
AND tr.`id_tax_rules_group` = 19
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 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1080
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 3 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1050
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 5 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 2 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1079
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 3 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1128
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1053
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1047
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 6 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1081
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 4 Yes Yes /classes/Category.php:1100
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` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 71521) AND (b.`id_shop` = 1) LIMIT 1
0.3 0 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 0  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.3 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 71521) AND (b.`id_shop` = 1) LIMIT 1
0.3 0 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1054
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 5 Yes Yes /classes/Category.php:1100
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:203
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1078
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE b.*, bl.`title`
FROM `ps_fmm_stickersbanners` b
LEFT JOIN ps_fmm_stickersbanners_products bp
ON (b.stickersbanners_id = bp.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_lang bl
ON (b.stickersbanners_id = bl.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_shop ssh
ON (b.stickersbanners_id = ssh.stickersbanners_id)
WHERE bp.`id_product` = 19728
AND `id_lang` = 2
AND ssh.id_shop = 1
AND
(
(b.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= b.`start_date`)
AND
(b.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= b.`expiry_date`)
) LIMIT 1
0.2 1 /modules/productlabelsandstickers/models/Stickers.php:335
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1106
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 3 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1057
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 6 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1127
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1055
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 3 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1103
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1104
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1059
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 3 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 19728) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE b.*, bl.`title`
FROM `ps_fmm_stickersbanners` b
LEFT JOIN ps_fmm_stickersbanners_products bp
ON (b.stickersbanners_id = bp.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_lang bl
ON (b.stickersbanners_id = bl.stickersbanners_id)
LEFT JOIN ps_fmm_stickersbanners_shop ssh
ON (b.stickersbanners_id = ssh.stickersbanners_id)
WHERE bp.`id_product` = 19728
AND `id_lang` = 2
AND ssh.id_shop = 1
AND
(
(b.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= b.`start_date`)
AND
(b.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= b.`expiry_date`)
) LIMIT 1
0.2 1 /modules/productlabelsandstickers/models/Stickers.php:335
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1129
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 2 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1105
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 3 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE fsr.*
FROM `ps_fmm_stickers_rules` fsr
LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "new"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= fsr.`expiry_date`)
)
0.2 7 /modules/productlabelsandstickers/models/Rules.php:116
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`, t.`id_tag`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=19728
0.2 7 /modules/tagsicons/Tags.php:200
SELECT SQL_NO_CACHE * FROM ps_dor_blockfooter AS psb 
LEFT JOIN ps_dor_blockfooter_lang AS psl ON psb.id_dor_blockfooter = psl.id_dor_blockfooter
LEFT JOIN ps_dor_blockfooter_shop AS pss ON psb.id_dor_blockfooter = pss.id_dor_blockfooter
WHERE id_shop =1
AND id_lang =2
AND `hook_position` = "doradoFooterAdv" 
AND `showhook` = 1 ORDER BY psb.order  ASC
0.2 7 Yes /modules/dor_managerblockfooter/models/Managerblockfooter.php:51
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1154
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE ps1.*
FROM `ps_fmm_stickers` ps1
LEFT JOIN ps_fmm_stickers_products ps2 ON (ps1.sticker_id = ps2.sticker_id)
WHERE ps2.`id_product` = 19728
AND ps1.`product` > 0
AND
(
(ps1.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= ps1.`start_date`)
AND
(ps1.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= ps1.`expiry_date`)
)
0.2 2 /modules/productlabelsandstickers/models/Stickers.php:203
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
0.2 1 /classes/Cart.php:3931
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 3) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1058
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=19728
0.2 7 /classes/Tag.php:228
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=19728
0.2 7 /classes/Tag.php:228
SELECT SQL_NO_CACHE * FROM ps_product_videos WHERE id_product = 19728 AND id_shop = 1 ORDER BY position ASC
0.2 1 Yes /modules/productvideo/productvideo.php:2712
SELECT SQL_NO_CACHE g.id_group as value, gl.name as label FROM ps_group g
LEFT JOIN ps_group_lang gl ON (g.id_group=gl.id_group AND gl.id_lang="2")
WHERE g.id_group !="1" AND g.id_group !="2"
0.2 3 /modules/ybc_blog/ybc_blog_defines.php:3321
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1096
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1132
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1161
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1159
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE il.*,it.`dir`,it.`tag_link` FROM `ps_icontags_lang` il LEFT JOIN `ps_icontags` it ON il.`id_tag` = it.`id_tag` WHERE id_lang = 2 and name IN ("jo malone","Vegan","Cruelty Free","Peony and Blush Suede","Peony & Blush Suede")
0.2 42 /modules/tagsicons/tagsicons.php:910
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1114
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1111
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `categories` = 1  ORDER BY `name` ASC
0.2 7 Yes /classes/ImageType.php:108
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1101
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1071
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1148
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1170
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1108
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE fsr.*
FROM `ps_fmm_stickers_rules` fsr
LEFT JOIN `ps_fmm_stickers_rules_shop` fsrs ON (fsr.`fmm_stickers_rules_id` = fsrs.`fmm_stickers_rules_id`)
WHERE fsr.`status` = 1
AND fsr.`rule_type` = "category"
AND fsrs.`id_shop` = 1
AND
(
(fsr.`start_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' >= fsr.`start_date`)
AND
(fsr.`expiry_date` = '0000-00-00 00:00:00' OR '2024-09-10 01:57:38' <= fsr.`expiry_date`)
)
0.2 7 /modules/productlabelsandstickers/models/Rules.php:116
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1137
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1125
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1110
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1151
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1133
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
0.2 2 /classes/SpecificPrice.php:399
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.id_category, cl.title,cl.image,cl.thumb
FROM ps_ybc_blog_category c
LEFT JOIN ps_ybc_blog_category_shop cs ON (c.id_category=cs.id_category)
LEFT JOIN ps_ybc_blog_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 2
WHERE c.id_parent = 4  AND  c.enabled = 1 AND cs.id_shop='1' GROUP BY c.id_category ORDER BY c.sort_order
0.2 34 Yes Yes /modules/ybc_blog/ybc_blog.php:11912
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1164
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1146
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1126
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (19729, 19730, 19731, 19732, 19733, 118870, 118871) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 7 Yes /classes/Product.php:2442
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1135
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` = 19729 AND il.`id_lang` = 2 ORDER by i.`position` LIMIT 1
0.2 1 Yes /classes/Product.php:2469
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1075
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1166
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1074
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (19729, 19730, 19731, 19732, 19733, 118870, 118871) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 7 Yes /classes/Product.php:2442
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1095
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1150
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1163
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1073
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1123
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
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` = 17
AND tr.`id_tax_rules_group` = 19
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.2 1 /override/classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.2 1 /classes/SpecificPrice.php:276
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1141
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 19728 AND pa.`id_product` = 19728 AND pa.`id_product_attribute` = 19733 LIMIT 1
0.2 1 /classes/Product.php:919
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1155
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1109
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 19728
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-09-10 00:00:00",
INTERVAL 7 DAY
)
) > 0
0.2 0 /classes/Product.php:1373
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1120
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1169
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1056
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 4 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1124
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1087
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1115
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1118
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1091
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 1157
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 1 Yes Yes /classes/Category.php:1100
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=19728
0.2 7 /classes/Tag.php:228