Tag: voodoo

Animal Triste

Interview

2022

Creatures of the night

Read more...

×** [Flexisystem PLG: Adding css classes to BODY: 0.000 s]

0.000 seconds (0.000); 5.08 MB (5.083) - START: FLEXIcontent component
0.092 seconds (0.092); 10.39 MB (5.303) - END: FLEXIcontent component: (VIEW: category -- LAYOUT: tags)

-- [Initialize component: 0.01 s]
-- [Query: item LISTING: 0.01 s]
-- [Query: ALPHA-index creation: 0.00 s]
-- [FC Templates: XML files parsing: 0.00 s]
-- [FC Templates: LESS files parsing: 0.00 s]
-- [FC Templates: INI files parsing: 0.00 s]
-- [FC fields values retrieval + field params creation: 0.01 s]
-- [FC "category" view Template Rendering: 0.01 s]

-- [FC Fields Rendering: 0.01 s]

0.001 smaintext

0.001 stext

0.009 simage

0.001 sradio

_{Well this site has a real tough cookie with a long history of breaking little hearts like the one in me,}_{with functionalities linked to so-called social networks and traffic statistics. Hit me with your best shot.}

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675455095,
                "last": 1675455095,
                "now": 1675455095
            },
            "token": "I0n1VnY96rDH9wM1Qat3BXUHLRRVqSJr"
        },
        "registry": {
            "com_flexicontent": {
                "min_word_len": 4
            },
            "use_limit_before_search_filt": 0,
            "filter_messages": null
        },
        "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"
        }
    },
    "__flexicontent": {
        "screenSizeCookieToBeAdded": 0,
        "screenSizeCookieTried": 1
    }
}

Profile Information

Time

Memory

Time: 15.11 ms / 15.11 ms Memory: 0.813 MB / 1.15 MB Application: afterLoad

Time: 49.93 ms / 65.04 ms Memory: 3.506 MB / 4.66 MB Application: afterInitialise

Time: 6.57 ms / 71.60 ms Memory: 0.190 MB / 4.85 MB Application: Before Access::preloadComponents (all components)

Time: 1.53 ms / 73.14 ms Memory: 0.060 MB / 4.90 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 73.17 ms Memory: -0.003 MB / 4.90 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.23 ms / 73.40 ms Memory: 0.017 MB / 4.92 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 1.80 ms / 75.20 ms Memory: 0.030 MB / 4.95 MB Application: afterRoute

Time: 40.13 ms / 115.33 ms Memory: 0.066 MB / 5.01 MB Application: beforeRenderComponent com_flexicontent

Time: 42.00 ms / 157.33 ms Memory: 2.681 MB / 7.70 MB Application: Before Access::getAssetRules (id:217 name:com_flexicontent)

Time: 0.12 ms / 157.45 ms Memory: 0.033 MB / 7.73 MB Application: After Access::getAssetRules (id:217 name:com_flexicontent)

Time: 39.60 ms / 197.05 ms Memory: 1.709 MB / 9.44 MB Application: Before Access::preloadPermissions (com_content)

Time: 2.15 ms / 199.21 ms Memory: 0.271 MB / 9.71 MB Application: After Access::preloadPermissions (com_content)

Time: 0.03 ms / 199.23 ms Memory: -0.019 MB / 9.69 MB Application: Before Access::getAssetRules (id:666 name:com_content.article.239)

Time: 0.05 ms / 199.29 ms Memory: 0.008 MB / 9.70 MB Application: After Access::getAssetRules (id:666 name:com_content.article.239)

Time: 9.29 ms / 208.58 ms Memory: 0.685 MB / 10.38 MB Application: afterRenderComponent com_flexicontent

Time: 1.92 ms / 210.50 ms Memory: 0.018 MB / 10.40 MB Application: afterDispatch

Time: 134.72 ms / 345.22 ms Memory: 0.629 MB / 11.03 MB Application: beforeRenderModule mod_languages (Sélecteur de langue)

Time: 2.53 ms / 347.75 ms Memory: 0.027 MB / 11.06 MB Application: afterRenderModule mod_languages (Sélecteur de langue)

Time: 0.07 ms / 347.82 ms Memory: -0.001 MB / 11.05 MB Application: beforeRenderModule mod_acymailing (AcyMailing Module)

Time: 5.06 ms / 352.88 ms Memory: 0.513 MB / 11.57 MB Application: afterRenderModule mod_acymailing (AcyMailing Module)

Time: 0.36 ms / 353.24 ms Memory: 0.004 MB / 11.57 MB Application: beforeRenderModule mod_custom (Lien Facebook)

Time: 0.33 ms / 353.56 ms Memory: 0.005 MB / 11.58 MB Application: afterRenderModule mod_custom (Lien Facebook)

