Dvoudírková pyramida

Katalog

Dvoudírková pyramida  Zde je 115 produktů.

Showing 1 - 30 of 115 items

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030

2,07 Kč
: 243 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/28701

2,48 Kč
: 98 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/27001

2,89 Kč
: 23 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/27101

2,48 Kč
: 34 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/29500

2,07 Kč
: 43 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/28101

2,07 Kč
: 151 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/29121

2,07 Kč
: 199 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/15726

3,31 Kč
: 170 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/15781

3,31 Kč
: 221 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 00030/65431

3,72 Kč
: 254 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010

2,07 Kč
: 199 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/28701

2,48 Kč
: 113 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/28001

2,48 Kč
: 290 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/28137

2,48 Kč
: 204 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/29121

2,48 Kč
: 261 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/23001

2,48 Kč
: 229 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/65491

4,13 Kč
: 233 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/15495

3,31 Kč
: 179 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/65307

4,13 Kč
: 250 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/15496

3,31 Kč
: 195 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/15435

3,31 Kč
: 159 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/15781

4,13 Kč
: 237 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/15696

3,31 Kč
: 157 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/15464

3,31 Kč
: 167 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 02010/65431

4,13 Kč
: 182 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 23980

2,07 Kč
: 154 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 23980/84100

2,07 Kč
: 114 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 23980/28701

2,48 Kč
: 100 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 23980/27401

2,48 Kč
: 173 balení balení

Dvoudírková pyramida Velikost cca 12x12x8mm Cena za 1 ks Barva 23980/27101

2,48 Kč
: 224 balení balení
Showing 1 - 30 of 115 items
Load time1503 ms - OK... for a shared hosting
Querying time636 ms
Queries1689
Memory peak usage28.5 Mb
Included files371 files - 6.57 Mb
thirty bees cache5.43 Mb
Global vars3.02 Mb
thirty bees version1.1.0
PrestaShop (emulated) version1.6.1.999
PHP version7.3.22-1+ubuntu18.04.1+deb.sury.org+1 (OK)
MySQL version10.1.44-MariaDB-0ubuntu0.18.04.1 (OK)
Memory limit2048M
Max execution time1200s
Smarty cachedisabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 28 ms 28 ms 2.23 Mb 2.30 Mb
__construct 0 ms 28 ms - Mb 2.30 Mb
init 9 ms 37 ms 0.64 Mb 2.87 Mb
checkAccess 0 ms 37 ms - Mb 2.87 Mb
setMedia 5 ms 42 ms 0.05 Mb 2.95 Mb
postProcess 0 ms 42 ms - Mb 2.95 Mb
initHeader 0 ms 42 ms - Mb 2.95 Mb
initContent 1134 ms 1176 ms 23.87 Mb 26.80 Mb
initFooter 68 ms 1244 ms 0.51 Mb 27.61 Mb
display 259 ms 1503 ms 0.26 Mb 28.55 Mb
Hook Time Memory Usage
hookdisplayLeftColumn 360 ms 8.00 Mb
hookproductlistassign 185 ms 4.00 Mb
hookdisplayTop 182 ms 6.00 Mb
__construct 63 ms 2.00 Mb
hookleftcolumn 49 ms - Mb
hookfooter 40 ms - Mb
hookheader 33 ms - Mb
hookdisplayNav 21 ms - Mb
hookdisplayHeader 15 ms - Mb
hooktop 15 ms - Mb
hookdisplayFooterAfter 10 ms - Mb
hookdisplayFooterBefore 10 ms - Mb
hookdisplayFooter 6 ms - Mb
13 hooks 989 ms 20.00 Mb
Module Time Memory Usage
verticalblockcategories 359 ms 8.00 Mb
blocklayered 241 ms 4.00 Mb
blocktopmenu 175 ms 6.00 Mb
blockcms 20 ms - Mb
m4pdf 16 ms 2.00 Mb
homecategories 15 ms - Mb
blockcart 15 ms - Mb
customblocknewsletter 13 ms - Mb
ganalytics 13 ms - Mb
blocklanguages 13 ms - Mb
htmlbanners5 12 ms - Mb
themeconfigurator 10 ms - Mb
blockmyaccountfooter 8 ms - Mb
blocktags 7 ms - Mb
paypal 7 ms - Mb
blockcurrencies 5 ms - Mb
blockuserinfo 5 ms - Mb
statsdata 5 ms - Mb
htmlbanners4 5 ms - Mb
blockcontactinfos 5 ms - Mb
htmlbanners7 5 ms - Mb
htmlbanners6 5 ms - Mb
blockcontact 4 ms - Mb
blocksearch 4 ms - Mb
eucookieconsent 3 ms - Mb
blockspecials 3 ms - Mb
add_dobirka_fee 3 ms - Mb
htmlbanners1 2 ms - Mb
htmlbanners9 2 ms - Mb
customergroup 1 ms - Mb
eet 1 ms - Mb
supercheckout 1 ms - Mb
statsmodule 1 ms - Mb
dpdparcelshop 1 ms - Mb
vatnumber 1 ms - Mb
blockpaymentlogo 1 ms - Mb
beesblogrecentposts 1 ms - Mb
sklikretargeting 1 ms 2.00 Mb
googleremarketing 1 ms - Mb
blockmyaccount 0 ms - Mb
packetery 0 ms - Mb
eicaptcha 0 ms - Mb
mailalerts 0 ms - Mb
ares 0 ms - Mb
productscategory 0 ms - Mb
blockfacebook 0 ms - Mb
productthumbnails 0 ms - Mb
47 modules 989 ms 20.00 Mb

