Tag: relation item

Image	Title	Description	Last updated
No image	10 - Creation relation field to link Agent and Estate	Relation and relation inverse field is a powerfull feature to create link between item. More other we have a basic template system to display any ...	Wednesday, 20 January 2021 12:45

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

0.000 seconds (0.000); 9.28 MB (9.285) - START: FLEXIcontent component
0.061 seconds (0.061); 16.88 MB (7.591) - END: FLEXIcontent component: (VIEW: tags)

-- [Initialize component: 0.01 s]
-- [Query: item LISTING: 0.01 s]
-- [FC core LESS checked re-compile: 0.01 s]
-- [FC fields values retrieval + field params creation: 0.00 s]
-- [FC "tags" view Template Rendering: 0.02 s]

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701641813,
                "last": 1701641813,
                "now": 1701641813
            },
            "token": "jlEQl0PRQINqKZquxpN9EZ6f7yrsn7tg"
        },
        "registry": {
            "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
        },
        "com_mailto": {
            "links": {
                "43eaefa01077b9d6c5abdd69be4951b90e86a7cf": {
                    "link": "https://flexidemo.com3elles.com/realestate/recherche/tag/",
                    "expiry": 1701641813
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

41 Queries Logged 31.37 ms

2 duplicate found!

2 duplicates: #39 #40

Query Time: 0.26 ms Query memory: 0.023 MB Memory before query: 4.091 MB Rows returned: 0

SELECT `data`

  FROM `bh48s_session`

  WHERE `session_id` = X'677671706673646e6b633570316e62613033706a36656a6d6c72'

Explain

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

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.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.16 ms After last query: 0.84 ms Query memory: 0.020 MB Memory before query: 4.186 MB Rows returned: 0

SELECT `session_id`

  FROM `bh48s_session`

  WHERE `session_id` = X'677671706673646e6b633570316e62613033706a36656a6d6c72' 
  LIMIT 1

Explain

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

Profile

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

INSERT INTO `bh48s_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'677671706673646e6b633570316e62613033706a36656a6d6c72', 1, 1701641813, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `bh48s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'677671706673646e6b633570316e62613033706a36656a6d6c72', 1, 1701641813, 0, '', 0)

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.04 ms
Waiting for query cache lock	0.00 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	3.12 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.20 ms After last query: 3.78 ms Query memory: 0.020 MB Memory before query: 4.757 MB Rows returned: 3

SELECT id, rules

  FROM `bh48s_viewlevels`

Explain

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

Profile

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

SELECT b.id

  FROM bh48s_usergroups AS a

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

  WHERE a.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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	1	Using where; Using index

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.23 ms After last query: 13.90 ms Query memory: 0.021 MB Memory before query: 7.325 MB Rows returned: 1

SELECT lft,rgt 
  FROM bh48s_categories 
  WHERE id=1

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:101
8	require_once JROOT/administrator/components/com_flexicontent/defineconstants.php	JROOT/plugins/system/flexisystem/flexisystem.php:36
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.50 ms After last query: 13.57 ms Query memory: 0.023 MB Memory before query: 8.745 MB Rows returned: 41

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

  FROM `bh48s_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_ffexplorer','com_fields','com_finder','com_flexicontent','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_pwtseo','com_redirect','com_search','com_tags','com_templateck','com_templates','com_users','com_weblinks','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/flexisystem/flexisystem.php:266
8	plgSystemFlexisystem->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: 12.47 ms After last query: 0.70 ms Query memory: 0.006 MB Memory before query: 8.841 MB

UPDATE `bh48s_extensions`

  SET `params` = '{\"mediaversion\":\"dd092201cc60007848ec85419819afd0\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.05 ms
Updating	0.04 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	12.24 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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/flexisystem/flexisystem.php:278
8	plgSystemFlexisystem->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.29 ms After last query: 24.97 ms Query memory: 0.022 MB Memory before query: 12.085 MB Rows returned: 1

SELECT t.name, t.id, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM bh48s_flexicontent_tags AS t 
  WHERE t.id = 46 
  AND t.published = 1

Explain

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

Profile

Status	Duration
Starting	0.05 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.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/models/tags.php:696
12	FlexicontentModelTags->getTag()	JROOT/components/com_flexicontent/views/tags/view.html.php:56
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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: 3.03 ms After last query: 1.55 ms Query memory: 2.500 MB Memory before query: 12.310 MB Rows returned: 1

SELECT i.id, i.*, ie.* , c.access as category_access, ty.access as type_access, 1 AS has_access, 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 
  FROM bh48s_content AS i JOIN bh48s_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id JOIN bh48s_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN bh48s_flexicontent_types AS ty 
  ON ie.type_id = ty.id JOIN bh48s_categories AS c 
  ON c.id = i.catid 
  WHERE tag.tid = 46 
  AND ( i.state IN (1, -5) ) 
  AND ( ( i.publish_up is NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) ) 
  AND ( ( i.publish_down is NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) ) 
  AND ty.access IN (0,1,1) 
  AND  c.access IN (0,1,1) 
  AND  i.access IN (0,1,1) 
  GROUP BY i.id 
  ORDER BY i.created DESC, i.title ASC 
  LIMIT 0, 30

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,idx_access,idx_state,idx_catid	PRIMARY	4	com3web5_flexirealestatedemo.tag.itemid	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	com3web5_flexirealestatedemo.i.catid	1	Using where
1	SIMPLE	ie	eq_ref	PRIMARY,type_id	PRIMARY	4	com3web5_flexirealestatedemo.tag.itemid	1	Using index condition
1	SIMPLE	ty	eq_ref	PRIMARY,access	PRIMARY	4	com3web5_flexirealestatedemo.ie.type_id	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.08 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.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	1.16 ms
Creating sort index	1.06 ms
Removing tmp table	0.25 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_flexicontent/models/tags.php:238
13	FlexicontentModelTags->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/tags/view.html.php:74
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.25 ms After last query: 0.56 ms Query memory: 0.023 MB Memory before query: 13.561 MB Rows returned: 0

SELECT a.id as id, k.id as original_id 
  FROM bh48s_associations AS a JOIN bh48s_associations AS k 
  ON a.`key`=k.`key` JOIN bh48s_content AS i 
  ON i.id = k.id 
  AND i.language = 'en-GB' 
  WHERE a.id IN (87) 
  AND a.context = "com_content.item"

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.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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/helpers/db.php:1161
14	flexicontent_db::getOriginalContentItemids()	JROOT/components/com_flexicontent/models/tags.php:241
13	FlexicontentModelTags->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/tags/view.html.php:74
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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: 2.52 ms After last query: 0.08 ms Query memory: 2.499 MB Memory before query: 13.569 MB Rows returned: 1

SELECT i.id, i.*, ie.* , c.access as category_access, ty.access as type_access, 1 AS has_access, 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 
  FROM bh48s_content AS i JOIN bh48s_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id JOIN bh48s_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN bh48s_flexicontent_types AS ty 
  ON ie.type_id = ty.id JOIN bh48s_categories AS c 
  ON c.id = i.catid 
  WHERE tag.tid = 46 
  AND ( i.state IN (1, -5) ) 
  AND ( ( i.publish_up is NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) ) 
  AND ( ( i.publish_down is NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) ) 
  AND ty.access IN (0,1,1) 
  AND  c.access IN (0,1,1) 
  AND  i.access IN (0,1,1) 
  GROUP BY i.id 
  ORDER BY i.created DESC, i.title 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,idx_access,idx_state,idx_catid	PRIMARY	4	com3web5_flexirealestatedemo.tag.itemid	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	com3web5_flexirealestatedemo.i.catid	1	Using where
1	SIMPLE	ie	eq_ref	PRIMARY,type_id	PRIMARY	4	com3web5_flexirealestatedemo.tag.itemid	1	Using index condition
1	SIMPLE	ty	eq_ref	PRIMARY,access	PRIMARY	4	com3web5_flexirealestatedemo.ie.type_id	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_flexicontent/models/tags.php:270
13	FlexicontentModelTags->getTotal()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/tags/view.html.php:75
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.28 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 13.576 MB Rows returned: 4

SELECT t.tid, t.itemid 
  FROM bh48s_flexicontent_tags_item_relations AS t 
  WHERE t.itemid IN (87)

Explain

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

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.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1498
14	FlexicontentFields::_getTags()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:353
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.52 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.586 MB Rows returned: 4

SELECT DISTINCT t.id AS _id, t.name, jt.id, jt.title, jt.description,  
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM bh48s_flexicontent_tags AS t JOIN bh48s_flexicontent_tags_item_relations AS i 
  ON i.tid = t.id 
  LEFT JOIN bh48s_tags AS jt 
  ON jt.id = t.jtag_id 
  WHERE i.itemid IN (87) 
  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	4	Using temporary
1	SIMPLE	t	eq_ref	PRIMARY,published	PRIMARY	4	com3web5_flexirealestatedemo.i.tid	1	Using where
1	SIMPLE	jt	eq_ref	PRIMARY	PRIMARY	4	com3web5_flexirealestatedemo.t.jtag_id	1	Using where

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.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.18 ms
Removing tmp table	0.05 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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:1515
14	FlexicontentFields::_getTags()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:353
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.17 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.594 MB Rows returned: 1

SELECT c.catid, c.itemid 
  FROM bh48s_flexicontent_cats_item_relations AS c 
  WHERE c.itemid IN (87)

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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1596
14	FlexicontentFields::_getCategories()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:354
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.27 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.603 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 bh48s_categories AS c JOIN bh48s_flexicontent_cats_item_relations AS rel 
  ON rel.catid = c.id 
  WHERE rel.itemid IN (87)

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	com3web5_flexirealestatedemo.rel.catid	1

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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:1613
14	FlexicontentFields::_getCategories()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:354
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.20 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 13.612 MB Rows returned: 0

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bh48s_flexicontent_favourites	ref	itemid	itemid	4	const	1	Using where; Using temporary

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.01 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1647
14	FlexicontentFields::_getFavourites()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:355
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.20 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 13.633 MB Rows returned: 0

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bh48s_flexicontent_favourites	ref\|filter	itemid,userid	itemid\|userid	4\|4	const	1 (11%)	Using where; Using rowid filter

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1681
14	FlexicontentFields::_getFavoured()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:356
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.23 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.641 MB Rows returned: 1

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

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.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1741
14	FlexicontentFields::_getAuthors()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:357
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.20 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.649 MB Rows returned: 1

SELECT i.id, u.name, u.username, u.email 
  FROM bh48s_content AS i 
  LEFT JOIN bh48s_users AS u 
  ON u.id = i.modified_by 
  WHERE i.id IN ('87')

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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1715
14	FlexicontentFields::_getModifiers()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:358
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.16 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.657 MB Rows returned: 1

SELECT id, name 
  FROM bh48s_flexicontent_types 
  WHERE id IN ('7')

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1765
14	FlexicontentFields::_getTypenames()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:359
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.14 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.665 MB Rows returned: 0

SELECT * 
  FROM bh48s_content_rating 
  WHERE content_id IN ('87')

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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1797
14	FlexicontentFields::_getVotes()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:360
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.12 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 13.672 MB Rows returned: 0

SELECT *, field_id as extra_id 
  FROM bh48s_flexicontent_items_extravote 
  WHERE content_id IN ('87')

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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1803
14	FlexicontentFields::_getVotes()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:360
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.23 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.680 MB Rows returned: 1

SELECT field_id, value, item_id, valueorder, suborder 
  FROM bh48s_flexicontent_fields_item_relations 
  WHERE item_id IN (87) 
  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	bh48s_flexicontent_fields_item_relations	ref	item_id,value	item_id	4	const	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.02 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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:1367
14	FlexicontentFields::_getCustomValues()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:361
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.83 ms After last query: 0.02 ms Query memory: 0.039 MB Memory before query: 13.688 MB Rows returned: 43

SELECT fi.*, 
  CASE WHEN fi.access IN (0,1,1) THEN 1 ELSE 0 END AS has_access 
  FROM bh48s_flexicontent_fields AS fi JOIN bh48s_flexicontent_fields_type_relations AS ftrel 
  ON ftrel.field_id = fi.id 
  AND ftrel.type_id = 7 
  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	262	Using where; Using temporary; Using filesort
1	SIMPLE	fi	eq_ref	PRIMARY	PRIMARY	4	com3web5_flexirealestatedemo.ftrel.field_id	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.34 ms
Creating sort index	0.16 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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/classes/flexicontent.fields.php:402
13	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
12	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/tags/view.html.php:83
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.19 ms After last query: 0.74 ms Query memory: 0.023 MB Memory before query: 15.058 MB Rows returned: 3

SELECT id, title 
  FROM bh48s_viewlevels

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:177
13	flexicontent_db::getAccessNames()	JROOT/components/com_flexicontent/classes/helpers/html.php:5833
12	flexicontent_html::calculateItemMarkups()	JROOT/components/com_flexicontent/views/tags/view.html.php:90
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.21 ms After last query: 3.90 ms Query memory: 0.024 MB Memory before query: 16.215 MB Rows returned: 3

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 bh48s_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	3	Using filesort

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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:1886
13	flexicontent_html::loadFramework()	JROOT/components/com_flexicontent/classes/helpers/html.php:1910
12	flexicontent_html::loadFramework()	JROOT/components/com_flexicontent/views/tags/view.html.php:98
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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: 3.51 ms Query memory: 0.026 MB Memory before query: 16.525 MB Rows returned: 0

SELECT f.*  
  FROM bh48s_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	96	Using where

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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:5831
17	FlexicontentFields::getFieldsPerGroup()	JROOT/components/com_flexicontent/tmpl_common/filters.php:26
16	include JROOT/components/com_flexicontent/tmpl_common/filters.php	JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php:16
15	include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php	JROOT/components/com_flexicontent/views/tags/tmpl/default.php:141
14	include JROOT/components/com_flexicontent/views/tags/tmpl/default.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/tags/view.html.php:334
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.21 ms After last query: 7.45 ms Query memory: 0.072 MB Memory before query: 16.558 MB Rows returned: 5

SELECT t.attribs, t.id

  FROM bh48s_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	5

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/helpers/route.php:308
16	FlexicontentHelperRoute::_getTypeParams()	JROOT/components/com_flexicontent/helpers/route.php:408
15	FlexicontentHelperRoute::getItemRoute()	JROOT/components/com_flexicontent/views/tags/tmpl/default.php:216
14	include JROOT/components/com_flexicontent/views/tags/tmpl/default.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/tags/view.html.php:334
11	FlexicontentViewTags->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:263
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:270
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.49 ms After last query: 12.05 ms Query memory: 0.024 MB Memory before query: 17.166 MB Rows returned: 138

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/mobilemenuck/helpers/helper.php:186
9	Mobilemenuck\Helper::searchTable()	JROOT/plugins/system/mobilemenuck/helpers/helper.php:174
8	Mobilemenuck\Helper::checkIsProVersion()	JROOT/plugins/system/mobilemenuck/mobilemenuck.php:620
7	PlgSystemMobilemenuck->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.28 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 17.177 MB Rows returned: 0

SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`

  FROM `bh48s_plg_pwtseo` AS `pwtseo`

  WHERE `pwtseo`.`context_id` = '46' 
  AND `pwtseo`.`context` = 'com_flexicontent.tags'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/pwtseo/pwtseo.php:665
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:869
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.50 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 17.187 MB Rows returned: 0

SELECT 'com_flexicontent.tags' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
  values` AS `
  values`

  FROM `bh48s_plg_pwtseo_datalayers` AS `layers`
RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map` 
  ON `map`.`datalayer_id` = `layers`.`id`

  WHERE `map`.`context_id` = '46' 
  AND `map`.`context` = 'com_flexicontent.tags' 
  AND `layers`.`published` = 1

  ORDER BY `layers`.`ordering` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	context_id,pwtseo_datalayers_map_datalayer_fk	context_id	4	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	layers	eq_ref	PRIMARY	PRIMARY	4	com3web5_flexirealestatedemo.map.datalayer_id	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.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/pwtseo/pwtseo.php:745
10	PlgSystemPWTSEO->getDataLayers()	JROOT/plugins/system/pwtseo/pwtseo.php:678
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:869
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.19 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 17.193 MB Rows returned: 1

SELECT `cascade_settings`

  FROM `bh48s_plg_pwtseo`

  WHERE `context` = 'com_menus.item' 
  AND `context_id` = 167

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/pwtseo/pwtseo.php:2654
9	PlgSystemPWTSEO->shouldSettingsCascade()	JROOT/plugins/system/pwtseo/pwtseo.php:902
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.21 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 17.203 MB Rows returned: 0

SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`

  FROM `bh48s_plg_pwtseo` AS `pwtseo`

  WHERE `pwtseo`.`url` = '/realestate/recherche/tag/46-relation-item.html' 
  AND `pwtseo`.`context` = 'com_menus.item'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/pwtseo/pwtseo.php:665
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:939
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.39 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.213 MB Rows returned: 0

SELECT 'com_menus.item' AS context,'/realestate/recherche/tag/46-relation-item.html' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
  values` AS `
  values`

  FROM `bh48s_plg_pwtseo_datalayers` AS `layers`
RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map` 
  ON `map`.`datalayer_id` = `layers`.`id`

  WHERE `map`.`context_id` = '/realestate/recherche/tag/46-relation-item.html' 
  AND `map`.`context` = 'com_menus.item' 
  AND `layers`.`published` = 1

  ORDER BY `layers`.`ordering` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	context_id,pwtseo_datalayers_map_datalayer_fk	context_id	4	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	layers	eq_ref	PRIMARY	PRIMARY	4	com3web5_flexirealestatedemo.map.datalayer_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/pwtseo/pwtseo.php:745
10	PlgSystemPWTSEO->getDataLayers()	JROOT/plugins/system/pwtseo/pwtseo.php:678
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:939
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.23 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.215 MB Rows returned: 0

SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`

  FROM `bh48s_plg_pwtseo` AS `pwtseo`

  WHERE `pwtseo`.`url` = '/realestate/recherche/tag/46-relation-item.html' 
  AND `pwtseo`.`context` = 'com_pwtseo.custom'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/pwtseo/pwtseo.php:665
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:943
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.24 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 17.222 MB Rows returned: 0

SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`,`item`.`language`

  FROM `bh48s_plg_pwtseo` AS `pwtseo`

  LEFT JOIN `bh48s_content` AS `item` 
  ON `item`.`id` = 46

  WHERE `pwtseo`.`context_id` = '46' 
  AND `pwtseo`.`context` = 'com_content.article'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pwtseo	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	item	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/pwtseo/pwtseo.php:665
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:946
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.38 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.232 MB Rows returned: 0

SELECT 'com_content.article' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
  values` AS `
  values`

  FROM `bh48s_plg_pwtseo_datalayers` AS `layers`
RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map` 
  ON `map`.`datalayer_id` = `layers`.`id`

  WHERE `map`.`context_id` = '46' 
  AND `map`.`context` = 'com_content.article' 
  AND `layers`.`published` = 1

  ORDER BY `layers`.`ordering` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	map	ref	context_id,pwtseo_datalayers_map_datalayer_fk	context_id	4	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	layers	eq_ref	PRIMARY	PRIMARY	4	com3web5_flexirealestatedemo.map.datalayer_id	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/pwtseo/pwtseo.php:745
10	PlgSystemPWTSEO->getDataLayers()	JROOT/plugins/system/pwtseo/pwtseo.php:678
9	PlgSystemPWTSEO->getSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:946
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.20 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.230 MB Rows returned: 0

Duplicate queries: #40

SELECT `layers`.`id`,`layers`.`title`,`layers`.`name`,`layers`.`fields`,`layers`.`language`,`layers`.`template`

  FROM `bh48s_plg_pwtseo_datalayers` AS `layers`

  WHERE `published` = 1 
  AND `language` = '*'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/pwtseo/pwtseo.php:811
9	PlgSystemPWTSEO->getDefaultDataLayers()	JROOT/plugins/system/pwtseo/pwtseo.php:954
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.16 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 17.236 MB Rows returned: 0

Duplicate queries: #39

SELECT `layers`.`id`,`layers`.`title`,`layers`.`name`,`layers`.`fields`,`layers`.`language`,`layers`.`template`

  FROM `bh48s_plg_pwtseo_datalayers` AS `layers`

  WHERE `published` = 1 
  AND `language` = '*'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/pwtseo/pwtseo.php:811
9	PlgSystemPWTSEO->getDefaultDataLayers()	JROOT/plugins/system/pwtseo/pwtseo.php:962
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.19 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 17.241 MB Rows returned: 1

SELECT `id`

  FROM `bh48s_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bh48s_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id_home	1	const	2	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/pwtseo/pwtseo.php:990
8	PlgSystemPWTSEO->getCurrentSEOData()	JROOT/plugins/system/pwtseo/pwtseo.php:1304
7	PlgSystemPWTSEO->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
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.]

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical` 
  FROM `bh48s_plg_pwtseo` AS `pwtseo`

2 × SELECT i.id, i.*, ie.* , c.access as category_access, ty.access as type_access, 1 AS has_access, 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 
  FROM bh48s_content AS i JOIN bh48s_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id JOIN bh48s_flexicontent_tags_item_relations AS tag 
  ON tag.itemid = i.id JOIN bh48s_flexicontent_types AS ty 
  ON ie.type_id = ty.id JOIN bh48s_categories AS c 
  ON c.id = i.catid

2 × SELECT `layers`.`id`,`layers`.`title`,`layers`.`name`,`layers`.`fields`,`layers`.`language`,`layers`.`template` 
  FROM `bh48s_plg_pwtseo_datalayers` AS `layers`

1 × SELECT `data` 
  FROM `bh48s_session`

1 × SELECT `session_id` 
  FROM `bh48s_session`

1 × SELECT id, rules 
  FROM `bh48s_viewlevels

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

1 × SELECT lft,rgt 
  FROM bh48s_categories

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `bh48s_assets`

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

1 × SELECT a.id as id, k.id as original_id 
  FROM bh48s_associations AS a JOIN bh48s_associations AS k 
  ON a.`key`=k.`key` JOIN bh48s_content AS i 
  ON i.id = k.id 
  AND i.language = 'en-GB'

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

1 × SELECT DISTINCT t.id AS _id, t.name, jt.id, jt.title, jt.description,  
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM bh48s_flexicontent_tags AS t JOIN bh48s_flexicontent_tags_item_relations AS i 
  ON i.tid = t.id 
  LEFT JOIN bh48s_tags AS jt 
  ON jt.id = t.jtag_id

1 × SELECT c.catid, c.itemid 
  FROM bh48s_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 bh48s_categories AS c JOIN bh48s_flexicontent_cats_item_relations AS rel 
  ON rel.catid = c.id

1 × SELECT DISTINCT itemid, 1 AS favs 
  FROM bh48s_flexicontent_favourites

1 × SELECT DISTINCT itemid, 1 AS fav 
  FROM bh48s_flexicontent_favourites

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

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

1 × SELECT id, name 
  FROM bh48s_flexicontent_types

1 × SELECT * 
  FROM bh48s_content_rating

1 × SELECT *, field_id as extra_id 
  FROM bh48s_flexicontent_items_extravote

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

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

1 × SELECT id, title 
  FROM bh48s_viewlevel

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 bh48s_languages as lc

1 × SELECT f.*  
  FROM bh48s_flexicontent_fields AS f

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

1 × SELECT 'com_flexicontent.tags' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
  values` AS `
  values` 
  FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map` 
  ON `map`.`datalayer_id` = `layers`.`id`

1 × SELECT `cascade_settings` 
  FROM `bh48s_plg_pwtseo`

1 × SELECT 'com_menus.item' AS context,'/realestate/recherche/tag/46-relation-item.html' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
  values` AS `
  values` 
  FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map` 
  ON `map`.`datalayer_id` = `layers`.`id`

1 × SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`,`item`.`language` 
  FROM `bh48s_plg_pwtseo` AS `pwtseo` 
  LEFT JOIN `bh48s_content` AS `item` 
  ON `item`.`id` = 46

1 × SELECT 'com_content.article' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
  values` AS `
  values` 
  FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map` 
  ON `map`.`datalayer_id` = `layers`.`id`

1 × SELECT `id` 
  FROM `bh48s_template_styles`

OTHER Tables:

1 × INSERT INTO `bh48s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'677671706673646e6b633570316e62613033706a36656a6d6c72', 1, 1701641813, 0, '', 0

1 × UPDATE `bh48s_extensions` 
  SET `params` = '{\"mediaversion\":\"dd092201cc60007848ec85419819afd0\"}'

```
1 × SHOW TABLE
```

Tag: relation item

Login

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

41 Queries Logged 31.37 ms

2 duplicate found!

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: