Warning: Invalid argument supplied for foreach() in /data/www/virtuals/detivbavlnce.cz/classes/cache/CacheApc.php on line 38

Notice: Constant _THEME_NAME_ already defined in /data/www/virtuals/detivbavlnce.cz/config/config.inc.php on line 106
Dětské kardigany a bolerka - Děti v bavlnce .cz

Dětské kardigany a bolerka



Výrobci

Dětské kardigany a bolerka V této kategorii není žádné zboží.

Load time: 1493 ms
You'd better run your shop on a toaster
ExecutionLoad time (ms)
config82
constructor0
init31
checkAccess0
setMedia9
postProcess0
initHeader0
initContent1247
initFooter27
display96
Hook processing: 245 ms / 11.39 Mb
64 methods called in 38 modules
HookProcessing
displayTop3.17 Mb in 105 ms
displayHeader4.75 Mb in 78 ms
displayLeftColumn0.33 Mb in 28 ms
displayFooter3.03 Mb in 27 ms
displayNav0.12 Mb in 6 ms
displayTopColumn0.00 Mb in 0 ms
moduleRoutes0.00 Mb in 0 ms
actionProductListModifier0.00 Mb in 0 ms
actionFrontControllerSetMedia0.00 Mb in 0 ms
displayRightColumn0.00 Mb in 0 ms
actionDispatcher0.00 Mb in 0 ms
actionProductListOverride0.00 Mb in 0 ms
DisplayOverrideTemplate0.00 Mb in 0 ms
Memory peak usage: 31.8 Mb
ExecutionMemory (Mb)Total (Mb)
config7.968.2
constructor0.008.2
init3.0411.4
checkAccess0.0011.4
setMedia0.2211.4
postProcess0.0011.4
initHeader0.0111.4
initContent8.5720.4
initFooter3.0423.5
display1.1631.8
Total cache size (in Cache class): 2.16 Mb
DB type: DbPDO
SQL Queries: 71 queries
Time spent querying: 1045 ms
Included files: 236
Size of included files: 7.14 Mb
Globals (> 1 Ko only): 538 Ko
  • _MODULES ≈ 303.1 Ko
  • _LANG ≈ 141.7 Ko
  • context ≈ 73.7 Ko
  • _MODULE ≈ 12.1 Ko
  • _SERVER ≈ 5.8 Ko
Stopwatch (with SQL_NO_CACHE) (total = 71)
Query Time (ms) Rows Filesort Group By Location
SELECT p.*, product_shop.*, 0 as quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL 1
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image` i
ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 289 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` desc
LIMIT 0,24
734.47925525Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:735

from /controllers/front/CategoryController.php:200
from /controllers/front/CategoryController.php:118
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT COUNT(cp.`id_product`) AS total
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 289 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
290.55125525in /data/www/virtuals/detivbavlnce.cz/classes/Category.php:657

from /controllers/front/CategoryController.php:198
from /controllers/front/CategoryController.php:118
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
WHERE `id_parent` = 289
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.4261YesYesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:578

from /controllers/front/CategoryController.php:172
from /controllers/front/CategoryController.php:117
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT s.*
FROM `ps_scene_category` sc
LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene)
INNER JOIN ps_scene_shop scene_shop
ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1)
LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene)
WHERE sc.id_category = 289
AND sl.id_lang = 1 AND s.active = 1
ORDER BY sl.name ASC
1.0061Yesin /data/www/virtuals/detivbavlnce.cz/classes/Scene.php:217

from /controllers/front/CategoryController.php:49
from /tools/profiling/Controller.php:207
from /classes/Dispatcher.php:373
from /index.php:28
SELECT m.*, ml.`description`, ml.`short_description`
FROM `ps_manufacturer` m
INNER JOIN ps_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)
WHERE m.`active` = 1
ORDER BY m.`name` ASC
0.9831169Yesin /data/www/virtuals/detivbavlnce.cz/classes/Manufacturer.php:178

from /modules/blocktopmenu/blocktopmenu.php:512
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 1679
AND c.nright >= 1680
AND c.nleft >= 16
AND c.nright <= 1695
AND cl.id_lang = 1
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.90110Yesin /data/www/virtuals/detivbavlnce.cz/classes/Tools.php:1053

