ΙΕΚ ΑΙΓΑΛΕΩ

Κονσόλα Αποσφαλμάτωσης του Joomla!

Συνεδρία

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1785377795,
                "last": 1785377795,
                "now": 1785377795
            },
            "client": {
                "forwarded": "216.73.217.98"
            },
            "token": "v3JnQcTwwEOpI0AtcH2wXlhRcFVgdaPm"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Πληροφορίες Προφίλ

Χρόνος

Μνήμη

Χρόνος: 4.09 ms / 4.09 ms Μνήμη: 0.407 MB / 0.75 MB Application: afterLoad

Χρόνος: 34.15 ms / 38.25 ms Μνήμη: 3.561 MB / 4.31 MB Application: afterInitialise

Χρόνος: 28.89 ms / 67.14 ms Μνήμη: 0.471 MB / 4.78 MB Application: afterRoute

Χρόνος: 2.47 ms / 69.61 ms Μνήμη: 0.040 MB / 4.82 MB Application: beforeRenderComponent com_zoo

Χρόνος: 4.31 ms / 73.92 ms Μνήμη: 0.204 MB / 5.03 MB Application: Before Access::preloadComponents (all components)

Χρόνος: 1.13 ms / 75.05 ms Μνήμη: 0.041 MB / 5.07 MB Application: After Access::preloadComponents (all components)

Χρόνος: 0.02 ms / 75.07 ms Μνήμη: -0.003 MB / 5.07 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Χρόνος: 0.17 ms / 75.25 ms Μνήμη: 0.008 MB / 5.07 MB Application: After Access::getAssetRules (id:1 name:root.1)

Χρόνος: 6.73 ms / 81.98 ms Μνήμη: 0.389 MB / 5.46 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Χρόνος: 0.01 ms / 81.99 ms Μνήμη: 0.002 MB / 5.46 MB Application: After Access::getAssetRules (id:1 name:root.1)

Χρόνος: 0.91 ms / 82.89 ms Μνήμη: 0.113 MB / 5.58 MB Application: Before Access::preloadPermissions (com_zoo)

Χρόνος: 0.97 ms / 83.87 ms Μνήμη: 0.015 MB / 5.59 MB Application: After Access::preloadPermissions (com_zoo)

Χρόνος: 1.39 ms / 85.25 ms Μνήμη: 0.114 MB / 5.71 MB Application: Before Access::getAssetRules (id:781 name:com_zoo)

Χρόνος: 0.03 ms / 85.28 ms Μνήμη: 0.002 MB / 5.71 MB Application: After Access::getAssetRules (id:781 name:com_zoo)

Χρόνος: 8.82 ms / 94.10 ms Μνήμη: 0.310 MB / 6.02 MB Application: afterRenderComponent com_zoo

Χρόνος: 5.26 ms / 99.36 ms Μνήμη: 0.122 MB / 6.14 MB Application: afterDispatch

Χρόνος: 26.87 ms / 126.23 ms Μνήμη: 0.927 MB / 7.07 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Χρόνος: 0.90 ms / 127.14 ms Μνήμη: 0.014 MB / 7.08 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Χρόνος: 0.54 ms / 127.68 ms Μνήμη: -0.001 MB / 7.08 MB Application: beforeRenderModule mod_menu ()

Χρόνος: 2.31 ms / 129.98 ms Μνήμη: 0.050 MB / 7.13 MB Application: afterRenderModule mod_menu ()

Χρόνος: 0.24 ms / 130.22 ms Μνήμη: -0.020 MB / 7.11 MB Application: beforeRenderModule mod_custom ()

Χρόνος: 2.67 ms / 132.89 ms Μνήμη: 0.028 MB / 7.14 MB Application: afterRenderModule mod_custom ()

Χρόνος: 0.38 ms / 133.27 ms Μνήμη: 0.002 MB / 7.14 MB Application: beforeRenderModule mod_menu (Toolbar Menu)

Χρόνος: 1.13 ms / 134.39 ms Μνήμη: 0.015 MB / 7.16 MB Application: afterRenderModule mod_menu (Toolbar Menu)

Χρόνος: 0.22 ms / 134.61 ms Μνήμη: -0.008 MB / 7.15 MB Application: beforeRenderModule mod_menu ()

Χρόνος: 0.74 ms / 135.35 ms Μνήμη: 0.022 MB / 7.17 MB Application: afterRenderModule mod_menu ()

Χρόνος: 0.02 ms / 135.37 ms Μνήμη: -0.020 MB / 7.15 MB Application: beforeRenderModule mod_custom ()

Χρόνος: 0.57 ms / 135.94 ms Μνήμη: 0.002 MB / 7.15 MB Application: afterRenderModule mod_custom ()

Χρόνος: 5.20 ms / 141.14 ms Μνήμη: 0.069 MB / 7.22 MB Application: afterRender

Ολικές επερωτήσεις βάσης δεδομένων¨40.43 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_session	const	PRIMARY	PRIMARY	194	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Καλών	Αρχείο και αριθμός σειράς
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'71746371333736333773756467386d646d616c71367237327165', 1, 1785377795, 0, '', 0)

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
update	0.06 ms
end	0.01 ms
query end	0.54 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.59 ms Μετά την τελευταία επερώτηση:0.49 ms Μνήμη με επερώτηση: 0.040 MB Μνήμη πριν την επερώτηση: 1.083 MB Σειρές που επιστράφηκαν:41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j25_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

Προφίλ

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.28 ms Μετά την τελευταία επερώτηση:0.70 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.123 MB Σειρές που επιστράφηκαν:3

SELECT id, rules

  FROM `j25_viewlevels`

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_viewlevels	ALL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	3

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.134 MB Σειρές που επιστράφηκαν:1

SELECT b.id

  FROM j25_usergroups AS a

  LEFT JOIN j25_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Προφίλ

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.79 ms Μετά την τελευταία επερώτηση:0.15 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 1.155 MB Σειρές που επιστράφηκαν:101

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM j25_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_extensions	ref	extension	extension	82	const	122	Using index condition; Using where; Χρήση ταξινόμησης αρχείου

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.45 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:3.34 ms Μετά την τελευταία επερώτηση:13.36 ms Μνήμη με επερώτηση: 0.655 MB Μνήμη πριν την επερώτηση: 1.841 MB Σειρές που επιστράφηκαν:562

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM j25_menu AS m

  LEFT JOIN j25_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	595	Using index condition; Using where; Χρήση ταξινόμησης αρχείου
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.m.component_id	1	Using where

Προφίλ

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	2.95 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/shlib/shlib_runtime.php:70
8	plgSystemShlib->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:3.23 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.997 MB Σειρές που επιστράφηκαν:2

SELECT *

  FROM j25_languages

  ORDER BY ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_languages	ALL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	2	Χρήση ταξινόμησης αρχείου

Προφίλ

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:63
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:1.28 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 4.095 MB Σειρές που επιστράφηκαν:1

SELECT `params` 
  FROM j25_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:656
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:86
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.37 ms Μετά την τελευταία επερώτηση:7.24 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.523 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM `j25_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'item/iek-aigaleo.html') 
  order by `ordering` asc

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Προφίλ

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:221
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:115
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:188
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:645
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:263
10	Sh404sefClassRouterInternal->preprocessParseRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.33 ms Μετά την τελευταία επερώτηση:0.05 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.531 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM j25_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_aliases	system	type,state	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	1

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:278
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:188
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:645
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:263
10	Sh404sefClassRouterInternal->preprocessParseRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.25 ms Μετά την τελευταία επερώτηση:0.12 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 4.540 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM j25_sh404sef_pageids 
  WHERE `pageid`='item/iek-aigaleo.html';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_pageids	ref	alias	alias	572	const	1	Using where

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:2002
11	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:264
10	Sh404sefClassRouterInternal->preprocessParseRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.28 ms Μετά την τελευταία επερώτηση:0.17 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.552 MB Σειρές που επιστράφηκαν:2

SELECT *

  FROM j25_languages

  WHERE published=1

  ORDER BY ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_languages	ALL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	2	Using where; Χρήση ταξινόμησης αρχείου

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
17	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:1709
16	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1678
15	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1624
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1298
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2282
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:399
11	Sh404sefClassRouterInternal->parseRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.33 ms Μετά την τελευταία επερώτηση:0.53 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.573 MB Σειρές που επιστράφηκαν:1

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM j25_sh404sef_urls 
  WHERE `oldurl`='item/iek-aigaleo.html' 
  ORDER BY `rank`;

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_urls	ref	oldurl	oldurl	573	const	1	Using where; Χρήση ταξινόμησης αρχείου

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1638
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1298
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2282
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:399
11	Sh404sefClassRouterInternal->parseRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:17.71 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.008 MB Μνήμη πριν την επερώτηση: 4.584 MB

UPDATE `j25_sh404sef_urls` 
  SET `cpt`=4280, `last_hit`='2026-07-30 02:16:35' 
  WHERE `id`='24633' 
  AND `rank`=0;

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `j25_sh404sef_urls` SET `cpt`=4280, `last_hit`='2026-07-30 02:16:35' WHERE `id`='24633' AND `rank`=0;

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for table level lock	17.34 ms
Table lock	0.01 ms
init	0.06 ms
updating	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1317
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2282
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:399
11	Sh404sefClassRouterInternal->parseRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.58 ms Μετά την τελευταία επερώτηση:1.15 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 4.673 MB Σειρές που επιστράφηκαν:1

SELECT id, home, template, s.params

  FROM j25_template_styles as s

  LEFT JOIN j25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Προφίλ

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:97
13	YOOtheme\Theme\Joomla\ThemeLoader::getTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:38
12	YOOtheme\Theme\Joomla\ThemeLoader::initTheme()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
11	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:71
10	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:117
9	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:47
8	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:44
7	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.35 ms Μετά την τελευταία επερώτηση:2.07 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.811 MB Σειρές που επιστράφηκαν:1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j25_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.36 ms Μετά την τελευταία επερώτηση:0.11 ms Μνήμη με επερώτηση: 0.005 MB Μνήμη πριν την επερώτηση: 4.801 MB

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"cdff64b3296846f164b8843887a55ac7\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `j25_extensions` SET `params` = '{\"mediaversion\":\"cdff64b3296846f164b8843887a55ac7\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
updating	0.05 ms
end	0.01 ms
query end	1.08 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.43 ms Μετά την τελευταία επερώτηση:2.36 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.955 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM j25_zoo_item 
  WHERE id = 1979

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1

Προφίλ

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
11	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
10	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
9	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:75
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.30 ms Μετά την τελευταία επερώτηση:0.55 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.983 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM j25_zoo_application 
  WHERE id = 4

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_zoo_application	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
12	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
11	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
10	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
9	AppTable->get()	JROOT/administrator/components/com_zoo/classes/item.php:326
8	Item->getApplication()	JROOT/administrator/components/com_zoo/helpers/zoo.php:76
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.95 ms Μετά την τελευταία επερώτηση:1.27 ms Μνήμη με επερώτηση: 0.028 MB Μνήμη πριν την επερώτηση: 5.016 MB Σειρές που επιστράφηκαν:39

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `j25_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sh404sef','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zoo')

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_assets	range	idx_asset_name	idx_asset_name	202	NULL	41	Using index condition

Προφίλ

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.45 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
12	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
11	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:106
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:1.10 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 5.090 MB Σειρές που επιστράφηκαν:2

SELECT * 
  FROM j25_zoo_category 
  WHERE application_id = 4 
  AND published = 1 
  ORDER BY ordering

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_zoo_category	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	2	Using where; Χρήση ταξινόμησης αρχείου

Προφίλ

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
19	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
18	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
17	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
16	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
15	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:227
14	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
13	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
12	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/route.php:295
11	RouteHelper->item()	JROOT/components/com_zoo/controllers/default.php:131
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:1.89 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 5.376 MB

UPDATE j25_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 1979

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE j25_zoo_item SET hits = (hits + 1) WHERE id = 1979

Προφίλ

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
updating	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
12	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:674
11	Item->hit()	JROOT/components/com_zoo/controllers/default.php:167
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.23 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 5.384 MB Σειρές που επιστράφηκαν:1

SELECT id 
  FROM j25_users 
  WHERE id = 62

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_users	const	PRIMARY	PRIMARY	4	const	1	Using index

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
13	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:44
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.94 ms Μετά την τελευταία επερώτηση:0.42 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 5.400 MB Σειρές που επιστράφηκαν:17

SHOW FULL COLUMNS 
  FROM `j25_users`

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `j25_users`

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.33 ms Μετά την τελευταία επερώτηση:0.32 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 5.432 MB Σειρές που επιστράφηκαν:1

SELECT *

  FROM `j25_users`

  WHERE `id` = 62

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_users	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.34 ms Μετά την τελευταία επερώτηση:0.19 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 5.445 MB Σειρές που επιστράφηκαν:1