Time: 145.87 ms / 499.43 ms Memory: 0.186 MB / 11.76 MB Application: afterRender

Database queries total: 36.89 ms

Memory Usage

Database Queries

56 Queries Logged 36.89 ms

Query Time: 0.50 ms Query memory: 0.023 MB Memory before query: 1.498 MB Rows returned: 0

SELECT `data`

  FROM `va2rq_session`

  WHERE `session_id` = X'3865656236666636616561623861383665356230626161626336323930316166'

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 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: 0.52 ms After last query: 0.41 ms Query memory: 0.020 MB Memory before query: 1.512 MB Rows returned: 0

SELECT `session_id`

  FROM `va2rq_session`

  WHERE `session_id` = X'3865656236666636616561623861383665356230626161626336323930316166' 
  LIMIT 1

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 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: 0.44 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.517 MB

INSERT INTO `va2rq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3865656236666636616561623861383665356230626161626336323930316166', 1, 1675455095, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `va2rq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865656236666636616561623861383665356230626161626336323930316166', 1, 1675455095, 0, '', 0)

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.09 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

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: 0.60 ms After last query: 1.42 ms Query memory: 0.021 MB Memory before query: 1.602 MB Rows returned: 6

SELECT id, rules

  FROM `va2rq_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.05 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: 0.57 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.615 MB Rows returned: 2

SELECT b.id

  FROM va2rq_usergroups AS a

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

  WHERE a.id = 13

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

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: 0.60 ms After last query: 10.31 ms Query memory: 0.021 MB Memory before query: 4.271 MB Rows returned: 1

SELECT lft,rgt 
  FROM va2rq_categories 
  WHERE id=1

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/defineconstants.php:100
8	require_once JROOT/administrator/components/com_flexicontent/defineconstants.php	JROOT/plugins/system/flexisystem/flexisystem.php:19
7	require_once JROOT/plugins/system/flexisystem/flexisystem.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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: 0.72 ms After last query: 8.46 ms Query memory: 0.022 MB Memory before query: 4.493 MB Rows returned: 1

SELECT `params`

  FROM `va2rq_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_jchoptimize'

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof40/Params/Params.php:55
12	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
11	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
10	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:115
9	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
8	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:124
7	plgSystemJchoptimize->__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: 0.99 ms After last query: 14.09 ms Query memory: 0.021 MB Memory before query: 4.621 MB Rows returned: 1

SELECT DISTINCT userid 
  FROM va2rq_session 
  WHERE guest=0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_session	index	NULL	userid	5	NULL	116	Using where

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.41 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/flexisystem/flexisystem.php:1382
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->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:668
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.51 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 4.627 MB Rows returned: 0

SELECT id, checked_out, checked_out_time 
  FROM va2rq_content 
  WHERE checked_out > 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_content	range	idx_checkout	idx_checkout	4	NULL	1	Using index condition

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.85 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->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:668
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: 0.62 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.632 MB Rows returned: 0

SELECT id, checked_out, checked_out_time 
  FROM va2rq_categories 
  WHERE checked_out > 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_categories	range	idx_checkout	idx_checkout	4	NULL	1	Using index condition

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->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:668
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: 0.56 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.638 MB Rows returned: 1

SELECT id, checked_out, checked_out_time 
  FROM va2rq_modules 
  WHERE checked_out > 0

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->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:668
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: 0.55 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 4.644 MB Rows returned: 0

SELECT id, checked_out, checked_out_time 
  FROM va2rq_menu 
  WHERE checked_out > 0

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:1395
9	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:206
8	plgSystemFlexisystem->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:668
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: 0.50 ms After last query: 6.07 ms Query memory: 0.022 MB Memory before query: 4.839 MB Rows returned: 0

