Dykcenter

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734801818,
                "last": 1734801818,
                "now": 1734801818
            },
            "client": {
                "forwarded": "18.191.135.120"
            },
            "token": "c6wdYBjdMyydywantjYP5hqs3H4CEM2O"
        },
        "registry": {
            "com_contact": {
                "contact": {
                    "data": {
                        "catid": "73"
                    }
                }
            }
        },
        "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

56 loggade SQL-frågor 47.54 ms

1. Frågetid: 0.61 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` = 'i1o4pkveaqa78tonqkehglkk4u'

   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.12 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.06 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.01 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.01 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.41 ms Efter sista fråga: 1.33 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` = 'i1o4pkveaqa78tonqkehglkk4u' 
     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.07 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.02 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.02 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: 2.15 ms Efter sista fråga: 0.13 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 
   ('i1o4pkveaqa78tonqkehglkk4u', 1, 1734801818, 0, '', 0)

   Förklara

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

   Profil

   Status	Duration
   Starting	0.06 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Init for update	0.01 ms
   Update	0.09 ms
   Waiting for query cache lock	0.00 ms
   Update	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	1.78 ms
   Closing tables	0.02 ms
   Unlocking tables	0.01 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.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.73 ms Efter sista fråga: 2.69 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.03 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.19 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.04 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/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.48 ms Efter sista fråga: 2.47 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.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.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.08 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.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.02 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.38 ms Efter sista fråga: 0.11 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.04 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.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.08 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 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.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
   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: 0.99 ms Efter sista fråga: 0.87 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.09 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.06 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.45 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.04 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: 0.53 ms Efter sista fråga: 9.25 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.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.04 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.09 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
   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.34 ms Efter sista fråga: 0.14 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.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.02 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.07 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
   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.24 ms Efter sista fråga: 15.85 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.14 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.13 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.17 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.27 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.04 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: 1.20 ms Efter sista fråga: 10.33 ms Frågeminne: 0.023 MB Minne före fråga: 6.601 MB Returnerade rader: 2

    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_contact' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 73
    
      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|filter	cat_idx,idx_access,idx_left_right,idx_language	cat_idx|idx_left_right	207|4	NULL	12 (3%)	Using index condition; Using where; Använder filsortering; Using rowid filter

    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.01 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.21 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.06 ms
    Creating sort index	0.15 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.04 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/helpers/legacyrouter.php:222
    10	ContactRouterRulesLegacy->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.80 ms Efter sista fråga: 1.23 ms Frågeminne: 0.021 MB Minne före fråga: 6.433 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.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.05 ms
    Optimizing	0.04 ms
    Statistics	0.18 ms
    Preparing	0.04 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.04 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/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.63 ms Efter sista fråga: 1.84 ms Frågeminne: 0.022 MB Minne före fråga: 6.699 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.02 ms
    Statistics	0.10 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.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.01 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: 1.79 ms Efter sista fråga: 0.21 ms Frågeminne: 0.005 MB Minne före fråga: 6.689 MB

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

    Förklara

    EXPLAIN inte möjlig i fråga: UPDATE `exp_extensions` SET `params` = '{\"mediaversion\":\"107f912ae2ef41fc656b9f11fd300eeb\"}' 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.00 ms
    Init for update	0.12 ms
    Updating	0.07 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	1.34 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 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
    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: 1.16 ms Efter sista fråga: 8.78 ms Frågeminne: 0.028 MB Minne före fråga: 7.460 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.12 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.07 ms
    Optimizing	0.02 ms
    Statistics	0.17 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.44 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.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_contact/models/contact.php:62
    14	ContactModelContact->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_contact/models/contact.php:165
    12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 0.87 ms Efter sista fråga: 0.94 ms Frågeminne: 0.023 MB Minne före fråga: 7.600 MB Returnerade rader: 1

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM exp_contact_details AS a
    
      LEFT JOIN exp_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN exp_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.id = 107 
      AND (a.published = 1 OR a.published =2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-21 17:23:38') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-21 17:23:38')

    Förklara

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.18 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.09 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	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.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:225
    12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 1.20 ms Efter sista fråga: 1.83 ms Frågeminne: 0.023 MB Minne före fråga: 7.749 MB Returnerade rader: 0
    Duplikatfrågor: #27  #41  #47

    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_contact.contact' 
      AND `m`.`content_item_id` = 107 
      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.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.50 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.03 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/contact.php:255
    12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 0.84 ms Efter sista fråga: 3.48 ms Frågeminne: 0.029 MB Minne före fråga: 8.080 MB Returnerade rader: 16

    SHOW FULL COLUMNS 
      FROM `exp_users`

    Förklara

    EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `exp_users`

    Profil

    Status	Duration
    Starting	0.06 ms
    Checking permissions	0.01 ms
    Closing tables	0.01 ms
    Opening tables	0.26 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    Checking permissions	0.10 ms
    Closing tables	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
    Removing tmp table	0.10 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
    18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_users/models/user.php:64
    16	UsersModelUser->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:946
    15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:89
    14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:395
    13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
    12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.70 ms Efter sista fråga: 3.20 ms Frågeminne: 0.025 MB Minne före fråga: 8.323 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.12 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.04 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.11 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.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/plugins/system/zcore/zcore.php:88
    18	plgSystemZCore::getDefaultTemplate()	JROOT/plugins/system/zcore/zcore.php:101
    17	plgSystemZCore::getTemplateName()	JROOT/plugins/system/zcore/zcore.php:34
    16	plgSystemZCore->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:411
    13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
    12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 2.90 ms Frågeminne: 0.026 MB Minne före fråga: 8.586 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_users.user' 
      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.00 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.25 ms
    Creating sort index	0.06 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.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    18	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
    17	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:298
    16	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:411
    13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
    12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.51 ms Efter sista fråga: 5.07 ms Frågeminne: 0.027 MB Minne före fråga: 8.844 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_contact.mail' 
      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.29 ms
    Checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.04 ms
    Init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.04 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.28 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.05 ms
    Creating sort index	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.05 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:298
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_contact/models/contact.php:82
    12	ContactModelContact->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:83
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 1.04 ms Efter sista fråga: 1.03 ms Frågeminne: 0.097 MB Minne före fråga: 8.903 MB Returnerade rader: 11

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM `exp_contact_details` 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
    
      WHERE a.access IN (1,1,5) 
      AND a.catid = 73 
      AND c.access IN (1,1,5) 
      AND a.published = 1
    
      ORDER BY a.name asc

    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	index_merge	idx_access,idx_state,idx_catid	idx_state,idx_catid	1,4	NULL	6	Using intersect(idx_state,idx_catid); Using where; Använder filsortering
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	scubatravel.a.created_by	1	Using where

    Profil

    Status	Duration
    Starting	0.17 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.09 ms
    Optimizing	0.03 ms
    Statistics	0.13 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.03 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.32 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.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_contact/models/category.php:91
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 1.25 ms Efter sista fråga: 0.28 ms Frågeminne: 0.023 MB Minne före fråga: 9.006 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_contact.contact' 
      AND `m`.`content_item_id` = 111 
      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.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.36 ms
    Preparing	0.05 ms
    Executing	0.00 ms
    Sending data	0.41 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.04 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.91 ms Efter sista fråga: 0.19 ms Frågeminne: 0.023 MB Minne före fråga: 9.016 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_contact.contact' 
      AND `m`.`content_item_id` = 42 
      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.09 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.00 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.36 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.03 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.82 ms Efter sista fråga: 0.26 ms Frågeminne: 0.022 MB Minne före fråga: 9.026 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 54 
      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.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.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.41 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.01 ms
    Freeing items	0.03 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.74 ms Efter sista fråga: 0.17 ms Frågeminne: 0.022 MB Minne före fråga: 9.036 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 108 
      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.06 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	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.33 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.03 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.71 ms Efter sista fråga: 0.25 ms Frågeminne: 0.022 MB Minne före fråga: 9.046 MB Returnerade rader: 0
    Duplikatfrågor: #17  #41  #47

    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_contact.contact' 
      AND `m`.`content_item_id` = 107 
      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.04 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.32 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.03 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.79 ms Efter sista fråga: 0.16 ms Frågeminne: 0.022 MB Minne före fråga: 9.056 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 58 
      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.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.02 ms
    Statistics	0.04 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.03 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.69 ms Efter sista fråga: 0.13 ms Frågeminne: 0.022 MB Minne före fråga: 9.066 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 55 
      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.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.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.36 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.03 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.72 ms Efter sista fråga: 0.19 ms Frågeminne: 0.022 MB Minne före fråga: 9.076 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 56 
      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.04 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.42 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.02 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
    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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 0.80 ms Efter sista fråga: 0.13 ms Frågeminne: 0.022 MB Minne före fråga: 9.086 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 104 
      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.03 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.49 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.02 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.68 ms Efter sista fråga: 0.11 ms Frågeminne: 0.022 MB Minne före fråga: 9.097 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 109 
      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.03 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 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.02 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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.65 ms Efter sista fråga: 0.13 ms Frågeminne: 0.023 MB Minne före fråga: 9.113 MB Returnerade rader: 0

    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_contact.contact' 
      AND `m`.`content_item_id` = 94 
      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.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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.33 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
    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/components/com_contact/models/category.php:107
    11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:125
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 0.66 ms Efter sista fråga: 5.55 ms Frågeminne: 0.026 MB Minne före fråga: 9.578 MB Returnerade rader: 36
    Duplikatfrågor: #35

    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.01 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.23 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.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    16	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/map.php:1012
    15	require_once JROOT/plugins/editors/yeeditor/include/map.php	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:14
    14	require_once JROOT/plugins/editors/yeeditor/include/functions_frontend.php	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:30
    13	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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: 0.47 ms Efter sista fråga: 0.06 ms Frågeminne: 0.026 MB Minne före fråga: 9.587 MB Returnerade rader: 36
    Duplikatfrågor: #34

    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.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.03 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.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.13 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/map.php:1016
    15	require_once JROOT/plugins/editors/yeeditor/include/map.php	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:14
    14	require_once JROOT/plugins/editors/yeeditor/include/functions_frontend.php	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:30
    13	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

