Message

Parsing new templates: blog, default, presentation

Oscar Bourne

Last modified

Friday, 01 December 2023

I'm an agent! I sell stuff! This is my bio, where I tell you all about my collection of comic books and my three dogs. I could also mention my license, education or anything else I think will make you like me! It's not required though, so if you're not a talkative type, leave this blank.

Estate in relation

Appartement austria

2,850,000.00 €

Appartement lille

860,000.00 €

Appartement poland

2,600,000.00 €

Appartement taipai

2,604,000.00 €

Garden House californie

4,544,545.00 €

Garden House newark

520,000.00 €

Garden House Paris

1,200,000.00 € | 545,555.00 €

Alice Brian

Skills

Studio
Appartement

Melissa William

Skills

Studio
Exclusive house

Nathan James

Skills

Appartement
Exclusive house

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

0.000 seconds (0.000); 9.27 MB (9.268) - START: FLEXIcontent component
0.133 seconds (0.133); 22.24 MB (12.976) - END: FLEXIcontent component: (VIEW: item)

-- [Initialize component: 0.01 s]
-- [FC Templates: XML files parsing: 0.00 s]
-- [FC Templates: LESS files parsing: 0.00 s]
-- [FC Templates: INI files parsing: 0.00 s]
-- [FC core LESS checked re-compile: 0.01 s]
-- [Joomla Content Plugins: 0.01 s]
-- [Get/Calculate Item Properties: 0.02 s]
-- [FC fields values retrieval + field params creation: 0.01 s]
-- [FC "item" view Template Rendering: 0.00 s]

-- [FC Fields Rendering: 0.05 s]

0.003 stitle

0.000 smaintext

0.000 screated

0.000 screatedby

0.000 smodified

0.000 smodifiedby

0.000 shits

0.000 stype

0.000 sversion

0.000 sstate

0.002 svoting

0.002 sfavourites

0.000 scategories

0.000 stags

0.004 semail

0.010 simage

0.002 stext

0.010 srelation_reverse - Field rendered other fields. Time was (retrieval+render)= 0.017 s

0.003 scheckbox

0.001 sphonenumbers

