Load Time353 ms - Unicorn powered webserver!
Querying Time51 ms
Queries37
Memory Peak Usage8.5 Mb
Included Files159 files - 5.77 Mb
PrestaShop Cache0.45 Mb
Global vars2.74 Mb
PrestaShop Version1.6.1.21
PHP Version7.1.27 (OK)
MySQL Version10.2.22-MariaDB (OK)
Memory Limit1G
Max Execution Time300s
Smarty Cachedisabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 152 ms 152 ms 3.42 Mb 6.26 Mb
__construct 0 ms 152 ms - Mb 6.26 Mb
init 201 ms 353 ms 1.52 Mb 8.46 Mb
Hook Time Memory Usage
__construct 128 ms 4.00 Mb
hookmoduleRoutes - ms - Mb
2 hooks 128 ms 4.00 Mb
Module Time Memory Usage
envoimoinscher 41 ms - Mb
spmgsnipreview 34 ms 4.00 Mb
lemonway 13 ms - Mb
advanceddateofdelivery 9 ms - Mb
cronjobs 6 ms - Mb
wkassigncomb 5 ms 2.00 Mb
prodquestions 4 ms - Mb
pk_testimonials 3 ms - Mb
pk_awshowcaseslider 3 ms - Mb
ph_simpleblog 3 ms - Mb
pk_bannercarousel 3 ms - Mb
advancedcms 2 ms - Mb
pagecache 2 ms - Mb
13 modules 128 ms 4.00 Mb

Stopwatch SQL - 37 queries

Query Time (ms) Rows Filesort Group By Location
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 `pscx_configuration` c
LEFT JOIN `pscx_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
12 1644 /classes/Configuration.php:148
SELECT SQL_NO_CACHE *
FROM `pscx_tab` a
LEFT JOIN `pscx_tab_lang` `b` ON a.`id_tab` = b.`id_tab` AND b.`id_lang` = 2
WHERE (a.`id_tab` = 21) LIMIT 1
11.1 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `pscx_access` a
LEFT JOIN `pscx_tab` t ON t.id_tab = a.id_tab
WHERE `id_profile` = 0
3.9 1 /classes/Profile.php:143
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `pscx_module` m
INNER JOIN `pscx_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `pscx_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.6 310 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `pscx_module` m
INNER JOIN pscx_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 `pscx_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `pscx_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `pscx_hook` h ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
2.5 128 Yes Yes /classes/Hook.php:355
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `pscx_spmgsnipreview_storereviews` pc
WHERE is_deleted = 0 AND is_new = 1 AND  id_shop = 1 LIMIT 1
2.3 1 /modules/spmgsnipreview/classes/storereviews.class.php:1379
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `pscx_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `pscx_module` m
1.4 155 /classes/module/Module.php:277
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `pscx_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `pscx_module` m
1.3 155 /classes/module/Module.php:277
SELECT SQL_NO_CACHE COUNT(`id`) AS "count"
FROM `pscx_spmgsnipreview` pc
WHERE is_new = 1 AND  id_shop = 1 LIMIT 1
1.2 0 /modules/spmgsnipreview/classes/spmgsnipreviewhelp.class.php:251
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `pscx_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `pscx_module` m
1.1 155 /classes/module/Module.php:277
SELECT SQL_NO_CACHE id_tab, class_name FROM `pscx_tab`
1.1 140 /classes/Tab.php:296
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `pscx_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `pscx_hook_alias` ha
INNER JOIN `pscx_hook` h ON ha.name = h.name
1 0 /classes/Hook.php:131
UPDATE `pscx_employee`
SET `last_connection_date` = CURRENT_DATE()
WHERE `id_employee` = 0 AND `last_connection_date`< CURRENT_DATE()
1 1 /classes/Employee.php:493
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pscx_shop_url su
LEFT JOIN pscx_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.ilovhair.fr' OR su.domain_ssl = 'www.ilovhair.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.8 1 Yes /classes/shop/Shop.php:334
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pscx_meta` m
LEFT JOIN `pscx_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.8 45 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pscx_lang` l
JOIN pscx_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.6 4 /classes/Language.php:892
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 pscx_shop_group gs
LEFT JOIN pscx_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pscx_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.6 1 Yes /classes/shop/Shop.php:663
SELECT SQL_NO_CACHE t.`class_name`, t.`module`
FROM `pscx_tab` t
WHERE t.`module` IS NOT NULL AND t.`module` != ""
0.5 140 /classes/Tab.php:235
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 pscx_shop_group gs
LEFT JOIN pscx_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pscx_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:663
SELECT SQL_NO_CACHE value FROM `pscx_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.4 1 /classes/shop/Shop.php:1067
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM pscx_shop s
LEFT JOIN pscx_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN pscx_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:202
SELECT SQL_NO_CACHE *
FROM `pscx_lang` a
LEFT JOIN `pscx_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `pscx_currency` a
LEFT JOIN `pscx_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `pscx_tab` t
LEFT JOIN `pscx_tab_lang` tl
ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 2)
WHERE t.`id_tab` = 21 LIMIT 1
0.3 1 /classes/Tab.php:216
SELECT SQL_NO_CACHE *
FROM `pscx_country` a
LEFT JOIN `pscx_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `pscx_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `pscx_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pscx_lang` l
LEFT JOIN `pscx_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 2 /classes/Language.php:777
SELECT SQL_NO_CACHE * FROM `pscx_hook_alias`
0.3 86 /classes/Hook.php:187
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pscx_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE * FROM `pscx_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2 75 /classes/module/Module.php:2141
SELECT SQL_NO_CACHE `id_module` FROM `pscx_module` WHERE `name` = "pagecache" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `pscx_smarty_last_flush` WHERE type='compile' LIMIT 1
0.2 1 /classes/SmartyCustom.php:95
SELECT SQL_NO_CACHE *
FROM `pscx_tab` t
LEFT JOIN `pscx_tab_lang` tl
ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 2)
WHERE t.`id_tab` = 9 LIMIT 1
0.2 1 /classes/Tab.php:216
SELECT SQL_NO_CACHE *
FROM `pscx_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `pscx_module` WHERE `name` = "bvkseodispatcher" LIMIT 1
0.2 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE `id_module` FROM `pscx_module_shop` WHERE `id_module` = 198 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `pscx_theme` a
WHERE (a.`id_theme` = 4) LIMIT 1
0.2 1 /Adapter/Adapter_EntityMapper.php:61

Doubles

3
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `pscx_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `pscx_module` m
2
				SELECT *
				FROM `pscx_tab` t
				LEFT JOIN `pscx_tab_lang` tl
					ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX)
				WHERE t.`id_tab` = XX LIMIT XX
2
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 pscx_shop_group gs
				LEFT JOIN pscx_shop s
					ON s.id_shop_group = gs.id_shop_group
				LEFT JOIN pscx_shop_url su
					ON s.id_shop = su.id_shop AND su.main = XX
				
				WHERE s.deleted = XX
					AND gs.deleted = XX
					
				ORDER BY gs.name, s.name

Tables stress

7 module
6 tab
6 module_shop
5 shop_url
5 shop
4 hook
3 shop_group
3 tab_lang
3 lang
3 lang_shop
2 hook_alias
2 hook_module
2 theme
2 configuration
1 country_shop
1 country_lang
1 country
1 meta
1 meta_lang
1 configuration_lang
1 access
1 currency
1 currency_shop
1 hook_module_exceptions
1 spmgsnipreview_storereviews
1 spmgsnipreview
1 smarty_last_flush

ObjectModel instances

NameInstancesSource
Shop 1 /config/config.inc.php [114]
Theme 1 /config/config.inc.php [115]
Country 1 /config/config.inc.php [142]
Employee 1 /config/config.inc.php [182]
Language 1 /config/config.inc.php [198]
Tab 1 /override/classes/Dispatcher.php [283]
Currency 1 /classes/controller/AdminController.php [506]
Category 1 /controllers/admin/AdminProductsController.php [162]
ShopGroup 1 /classes/shop/Shop.php [518]

Included Files

#Filename
1/admin123/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/settings.inc.php
5/config/autoload.php
6/config/alias.php
7/classes/PrestaShopAutoload.php
8/cache/class_index.php
9/config/bootstrap.php
10/Core/Business/Core_Business_ContainerBuilder.php
11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
12/Adapter/Adapter_ServiceLocator.php
13/classes/controller/Controller.php
14/classes/ObjectModel.php
15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
16/classes/db/Db.php
17/classes/Tools.php
18/classes/Context.php
19/classes/shop/Shop.php
20/classes/db/DbPDO.php
21/classes/Configuration.php
22/override/classes/Configuration.php
23/classes/Validate.php
24/classes/cache/Cache.php
25/Adapter/Adapter_EntityMapper.php
26/classes/db/DbQuery.php
27/classes/Theme.php
28/config/defines_uri.inc.php
29/tools/htmlpurifier/HTMLPurifier.standalone.php
30/classes/Language.php
31/classes/Country.php
32/classes/PrestaShopCollection.php
33/classes/Cookie.php
34/classes/Rijndael.php
35/classes/Employee.php
36/config/smarty.config.inc.php
37/tools/smarty/Smarty.class.php
38/tools/smarty/sysplugins/smarty_internal_data.php
39/tools/smarty/sysplugins/smarty_internal_templatebase.php
40/tools/smarty/sysplugins/smarty_internal_template.php
41/tools/smarty/sysplugins/smarty_resource.php
42/tools/smarty/sysplugins/smarty_internal_resource_file.php
43/tools/smarty/sysplugins/smarty_cacheresource.php
44/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
45/classes/SmartyCustom.php
46/config/smartyadmin.config.inc.php
47/classes/Link.php
48/override/classes/Link.php
49/classes/shop/ShopUrl.php
50/admin123/functions.php
51/images.inc.php
52/classes/Dispatcher.php
53/override/classes/Dispatcher.php
54/classes/Hook.php
55/override/classes/Hook.php
56/classes/Group.php
57/override/classes/Group.php
58/tools/mobile_Detect/Mobile_Detect.php
59/config/db_slave_server.inc.php
60/classes/module/Module.php
61/modules/ph_simpleblog/ph_simpleblog.php
62/modules/ph_simpleblog/assets/phpthumb/ThumbLib.inc.php
63/modules/ph_simpleblog/assets/phpthumb/PhpThumb.inc.php
64/modules/ph_simpleblog/assets/phpthumb/ThumbBase.inc.php
65/modules/ph_simpleblog/assets/phpthumb/GdThumb.inc.php
66/modules/ph_simpleblog/models/SimpleBlogHelper.php
67/modules/ph_simpleblog/models/SimpleBlogCategory.php
68/modules/ph_simpleblog/models/SimpleBlogPost.php
69/modules/ph_simpleblog/models/SimpleBlogTag.php
70/classes/Translate.php
71/themes/alysum/modules/ph_simpleblog/translations/fr.php
72/modules/ph_simpleblog/translations/fr.php
73/modules/advancedcms/advancedcms.php
74/modules/advancedcms/translations/fr.php
75/modules/advancedcms/classes/AdvancedCMSPage.php
76/modules/advancedcms/classes/AdvancedCMSContainer.php
77/modules/advancedcms/classes/AdvancedCMSBlock.php
78/modules/advancedcms/classes/AdvancedCmsBlockModel.php
79/modules/pagecache/pagecache.php
80/modules/pagecache/PageCacheURLNormalizer.php
81/modules/pagecache/PageCacheUtils.php
82/modules/pagecache/PageCacheCache.php
83/modules/pagecache/PageCacheCacheSimpleFS.php
84/modules/pagecache/PageCacheCacheMultiStore.php
85/modules/pagecache/PageCacheCacheZipArchive.php
86/modules/pagecache/PageCacheDAO.php
87/modules/pagecache/http_build_url.php
88/classes/Tab.php
89/controllers/admin/AdminProductsController.php
90/classes/controller/AdminController.php
91/translations/fr/admin.php
92/classes/Profile.php
93/classes/Currency.php
94/themes/alysum/modules/pk_themesettings/translations/fr.php
95/modules/pk_themesettings/translations/fr.php
96/themes/alysum/modules/advanceddateofdelivery/translations/fr.php
97/modules/advanceddateofdelivery/translations/fr.php
98/classes/Category.php
99/override/classes/Category.php
100/classes/stock/StockAvailable.php
101/classes/shop/ShopGroup.php
102/themes/alysum/modules/pagecache/translations/fr.php
103/modules/pagecache/fr.php
104/modules/cronjobs/cronjobs.php
105/modules/cronjobs/classes/CronJobsForms.php
106/themes/alysum/modules/cronjobs/translations/fr.php
107/modules/cronjobs/translations/fr.php
108/modules/pk_bannercarousel/pk_bannercarousel.php
109/themes/alysum/modules/pk_bannercarousel/translations/fr.php
110/modules/pk_bannercarousel/translations/fr.php
111/modules/pk_awshowcaseslider/pk_awshowcaseslider.php
112/themes/alysum/modules/pk_awshowcaseslider/translations/fr.php
113/modules/pk_awshowcaseslider/translations/fr.php
114/modules/pk_testimonials/pk_testimonials.php
115/themes/alysum/modules/pk_testimonials/translations/fr.php
116/modules/pk_testimonials/translations/fr.php
117/classes/Media.php
118/override/classes/Media.php
119/modules/envoimoinscher/envoimoinscher.php
120/classes/module/CarrierModule.php
121/modules/envoimoinscher/includes/EnvoimoinscherModel.php
122/modules/envoimoinscher/includes/EnvoimoinscherHelper.php
123/modules/envoimoinscher/includes/EnvoimoinscherOrder.php
124/modules/envoimoinscher/includes/autoload.php
125/modules/envoimoinscher/includes/config.php
126/modules/envoimoinscher/Env/Autoloader.php
127/themes/alysum/modules/envoimoinscher/translations/fr.php
128/modules/envoimoinscher/translations/fr.php
129/modules/lemonway/lemonway.php
130/modules/lemonway/services/LemonWayConfig.php
131/modules/lemonway/classes/SplitpaymentProfile.php
132/modules/lemonway/classes/SplitpaymentDeadline.php
133/modules/lemonway/services/LemonWayKit.php
134/modules/lemonway/classes/methods/Cc.php
135/modules/lemonway/classes/methods/Method.php
136/modules/lemonway/classes/methods/CcXtimes.php
137/classes/PaymentModule.php
138/themes/alysum/modules/lemonway/translations/fr.php
139/modules/lemonway/translations/fr.php
140/modules/advanceddateofdelivery/advanceddateofdelivery.php
141/modules/wkassigncomb/wkassigncomb.php
142/themes/alysum/modules/wkassigncomb/translations/fr.php
143/modules/wkassigncomb/translations/fr.php
144/modules/prodquestions/prodquestions.php
145/modules/prodquestions/translations/fr.php
146/modules/prodquestions/views/templates/hooks/hookDisplayBackOfficeHeader.phtml
147/modules/spmgsnipreview/spmgsnipreview.php
148/modules/spmgsnipreview/translations/fr.php
149/modules/spmgsnipreview/views/templates/hooks/hookdisplayBackOfficeHeader.phtml
150/modules/spmgsnipreview/classes/storereviews.class.php
151/modules/spmgsnipreview/classes/spmgsnipreviewhelp.class.php
152/cache/smarty/compile/e1/34/17/e13417cd08a044f7f30835095389e34d0b38fcad.file.header_info.tpl.php
153/tools/smarty/plugins/modifier.escape.php
154/translations/fr/errors.php
155/cache/smarty/compile/40/4e/9d/404e9d9dfa5bfb37a56596345ebe892e148c1ffa.file.login_addons.tpl.php