Landbaserad dykning Kroatien

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734854684,
                "last": 1734854684,
                "now": 1734854684
            },
            "client": {
                "forwarded": "3.149.24.70"
            },
            "token": "QQPOo0zHlJM0WYIcuCErZm4v60bPuLKQ"
        },
        "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": "sv-SE"
        }
    }
}

Tid

Minne

50 loggade SQL-frågor 55.66 ms

1. Frågetid: 0.49 ms Frågeminne: 0.023 MB Minne före fråga: 3.241 MB Returnerade rader: 0

   SELECT `data`
   
     FROM `exp_session`
   
     WHERE `session_id` = '32dq4g4mu979k44el6p6ujn169'

   Förklara

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

   Profil

   Status	Duration
   Starting	0.08 ms
   Checking permissions	0.03 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.07 ms
   Reset for next command	0.00 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Samma som samtal i raden nedan.
   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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

2. Frågetid: 0.43 ms Efter sista fråga: 1.76 ms Frågeminne: 0.020 MB Minne före fråga: 3.331 MB Returnerade rader: 0

   SELECT `session_id`
   
     FROM `exp_session`
   
     WHERE `session_id` = '32dq4g4mu979k44el6p6ujn169' 
     LIMIT 1

   Förklara

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

   Profil

   Status	Duration
   Starting	0.08 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Executing	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.07 ms
   Reset for next command	0.00 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

3. Frågetid: 4.14 ms Efter sista fråga: 0.09 ms Frågeminne: 0.004 MB Minne före fråga: 3.336 MB

   INSERT INTO `exp_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('32dq4g4mu979k44el6p6ujn169', 1, 1734854684, 0, '', 0)

   Förklara

   EXPLAIN inte möjlig i fråga: INSERT INTO `exp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('32dq4g4mu979k44el6p6ujn169', 1, 1734854684, 0, '', 0)

   Profil

   Status	Duration
   Starting	0.07 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Init for update	0.02 ms
   Update	0.32 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	3.22 ms
   Closing tables	0.20 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.04 ms
   Reset for next command	0.01 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

4. Frågetid: 0.77 ms Efter sista fråga: 3.30 ms Frågeminne: 0.024 MB Minne före fråga: 3.591 MB Returnerade rader: 39

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

   Förklara

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

   Profil

   Status	Duration
   Starting	0.09 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.20 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.00 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   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}()	Samma som samtal i raden nedan.
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

5. Frågetid: 0.49 ms Efter sista fråga: 3.80 ms Frågeminne: 0.021 MB Minne före fråga: 3.770 MB Returnerade rader: 5

   SELECT id, rules
   
     FROM `exp_viewlevels`

   Förklara

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	exp_viewlevels	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	5

   Profil

   Status	Duration
   Starting	0.07 ms
   Checking permissions	0.01 ms
   Opening tables	0.05 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.08 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

6. Frågetid: 0.43 ms Efter sista fråga: 0.27 ms Frågeminne: 0.021 MB Minne före fråga: 3.782 MB Returnerade rader: 2

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

   Förklara

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

   Profil

   Status	Duration
   Starting	0.06 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
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.05 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.05 ms
   Reset for next command	0.00 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

7. Frågetid: 1.46 ms Efter sista fråga: 1.00 ms Frågeminne: 0.030 MB Minne före fråga: 3.847 MB Returnerade rader: 85

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

   Förklara

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	exp_extensions	ref	extension	extension	82	const	124	Using index condition; Using where; Använder filsortering

   Profil

   Status	Duration
   Starting	0.12 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.08 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.72 ms
   End of update loop	0.02 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.07 ms
   Reset for next command	0.01 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Samma som samtal i raden nedan.
   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:359
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

8. Frågetid: 1.01 ms Efter sista fråga: 12.33 ms Frågeminne: 0.021 MB Minne före fråga: 4.657 MB Returnerade rader: 1

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

   Förklara

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	exp_languages	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	3	Using where; Använder filsortering

   Profil

   Status	Duration
   Starting	0.10 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.05 ms
   Optimizing	0.32 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.11 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.07 ms
   Reset for next command	0.02 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   9	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   8	PlgSystemLanguageFilter->__construct()	JROOT/plugins/system/languagedomains/languagedomains.php:72
   7	PlgSystemLanguageDomains->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

