An Coimisiún Le Rincí Gaelacha

The Irish Dancing Commission

Blessed Thomas Holford Catholic College

Venue

Street:: Urban Road, Altrincham,
City:: Cheshire WA15 8HT
Country:

Date	Title	Region
Currently no events are available

Home
Baile
- Find Teacher
- Teacher Search A to Z
Results
Torthaí
About Us
Eolas
Oireachtaisí
Championships
- All Irelands 2020
- World Championships 2020
- Championship Archives
  - All Irelands 2019
  - World Championships 2019
News
Nuacht
Feiseanna agus Scrúdaithe
Feiseanna & Exams
Sponsorship
Urraíocht
- Buy a brick
Rules
Rialacha
Vetting
Grinnfhiosrúchán

Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.

More information Ok

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1560719891,
                "last": 1560719891,
                "now": 1560719891
            },
            "token": "gZeTE1j4hcCGOPMyq7oMOSV1CTtBFA0I"
        },
        "registry": {
            "com_jem": {
                "venue": {
                    "99:366": {
                        "limitstart": 0
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "com_advertisementfactory": {
            "url": "https:\/\/www.clrg.ie\/index.php\/en\/feiseanna-exams\/find-a-feis\/venue\/99-blessed-thomas-holford-catholic-college.html"
        }
    }
}

Profile Information

Time

Memory

Time: 22.41 ms / 22.41 ms Memory: 1.707 MB / 2.08 MB Application: afterLoad

Time: 89.31 ms / 111.72 ms Memory: 6.167 MB / 8.24 MB Application: afterInitialise

Time: 17.77 ms / 129.49 ms Memory: 1.455 MB / 9.70 MB Application: afterRoute

Time: 4.68 ms / 134.17 ms Memory: 0.207 MB / 9.90 MB Application: beforeRenderComponent com_jem

Time: 41.50 ms / 175.67 ms Memory: 4.183 MB / 14.09 MB Application: afterRenderComponent com_jem

Time: 11.51 ms / 187.18 ms Memory: 0.588 MB / 14.67 MB Application: afterDispatch

Time: 4.69 ms / 191.87 ms Memory: 0.279 MB / 14.95 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 1)

Time: 4.09 ms / 195.96 ms Memory: 0.208 MB / 15.16 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 1)

Time: 0.04 ms / 196.00 ms Memory: 0.000 MB / 15.16 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 2)

Time: 1.16 ms / 197.15 ms Memory: 0.017 MB / 15.18 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 2)

Time: 0.03 ms / 197.19 ms Memory: 0.000 MB / 15.17 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 3)

Time: 1.13 ms / 198.32 ms Memory: 0.016 MB / 15.19 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 3)

Time: 0.03 ms / 198.35 ms Memory: 0.000 MB / 15.19 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 4)

Time: 1.16 ms / 199.51 ms Memory: 0.016 MB / 15.20 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 4)

Time: 2.70 ms / 202.20 ms Memory: 0.156 MB / 15.36 MB Application: beforeRenderModule mod_menu (Top Menu EN)

Time: 2.07 ms / 204.28 ms Memory: 0.094 MB / 15.45 MB Application: afterRenderModule mod_menu (Top Menu EN)

Time: 0.04 ms / 204.31 ms Memory: 0.000 MB / 15.45 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 2.30 ms / 206.61 ms Memory: 0.113 MB / 15.57 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 2.69 ms / 209.30 ms Memory: 0.116 MB / 15.68 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.51 ms / 209.81 ms Memory: 0.006 MB / 15.69 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.47 ms / 210.28 ms Memory: 0.002 MB / 15.69 MB Application: beforeRenderModule mod_menu (English Menu)

Time: 8.00 ms / 218.28 ms Memory: 0.255 MB / 15.94 MB Application: afterRenderModule mod_menu (English Menu)

Time: 4.47 ms / 222.75 ms Memory: 0.035 MB / 15.98 MB Application: beforeRenderModule mod_custom (Logo (small))

Time: 0.37 ms / 223.12 ms Memory: 0.003 MB / 15.98 MB Application: afterRenderModule mod_custom (Logo (small))

Time: 1.71 ms / 224.83 ms Memory: 0.001 MB / 15.98 MB Application: beforeRenderModule mod_custom (Footer EN)

Time: 0.33 ms / 225.17 ms Memory: 0.003 MB / 15.99 MB Application: afterRenderModule mod_custom (Footer EN)

Time: 0.03 ms / 225.19 ms Memory: 0.000 MB / 15.99 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 6)