from /controllers/front/CategoryController.php:127
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT l.`id_lang`, c.`link_rewrite`
FROM `ps_category_lang` AS c
LEFT JOIN  `ps_lang` AS l ON c.`id_lang` = l.`id_lang`
WHERE c.`id_category` = 289
AND l.`active` = 1
0.7851in /data/www/virtuals/detivbavlnce.cz/classes/Category.php:1288

from /modules/blocklanguages/blocklanguages.php:71
from /modules/blocklanguages/blocklanguages.php:100
from /modules/blocklanguages/blocklanguages.php:108
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/72/eb/45/72eb452d7f76b1f8d52918ce3700519ecd242ebb.file.header.tpl.php:143
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:188
from /tools/smarty/sysplugins/smarty_internal_template.php:303
from /cache/smarty/compile/66/d0/ac/66d0ace9455f5f5e65a8b413b7cb177fa8a00c91.file.layout.tpl.php:46
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:188
from /classes/controller/Controller.php:406
from /classes/controller/FrontController.php:563
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 289) AND (b.id_shop = 1)
LIMIT 1
0.7391in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Category.php:137
from /controllers/front/CategoryController.php:83
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 5 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.7151292Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description`
FROM `ps_category_lang` cl
WHERE cl.`id_lang` = 1
AND cl.`id_category` = 289 AND cl.id_shop = 1  LIMIT 1
0.6271in /data/www/virtuals/detivbavlnce.cz/classes/Meta.php:282

from /classes/Meta.php:201
from /classes/controller/FrontController.php:290
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT 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`)
0.603619in /data/www/virtuals/detivbavlnce.cz/classes/Configuration.php:134

from /config/config.inc.php:116
from /index.php:27
SELECT ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 289 AND ctg.`id_group` = 1 LIMIT 1
0.5971in /data/www/virtuals/detivbavlnce.cz/classes/Category.php:1163

from /controllers/front/CategoryController.php:93
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT img FROM ps_psograph_images WHERE type = "indexImage" AND id_lang = 1 LIMIT 1
0.4980in /data/www/virtuals/detivbavlnce.cz/modules/psograph/psograph.php:300

from /modules/psograph/psograph.php:339
from /modules/psograph/psograph.php:313
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 289 LIMIT 1
0.4771in /data/www/virtuals/detivbavlnce.cz/classes/Category.php:933

from /modules/psograph/psograph.php:383
from /modules/psograph/psograph.php:313
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
0.474244Yesin /data/www/virtuals/detivbavlnce.cz/classes/Country.php:129

from /modules/blocknewsletter/blocknewsletter.php:74
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 16 AND nright <= 1695
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (3)
)
ORDER BY `level_depth` ASC, cl.`name` ASC
0.418687Yesin /data/www/virtuals/detivbavlnce.cz/modules/blockcategories/blockcategories.php:231

from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT nleft, nright, level_depth
FROM ps_category
WHERE id_category = 289 LIMIT 1
0.3851in /data/www/virtuals/detivbavlnce.cz/classes/Category.php:1308

from /classes/Tools.php:1036
from /controllers/front/CategoryController.php:127
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3631in /data/www/virtuals/detivbavlnce.cz/classes/Language.php:712

from /config/config.inc.php:122
from /index.php:27
SELECT id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.3361in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:1259

from /classes/Group.php:314
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT id_shop
FROM `ps_category_shop`
WHERE `id_category` = 289
AND id_shop = 1 LIMIT 1
0.3291in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:1259

from /controllers/front/CategoryController.php:62
from /classes/controller/FrontController.php:299
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
0.31474YesYesin /data/www/virtuals/detivbavlnce.cz/classes/Hook.php:346

from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 4 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.3051292Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT * FROM `ps_state` ORDER BY `name` ASC
0.298312Yesin /data/www/virtuals/detivbavlnce.cz/classes/Country.php:136

from /modules/blocknewsletter/blocknewsletter.php:74
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT t.name, COUNT(pt.id_tag) AS times
FROM `ps_product_tag` pt
LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag)
LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product)
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE t.`id_lang` = 1
AND product_shop.`active` = 1
GROUP BY t.id_tag
ORDER BY times DESC
LIMIT 10
0.2831Yesin /data/www/virtuals/detivbavlnce.cz/classes/Tag.php:157

