{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1593802497,
                "last": 1593802497,
                "now": 1593802497
            },
            "token": "LCJGSarxdH0UbTVuRBCD6fjIycqqS1VP"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "4d489e94c080107c7eaf6ed630d5a635854617c5": {
                    "link": "https:\/\/www.karvenu.co.il\/\u05e9\u05d5\u05e4\u05e12\/\u05d3\u05d9\u05e1\u05e7\u05d9\u05dd-\u05e6\u05e4\u05d9\u05d9\u05d4\/item\/562-\u05db\u05d7-\u05d4\u05d4\u05e7\u05e8\u05d1\u05d4",
                    "expiry": 1593802498
                }
            }
        }
    },
    "__k2store": {
        "currency": "USD"
    }
}

Time

Memory

88 שאילתות נרשמו 150.20 ms

1. Query Time: 0.36 ms

   SELECT `session_id`
   
     FROM `lta74h_session`
   
     WHERE `session_id` = 'br48l4dffjbrntpls03t55jimh' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lta74h_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT\libraries\src\Session\MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 2.66 ms After last query: 0.19 ms

   INSERT INTO `lta74h_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('br48l4dffjbrntpls03t55jimh', 1, '1593802497', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `lta74h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('br48l4dffjbrntpls03t55jimh', 1, '1593802497', 0, '', 0)

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverPdo->execute()	JROOT\libraries\src\Session\MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.32 ms After last query: 11.98 ms

   SELECT id, rules
   
     FROM `lta74h_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lta74h_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	NULL

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1496
   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:606
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 0.28 ms After last query: 0.19 ms

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	20.00	Using where; Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1540
   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:606
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.57 ms After last query: 45.45 ms

   SELECT `enabled`
   
     FROM `lta74h_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT\plugins\system\backuponupdate\backuponupdate.php:74
   7	require_once JROOT\plugins\system\backuponupdate\backuponupdate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
   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:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 1.52 ms After last query: 158.95 ms

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `lta74h_assets`
   
     WHERE `name` IN ('root.1','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easydiscuss','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_k2import','com_k2store','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_psalm','com_redirect','com_regularlabsmanager','com_rsform','com_search','com_sigpro','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lta74h_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	113	43.36	Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
   18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
   17	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
   16	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
   15	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
   14	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
   13	Joomla\CMS\User\User->authorise()	JROOT\plugins\system\advancedmodules\src\Document.php:28
   12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT\plugins\system\advancedmodules\src\Helper.php:32
   11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
   10	call_user_func_array()	JROOT\plugins\system\advancedmodules\src\Plugin.php:97
   9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT\plugins\system\advancedmodules\advancedmodules.php:64
   8	PlgSystemAdvancedModules->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:1080
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:798
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 6.04 ms After last query: 3.95 ms

   UPDATE `lta74h_extensions`
   
     SET `params` = '{\"mediaversion\":\"18302db46b79fda15111a74cd91aeec0\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lta74h_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverPdo->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
   13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
   12	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
   11	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT\plugins\system\k2\k2.php:388
   8	plgSystemK2->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:1080
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:798
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 0.73 ms After last query: 51.76 ms

   SELECT id 
     FROM lta74h_k2_categories 
     WHERE published=1 
     AND trash=0 
     AND access IN(1,1)

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lta74h_k2_categories	range	category,published,access,trash	category	8	NULL	89	100.00	Using where; Using index

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1540
   14	JDatabaseDriver->loadColumn()	JROOT\components\com_k2\helpers\permissions.php:274
   13	K2HelperPermissions::canAddItem()	JROOT\components\com_k2\views\item\view.html.php:35
   12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
   11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
   10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
   9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
   8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
   6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.52 ms After last query: 0.51 ms

   SELECT * 
     FROM lta74h_k2_items 
     WHERE id=562 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lta74h_k2_items	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
   14	JDatabaseDriver->loadObject()	JROOT\components\com_k2\models\item.php:33
   13	K2ModelItem->getData()	JROOT\components\com_k2\views\item\view.html.php:42
   12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
   11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
   10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
   9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
   8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
   6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 32.70 ms After last query: 1.77 ms

    SHOW FULL COLUMNS 
      FROM `lta74h_k2_categories`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lta74h_k2_categories`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\pdomysql.php:320
    18	JDatabaseDriverPdomysql->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_k2\tables\k2category.php:36
    15	TableK2Category->__construct()	JROOT\libraries\src\Table\Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT\components\com_k2\models\item.php:64
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.45 ms After last query: 1.84 ms

    SELECT * 
      FROM lta74h_k2_categories 
      WHERE id = '42'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1455
    15	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_k2\tables\k2category.php:67
    14	TableK2Category->load()	JROOT\components\com_k2\models\item.php:65
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.45 ms After last query: 5.14 ms

    SELECT * 
      FROM lta74h_k2_categories 
      WHERE id = '2'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1455
    15	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_k2\tables\k2category.php:67
    14	TableK2Category->load()	JROOT\components\com_k2\models\item.php:85
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.44 ms After last query: 0.69 ms

    SELECT tag.*
                
      FROM lta74h_k2_tags AS tag
                JOIN lta74h_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
                
      WHERE tag.published=1
                
      AND xref.itemID = 562 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	6	100.00	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	karvenu.xref.tagID	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\item.php:1174
    14	K2ModelItem->getItemTags()	JROOT\components\com_k2\models\item.php:98
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.21 ms After last query: 2.94 ms

    SELECT extraFieldsGroup 
      FROM lta74h_k2_categories 
      WHERE id=42

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1730
    15	JDatabaseDriver->loadResult()	JROOT\components\com_k2\models\item.php:1210
    14	K2ModelItem->getItemExtraFields()	JROOT\components\com_k2\models\item.php:159
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 0.30 ms After last query: 0.18 ms

    SELECT * 
      FROM lta74h_k2_extra_fields 
      WHERE `
      group` = 1 
      AND published=1 
      AND (id IN (3,4) OR `type` = 'header') 
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	50.00	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\item.php:1214
    14	K2ModelItem->getItemExtraFields()	JROOT\components\com_k2\models\item.php:159
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 0.38 ms After last query: 0.95 ms

    SELECT * 
      FROM lta74h_k2_attachments 
      WHERE itemID=562

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_attachments	ref	itemID	itemID	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\item.php:1399
    14	K2ModelItem->getItemAttachments()	JROOT\components\com_k2\models\item.php:164
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 0.20 ms After last query: 0.14 ms

    SELECT * 
      FROM lta74h_k2_rating 
      WHERE itemID = 562

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_rating	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    16	JDatabaseDriver->loadObject()	JROOT\components\com_k2\models\item.php:872
    15	K2ModelItem->getRating()	JROOT\components\com_k2\models\item.php:916
    14	K2ModelItem->getVotesPercentage()	JROOT\components\com_k2\models\item.php:169
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 24.38 ms After last query: 3.19 ms

    SHOW FULL COLUMNS 
      FROM `lta74h_users`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lta74h_users`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\pdomysql.php:320
    23	JDatabaseDriverPdomysql->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
    22	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
    21	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\User.php:40
    20	Joomla\CMS\Table\User->__construct()	JROOT\libraries\src\Table\Table.php:312
    19	Joomla\CMS\Table\Table::getInstance()	JROOT\libraries\src\User\User.php:603
    18	Joomla\CMS\User\User::getTable()	JROOT\libraries\src\User\User.php:880
    17	Joomla\CMS\User\User->load()	JROOT\libraries\src\User\User.php:248
    16	Joomla\CMS\User\User->__construct()	JROOT\libraries\src\User\User.php:301
    15	Joomla\CMS\User\User::getInstance()	JROOT\libraries\src\Factory.php:266
    14	Joomla\CMS\Factory::getUser()	JROOT\components\com_k2\models\item.php:211
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 0.36 ms After last query: 0.41 ms

    SELECT *
    
      FROM `lta74h_users`
    
      WHERE `id` = 434

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_users	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1455
    19	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\User.php:86
    18	Joomla\CMS\Table\User->load()	JROOT\libraries\src\User\User.php:883
    17	Joomla\CMS\User\User->load()	JROOT\libraries\src\User\User.php:248
    16	Joomla\CMS\User\User->__construct()	JROOT\libraries\src\User\User.php:301
    15	Joomla\CMS\User\User::getInstance()	JROOT\libraries\src\Factory.php:266
    14	Joomla\CMS\Factory::getUser()	JROOT\components\com_k2\models\item.php:211
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 0.29 ms After last query: 4.42 ms

    SELECT `g`.`id`,`g`.`title`
    
      FROM `lta74h_usergroups` AS g
    
      INNER JOIN `lta74h_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 434

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	karvenu.m.group_id	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1496
    19	JDatabaseDriver->loadAssocList()	JROOT\libraries\src\Table\User.php:111
    18	Joomla\CMS\Table\User->load()	JROOT\libraries\src\User\User.php:883
    17	Joomla\CMS\User\User->load()	JROOT\libraries\src\User\User.php:248
    16	Joomla\CMS\User\User->__construct()	JROOT\libraries\src\User\User.php:301
    15	Joomla\CMS\User\User::getInstance()	JROOT\libraries\src\Factory.php:266
    14	Joomla\CMS\Factory::getUser()	JROOT\components\com_k2\models\item.php:211
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 0.28 ms After last query: 1.01 ms

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM lta74h_k2_users 
      WHERE userID=434

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_users	ref	userID	userID	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    15	JDatabaseDriver->loadObject()	JROOT\components\com_k2\models\item.php:1550
    14	K2ModelItem->getUserProfile()	JROOT\components\com_k2\models\item.php:214
    13	K2ModelItem->prepareItem()	JROOT\components\com_k2\views\item\view.html.php:50
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.77 ms After last query: 13.89 ms

    SELECT 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 lta74h_fields AS a
    
      LEFT JOIN `lta74h_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lta74h_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lta74h_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lta74h_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lta74h_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `lta74h_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_k2.item-media' 
      AND (fc.category_id IS NULL OR fc.category_id IN (42,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	karvenu.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	karvenu.a.id	1	100.00	Using where; Using index

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:327
    19	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
    17	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:479
    16	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:569
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 0.67 ms After last query: 11.65 ms

    SELECT 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 lta74h_fields AS a
    
      LEFT JOIN `lta74h_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lta74h_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lta74h_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lta74h_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lta74h_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `lta74h_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_k2.item' 
      AND (fc.category_id IS NULL OR fc.category_id IN (42,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	karvenu.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	karvenu.a.id	1	100.00	Using where; Using index

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    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:327
    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:136
    18	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:388
    17	PlgSystemFields->display()	JROOT\plugins\system\fields\fields.php:308
    16	PlgSystemFields->onContentAfterTitle()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:641
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.31 ms After last query: 6.93 ms

    SELECT * 
      FROM lta74h_k2_items 
      WHERE id=562

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_items	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    19	JDatabaseDriver->loadObject()	JROOT\components\com_k2store\helpers\cart.php:294
    18	K2StoreHelperCart::getItemInfo()	JROOT\plugins\k2\k2store\k2store.php:387
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 18.62 ms After last query: 1.01 ms

    SHOW FULL COLUMNS 
      FROM `lta74h_k2_items`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lta74h_k2_items`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    26	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\pdomysql.php:320
    25	JDatabaseDriverPdomysql->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
    24	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
    23	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_k2\tables\k2item.php:58
    22	TableK2Item->__construct()	JROOT\libraries\src\Table\Table.php:312
    21	Joomla\CMS\Table\Table::getInstance()	JROOT\administrator\components\com_k2store\library\prices.php:303
    20	K2StorePrices::_getK2Item()	JROOT\administrator\components\com_k2store\library\prices.php:239
    19	K2StorePrices::getProduct()	JROOT\components\com_k2store\helpers\cart.php:296
    18	K2StoreHelperCart::getItemInfo()	JROOT\plugins\k2\k2store\k2store.php:387
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.44 ms After last query: 0.49 ms

    SELECT *
    
      FROM lta74h_k2_items
    
      WHERE `id` = '562'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_items	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1455
    23	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
    22	Joomla\CMS\Table\Table->load()	JROOT\administrator\components\com_k2\tables\table.php:23
    21	K2Table->load()	JROOT\administrator\components\com_k2store\library\prices.php:305
    20	K2StorePrices::_getK2Item()	JROOT\administrator\components\com_k2store\library\prices.php:239
    19	K2StorePrices::getProduct()	JROOT\components\com_k2store\helpers\cart.php:296
    18	K2StoreHelperCart::getItemInfo()	JROOT\plugins\k2\k2store\k2store.php:387
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 0.27 ms After last query: 0.19 ms
    Duplicate queries: #31

    SELECT *
    
      FROM lta74h_k2store_products
    
      WHERE product_id='562'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2store_products	ref	product_id	product_id	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    20	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_k2store\library\prices.php:244
    19	K2StorePrices::getProduct()	JROOT\components\com_k2store\helpers\cart.php:296
    18	K2StoreHelperCart::getItemInfo()	JROOT\plugins\k2\k2store\k2store.php:387
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 0.27 ms After last query: 0.66 ms

    SELECT *
    
      FROM lta74h_k2store_storeprofiles
    
      WHERE state=1
    
      ORDER BY store_id ASC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2store_storeprofiles	index	NULL	PRIMARY	4	NULL	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    20	JDatabaseDriver->loadObject()	JROOT\components\com_k2store\helpers\cart.php:471
    19	K2StoreHelperCart::getStoreAddress()	JROOT\components\com_k2store\helpers\cart.php:313
    18	K2StoreHelperCart::getItemInfo()	JROOT\plugins\k2\k2store\k2store.php:387
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 0.32 ms After last query: 3.19 ms

    SELECT template 
      FROM lta74h_template_styles 
      WHERE client_id = 0 
      AND home=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	11	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1730
    20	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_k2store\helpers\strapper.php:108
    19	K2StoreStrapper::addCSS()	JROOT\components\com_k2store\helpers\cart.php:148
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 0.32 ms After last query: 3.44 ms

    SELECT po.*,o.option_name, o.type
    
      FROM lta74h_k2store_product_options AS po
    
      LEFT JOIN lta74h_k2store_options AS o 
      ON po.option_id=o.option_id
    
      WHERE po.product_id=562 
      AND o.state=1
    
      ORDER BY po.product_option_id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	po	index	NULL	PRIMARY	4	NULL	1	100.00	Using where
    1	SIMPLE	o	eq_ref	PRIMARY	PRIMARY	4	karvenu.po.option_id	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2store\models\mycart.php:261
    19	K2StoreModelMyCart->getProductOptions()	JROOT\components\com_k2store\helpers\cart.php:186
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 0.25 ms After last query: 0.14 ms
    Duplicate queries: #27

    SELECT *
    
      FROM lta74h_k2store_products
    
      WHERE product_id='562'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2store_products	ref	product_id	product_id	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    20	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_k2store\library\inventory.php:144
    19	K2StoreInventory::getStock()	JROOT\components\com_k2store\helpers\cart.php:198
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

32. Query Time: 11.18 ms After last query: 0.64 ms

    SHOW FULL COLUMNS 
      FROM `lta74h_k2store_products`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `lta74h_k2store_products`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    25	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\pdomysql.php:320
    24	JDatabaseDriverPdomysql->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
    23	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
    22	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_k2store\tables\products.php:19
    21	TableProducts->__construct()	JROOT\libraries\src\Table\Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT\administrator\components\com_k2store\library\inventory.php:147
    19	K2StoreInventory::getStock()	JROOT\components\com_k2store\helpers\cart.php:198
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

33. Query Time: 0.27 ms After last query: 4.43 ms

    SELECT pr.*
    
      FROM lta74h_k2store_productprices as pr
    
      WHERE pr.product_id=562 
      AND pr.quantity_start <=1
    
      ORDER BY pr.quantity_start DESC

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1652
    21	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_k2store\library\prices.php:131
    20	K2StorePrices::getPriceRange()	JROOT\administrator\components\com_k2store\library\prices.php:67
    19	K2StorePrices::getPrice()	JROOT\components\com_k2store\helpers\cart.php:203
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

34. Query Time: 0.59 ms After last query: 0.37 ms

    SELECT tr2.taxrate_id, tr2.taxrate_name AS name, tr2.tax_percent AS rate 
      FROM  lta74h_k2store_taxrules tr1 
      LEFT JOIN  lta74h_k2store_taxrates tr2 
      ON (tr1.taxrate_id = tr2.taxrate_id) 
      LEFT JOIN  lta74h_k2store_geozonerules z2gz 
      ON (tr2.geozone_id = z2gz.geozone_id) 
      LEFT JOIN  lta74h_k2store_geozones gz 
      ON (tr2.geozone_id = gz.geozone_id) 
      WHERE tr1.taxprofile_id = 0 
      AND tr1.address = 'shipping' 
      AND z2gz.country_id = 104 
      AND (z2gz.zone_id = 0 OR z2gz.zone_id = 0) 
      ORDER BY tr1.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	tr1	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	tr2	eq_ref	PRIMARY	PRIMARY	4	karvenu.tr1.taxrate_id	1	100.00	NULL
    1	SIMPLE	gz	eq_ref	PRIMARY	PRIMARY	4	karvenu.tr2.geozone_id	1	100.00	Using index
    1	SIMPLE	z2gz	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_k2store\library\tax.php:255
    21	K2StoreTax->getTaxRateItems()	JROOT\administrator\components\com_k2store\library\tax.php:192
    20	K2StoreTax->getRates()	JROOT\administrator\components\com_k2store\library\tax.php:117
    19	K2StoreTax->getProductTax()	JROOT\components\com_k2store\helpers\cart.php:214
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

35. Query Time: 0.33 ms After last query: 0.18 ms

    SELECT tr2.taxrate_id, tr2.taxrate_name AS name, tr2.tax_percent AS rate 
      FROM  lta74h_k2store_taxrules tr1 
      LEFT JOIN  lta74h_k2store_taxrates tr2 
      ON (tr1.taxrate_id = tr2.taxrate_id) 
      LEFT JOIN  lta74h_k2store_geozonerules z2gz 
      ON (tr2.geozone_id = z2gz.geozone_id) 
      LEFT JOIN  lta74h_k2store_geozones gz 
      ON (tr2.geozone_id = gz.geozone_id) 
      WHERE tr1.taxprofile_id = 0 
      AND tr1.address = 'store' 
      AND z2gz.country_id = 104 
      AND (z2gz.zone_id = 0 OR z2gz.zone_id = 0) 
      ORDER BY tr1.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	tr1	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	tr2	eq_ref	PRIMARY	PRIMARY	4	karvenu.tr1.taxrate_id	1	100.00	NULL
    1	SIMPLE	gz	eq_ref	PRIMARY	PRIMARY	4	karvenu.tr2.geozone_id	1	100.00	Using index
    1	SIMPLE	z2gz	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_k2store\library\tax.php:255
    21	K2StoreTax->getTaxRateItems()	JROOT\administrator\components\com_k2store\library\tax.php:218
    20	K2StoreTax->getRates()	JROOT\administrator\components\com_k2store\library\tax.php:117
    19	K2StoreTax->getProductTax()	JROOT\components\com_k2store\helpers\cart.php:214
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

36. Query Time: 2.84 ms After last query: 3.93 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM lta74h_modules AS m
    
      LEFT JOIN lta74h_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN lta74h_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.access IN (1,1) 
      AND m.client_id = 0
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	published,newsfeeds	published	1	const	81	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	karvenu.m.id	1	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	karvenu.m.module,const	1	100.00	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    28	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\advancedmodules\src\Helpers\advancedmodulehelper.php:406
    27	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT\plugins\system\advancedmodules\src\Helpers\advancedmodulehelper.php:123
    26	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT\libraries\joomla\event\dispatcher.php:165
    25	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
    24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Helper\ModuleHelper.php:358
    23	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
    22	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\components\com_k2store\views\mycart\tmpl\addtocart.php:31
    21	include JROOT\components\com_k2store\views\mycart\tmpl\addtocart.php	JROOT\libraries\src\MVC\View\HtmlView.php:695
    20	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
    19	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_k2store\helpers\cart.php:249
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

37. Query Time: 0.33 ms After last query: 40.42 ms

    SELECT *
    
      FROM lta74h_k2store_currency
    
      WHERE state=1

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1496
    28	JDatabaseDriver->loadAssocList()	JROOT\administrator\components\com_k2store\library\currency.php:68
    27	K2StoreCurrency::getCurrencyList()	JROOT\administrator\components\com_k2store\library\currency.php:35
    26	K2StoreCurrency->__construct()	JROOT\administrator\components\com_k2store\library\currency.php:55
    25	K2StoreCurrency::getInstance()	JROOT\administrator\components\com_k2store\library\base.php:73
    24	K2StoreFactory::getCurrencyObject()	JROOT\administrator\components\com_k2store\library\prices.php:289
    23	K2StorePrices::number()	JROOT\components\com_k2store\helpers\cart.php:275
    22	K2StoreHelperCart::dispayPriceWithTax()	JROOT\components\com_k2store\views\mycart\tmpl\addtocart.php:45
    21	include JROOT\components\com_k2store\views\mycart\tmpl\addtocart.php	JROOT\libraries\src\MVC\View\HtmlView.php:695
    20	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
    19	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_k2store\helpers\cart.php:249
    18	K2StoreHelperCart::getAjaxCart()	JROOT\plugins\k2\k2store\k2store.php:391
    17	plgK2K2Store->_loadCart()	JROOT\plugins\k2\k2store\k2store.php:98
    16	plgK2K2Store->onK2AfterDisplay()	JROOT\libraries\joomla\event\event.php:70
    15	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:723
    13	K2ModelItem->execPlugins()	JROOT\components\com_k2\views\item\view.html.php:53
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

38. Query Time: 9.56 ms After last query: 3.33 ms

    UPDATE lta74h_k2_items
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '562'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_items	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverPdo->execute()	JROOT\libraries\src\Table\Table.php:1242
    14	Joomla\CMS\Table\Table->hit()	JROOT\components\com_k2\models\item.php:798
    13	K2ModelItem->hit()	JROOT\components\com_k2\views\item\view.html.php:117
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

39. Query Time: 0.38 ms After last query: 0.38 ms

    SELECT * 
      FROM lta74h_k2_comments 
      WHERE itemID=562 
      AND published=1  
      ORDER BY commentDate DESC 
      LIMIT 10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_comments	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\item.php:1420
    13	K2ModelItem->getItemComments()	JROOT\components\com_k2\views\item\view.html.php:205
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

40. Query Time: 1.11 ms After last query: 1.88 ms

    SELECT i.*, c.alias as categoryalias 
      FROM lta74h_k2_items as i
                
      LEFT JOIN lta74h_k2_categories c 
      ON c.id = i.catid
                
      WHERE i.id != 562
                
      AND i.published = 1
                
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-07-03 18:54:57' )
                
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-07-03 18:54:57' )  
      AND i.access IN(1,1)  
      AND i.trash = 0
                
      AND i.created_by = 434
                
      AND i.created_by_alias=''
                
      AND c.published = 1  
      AND c.access IN(1,1)  
      AND c.trash = 0
                
      ORDER BY i.created DESC 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	index	PRIMARY,item,catid,created_by	created	5	NULL	5	32200.00	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	karvenu.i.catid	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\itemlist.php:759
    13	K2ModelItemlist->getAuthorLatest()	JROOT\components\com_k2\views\item\view.html.php:243
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

41. Query Time: 1.12 ms After last query: 1.81 ms

    SELECT id, name,  parent  
      FROM lta74h_k2_categories 
      WHERE published=1  
      AND trash=0 
      AND access IN(1,1) 
      ORDER BY parent

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_categories	ref	category,published,access,trash	category	2	const	89	100.00	Using index condition; Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\itemlist.php:1077
    15	K2ModelItemlist->getCategoriesTree()	JROOT\components\com_k2\helpers\route.php:314
    14	K2HelperRoute::_findItem()	JROOT\components\com_k2\helpers\route.php:41
    13	K2HelperRoute::getItemRoute()	JROOT\components\com_k2\views\item\view.html.php:246
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

42. Query Time: 2.31 ms After last query: 3.69 ms

    SELECT itemID 
      FROM lta74h_k2_tags_xref 
      WHERE tagID IN (14,38,673,674,675,676) 
      AND itemID!=562 
      GROUP BY itemID

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_tags_xref	range	tagID,itemID	tagID	4	NULL	349	100.00	Using index condition; Using where; Using temporary; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1540
    14	JDatabaseDriver->loadColumn()	JROOT\components\com_k2\models\itemlist.php:818
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

43. Query Time: 4.82 ms After last query: 0.52 ms

    SELECT i.*, c.alias as categoryalias 
      FROM lta74h_k2_items as i
                
      LEFT JOIN lta74h_k2_categories c 
      ON c.id = i.catid
                
      WHERE i.published = 1
                
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-07-03 18:54:57' )
                
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-07-03 18:54:57' )  
      AND i.access IN(1,1)  
      AND i.trash = 0
                    
      AND c.published = 1  
      AND c.access IN(1,1)  
      AND c.trash = 0
                    
      AND (i.id) IN (94,98,109,111,114,116,117,119,125,126,127,133,134,135,137,140,145,146,147,148,149,150,152,154,155,156,157,160,161,162,164,165,171,172,174,175,176,177,178,179,180,183,185,187,188,189,190,191,192,193,195,198,199,200,201,202,203,204,205,206,209,210,211,213,216,218,219,220,221,222,223,224,225,226,227,228,230,231,232,233,236,243,246,248,250,251,252,255,256,257,258,259,260,261,262,266,267,271,272,275,278,279,280,281,282,283,284,285,287,291,293,296,297,299,305,306,307,308,309,310,313,314,318,321,322,323,324,325,329,330,331,332,333,334,335,337,339,341,342,343,346,349,350,351,353,355,356,357,358,359,360,361,364,365,368,369,373,374,375,378,379,382,384,387,389,392,393,394,396,397,400,403,408,409,411,412,413,416,417,419,422,424,425,428,429,431,432,434,436,437,444,445,446,447,452,454,455,458,461,462,463,464,468,470,471,472,473,474,475,476,477,481,482,485,487,488,491,493,501,553,554,555,556,560,563,566,569,573,574,575,576,577,578,579,580,581,583,587,588,590,592,596,598,599,601,602,603,604,605,608,609,610,612,619,624,626,632,636,641,643,650,653,658,661,663,668,669,672,677,683,684,686,687,690,696,699,701,705,706,707,710,714,715,716,717,718,720,721,722,734,735,736,737,739,743,745,752,760,768,802,873,960,976,1085,1086,1857,2456,2578,2581,2645,2718,3009)
                    
      ORDER BY i.created DESC 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	index	PRIMARY,item,catid	created	5	NULL	30	1040.00	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	karvenu.i.catid	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\itemlist.php:858
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

44. Query Time: 0.25 ms After last query: 0.42 ms

    SELECT * 
      FROM lta74h_k2_categories 
      WHERE id = '21'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1455
    16	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_k2\tables\k2category.php:67
    15	TableK2Category->load()	JROOT\components\com_k2\models\item.php:65
    14	K2ModelItem->prepareItem()	JROOT\components\com_k2\models\itemlist.php:868
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

45. Query Time: 0.26 ms After last query: 4.22 ms
    Duplicate queries: #59  #61

    SELECT extraFieldsGroup 
      FROM lta74h_k2_categories 
      WHERE id=21

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT\components\com_k2\models\item.php:1210
    15	K2ModelItem->getItemExtraFields()	JROOT\components\com_k2\models\item.php:159
    14	K2ModelItem->prepareItem()	JROOT\components\com_k2\models\itemlist.php:868
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

46. Query Time: 0.34 ms After last query: 0.18 ms
    Duplicate queries: #51  #56  #60  #62

    SELECT * 
      FROM lta74h_k2_extra_fields 
      WHERE `
      group` = 1 
      AND published=1 
      AND (id IN (3,4,5) OR `type` = 'header') 
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lta74h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	50.00	Using where; Using filesort

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT\components\com_k2\models\item.php:1214
    15	K2ModelItem->getItemExtraFields()	JROOT\components\com_k2\models\item.php:159
    14	K2ModelItem->prepareItem()	JROOT\components\com_k2\models\itemlist.php:868
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

47. Query Time: 0.81 ms After last query: 1.42 ms

    SELECT 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 lta74h_fields AS a
    
      LEFT JOIN `lta74h_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lta74h_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lta74h_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lta74h_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lta74h_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `lta74h_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_k2.relatedByTag-media' 
      AND (fc.category_id IS NULL OR fc.category_id IN (21,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	karvenu.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	karvenu.a.id	1	100.00	Using where; Using index

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    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:327
    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:136
    18	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:479
    17	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
    16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:569
    14	K2ModelItem->execPlugins()	JROOT\components\com_k2\models\itemlist.php:869
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

48. Query Time: 0.68 ms After last query: 3.44 ms

    SELECT 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 lta74h_fields AS a
    
      LEFT JOIN `lta74h_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lta74h_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lta74h_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lta74h_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lta74h_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `lta74h_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_k2.relatedByTag' 
      AND (fc.category_id IS NULL OR fc.category_id IN (21,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	karvenu.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	karvenu.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	karvenu.a.id	1	100.00	Using where; Using index

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1691
    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:327
    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:136
    19	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:388
    18	PlgSystemFields->display()	JROOT\plugins\system\fields\fields.php:308
    17	PlgSystemFields->onContentAfterTitle()	JROOT\libraries\joomla\event\event.php:70
    16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT\components\com_k2\models\item.php:641
    14	K2ModelItem->execPlugins()	JROOT\components\com_k2\models\itemlist.php:869
    13	K2ModelItemlist->getRelatedItems()	JROOT\components\com_k2\views\item\view.html.php:255
    12	K2ViewItem->display()	JROOT\libraries\src\Cache\Controller\ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT\libraries\src\MVC\Controller\BaseController.php:663
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_k2\controllers\controller.php:19
    9	K2Controller->display()	JROOT\components\com_k2\controllers\item.php:74
    8	K2ControllerItem->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_k2\k2.php:64
    6	require_once JROOT\components\com_k2\k2.php	JROOT\libraries\src\Component\ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

49. Query Time: 0.29 ms After last query: 0.61 ms

    SELEC