9. Frågetid: 0.79 ms Efter sista fråga: 0.26 ms Frågeminne: 0.022 MB Minne före fråga: 4.665 MB Returnerade rader: 6

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

   Förklara

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

   Profil

   Status	Duration
   Starting	0.07 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.09 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Anropsstack

   #	Uppringare	Fil och radnummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   9	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   8	PlgSystemLanguageFilter->__construct()	JROOT/plugins/system/languagedomains/languagedomains.php:72
   7	PlgSystemLanguageDomains->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

   ---

10. Frågetid: 2.48 ms Efter sista fråga: 22.25 ms Frågeminne: 0.204 MB Minne före fråga: 5.471 MB Returnerade rader: 119

    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 exp_menu AS m
    
      LEFT JOIN exp_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

    Förklara

    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	164	Using index condition; Using where; Använder filsortering
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	scubatravel.m.component_id	1	Using where

    Profil

    Status	Duration
    Starting	0.15 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.05 ms
    Optimizing	0.03 ms
    Statistics	0.13 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.50 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Samma som samtal i raden nedan.
    21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    9	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/plugins/system/languagedomains/languagedomains.php:217
    8	PlgSystemLanguageDomains->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

11. Frågetid: 4.15 ms Efter sista fråga: 13.11 ms Frågeminne: 2.440 MB Minne före fråga: 6.602 MB Returnerade rader: 162

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `exp_categories` AS `s`
    
      INNER JOIN `exp_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('sv-SE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id = 51
    
      ORDER BY c.lft

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_left_right,idx_language	cat_idx	203	NULL	174	Using index condition; Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.20 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.21 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	3.12 ms
    End of update loop	0.03 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    13	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:165
    12	ContentRouter->getCategoryId()	Samma som samtal i raden nedan.
    11	call_user_func_array()	JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140
    10	Joomla\CMS\Component\Router\Rules\StandardRules->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

12. Frågetid: 0.88 ms Efter sista fråga: 5.14 ms Frågeminne: 0.021 MB Minne före fråga: 9.286 MB Returnerade rader: 3

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

    Förklara

    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	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	scubatravel.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.13 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.04 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.08 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/languagedomains/languagedomains.php:1069
    9	PlgSystemLanguageDomains->setLanguage()	JROOT/plugins/system/languagedomains/languagedomains.php:266
    8	PlgSystemLanguageDomains->onAfterRoute()	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:1122
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

13. Frågetid: 0.68 ms Efter sista fråga: 2.27 ms Frågeminne: 0.022 MB Minne före fråga: 9.556 MB Returnerade rader: 1

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

    Förklara

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

    Profil

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.08 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    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}()	Samma som samtal i raden nedan.
    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:1129
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

14. Frågetid: 2.15 ms Efter sista fråga: 0.32 ms Frågeminne: 0.005 MB Minne före fråga: 9.546 MB

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

    Förklara

    EXPLAIN inte möjlig i fråga: UPDATE `exp_extensions` SET `params` = '{\"mediaversion\":\"e0a3338858edb39100c53876fe834d64\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profil

    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.00 ms
    Table lock	0.01 ms
    Init for update	0.09 ms
    Updating	0.07 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	1.68 ms
    Closing tables	0.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    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:1129
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

15. Frågetid: 0.91 ms Efter sista fråga: 9.30 ms Frågeminne: 0.028 MB Minne före fråga: 10.419 MB Returnerade rader: 39

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `exp_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jlsitemap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tagmeta','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_yeeditor')

    Förklara

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

    Profil

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.01 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.31 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