36. Frågetid: 0.54 ms Efter sista fråga: 11.84 ms Frågeminne: 0.025 MB Minne före fråga: 10.900 MB Returnerade rader: 1
    Duplikatfrågor: #37

    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.07 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.07 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.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    18	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
    17	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:588
    16	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    15	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    14	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    13	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

37. Frågetid: 0.18 ms Efter sista fråga: 0.06 ms Frågeminne: 0.025 MB Minne före fråga: 10.909 MB Returnerade rader: 1
    Duplikatfrågor: #36

    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.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 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.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
    17	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:588
    16	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    15	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    14	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    13	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

38. Frågetid: 0.14 ms Efter sista fråga: 0.04 ms Frågeminne: 0.025 MB Minne före fråga: 10.918 MB Returnerade rader: 1
    Duplikatfrågor: #39

    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.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    18	JDatabase->query()	JROOT/plugins/editors/yeeditor/include/functions_general.php:28
    17	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:589
    16	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    15	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    14	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    13	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

39. Frågetid: 0.13 ms Efter sista fråga: 0.01 ms Frågeminne: 0.025 MB Minne före fråga: 10.927 MB Returnerade rader: 1
    Duplikatfrågor: #38

    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.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End 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.02 ms
    Reset for next command	0.00 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/editors/yeeditor/include/functions_general.php:32
    17	get_yeeditor_option()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:589
    16	yeeditor_load_frontend_assets()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:31
    15	displayYeeditorContent_frontend()	JROOT/plugins/editors/yeeditor/include/functions_frontend.php:18
    14	get_yeeditor_translated_html()	JROOT/plugins/system/yeeditor_content/yeeditor_content.php:37
    13	plgSystemYeeditor_content->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