SELECT i.id

  FROM `va2rq_flexicontent_tags` AS i

  WHERE i.`alias` = '490-voodoo'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	alias	alias	767	const	1	Using index condition

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.12 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/router.php:1067
13	_FlexicontentSiteRouter->_fc_route_getRecordIdByAlias()	JROOT/components/com_flexicontent/router.php:1158
12	_FlexicontentSiteRouter->_fc_route_addRecordIdPrefix()	JROOT/components/com_flexicontent/router.php:772
11	_FlexicontentSiteRouter->FLEXIcontentParseRoute()	JROOT/components/com_flexicontent/router.php:37
10	FLEXIcontentParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.32 ms After last query: 0.49 ms Query memory: 0.027 MB Memory before query: 4.850 MB Rows returned: 40

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

  FROM `va2rq_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_banners','com_cache','com_carouselck','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_flexicontent','com_installer','com_jchoptimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.48 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->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: 0.50 ms After last query: 0.79 ms Query memory: 0.006 MB Memory before query: 4.920 MB

UPDATE `va2rq_extensions`

  SET `params` = '{\"mediaversion\":\"60f3805eacf2d9beb84b733a0156b45f\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `va2rq_extensions` SET `params` = '{\"mediaversion\":\"60f3805eacf2d9beb84b733a0156b45f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.01 ms
init for update	0.08 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/wbamp/wbamp.php:404
8	plgSystemWbamp->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.60 ms After last query: 1.55 ms Query memory: 0.019 MB Memory before query: 5.006 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM va2rq_template_styles as s

  LEFT JOIN va2rq_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	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	lahe0874_db.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.65 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.06 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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: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.56 ms After last query: 73.22 ms Query memory: 0.025 MB Memory before query: 7.034 MB Rows returned: 1

SHOW VARIABLES LIKE '%ft_min_word_len%'

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE '%ft_min_word_len%'

Profile

Status	Duration
Starting	0.07 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	1.00 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/models/category.php:279
15	FlexicontentModelCategory->populateRecordState()	JROOT/components/com_flexicontent/models/category.php:176
14	FlexicontentModelCategory->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.80 ms After last query: 0.60 ms Query memory: 0.023 MB Memory before query: 7.067 MB Rows returned: 1

SELECT *, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM va2rq_flexicontent_tags AS t 
  WHERE t.id = 490

Explain

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

Profile

Status	Duration
Starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/models/category.php:2159
13	FlexicontentModelCategory->getTag()	JROOT/components/com_flexicontent/models/category.php:1986
12	FlexicontentModelCategory->getCategory()	JROOT/components/com_flexicontent/views/category/view.html.php:79
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.75 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.074 MB Rows returned: 1

SELECT * 
  FROM va2rq_tags AS t 
  WHERE t.id = 486

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/models/category.php:2174
13	FlexicontentModelCategory->getTag()	JROOT/components/com_flexicontent/models/category.php:1986
12	FlexicontentModelCategory->getCategory()	JROOT/components/com_flexicontent/views/category/view.html.php:79
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.62 ms After last query: 1.86 ms Query memory: 0.024 MB Memory before query: 7.730 MB Rows returned: 7

SELECT template as folder, cfgname, attribs, layout as type 
  FROM va2rq_flexicontent_layouts_conf

Explain

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

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/helpers/tmpl.php:408
15	flexicontent_tmpl::getLayoutparams()	JROOT/components/com_flexicontent/models/category.php:2725
14	FlexicontentModelCategory->getLayoutparams()	JROOT/components/com_flexicontent/models/category.php:2499
13	FlexicontentModelCategory->_loadCategoryParams()	JROOT/components/com_flexicontent/models/category.php:2061
12	FlexicontentModelCategory->getCategory()	JROOT/components/com_flexicontent/views/category/view.html.php:79
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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.03 ms After last query: 0.59 ms Query memory: 0.042 MB Memory before query: 7.730 MB Rows returned: 4

SELECT fi.* 
  FROM va2rq_flexicontent_fields AS fi 
  WHERE fi.published = 1 
  AND fi.isfilter = 1 
  AND fi.access IN (0,1,1,5)  
  ORDER BY fi.ordering, fi.name

Explain

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

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:4862
17	FlexicontentFields::getFilters()	JROOT/components/com_flexicontent/models/category.php:1366
16	FlexicontentModelCategory->_buildFiltersWhere()	JROOT/components/com_flexicontent/models/category.php:1096
15	FlexicontentModelCategory->_buildItemWhere()	JROOT/components/com_flexicontent/models/category.php:544
14	FlexicontentModelCategory->_buildQuery()	JROOT/components/com_flexicontent/models/category.php:365
13	FlexicontentModelCategory->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/category/view.html.php:130
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.18 ms After last query: 2.42 ms Query memory: 0.023 MB Memory before query: 7.742 MB Rows returned: 1

SELECT FOUND_ROWS()

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	No tables used

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.11 ms
Optimizing	0.09 ms
Statistics	0.53 ms
Preparing	0.06 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.12 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_flexicontent/models/category.php:402
13	FlexicontentModelCategory->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/category/view.html.php:130
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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.40 ms After last query: 0.10 ms Query memory: 0.086 MB Memory before query: 7.750 MB Rows returned: 1

SELECT i.*, ie.*, u.name as author, ty.name AS typename, ty.alias AS typealias, rel.catid as rel_catid, c.title AS maincat_title, c.alias AS maincat_alias, 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, c.access as category_access, ty.access as type_access, 1 AS has_access 
  FROM va2rq_content AS i  JOIN va2rq_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id  JOIN va2rq_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl 
  ON tagtbl.id = tag.tid 
  AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty 
  ON ie.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel 
  ON rel.itemid = i.id JOIN va2rq_categories AS c 
  ON c.id = i.catid 
  LEFT JOIN va2rq_users AS u 
  ON u.id = i.created_by 
  WHERE i.id IN (239) 
  GROUP BY i.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	ie	const	PRIMARY,type_id	PRIMARY	4	const	1
1	SIMPLE	ty	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	rel	ref	itemid	itemid	4	const	1
1	SIMPLE	tag	ref	PRIMARY,tid,itemid	itemid	4	const	13
1	SIMPLE	tagtbl	eq_ref	PRIMARY,published	PRIMARY	4	lahe0874_db.tag.tid	1	Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/category.php:432
13	FlexicontentModelCategory->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/category/view.html.php:130
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.64 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 7.795 MB Rows returned: 1

SELECT a.id as id, k.id as original_id 
  FROM va2rq_associations AS a JOIN va2rq_associations AS k 
  ON a.`key`=k.`key` JOIN va2rq_content AS i 
  ON i.id = k.id 
  AND i.language = 'fr-FR' 
  WHERE a.id IN (239) 
  AND a.context = "com_content.item"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	k	ref	idx_key	idx_key	128	const	2	Using index
1	SIMPLE	i	eq_ref	PRIMARY,idx_language	PRIMARY	4	lahe0874_db.k.id	1	Using where

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.27 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.09 ms
Executing	0.01 ms
Sending data	0.43 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 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/components/com_flexicontent/classes/helpers/db.php:1062
14	flexicontent_db::getOriginalContentItemids()	JROOT/components/com_flexicontent/models/category.php:442
13	FlexicontentModelCategory->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/category/view.html.php:130
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.95 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 7.801 MB Rows returned: 1

SELECT DISTINCT LOWER(SUBSTRING(i.title 
  FROM 1 FOR 1)) AS alpha 
  FROM va2rq_flexicontent_items_tmp AS i  JOIN va2rq_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl 
  ON tagtbl.id = tag.tid 
  AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel 
  ON rel.itemid = i.id JOIN va2rq_categories AS c 
  ON c.id = i.catid 
  WHERE 1 
  AND tag.tid = '490' 
  AND ( i.state IN (1, -5) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) ) 
  AND (i .language = 'en-GB' OR i.language = '*') 
  AND ty.access IN (0,1,1,5) 
  AND  c.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) 
  ORDER BY alpha ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	ref	PRIMARY,tid,itemid	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
1	SIMPLE	i	eq_ref	PRIMARY,state,catid,access,language,type_id	PRIMARY	4	lahe0874_db.tag.itemid	1	Using index condition; Using where
1	SIMPLE	ty	eq_ref	PRIMARY,access	PRIMARY	4	lahe0874_db.i.type_id	1	Using where; Distinct
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	lahe0874_db.i.catid	1	Using where; Distinct
1	SIMPLE	rel	ref	itemid	itemid	4	lahe0874_db.i.id	1	Using where; Using index; Distinct
1	SIMPLE	tagtbl	eq_ref	PRIMARY,published	PRIMARY	4	lahe0874_db.tag.tid	1	Using where; Distinct

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_flexicontent/models/category.php:2759
13	FlexicontentModelCategory->getAlphaindex()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/category/view.html.php:134
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.46 ms After last query: 3.33 ms Query memory: 0.024 MB Memory before query: 7.832 MB Rows returned: 2

SELECT DISTINCT lc.lang_id as id, lc.image as image_prefix, lc.lang_code as code, lc.title_native, lc.sef,lc.title as name

  FROM va2rq_languages as lc

  WHERE 1

  ORDER BY lc.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.27 ms
Preparing	0.05 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:125
15	FLEXIUtilities::getlanguageslist()	JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:197
14	FLEXIUtilities::getLanguages()	JROOT/components/com_flexicontent/classes/helpers/html.php:1857
13	flexicontent_html::loadFramework()	JROOT/components/com_flexicontent/classes/helpers/html.php:1881
12	flexicontent_html::loadFramework()	JROOT/components/com_flexicontent/views/category/view.html.php:177
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.42 ms After last query: 1.45 ms Query memory: 0.024 MB Memory before query: 7.852 MB Rows returned: 16

SELECT t.tid, t.itemid 
  FROM va2rq_flexicontent_tags_item_relations AS t 
  WHERE t.itemid IN (239)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	itemid	itemid	4	const	13

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 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.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1407
14	FlexicontentFields::_getTags()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:306
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.65 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 7.868 MB Rows returned: 16

SELECT DISTINCT t.id, t.name, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM va2rq_flexicontent_tags AS t JOIN va2rq_flexicontent_tags_item_relations AS i 
  ON i.tid = t.id 
  WHERE i.itemid IN (239) 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,tid,itemid	itemid	4	const	13	Using temporary
1	SIMPLE	t	eq_ref	PRIMARY,published	PRIMARY	4	lahe0874_db.i.tid	1	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1423
14	FlexicontentFields::_getTags()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:306
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.30 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 7.876 MB Rows returned: 1

SELECT c.catid, c.itemid 
  FROM va2rq_flexicontent_cats_item_relations AS c 
  WHERE c.itemid IN (239)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	itemid	itemid	4	const	1

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Executing	0.01 ms
Sending data	0.21 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1494
14	FlexicontentFields::_getCategories()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:307
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.45 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.885 MB Rows returned: 1

SELECT DISTINCT c.id, c.title, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM va2rq_categories AS c JOIN va2rq_flexicontent_cats_item_relations AS rel 
  ON rel.catid = c.id 
  WHERE rel.itemid IN (239)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rel	ref	PRIMARY,catid,itemid	itemid	4	const	1	Using temporary
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	lahe0874_db.rel.catid	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1511
14	FlexicontentFields::_getCategories()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:307
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.29 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 7.892 MB Rows returned: 0

SELECT DISTINCT itemid, 1 AS favs 
  FROM va2rq_flexicontent_favourites 
  WHERE type = 0 
  AND itemid IN ('239')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1543
14	FlexicontentFields::_getFavourites()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:308
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.26 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 7.901 MB Rows returned: 0

SELECT DISTINCT itemid, 1 AS fav 
  FROM va2rq_flexicontent_favourites 
  WHERE type = 0 
  AND itemid IN (239) 
  AND userid = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1577
14	FlexicontentFields::_getFavoured()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:309
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.36 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 7.915 MB Rows returned: 1

SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email 
  FROM va2rq_content AS i 
  LEFT JOIN va2rq_users AS u 
  ON u.id = i.created_by 
  WHERE i.id IN ('239')

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1637
14	FlexicontentFields::_getAuthors()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:310
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.35 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 7.924 MB Rows returned: 1

SELECT i.id, u.name, u.username, u.email 
  FROM va2rq_content AS i 
  LEFT JOIN va2rq_users AS u 
  ON u.id = i.modified_by 
  WHERE i.id IN ('239')

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1611
14	FlexicontentFields::_getModifiers()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:311
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.31 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 7.932 MB Rows returned: 1

SELECT id, name 
  FROM va2rq_flexicontent_types 
  WHERE id IN ('2')

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1661
14	FlexicontentFields::_getTypenames()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:312
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.32 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.940 MB Rows returned: 0

SELECT * 
  FROM va2rq_content_rating 
  WHERE content_id IN ('239')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1693
14	FlexicontentFields::_getVotes()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:313
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.30 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.947 MB Rows returned: 0

SELECT *, field_id as extra_id 
  FROM va2rq_flexicontent_items_extravote 
  WHERE content_id IN ('239')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1699
14	FlexicontentFields::_getVotes()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:313
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.91 ms After last query: 0.06 ms Query memory: 0.041 MB Memory before query: 7.955 MB Rows returned: 26

SELECT field_id, value, item_id, valueorder, suborder 
  FROM va2rq_flexicontent_fields_item_relations 
  WHERE item_id IN (239) 
  AND value > ""  
  ORDER BY item_id, field_id, valueorder, suborder

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_flexicontent_fields_item_relations	ref	item_id,value	item_id	4	const	23	Using where; Using filesort

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1284
14	FlexicontentFields::_getCustomValues()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:314
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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.64 ms After last query: 0.13 ms Query memory: 0.101 MB Memory before query: 7.989 MB Rows returned: 40

SELECT fi.*, 
  CASE WHEN fi.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_access 
  FROM va2rq_flexicontent_fields AS fi JOIN va2rq_flexicontent_fields_type_relations AS ftrel 
  ON ftrel.field_id = fi.id 
  AND ftrel.type_id = 2 
  WHERE fi.published = 1 
  GROUP BY fi.id 
  ORDER BY ftrel.ordering, fi.ordering, fi.name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ftrel	ALL	PRIMARY,field_id,type_id	NO INDEX KEY COULD BE USED	NULL	NULL	54	Using where; Using temporary; Using filesort
1	SIMPLE	fi	eq_ref	PRIMARY	PRIMARY	4	lahe0874_db.ftrel.field_id	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.44 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:355
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.44 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 8.155 MB Rows returned: 5

SELECT * 
  FROM va2rq_flexicontent_templates 
  WHERE template = 'liste-cases' 
  AND layout = 'category'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_flexicontent_templates	ref	configuration	configuration	152	const	5	Using index condition

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.70 ms
Creating sort index	0.32 ms
Removing tmp table	0.10 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/helpers/tmpl.php:506
14	flexicontent_tmpl::getFieldsByPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1146
13	FlexicontentFields::renderPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.34 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 8.172 MB Rows returned: 14

SELECT field_type 
  FROM va2rq_flexicontent_fields 
  WHERE iscore=1

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1856
16	FlexicontentFields::_getTypeToCoreFieldParams()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1766
15	FlexicontentFields::loadFieldConfig()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:785
14	FlexicontentFields::renderField()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1173
13	FlexicontentFields::renderPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.30 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 8.182 MB Rows returned: 1

SELECT t.attribs, t.name, t.alias 
  FROM va2rq_flexicontent_types AS t 
  WHERE t.id = 2

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1866
16	FlexicontentFields::_getTypeToCoreFieldParams()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1766
15	FlexicontentFields::loadFieldConfig()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:785
14	FlexicontentFields::renderField()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1173
13	FlexicontentFields::renderPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.39 ms After last query: 0.31 ms Query memory: 0.024 MB Memory before query: 8.219 MB Rows returned: 0

SELECT attribs, published 
  FROM va2rq_flexicontent_fields 
  WHERE name='text_fiche-album'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1819
15	FlexicontentFields::loadFieldConfig()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:785
14	FlexicontentFields::renderField()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1173
13	FlexicontentFields::renderPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.56 ms After last query: 8.84 ms Query memory: 0.026 MB Memory before query: 8.940 MB Rows returned: 2

SELECT a.sef AS sef,a.lang_code AS lang_code

  FROM va2rq_languages AS a

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/helpers/route.php:217
19	FlexicontentHelperRoute::_buildLanguageLookup()	JROOT/components/com_flexicontent/helpers/route.php:356
18	FlexicontentHelperRoute::getItemRoute()	JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.php:23
17	include JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.php	JROOT/plugins/flexicontent_fields/image/image.php:1867
16	plgFlexicontent_fieldsImage->onDisplayFieldValue()	JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:428
15	FLEXIUtilities::call_FC_Field_Func()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:861
14	FlexicontentFields::renderField()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1230
13	FlexicontentFields::renderPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.44 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 8.951 MB Rows returned: 2

SELECT t.attribs, t.id

  FROM va2rq_flexicontent_types AS t

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 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/components/com_flexicontent/helpers/route.php:293
19	FlexicontentHelperRoute::_getTypeParams()	JROOT/components/com_flexicontent/helpers/route.php:384
18	FlexicontentHelperRoute::getItemRoute()	JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.php:23
17	include JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.php	JROOT/plugins/flexicontent_fields/image/image.php:1867
16	plgFlexicontent_fieldsImage->onDisplayFieldValue()	JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:428
15	FLEXIUtilities::call_FC_Field_Func()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:861
14	FlexicontentFields::renderField()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1230
13	FlexicontentFields::renderPositions()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/category/view.html.php:243
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.53 ms After last query: 1.63 ms Query memory: 0.022 MB Memory before query: 9.136 MB Rows returned: 1

SELECT c.id 
  FROM va2rq_categories AS c 
  WHERE id IN (81,80) 
  AND id NOT IN (81)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	PRIMARY	PRIMARY	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_flexicontent/classes/helpers/html.php:5639
12	flexicontent_html::calculateItemMarkups()	JROOT/components/com_flexicontent/views/category/view.html.php:251
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.44 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 9.144 MB Rows returned: 6

SELECT id, title 
  FROM va2rq_viewlevels

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_viewlevels	index	NULL	idx_assetgroup_title_lookup	402	NULL	6	Using index

Profile

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.08 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/helpers/db.php:78
13	flexicontent_db::getAccessNames()	JROOT/components/com_flexicontent/classes/helpers/html.php:5652
12	flexicontent_html::calculateItemMarkups()	JROOT/components/com_flexicontent/views/category/view.html.php:251
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.40 ms After last query: 1.29 ms Query memory: 0.022 MB Memory before query: 9.244 MB Rows returned: 2

SELECT t.id, t.attribs 
  FROM va2rq_flexicontent_types AS t 
  WHERE 1

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/helpers/db.php:148
12	flexicontent_db::getTypeAttribs()	JROOT/components/com_flexicontent/views/category/view.html.php:583
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.46 ms After last query: 0.93 ms Query memory: 0.028 MB Memory before query: 9.379 MB Rows returned: 0

SELECT f.*  
  FROM va2rq_flexicontent_fields AS f  
  WHERE f.published = 1 
  AND f.field_type = "fieldgroup"

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:5593
21	FlexicontentFields::getFieldsPerGroup()	JROOT/components/com_flexicontent/tmpl_common/filters.php:25
20	include JROOT/components/com_flexicontent/tmpl_common/filters.php	JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php:14
19	include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php	JROOT/components/com_flexicontent/tmpl_common/listings_filter_form.php:16
18	include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form.php	JROOT/components/com_flexicontent/templates/liste-cases/category_items.php:88
17	include JROOT/components/com_flexicontent/templates/liste-cases/category_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_flexicontent/tmpl_common/category.php:120
15	include JROOT/components/com_flexicontent/tmpl_common/category.php	JROOT/components/com_flexicontent/templates/liste-cases/category.php:3
14	include JROOT/components/com_flexicontent/templates/liste-cases/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flexicontent/views/category/view.html.php:1175
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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.01 ms After last query: 1.75 ms Query memory: 0.071 MB Memory before query: 9.440 MB Rows returned: 287

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

  FROM `va2rq_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	va2rq_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	664	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