16. Frågetid: 3.28 ms Efter sista fråga: 0.24 ms Frågeminne: 0.302 MB Minne före fråga: 10.469 MB Returnerade rader: 2154

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `exp_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_assets	ALL	idx_asset_name,idx_parent_id	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	4110	Using where

    Profil

    Status	Duration
    Starting	0.04 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
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	2.70 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.09 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

17. Frågetid: 3.20 ms Efter sista fråga: 6.29 ms Frågeminne: 0.075 MB Minne före fråga: 12.329 MB Returnerade rader: 7

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `exp_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1 
      AND (i.language = '*' OR i.language = 'sv-SE')) AS numitems
    
      FROM `exp_categories` AS `s`
    
      INNER JOIN `exp_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('sv-SE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id = 205
    
      ORDER BY c.lft

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	PRIMARY	c	range|filter	cat_idx,idx_left_right,idx_language	cat_idx|idx_left_right	203|4	NULL	174 (75%)	Using index condition; Using where; Använder filsortering; Using rowid filter
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	scubatravel.c.id	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.18 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.09 ms
    Optimizing	0.03 ms
    Statistics	0.17 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    Creating sort index	0.69 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.48 ms
    Executing	0.01 ms
    Sending data	0.64 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.06 ms
    Freeing items	0.01 ms
    Removing tmp table	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

18. Frågetid: 1.29 ms Efter sista fråga: 1.89 ms Frågeminne: 0.024 MB Minne före fråga: 12.519 MB Returnerade rader: 0

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM exp_content AS a
    
      LEFT JOIN exp_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN exp_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN exp_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN exp_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN exp_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 205 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-22 08:04:44') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 08:04:44') 
      AND a.language IN ('sv-SE','*')
    
      ORDER BY  c.lft,  a.ordering,  a.created   
      LIMIT 10

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where; Använder filsortering
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a.id	1	Using where

    Profil

    Status	Duration
    Starting	0.28 ms
    Checking permissions	0.01 ms
    Opening tables	0.08 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.04 ms
    Init	0.11 ms
    Optimizing	0.07 ms
    Statistics	0.22 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.06 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

19. Frågetid: 0.80 ms Efter sista fråga: 1.45 ms Frågeminne: 0.024 MB Minne före fråga: 12.618 MB Returnerade rader: 1

    SELECT COUNT(*)
    
      FROM exp_content AS a
    
      LEFT JOIN exp_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN exp_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN exp_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN exp_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN exp_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 205 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-22 08:04:44') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 08:04:44') 
      AND a.language IN ('sv-SE','*')

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1	Using where

    Profil

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.16 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

20. Frågetid: 1.16 ms Efter sista fråga: 1.76 ms Frågeminne: 0.023 MB Minne före fråga: 12.743 MB Returnerade rader: 1

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `exp_contentitem_tag_map` AS m 
    
      INNER JOIN `exp_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 205 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	32	Using index condition
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	scubatravel.t.id	25	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.12 ms
    Executing	0.00 ms
    Sending data	0.52 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.06 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