Stopwatch SQL - 1689 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
INNER JOIN tb_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `tb_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `tb_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
22.2 500 Yes Yes /classes/Category.php:361
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `tb_category` c
INNER JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `tb_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 1003
AND c.id_category IN (
SELECT id_category
FROM `tb_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
18.6 500 Yes /modules/verticalblockcategories/verticalblockcategories.php:306
SELECT SQL_NO_CACHE *
FROM `tb_category` c
INNER JOIN tb_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
WHERE 1  AND `id_lang` = 1
AND `active` = 1
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
11.6 500 Yes /classes/Category.php:217
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `tb_specific_price` WHERE `id_product` != 0 LIMIT 1
9.4 5738 /classes/SpecificPrice.php:388
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 485) LIMIT 1
8.5 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
INNER JOIN tb_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `tb_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `tb_category` c2 ON c2.`id_category` = 17 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
5.4 502 Yes Yes /classes/Category.php:361
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop`
FROM `tb_configuration` c
LEFT JOIN `tb_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration`
5.2 1437 /classes/Configuration.php:437
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `tb_module` m
INNER JOIN tb_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 `tb_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `tb_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `tb_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `tb_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
4.5 170 Yes Yes /classes/Hook.php:588
SELECT SQL_NO_CACHE p.*,
product_shop.*,
product_shop.id_category_default,
pl.*,
image_shop.`id_image` id_image,
il.legend,
m.name manufacturer_name,
product_attribute_shop.id_product_attribute id_product_attribute,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-09-29 00:00:00", INTERVAL 30 DAY)) > 0 AS new,
stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity
FROM tb_cat_filter_restriction cp
LEFT JOIN `tb_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `tb_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 tb_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1  AND pl.id_lang = 1)
LEFT JOIN `tb_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 `tb_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN tb_manufacturer m ON (m.id_manufacturer = p.id_manufacturer)
LEFT JOIN tb_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY cp.position asc , cp.id_product LIMIT 0,30
3.5 115 Yes /modules/blocklayered/blocklayered.php:3133
SELECT SQL_NO_CACHE cl.*, c.*, cl.`name` AS `country`, z.`name` AS `zone`
FROM `tb_country` c
INNER JOIN tb_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `tb_country_lang` `cl` ON c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1
LEFT JOIN `tb_zone` `z` ON z.`id_zone` = c.`id_zone`
ORDER BY cl.`name` ASC
3.4 244 Yes /classes/Country.php:591
UPDATE `tb_configuration_lang` cl
SET cl.value = 'returnslip',
cl.date_upd = NOW()
WHERE cl.id_lang = 1
AND cl.`id_configuration` = (
SELECT c.`id_configuration`
FROM `tb_configuration` c
WHERE c.name = 'M4PDF_FILE_ORDERRETURN_PREFIX' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0))
2.9 1 /classes/Configuration.php:707
SELECT SQL_NO_CACHE COUNT(*)
FROM `tb_log`
WHERE
`message` = 'Module \'productthumbnails\' doesn\'t implement handler for hook \'displayHeader\''
AND `severity` = '2'
AND `error_code` = '0'
AND `object_type` = 'Module'
AND `object_id` = '55' LIMIT 1
2.9 2620 /classes/PrestaShopLogger.php:181
SELECT SQL_NO_CACHE COUNT(*)
FROM `tb_log`
WHERE
`message` = 'Module \'packetery\' doesn\'t implement handler for hook \'displayFooter\''
AND `severity` = '2'
AND `error_code` = '0'
AND `object_type` = 'Module'
AND `object_id` = '86' LIMIT 1
2.8 2620 /classes/PrestaShopLogger.php:181
SELECT SQL_NO_CACHE COUNT(*)
FROM `tb_log`
WHERE
`message` = 'Module \'htmlbanners6\' doesn\'t implement handler for hook \'displayHeader\''
AND `severity` = '2'
AND `error_code` = '0'
AND `object_type` = 'Module'
AND `object_id` = '56' LIMIT 1
2.8 2620 /classes/PrestaShopLogger.php:181
UPDATE `tb_configuration_lang` cl
SET cl.value = 'returnslip',
cl.date_upd = NOW()
WHERE cl.id_lang = 3
AND cl.`id_configuration` = (
SELECT c.`id_configuration`
FROM `tb_configuration` c
WHERE c.name = 'M4PDF_FILE_ORDERRETURN_PREFIX' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0))
2.7 1 /classes/Configuration.php:707
CREATE TEMPORARY TABLE tb_cat_restriction ENGINE=MEMORY
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM tb_category c
STRAIGHT_JOIN tb_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 213
AND c.nright <= 214
AND c.active = 1)
STRAIGHT_JOIN tb_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
STRAIGHT_JOIN tb_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
2.6 1 /modules/blocklayered/blocklayered.php:1972
SELECT SQL_NO_CACHE COUNT(*)
FROM `tb_log`
WHERE
`message` = 'Module \'verticalblockcategories\' doesn\'t implement handler for hook \'displayFooter\''
AND `severity` = '2'
AND `error_code` = '0'
AND `object_type` = 'Module'
AND `object_id` = '97' LIMIT 1
2.6 2620 /classes/PrestaShopLogger.php:181
UPDATE `tb_configuration_lang` cl
SET cl.value = 'returnslip',
cl.date_upd = NOW()
WHERE cl.id_lang = 2
AND cl.`id_configuration` = (
SELECT c.`id_configuration`
FROM `tb_configuration` c
WHERE c.name = 'M4PDF_FILE_ORDERRETURN_PREFIX' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0))
2.6 1 /classes/Configuration.php:707
SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active
FROM `tb_hook_module` hm
STRAIGHT_JOIN `tb_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `tb_module` AS m ON (m.id_module = hm.id_module)
ORDER BY hm.position
2.6 408 /classes/Hook.php:207
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
2.5 502 Yes /classes/Product.php:7903
CREATE TEMPORARY TABLE tb_cat_filter_restriction ENGINE=MEMORY
SELECT cp.id_product, MIN(cp.position) position FROM tb_category c
STRAIGHT_JOIN tb_category_product cp ON (c.id_category = cp.id_category AND
c.nleft >= 213
AND c.nright <= 214
AND c.active = 1)
STRAIGHT_JOIN `tb_product` p ON (p.id_product=cp.id_product)
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY cp.id_product ORDER BY position, id_product
2.5 1 /modules/blocklayered/blocklayered.php:3023
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 428) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `tb_hook`
UNION
SELECT `id_hook`, ha.`alias` AS name
FROM `tb_hook_alias` ha
INNER JOIN `tb_hook` h ON ha.name = h.name
2 0 /classes/Hook.php:731
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20837
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.8 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
1.8 502 Yes /classes/Product.php:7903
UPDATE `tb_configuration` SET `value` = '1',`date_upd` = '2020-09-29 13:14:01' WHERE `name` = 'M4PDF_LIBRARY' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1
1.7 1 /classes/Configuration.php:693
SELECT SQL_NO_CACHE *
FROM `tb_state`
ORDER BY `name` ASC
1.7 312 Yes /classes/Country.php:602
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
INNER JOIN tb_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
LEFT JOIN `tb_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `tb_category` c2 ON c2.`id_category` = 173 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
1.7 41 Yes Yes /classes/Category.php:361
UPDATE `tb_configuration` SET `value` = '1601378041',`date_upd` = '2020-09-29 13:14:01' WHERE `name` = 'BLOCKSPECIALS_TIMESTAMP' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1
1.6 1 /classes/Configuration.php:693
SELECT SQL_NO_CACHE COUNT(DISTINCT(cp.`id_product`)) AS total
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` IN (265) AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
1.5 115 /classes/Category.php:1961
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20841) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20864
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.5 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20856) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.5 2 Yes /classes/SpecificPrice.php:254
INSERT INTO `tb_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
1.4 1 /classes/ObjectModel.php:609
SELECT SQL_NO_CACHE p.`id_product`, sa.`quantity`, sa.`out_of_stock` 
FROM tb_cat_restriction p
LEFT JOIN `tb_stock_available` sa
ON (sa.id_product = p.id_product AND sa.id_product_attribute=0  AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN `tb_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
1.3 115 /modules/blocklayered/blocklayered.php:2212
SELECT SQL_NO_CACHE m.`page`, ml.`url_rewrite`, ml.`id_lang`
FROM `tb_meta` m
LEFT JOIN `tb_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta`  AND ml.id_shop = 1 
ORDER BY LENGTH(ml.`url_rewrite`) DESC
1.3 80 Yes /classes/Dispatcher.php:609
SELECT SQL_NO_CACHE c.*, cl.`delay`
FROM `tb_carrier` c
LEFT JOIN `tb_carrier_lang` `cl` ON c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 
LEFT JOIN `tb_carrier_zone` `cz` ON cz.`id_carrier` = c.`id_carrier`
INNER JOIN tb_carrier_shop carrier_shop
ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1)
WHERE (c.`deleted` = 0) AND (c.`active` = 1)
GROUP BY c.`id_carrier`
ORDER BY c.`position` ASC
1.2 38 Yes Yes /classes/Carrier.php:929
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20863) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20841
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.2 1 Yes Yes /classes/Product.php:6220
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20856)
1.2 1 /classes/Product.php:855
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20845
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.2 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
1.1 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20839
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20852) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20838
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20866
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
UPDATE `tb_configuration` SET `value` = '0',`date_upd` = '2020-09-29 13:14:01' WHERE `name` = 'M4PDF_FILE_ORDERRETURN_FORMAT' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1
1.1 1 /classes/Configuration.php:693
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20840
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20860
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20842) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20847
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20851) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20862) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20842
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20843
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 1 Yes Yes /classes/Product.php:6220
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 `tb_category` c
INNER JOIN tb_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
LEFT JOIN `tb_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 265
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1 1 Yes Yes /classes/Category.php:1727
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20860) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20840) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20844
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20866) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20848) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20864) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20846) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
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 `tb_product_attribute` pa
INNER JOIN tb_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 `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `tb_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1 60 Yes Yes /classes/Product.php:2610
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20841) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20847) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20862
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20854) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20858) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20854
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20846
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20852
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20845) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20844) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20843) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20857) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20856
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20850) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20853) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20861
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20838) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20848
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20858
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20865) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20853
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20863
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20849
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM tb_category c
LEFT JOIN tb_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN tb_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 213
AND c.nright >= 214
AND c.nleft >= 2
AND c.nright <= 1003
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.9 125 Yes /classes/Tools.php:1918
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20849) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20850
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20839) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE * FROM `tb_eet` WHERE chyba != ""
0.9 221 /modules/eet/eet.php:1376
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20861) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20837) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 114) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20851
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20857
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20865
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.9 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20855) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0)) AS `score`
FROM `tb_specific_price`
WHERE (`id_shop` IN (0, 1)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 21)) AND (`id_group` IN (0, 1) AND `id_product` IN (0, 20859) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2020-09-29 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes /classes/SpecificPrice.php:254
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20855
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.8 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) AS quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `tb_product_attribute` pa
INNER JOIN tb_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 tb_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `tb_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `tb_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `tb_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `tb_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `tb_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN tb_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 20859
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.8 1 Yes Yes /classes/Product.php:6220
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM tb_feature_product fp
INNER JOIN tb_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN tb_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `tb_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 8
GROUP BY fv.id_feature_value
0.8 115 Yes /modules/blocklayered/blocklayered.php:2212
SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value,
COUNT(DISTINCT p.id_product) nbr,
lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title 
FROM tb_feature_product fp
INNER JOIN tb_cat_restriction p
ON p.id_product = fp.id_product
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0))
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_layered_indexable_feature_lang_value lifl
ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1)
LEFT JOIN tb_layered_indexable_feature_value_lang_value lifvl
ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) 
LEFT JOIN `tb_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE fp.id_feature = 9
GROUP BY fv.id_feature_value
0.8 115 Yes /modules/blocklayered/blocklayered.php:2212
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20864) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20857
ORDER BY f.position ASC
0.8 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.8 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.8 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE hs.`id_htmlbanners5_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM tb_htmlbanners5 hs
LEFT JOIN tb_htmlbanners5_slides hss ON (hs.id_htmlbanners5_slides = hss.id_htmlbanners5_slides)
LEFT JOIN tb_htmlbanners5_slides_lang hssl ON (hss.id_htmlbanners5_slides = hssl.id_htmlbanners5_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.8 6 Yes /modules/htmlbanners5/htmlbanners5.php:799
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.8 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE p.id_product
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 20841
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-29 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.7 0 /classes/Product.php:554
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 221) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20848) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE hs.`id_htmlbanners4_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM tb_htmlbanners4 hs
LEFT JOIN tb_htmlbanners4_slides hss ON (hs.id_htmlbanners4_slides = hss.id_htmlbanners4_slides)
LEFT JOIN tb_htmlbanners4_slides_lang hssl ON (hss.id_htmlbanners4_slides = hssl.id_htmlbanners4_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.7 1 Yes /modules/htmlbanners4/htmlbanners4.php:610
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 253) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.7 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE value FROM `tb_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.6 1437 /classes/shop/Shop.php:1304
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE `reduction`
FROM `tb_product_group_reduction_cache`
WHERE (`id_product` = 20862) AND (`id_group` = 1) LIMIT 1
0.6 0 /classes/GroupReduction.php:111
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max 
FROM tb_cat_restriction p
INNER JOIN `tb_layered_price_index` psi
ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1)
WHERE 1
0.6 115 /modules/blocklayered/blocklayered.php:2212
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE COUNT(DISTINCT lpa.id_product) nbr, lpa.id_attribute_group,
a.color, al.name attribute_name, agl.public_name attribute_group_name , lpa.id_attribute, ag.is_color_group,
liagl.url_name name_url_name, liagl.meta_title name_meta_title, lial.url_name value_url_name, lial.meta_title value_meta_title
FROM tb_layered_product_attribute lpa
INNER JOIN tb_attribute a
ON a.id_attribute = lpa.id_attribute
INNER JOIN tb_attribute_lang al
ON al.id_attribute = a.id_attribute
AND al.id_lang = 1
INNER JOIN tb_cat_restriction p
ON p.id_product = lpa.id_product
INNER JOIN tb_attribute_group ag
ON ag.id_attribute_group = lpa.id_attribute_group
INNER JOIN tb_attribute_group_lang agl
ON agl.id_attribute_group = lpa.id_attribute_group
AND agl.id_lang = 1
LEFT JOIN tb_layered_indexable_attribute_group_lang_value liagl
ON (liagl.id_attribute_group = lpa.id_attribute_group AND liagl.id_lang = 1)
LEFT JOIN tb_layered_indexable_attribute_lang_value lial
ON (lial.id_attribute = lpa.id_attribute AND lial.id_lang = 1) 
LEFT JOIN `tb_manufacturer` m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE lpa.id_attribute_group = 3 AND lpa.`id_shop` = 1
GROUP BY lpa.id_attribute
ORDER BY ag.`position` ASC, a.`position` ASC
0.6 1 Yes /modules/blocklayered/blocklayered.php:2212
SELECT SQL_NO_CACHE t.`name`, `counter` AS `times`
FROM `tb_tag_count` pt
LEFT JOIN `tb_tag` `t` ON t.`id_tag` = pt.`id_tag`
WHERE (pt.`id_group` = 1) AND (pt.`id_lang` = 1) AND (pt.`id_shop` = 1)
ORDER BY `times` DESC
LIMIT 8
0.6 2889 /classes/Tag.php:297
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
ALTER TABLE tb_cat_restriction ADD PRIMARY KEY (id_product),
ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
ADD KEY `weight` (`weight`,`id_product`) USING BTREE
0.6 1 /modules/blocklayered/blocklayered.php:1979
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 102) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 501) LIMIT 1
0.6 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop`
FROM `tb_module` m
LEFT JOIN `tb_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1
0.6 113 /classes/module/Module.php:214
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20846) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 213 AND c.nright >= 214)
ORDER BY c.nleft
0.6 502 Yes /classes/Product.php:7903
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20845) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20858) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `tb_specific_price_priority`
WHERE (`id_product` = 20863)
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.6 1 /classes/SpecificPrice.php:480
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20847) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20844
ORDER BY f.position ASC
0.6 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20849) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `tb_tag` t
LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 20841)
0.6 1 /classes/Tag.php:331
INSERT INTO `tb_connections` (`id_shop_group`, `id_shop`, `id_guest`, `id_page`, `ip_address`, `date_add`, `http_referer`) VALUES ('1', '1', '1288637', '1299', '921548793', '2020-09-29 13:14:02', '')
0.5 1 /classes/ObjectModel.php:609
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20862) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `tb_product_shop`
WHERE `id_product` = 20845 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:1168
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20853
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
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 `tb_shop_group` gs
LEFT JOIN `tb_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group`
LEFT JOIN `tb_shop_url` `su` ON s.`id_shop` = su.`id_shop` AND su.`main` = 1
WHERE (s.`deleted` = 0) AND (gs.`deleted` = 0)
ORDER BY gs.`name`, s.`name`
0.5 1 Yes /classes/shop/Shop.php:753
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20837
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20856
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20852) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20863) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE hs.`id_htmlbanners6_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`customclass`, hssl.`image`
FROM tb_htmlbanners6 hs
LEFT JOIN tb_htmlbanners6_slides hss ON (hs.id_htmlbanners6_slides = hss.id_htmlbanners6_slides)
LEFT JOIN tb_htmlbanners6_slides_lang hssl ON (hss.id_htmlbanners6_slides = hssl.id_htmlbanners6_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.5 1 Yes /modules/htmlbanners6/htmlbanners6.php:590
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20840
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20837) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20846) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20845
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20854) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20857) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20851)
0.5 1 /classes/Product.php:855
SELECT SQL_NO_CACHE `id_image` FROM `tb_image` WHERE `id_product` = 20837 ORDER BY position ASC LIMIT 1, 2
0.5 1 Yes /override/classes/Product.php:35
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20844) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20838) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20858) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20842) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20848) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20846)
0.5 1 /classes/Product.php:855
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20846
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main`
FROM `tb_shop_url` su
LEFT JOIN `tb_shop` `s` ON s.`id_shop` = su.`id_shop`
WHERE (su.domain = 'koralkykomponenty.cz' OR su.domain_ssl = 'koralkykomponenty.cz') AND (s.`active` = 1) AND (s.`deleted` = 0)
ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC
0.5 1 Yes /classes/shop/Shop.php:353
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `tb_tag` t
LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 20842)
0.5 1 /classes/Tag.php:331
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20838) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20850
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20841) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 209) LIMIT 1
0.5 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20860) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20844)
0.5 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_currency` c
INNER JOIN tb_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 `name` ASC
0.5 2 Yes /classes/Currency.php:354
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20851
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 422) LIMIT 1
0.5 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20859
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE tr.*
FROM `tb_tax_rule` tr
JOIN `tb_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 12
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 Yes /classes/tax/TaxRulesTaxManager.php:130
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 86) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20861) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20851) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20853) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20843) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20852
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE depends_on_stock
FROM `tb_stock_available`
WHERE (id_product = 20864) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 /classes/stock/StockAvailable.php:752
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20863
ORDER BY f.position ASC
0.5 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20859) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20851) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE hs.`id_htmlbanners7_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM tb_htmlbanners7 hs
LEFT JOIN tb_htmlbanners7_slides hss ON (hs.id_htmlbanners7_slides = hss.id_htmlbanners7_slides)
LEFT JOIN tb_htmlbanners7_slides_lang hssl ON (hss.id_htmlbanners7_slides = hssl.id_htmlbanners7_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.4 2 Yes /modules/htmlbanners7/htmlbanners7.php:624
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20865) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20850) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20839) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20860) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20850) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 161) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20855) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20856) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20863) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20847) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20866
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20859) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20862) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20840) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20839) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20842) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 88) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE hs.`id_htmlbanners9_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM tb_htmlbanners9 hs
LEFT JOIN tb_htmlbanners9_slides hss ON (hs.id_htmlbanners9_slides = hss.id_htmlbanners9_slides)
LEFT JOIN tb_htmlbanners9_slides_lang hssl ON (hss.id_htmlbanners9_slides = hssl.id_htmlbanners9_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.4 4 Yes /modules/htmlbanners9/htmlbanners9.php:773
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20866) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
ALTER TABLE tb_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.4 1 /modules/blocklayered/blocklayered.php:3038
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 332) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20840) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20849) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20865) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 120) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_cms` a
LEFT JOIN `tb_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `tb_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20847
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20852) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 379) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 259) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE hs.`id_htmlbanners1_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM tb_htmlbanners1 hs
LEFT JOIN tb_htmlbanners1_slides hss ON (hs.id_htmlbanners1_slides = hss.id_htmlbanners1_slides)
LEFT JOIN tb_htmlbanners1_slides_lang hssl ON (hss.id_htmlbanners1_slides = hssl.id_htmlbanners1_slides)
WHERE id_shop = 1
AND hssl.id_lang = 1 AND hss.`active` = 1
ORDER BY hss.position
0.4 4 Yes /modules/htmlbanners1/htmlbanners1.php:796
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 351) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20858
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20862
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`)
FROM `tb_lang` l
INNER JOIN `tb_lang_shop` ls ON ls.`id_lang` = l.`id_lang`
WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1
0.4 4 /classes/Language.php:395
SELECT SQL_NO_CACHE p.id_product
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 20837
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-29 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.4 0 /classes/Product.php:554
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20841
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 265) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `tb_tag` t
LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 20851)
0.4 1 /classes/Tag.php:331
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20838
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20845)
0.4 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20842)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20842
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 441) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20848
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label
FROM tb_linksmenutop l
LEFT JOIN tb_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = 1 AND ll.id_shop=1)
LEFT JOIN tb_shop s ON l.id_shop = s.id_shop
WHERE 1  AND l.id_linksmenutop = "2"
AND l.id_shop IN (0, 1)
0.4 1 /modules/blocktopmenu/menutoplinks.class.php:53
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20843) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20843
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 84) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20849
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 218) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20854) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20839
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 350) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20855) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20866) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20860
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20854
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20864
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE IFNULL(`left_column`, `default_left_column`) AS `left_column`, IFNULL(`right_column`, `default_right_column`) AS `right_column`
FROM `tb_theme` t
LEFT JOIN `tb_theme_meta` `tm` ON t.`id_theme` = tm.`id_theme`
LEFT JOIN `tb_meta` `m` ON m.`id_meta` = tm.`id_meta`
WHERE (t.`id_theme` = 2) AND (m.`page` = 'category') LIMIT 1
0.4 1 /classes/Theme.php:396
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 70) LIMIT 1
0.4 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 149) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20862 LIMIT 1
0.4 1 /classes/Product.php:1065
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20855)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_hook_module_exceptions`
WHERE (`id_shop` IN (1))
0.4 107 /classes/module/Module.php:3035
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20855
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20845) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20863)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20852) AND (`id_shop` = 1)
0.4 3 /Adapter/Adapter_EntityMapper.php:88
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20843)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20857) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20837) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20865
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 266) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 402) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.`id_cms`, cl.`link_rewrite`, cl.`meta_title`
FROM `tb_cms` c
LEFT JOIN `tb_cms_lang` `cl` ON c.`id_cms` = cl.`id_cms` AND cl.`id_lang` = 1
INNER JOIN tb_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
WHERE (c.`id_cms` IN (10)) AND (c.`active` = 1 )
GROUP BY c.`id_cms`
ORDER BY c.`position`
0.4 3 Yes /classes/CMS.php:113
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 152) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 415) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 375) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 358) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 108) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 84) LIMIT 1
0.4 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 323) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20861) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE p.id_product
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 20861
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-29 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.4 0 /classes/Product.php:554
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 378) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20861)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 151) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
0.4 1 /classes/Category.php:442
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20864) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 128) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 222) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 284) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `id_category`
FROM `tb_category`
WHERE (`nleft` > 213 AND `nright` < 214)
0.4 393 /classes/Category.php:2597
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20844) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20849)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 410) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20853) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 174) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20866)
0.4 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 342) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 397) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20863 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE *
FROM `tb_product` a
LEFT JOIN `tb_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20856) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM tb_layered_category
WHERE id_category = 265
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
0.3 6 Yes Yes /modules/blocklayered/blocklayered.php:1955
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer, m.name 
FROM tb_cat_restriction p
INNER JOIN tb_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) 
WHERE 1
GROUP BY p.id_manufacturer ORDER BY m.name
0.3 11 Yes /modules/blocklayered/blocklayered.php:2212
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 335) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE name, value, pf.id_feature
FROM tb_feature_product pf
LEFT JOIN tb_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN tb_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN tb_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN tb_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 20861
ORDER BY f.position ASC
0.3 1 Yes /classes/Product.php:2047
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 142) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_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 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE `id_page`
FROM `tb_page`
WHERE (`id_page_type` = 2 AND `id_object` = 265) LIMIT 1
0.3 1 /classes/Page.php:99
SELECT SQL_NO_CACHE p.id_product
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 20856
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-29 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:554
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20852)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20841)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 132) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 334) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_country` a
LEFT JOIN `tb_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `tb_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 16) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 218) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 436) LIMIT 1
0.3 1 /classes/Category.php:2222
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20853)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 87) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 115) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 402) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 117) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `tb_tag` t
LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 20837)
0.3 1 /classes/Tag.php:331
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 174) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20860) AND (`id_shop` = 1)
0.3 2 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 112) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 91) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 266) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_currency` c
INNER JOIN tb_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE (`deleted` = 0)
ORDER BY `name` ASC
0.3 2 Yes /classes/Currency.php:354
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 109) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20858)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20865)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 134) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 221) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20849) AND (`id_shop` = 1)
0.3 3 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 321) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 209) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 379) LIMIT 1
0.3 1 /classes/Category.php:2222
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20838)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 408) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 375) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20844) AND (`id_shop` = 1)
0.3 3 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 219) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 409) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 71) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20840) AND (`id_shop` = 1)
0.3 3 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20839)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20862)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20860)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20857)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 107) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 108) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 102) LIMIT 1
0.3 1 /classes/Category.php:2222
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20854)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 107) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 377) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 420) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 410) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 290) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 493) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 345) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 343) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20844 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 350) LIMIT 1
0.3 1 /classes/Category.php:2222
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20847)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 317) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 290) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 87) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE out_of_stock
FROM `tb_stock_available`
WHERE (id_product = 20859) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:781
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20851) AND (`id_shop` = 1)
0.3 3 /Adapter/Adapter_EntityMapper.php:88
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20837)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20848)
0.3 1 /classes/Product.php:855
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20864)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 344) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 403) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 333) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 306) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 501) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 346) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 328) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20840 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 132) LIMIT 1
0.3 1 /classes/Category.php:2222
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20850)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 453) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 169) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20838 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 414) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20847) AND (`id_shop` = 1)
0.3 3 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 446) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 335) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20851 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 286) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 340) LIMIT 1
0.3 1 /classes/Category.php:2222
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20840)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 321) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 487) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 355) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 169) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE p.id_product
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 20846
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-29 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:554
SELECT SQL_NO_CACHE *
FROM `tb_cms` a
LEFT JOIN `tb_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1
LEFT JOIN `tb_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 20) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE SUM(quantity)
FROM `tb_stock_available`
WHERE (id_product = 20859) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:423
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 358) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 502) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 419) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 114) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 296) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 376) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 162) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 377) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE SUM(quantity)
FROM `tb_stock_available`
WHERE (id_product = 20840) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:423
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 11) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 197) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 354) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_product_lang`
WHERE (`id_product` = 20838) AND (`id_shop` = 1)
0.3 3 /Adapter/Adapter_EntityMapper.php:88
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 388) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 11) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE l.`id_lang`, c.`link_rewrite`
FROM `tb_category_lang` c
LEFT JOIN `tb_lang` `l` ON c.`id_lang` = l.`id_lang`
WHERE (c.`id_category` = 265) AND (l.`active` = 1)
0.3 6 /classes/Category.php:959
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 265) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 121) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE tr.*
FROM `tb_tax_rule` tr
JOIN `tb_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 0 /classes/tax/TaxRulesTaxManager.php:130
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 486) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM `tb_shop` s
LEFT JOIN `tb_shop_url` `su` ON s.`id_shop` = su.`id_shop`
LEFT JOIN `tb_theme` `t` ON t.`id_theme` = s.`id_theme`
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:179
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 334) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE * FROM `tb_hook_alias`
0.3 86 /classes/Hook.php:685
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 494) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 331) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 116) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 408) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
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 `tb_product` p
INNER JOIN `tb_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `tb_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` = 20859)
0.3 1 /classes/Product.php:855
SELECT SQL_NO_CACHE `reduction`
FROM `tb_product_group_reduction_cache`
WHERE (`id_product` = 20837) AND (`id_group` = 1) LIMIT 1
0.3 0 /classes/GroupReduction.php:111
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 265) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 117) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 345) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 376) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE COUNT(*)
FROM `tb_hook_module` hm
LEFT JOIN `tb_hook` `h` ON h.`id_hook` = hm.`id_hook`
WHERE (h.`name` = 'actionPDFInvoiceRender') AND (hm.`id_module` = 117) LIMIT 1
0.3 1 /classes/module/Module.php:3164
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 364) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 160) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 437) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 79) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 262) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 332) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_country` a
LEFT JOIN `tb_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `tb_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 399) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE p.id_product
FROM `tb_product` p
INNER JOIN tb_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 20840
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-09-29 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 /classes/Product.php:554
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 407) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 357) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 71) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE COUNT(DISTINCT c.`id_currency`)
FROM `tb_currency` c
LEFT JOIN `tb_currency_shop` `cs` ON cs.`id_currency` = c.`id_currency`
WHERE (cs.`id_shop` = 1) AND (c.`active` = 1) LIMIT 1
0.3 4 /classes/Currency.php:484
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 32) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 288) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20861 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 485) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 16) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 118) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 355) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 468) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `tb_tag` t
LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 20854)
0.3 1 /classes/Tag.php:331
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 149) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 173) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 106) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 414) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 329) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 115) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 343) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 18) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 284) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 378) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM tb_product_attribute pa
INNER JOIN tb_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 = 20839 LIMIT 1
0.3 1 /classes/Product.php:1065
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 175) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 101) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:80
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 286) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 2 AND cl.id_shop = 1 ) AND (c.`id_category` = 265) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 419) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE c.*, cl.*
FROM `tb_category` c
LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category`
WHERE (`id_lang` = 1 AND cl.id_shop = 1 ) AND (c.`id_category` = 34) LIMIT 1
0.3 1 /classes/Category.php:2222
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM `tb_tag` t
LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag`
WHERE (pt.`id_product` = 20847)
0.3 1 /classes/Tag.php:331
SELECT SQL_NO_CACHE *
FROM `tb_category` a
LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 258) AND (b.`id_shop`