Time: 1.09 ms / 226.28 ms Memory: 0.015 MB / 16.00 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 6)

Time: 0.03 ms / 226.31 ms Memory: 0.000 MB / 16.00 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 7)

Time: 1.02 ms / 227.33 ms Memory: 0.022 MB / 16.02 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 7)

Time: 0.03 ms / 227.36 ms Memory: 0.000 MB / 16.02 MB Application: beforeRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 5)

Time: 1.04 ms / 228.40 ms Memory: 0.016 MB / 16.04 MB Application: afterRenderModule mod_advertisementfactory_banners (Home Page Banners Ads 5)

Time: 1.26 ms / 229.66 ms Memory: 0.017 MB / 16.05 MB Application: beforeRenderModule mod_menu (English Menu mobile)

Time: 5.08 ms / 234.75 ms Memory: 0.018 MB / 16.07 MB Application: afterRenderModule mod_menu (English Menu mobile)

Time: 10.48 ms / 245.22 ms Memory: 1.051 MB / 17.12 MB Application: afterRender

Database queries total: 32.28 ms

Memory Usage

Database Queries

33 Queries Logged 32.28 ms

Query Time: 0.43 ms Query memory: 0.020 MB Memory before query: 3.875 MB Rows returned: 0

SELECT `session_id`

  FROM `clrg1_session`

  WHERE `session_id` = 'a2f53433954bc9b45ba7b62eab6953e7' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.07 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.06 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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.]

Query Time: 4.57 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 3.881 MB

INSERT INTO `clrg1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a2f53433954bc9b45ba7b62eab6953e7', 1, 1560719891, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `clrg1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a2f53433954bc9b45ba7b62eab6953e7', 1, 1560719891, 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.18 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	4.08 ms
closing tables	0.03 ms
freeing items	0.06 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.]

Query Time: 1.02 ms After last query: 3.59 ms Query memory: 0.040 MB Memory before query: 4.095 MB Rows returned: 48

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `clrg1_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	clrg1_extensions	NULL	ref	extension	extension	82	const	49	1.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 2.92 ms Query memory: 0.021 MB Memory before query: 4.359 MB Rows returned: 18

SELECT id, rules

  FROM `clrg1_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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.]

Query Time: 0.48 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 4.377 MB Rows returned: 2

SELECT b.id

  FROM clrg1_usergroups AS a

  LEFT JOIN clrg1_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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	13	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.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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.]

Query Time: 1.67 ms After last query: 0.84 ms Query memory: 0.030 MB Memory before query: 4.446 MB Rows returned: 105

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM clrg1_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	clrg1_extensions	NULL	ref	extension	extension	82	const	204	0.60	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 15.69 ms Query memory: 0.021 MB Memory before query: 6.056 MB Rows returned: 2

SELECT *

  FROM clrg1_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php: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.]

Query Time: 0.45 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 6.064 MB Rows returned: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `clrg1_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	clrg1_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 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.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php: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.]

Query Time: 0.38 ms After last query: 21.19 ms Query memory: 0.023 MB Memory before query: 7.499 MB Rows returned: 22

SELECT *

  FROM clrg1_rsform_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.32 ms After last query: 2.32 ms Query memory: 0.161 MB Memory before query: 7.691 MB Rows returned: 122

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM clrg1_menu AS m

  LEFT JOIN clrg1_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	197	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	clrgxm_db12.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 0.60 ms After last query: 20.24 ms Query memory: 0.022 MB Memory before query: 9.730 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `clrg1_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	clrg1_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 9.721 MB

UPDATE `clrg1_extensions`

  SET `params` = '{\"mediaversion\":\"37f6f828b769460aca28bd0c1205e3d2\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 1.96 ms Query memory: 0.019 MB Memory before query: 9.898 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM clrg1_template_styles as s

  LEFT JOIN clrg1_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	14.29	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	clrgxm_db12.s.template,const	1	4.48	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 0.38 ms After last query: 11.14 ms Query memory: 0.026 MB Memory before query: 11.288 MB Rows returned: 68

SELECT `keyname`,`value`

  FROM clrg1_jem_config

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 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.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_jem/classes/config.class.php:108
11	JemConfig->loadData()	JROOT/components/com_jem/classes/config.class.php:65
10	JemConfig->__construct()	JROOT/components/com_jem/classes/config.class.php:49
9	JemConfig::getInstance()	JROOT/components/com_jem/helpers/helper.php:34
8	JemHelper::config()	JROOT/components/com_jem/helpers/helper.php:83
7	JemHelper::cleanup()	JROOT/components/com_jem/jem.php:32
6	require_once JROOT/components/com_jem/jem.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.]