40. Frågetid: 1.60 ms Efter sista fråga: 3.07 ms Frågeminne: 0.025 MB Minne före fråga: 11.021 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
    
      LEFT JOIN `exp_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_contact.contact' 
      AND (fc.category_id IS NULL OR fc.category_id IN (73,0)) 
      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) 
      AND a.language in ('*','sv-SE')
    
      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_language	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
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	scubatravel.a.id	1	Using where; Using index; Distinct

    Profil

    Status	Duration
    Starting	0.22 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.01 ms
    Init	0.09 ms
    Optimizing	0.05 ms
    Statistics	0.18 ms
    Preparing	0.05 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.38 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.06 ms
    Creating sort index	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.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.05 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/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:304
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

41. Frågetid: 1.29 ms Efter sista fråga: 1.82 ms Frågeminne: 0.022 MB Minne före fråga: 11.144 MB Returnerade rader: 0
    Duplikatfrågor: #17  #27  #47

    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_contact.contact' 
      AND `m`.`content_item_id` = 107 
      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.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.06 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.66 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.04 ms
    Starting cleanup	0.00 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Anropsstack

    #	Uppringare	Fil och radnummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/views/contact/view.html.php:350
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

42. Frågetid: 0.83 ms Efter sista fråga: 0.46 ms Frågeminne: 0.033 MB Minne före fråga: 11.174 MB Returnerade rader: 43

    SHOW FULL COLUMNS 
      FROM `exp_contact_details`

    Förklara

    EXPLAIN inte möjlig i fråga: SHOW FULL COLUMNS FROM `exp_contact_details`

    Profil

    Status	Duration
    Starting	0.04 ms
    Checking permissions	0.01 ms
    Closing tables	0.00 ms
    Opening tables	0.22 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
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    Checking permissions	0.18 ms
    Closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.07 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.02 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/joomla/database/driver/mysqli.php:445
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:39
    13	ContactTableContact->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_contact/models/contact.php:628
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:368
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

43. Frågetid: 0.59 ms Efter sista fråga: 1.64 ms Frågeminne: 0.023 MB Minne före fråga: 11.339 MB Returnerade rader: 1

    SELECT *
    
      FROM exp_contact_details
    
      WHERE `id` = '107'

    Förklara

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

    Profil

    Status	Duration
    Starting	0.07 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.06 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.03 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    12	Joomla\CMS\Table\Table->load()	JROOT/components/com_contact/models/contact.php:629
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:368
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

44. Frågetid: 2.05 ms Efter sista fråga: 0.11 ms Frågeminne: 0.006 MB Minne före fråga: 11.346 MB

    UPDATE exp_contact_details
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '107'

    Förklara

    EXPLAIN inte möjlig i fråga: UPDATE exp_contact_details SET `hits` = (`hits` + 1) WHERE `id` = '107'

    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.00 ms
    Init for update	0.06 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.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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
    12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_contact/models/contact.php:630
    11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:368
    10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
    8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
    6	require_once JROOT/components/com_contact/contact.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]

    ---

45. Frågetid: 1.58 ms Efter sista fråga: 4.53 ms Frågeminne: 0.025 MB Minne före fråga: 11.592 MB Returnerade rader: 19

    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-21 17:23:38') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-21 17:23:38') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 228 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.28 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.05 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.58 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.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]

    ---

46. Frågetid: 0.74 ms Efter sista fråga: 11.18 ms Frågeminne: 0.024 MB Minne före fråga: 12.027 MB Returnerade rader: 1

    SELECT a.*, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      FROM exp_contact_details AS a
    
      LEFT JOIN exp_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN exp_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.id = 107

    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	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.17 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.06 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.00 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.02 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:225
    13	ContactModelContact->getItem()	JROOT/templates/stravel/helper.php:114
    12	ZTplHelper::getCurrentContact()	JROOT/modules/mod_heading/tmpl/default.php:43
    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]

    ---

47. Frågetid: 0.86 ms Efter sista fråga: 0.21 ms Frågeminne: 0.023 MB Minne före fråga: 12.054 MB Returnerade rader: 0
    Duplikatfrågor: #17  #27  #41

    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_contact.contact' 
      AND `m`.`content_item_id` = 107 
      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.05 ms
    Checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.39 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/contact.php:255
    13	ContactModelContact->getItem()	JROOT/templates/stravel/helper.php:114
    12	ZTplHelper::getCurrentContact()	JROOT/modules/mod_heading/tmpl/default.php:43
    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]

    ---

48. Frågetid: 1.33 ms Efter sista fråga: 0.69 ms Frågeminne: 0.027 MB Minne före fråga: 12.065 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
    
      LEFT JOIN `exp_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_users.user' 
      AND (fc.category_id IS NULL OR fc.category_id IN (73,0)) 
      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) 
      AND a.language in ('*','sv-SE')
    
      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_language	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
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	scubatravel.a.id	1	Using where; Using index; Distinct

    Profil

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.04 ms
    Creating tmp table	0.07 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.28 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.18 ms
    Creating sort index	0.03 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.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.03 ms
    Updating status	0.02 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/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:298
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:411
    14	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
    13	ContactModelContact->getItem()	JROOT/templates/stravel/helper.php:114
    12	ZTplHelper::getCurrentContact()	JROOT/modules/mod_heading/tmpl/default.php:43
    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]

    ---