from /modules/blocktags/blocktags.php:142
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
0.2680in /data/www/virtuals/detivbavlnce.cz/classes/Hook.php:131

from /classes/Hook.php:417
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.2592Yesin /data/www/virtuals/detivbavlnce.cz/classes/Currency.php:220

from /classes/controller/FrontController.php:342
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.2561Yesin /data/www/virtuals/detivbavlnce.cz/classes/shop/Shop.php:639

from /classes/shop/Shop.php:789
from /classes/shop/Shop.php:936
from /modules/sekeywords/sekeywords.php:49
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'detivbavlnce.cz' OR su.domain_ssl = 'detivbavlnce.cz')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.2371Yesin /data/www/virtuals/detivbavlnce.cz/classes/shop/Shop.php:329

from /config/config.inc.php:97
from /index.php:27
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
0.2361Yesin /data/www/virtuals/detivbavlnce.cz/modules/themeconfigurator/themeconfigurator.php:375

from /modules/themeconfigurator/themeconfigurator.php:359
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:811
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:28
SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1
LIMIT 1
0.2351in /data/www/virtuals/detivbavlnce.cz/classes/Language.php:817

from /classes/Language.php:918
from /classes/Dispatcher.php:397
from /classes/Dispatcher.php:221
from /classes/Dispatcher.php:193
from /index.php:28
SELECT * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2343in /data/www/virtuals/detivbavlnce.cz/classes/module/Module.php:1889

from /classes/Hook.php:469
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 3 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.2341292Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.23293in /data/www/virtuals/detivbavlnce.cz/classes/module/Module.php:217

from /modules/blocksearch/blocksearch.php:40
from /classes/module/Module.php:1031
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:447
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 7 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.22378Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 6 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.207119Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_shop` a
WHERE (a.id_shop = 1)
LIMIT 1
0.2031in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:131
from /classes/shop/Shop.php:392
from /config/config.inc.php:97
from /index.php:27
SELECT domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.1961in /data/www/virtuals/detivbavlnce.cz/classes/shop/ShopUrl.php:163

from /classes/shop/ShopUrl.php:177
from /classes/Tools.php:200
from /classes/Link.php:52
from /config/config.inc.php:214
from /index.php:27
SELECT id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.1931in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:1259

from /classes/Tools.php:346
from /classes/controller/FrontController.php:160
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 9 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.1891292Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "category" LIMIT 1
0.1821in /data/www/virtuals/detivbavlnce.cz/classes/Theme.php:181

from /classes/controller/FrontController.php:78
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:366
from /index.php:28
SELECT s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1)
GROUP BY s.id_supplier
ORDER BY  s.`name` ASC
0.1781YesYesin /data/www/virtuals/detivbavlnce.cz/classes/Supplier.php:124

from /controllers/front/CategoryController.php:135
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 42 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
0.1761292Yesin /data/www/virtuals/detivbavlnce.cz/classes/Category.php:508

from /modules/blocktopmenu/blocktopmenu.php:480
from /modules/blocktopmenu/blocktopmenu.php:731
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1
LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1
WHERE (a.id_country = 16)
LIMIT 1
0.1761in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:125
from /index.php:27
SELECT *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1
WHERE (a.id_currency = 1)
LIMIT 1
0.1751in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Currency.php:103
from /classes/Currency.php:430
from /classes/Tools.php:433
from /classes/controller/FrontController.php:182
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1
WHERE (a.id_group = 1)
LIMIT 1
0.1741in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang` 
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.1731Yesin /data/www/virtuals/detivbavlnce.cz/classes/Language.php:654

from /classes/Tools.php:358
from /classes/controller/FrontController.php:160
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1
WHERE (a.id_lang = 1)
LIMIT 1
0.1711in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Language.php:90
from /config/config.inc.php:177
from /index.php:27
SELECT * FROM `ps_hook_alias`
0.16586in /data/www/virtuals/detivbavlnce.cz/classes/Hook.php:183