Query Time: 4.80 ms After last query: 8.06 ms Query memory: 0.118 MB Memory before query: 12.113 MB Rows returned: 510

SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi

  FROM clrg1_jem_categories as c

  LEFT JOIN clrg1_jem_cats_event_relations AS rel 
  ON rel.catid = c.id

  LEFT JOIN clrg1_jem_events AS a 
  ON a.id = rel.itemid

  WHERE c.published = 1 
  AND (c.access IN (1,1,5))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	6.67	Using where; Using temporary
1	SIMPLE	rel	NULL	ref	category event relation,catid	category event relation	4	clrgxm_db12.c.id	5	100.00	Using where; Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	clrgxm_db12.rel.itemid	1	100.00	Using where; Using index

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.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.01 ms
Sending data	4.33 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
18	JDatabaseDriver->loadColumn()	JROOT/components/com_jem/models/eventslist.php:685
17	JemModelEventslist->getCategories()	JROOT/components/com_jem/models/eventslist.php:383
16	JemModelEventslist->getListQuery()	JROOT/components/com_jem/models/venue.php:125
15	JemModelVenue->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jem/models/eventslist.php:494
12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/venue.php:109
11	JemModelVenue->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/venue/view.html.php:169
9	JemViewVenue->display()	JROOT/components/com_jem/controller.php:101
8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:42
6	require_once JROOT/components/com_jem/jem.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.]

Query Time: 1.43 ms After last query: 0.34 ms Query memory: 0.040 MB Memory before query: 12.121 MB Rows returned: 0

SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug

  FROM clrg1_jem_events as a

  LEFT JOIN clrg1_users AS u 
  on u.id = a.created_by

  LEFT JOIN clrg1_jem_venues AS l 
  ON l.id = a.locid

  LEFT JOIN clrg1_jem_countries AS ct 
  ON ct.iso2 = l.country

  LEFT JOIN clrg1_jem_cats_event_relations AS rel 
  ON rel.itemid = a.id

  LEFT JOIN clrg1_jem_categories AS c 
  ON c.id = rel.catid

  WHERE a.access IN (1,1,5) 
  AND ((`a`.published = 1)) 
  AND c.id  IN (1,2,3,4,5,6,7,8,9,10,11,12,13,15) 
  AND a.locid = 99

  GROUP BY a.id

  ORDER BY a.dates ASC,a.times ASC 
  LIMIT 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,idx_venue,idx_access,idx_pubstate	idx_venue	4	const	1	5.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	clrgxm_db12.a.created_by	1	100.00	Using where
1	SIMPLE	l	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ct	NULL	ref	iso2	iso2	8	clrgxm_db12.l.country	1	100.00	NULL
1	SIMPLE	rel	NULL	ref	category event relation,catid,itemid	itemid	4	clrgxm_db12.a.id	1	100.00	Using index condition
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	clrgxm_db12.rel.catid	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.13 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.34 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jem/models/eventslist.php:494
12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/venue.php:109
11	JemModelVenue->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/venue/view.html.php:169
9	JemViewVenue->display()	JROOT/components/com_jem/controller.php:101
8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:42
6	require_once JROOT/components/com_jem/jem.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.]

Query Time: 0.39 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 12.134 MB Rows returned: 1

SELECT id, venue, published, city, state, url, street, custom1, custom2, custom3, custom4, custom5,  custom6, custom7, custom8, custom9, custom10, locimage, meta_keywords, meta_description,  created, created_by, locdescription, country, map, latitude, longitude, postalCode, checked_out AS vChecked_out, checked_out_time AS vChecked_out_time,  
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug

  FROM `clrg1_jem_venues`

  WHERE id = 99 
  AND published = 1

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 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:1656
12	JDatabaseDriver->loadObject()	JROOT/components/com_jem/models/venue.php:199
11	JemModelVenue->getVenue()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/venue/view.html.php:170
9	JemViewVenue->display()	JROOT/components/com_jem/controller.php:101
8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:42
6	require_once JROOT/components/com_jem/jem.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.]

Query Time: 1.28 ms After last query: 4.88 ms Query memory: 0.038 MB Memory before query: 12.603 MB Rows returned: 0

SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug

  FROM clrg1_jem_events as a

  LEFT JOIN clrg1_users AS u 
  on u.id = a.created_by

  LEFT JOIN clrg1_jem_venues AS l 
  ON l.id = a.locid

  LEFT JOIN clrg1_jem_countries AS ct 
  ON ct.iso2 = l.country

  LEFT JOIN clrg1_jem_cats_event_relations AS rel 
  ON rel.itemid = a.id

  LEFT JOIN clrg1_jem_categories AS c 
  ON c.id = rel.catid

  WHERE a.access IN (1,1,5) 
  AND ((`a`.published = 1)) 
  AND c.id  IN (1,2,3,4,5,6,7,8,9,10,11,12,13,15) 
  AND a.locid = 99

  GROUP BY a.id

  ORDER BY a.dates ASC,a.times ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,idx_venue,idx_access,idx_pubstate	idx_venue	4	const	1	5.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	clrgxm_db12.a.created_by	1	100.00	Using where
1	SIMPLE	l	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ct	NULL	ref	iso2	iso2	8	clrgxm_db12.l.country	1	100.00	NULL
1	SIMPLE	rel	NULL	ref	category event relation,catid,itemid	itemid	4	clrgxm_db12.a.id	1	100.00	Using index condition
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	clrgxm_db12.rel.catid	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
12	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
11	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/venue/view.html.php:294
9	JemViewVenue->display()	JROOT/components/com_jem/controller.php:101
8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:42
6	require_once JROOT/components/com_jem/jem.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.]

Query Time: 0.37 ms After last query: 9.72 ms Query memory: 0.023 MB Memory before query: 14.094 MB Rows returned: 1

SELECT params 
  FROM clrg1_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 0.23 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 14.102 MB Rows returned: 1

SELECT id,template 
  FROM clrg1_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 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.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:1656
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 0.66 ms After last query: 8.72 ms Query memory: 0.021 MB Memory before query: 14.665 MB Rows returned: 3

SELECT language,id

  FROM `clrg1_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	clrg1_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	198	1.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.34 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.]

Query Time: 2.08 ms After last query: 2.88 ms Query memory: 0.029 MB Memory before query: 14.925 MB Rows returned: 21

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM clrg1_modules AS m

  LEFT JOIN clrg1_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN clrg1_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 <= '2019-06-16 21:18:11') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-16 21:18:11') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 366 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	158	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	clrgxm_db12.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	clrgxm_db12.m.id	2	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:26
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.63 ms After last query: 1.82 ms Query memory: 0.031 MB Memory before query: 15.095 MB Rows returned: 21

SHOW FULL COLUMNS 
  FROM `clrg1_advertisementfactory_ads`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 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
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_advertisementfactory/tables/ad.php:46
18	AdvertisementFactoryTableAd->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_advertisementfactory/models/servead.php:86
16	AdvertisementFactoryModelServeAd->checkExpired()	JROOT/components/com_advertisementfactory/models/servead.php:24
15	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
14	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:72
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.31 ms After last query: 0.48 ms Query memory: 0.009 MB Memory before query: 15.147 MB

UPDATE clrg1_advertisementfactory_ads

  SET state = 2
	, paid = 0
	, history = CONCAT('<b>2019-06-16 21:18:11</b>\nCOM_ADVERTISEMENTFACTORY_AD_STATE_CHANGED_EXPIRED\n\n\n', history)

  WHERE price_type = 3 
  AND state = 1 
  AND publish_down <= '2019-06-16 21:18:11'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	clrg1_advertisementfactory_ads	NULL	index	NULL	PRIMARY	4	NULL	16	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.03 ms
updating	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_advertisementfactory/models/servead.php:98
16	AdvertisementFactoryModelServeAd->checkExpired()	JROOT/components/com_advertisementfactory/models/servead.php:24
15	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
14	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:72
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.49 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 15.153 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10010'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.02 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
15	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
14	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:72
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.56 ms After last query: 0.83 ms Query memory: 0.025 MB Memory before query: 15.188 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10011'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.02 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.13 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
15	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
14	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:72
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.54 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 15.203 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10012'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.02 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
15	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
14	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:72
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.57 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 15.217 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10041'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.02 ms
statistics	0.03 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
15	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
14	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php:72
10	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.config.php	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:10
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.35 ms After last query: 6.34 ms Query memory: 0.026 MB Memory before query: 15.566 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `clrg1_menu` AS `c`

  INNER JOIN `clrg1_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `clrg1_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `clrg1_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 366

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 ms
end	0.00 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
19	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
18	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
17	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
16	include JROOT/modules/mod_languages/mod_languages.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/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:53
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.53 ms After last query: 19.58 ms Query memory: 0.026 MB Memory before query: 16.014 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10392'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.03 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
17	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
16	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.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/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:310
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.50 ms After last query: 0.58 ms Query memory: 0.026 MB Memory before query: 16.029 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10393'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
17	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
16	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.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/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:310
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.50 ms After last query: 0.53 ms Query memory: 0.026 MB Memory before query: 16.050 MB Rows returned: 1

SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served

  FROM clrg1_advertisementfactory_ads a

  WHERE a.type = 'banner' 
  AND a.state = 1 
  AND IF (a.price_type = "1", a.served < a.purchased, 1) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-16 21:18:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-16 21:18:11') 
  AND a.module_id = '10391'

  ORDER BY RAND()

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where; Using temporary; Using filesort

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.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_advertisementfactory/models/servead.php:59
17	AdvertisementFactoryModelServeAd->getAds()	JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.php:45
16	include JROOT/modules/mod_advertisementfactory_banners/mod_advertisementfactory_banners.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/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_katana/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php:310
9	include JROOT/templates/yoo_katana/styles/CLRG/layouts/theme.php	JROOT/templates/yoo_katana/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_katana/index.php:16
7	require JROOT/templates/yoo_katana/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.]

Query Time: 0.36 ms After last query: 14.49 ms Query memory: 0.029 MB Memory before query: 16.663 MB Rows returned: 90

SELECT * 
  FROM clrg1_acymailing_config

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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.]

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT a.id, a.title, a.url, a.filename, a.contents, a.keywords, a.price_type, a.purchased, a.served 
  FROM clrg1_advertisementfactory_ads a

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `clrg1_extensions`

2 × SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug 
  FROM clrg1_jem_events as a 
  LEFT JOIN clrg1_users AS u 
  on u.id = a.created_by 
  LEFT JOIN clrg1_jem_venues AS l 
  ON l.id = a.locid 
  LEFT JOIN clrg1_jem_countries AS ct 
  ON ct.iso2 = l.country 
  LEFT JOIN clrg1_jem_cats_event_relations AS rel 
  ON rel.itemid = a.id 
  LEFT JOIN clrg1_jem_categories AS c 
  ON c.id = rel.catid

1 × SELECT `session_id` 
  FROM `clrg1_session`

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM clrg1_modules AS m 
  LEFT JOIN clrg1_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN clrg1_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT language,id 
  FROM `clrg1_menu`

1 × SELECT id,template 
  FROM clrg1_template_styles

1 × SELECT params 
  FROM clrg1_extensions AS e

1 × SELECT id, venue, published, city, state, url, street, custom1, custom2, custom3, custom4, custom5,  custom6, custom7, custom8, custom9, custom10, locimage, meta_keywords, meta_description,  created, created_by, locdescription, country, map, latitude, longitude, postalCode, checked_out AS vChecked_out, checked_out_time AS vChecked_out_time,  
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM `clrg1_jem_venues`

1 × SELECT `keyname`,`value` 
  FROM clrg1_jem_confi

1 × SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi 
  FROM clrg1_jem_categories as c 
  LEFT JOIN clrg1_jem_cats_event_relations AS rel 
  ON rel.catid = c.id 
  LEFT JOIN clrg1_jem_events AS a 
  ON a.id = rel.itemid

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM clrg1_menu AS m 
  LEFT JOIN clrg1_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM clrg1_rsform_confi

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `clrg1_extensions`

```
1 × SELECT * 
  FROM clrg1_languages
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM clrg1_extensions

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

1 × SELECT id, rules 
  FROM `clrg1_viewlevels

1 × SELECT * 
  FROM clrg1_acymailing_confi

OTHER Tables:

1 × INSERT INTO `clrg1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a2f53433954bc9b45ba7b62eab6953e7', 1, 1560719891, 0, '', 0

1 × UPDATE `clrg1_extensions` 
  SET `params` = '{\"mediaversion\":\"37f6f828b769460aca28bd0c1205e3d2\"}'

1 × SHOW FULL COLUMNS 
  FROM `clrg1_advertisementfactory_ads

1 × UPDATE clrg1_advertisementfactory_ads 
  SET state = 2  , paid = 0  , history = CONCAT('<b>2019-06-16 21:18:11</b>\nCOM_ADVERTISEMENTFACTORY_AD_STATE_CHANGED_EXPIRED\n\n\n', history)