23	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_flexicontent/classes/helpers/html.php:3281
18	flexicontent_html::editbutton()	JROOT/components/com_flexicontent/templates/liste-cases/category_items.php:598
17	include JROOT/components/com_flexicontent/templates/liste-cases/category_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_flexicontent/tmpl_common/category.php:120
15	include JROOT/components/com_flexicontent/tmpl_common/category.php	JROOT/components/com_flexicontent/templates/liste-cases/category.php:3
14	include JROOT/components/com_flexicontent/templates/liste-cases/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flexicontent/views/category/view.html.php:1175
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.41 ms After last query: 8.43 ms Query memory: 0.027 MB Memory before query: 10.431 MB Rows returned: 0

SELECT catid  
  FROM va2rq_content 
  WHERE id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.61 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:280
21	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:217
20	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
19	FlexicontentModelItem->__construct()	JROOT/components/com_flexicontent/classes/helpers/html.php:2867
18	flexicontent_html::statebutton()	JROOT/components/com_flexicontent/templates/liste-cases/category_items.php:603
17	include JROOT/components/com_flexicontent/templates/liste-cases/category_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_flexicontent/tmpl_common/category.php:120
15	include JROOT/components/com_flexicontent/tmpl_common/category.php	JROOT/components/com_flexicontent/templates/liste-cases/category.php:3
14	include JROOT/components/com_flexicontent/templates/liste-cases/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_flexicontent/views/category/view.html.php:1175
11	FlexicontentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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: 0.70 ms After last query: 2.01 ms Query memory: 0.021 MB Memory before query: 10.400 MB Rows returned: 3