from /classes/Hook.php:202
from /classes/Hook.php:373
from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:28
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1
LEFT JOIN `ps_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.1611in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Category.php:137
from /modules/blockcategories/blockcategories.php:200
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_theme` a
WHERE (a.id_theme = 1)
LIMIT 1
0.1541in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:98
from /index.php:27
SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_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.1471in /data/www/virtuals/detivbavlnce.cz/classes/shop/Shop.php:198

from /classes/shop/Shop.php:133
from /classes/shop/Shop.php:392
from /config/config.inc.php:97
from /index.php:27
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 14) AND (b.id_shop = 1)
LIMIT 1
0.1431in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/Category.php:137
from /classes/Link.php:166
from /modules/blockcategories/blockcategories.php:136
from /modules/blockcategories/blockcategories.php:133
from /modules/blockcategories/blockcategories.php:238
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.13637Yesin /data/www/virtuals/detivbavlnce.cz/classes/Dispatcher.php:461

from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:28
SELECT nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.1311in /data/www/virtuals/detivbavlnce.cz/classes/Category.php:1308

from /classes/Category.php:1326
from /controllers/front/CategoryController.php:62
from /classes/controller/FrontController.php:299
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1
LIMIT 1
0.1262in /data/www/virtuals/detivbavlnce.cz/classes/Currency.php:442

from /classes/Currency.php:450
from /classes/module/Module.php:2008
from /modules/blockpermanentlinks/blockpermanentlinks.php:60
from /classes/Hook.php:509
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:448
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'category_default-bootstrap' LIMIT 1
0.1251in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:154
from /controllers/front/CategoryController.php:129
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1171in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:1259

from /classes/Tools.php:436
from /classes/controller/FrontController.php:182
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT * FROM `ps_group_lang`
WHERE `id_group` = 1
0.1131in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:224

from /tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:173
from /classes/controller/FrontController.php:243
from /controllers/front/CategoryController.php:85
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_shop_group` a
WHERE (a.id_shop_group = 1)
LIMIT 1
0.1131in /data/www/virtuals/detivbavlnce.cz/classes/ObjectModel.php:217

from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:500
from /config/config.inc.php:148
from /index.php:27
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'default-bootstrap_medium' LIMIT 1
0.1021in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:156
from /controllers/front/CategoryController.php:130
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'default-bootstrap_category' LIMIT 1
0.0931in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:156
from /controllers/front/CategoryController.php:129
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 1
AND hook = 'left' AND active = 1
ORDER BY item_order ASC
0.0861Yesin /data/www/virtuals/detivbavlnce.cz/modules/themeconfigurator/themeconfigurator.php:375

from /modules/themeconfigurator/themeconfigurator.php:305
from /classes/Hook.php:507
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:449
from /controllers/front/CategoryController.php:104
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'medium_default-bootstrap' LIMIT 1
0.0851in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:154
from /controllers/front/CategoryController.php:130
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default'
LIMIT 1
0.0781in /data/www/virtuals/detivbavlnce.cz/classes/Image.php:376

from /controllers/front/CategoryController.php:132
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'category_default'
LIMIT 1
0.071in /data/www/virtuals/detivbavlnce.cz/classes/Image.php:376

from /controllers/front/CategoryController.php:129
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default'
LIMIT 1
0.0691in /data/www/virtuals/detivbavlnce.cz/classes/Image.php:376

from /controllers/front/CategoryController.php:130
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'm_scene_default-bootstrap' LIMIT 1
0.0662in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:154
from /controllers/front/CategoryController.php:131
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'home_default-bootstrap' LIMIT 1
0.0561in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:154
from /controllers/front/CategoryController.php:132
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'default-bootstrap_m_scene' LIMIT 1
0.0551in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:156
from /controllers/front/CategoryController.php:131
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` 
FROM `ps_image_type` 
WHERE 
`name` LIKE 'default-bootstrap_home' LIMIT 1
0.0551in /data/www/virtuals/detivbavlnce.cz/classes/ImageType.php:140

from /classes/ImageType.php:156
from /controllers/front/CategoryController.php:132
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'm_scene_default'
LIMIT 1
0.0521in /data/www/virtuals/detivbavlnce.cz/classes/Image.php:376