49. Frågetid: 0.65 ms Efter sista fråga: 4.95 ms Frågeminne: 0.023 MB Minne före fråga: 12.289 MB Returnerade rader: 2
    Duplikatfrågor: #55  #56

    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.10 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.03 ms
    Statistics	0.14 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.02 ms
    Reset for next command	0.00 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]

    ---

50. Frågetid: 0.48 ms Efter sista fråga: 0.90 ms Frågeminne: 0.023 MB Minne före fråga: 12.311 MB Returnerade rader: 2
    Duplikatfrågor: #53

    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 = 228

    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.02 ms
    Statistics	0.09 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.01 ms
    Updating status	0.02 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]

    ---

51. Frågetid: 0.64 ms Efter sista fråga: 0.64 ms Frågeminne: 0.023 MB Minne före fråga: 12.329 MB Returnerade rader: 0
    Duplikatfrågor: #54

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `exp_contact_details` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_contact.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_contact_details` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `exp_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_contact'
    
      WHERE c.id = 107

    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.09 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.00 ms
    Executing	0.02 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.06 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 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/components/com_contact/helpers/association.php:43
    12	ContactHelperAssociation::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]

    ---

52. Frågetid: 0.63 ms Efter sista fråga: 3.76 ms Frågeminne: 0.023 MB Minne före fråga: 12.399 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.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.03 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	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.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: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]

    ---