SELECT language,id

  FROM `va2rq_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	va2rq_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	373	Using where

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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: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.67 ms After last query: 1.32 ms Query memory: 0.063 MB Memory before query: 10.424 MB Rows returned: 41

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM va2rq_modules AS m

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

  LEFT JOIN va2rq_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
14	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/templatefiche/index.php:80
7	require JROOT/templates/templatefiche/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: 0.65 ms After last query: 133.30 ms Query memory: 0.023 MB Memory before query: 11.059 MB Rows returned: 0

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

  FROM `va2rq_menu` AS `c`

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

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

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

  WHERE c.id = 575

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.90 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 0.55 ms After last query: 1.77 ms Query memory: 0.035 MB Memory before query: 11.098 MB Rows returned: 132

SELECT * 
  FROM va2rq_acymailing_config

Explain

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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
15	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
13	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
12	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 0.54 ms After last query: 3.02 ms Query memory: 0.023 MB Memory before query: 11.571 MB Rows returned: 2

SELECT * 
  FROM va2rq_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	va2rq_acymailing_list	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	2	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

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/compat/joomla.php:464
12	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:104
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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.]

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

1 × SELECT `data` 
  FROM `va2rq_session`

1 × SELECT `session_id` 
  FROM `va2rq_session`

1 × SELECT id, rules 
  FROM `va2rq_viewlevels

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