SELECT `g`.`id`,`g`.`title`

  FROM `j25_usergroups` AS g

  INNER JOIN `j25_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 62

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.m.group_id	1

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.33 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 5.453 MB Σειρές που επιστράφηκαν:2

SELECT b.id

  FROM j25_user_usergroup_map AS map

  LEFT JOIN j25_usergroups AS a 
  ON a.id = map.group_id

  LEFT JOIN j25_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE map.user_id = 62

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.map.group_id	1
1	SIMPLE	b	ALL	idx_usergroup_nested_set_lookup	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	8	Range checked for each record (index map: 0x10)

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
16	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
15	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/libraries/src/User/User.php:386
14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
13	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.86 ms Μετά την τελευταία επερώτηση:1.02 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 5.578 MB Σειρές που επιστράφηκαν:5

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `j25_assets`

  WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_assets	ALL	idx_asset_name,idx_parent_id	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	789	Using where

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.56 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
23	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
18	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
17	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
16	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
15	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
14	Item->canEdit()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:11
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.65 ms Μετά την τελευταία επερώτηση:0.30 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 5.677 MB Σειρές που επιστράφηκαν:8

SHOW FULL COLUMNS 
  FROM `j25_assets`

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `j25_assets`

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.19 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
23	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
18	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
17	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
16	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
15	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
14	Item->canEdit()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:11
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.26 ms Μετά την τελευταία επερώτηση:0.16 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 5.701 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33

SELECT *

  FROM j25_assets

  WHERE `name` = 'com_zoo.application.4.iek'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Προφίλ

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
18	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
17	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
16	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
15	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
14	Item->canEdit()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:11
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.24 ms Μετά την τελευταία επερώτηση:0.17 ms Μνήμη με επερώτηση: 0.028 MB Μνήμη πριν την επερώτηση: 5.721 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #32

SELECT *

  FROM j25_assets

  WHERE `name` = 'com_zoo.application.4.iek'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
22	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
21	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
17	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
16	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
15	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
14	Item->canEdit()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:11
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.30 ms Μετά την τελευταία επερώτηση:1.56 ms Μνήμη με επερώτηση: 0.035 MB Μνήμη πριν την επερώτηση: 5.878 MB Σειρές που επιστράφηκαν:0

SELECT `oldurl`, `dateadd` 
  FROM j25_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_zoo&Itemid=762&element=cf6dd846-5774-47aa-8ca7-c1623c06e130&format=raw&item_id=1979&lang=el&task=callelement';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
41	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
40	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
39	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
38	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
37	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:767
36	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:804
35	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1521
34	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1157
33	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2288
32	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1011
31	Sh404sefClassRouterInternal->buildRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
30	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
29	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
28	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
27	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
26	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
25	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
24	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
23	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_zoo/framework/classes/component.php:78
22	AppComponent->link()	JROOT/administrator/components/com_zoo/framework/classes/app.php:192
21	App->link()	JROOT/media/zoo/elements/rating/rating.php:78
20	ElementRating->render()	JROOT/components/com_zoo/renderer/element/comma.php:23
19	include JROOT/components/com_zoo/renderer/element/comma.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
18	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
17	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php:20
16	include JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:22
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.35 ms Μετά την τελευταία επερώτηση:2.69 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 5.925 MB Σειρές που επιστράφηκαν:7

SELECT name 
  FROM j25_zoo_tag 
  WHERE item_id = 1979

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_zoo_tag	ref	PRIMARY	PRIMARY	4	const	7	Using index

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
22	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
21	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/tables/tag.php:93
20	TagTable->getItemTags()	JROOT/administrator/components/com_zoo/classes/item.php:631
19	Item->getTags()	JROOT/media/zoo/elements/itemtag/itemtag.php:40
18	ElementItemTag->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php:67
16	include JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:22
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.34 ms Μετά την τελευταία επερώτηση:1.35 ms Μνήμη με επερώτηση: 0.034 MB Μνήμη πριν την επερώτηση: 6.034 MB Σειρές που επιστράφηκαν:0

SELECT `oldurl`, `dateadd` 
  FROM j25_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_zoo&Itemid=762&app_id=4&lang=el&tag=%CE%9F%CE%B9%CE%BA%CE%BF%CE%BD%CE%BF%CE%BC%CE%AF%CE%B1+&task=tag&διοίκηση=';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
38	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
37	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
36	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
35	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:767
34	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:804
33	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1521
32	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1157
31	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2288
30	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1011
29	Sh404sefClassRouterInternal->buildRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
28	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
27	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
26	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
25	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/media/zoo/elements/itemtag/itemtag.php:61
20	ElementItemTag->render()	JROOT/media/zoo/applications/business/templates/uikit3/renderer/element/uikit_panel.php:19
19	include JROOT/media/zoo/applications/business/templates/uikit3/renderer/element/uikit_panel.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
18	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
17	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php:69
16	include JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:22
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.34 ms Μετά την τελευταία επερώτηση:0.47 ms Μνήμη με επερώτηση: 0.035 MB Μνήμη πριν την επερώτηση: 6.062 MB Σειρές που επιστράφηκαν:1

SELECT `oldurl` 
  FROM j25_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_zoo&Itemid=762&app_id=4&lang=el&tag=%CE%9F%CE%B9%CE%BA%CE%BF%CE%BD%CE%BF%CE%BC%CE%AF%CE%B1+&task=tag';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_urls	ref	newurl	newurl	573	const	360	Using where

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
41	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
40	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
39	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
38	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
37	ShlDbHelper::selectResult()	JROOT/components/com_sh404sef/sef_ext.php:813
36	sef_404::sefGetLocation()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:498
35	shFinalizePlugin()	JROOT/components/com_zoo/sef_ext/com_zoo.php:222
34	include JROOT/components/com_zoo/sef_ext/com_zoo.php	JROOT/components/com_sh404sef/sef_ext.php:388
33	sef_404->create()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1740
32	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1157
31	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2288
30	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1011
29	Sh404sefClassRouterInternal->buildRule()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
28	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
27	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
26	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
25	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
21	Joomla\CMS\Router\Route::_()	JROOT/media/zoo/elements/itemtag/itemtag.php:61
20	ElementItemTag->render()	JROOT/media/zoo/applications/business/templates/uikit3/renderer/element/uikit_panel.php:19
19	include JROOT/media/zoo/applications/business/templates/uikit3/renderer/element/uikit_panel.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
18	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
17	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php:69
16	include JROOT/media/zoo/applications/business/templates/uikit3/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
14	ItemRenderer->render()	JROOT/media/zoo/applications/business/templates/uikit3/item.php:22
13	include JROOT/media/zoo/applications/business/templates/uikit3/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:199
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.30 ms Μετά την τελευταία επερώτηση:3.79 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 6.070 MB Σειρές που επιστράφηκαν:0

SELECT `pageid` 
  FROM j25_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_zoo&Itemid=762&item_id=1979&lang=el&task=item';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j25_sh404sef_pageids	ref	newurl	newurl	573	const	1	Using where

Προφίλ

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
11	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
10	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
9	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
8	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:217
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.22 ms Μετά την τελευταία επερώτηση:0.56 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 6.089 MB Σειρές που επιστράφηκαν:36

SHOW FULL COLUMNS 
  FROM `j25_sh404sef_metas`

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `j25_sh404sef_metas`

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.33 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
14	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:33
12	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
11	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:118
10	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:164
9	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:359
8	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:232
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.26 ms Μετά την τελευταία επερώτηση:0.12 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 6.133 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM j25_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_zoo&Itemid=762&item_id=1979&lang=el&task=item';

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Προφίλ

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:34
12	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
11	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:118
10	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:164
9	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:359
8	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:232
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.49 ms Μετά την τελευταία επερώτηση:0.78 ms Μνήμη με επερώτηση: 0.035 MB Μνήμη πριν την επερώτηση: 6.224 MB Σειρές που επιστράφηκαν:7

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM j25_modules AS m

  LEFT JOIN j25_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN j25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-30 02:16:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-30 02:16:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 762 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	11	Using index condition; Using where; Χρήση ταξινόμησης αρχείου
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	foitit_foit.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	foitit_foit.m.id	5	Using where; Using index

Προφίλ

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
37	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
36	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
35	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
34	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
33	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
32	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:268
31	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:283
30	YOOtheme\Container->YOOtheme\{closure}()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
29	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:89
28	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:31
27	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:287
26	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:15
25	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:164
24	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:61
23	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:164
22	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:22
21	YOOtheme\Theme\Joomla\UrlListener::resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:164
20	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:249
19	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
18	YOOtheme\View->__invoke()	JROOT/templates/yootheme/templates/header.php:111
17	require JROOT/templates/yootheme/templates/header.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:287
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:15
15	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:164
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:61
13	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:164
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:22
11	YOOtheme\Theme\Joomla\UrlListener::resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:164
10	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:249
9	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
8	YOOtheme\View->__invoke()	JROOT/templates/yootheme/index.php:129
7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.27 ms Μετά την τελευταία επερώτηση:30.56 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 7.146 MB Σειρές που επιστράφηκαν:0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM j25_fields AS a

  LEFT JOIN `j25_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN j25_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN j25_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN j25_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	foitit_foit.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	foitit_foit.a.group_id	1	Using where

