Browse our cakes collections (Birthday cakes, celebration cakes, wedding cakes, teatime cake, etc.) to order the best cakes in abuja at affordable prices.

At Lilies Pastries, our products are made from the best ingredients available and are baked on-demand to ensure total freshness.

Cakes

We bake nutritious and beautiful cakes for birthdays, weddings, celebrations and other occasions. Our team of decorators ensures that the cake design suites the occasion you are celebrating and it’s according to your specifications.

Order Cake(s)

TeaTime Cake

Fresh, nutritious and scrumptious with a stylish touch from “Lilies golden fingers” is how I would describe our ever delicious Teatime cake which can be served for breakfast (it’s perfect to accompany a cup of tea), ideal for lunch boxes or afternoon snacks and any other way you may want to savour it. It comes in mouth-watering flavours like vanilla, butterscotch, banana, chocolate and red velvet. The Teatime cake remains our signature product and we are happy to serve you the best.

Place Order

CupCakes

Our modern and fashionable cupcakes are made to complement the traditional wedding and birthday cake. There come in a variety of flavours and designs as well.

Place Order

Lilies Squares (Chin Chin)

It is a scrumptious fried pastry made to serve as snacks. Our chin chin taste good, are highly nutritious and come in different shapes – meaning that you can order a customized shape in case you want them for your occasion. We bake them as a retail or wholesale product.

Place Order

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1664725644,
                "last": 1664725644,
                "now": 1664725644
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 70.19 ms / 70.19 ms Memory: 0.781 MB / 1.16 MB Application: afterLoad

Time: 156.60 ms / 226.79 ms Memory: 1.632 MB / 2.79 MB Application: afterInitialise

Time: 46.52 ms / 273.31 ms Memory: 0.429 MB / 3.22 MB Application: afterRoute

Time: 3.33 ms / 276.64 ms Memory: 0.037 MB / 3.26 MB Application: beforeRenderComponent com_content

Time: 14.55 ms / 291.19 ms Memory: 0.118 MB / 3.38 MB Application: Before Access::preloadComponents (all components)

Time: 2.22 ms / 293.41 ms Memory: 0.071 MB / 3.45 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 293.44 ms Memory: -0.004 MB / 3.44 MB Application: Before Access::preloadPermissions (com_content)

Time: 2.63 ms / 296.07 ms Memory: 0.287 MB / 3.73 MB Application: After Access::preloadPermissions (com_content)

Time: 0.04 ms / 296.11 ms Memory: -0.018 MB / 3.71 MB Application: Before Access::getAssetRules (id:41 name:com_content.article.2)

Time: 1.35 ms / 297.46 ms Memory: 0.072 MB / 3.78 MB Application: After Access::getAssetRules (id:41 name:com_content.article.2)

Time: 79.59 ms / 377.05 ms Memory: 0.684 MB / 4.47 MB Application: afterRenderComponent com_content

Time: 3.47 ms / 380.52 ms Memory: 0.011 MB / 4.48 MB Application: afterDispatch

Time: 17.49 ms / 398.02 ms Memory: 0.263 MB / 4.74 MB Application: beforeRenderModule mod_search (search)

Time: 2.93 ms / 400.95 ms Memory: 0.016 MB / 4.76 MB Application: afterRenderRawModule mod_search (search)

Time: 0.02 ms / 400.96 ms Memory: -0.004 MB / 4.76 MB Application: beforeRenderModule mod_search (search)

Time: 1.86 ms / 402.82 ms Memory: 0.002 MB / 4.76 MB Application: afterRenderModule mod_search (search)

Time: 0.08 ms / 402.90 ms Memory: -0.001 MB / 4.76 MB Application: beforeRenderModule mod_footer (footer)

Time: 1.00 ms / 403.90 ms Memory: 0.008 MB / 4.76 MB Application: afterRenderRawModule mod_footer (footer)

Time: 0.02 ms / 403.92 ms Memory: -0.002 MB / 4.76 MB Application: beforeRenderModule mod_footer (footer)

Time: 0.51 ms / 404.42 ms Memory: 0.002 MB / 4.76 MB Application: afterRenderModule mod_footer (footer)

Time: 0.08 ms / 404.51 ms Memory: 0.008 MB / 4.77 MB Application: beforeRenderModule mod_acymailing (Newsletter sign up)

Time: 19.37 ms / 423.88 ms Memory: 0.366 MB / 5.14 MB Application: afterRenderRawModule mod_acymailing (Newsletter sign up)

Time: 0.02 ms / 423.90 ms Memory: -0.012 MB / 5.13 MB Application: beforeRenderModule mod_acymailing (Newsletter sign up)

Time: 0.48 ms / 424.38 ms Memory: 0.002 MB / 5.13 MB Application: afterRenderModule mod_acymailing (Newsletter sign up)

Time: 0.06 ms / 424.45 ms Memory: -0.004 MB / 5.12 MB Application: beforeRenderModule mod_jxtc_html (Connect with us:)

Time: 0.43 ms / 424.87 ms Memory: 0.006 MB / 5.13 MB Application: afterRenderRawModule mod_jxtc_html (Connect with us:)

Time: 0.01 ms / 424.89 ms Memory: -0.002 MB / 5.13 MB Application: beforeRenderModule mod_jxtc_html (Connect with us:)

Time: 0.36 ms / 425.25 ms Memory: 0.002 MB / 5.13 MB Application: afterRenderModule mod_jxtc_html (Connect with us:)

Time: 0.09 ms / 425.34 ms Memory: 0.001 MB / 5.13 MB Application: beforeRenderModule mod_jxtc_html (Quick links:)

Time: 0.15 ms / 425.49 ms Memory: 0.004 MB / 5.14 MB Application: afterRenderRawModule mod_jxtc_html (Quick links:)

Time: 0.01 ms / 425.50 ms Memory: -0.002 MB / 5.13 MB Application: beforeRenderModule mod_jxtc_html (Quick links:)

Time: 0.35 ms / 425.85 ms Memory: 0.002 MB / 5.14 MB Application: afterRenderModule mod_jxtc_html (Quick links:)

Time: 0.11 ms / 425.96 ms Memory: 0.005 MB / 5.14 MB Application: beforeRenderModule mod_jxtc_html (Footer Contact Info:)

Time: 0.16 ms / 426.13 ms Memory: 0.011 MB / 5.15 MB Application: afterRenderRawModule mod_jxtc_html (Footer Contact Info:)

Time: 0.01 ms / 426.14 ms Memory: -0.004 MB / 5.15 MB Application: beforeRenderModule mod_jxtc_html (Footer Contact Info:)

Time: 0.35 ms / 426.49 ms Memory: 0.002 MB / 5.15 MB Application: afterRenderModule mod_jxtc_html (Footer Contact Info:)

Time: 0.06 ms / 426.55 ms Memory: -0.002 MB / 5.15 MB Application: beforeRenderModule mod_microbread (mod_microbread)

Time: 1.63 ms / 428.18 ms Memory: 0.011 MB / 5.16 MB Application: afterRenderRawModule mod_microbread (mod_microbread)

Time: 0.01 ms / 428.19 ms Memory: -0.004 MB / 5.16 MB Application: beforeRenderModule mod_microbread (mod_microbread)

Time: 0.38 ms / 428.57 ms Memory: 0.002 MB / 5.16 MB Application: afterRenderModule mod_microbread (mod_microbread)

Time: 0.07 ms / 428.64 ms Memory: 0.000 MB / 5.16 MB Application: beforeRenderModule mod_jxtc_html (Order button)

Time: 0.15 ms / 428.78 ms Memory: 0.003 MB / 5.16 MB Application: afterRenderRawModule mod_jxtc_html (Order button)

Time: 0.01 ms / 428.79 ms Memory: -0.001 MB / 5.16 MB Application: beforeRenderModule mod_jxtc_html (Order button)

Time: 0.33 ms / 429.13 ms Memory: 0.002 MB / 5.16 MB Application: afterRenderModule mod_jxtc_html (Order button)

Time: 0.06 ms / 429.19 ms Memory: 0.003 MB / 5.17 MB Application: beforeRenderModule mod_sj_flat_menu (Main Menu)

Time: 7.21 ms / 436.40 ms Memory: 0.306 MB / 5.47 MB Application: afterRenderRawModule mod_sj_flat_menu (Main Menu)

Time: 0.02 ms / 436.42 ms Memory: -0.006 MB / 5.47 MB Application: beforeRenderModule mod_sj_flat_menu (Main Menu)

Time: 0.39 ms / 436.81 ms Memory: 0.002 MB / 5.47 MB Application: afterRenderModule mod_sj_flat_menu (Main Menu)

Time: 0.04 ms / 436.85 ms Memory: 0.007 MB / 5.47 MB Application: beforeRenderModule mod_menu (About Menu)

Time: 4.90 ms / 441.76 ms Memory: 0.029 MB / 5.50 MB Application: afterRenderRawModule mod_menu (About Menu)

Time: 0.02 ms / 441.77 ms Memory: -0.004 MB / 5.50 MB Application: beforeRenderModule mod_menu (About Menu)

Time: 0.37 ms / 442.14 ms Memory: 0.002 MB / 5.50 MB Application: afterRenderModule mod_menu (About Menu)

Time: 0.09 ms / 442.23 ms Memory: 0.004 MB / 5.51 MB Application: beforeRenderModule mod_jxtc_html (Head social)

Time: 0.16 ms / 442.39 ms Memory: 0.004 MB / 5.51 MB Application: afterRenderRawModule mod_jxtc_html (Head social)

Time: 0.01 ms / 442.40 ms Memory: -0.001 MB / 5.51 MB Application: beforeRenderModule mod_jxtc_html (Head social)

Time: 0.34 ms / 442.75 ms Memory: 0.002 MB / 5.51 MB Application: afterRenderModule mod_jxtc_html (Head social)

Time: 0.03 ms / 442.78 ms Memory: -0.001 MB / 5.51 MB Application: beforeRenderModule mod_jxtc_html (top call us)

Time: 4.26 ms / 447.03 ms Memory: 0.014 MB / 5.52 MB Application: afterRenderRawModule mod_jxtc_html (top call us)

Time: 0.01 ms / 447.05 ms Memory: -0.002 MB / 5.52 MB Application: beforeRenderModule mod_jxtc_html (top call us)

Time: 0.35 ms / 447.40 ms Memory: 0.002 MB / 5.52 MB Application: afterRenderModule mod_jxtc_html (top call us)

Time: 679.09 ms / 1126.49 ms Memory: 0.239 MB / 5.76 MB Application: afterRender

Database queries total: 54.10 ms

Memory Usage

Database Queries

24 Queries Logged 54.10 ms

Query Time: 1.44 ms Query memory: 0.007 MB Memory before query: 1.609 MB Rows returned: 0

SELECT `data`

  FROM `z0dyz_session`

  WHERE `session_id` = X'6361663165306564633838333761333137633764636432663133336133363338'

Explain

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

Profile

Status	Duration
Starting	0.20 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.10 ms
Checking permissions	0.03 ms
Opening tables	0.14 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.15 ms
Preparing	0.03 ms
Executing	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.16 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.24 ms After last query: 3.62 ms Query memory: 0.004 MB Memory before query: 1.687 MB Rows returned: 0

SELECT `session_id`

  FROM `z0dyz_session`

  WHERE `session_id` = X'6361663165306564633838333761333137633764636432663133336133363338' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.18 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.14 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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: 2.53 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.693 MB

INSERT INTO `z0dyz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6361663165306564633838333761333137633764636432663133336133363338', 1, 1664725644, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `z0dyz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6361663165306564633838333761333137633764636432663133336133363338', 1, 1664725644, 0, '', 0)

Profile

Status	Duration
Starting	0.21 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init for update	0.04 ms
Update	0.16 ms
Waiting for query cache lock	0.05 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	1.46 ms
Closing tables	0.04 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.14 ms
Updating status	0.05 ms
Reset for next command	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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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: 2.13 ms After last query: 6.34 ms Query memory: 0.006 MB Memory before query: 1.729 MB Rows returned: 45

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

  FROM `z0dyz_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	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:225
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.42 ms After last query: 6.14 ms Query memory: 0.005 MB Memory before query: 1.854 MB Rows returned: 4

SELECT id, rules

  FROM `z0dyz_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
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:225
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.51 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 1.865 MB Rows returned: 2

SELECT b.id

  FROM z0dyz_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
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:225
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.93 ms After last query: 1.99 ms Query memory: 0.005 MB Memory before query: 1.888 MB Rows returned: 117

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

  FROM z0dyz_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z0dyz_extensions	ref	extension	extension	82	const	158	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
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:225
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.83 ms After last query: 35.14 ms Query memory: 0.008 MB Memory before query: 2.441 MB Rows returned: 33

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 z0dyz_menu AS m

  LEFT JOIN z0dyz_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	45	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	lilijxne_liespa.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.22 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.13 ms
Checking permissions	0.03 ms
Opening tables	0.16 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.05 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.08 ms
Sorting result	0.06 ms
Executing	0.03 ms
Sending data	0.05 ms
Creating sort index	0.70 ms
End of update loop	0.06 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.19 ms
Updating status	0.08 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
16	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
13	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
12	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
11	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
10	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
9	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
8	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/plugins/system/expiresheaders/expiresheaders.php:28
7	plgSystemExpiresHeaders->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
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:225
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.52 ms After last query: 60.90 ms Query memory: 0.009 MB Memory before query: 3.034 MB Rows returned: 1

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

  FROM `z0dyz_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	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/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:66
9	plgSystemVmogmetatag->_init()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:103
8	plgSystemVmogmetatag->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.52 ms After last query: 0.25 ms Query memory: 0.006 MB Memory before query: 3.028 MB

UPDATE `z0dyz_extensions`

  SET `params` = '{\"mediaversion\":\"41b94cea240b5e203344328dced9cb76\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `z0dyz_extensions` SET `params` = '{\"mediaversion\":\"41b94cea240b5e203344328dced9cb76\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.18 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init for update	0.13 ms
Updating	0.13 ms
End of update loop	0.03 ms
Waiting for query cache lock	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	1.36 ms
Closing tables	0.05 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.17 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:66
9	plgSystemVmogmetatag->_init()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:103
8	plgSystemVmogmetatag->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.75 ms After last query: 6.79 ms Query memory: 0.006 MB Memory before query: 3.117 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM z0dyz_template_styles as s

  LEFT JOIN z0dyz_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.18 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.12 ms
Checking permissions	0.03 ms
Opening tables	0.14 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.16 ms
Preparing	0.12 ms
Executing	0.03 ms
Sending data	0.22 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.15 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:345
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.40 ms After last query: 6.53 ms Query memory: 0.003 MB Memory before query: 3.236 MB Rows returned: 1

SELECT *

  FROM z0dyz_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.19 ms
Waiting for query cache lock	0.03 ms
Init	0.02 ms
Checking query cache for query	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.12 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.57 ms
Statistics	0.28 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.35 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.13 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:225
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.87 ms After last query: 15.46 ms Query memory: 0.009 MB Memory before query: 3.382 MB Rows returned: 45

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `z0dyz_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_icebreaker','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijosef','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_rsform','com_scriptmerge','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.03 ms After last query: 0.24 ms Query memory: 0.009 MB Memory before query: 3.445 MB Rows returned: 273

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `z0dyz_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z0dyz_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	596	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.31 ms After last query: 3.97 ms Query memory: 0.007 MB Memory before query: 3.788 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `z0dyz_content`

Explain

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

Profile

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.60 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Filling schema table	0.03 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
Checking permissions	0.18 ms
Closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Removing tmp table	0.17 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.05 ms
Freeing items	0.19 ms
Updating status	9.80 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.20 ms After last query: 9.63 ms Query memory: 0.005 MB Memory before query: 3.852 MB

UPDATE z0dyz_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'

Explain

EXPLAIN not possible on query: UPDATE z0dyz_content SET `hits` = (`hits` + 1) WHERE `id` = '2'

Profile

Status	Duration
Starting	0.18 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
Init for update	0.07 ms
Updating	0.10 ms
End of update loop	0.03 ms
Waiting for query cache lock	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	1.13 ms
Closing tables	0.05 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.15 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.50 ms After last query: 3.23 ms Query memory: 0.007 MB Memory before query: 4.019 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM z0dyz_content AS a

  INNER JOIN z0dyz_categories AS c 
  on c.id = a.catid

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

  LEFT JOIN z0dyz_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN z0dyz_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 2 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-10-02 15:47:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-10-02 15:47:24') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Profile

Status	Duration
Starting	0.19 ms
Waiting for query cache lock	0.03 ms
Init	0.02 ms
Checking query cache for query	0.29 ms
Checking permissions	0.04 ms
Opening tables	0.53 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.11 ms
Optimizing	0.10 ms
Statistics	0.22 ms
Preparing	0.04 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.22 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.30 ms After last query: 3.95 ms Query memory: 0.006 MB Memory before query: 4.130 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `z0dyz_contentitem_tag_map` AS m 

  INNER JOIN `z0dyz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	52	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	lilijxne_liespa.t.id	8	Using index condition; Using where

Profile

Status	Duration
Starting	0.18 ms
Waiting for query cache lock	0.03 ms
Init	0.02 ms
Checking query cache for query	0.10 ms
Checking permissions	0.03 ms
Opening tables	0.23 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.76 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.16 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.85 ms After last query: 22.54 ms Query memory: 0.010 MB Memory before query: 4.277 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `z0dyz_categories` AS `s`

  INNER JOIN `z0dyz_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 9

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	9	Using index condition; Using where

Profile

Status	Duration
Starting	0.19 ms
Waiting for query cache lock	0.03 ms
Init	0.02 ms
Checking query cache for query	0.21 ms
Checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.09 ms
Optimizing	0.07 ms
Statistics	0.21 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.17 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.15 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.90 ms After last query: 1.33 ms Query memory: 0.009 MB Memory before query: 4.299 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM z0dyz_fields AS a

  LEFT JOIN `z0dyz_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN z0dyz_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN z0dyz_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN z0dyz_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN z0dyz_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `z0dyz_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (9,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.20 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.23 ms
Checking permissions	0.03 ms
Opening tables	0.47 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.10 ms
Optimizing	0.08 ms
Statistics	0.19 ms
Preparing	0.09 ms
Creating tmp table	0.11 ms
Sorting result	0.05 ms
Executing	0.03 ms
Sending data	1.26 ms
Creating sort index	0.10 ms
Removing tmp table	0.15 ms
Creating sort index	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.18 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.84 ms After last query: 35.82 ms Query memory: 0.011 MB Memory before query: 4.652 MB Rows returned: 18

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

  FROM z0dyz_modules AS m

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

  LEFT JOIN z0dyz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-10-02 15:47:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-10-02 15:47:24') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	35	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	lilijxne_liespa.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	lilijxne_liespa.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.21 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.18 ms
Checking permissions	0.03 ms
Opening tables	0.26 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.08 ms
Optimizing	0.09 ms
Statistics	0.14 ms
Preparing	0.12 ms
Sorting result	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
Creating sort index	0.92 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.17 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	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/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441
18	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371
17	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:87
16	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
15	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:653
14	T3Template->countModules()	JROOT/templates/lipas/tpls/blocks/off-canvas.php:43
13	include JROOT/templates/lipas/tpls/blocks/off-canvas.php	JROOT/plugins/system/t3/includes/core/template.php:200
12	T3Template->loadBlock()	JROOT/templates/lipas/tpls/blocks/header.php:62
11	include JROOT/templates/lipas/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
10	T3Template->loadBlock()	JROOT/templates/lipas/tpls/default.php:32
9	include JROOT/templates/lipas/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
8	T3Template->loadLayout()	JROOT/templates/lipas/index.php:34
7	require JROOT/templates/lipas/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.53 ms After last query: 17.69 ms Query memory: 0.008 MB Memory before query: 5.064 MB Rows returned: 80

SELECT * 
  FROM z0dyz_acymailing_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z0dyz_acymailing_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	80

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:375
13	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:776
12	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:249
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.16 ms After last query: 6.63 ms Query memory: 0.007 MB Memory before query: 5.144 MB Rows returned: 1

SELECT * 
  FROM z0dyz_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z0dyz_acymailing_list	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.20 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.07 ms
Checking permissions	0.03 ms
Opening tables	0.81 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Closing tables	0.03 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.17 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:29
12	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:117
11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:249
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.39 ms After last query: 21.59 ms Query memory: 0.009 MB Memory before query: 5.530 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM z0dyz_fields AS a

  LEFT JOIN `z0dyz_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN z0dyz_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN z0dyz_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN z0dyz_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN z0dyz_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.22 ms
Waiting for query cache lock	0.03 ms
Init	0.03 ms
Checking query cache for query	0.23 ms
Checking permissions	0.04 ms
Opening tables	0.09 ms
After opening tables	0.04 ms
System lock	0.03 ms
Table lock	0.04 ms
Init	0.10 ms
Optimizing	0.08 ms
Statistics	0.19 ms
Preparing	0.09 ms
Creating tmp table	0.11 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	1.12 ms
Creating sort index	0.10 ms
Removing tmp table	0.16 ms
Creating sort index	0.05 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.03 ms
Closing tables	0.05 ms
Starting cleanup	0.06 ms
Freeing items	0.17 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/modules/mod_jxtc_html/mod_jxtc_html.php:44
11	include JROOT/modules/mod_jxtc_html/mod_jxtc_html.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:249
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `z0dyz_assets`

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM z0dyz_content AS a 
  INNER JOIN z0dyz_categories AS c 
  on c.id = a.catid 
  LEFT JOIN z0dyz_users AS u 
  on u.id = a.created_by 
  LEFT JOIN z0dyz_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN z0dyz_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT * 
  FROM z0dyz_acymailing_list

1 × SELECT * 
  FROM z0dyz_acymailing_confi

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

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM z0dyz_fields AS a 
  LEFT JOIN `z0dyz_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN z0dyz_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN z0dyz_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN z0dyz_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN z0dyz_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `z0dyz_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `z0dyz_contentitem_tag_map` AS m  
  INNER JOIN `z0dyz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT `data` 
  FROM `z0dyz_session`

1 × SELECT `session_id` 
  FROM `z0dyz_session`

```
1 × SELECT * 
  FROM z0dyz_languages
```

1 × SELECT id, home, template, s.params 
  FROM z0dyz_template_styles as s 
  LEFT JOIN z0dyz_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 z0dyz_menu AS m 
  LEFT JOIN z0dyz_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `z0dyz_viewlevels

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM z0dyz_fields AS a 
  LEFT JOIN `z0dyz_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN z0dyz_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN z0dyz_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN z0dyz_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN z0dyz_fields_groups AS g 
  ON g.id = a.group_id

OTHER Tables:

1 × INSERT INTO `z0dyz_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6361663165306564633838333761333137633764636432663133336133363338', 1, 1664725644, 0, '', 0

1 × UPDATE `z0dyz_extensions` 
  SET `params` = '{\"mediaversion\":\"41b94cea240b5e203344328dced9cb76\"}'

1 × SHOW FULL COLUMNS 
  FROM `z0dyz_content

1 × UPDATE z0dyz_content 
  SET `hits` = (`hits` + 1)

Browse our cakes collections (Birthday cakes, celebration cakes, wedding cakes, teatime cake, etc.) to order the best cakes in abuja at affordable prices.

Main Menu

Our Cakes & Bakes

Cakes

TeaTime Cake

CupCakes

Lilies Squares (Chin Chin)

Lilies Cakes and Pastries

Opening hours:

Quick links:

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

24 Queries Logged 54.10 ms

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: