{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653022461,
                "last": 1653022461,
                "now": 1653022461
            },
            "token": "X0uzRDncuAwNcrNqgtSiubCldaOUJHyy"
        },
        "registry": {
            "rspagebuilder": {
                "search": ""
            }
        },
        "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_rsfirewall": {
            "geoip": "US"
        }
    }
}

Time

Memory

24 SQL-запросов зафиксировано 24.63 ms

1. Query Time: 0.47 ms Query memory: 0.013 MB Memory before query: 1.859 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `l52fb_session`
   
     WHERE `session_id` = 'b5f8494c7d000803896b282e97f3f521' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	l52fb_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.49 ms After last query: 0.37 ms Query memory: 0.010 MB Memory before query: 1.876 MB

   INSERT INTO `l52fb_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('b5f8494c7d000803896b282e97f3f521', 1, 1653022461, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `l52fb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b5f8494c7d000803896b282e97f3f521', 1, 1653022461, 0, '', 0)

   Profile

   Status	Duration
   starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.14 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.46 ms After last query: 4.67 ms Query memory: 0.015 MB Memory before query: 2.100 MB Rows returned: 3

   SELECT id, rules
   
     FROM `l52fb_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

4. Query Time: 0.61 ms After last query: 0.34 ms Query memory: 0.016 MB Memory before query: 2.124 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   init	0.05 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.11 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.44 ms After last query: 9.54 ms Query memory: 0.017 MB Memory before query: 2.647 MB Rows returned: 0

   SELECT `path`
   
     FROM l52fb_rsfirewall_ignored
   
     WHERE `type`='ignore_folder' OR `type`='ignore_file'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.40 ms After last query: 0.23 ms Query memory: 0.017 MB Memory before query: 2.665 MB Rows returned: 0

   SELECT `file`
   
     FROM l52fb_rsfirewall_hashes
   
     WHERE `type`='protect'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.49 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 2.679 MB Rows returned: 52

   SELECT *
   
     FROM l52fb_rsfirewall_configuration

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 1.01 ms After last query: 8.93 ms Query memory: 0.024 MB Memory before query: 3.097 MB Rows returned: 10

   SHOW FULL COLUMNS 
     FROM `l52fb_rsfirewall_logs`

   Explain

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

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.34 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.02 ms
   Opening tables	0.03 ms
   checking permissions	0.05 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.03 ms
   Sending data	0.07 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   removing tmp table	0.06 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
   11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
   10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
   9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
   8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.64 ms After last query: 28.76 ms Query memory: 0.018 MB Memory before query: 3.675 MB

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	l52fb_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.14 ms
   updating	0.12 ms
   end	0.01 ms
   Waiting for query cache lock	0.01 ms
   end	0.01 ms
   query end	0.04 ms
   closing tables	0.04 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jxtcxmenu/jxtcxmenu.php:46
   9	plgSystemjxtcxmenu->onAfterInitialise()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.39 ms After last query: 15.07 ms Query memory: 0.016 MB Memory before query: 4.895 MB Rows returned: 0

    SELECT *
    
      FROM l52fb_rsfirewall_hashes
    
      WHERE (`type`='3.9.9' OR `type`='protect') 
      AND `flag`!='C'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1026
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.39 ms After last query: 0.38 ms Query memory: 0.017 MB Memory before query: 4.916 MB Rows returned: 0

    SELECT *
    
      FROM l52fb_rsfirewall_snapshots
    
      WHERE `type`='protect'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
    10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1049
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.56 ms After last query: 0.25 ms Query memory: 0.018 MB Memory before query: 4.933 MB Rows returned: 0

    SELECT `ip`,`reason`
    
      FROM l52fb_rsfirewall_lists
    
      WHERE (`ip`='18.205.56.183' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='1' 
      AND `published`='1'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l52fb_rsfirewall_lists	NULL	ref	published,type,ip	type	1	const	6	36.79	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
    10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1085
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 1.17 ms After last query: 0.30 ms Query memory: 0.018 MB Memory before query: 4.950 MB Rows returned: 0

    SELECT `ip`,`reason`
    
      FROM l52fb_rsfirewall_lists
    
      WHERE (`ip`='18.205.56.183' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='0' 
      AND `published`='1'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l52fb_rsfirewall_lists	NULL	ALL	published,type,ip	NO INDEX KEY COULD BE USED	NULL	NULL	326	36.79	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.72 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
    10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1089
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.41 ms After last query: 2.66 ms Query memory: 0.019 MB Memory before query: 5.973 MB Rows returned: 0

    SELECT *
    
      FROM l52fb_rsfirewall_exceptions
    
      WHERE `published`='1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:682
    10	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1142
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 1.84 ms After last query: 11.28 ms Query memory: 0.030 MB Memory before query: 6.405 MB Rows returned: 46

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `l52fb_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_foxcontact','com_installer','com_joomlaupdate','com_jxtc','com_jxtceasyimage','com_jxtcreadinglist','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_rspagebuilder','com_search','com_sigpro','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l52fb_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	47	100.00	Using index condition

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.34 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.97 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_rspagebuilder/models/page.php:21
    14	RSPageBuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_rspagebuilder/models/page.php:30
    12	RSPageBuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_rspagebuilder/views/page/view.html.php:22
    10	RSPageBuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rspagebuilder/controller.php:17
    8	RSPageBuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rspagebuilder/rspagebuilder.php:14
    6	require_once JROOT/components/com_rspagebuilder/rspagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.76 ms After last query: 1.48 ms Query memory: 0.026 MB Memory before query: 6.531 MB Rows returned: 1

    SELECT a.*,l.title AS language_title,ua.name AS author_name
    
      FROM l52fb_rspagebuilder as a
    
      LEFT JOIN `l52fb_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN l52fb_users AS ua 
      ON ua.id = a.created_by
    
      WHERE a.id = 9 
      AND a.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
    1	SIMPLE	l	NULL	const	idx_langcode	idx_langcode	28	const	0	0.00	unique row not found
    1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.17 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.07 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_rspagebuilder/models/page.php:64
    12	RSPageBuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_rspagebuilder/views/page/view.html.php:22
    10	RSPageBuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rspagebuilder/controller.php:17
    8	RSPageBuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rspagebuilder/rspagebuilder.php:14
    6	require_once JROOT/components/com_rspagebuilder/rspagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.52 ms After last query: 8.08 ms Query memory: 0.033 MB Memory before query: 6.891 MB Rows returned: 1

    SELECT *
    
      FROM `l52fb_modules`
    
      WHERE `id` = '828' 
      AND (`publish_up` = '0000-00-00 00:00:00' OR `publish_up` <= '2022-05-20 04:54:21') 
      AND (`publish_down` = '0000-00-00 00:00:00' OR `publish_down` >= '2022-05-20 04:54:21') 
      AND `published`='1' 
      AND `client_id`=0 
      AND `access` IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l52fb_modules	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/components/com_rspagebuilder/layouts/elements/bootstrap2/module.php:37
    17	include JROOT/components/com_rspagebuilder/layouts/elements/bootstrap2/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    16	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rspagebuilder/helpers/rspagebuilder.php:112
    15	RSPageBuilderHelper::loadElementLayout()	JROOT/components/com_rspagebuilder/helpers/element-parser.php:231
    14	ElementParser::viewPage()	JROOT/components/com_rspagebuilder/views/page/tmpl/default.php:27
    13	include JROOT/components/com_rspagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rspagebuilder/views/page/view.html.php:84
    10	RSPageBuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rspagebuilder/controller.php:17
    8	RSPageBuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rspagebuilder/rspagebuilder.php:14
    6	require_once JROOT/components/com_rspagebuilder/rspagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 3.01 ms After last query: 21.08 ms Query memory: 0.071 MB Memory before query: 8.771 MB Rows returned: 22
    Duplicate queries: #24

    SELECT a.id, a.state, a.alias, a.publish_up, a.publish_down,a.title,a.introtext,a.images,a.created,a.modified_by,a.access,a.featured,a.created_by,a.catid
    
      FROM l52fb_content AS a
    
      WHERE a.state = 1 
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up < '2022-05-20 04:54:21' ) 
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down > '2022-05-20 04:54:21' ) 
      AND a.catid IN (54) 
      AND a.access IN (1,1)
    
      ORDER BY a.created DESC 
      LIMIT 200

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	12	16.00	Using intersect(idx_catid,idx_state); Using where; Using filesort

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.16 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	2.28 ms
    end	0.01 ms
    query end	0.09 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_junewsultra/helper/com_content.php:417
    20	com_content::getList()	JROOT/modules/mod_junewsultra/mod_junewsultra.php:95
    19	include JROOT/modules/mod_junewsultra/mod_junewsultra.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_rspagebuilder/layouts/elements/bootstrap2/module.php:85
    17	include JROOT/components/com_rspagebuilder/layouts/elements/bootstrap2/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    16	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rspagebuilder/helpers/rspagebuilder.php:112
    15	RSPageBuilderHelper::loadElementLayout()	JROOT/components/com_rspagebuilder/helpers/element-parser.php:231
    14	ElementParser::viewPage()	JROOT/components/com_rspagebuilder/views/page/tmpl/default.php:27
    13	include JROOT/components/com_rspagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rspagebuilder/views/page/view.html.php:84
    10	RSPageBuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rspagebuilder/controller.php:17
    8	RSPageBuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rspagebuilder/rspagebuilder.php:14
    6	require_once JROOT/components/com_rspagebuilder/rspagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 1.13 ms After last query: 1.43 ms Query memory: 0.050 MB Memory before query: 9.297 MB Rows returned: 3

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	101	10.16	Using where

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.20 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    32	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    31	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    30	ContentRouter->getCategorySegment()	Same as call in the line below.
    29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_junewsultra/helper/com_content.php:502
    20	com_content::getList()	JROOT/modules/mod_junewsultra/mod_junewsultra.php:95
    19	include JROOT/modules/mod_junewsultra/mod_junewsultra.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    18	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_rspagebuilder/layouts/elements/bootstrap2/module.php:85
    17	include JROOT/components/com_rspagebuilder/layouts/elements/bootstrap2/module.php	JROOT/libraries/src/Layout/FileLayout.php:125
    16	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_rspagebuilder/helpers/rspagebuilder.php:112
    15	RSPageBuilderHelper::loadElementLayout()	JROOT/components/com_rspagebuilder/helpers/element-parser.php:231
    14	ElementParser::viewPage()	JROOT/components/com_rspagebuilder/views/page/tmpl/default.php:27
    13	include JROOT/components/com_rspagebuilder/views/page/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rspagebuilder/views/page/view.html.php:84
    10	RSPageBuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rspagebuilder/controller.php:17
    8	RSPageBuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rspagebuilder/rspagebuilder.php:14
    6	require_once JROOT/components/com_rspagebuilder/rspagebuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 4.62 ms After last query: 66.31 ms Query memory: 0.024 MB Memory before query: 9.425 MB Rows returned: 22

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM l52fb_modules AS m
    
      LEFT JOIN l52fb_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN l52fb_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-20 04:54:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-20 04:54:21') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 27 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	NO INDEX KEY COULD BE USED	NULL	NULL	275	1.00	Using where; Using temporary; Using filesort
    1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	newsfeeds	204	u0397366_spok17.e.element,const	3	1.41	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	u0397366_spok17.m.id	8	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.06 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	3.48 ms
    Creating sort index	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.07 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/versant/layouts/default/layout.php:94
    8	require JROOT/templates/versant/layouts/default/layout.php	JROOT/templates/versant/index.php:26
    7	require JROOT/templates/versant/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.99 ms After last query: 3.48 ms Query memory: 0.029 MB Memory before query: 9.543 MB Rows returned: 3

    SELECT id,filename 
      FROM l52fb_jxtc_ezimg_images 
      WHERE folder='slideshow5' 
      ORDER BY ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l52fb_jxtc_ezimg_images	NULL	ref	folder	folder	386	const	12	100.00	Using index condition; Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.14 ms
    end	0.01 ms
    query end	0.31 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jxtceasyimage/support/helper.php:82
    19	EzimgHelper::refreshImages()	JROOT/administrator/components/com_jxtceasyimage/support/helper.php:306
    18	EzimgHelper::getImages()	JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php:39
    17	require JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php	JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php:34
    16	include JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/versant/XTC/XTC_library.php:626
    11	_xtcJdocCount()	JROOT/templates/versant/XTC/XTC_library.php:561
    10	xtcBootstrapGrid()	JROOT/templates/versant/layouts/default/layout_includes/region2.php:65
    9	require JROOT/templates/versant/layouts/default/layout_includes/region2.php	JROOT/templates/versant/layouts/default/layout.php:124
    8	require JROOT/templates/versant/layouts/default/layout.php	JROOT/templates/versant/index.php:26
    7	require JROOT/templates/versant/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.88 ms After last query: 1.05 ms Query memory: 0.037 MB Memory before query: 9.617 MB Rows returned: 17

    SHOW FULL COLUMNS 
      FROM `l52fb_jxtc_ezimg_images`

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.24 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.05 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    24	JDatabaseDriverMysqli->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_jxtceasyimage/tables/images.php:54
    21	TableImages->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jxtceasyimage/support/helper.php:88
    19	EzimgHelper::refreshImages()	JROOT/administrator/components/com_jxtceasyimage/support/helper.php:306
    18	EzimgHelper::getImages()	JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php:39
    17	require JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php	JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php:34
    16	include JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/versant/XTC/XTC_library.php:626
    11	_xtcJdocCount()	JROOT/templates/versant/XTC/XTC_library.php:561
    10	xtcBootstrapGrid()	JROOT/templates/versant/layouts/default/layout_includes/region2.php:65
    9	require JROOT/templates/versant/layouts/default/layout_includes/region2.php	JROOT/templates/versant/layouts/default/layout.php:124
    8	require JROOT/templates/versant/layouts/default/layout.php	JROOT/templates/versant/index.php:26
    7	require JROOT/templates/versant/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.57 ms After last query: 0.30 ms Query memory: 0.031 MB Memory before query: 9.679 MB Rows returned: 3

    SELECT * 
      FROM l52fb_jxtc_ezimg_images 
      WHERE published=1 
      AND folder='slideshow5' 
      ORDER BY ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l52fb_jxtc_ezimg_images	NULL	ref	folder	folder	386	const	12	10.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jxtceasyimage/support/helper.php:310
    18	EzimgHelper::getImages()	JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php:39
    17	require JROOT/modules/mod_jxtc_eiunoslider/tmpl/default.php	JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php:34
    16	include JROOT/modules/mod_jxtc_eiunoslider/mod_jxtc_eiunoslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/versant/XTC/XTC_library.php:626
    11	_xtcJdocCount()	JROOT/templates/versant/XTC/XTC_library.php:561
    10	xtcBootstrapGrid()	JROOT/templates/versant/layouts/default/layout_includes/region2.php:65
    9	require JROOT/templates/versant/layouts/default/layout_includes/region2.php	JROOT/templates/versant/layouts/default/layout.php:124
    8	require JROOT/templates/versant/layouts/default/layout.php	JROOT/templates/versant/index.php:26
    7	require JROOT/templates/versant/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 2.38 ms After last query: 2.30 ms Query memory: 0.031 MB Memory before query: 9.773 MB Rows returned: 22
    Duplicate queries: #18

    SELECT a.id, a.state, a.alias, a.publish_up, a.publish_down,a.title,a.introtext,a.images,a.created,a.modified_by,a.access,a.featured,a.created_by,a.catid
    
      FROM l52fb_content AS a
    
      WHERE a.state = 1 
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up < '2022-05-20 04:54:21' ) 
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down > '2022-05-20 04:54:21' ) 
      AND a.catid IN (54) 
      AND a.access IN (1,1)
    
      ORDER BY a.created DESC 
      LIMIT 200

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	12	16.00	Using intersect(idx_catid,idx_state); Using where; Using filesort

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.84 ms
    end	0.01 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_junewsultra/helper/com_content.php:417
    17	com_content::getList()	JROOT/modules/mod_junewsultra/mod_junewsultra.php:95
    16	include JROOT/modules/mod_junewsultra/mod_junewsultra.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    13	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    12	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/templates/versant/XTC/XTC_library.php:626
    11	_xtcJdocCount()	JROOT/templates/versant/XTC/XTC_library.php:561
    10	xtcBootstrapGrid()	JROOT/templates/versant/layouts/default/layout_includes/region3.php:66
    9	require JROOT/templates/versant/layouts/default/layout_includes/region3.php	JROOT/templates/versant/layouts/default/layout.php:124
    8	require JROOT/templates/versant/layouts/default/layout.php	JROOT/templates/versant/index.php:26
    7	require JROOT/templates/versant/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

1. 2 × SELECT a.id, a.state, a.alias, a.publish_up, a.publish_down,a.title,a.introtext,a.images,a.created,a.modified_by,a.access,a.featured,a.created_by,a.catid 
     FROM l52fb_content AS a

2. 2 × SELECT `ip`,`reason` 
     FROM l52fb_rsfirewall_lists

3. 1 × SELECT id, rules 
     FROM `l52fb_viewlevels

4. 1 × SELECT * 
     FROM `l52fb_modules`

5. 1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
     FROM l52fb_rspagebuilder as a 
     LEFT JOIN `l52fb_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN l52fb_users AS ua 
     ON ua.id = a.created_by

6. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM `l52fb_categories` AS `s` 
     INNER JOIN `l52fb_categories` AS `c` 
     ON (s.lft <= c.lft 
     AND c.lft < s.rgt) OR (c.lft < s.lft 
     AND s.rgt < c.rgt)

7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM l52fb_modules AS m 
     LEFT JOIN l52fb_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN l52fb_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

8. 1 × SELECT * 
     FROM l52fb_jxtc_ezimg_images

9. 1 × SELECT id,filename 
     FROM l52fb_jxtc_ezimg_images

10. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `l52fb_assets`

11. 1 × SELECT * 
      FROM l52fb_rsfirewall_exceptions

12. 1 × SELECT `file` 
      FROM l52fb_rsfirewall_hashes

13. 1 × SELECT `path` 
      FROM l52fb_rsfirewall_ignored

14. 1 × SELECT * 
      FROM l52fb_rsfirewall_configuratio

15. 1 × SELECT * 
      FROM l52fb_rsfirewall_hashes

16. 1 × SELECT `session_id` 
      FROM `l52fb_session`

17. 1 × SELECT * 
      FROM l52fb_rsfirewall_snapshots

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

Прочие SQL-запросы:

1. 1 × SHOW FULL COLUMNS 
     FROM `l52fb_jxtc_ezimg_images

2. 1 × UPDATE `l52fb_extensions` 
     SET `params` = '{\"mediaversion\":\"f1f53ee45ed934230d5e8e5be18bd78e\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `l52fb_rsfirewall_logs

4. 1 × INSERT INTO `l52fb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('b5f8494c7d000803896b282e97f3f521', 1, 1653022461, 0, '', 0