Προφίλ

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.37 ms
Creating sort index	0.05 ms
removing tmp table	0.08 ms
Creating sort index	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:29
7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Καταγράφηκαν 37 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `j25_assets`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `j25_extensions`

```
2 × SELECT * 
  FROM j25_languages
```

2 × SELECT `oldurl`, `dateadd` 
  FROM j25_sh404sef_urls

```
2 × SELECT * 
  FROM j25_assets
```

1 × SELECT `data` 
  FROM `j25_session`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM j25_modules AS m 
  LEFT JOIN j25_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN j25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM j25_sh404sef_metas

1 × SELECT `pageid` 
  FROM j25_sh404sef_pageids

1 × SELECT `oldurl` 
  FROM j25_sh404sef_urls

```
1 × SELECT name 
  FROM j25_zoo_tag
```

1 × SELECT b.id 
  FROM j25_user_usergroup_map AS map 
  LEFT JOIN j25_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN j25_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `j25_usergroups` AS g 
  INNER JOIN `j25_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `j25_users`
```
```
1 × SELECT id 
  FROM j25_users
```
```
1 × SELECT * 
  FROM j25_zoo_category
```

1 × SELECT * 
  FROM j25_zoo_application

1 × SELECT `session_id` 
  FROM `j25_session`

```
1 × SELECT * 
  FROM j25_zoo_item
```