21. Frågetid: 1.83 ms Efter sista fråga: 5.57 ms Frågeminne: 0.078 MB Minne före fråga: 13.116 MB Returnerade rader: 7
    Duplikatfrågor: #31

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `exp_categories` AS `s`
    
      INNER JOIN `exp_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('sv-SE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 205
    
      ORDER BY c.lft

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	207	NULL	176	Using index condition; Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.21 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.17 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.81 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.19 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    23	ContentRouter->getCategorySegment()	Samma som samtal i raden nedan.
    22	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    21	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    20	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    19	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    14	Joomla\CMS\Router\Route::_()	JROOT/libraries/src/MVC/View/CategoryView.php:320
    13	Joomla\CMS\MVC\View\CategoryView->addFeed()	JROOT/components/com_content/views/category/view.html.php:283
    12	ContentViewCategory->prepareDocument()	JROOT/libraries/src/MVC/View/CategoryView.php:243
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

22. Frågetid: 0.64 ms Efter sista fråga: 10.87 ms Frågeminne: 0.030 MB Minne före fråga: 13.839 MB Returnerade rader: 36
    Duplikatfrågor: #23

    select widget_name,widget_group 
      from exp_yeeditor_extensions 
      where published=1 
      order by widget_name asc

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_extensions	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	36	Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.16 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.07 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    24	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/map.php:1012
    23	require_once JROOT/plugins/editors/yeeditor/include/map.php	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:14
    22	require_once JROOT/plugins/editors/yeeditor/include/functions_frontend.php	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:30
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

23. Frågetid: 0.52 ms Efter sista fråga: 0.08 ms Frågeminne: 0.030 MB Minne före fråga: 13.851 MB Returnerade rader: 36
    Duplikatfrågor: #22

    select widget_name,widget_group 
      from exp_yeeditor_extensions 
      where published=1 
      order by widget_name asc

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_extensions	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	36	Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.04 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
    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.19 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/map.php:1016
    23	require_once JROOT/plugins/editors/yeeditor/include/map.php	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:14
    22	require_once JROOT/plugins/editors/yeeditor/include/functions_frontend.php	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:30
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

24. Frågetid: 0.60 ms Efter sista fråga: 15.59 ms Frågeminne: 0.028 MB Minne före fråga: 15.167 MB Returnerade rader: 1
    Duplikatfrågor: #25

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_load_font_awesome"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    Status	Duration
    Starting	0.11 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.04 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.08 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    26	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
    25	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:588
    24	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

25. Frågetid: 0.39 ms Efter sista fråga: 0.09 ms Frågeminne: 0.028 MB Minne före fråga: 15.179 MB Returnerade rader: 1
    Duplikatfrågor: #24

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_load_font_awesome"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.07 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
    25	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:588
    24	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

26. Frågetid: 0.29 ms Efter sista fråga: 0.08 ms Frågeminne: 0.028 MB Minne före fråga: 15.192 MB Returnerade rader: 1
    Duplikatfrågor: #27

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_load_cbootstrap3"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    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
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.04 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    26	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
    25	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:589
    24	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

27. Frågetid: 0.28 ms Efter sista fråga: 0.04 ms Frågeminne: 0.028 MB Minne före fråga: 15.204 MB Returnerade rader: 1
    Duplikatfrågor: #26

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_load_cbootstrap3"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    Status	Duration
    Starting	0.04 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
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
    25	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:589
    24	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

28. Frågetid: 0.41 ms Efter sista fråga: 1.94 ms Frågeminne: 0.028 MB Minne före fråga: 15.263 MB Returnerade rader: 1
    Duplikatfrågor: #29  #32  #33

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_imageglobalsizedefine"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    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.00 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    27	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
    26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
    25	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
    24	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

29. Frågetid: 0.25 ms Efter sista fråga: 0.23 ms Frågeminne: 0.028 MB Minne före fråga: 15.276 MB Returnerade rader: 1
    Duplikatfrågor: #28  #32  #33

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_imageglobalsizedefine"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    Status	Duration
    Starting	0.04 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
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.05 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
    26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
    25	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
    24	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

30. Frågetid: 0.50 ms Efter sista fråga: 0.51 ms Frågeminne: 0.029 MB Minne före fråga: 15.322 MB Returnerade rader: 1

    SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
    
      FROM exp_modules AS m
    
      WHERE m.published = 1 
      AND m.id = 164 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-22 08:04:44') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 08:04:44') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND m.language IN ('sv-SE','*')

    Förklara

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

    Profil

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.04 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    29	JDatabaseDriver->loadObject()	JROOT/components/com_yeeditor/widgets_ex/wgt_joomla_module/frontend/default/html/helper.php:46
    28	widgetJoomlaModuleHelper::getModule()	JROOT/components/com_yeeditor/widgets_ex/wgt_joomla_module/frontend/default/html/wgt_joomla_module.php:19
    27	include JROOT/components/com_yeeditor/widgets_ex/wgt_joomla_module/frontend/default/html/wgt_joomla_module.php	JROOT/plugins/editors/yeeditor/include/functions.php:318
    26	get_element_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:292
    25	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
    24	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

31. Frågetid: 1.68 ms Efter sista fråga: 1.77 ms Frågeminne: 0.084 MB Minne före fråga: 15.450 MB Returnerade rader: 7
    Duplikatfrågor: #21

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `exp_categories` AS `s`
    
      INNER JOIN `exp_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('sv-SE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 205
    
      ORDER BY c.lft

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	207	NULL	176	Using index condition; Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.96 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.07 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    35	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    34	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_child_categories/helper.php:51
    33	ModChildCategoriesHelper::getList()	Samma som samtal i raden nedan.
    32	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    31	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:554
    30	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_child_categories/mod_child_categories.php:26
    29	include JROOT/modules/mod_child_categories/mod_child_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    28	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_yeeditor/widgets_ex/wgt_joomla_module/frontend/default/html/wgt_joomla_module.php:23
    27	include JROOT/components/com_yeeditor/widgets_ex/wgt_joomla_module/frontend/default/html/wgt_joomla_module.php	JROOT/plugins/editors/yeeditor/include/functions.php:318
    26	get_element_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:292
    25	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
    24	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

32. Frågetid: 0.49 ms Efter sista fråga: 1.85 ms Frågeminne: 0.028 MB Minne före fråga: 15.509 MB Returnerade rader: 1
    Duplikatfrågor: #28  #29  #33

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_imageglobalsizedefine"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.06 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    27	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
    26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
    25	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
    24	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

33. Frågetid: 0.21 ms Efter sista fråga: 0.04 ms Frågeminne: 0.029 MB Minne före fråga: 15.529 MB Returnerade rader: 1
    Duplikatfrågor: #28  #29  #32

    SELECT option_value 
      from exp_yeeditor_option 
      WHERE option_name="yeeditor_imageglobalsizedefine"

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	exp_yeeditor_option	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	15	Using where

    Profil

    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
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.04 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
    26	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:275
    25	get_element_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:576
    24	get_row_inner_frontend_html()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:70
    23	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    22	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    21	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

34. Frågetid: 1.33 ms Efter sista fråga: 2.59 ms Frågeminne: 0.028 MB Minne före fråga: 15.612 MB Returnerade rader: 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 exp_fields AS a
    
      LEFT JOIN `exp_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN exp_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN exp_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN exp_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN exp_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.categories' 
      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

    Förklara

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

    Profil

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.03 ms
    Creating tmp table	0.09 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.30 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    18	JHtmlContent::prepare()	Samma som samtal i raden nedan.
    17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/stravel/html/com_content/category/default.php:17
    14	include JROOT/templates/stravel/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

35. Frågetid: 1.63 ms Efter sista fråga: 2.79 ms Frågeminne: 0.025 MB Minne före fråga: 15.762 MB Returnerade rader: 20

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM exp_modules AS m
    
      LEFT JOIN exp_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN exp_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-12-22 08:04:44') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 08:04:44') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 200 OR mm.menuid <= 0) 
      AND m.language IN ('sv-SE','*')
    
      ORDER BY m.position, m.ordering

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref|filter	PRIMARY,published,newsfeeds,idx_language	published|idx_language	1|28	const	103 (54%)	Using index condition; Using where; Använder filsortering; Using rowid filter
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	scubatravel.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	scubatravel.m.id	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.08 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.70 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.05 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	Samma som samtal i raden nedan.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/stravel/index.php:66
    7	require JROOT/templates/stravel/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

36. Frågetid: 0.82 ms Efter sista fråga: 11.65 ms Frågeminne: 0.023 MB Minne före fråga: 16.108 MB Returnerade rader: 1

    SELECT id, home, template, s.params
    
      FROM exp_template_styles as s
    
      LEFT JOIN exp_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 s.home = 1 
      AND e.enabled = 1

    Förklara

    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	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	scubatravel.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.20 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/plugins/system/zcore/zcore.php:88
    13	plgSystemZCore::getDefaultTemplate()	JROOT/plugins/system/zcore/zcore.php:101
    12	plgSystemZCore::getTemplateName()	JROOT/modules/mod_heading/tmpl/default.php:12
    11	require JROOT/modules/mod_heading/tmpl/default.php	JROOT/modules/mod_heading/mod_heading.php:22
    10	include JROOT/modules/mod_heading/mod_heading.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

37. Frågetid: 0.86 ms Efter sista fråga: 3.14 ms Frågeminne: 0.025 MB Minne före fråga: 16.213 MB Returnerade rader: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `exp_categories` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_categories.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_categories` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 10

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    Starting	0.15 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.05 ms
    Optimizing	0.04 ms
    Statistics	0.24 ms
    Preparing	0.02 ms
    Executing	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.07 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    15	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
    14	CategoriesHelper::getAssociations()	JROOT/templates/stravel/helper.php:301
    13	ZTplHelper::getAssocCategory()	JROOT/modules/mod_heading/tmpl/_additional.php:12
    12	require JROOT/modules/mod_heading/tmpl/_additional.php	JROOT/modules/mod_heading/tmpl/default.php:113
    11	require JROOT/modules/mod_heading/tmpl/default.php	JROOT/modules/mod_heading/mod_heading.php:22
    10	include JROOT/modules/mod_heading/mod_heading.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

38. Frågetid: 1.70 ms Efter sista fråga: 0.20 ms Frågeminne: 0.076 MB Minne före fråga: 16.222 MB Returnerade rader: 8

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `exp_categories` AS `s`
    
      INNER JOIN `exp_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('sv-SE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 115
    
      ORDER BY c.lft

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	207	NULL	176	Using index condition; Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.16 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.31 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.83 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/libraries/src/Categories/CategoryNode.php:421
    13	Joomla\CMS\Categories\CategoryNode->getChildren()	JROOT/modules/mod_heading/tmpl/_additional.php:36
    12	require JROOT/modules/mod_heading/tmpl/_additional.php	JROOT/modules/mod_heading/tmpl/default.php:113
    11	require JROOT/modules/mod_heading/tmpl/default.php	JROOT/modules/mod_heading/mod_heading.php:22
    10	include JROOT/modules/mod_heading/mod_heading.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

39. Frågetid: 1.75 ms Efter sista fråga: 0.80 ms Frågeminne: 0.062 MB Minne före fråga: 16.305 MB Returnerade rader: 5

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `exp_categories` AS `s`
    
      INNER JOIN `exp_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('sv-SE','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 206
    
      ORDER BY c.lft

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	207	NULL	176	Using index condition; Using where; Använder filsortering

    Profil

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.97 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.07 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    22	ContentRouter->getCategorySegment()	Samma som samtal i raden nedan.
    21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_heading/tmpl/_additional.php:48
    12	require JROOT/modules/mod_heading/tmpl/_additional.php	JROOT/modules/mod_heading/tmpl/default.php:113
    11	require JROOT/modules/mod_heading/tmpl/default.php	JROOT/modules/mod_heading/mod_heading.php:22
    10	include JROOT/modules/mod_heading/mod_heading.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

40. Frågetid: 1.43 ms Efter sista fråga: 2.72 ms Frågeminne: 0.025 MB Minne före fråga: 16.365 MB Returnerade rader: 0

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM exp_content AS a
    
      LEFT JOIN exp_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN exp_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN exp_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN exp_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN exp_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (10) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-22 08:04:44') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 08:04:44') 
      AND a.language IN ('sv-SE','*')
    
      ORDER BY a.title ASC

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    Starting	0.33 ms
    Checking permissions	0.01 ms
    Opening tables	0.16 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.16 ms
    Optimizing	0.07 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Executing	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.06 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    15	ContentModelArticles->getItems()	JROOT/modules/mod_filter_map/helper.php:96
    14	ModMapFilterHelper::getList()	Samma som samtal i raden nedan.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:554
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_filter_map/mod_filter_map.php:29
    10	include JROOT/modules/mod_filter_map/mod_filter_map.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

41. Frågetid: 0.99 ms Efter sista fråga: 5.32 ms Frågeminne: 0.023 MB Minne före fråga: 16.492 MB Returnerade rader: 2
    Duplikatfrågor: #49  #50

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `exp_menu` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_menus.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 129

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a2.id	1

    Profil

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.21 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.07 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    14	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    13	MenusHelper::getAssociations()	JROOT/templates/stravel/helper.php:294
    12	ZTplHelper::getAssocMenuItem()	JROOT/templates/stravel/html/mod_menu/default.php:116
    11	require JROOT/templates/stravel/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

42. Frågetid: 0.71 ms Efter sista fråga: 1.52 ms Frågeminne: 0.023 MB Minne före fråga: 16.515 MB Returnerade rader: 0
    Duplikatfrågor: #46

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `exp_menu` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_menus.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 200

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Executing	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.08 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

43. Frågetid: 0.83 ms Efter sista fråga: 0.85 ms Frågeminne: 0.024 MB Minne före fråga: 16.539 MB Returnerade rader: 2
    Duplikatfrågor: #47

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `exp_categories` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_categories.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_categories` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 205

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a2.id	1

    Profil

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.09 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    15	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
    14	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
    13	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
    12	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

44. Frågetid: 0.44 ms Efter sista fråga: 0.14 ms Frågeminne: 0.023 MB Minne före fråga: 16.547 MB Returnerade rader: 1
    Duplikatfrågor: #48

    SELECT `published`
    
      FROM `exp_categories`
    
      WHERE access IN (1,1,5) 
      AND `id` = 204

    Förklara

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

    Profil

    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.00 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.05 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_categories/helpers/categories.php:132
    14	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
    13	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
    12	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

45. Frågetid: 0.94 ms Efter sista fråga: 3.39 ms Frågeminne: 0.023 MB Minne före fråga: 16.619 MB Returnerade rader: 3

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `exp_menu` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_menus.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 128

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a2.id	1

    Profil

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.15 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.09 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    14	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    13	MenusHelper::getAssociations()	JROOT/templates/stravel/helper.php:294
    12	ZTplHelper::getAssocMenuItem()	JROOT/templates/stravel/html/mod_menu/mytrip.php:13
    11	require JROOT/templates/stravel/html/mod_menu/mytrip.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

46. Frågetid: 0.79 ms Efter sista fråga: 2.89 ms Frågeminne: 0.025 MB Minne före fråga: 16.678 MB Returnerade rader: 0
    Duplikatfrågor: #42

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `exp_menu` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_menus.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 200

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    Starting	0.15 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.04 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Executing	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    17	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    16	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
    15	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    14	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/stravel/html/mod_menu/mobile.php:30
    11	require JROOT/templates/stravel/html/mod_menu/mobile.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

47. Frågetid: 0.83 ms Efter sista fråga: 0.33 ms Frågeminne: 0.026 MB Minne före fråga: 16.688 MB Returnerade rader: 2
    Duplikatfrågor: #43

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `exp_categories` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_categories.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_categories` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 205

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a2.id	1

    Profil

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.06 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    19	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
    18	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
    17	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
    16	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
    15	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    14	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/stravel/html/mod_menu/mobile.php:30
    11	require JROOT/templates/stravel/html/mod_menu/mobile.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

48. Frågetid: 0.39 ms Efter sista fråga: 0.14 ms Frågeminne: 0.026 MB Minne före fråga: 16.698 MB Returnerade rader: 1
    Duplikatfrågor: #44

    SELECT `published`
    
      FROM `exp_categories`
    
      WHERE access IN (1,1,5) 
      AND `id` = 204

    Förklara

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

    Profil

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_categories/helpers/categories.php:132
    18	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
    17	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
    16	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
    15	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    14	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/stravel/html/mod_menu/mobile.php:30
    11	require JROOT/templates/stravel/html/mod_menu/mobile.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

49. Frågetid: 0.50 ms Efter sista fråga: 1.69 ms Frågeminne: 0.023 MB Minne före fråga: 16.687 MB Returnerade rader: 2
    Duplikatfrågor: #41  #50

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `exp_menu` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_menus.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 129

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a2.id	1

    Profil

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    14	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    13	MenusHelper::getAssociations()	JROOT/templates/stravel/helper.php:294
    12	ZTplHelper::getAssocMenuItem()	JROOT/templates/stravel/html/mod_menu/mobile.php:141
    11	require JROOT/templates/stravel/html/mod_menu/mobile.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---

50. Frågetid: 0.64 ms Efter sista fråga: 0.62 ms Frågeminne: 0.023 MB Minne före fråga: 16.683 MB Returnerade rader: 2
    Duplikatfrågor: #41  #49

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `exp_menu` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_menus.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 129

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a2.id	1

    Profil

    Status	Duration
    Starting	0.09 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/languagedomains/rewrite-32/associations.php:83
    14	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    13	MenusHelper::getAssociations()	JROOT/templates/stravel/helper.php:294
    12	ZTplHelper::getAssocMenuItem()	JROOT/templates/stravel/html/mod_custom/request.php:17
    11	require JROOT/templates/stravel/html/mod_custom/request.php	JROOT/modules/mod_custom/mod_custom.php:20
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

    ---