1 × SELECT lft,rgt 
  FROM va2rq_categories

1 × SELECT `params` 
  FROM `va2rq_extensions`

1 × SELECT DISTINCT userid 
  FROM va2rq_session

1 × SELECT id, checked_out, checked_out_time 
  FROM va2rq_content

1 × SELECT id, checked_out, checked_out_time 
  FROM va2rq_categories

1 × SELECT id, checked_out, checked_out_time 
  FROM va2rq_modules

1 × SELECT id, checked_out, checked_out_time 
  FROM va2rq_menu

1 × SELECT i.id 
  FROM `va2rq_flexicontent_tags` AS i

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

1 × SELECT *, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM va2rq_flexicontent_tags AS t

```
1 × SELECT * 
  FROM va2rq_tags AS t
```

1 × SELECT template as folder, cfgname, attribs, layout as type 
  FROM va2rq_flexicontent_layouts_con

1 × SELECT fi.* 
  FROM va2rq_flexicontent_fields AS fi

```
1 × SELECT FOUND_ROWS(
```

1 × SELECT i.*, ie.*, u.name as author, ty.name AS typename, ty.alias AS typealias, rel.catid as rel_catid, c.title AS maincat_title, c.alias AS maincat_alias, 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, c.access as category_access, ty.access as type_access, 1 AS has_access 
  FROM va2rq_content AS i  JOIN va2rq_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id  JOIN va2rq_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl 
  ON tagtbl.id = tag.tid 
  AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty 
  ON ie.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel 
  ON rel.itemid = i.id JOIN va2rq_categories AS c 
  ON c.id = i.catid 
  LEFT JOIN va2rq_users AS u 
  ON u.id = i.created_by

1 × SELECT a.id as id, k.id as original_id 
  FROM va2rq_associations AS a JOIN va2rq_associations AS k 
  ON a.`key`=k.`key` JOIN va2rq_content AS i 
  ON i.id = k.id 
  AND i.language = 'fr-FR'

1 × SELECT DISTINCT LOWER(SUBSTRING(i.title 
  FROM 1 FOR 1)) AS alpha 
  FROM va2rq_flexicontent_items_tmp AS i  JOIN va2rq_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl 
  ON tagtbl.id = tag.tid 
  AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel 
  ON rel.itemid = i.id JOIN va2rq_categories AS c 
  ON c.id = i.catid

1 × SELECT DISTINCT lc.lang_id as id, lc.image as image_prefix, lc.lang_code as code, lc.title_native, lc.sef,lc.title as name 
  FROM va2rq_languages as lc

1 × SELECT t.tid, t.itemid 
  FROM va2rq_flexicontent_tags_item_relations AS t

1 × SELECT DISTINCT t.id, t.name, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM va2rq_flexicontent_tags AS t JOIN va2rq_flexicontent_tags_item_relations AS i 
  ON i.tid = t.id

1 × SELECT c.catid, c.itemid 
  FROM va2rq_flexicontent_cats_item_relations AS c

1 × SELECT DISTINCT c.id, c.title, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM va2rq_categories AS c JOIN va2rq_flexicontent_cats_item_relations AS rel 
  ON rel.catid = c.id

1 × SELECT DISTINCT itemid, 1 AS favs 
  FROM va2rq_flexicontent_favourites

1 × SELECT DISTINCT itemid, 1 AS fav 
  FROM va2rq_flexicontent_favourites

1 × SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email 
  FROM va2rq_content AS i 
  LEFT JOIN va2rq_users AS u 
  ON u.id = i.created_by

1 × SELECT i.id, u.name, u.username, u.email 
  FROM va2rq_content AS i 
  LEFT JOIN va2rq_users AS u 
  ON u.id = i.modified_by

1 × SELECT id, name 
  FROM va2rq_flexicontent_types

1 × SELECT * 
  FROM va2rq_content_rating

1 × SELECT *, field_id as extra_id 
  FROM va2rq_flexicontent_items_extravote

1 × SELECT field_id, value, item_id, valueorder, suborder 
  FROM va2rq_flexicontent_fields_item_relations

1 × SELECT fi.*, 
  CASE WHEN fi.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_access 
  FROM va2rq_flexicontent_fields AS fi JOIN va2rq_flexicontent_fields_type_relations AS ftrel 
  ON ftrel.field_id = fi.id 
  AND ftrel.type_id = 2

1 × SELECT * 
  FROM va2rq_flexicontent_templates

1 × SELECT field_type 
  FROM va2rq_flexicontent_fields

1 × SELECT t.attribs, t.name, t.alias 
  FROM va2rq_flexicontent_types AS t

1 × SELECT attribs, published 
  FROM va2rq_flexicontent_fields

1 × SELECT a.sef AS sef,a.lang_code AS lang_code 
  FROM va2rq_languages AS

1 × SELECT t.attribs, t.id 
  FROM va2rq_flexicontent_types AS

1 × SELECT c.id 
  FROM va2rq_categories AS c

1 × SELECT id, title 
  FROM va2rq_viewlevel

1 × SELECT t.id, t.attribs 
  FROM va2rq_flexicontent_types AS t

1 × SELECT f.*  
  FROM va2rq_flexicontent_fields AS f

1 × SELECT catid  
  FROM va2rq_content

1 × SELECT language,id 
  FROM `va2rq_menu`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM va2rq_modules AS m 
  LEFT JOIN va2rq_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN va2rq_advancedmodules as am 
  ON am.moduleid = m.id

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

1 × SELECT * 
  FROM va2rq_acymailing_confi

1 × SELECT * 
  FROM va2rq_acymailing_list

OTHER Tables:

1 × INSERT INTO `va2rq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3865656236666636616561623861383665356230626161626336323930316166', 1, 1675455095, 0, '', 0

1 × UPDATE `va2rq_extensions` 
  SET `params` = '{\"mediaversion\":\"60f3805eacf2d9beb84b733a0156b45f\"}'

1 × SHOW VARIABLES LIKE '%ft_min_word_len%