53. Frågetid: 0.56 ms Efter sista fråga: 2.23 ms Frågeminne: 0.025 MB Minne före fråga: 12.460 MB Returnerade rader: 2
    Duplikatfrågor: #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 = 228

    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.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.03 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 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]

    ---

54. Frågetid: 0.41 ms Efter sista fråga: 0.17 ms Frågeminne: 0.025 MB Minne före fråga: 12.471 MB Returnerade rader: 0
    Duplikatfrågor: #51

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `exp_contact_details` AS `c`
    
      INNER JOIN `exp_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_contact.item'
    
      INNER JOIN `exp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `exp_contact_details` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `exp_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_contact'
    
      WHERE c.id = 107

    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.08 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.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Executing	0.02 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.03 ms
    Reset for next command	0.00 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/components/com_contact/helpers/association.php:43
    16	ContactHelperAssociation::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]

    ---

55. Frågetid: 0.38 ms Efter sista fråga: 1.09 ms Frågeminne: 0.023 MB Minne före fråga: 12.458 MB Returnerade rader: 2
    Duplikatfrågor: #49  #56

    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.05 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.02 ms
    Statistics	0.08 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 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.01 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
    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]

    ---

56. Frågetid: 0.29 ms Efter sista fråga: 0.31 ms Frågeminne: 0.023 MB Minne före fråga: 12.454 MB Returnerade rader: 2
    Duplikatfrågor: #49  #55

    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.04 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.06 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 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
    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]

    ---