from /controllers/front/CategoryController.php:131
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:28
Doubles (IDs replaced by "XX") (total = 3)
7 SELECT 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 = XX) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = XX RIGHT JOIN `ps_category` cXX ON cXX.`id_category` = XX AND c.`nleft` >= cXX.`nleft` AND c.`nright` <= cXX.`nright` WHERE XX AND `id_lang` = XX ORDER BY c.`level_depth` ASC , category_shop.`position` ASC
3 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = XX LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = XX WHERE (a.id_category = XX) AND (b.id_shop = XX) LIMIT XX
2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX
Tables stress
22 category
17 category_lang
14 category_shop
12 image_type
5 lang
4 shop_url
4 shop
4 currency_shop
4 lang_shop
3 product_shop
3 currency
3 product
3 hook
3 module_shop
3 theme
2 category_product
2 hook_alias
2 meta
2 module
2 manufacturer
2 shop_group
2 country_shop
2 country_lang
2 country
2 group_shop
2 category_group
2 themeconfigurator
1 tag
1 product_tag
1 image_shop
1 product_lang
1 image
1 image_lang
1 supplier
1 supplier_lang
1 manufacturer_lang
1 group_lang
1 manufacturer_shop
1 psograph_images
1 state
1 zone
1 hook_module_exceptions
1 scene_lang
1 scene_shop
1 scene
1 scene_category
1 group
1 theme_meta
1 meta_lang
1 hook_module
1 configuration_lang
1 configuration
1 supplier_shop
ObjectModel instances
NameInstanceSource
Category5
controllers/front/CategoryController.php [83]
classes/Link.php [166]
modules/blockcategories/blockcategories.php [200]
classes/Link.php [166]
modules/blockcategories/blockcategories.php [243]
Language2
config/config.inc.php [177]
classes/Tools.php [345]
Shop1
config/config.inc.php [97]
Theme1
config/config.inc.php [98]
Country1
config/config.inc.php [125]
ShopGroup1
classes/shop/Shop.php [500]
Customer1
config/config.inc.php [202]
Currency1
classes/Tools.php [433]
Cart1
classes/controller/FrontController.php [243]
Group1
classes/Cart.php [173]
Included files
#Filename
1./index.php
2config/config.inc.php
3config/defines.inc.php
4config/settings.inc.php
5config/autoload.php
6config/alias.php
7classes/PrestaShopAutoload.php
8cache/class_index.php
9tools/profiling/Controller.php
10classes/controller/Controller.php
11tools/profiling/ObjectModel.php
12classes/ObjectModel.php
13tools/profiling/Hook.php
14classes/Hook.php
15tools/profiling/Db.php
16classes/db/Db.php
17tools/profiling/Tools.php
18classes/Tools.php
19classes/Context.php
20classes/shop/Shop.php
21config/db_slave_server.inc.php
22classes/db/DbPDO.php
23classes/cache/Cache.php
24classes/cache/CacheApc.php
25classes/Validate.php
26classes/db/DbQuery.php
27classes/Theme.php
28config/defines_uri.inc.php
29classes/Configuration.php
30tools/htmlpurifier/HTMLPurifier.standalone.php
31classes/Language.php
32classes/Country.php
33classes/PrestaShopCollection.php
34classes/shop/ShopGroup.php
35classes/Cookie.php
36classes/Blowfish.php
37classes/Customer.php
38classes/Group.php
39classes/Link.php
40override/classes/Link.php
41classes/shop/ShopUrl.php
42config/smarty.config.inc.php
43tools/smarty/SmartyBC.class.php
44tools/smarty/Smarty.class.php
45tools/smarty/sysplugins/smarty_internal_data.php
46tools/smarty/sysplugins/smarty_internal_templatebase.php
47tools/smarty/sysplugins/smarty_internal_template.php
48tools/smarty/sysplugins/smarty_resource.php
49tools/smarty/sysplugins/smarty_internal_resource_file.php
50tools/smarty/sysplugins/smarty_cacheresource.php
51tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
52config/smartyfront.config.inc.php
53classes/Dispatcher.php
54tools/mobile_Detect/Mobile_Detect.php
55controllers/front/CategoryController.php
56classes/controller/FrontController.php
57override/controllers/front/CategoryController.php
58classes/Category.php
59themes/detivbavlnce/lang/cs.php
60classes/Currency.php
61classes/Cart.php
62override/classes/Cart.php
63classes/CartRule.php
64classes/Meta.php
65classes/Product.php
66classes/webservice/WebserviceRequest.php
67classes/Media.php
68classes/Scene.php
69classes/module/Module.php
70override/classes/module/Module.php
71modules/blocksearch/blocksearch.php
72classes/Translate.php
73themes/detivbavlnce/modules/blocksearch/translations/cs.php
74modules/blocksearch/translations/cs.php
75modules/blockbanner/blockbanner.php
76themes/detivbavlnce/modules/blockbanner/translations/cs.php
77modules/blockbanner/translations/cs.php
78modules/blockcart/blockcart.php
79themes/detivbavlnce/modules/blockcart/translations/cs.php
80modules/blockcart/translations/cs.php
81modules/blocksocial/blocksocial.php
82themes/detivbavlnce/modules/blocksocial/translations/cs.php
83modules/blocksocial/translations/cs.php
84modules/blockcurrencies/blockcurrencies.php
85themes/detivbavlnce/modules/blockcurrencies/translations/cs.php
86modules/blockcurrencies/translations/cs.php
87modules/blocklanguages/blocklanguages.php
88themes/detivbavlnce/modules/blocklanguages/translations/cs.php
89modules/blocklanguages/translations/cs.php
90modules/blockcms/blockcms.php
91modules/blockcms/BlockCMSModel.php
92themes/detivbavlnce/modules/blockcms/translations/cs.php
93modules/blockcms/translations/cs.php
94modules/blockcontact/blockcontact.php
95themes/detivbavlnce/modules/blockcontact/translations/cs.php
96modules/blockcontact/translations/cs.php
97modules/blockcontactinfos/blockcontactinfos.php
98themes/detivbavlnce/modules/blockcontactinfos/translations/cs.php
99modules/blockcontactinfos/translations/cs.php
100modules/blockmyaccount/blockmyaccount.php
101themes/detivbavlnce/modules/blockmyaccount/translations/cs.php
102modules/blockmyaccount/translations/cs.php
103modules/blocknewsletter/blocknewsletter.php
104themes/detivbavlnce/modules/blocknewsletter/translations/cs.php
105modules/blocknewsletter/translations/cs.php
106modules/blockpaymentlogo/blockpaymentlogo.php
107themes/detivbavlnce/modules/blockpaymentlogo/translations/cs.php
108modules/blockpaymentlogo/translations/cs.php
109modules/blockspecials/blockspecials.php
110themes/detivbavlnce/modules/blockspecials/translations/cs.php
111modules/blockspecials/translations/cs.php
112modules/blocktags/blocktags.php
113themes/detivbavlnce/modules/blocktags/translations/cs.php
114modules/blocktags/translations/cs.php
115modules/blockuserinfo/blockuserinfo.php
116themes/detivbavlnce/modules/blockuserinfo/translations/cs.php
117modules/blockuserinfo/translations/cs.php
118modules/themeconfigurator/themeconfigurator.php
119themes/detivbavlnce/modules/themeconfigurator/translations/cs.php
120modules/themeconfigurator/translations/cs.php
121cache/smarty/compile/78/41/3f/78413f570ce3038870a2d30e3f103cdd0b11973d.file.hook.tpl.php
122tools/smarty/sysplugins/smarty_internal_filter_handler.php
123modules/productscategory/productscategory.php
124themes/detivbavlnce/modules/productscategory/translations/cs.php
125modules/productscategory/translations/cs.php
126modules/ganalytics/ganalytics.php
127themes/detivbavlnce/modules/ganalytics/translations/cs.php
128modules/ganalytics/translations/cs.php
129modules/blockpermanentlinks/blockpermanentlinks.php
130themes/detivbavlnce/modules/blockpermanentlinks/translations/cs.php
131modules/blockpermanentlinks/translations/cs.php
132modules/productenquiry/productenquiry.php
133themes/detivbavlnce/modules/productenquiry/translations/cs.php
134modules/productenquiry/cs.php
135modules/mailalerts/mailalerts.php
136modules/mailalerts/MailAlert.php
137themes/detivbavlnce/modules/mailalerts/translations/cs.php
138modules/mailalerts/translations/cs.php
139modules/sendtoafriend/sendtoafriend.php
140themes/detivbavlnce/modules/sendtoafriend/translations/cs.php
141modules/sendtoafriend/translations/cs.php
142modules/homefeatured/homefeatured.php
143themes/detivbavlnce/modules/homefeatured/translations/cs.php
144modules/homefeatured/translations/cs.php
145modules/blocktopmenu/blocktopmenu.php
146modules/blocktopmenu/menutoplinks.class.php
147themes/detivbavlnce/modules/blocktopmenu/translations/cs.php
148modules/blocktopmenu/translations/cs.php
149modules/blockcategories/blockcategories.php
150themes/detivbavlnce/modules/blockcategories/translations/cs.php
151modules/blockcategories/translations/cs.php
152modules/blockmanufacturer/blockmanufacturer.php
153themes/detivbavlnce/modules/blockmanufacturer/translations/cs.php
154modules/blockmanufacturer/translations/cs.php
155modules/ulozenka/ulozenka.php
156classes/module/CarrierModule.php
157modules/ulozenka/translations/cs.php
158modules/psograph/psograph.php
159cache/smarty/compile/8d/54/6d/8d546d6c4c7bb0dcc68e645ffeb2105b85c71b18.file.psograph.tpl.php
160tools/smarty/plugins/modifier.replace.php
161tools/minify_html/minify_html.class.php
162modules/uecookie/uecookie.php
163modules/uecookie/key.php
164modules/froggyfacebookcomment/froggyfacebookcomment.php
165modules/froggyfacebookcomment/froggy/FroggyModule.php
166modules/froggyfacebookcomment/froggy/FroggyHelperFormList.php
167modules/froggyfacebookcomment/froggy/FroggyHelperTreeCategories.php
168cache/smarty/compile/48/74/ca/4874ca9a27397fc545409a4f74ebe89326b25ca1.file.hookDisplayHeader.tpl.php
169tools/js_minify/jsmin.php
170modules/eicaptcha/eicaptcha.php
171classes/Customization.php
172cache/smarty/compile/44/e9/83/44e98388384468082eeb921fa32ec902fca655eb.file.blockcart.tpl.php
173tools/smarty/plugins/function.counter.php
174cache/smarty/compile/7b/3d/66/7b3d6600a88b2f417a8b2b36365b970c8c55292a.file.blockuserinfo.tpl.php
175modules/pagesnotfound/pagesnotfound.php
176themes/detivbavlnce/modules/pagesnotfound/translations/cs.php
177modules/pagesnotfound/translations/cs.php
178modules/sekeywords/sekeywords.php
179classes/module/ModuleGraph.php
180themes/detivbavlnce/modules/sekeywords/translations/cs.php
181modules/sekeywords/translations/cs.php
182cache/smarty/cache/blockpermanentlinks_header/1/1/16/14/8f/00/148f00dace4fa14434416370d5b84c0de76bf15a.blockpermanentlinks-header.tpl.php
183cache/smarty/cache/blocksearch_top/1/1/16/10/34/45/1034450186e196adc99d6988ee2bb88c6046ce8c.blocksearch-top.tpl.php
184classes/Manufacturer.php
185cache/smarty/compile/42/61/11/426111c12576761f4d89cbba451335683987a26d.file.blocktopmenu.tpl.cache.php
186tools/smarty/sysplugins/smarty_internal_write_file.php
187classes/Address.php
188classes/SpecificPrice.php
189classes/Tag.php
190modules/blockviewed/blockviewed.php
191themes/detivbavlnce/modules/blockviewed/translations/cs.php
192modules/blockviewed/translations/cs.php
193cache/smarty/compile/17/06/8a/17068a43871ecff5b6366929d75037f0d904354f.file.blockcategories.tpl.cache.php
194cache/smarty/compile/d1/82/c2/d182c2fd7e37f2042f71059429ccbdf167e012b8.file.category-tree-branch.tpl.cache.php
195cache/smarty/cache/blockmanufacturer/1/1/16/e5/ee/45/e5ee4511e91943732c0814574f4aec4f4790411e.blockmanufacturer.tpl.php
196classes/Image.php
197classes/ImageType.php
198classes/Supplier.php
199cache/smarty/compile/19/75/42/197542eb14a4f28bc0743a434ee7d13109fb7808.file.blocknewsletter.tpl.php
200cache/smarty/cache/blocksocial/1/1/16/5f/64/56/5f6456c430d195b0d697acc6588039be11fbc2e7.blocksocial.tpl.php
201cache/smarty/cache/blockcms/2/1/1/16/23/3a/b1/233ab1afb8b27ab89b3236c12a9b771cfe5646bf.blockcms.tpl.php
202modules/prestasms/prestasms.php
203modules/prestasms/includes/model/hooks.php
204modules/prestasms/includes/model/sms.php
205modules/prestasms/includes/model/variables.php
206modules/prestasms/includes/model/smsAdapter.php
207modules/prestasms/lang.php
208modules/prestasms/langs/cs/lang.php
209modules/prestasms/exc.php
210themes/detivbavlnce/modules/prestasms/translations/cs.php
211cache/smarty/cache/blockcontactinfos/1/1/16/58/a0/39/58a039c34378120ef56ae2817bce9bd7083947b6.blockcontactinfos.tpl.php
212modules/smartsupp/smartsupp.php
213modules/smartsupp/translations/cs.php
214modules/smartsupp/cs.php
215cache/smarty/compile/6a/b0/19/6ab0197b1891a74ad38889deb85170e747b91740.file.top.tpl.php
216cache/smarty/compile/e2/59/3f/e2593ff452d42aa0455ae0f67cc0624fe38af264.file.category.tpl.php
217cache/smarty/compile/76/6e/f1/766ef1ce0ec6e15a226ea0ae76e7d5378854fedf.file.errors.tpl.php
218cache/smarty/compile/39/28/b2/3928b206cdbe14e038e1a20b0400886dc8bc76e8.file.category-count.tpl.php
219cache/smarty/compile/66/d0/ac/66d0ace9455f5f5e65a8b413b7cb177fa8a00c91.file.layout.tpl.php
220cache/smarty/compile/72/eb/45/72eb452d7f76b1f8d52918ce3700519ecd242ebb.file.header.tpl.php
221tools/smarty/plugins/function.implode.php
222cache/smarty/compile/4f/55/d3/4f55d3b6a4bbacef83e71541002e901f17ddf178.file.nav.tpl.php
223cache/smarty/compile/7e/53/56/7e53562e253c3bf010e8b8e201109a1c32fffd1f.file.blockcurrencies.tpl.php
224cache/smarty/compile/8c/8f/68/8c8f68cb0021c7f0f061c881c3be5af7dad11de8.file.blocklanguages.tpl.php
225tools/smarty/plugins/modifier.regex_replace.php
226cache/smarty/cache/blockcontact/1/1/16/c9/a9/ac/c9a9ac7376f33a8a7802a67d7cc17d802be9c24b.nav.tpl.php
227cache/smarty/compile/0f/8a/7a/0f8a7a5db83aba2c1f036d4db5301f4fb9424464.file.breadcrumb.tpl.php
228./odkazy-rotator-levysloupec.php
229./funkce.php
230./odkazy-rotator.php
231cache/smarty/compile/be/71/1e/be711ef28eb57a77159ad5dc0b2238552b29a082.file.footer.tpl.php
232tools/smarty/plugins/modifier.date_format.php
233cache/smarty/compile/9d/44/79/9d4479615e34c6648a386f9152add6c3fb4b75bb.file.blockcmsinfo.tpl.php
234tools/smarty/plugins/shared.make_timestamp.php
235cache/smarty/compile/77/0f/e3/770fe3d3f1d5ac5241e5111735d5feb9ee312801.file.global.tpl.php
236cache/smarty/compile/21/82/9a/21829af81fd8cb17a6f884dcffdd4ea65ac1fc88.file.javascript.tpl.php