1 × SELECT id, home, template, s.params 
  FROM j25_template_styles as s 
  LEFT JOIN j25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM j25_sh404sef_urls

1 × SELECT * 
  FROM j25_sh404sef_pageids

1 × SELECT * 
  FROM j25_sh404sef_aliases

1 × SELECT * 
  FROM `j25_sh404sef_aliases`

1 × SELECT `params` 
  FROM j25_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM j25_menu AS m 
  LEFT JOIN j25_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM j25_extensions

1 × SELECT b.id 
  FROM j25_usergroups AS a 
  LEFT JOIN j25_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `j25_viewlevels

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM j25_fields AS a 
  LEFT JOIN `j25_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN j25_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN j25_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN j25_fields_groups AS g 
  ON g.id = a.group_id

ΑΛΛΟΙ Πίνακες:

1 × INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'71746371333736333773756467386d646d616c71367237327165', 1, 1785377795, 0, '', 0

1 × UPDATE `j25_sh404sef_urls` 
  SET `cpt`=4280, `last_hit`='2026-07-30 02:16:35'

1 × UPDATE `j25_extensions` 
  SET `params` = '{\"mediaversion\":\"cdff64b3296846f164b8843887a55ac7\"}'

1 × UPDATE j25_zoo_item 
  SET hits = (hits + 1)

1 × SHOW FULL COLUMNS 
  FROM `j25_users

1 × SHOW FULL COLUMNS 
  FROM `j25_assets

1 × SHOW FULL COLUMNS 
  FROM `j25_sh404sef_metas

ΙΕΚ ΑΙΓΑΛΕΩ

Επικοινωνια

Ειδικότητες

Σχολές / Τμήματα

Οδηγός Πόλεων

Χρήσιμα Links

Social Media

Κονσόλα Αποσφαλμάτωσης του Joomla!

Συνεδρία

Πληροφορίες Προφίλ

Χρόνος

Μνήμη

Χρήση Μνήμης

Ερωτήματα Βάσης Δεδομένων

Καταγράφηκαν 42 ερωτήματα 40.43 ms

2 διπλότυπα βρέθηκαν!

Καταγράφηκαν 37 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

ΑΛΛΟΙ Πίνακες: