Benchtop refractometers

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1715158929,
                "last": 1715158929,
                "now": 1715158929
            },
            "token": "0vxE6fmKPeinta7MTFMNFkIYv7PyTjT6"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "fi-FI"
        }
    },
    "__items": {
        "ContractPriceFilterValue": null
    }
}

Aika

Muisti

23 kyselyä kirjattu 84.95 ms

1. Kyselyn aika: 19.22 ms Kysely muisti: 0.022 MB Muistia ennen kyselyä: 0.753 MB Rivejä palautettu: 0

   SELECT `data`
   
     FROM `j_session`
   
     WHERE `session_id` = X'6f3064686b3831313437706c3767723735686d6a6332746f3472'

   Selite

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

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Sama kuin kutsu alla olevalla rivillä.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

2. Kyselyn aika: 0.18 ms Viimeisen kyselyn jälkeen: 1.97 ms Kysely muisti: 0.020 MB Muistia ennen kyselyä: 0.764 MB Rivejä palautettu: 0

   SELECT `session_id`
   
     FROM `j_session`
   
     WHERE `session_id` = X'6f3064686b3831313437706c3767723735686d6a6332746f3472' 
     LIMIT 1

   Selite

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

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

3. Kyselyn aika: 17.61 ms Viimeisen kyselyn jälkeen: 0.08 ms Kysely muisti: 0.003 MB Muistia ennen kyselyä: 0.769 MB

   INSERT INTO `j_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6f3064686b3831313437706c3767723735686d6a6332746f3472', 1, 1715158929, 0, '', 0)

   Selite

   EXPLAIN ei mahdollinen kyselyssä: INSERT INTO `j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6f3064686b3831313437706c3767723735686d6a6332746f3472', 1, 1715158929, 0, '', 0)

   Profiili

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After table lock	0.00 ms
   init	0.01 ms
   update	8.11 ms
   end	0.00 ms
   query end	9.35 ms
   closing tables	0.01 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

4. Kyselyn aika: 0.38 ms Viimeisen kyselyn jälkeen: 2.08 ms Kysely muisti: 0.060 MB Muistia ennen kyselyä: 0.797 MB Rivejä palautettu: 39

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `j_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Selite

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

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   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}()	Sama kuin kutsu alla olevalla rivillä.
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

5. Kyselyn aika: 0.16 ms Viimeisen kyselyn jälkeen: 2.00 ms Kysely muisti: 0.020 MB Muistia ennen kyselyä: 0.826 MB Rivejä palautettu: 5

   SELECT id, rules
   
     FROM `j_viewlevels`

   Selite

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

6. Kyselyn aika: 0.20 ms Viimeisen kyselyn jälkeen: 0.07 ms Kysely muisti: 0.020 MB Muistia ennen kyselyä: 0.836 MB Rivejä palautettu: 2

   SELECT b.id
   
     FROM j_usergroups AS a
   
     LEFT JOIN j_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Selite

   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	3	Using where; Using index

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

7. Kyselyn aika: 0.59 ms Viimeisen kyselyn jälkeen: 0.09 ms Kysely muisti: 0.022 MB Muistia ennen kyselyä: 0.857 MB Rivejä palautettu: 89

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM j_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Selite

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

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   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}()	Sama kuin kutsu alla olevalla rivillä.
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

8. Kyselyn aika: 5.43 ms Viimeisen kyselyn jälkeen: 8.07 ms Kysely muisti: 0.023 MB Muistia ennen kyselyä: 1.262 MB Rivejä palautettu: 39

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `j_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','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_enterpriseweb','com_export_users_profiles','com_extplorer','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_tags','com_templates','com_users','com_wrapper')

   Selite

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	352	Using where

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/ewdebug/ewdebug.php:175
   9	plgSystemEwdebug->readConfig()	JROOT/plugins/system/ewdebug/ewdebug.php:149
   8	plgSystemEwdebug->initialize()	JROOT/plugins/system/ewdebug/ewdebug.php:55
   7	plgSystemEwdebug->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

9. Kyselyn aika: 0.39 ms Viimeisen kyselyn jälkeen: 6.77 ms Kysely muisti: 0.022 MB Muistia ennen kyselyä: 1.567 MB Rivejä palautettu: 44

   SELECT id, title, link, menutype, language
   
     FROM j_menu AS m
   
     WHERE published = 1 
     AND link LIKE 'index.php?option=com_enterpriseweb%'

   Selite

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	101	Using where

   Profiili

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

   Kutsupino

   #	Kutsufunktio	Tiedosto ja rivin numero
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/components/com_enterpriseweb/helpers/route.php:725
   10	EwHelpersRoute::fetchMenuItems()	JROOT/components/com_enterpriseweb/helpers/route.php:76
   9	EwHelpersRoute::initialize()	JROOT/components/com_enterpriseweb/bootstrap_site.php:65
   8	require_once JROOT/components/com_enterpriseweb/bootstrap_site.php	JROOT/plugins/system/ewloader/ewloader.php:15
   7	require_once JROOT/plugins/system/ewloader/ewloader.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   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

   [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

   ---

10. Kyselyn aika: 0.31 ms Viimeisen kyselyn jälkeen: 4.16 ms Kysely muisti: 0.020 MB Muistia ennen kyselyä: 1.662 MB Rivejä palautettu: 2

    SELECT *
    
      FROM j_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Selite

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using filesort

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

11. Kyselyn aika: 0.23 ms Viimeisen kyselyn jälkeen: 0.11 ms Kysely muisti: 0.020 MB Muistia ennen kyselyä: 1.670 MB Rivejä palautettu: 4

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `j_extensions`
    
      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
    8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

12. Kyselyn aika: 6.15 ms Viimeisen kyselyn jälkeen: 7.95 ms Kysely muisti: 0.057 MB Muistia ennen kyselyä: 1.726 MB Rivejä palautettu: 64

    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 j_menu AS m
    
      LEFT JOIN j_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

    Selite

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	101	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	labnetprod.m.component_id	1	Using where

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    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}()	Sama kuin kutsu alla olevalla rivillä.
    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/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

13. Kyselyn aika: 5.41 ms Viimeisen kyselyn jälkeen: 449.05 ms Kysely muisti: 0.022 MB Muistia ennen kyselyä: 118.678 MB Rivejä palautettu: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    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}()	Sama kuin kutsu alla olevalla rivillä.
    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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

14. Kyselyn aika: 0.97 ms Viimeisen kyselyn jälkeen: 0.18 ms Kysely muisti: 0.004 MB Muistia ennen kyselyä: 118.668 MB

    UPDATE `j_extensions`
    
      SET `params` = '{\"mediaversion\":\"e5c594e8acf1cf73712f53c813686985\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Selite

    EXPLAIN ei mahdollinen kyselyssä: UPDATE `j_extensions` SET `params` = '{\"mediaversion\":\"e5c594e8acf1cf73712f53c813686985\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

15. Kyselyn aika: 2.76 ms Viimeisen kyselyn jälkeen: 2.30 ms Kysely muisti: 0.018 MB Muistia ennen kyselyä: 118.804 MB Rivejä palautettu: 3

    SELECT id, home, template, s.params
    
      FROM j_template_styles as s
    
      LEFT JOIN j_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

    Selite

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	labnetprod.s.template,const	1	Using index condition; Using where

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

16. Kyselyn aika: 0.17 ms Viimeisen kyselyn jälkeen: 12.93 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 118.953 MB Rivejä palautettu: 1

    SELECT *
    
      FROM j_ew_attribute_value
    
      WHERE `id` = 19728 
      LIMIT 1

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:221
    17	Ew\Item\Attributes\AttributeManager->findByTerms()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:67
    16	Ew\Item\Attributes\AttributeManager->findByValueId()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:112
    15	Ew\Item\Attributes\AttributeManager->resolve()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:156
    14	Ew\Item\Attributes\AttributeManager->resolveAll()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:511
    13	Ew\Item\Repository\ElasticsearchRepository->getParams()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:187
    12	Ew\Item\Repository\ElasticsearchRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DualRepository.php:49
    11	Ew\Item\Repository\DualRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DispatchingRepository.php:78
    10	Ew\Item\Repository\DispatchingRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/controllers/item.php:62
    9	EwControllersItem->itemsAction()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/BaseController.php:111
    8	Ew\Mvc\Controller\BaseController->execute()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/FrontController.php:38
    7	Ew\Mvc\Controller\FrontController->execute()	JROOT/components/com_enterpriseweb/enterpriseweb.php:20
    6	require_once JROOT/components/com_enterpriseweb/enterpriseweb.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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

17. Kyselyn aika: 0.30 ms Viimeisen kyselyn jälkeen: 0.06 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 118.963 MB Rivejä palautettu: 1
    Päällekkäisiä kyselyitä: #19

    SELECT *
    
      FROM j_ew_attribute
    
      WHERE `id` = 479 
      AND `type` = 'item' 
      LIMIT 1

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:221
    17	Ew\Item\Attributes\AttributeManager->findByTerms()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:68
    16	Ew\Item\Attributes\AttributeManager->findByValueId()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:112
    15	Ew\Item\Attributes\AttributeManager->resolve()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:156
    14	Ew\Item\Attributes\AttributeManager->resolveAll()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:511
    13	Ew\Item\Repository\ElasticsearchRepository->getParams()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:187
    12	Ew\Item\Repository\ElasticsearchRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DualRepository.php:49
    11	Ew\Item\Repository\DualRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DispatchingRepository.php:78
    10	Ew\Item\Repository\DispatchingRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/controllers/item.php:62
    9	EwControllersItem->itemsAction()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/BaseController.php:111
    8	Ew\Mvc\Controller\BaseController->execute()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/FrontController.php:38
    7	Ew\Mvc\Controller\FrontController->execute()	JROOT/components/com_enterpriseweb/enterpriseweb.php:20
    6	require_once JROOT/components/com_enterpriseweb/enterpriseweb.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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

18. Kyselyn aika: 0.27 ms Viimeisen kyselyn jälkeen: 0.08 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 118.973 MB Rivejä palautettu: 1

    SELECT *
    
      FROM j_ew_attribute_value
    
      WHERE `id` = 38135 
      LIMIT 1

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:221
    17	Ew\Item\Attributes\AttributeManager->findByTerms()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:67
    16	Ew\Item\Attributes\AttributeManager->findByValueId()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:112
    15	Ew\Item\Attributes\AttributeManager->resolve()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:156
    14	Ew\Item\Attributes\AttributeManager->resolveAll()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:511
    13	Ew\Item\Repository\ElasticsearchRepository->getParams()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:187
    12	Ew\Item\Repository\ElasticsearchRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DualRepository.php:49
    11	Ew\Item\Repository\DualRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DispatchingRepository.php:78
    10	Ew\Item\Repository\DispatchingRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/controllers/item.php:62
    9	EwControllersItem->itemsAction()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/BaseController.php:111
    8	Ew\Mvc\Controller\BaseController->execute()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/FrontController.php:38
    7	Ew\Mvc\Controller\FrontController->execute()	JROOT/components/com_enterpriseweb/enterpriseweb.php:20
    6	require_once JROOT/components/com_enterpriseweb/enterpriseweb.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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

19. Kyselyn aika: 0.27 ms Viimeisen kyselyn jälkeen: 0.06 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 118.982 MB Rivejä palautettu: 1
    Päällekkäisiä kyselyitä: #17

    SELECT *
    
      FROM j_ew_attribute
    
      WHERE `id` = 479 
      AND `type` = 'item' 
      LIMIT 1

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:221
    17	Ew\Item\Attributes\AttributeManager->findByTerms()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:68
    16	Ew\Item\Attributes\AttributeManager->findByValueId()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:112
    15	Ew\Item\Attributes\AttributeManager->resolve()	JROOT/components/com_enterpriseweb/src/Ew/Item/Attributes/AttributeManager.php:156
    14	Ew\Item\Attributes\AttributeManager->resolveAll()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:511
    13	Ew\Item\Repository\ElasticsearchRepository->getParams()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/ElasticsearchRepository.php:187
    12	Ew\Item\Repository\ElasticsearchRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DualRepository.php:49
    11	Ew\Item\Repository\DualRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/src/Ew/Item/Repository/DispatchingRepository.php:78
    10	Ew\Item\Repository\DispatchingRepository->findAllByTaxonomy()	JROOT/components/com_enterpriseweb/controllers/item.php:62
    9	EwControllersItem->itemsAction()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/BaseController.php:111
    8	Ew\Mvc\Controller\BaseController->execute()	JROOT/components/com_enterpriseweb/src/Ew/Mvc/Controller/FrontController.php:38
    7	Ew\Mvc\Controller\FrontController->execute()	JROOT/components/com_enterpriseweb/enterpriseweb.php:20
    6	require_once JROOT/components/com_enterpriseweb/enterpriseweb.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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

20. Kyselyn aika: 3.20 ms Viimeisen kyselyn jälkeen: 24.94 ms Kysely muisti: 0.020 MB Muistia ennen kyselyä: 118.988 MB Rivejä palautettu: 3

    SELECT language,id
    
      FROM `j_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Selite

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	101	Using where

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

21. Kyselyn aika: 0.69 ms Viimeisen kyselyn jälkeen: 51.12 ms Kysely muisti: 0.025 MB Muistia ennen kyselyä: 119.062 MB Rivejä palautettu: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j_modules AS m
    
      LEFT JOIN j_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN j_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 <= '2024-05-08 09:02:10') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-08 09:02:10') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 452 OR mm.menuid <= 0) 
      AND m.language IN ('fi-FI','*')
    
      ORDER BY m.position, m.ordering

    Selite

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	27	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	labnetprod.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	labnetprod.m.module,const	1	Using index condition; Using where

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	Sama kuin kutsu alla olevalla rivillä.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    14	Joomla\CMS\Document\HtmlDocument->countModules()	Sama kuin kutsu alla olevalla rivillä.
    13	call_user_func_array()	JROOT/components/com_enterpriseweb/src/Ew/Helper/TemplateHelper.php:166
    12	Ew\Helper\TemplateHelper->countModules()	JROOT/templates/tpl_enterpriseweb/themes/labnet/_partials/header.php:5
    11	include JROOT/templates/tpl_enterpriseweb/themes/labnet/_partials/header.php	JROOT/components/com_enterpriseweb/src/Ew/Helper/TemplateHelper.php:147
    10	Ew\Helper\TemplateHelper->includeThemeFile()	JROOT/templates/tpl_enterpriseweb/themes/_base/index.php:9
    9	include JROOT/templates/tpl_enterpriseweb/themes/_base/index.php	JROOT/components/com_enterpriseweb/src/Ew/Helper/TemplateHelper.php:147
    8	Ew\Helper\TemplateHelper->includeThemeFile()	JROOT/templates/tpl_enterpriseweb/index.php:6
    7	require JROOT/templates/tpl_enterpriseweb/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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

22. Kyselyn aika: 4.28 ms Viimeisen kyselyn jälkeen: 35.40 ms Kysely muisti: 0.025 MB Muistia ennen kyselyä: 119.116 MB Rivejä palautettu: 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 j_fields AS a
    
      LEFT JOIN `j_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN j_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN j_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN j_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN j_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Selite

    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; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	labnetprod.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	labnetprod.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	labnetprod.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	labnetprod.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	labnetprod.a.group_id	1	Using where

    Profiili

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.00 ms
    Creating tmp table	0.34 ms
    Copying to tmp table	0.02 ms
    Sorting result	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    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()	Sama kuin kutsu alla olevalla rivillä.
    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/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

23. Kyselyn aika: 15.77 ms Viimeisen kyselyn jälkeen: 178.82 ms Kysely muisti: 0.022 MB Muistia ennen kyselyä: 122.692 MB Rivejä palautettu: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `j_menu` AS `c`
    
      INNER JOIN `j_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `j_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `j_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 452

    Selite

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    12	MenusHelper::getAssociations()	JROOT/components/com_enterpriseweb/helpers/language.php:163
    11	EwHelpersLanguage::getSelectableLanguages()	JROOT/modules/mod_ewlanguages/mod_ewlanguages.php:3
    10	include JROOT/modules/mod_ewlanguages/mod_ewlanguages.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/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\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

    [Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

    ---

20 kyselytyyppiä kirjattu, järjestetty laskevasti esiintymismäärän mukaan

SELECT taulut:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `j_extensions`

2. 2 × SELECT * 
     FROM j_ew_attribute_value

3. 2 × SELECT * 
     FROM j_ew_attribute

4. 1 × SELECT `data` 
     FROM `j_session`

5. 1 × SELECT `session_id` 
     FROM `j_session`

6. 1 × SELECT id, rules 
     FROM `j_viewlevels

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

8. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM j_extensions

9. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `j_assets`

10. 1 × SELECT id, title, link, menutype, language 
      FROM j_menu AS m

11. 1 × SELECT * 
      FROM j_languages

12. 1 × SELECT `element`,`name`,`client_id`,`extension_id` 
      FROM `j_extensions`

13. 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 j_menu AS m 
      LEFT JOIN j_extensions AS e 
      ON m.component_id = e.extension_id

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

15. 1 × SELECT language,id 
      FROM `j_menu`

16. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM j_modules AS m 
      LEFT JOIN j_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN j_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

17. 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 j_fields AS a 
      LEFT JOIN `j_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN j_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN j_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN j_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN j_fields_groups AS g 
      ON g.id = a.group_id

18. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `j_menu` AS `c` 
      INNER JOIN `j_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item' 
      INNER JOIN `j_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key` 
      INNER JOIN `j_menu` AS `c2` 
      ON a2.id = c2.`id`