Séria Mate

Choose from our range of packaging, covers, cases, Bio packaging, protective glass and accessories on Huawei Séria Mate.

Active filters

Load Time13814 ms - You'd better run your shop on a toaster
Querying Time2783 ms
Queries2671
Memory Peak Usage85.7 Mb
Included Files814 files - 8.94 Mb
PrestaShop Cache2.57 Mb
Global vars0.26 Mb
PrestaShop Version1.7.6.5
PHP Version7.3.18 (OK)
MySQL Version5.7.30-1 (OK)
Memory Limit1024M
Max Execution Time300s
Smarty Cacheenabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 80 ms 80 ms 3.26 Mb 5.35 Mb
__construct 0 ms 80 ms - Mb 5.35 Mb
init 159 ms 240 ms 1.96 Mb 5.35 Mb
checkAccess 0 ms 240 ms - Mb 5.35 Mb
setMedia 10 ms 250 ms 0.14 Mb 5.41 Mb
postProcess 0 ms 250 ms - Mb 5.41 Mb
initHeader 0 ms 250 ms - Mb 5.41 Mb
initContent 1563 ms 1813 ms 10.83 Mb 16.28 Mb
initFooter 0 ms 1813 ms - Mb 16.28 Mb
display 12001 ms 13814 ms 68.27 Mb 85.70 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 2671 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 986
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
34.4 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1  AND sa.id_shop = 0 ) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 5 AND pl.id_lang = 3) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 5 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=514 AND c.nright<=547 AND ps.id_shop='5' GROUP BY p.id_product) p INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 5 AND pl.id_lang = 3) GROUP BY p.id_product ORDER BY p.name ASC LIMIT 0, 32
28.4 2111214 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:92
SELECT SQL_NO_CACHE r.`id_rvheaderinfo`, r.`id_shop`, rl.`text`
FROM `ps_rvheaderinfo` r
LEFT JOIN `ps_rvheaderinfo_lang` rl ON (r.`id_rvheaderinfo` = rl.`id_rvheaderinfo`)
WHERE `id_lang` = 3 AND  `id_shop` = 5 LIMIT 1
25.7 10 /modules/rvheaderinfo/rvheaderinfo.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1110) LIMIT 1
23.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 480 AND `id_shop` = 5
22.4 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1011 AND `id_shop` = 5
22.2 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 61) LIMIT 1
21.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, pl.name FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1  AND sa.id_shop = 0 ) INNER JOIN ps_product_lang pl ON (p.id_product = pl.id_product AND pl.id_shop = 5 AND pl.id_lang = 3) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 5 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=514 AND c.nright<=547 AND ps.id_shop='5' GROUP BY p.id_product) p
18.9 2111214 /modules/ps_facetedsearch/src/Adapter/MySQL.php:92
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 257) AND (b.`id_shop` = 5) LIMIT 1
18.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 234) AND (b.`id_shop` = 5) LIMIT 1
16.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1032) AND (b.`id_shop` = 5) LIMIT 1
16.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 453) AND (b.`id_shop` = 5) LIMIT 1
16 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 537 AND `id_shop` = 5
15.8 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1136 AND `id_shop` = 5
15.7 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 95 AND `id_shop` = 5
15.6 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 5
WHERE (a.`id_cms` = 1) LIMIT 1
15.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 10066 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 10066 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
15.4 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1018) AND (b.`id_shop` = 5) LIMIT 1
15.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 5 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 3
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
15.2 589 Yes /classes/Category.php:783
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 3) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 3) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
14.4 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 1033
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
14.4 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 580 AND `id_shop` = 5
14.4 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 479) LIMIT 1
14.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1036) AND (b.`id_shop` = 5) LIMIT 1
14 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 193) AND (b.`id_shop` = 5) LIMIT 1
14 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 988 AND `id_shop` = 5
13.1 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 452) AND (b.`id_shop` = 5) LIMIT 1
13 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 1079
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
12.8 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 69) AND (b.`id_shop` = 5) LIMIT 1
12.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 635) AND (b.`id_shop` = 5) LIMIT 1
12.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 1112
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
12.6 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 445
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
12.2 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 982) AND (b.`id_shop` = 5) LIMIT 1
12.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='14f3e6d3f5719f729bfd1d7275ccfb82' AND cache_id="ps_linklist|displayFooter|1|5|1|1|3|1|37" AND compile_id="" LIMIT 1
11.6 1 /classes/Smarty/SmartyCustom.php:216
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 22603 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 22603 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
11.5 0 /classes/Cart.php:1238
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1111) LIMIT 1
11 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 5)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 22602
ORDER BY `position`
10.8 3 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 21) LIMIT 1
10.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 576) AND (b.`id_shop` = 5) LIMIT 1
10.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 179) AND (b.`id_shop` = 5) LIMIT 1
10.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1089) AND (b.`id_shop` = 5) LIMIT 1
10.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 230) AND (b.`id_shop` = 5) LIMIT 1
10.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 997) AND (b.`id_shop` = 5) LIMIT 1
9.9 1 /src/Adapter/EntityMapper.php:75
UPDATE `ps_smarty_lazy_cache`
SET filepath='rvservices/1/5/1/1/3/1/37/c3/ae/4f/c3ae4f8a01ba2b46b583d5ec99cba02ea0741eb1.rvservicesviewstemplatesh.php'
WHERE `template_hash`='95dd24c5e68a3beaf3a45ac26b179877' AND cache_id="rvservices|1|5|1|1|3|1|37" AND compile_id=""
9.9 1 /classes/Smarty/SmartyCustom.php:184
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 2874) AND (b.`id_shop` = 5) LIMIT 1
9.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 130) LIMIT 1
9.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 174 AND `id_shop` = 5
9.2 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 498
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
9 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 1040 AND `id_shop` = 5
9 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 586) AND (b.`id_shop` = 5) LIMIT 1
8.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 175 AND `id_shop` = 5
8.7 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 577
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.7 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
8.6 6625 /classes/Configuration.php:160
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 233
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.6 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 508
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.3 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 573
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.3 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 189) AND (b.`id_shop` = 5) LIMIT 1
8.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 231) AND (b.`id_shop` = 5) LIMIT 1
8.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 468) AND (b.`id_shop` = 5) LIMIT 1
8.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 1111
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
8.1 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 2914) AND (b.`id_shop` = 5) LIMIT 1
8.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 171) AND (b.`id_shop` = 5) LIMIT 1
8.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 177 AND `id_shop` = 5
8 5 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 205) AND (b.`id_shop` = 5) LIMIT 1
8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1126) AND (b.`id_shop` = 5) LIMIT 1
8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 200) AND (b.`id_shop` = 5) LIMIT 1
7.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 51) LIMIT 1
7.9 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 588) AND (b.`id_shop` = 5) LIMIT 1
7.8 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 587) AND (b.`id_shop` = 5) LIMIT 1
7.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 190) AND (b.`id_shop` = 5) LIMIT 1
7.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 1163
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.5 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 121) AND (b.`id_shop` = 5) LIMIT 1
7.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 2936
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.4 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 211
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.4 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1093) AND (b.`id_shop` = 5) LIMIT 1
7.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1163) AND (b.`id_shop` = 5) LIMIT 1
7.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 1113) AND (b.`id_shop` = 5) LIMIT 1
7.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 188
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.3 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 121
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.3 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 2918
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.3 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 189
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.2 1 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 2936) AND (b.`id_shop` = 5) LIMIT 1
7.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 2931) AND (b.`id_shop` = 5) LIMIT 1
7.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 585) AND (b.`id_shop` = 5) LIMIT 1
7.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 3
AND c.`id_parent` = 584
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
7.2