0.011 sfcpagenav

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701641768,
                "last": 1701641768,
                "now": 1701641768
            },
            "token": "wQL6FEXv6aN4N9Nf5LpIJGOLcUOfqUVo"
        },
        "registry": {
            "com_flexicontent": {
                "min_word_len": 1,
                "23": {
                    "nav_orderby": {
                        "1": "hits",
                        "2": "alpha"
                    }
                },
                "23nav_item_count": 4,
                "23nav_loc_to_ids": {
                    "0": "103",
                    "1": "101",
                    "2": "63",
                    "3": "102",
                    "-1": -103,
                    "-2": -102
                }
            },
            "use_limit_before_search_filt": 0
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "72e1c1a85e305e992251d667a26a15005b86f7ab": {
                    "link": "https://flexidemo.com3elles.com/realestate/agents/item/63-oscar-bourne.html",
                    "expiry": 1701641768
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

121 Queries Logged 42.77 ms

11 duplicate found!

4 duplicates: #10 #14 #105 #106

3 duplicates: #37 #38 #87

2 duplicates: #47 #101

2 duplicates: #116 #117

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

SELECT `data`

  FROM `bh48s_session`

  WHERE `session_id` = X'73666e693236636f6363696431636d706b6f3971676538713931'

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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.17 ms After last query: 0.96 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'73666e693236636f6363696431636d706b6f3971676538713931' 
  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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.85 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'73666e693236636f6363696431636d706b6f3971676538713931', 1, 1701641768, 0, '', 0)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

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.23 ms After last query: 4.03 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.27 ms After last query: 0.09 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.27 ms After last query: 15.11 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.59 ms After last query: 14.55 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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: 3.01 ms After last query: 0.86 ms Query memory: 0.006 MB Memory before query: 8.841 MB

UPDATE `bh48s_extensions`

  SET `params` = '{\"mediaversion\":\"885a59c8d7edd0dc8fcdc04c905c0ad7\"}'

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

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.35 ms After last query: 37.04 ms Query memory: 0.025 MB Memory before query: 14.035 MB Rows returned: 1

SELECT catid  
  FROM bh48s_flexicontent_cats_item_relations  
  WHERE itemid = 63

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:265
17	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/base/base.php:198
16	FCModelAdmin->__construct()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
15	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
14	FlexicontentModelItem->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php: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.025 MB Memory before query: 14.045 MB Rows returned: 1

Duplicate queries: #14 #105 #106

SELECT catid  
  FROM bh48s_content 
  WHERE id = 63

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:280
17	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/base/base.php:198
16	FCModelAdmin->__construct()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
15	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
14	FlexicontentModelItem->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php: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.18 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 14.055 MB Rows returned: 5

SELECT id, name 
  FROM bh48s_flexicontent_types

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4358
18	ParentClassItem->getItemType()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:295
17	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/base/base.php:198
16	FCModelAdmin->__construct()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
15	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
14	FlexicontentModelItem->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php: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.025 MB Memory before query: 14.067 MB Rows returned: 1

SELECT ie.type_id 
  FROM bh48s_flexicontent_items_ext as ie JOIN bh48s_flexicontent_types as t 
  ON ie.type_id=t.id 
  WHERE ie.item_id = 63

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ie	const	PRIMARY,type_id	PRIMARY	4	const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4381
18	ParentClassItem->getItemType()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:295
17	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/base/base.php:198
16	FCModelAdmin->__construct()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
15	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
14	FlexicontentModelItem->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php: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: 1.33 ms Query memory: 0.026 MB Memory before query: 14.348 MB Rows returned: 1

SELECT t.id, t.attribs 
  FROM bh48s_flexicontent_types AS t 
  WHERE 1 
  AND t.id = 6

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/helpers/db.php:222
20	flexicontent_db::getTypeAttribs()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4453
19	ParentClassItem->getTypeparams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:328
18	ParentClassItem->getComponentTypeParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:299
17	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/base/base.php:198
16	FCModelAdmin->__construct()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
15	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
14	FlexicontentModelItem->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php: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.19 ms Query memory: 0.024 MB Memory before query: 14.368 MB Rows returned: 1

Duplicate queries: #10 #105 #106

SELECT catid  
  FROM bh48s_content 
  WHERE id = 63

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:280
16	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:217
15	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
14	FlexicontentModelItem->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php: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.52 ms Query memory: 0.024 MB Memory before query: 14.412 MB Rows returned: 1

SELECT i.id, i.version 
  FROM bh48s_content as i JOIN bh48s_categories AS c 
  ON i.catid=c.id 
  WHERE c.extension='com_content' 
  AND i.id=63

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:274
15	FLEXIUtilities::getCurrentVersions()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:545
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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: 0.04 ms Query memory: 0.024 MB Memory before query: 14.422 MB Rows returned: 1

SELECT item_id as id, max(version_id) as version 
  FROM bh48s_flexicontent_versions 
  WHERE 1 
  AND item_id=63 
  GROUP BY item_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bh48s_flexicontent_versions	ref	version2item	version2item	4	const	3	Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:233
15	FLEXIUtilities::getLastVersions()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:546
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.07 ms Query memory: 0.025 MB Memory before query: 14.435 MB Rows returned: 1

SELECT * 
  FROM bh48s_flexicontent_fields 
  WHERE field_type="voting"

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4287
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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: 1.11 ms Query memory: 0.026 MB Memory before query: 14.662 MB Rows returned: 9

SHOW FULL COLUMNS 
  FROM `bh48s_flexicontent_items_ext`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:305
19	flexicontent_items->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:257
17	flexicontent_items->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4288
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.42 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 14.681 MB Rows returned: 19

SHOW FULL COLUMNS 
  FROM `bh48s_flexicontent_items_tmp`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:305
19	flexicontent_items->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:257
17	flexicontent_items->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4288
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.44 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 14.709 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `bh48s_content`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:312
19	flexicontent_items->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:257
17	flexicontent_items->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4288
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.29 ms After last query: 0.38 ms Query memory: 0.024 MB Memory before query: 14.770 MB Rows returned: 1

SELECT e.*, a.*

  FROM bh48s_content AS a

  LEFT JOIN bh48s_flexicontent_items_ext AS e 
  ON a.id = e.item_id

  WHERE `a`.`id` = '63'

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	e	const	PRIMARY	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:546
16	flexicontent_items->load()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4289
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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: 0.06 ms Query memory: 0.025 MB Memory before query: 14.777 MB Rows returned: 14

SELECT field_type 
  FROM bh48s_flexicontent_fields 
  WHERE iscore=1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
18	JDatabaseDriver->loadColumn()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1960
17	FlexicontentFields::_getTypeToCoreFieldParams()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1870
16	FlexicontentFields::loadFieldConfig()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4290
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.02 ms Query memory: 0.025 MB Memory before query: 14.787 MB Rows returned: 1

SELECT t.attribs, t.name, t.alias 
  FROM bh48s_flexicontent_types AS t 
  WHERE t.id = 6

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1970
17	FlexicontentFields::_getTypeToCoreFieldParams()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1870
16	FlexicontentFields::loadFieldConfig()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4290
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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: 0.55 ms Query memory: 0.024 MB Memory before query: 14.862 MB Rows returned: 0

SELECT attribs, published 
  FROM bh48s_flexicontent_fields 
  WHERE name='voting_agent'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bh48s_flexicontent_fields	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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1923
16	FlexicontentFields::loadFieldConfig()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4290
15	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:673
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.40 ms Query memory: 0.039 MB Memory before query: 14.902 MB Rows returned: 1

SELECT i.*, ie.*,mc.access as category_access, ty.access as type_access, 
  CASE WHEN ty.access IN (0,1,1) THEN 1 ELSE 0 END AS has_type_access, 
  CASE WHEN mc.access IN (0,1,1) THEN 1 ELSE 0 END AS has_mcat_access, 
  CASE WHEN  i.access IN (0,1,1) THEN 1 ELSE 0 END AS has_item_access,c.id AS catid, i.catid as maincatid,c.title AS category_title, c.alias AS category_alias, c.lft,c.rgt, mc.title AS maincat_title, mc.alias AS maincat_alias,ty.name AS typename, ty.alias as typealias,ua.name AS author,v.rating_count as rating_count, ROUND( v.rating_sum / v.rating_count ) AS rating, ((v.rating_sum / v.rating_count)*20) as score,
  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,
  CASE WHEN i.publish_up is NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-12-03 22:16:08' THEN 0 ELSE 1 END as publication_scheduled,
  CASE WHEN i.publish_down is NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-12-03 22:16:08' THEN 0 ELSE 1 END as publication_expired

  FROM bh48s_content AS i

  LEFT JOIN bh48s_flexicontent_items_ext AS ie 
  ON ie.item_id = i.id

  LEFT JOIN bh48s_flexicontent_types AS ty 
  ON (
  CASE WHEN ie.type_id = 0 THEN 6 ELSE ie.type_id END) = ty.id

  LEFT JOIN bh48s_users AS ua 
  on ua.id = i.created_by

  LEFT JOIN bh48s_content_rating AS v 
  ON i.id = v.content_id

  LEFT JOIN bh48s_flexicontent_cats_item_relations AS rel 
  ON rel.itemid = i.id 
  AND rel.catid = 23

  LEFT JOIN bh48s_categories AS c 
  on c.id = rel.catid

  LEFT JOIN bh48s_categories AS mc 
  on mc.id = i.catid

  WHERE i.id = 63

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	ie	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ty	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	SIMPLE	rel	const	PRIMARY,catid,itemid	PRIMARY	8	const,const	1	Using index
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	mc	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 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.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:749
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.04 ms Query memory: 0.024 MB Memory before query: 14.917 MB Rows returned: 0

SELECT *

  FROM bh48s_content_rating

  WHERE content_id IN (63)

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.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.01 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4233
15	ParentClassItem->getVotes()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:781
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.03 ms Query memory: 0.024 MB Memory before query: 14.926 MB Rows returned: 0

SELECT *, field_id as extra_id

  FROM bh48s_flexicontent_items_extravote

  WHERE content_id IN (63)

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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4240
15	ParentClassItem->getVotes()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:781
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.36 ms Query memory: 0.023 MB Memory before query: 14.960 MB Rows returned: 0

SELECT DISTINCT tid

  FROM bh48s_flexicontent_tags_item_relations

  WHERE itemid = 63

Explain

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

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.02 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Removing tmp table	0.01 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:1550
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1001
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.03 ms Query memory: 0.023 MB Memory before query: 14.967 MB Rows returned: 1

SELECT DISTINCT catid

  FROM bh48s_flexicontent_cats_item_relations

  WHERE itemid = 63

Explain

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

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.01 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.02 ms
Removing tmp table	0.01 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:1550
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1034
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.024 MB Memory before query: 14.977 MB Rows returned: 1

SELECT title 
  FROM bh48s_viewlevels 
  WHERE id = 1

Explain

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

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.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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:5969
15	ParentClassItem->_afterLoad()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1072
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.15 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 14.986 MB Rows returned: 0

SELECT  v.rating_count as rating_count, ROUND( v.rating_sum / v.rating_count ) AS rating, ((v.rating_sum / v.rating_count)*20) as score 
  FROM bh48s_content_rating AS v 
  WHERE v.content_id = 63

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.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.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.01 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:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:6042
15	ParentClassItem->_afterLoad()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1072
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.024 MB Memory before query: 14.994 MB Rows returned: 1

SELECT name, email 
  FROM bh48s_users 
  WHERE id = 41

Explain

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

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
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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:6068
15	ParentClassItem->_afterLoad()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1072
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.15 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 15.009 MB Rows returned: 1

SELECT name, email 
  FROM bh48s_users 
  WHERE id = 49

Explain

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

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
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.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:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:6093
15	ParentClassItem->_afterLoad()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1072
14	ParentClassItem->_loadRecord()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:409
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.04 ms Query memory: 0.023 MB Memory before query: 15.016 MB Rows returned: 1

SELECT c.title, c.params 
  FROM bh48s_categories AS c 
  WHERE c.id = 23

Explain

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

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.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.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:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3789
14	ParentClassItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:416
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.24 ms After last query: 5.50 ms Query memory: 0.040 MB Memory before query: 15.595 MB Rows returned: 14

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

Explain

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

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.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 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/classes/helpers/tmpl.php:408
16	flexicontent_tmpl::getLayoutparams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4465
15	ParentClassItem->getLayoutparams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3832
14	ParentClassItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:416
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.46 ms After last query: 0.43 ms Query memory: 0.027 MB Memory before query: 15.746 MB Rows returned: 102

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

  FROM `bh48s_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bh48s_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	340	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.05 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.21 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
20	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1523
15	ParentClassItem->getItemAccess()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3872
14	ParentClassItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:416
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.24 ms After last query: 0.41 ms Query memory: 0.024 MB Memory before query: 15.773 MB Rows returned: 1

Duplicate queries: #38 #87

SELECT id, title, published, access, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM bh48s_categories 
  WHERE id IN (23) 
  AND extension="com_content"

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.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
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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.categories.php:80
16	flexicontent_cats->getParentCats()	JROOT/components/com_flexicontent/classes/flexicontent.categories.php:124
15	flexicontent_cats->getParentlist()	JROOT/components/com_flexicontent/models/item.php:108
14	FlexicontentModelItem->_check_viewing_access()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:421
13	ParentClassItem->getItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:2097
12	FlexicontentViewItem->_displayItem()	JROOT/administrator/components/com_flexicontent/views/item/view.html.php:57
11	FlexicontentViewItem->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.98 ms Query memory: 0.023 MB Memory before query: 16.242 MB Rows returned: 1

Message

Oscar Bourne

Login

Agents

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

121 Queries Logged 42.77 ms

11 duplicate found!