Flexicontent Real Estate demo
Toggle Navigation
  • Home
  • Propriety
    • House
    • Apartements
  • Agents
  • How to do same site
    • About this demo
  • Account
    • My selection
  • Project

Tag: relation item

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

Login

  • Forgot your username?
  • Forgot your password?

Copyright 2021 Com3elles Joomla! and flexicontent specialist :  site for demo only

Back to Top

© 2023 Flexicontent Real Estate demo

×** [Flexisystem PLG: Adding css classes to BODY: 0.000 s]
0.000 seconds (0.000); 9.28 MB (9.285) - START: FLEXIcontent component
0.061 seconds (0.061); 16.88 MB (7.591) - END: FLEXIcontent component: (VIEW: tags)

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

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701641813,
                "last": 1701641813,
                "now": 1701641813
            },
            "token": "jlEQl0PRQINqKZquxpN9EZ6f7yrsn7tg"
        },
        "registry": {
            "filter_messages": null
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "43eaefa01077b9d6c5abdd69be4951b90e86a7cf": {
                    "link": "https://flexidemo.com3elles.com/realestate/recherche/tag/",
                    "expiry": 1701641813
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 12.16 ms / 12.16 ms Memory: 1.929 MB / 2.32 MB Application: afterLoad
Time: 41.46 ms / 53.61 ms Memory: 5.453 MB / 7.77 MB Application: afterInitialise
Time: 7.26 ms / 60.87 ms Memory: 0.965 MB / 8.74 MB Application: Before Access::preloadComponents (all components)
Time: 0.64 ms / 61.51 ms Memory: 0.062 MB / 8.80 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 61.53 ms Memory: -0.004 MB / 8.80 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Time: 0.31 ms / 61.84 ms Memory: 0.026 MB / 8.82 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Time: 14.08 ms / 75.92 ms Memory: 0.248 MB / 9.07 MB Application: afterRoute
Time: 0.52 ms / 76.44 ms Memory: 0.101 MB / 9.17 MB Application: beforeRenderComponent com_flexicontent
Time: 23.51 ms / 99.95 ms Memory: 2.921 MB / 12.09 MB Application: Before Access::getAssetRules (id:43 name:com_flexicontent)
Time: 0.09 ms / 100.04 ms Memory: 0.031 MB / 12.13 MB Application: After Access::getAssetRules (id:43 name:com_flexicontent)
Time: 38.03 ms / 138.07 ms Memory: 4.705 MB / 16.83 MB Application: afterRenderComponent com_flexicontent
Time: 0.19 ms / 138.25 ms Memory: 0.005 MB / 16.83 MB Application: afterDispatch
Time: 24.14 ms / 162.40 ms Memory: 0.657 MB / 17.49 MB Application: afterRender

Database queries total: 31.37 ms

Memory Usage

18.05 MB (18,923,488 Bytes)

Database Queries

41 Queries Logged 31.37 ms


2 duplicate found!

2 duplicates: #39  #40
  1. Query Time: 0.26 ms Query memory: 0.023 MB Memory before query: 4.091 MB Rows returned: 0
    SELECT `data`
    
      FROM `bh48s_session`
      WHERE `session_id` = X'677671706673646e6b633570316e62613033706a36656a6d6c72'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.16 ms After last query: 0.84 ms Query memory: 0.020 MB Memory before query: 4.186 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `bh48s_session`
      WHERE `session_id` = X'677671706673646e6b633570316e62613033706a36656a6d6c72'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 3.31 ms After last query: 0.05 ms Query memory: 0.004 MB Memory before query: 4.191 MB
    INSERT INTO `bh48s_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'677671706673646e6b633570316e62613033706a36656a6d6c72', 1, 1701641813, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `bh48s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'677671706673646e6b633570316e62613033706a36656a6d6c72', 1, 1701641813, 0, '', 0)
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.01 ms
    Update0.04 ms
    Waiting for query cache lock0.00 ms
    Update0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit3.12 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.20 ms After last query: 3.78 ms Query memory: 0.020 MB Memory before query: 4.757 MB Rows returned: 3
    SELECT id, rules
    
      FROM `bh48s_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL3
    Profile
    StatusDuration
    Starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.26 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.768 MB Rows returned: 1
    SELECT b.id
    
      FROM bh48s_usergroups AS a
      LEFT JOIN bh48s_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL1Using where; Using index
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.23 ms After last query: 13.90 ms Query memory: 0.021 MB Memory before query: 7.325 MB Rows returned: 1
    SELECT lft,rgt 
      FROM bh48s_categories
      WHERE id=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    9JDatabaseDriver->loadObject()JROOT/administrator/components/com_flexicontent/defineconstants.php:101
    8require_once JROOT/administrator/components/com_flexicontent/defineconstants.phpJROOT/plugins/system/flexisystem/flexisystem.php:36
    7require_once JROOT/plugins/system/flexisystem/flexisystem.phpJROOT/libraries/src/Plugin/PluginHelper.php:251
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.50 ms After last query: 13.57 ms Query memory: 0.023 MB Memory before query: 8.745 MB Rows returned: 41
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `bh48s_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_ffexplorer','com_fields','com_finder','com_flexicontent','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_pwtseo','com_redirect','com_search','com_tags','com_templateck','com_templates','com_users','com_weblinks','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_assetsrangeidx_asset_nameidx_asset_name202NULL42Using index condition
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.08 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.18 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    13Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    12Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    11Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    10Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    9Joomla\CMS\User\User->authorise()JROOT/plugins/system/flexisystem/flexisystem.php:266
    8plgSystemFlexisystem->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 12.47 ms After last query: 0.70 ms Query memory: 0.006 MB Memory before query: 8.841 MB
    UPDATE `bh48s_extensions`
    
      SET `params` = '{\"mediaversion\":\"dd092201cc60007848ec85419819afd0\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `bh48s_extensions` SET `params` = '{\"mediaversion\":\"dd092201cc60007848ec85419819afd0\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.05 ms
    Updating0.04 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit12.24 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/plugins/system/flexisystem/flexisystem.php:278
    8plgSystemFlexisystem->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.29 ms After last query: 24.97 ms Query memory: 0.022 MB Memory before query: 12.085 MB Rows returned: 1
    SELECT t.name, t.id, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM bh48s_flexicontent_tags AS t
      WHERE t.id = 46
      AND t.published = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtconstPRIMARY,publishedPRIMARY4const1
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    13JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/models/tags.php:696
    12FlexicontentModelTags->getTag()JROOT/components/com_flexicontent/views/tags/view.html.php:56
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 3.03 ms After last query: 1.55 ms Query memory: 2.500 MB Memory before query: 12.310 MB Rows returned: 1
    SELECT i.id, i.*, ie.* , c.access as category_access, ty.access as type_access, 1 AS has_access, c.title AS maincat_title, c.alias AS maincat_alias, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug
      FROM bh48s_content AS i JOIN bh48s_flexicontent_items_ext AS ie
      ON ie.item_id = i.id JOIN bh48s_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN bh48s_flexicontent_types AS ty
      ON ie.type_id = ty.id JOIN bh48s_categories AS c
      ON c.id = i.catid
      WHERE tag.tid = 46
      AND ( i.state IN (1, -5) )
      AND ( ( i.publish_up is NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) )
      AND ( ( i.publish_down is NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) )
      AND ty.access IN (0,1,1)
      AND c.access IN (0,1,1)
      AND i.access IN (0,1,1)
      GROUP BY i.id
      ORDER BY i.created DESC, i.title ASC
      LIMIT 0, 30
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtagrefPRIMARY,tid,itemidPRIMARY4const1Using index; Using temporary; Using filesort
    1SIMPLEieq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4com3web5_flexirealestatedemo.tag.itemid1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4com3web5_flexirealestatedemo.i.catid1Using where
    1SIMPLEieeq_refPRIMARY,type_idPRIMARY4com3web5_flexirealestatedemo.tag.itemid1Using index condition
    1SIMPLEtyeq_refPRIMARY,accessPRIMARY4com3web5_flexirealestatedemo.ie.type_id1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.11 ms
    Preparing0.03 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data1.16 ms
    Creating sort index1.06 ms
    Removing tmp table0.25 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/components/com_flexicontent/models/tags.php:238
    13FlexicontentModelTags->getData()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/tags/view.html.php:74
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.25 ms After last query: 0.56 ms Query memory: 0.023 MB Memory before query: 13.561 MB Rows returned: 0
    SELECT a.id as id, k.id as original_id 
      FROM bh48s_associations AS a JOIN bh48s_associations AS k
      ON a.`key`=k.`key` JOIN bh48s_content AS i
      ON i.id = k.id
      AND i.language = 'en-GB'
      WHERE a.id IN (87)
      AND a.context = "com_content.item"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/db.php:1161
    14flexicontent_db::getOriginalContentItemids()JROOT/components/com_flexicontent/models/tags.php:241
    13FlexicontentModelTags->getData()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/tags/view.html.php:74
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 2.52 ms After last query: 0.08 ms Query memory: 2.499 MB Memory before query: 13.569 MB Rows returned: 1
    SELECT i.id, i.*, ie.* , c.access as category_access, ty.access as type_access, 1 AS has_access, c.title AS maincat_title, c.alias AS maincat_alias, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug
      FROM bh48s_content AS i JOIN bh48s_flexicontent_items_ext AS ie
      ON ie.item_id = i.id JOIN bh48s_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN bh48s_flexicontent_types AS ty
      ON ie.type_id = ty.id JOIN bh48s_categories AS c
      ON c.id = i.catid
      WHERE tag.tid = 46
      AND ( i.state IN (1, -5) )
      AND ( ( i.publish_up is NULL OR i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) )
      AND ( ( i.publish_down is NULL OR i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) )
      AND ty.access IN (0,1,1)
      AND c.access IN (0,1,1)
      AND i.access IN (0,1,1)
      GROUP BY i.id
      ORDER BY i.created DESC, i.title ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtagrefPRIMARY,tid,itemidPRIMARY4const1Using index; Using temporary; Using filesort
    1SIMPLEieq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4com3web5_flexirealestatedemo.tag.itemid1Using where
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4com3web5_flexirealestatedemo.i.catid1Using where
    1SIMPLEieeq_refPRIMARY,type_idPRIMARY4com3web5_flexirealestatedemo.tag.itemid1Using index condition
    1SIMPLEtyeq_refPRIMARY,accessPRIMARY4com3web5_flexirealestatedemo.ie.type_id1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.04 ms
    Optimizing0.03 ms
    Statistics0.09 ms
    Preparing0.03 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.82 ms
    Creating sort index1.00 ms
    Removing tmp table0.23 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/components/com_flexicontent/models/tags.php:270
    13FlexicontentModelTags->getTotal()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/tags/view.html.php:75
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.28 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 13.576 MB Rows returned: 4
    SELECT t.tid, t.itemid 
      FROM bh48s_flexicontent_tags_item_relations AS t
      WHERE t.itemid IN (87)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefitemiditemid4const4
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1498
    14FlexicontentFields::_getTags()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:353
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.52 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.586 MB Rows returned: 4
    SELECT DISTINCT t.id AS _id, t.name, jt.id, jt.title, jt.description,  
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM bh48s_flexicontent_tags AS t JOIN bh48s_flexicontent_tags_item_relations AS i
      ON i.tid = t.id
      LEFT JOIN bh48s_tags AS jt
      ON jt.id = t.jtag_id
      WHERE i.itemid IN (87)
      AND t.published = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEirefPRIMARY,tid,itemiditemid4const4Using temporary
    1SIMPLEteq_refPRIMARY,publishedPRIMARY4com3web5_flexirealestatedemo.i.tid1Using where
    1SIMPLEjteq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.t.jtag_id1Using where
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Creating tmp table0.02 ms
    Executing0.00 ms
    Sending data0.18 ms
    Removing tmp table0.05 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1515
    14FlexicontentFields::_getTags()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:353
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.594 MB Rows returned: 1
    SELECT c.catid, c.itemid 
      FROM bh48s_flexicontent_cats_item_relations AS c
      WHERE c.itemid IN (87)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrefitemiditemid4const1
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1596
    14FlexicontentFields::_getCategories()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:354
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.27 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.603 MB Rows returned: 1
    SELECT DISTINCT c.id, c.title, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM bh48s_categories AS c JOIN bh48s_flexicontent_cats_item_relations AS rel
      ON rel.catid = c.id
      WHERE rel.itemid IN (87)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLErelrefPRIMARY,catid,itemiditemid4const1Using temporary
    1SIMPLEceq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.rel.catid1
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    Removing tmp table0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1613
    14FlexicontentFields::_getCategories()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:354
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.20 ms After last query: 0.02 ms Query memory: 0.024 MB Memory before query: 13.612 MB Rows returned: 0
    SELECT DISTINCT itemid, 1 AS favs 
      FROM bh48s_flexicontent_favourites
      WHERE type = 0
      AND itemid IN ('87')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_favouritesrefitemiditemid4const1Using where; Using temporary
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Creating tmp table0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Removing tmp table0.01 ms
    Sending data0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1647
    14FlexicontentFields::_getFavourites()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:355
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.20 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 13.633 MB Rows returned: 0
    SELECT DISTINCT itemid, 1 AS fav 
      FROM bh48s_flexicontent_favourites
      WHERE type = 0
      AND itemid IN (87)
      AND userid = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_favouritesref|filteritemid,useriditemid|userid4|4const1 (11%)Using where; Using rowid filter
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1681
    14FlexicontentFields::_getFavoured()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:356
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.641 MB Rows returned: 1
    SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email 
      FROM bh48s_content AS i
      LEFT JOIN bh48s_users AS u
      ON u.id = i.created_by
      WHERE i.id IN ('87')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Unlocking tables0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1741
    14FlexicontentFields::_getAuthors()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:357
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.20 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 13.649 MB Rows returned: 1
    SELECT i.id, u.name, u.username, u.email 
      FROM bh48s_content AS i
      LEFT JOIN bh48s_users AS u
      ON u.id = i.modified_by
      WHERE i.id IN ('87')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1715
    14FlexicontentFields::_getModifiers()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:358
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.16 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.657 MB Rows returned: 1
    SELECT id, name 
      FROM bh48s_flexicontent_types
      WHERE id IN ('7')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_typesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1765
    14FlexicontentFields::_getTypenames()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:359
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.14 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.665 MB Rows returned: 0
    SELECT * 
      FROM bh48s_content_rating
      WHERE content_id IN ('87')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1797
    14FlexicontentFields::_getVotes()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:360
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 13.672 MB Rows returned: 0
    SELECT *, field_id as extra_id 
      FROM bh48s_flexicontent_items_extravote
      WHERE content_id IN ('87')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1803
    14FlexicontentFields::_getVotes()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:360
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 13.680 MB Rows returned: 1
    SELECT field_id, value, item_id, valueorder, suborder 
      FROM bh48s_flexicontent_fields_item_relations
      WHERE item_id IN (87)
      AND value > ""
      ORDER BY item_id, field_id, valueorder, suborder
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_fields_item_relationsrefitem_id,valueitem_id4const1Using where; Using filesort
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.03 ms
    End of update loop0.00 ms
    Query end0.02 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1367
    14FlexicontentFields::_getCustomValues()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:361
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.83 ms After last query: 0.02 ms Query memory: 0.039 MB Memory before query: 13.688 MB Rows returned: 43
    SELECT fi.*, 
      CASE WHEN fi.access IN (0,1,1) THEN 1 ELSE 0 END AS has_access
      FROM bh48s_flexicontent_fields AS fi JOIN bh48s_flexicontent_fields_type_relations AS ftrel
      ON ftrel.field_id = fi.id
      AND ftrel.type_id = 7
      WHERE fi.published = 1
      GROUP BY fi.id
      ORDER BY ftrel.ordering, fi.ordering, fi.name
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEftrelALLPRIMARY,field_id,type_idNO INDEX KEY COULD BE USEDNULLNULL262Using where; Using temporary; Using filesort
    1SIMPLEfieq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.ftrel.field_id1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.34 ms
    Creating sort index0.16 ms
    Removing tmp table0.07 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:402
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:126
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/tags/view.html.php:83
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.19 ms After last query: 0.74 ms Query memory: 0.023 MB Memory before query: 15.058 MB Rows returned: 3
    SELECT id, title 
      FROM bh48s_viewlevels
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_viewlevelsindexNULLidx_assetgroup_title_lookup402NULL3Using index
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/db.php:177
    13flexicontent_db::getAccessNames()JROOT/components/com_flexicontent/classes/helpers/html.php:5833
    12flexicontent_html::calculateItemMarkups()JROOT/components/com_flexicontent/views/tags/view.html.php:90
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.21 ms After last query: 3.90 ms Query memory: 0.024 MB Memory before query: 16.215 MB Rows returned: 3
    SELECT DISTINCT lc.lang_id as id, lc.image as image_prefix, lc.lang_code as code, lc.title_native, lc.sef,lc.title as name
    
      FROM bh48s_languages as lc
      WHERE 1
      ORDER BY lc.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLElcALLNULLNO INDEX KEY COULD BE USEDNULLNULL3Using filesort
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:125
    15FLEXIUtilities::getlanguageslist()JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:197
    14FLEXIUtilities::getLanguages()JROOT/components/com_flexicontent/classes/helpers/html.php:1886
    13flexicontent_html::loadFramework()JROOT/components/com_flexicontent/classes/helpers/html.php:1910
    12flexicontent_html::loadFramework()JROOT/components/com_flexicontent/views/tags/view.html.php:98
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.26 ms After last query: 3.51 ms Query memory: 0.026 MB Memory before query: 16.525 MB Rows returned: 0
    SELECT f.*  
      FROM bh48s_flexicontent_fields AS f
      WHERE f.published = 1
      AND f.field_type = "fieldgroup"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfALLNULLNO INDEX KEY COULD BE USEDNULLNULL96Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.07 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:5831
    17FlexicontentFields::getFieldsPerGroup()JROOT/components/com_flexicontent/tmpl_common/filters.php:26
    16include JROOT/components/com_flexicontent/tmpl_common/filters.phpJROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php:16
    15include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.phpJROOT/components/com_flexicontent/views/tags/tmpl/default.php:141
    14include JROOT/components/com_flexicontent/views/tags/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_flexicontent/views/tags/view.html.php:334
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.21 ms After last query: 7.45 ms Query memory: 0.072 MB Memory before query: 16.558 MB Rows returned: 5
    SELECT t.attribs, t.id
    
      FROM bh48s_flexicontent_types AS t
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/helpers/route.php:308
    16FlexicontentHelperRoute::_getTypeParams()JROOT/components/com_flexicontent/helpers/route.php:408
    15FlexicontentHelperRoute::getItemRoute()JROOT/components/com_flexicontent/views/tags/tmpl/default.php:216
    14include JROOT/components/com_flexicontent/views/tags/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_flexicontent/views/tags/view.html.php:334
    11FlexicontentViewTags->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:263
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:270
    6require_once JROOT/components/com_flexicontent/flexicontent.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.49 ms After last query: 12.05 ms Query memory: 0.024 MB Memory before query: 17.166 MB Rows returned: 138
    SHOW TABLES
    Explain
    EXPLAIN not possible on query: SHOW TABLES
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Filling schema table0.01 ms
    checking permissions0.23 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Removing tmp table0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    11JDatabaseDriver->loadColumn()JROOT/libraries/joomla/database/driver/mysqli.php:505
    10JDatabaseDriverMysqli->getTableList()JROOT/plugins/system/mobilemenuck/helpers/helper.php:186
    9Mobilemenuck\Helper::searchTable()JROOT/plugins/system/mobilemenuck/helpers/helper.php:174
    8Mobilemenuck\Helper::checkIsProVersion()JROOT/plugins/system/mobilemenuck/mobilemenuck.php:620
    7PlgSystemMobilemenuck->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.28 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 17.177 MB Rows returned: 0
    SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`
    
      FROM `bh48s_plg_pwtseo` AS `pwtseo`
      WHERE `pwtseo`.`context_id` = '46'
      AND `pwtseo`.`context` = 'com_flexicontent.tags'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.01 ms
    table lock0.00 ms
    init0.03 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.05 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    10JDatabaseDriver->loadObject()JROOT/plugins/system/pwtseo/pwtseo.php:665
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:869
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.50 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 17.187 MB Rows returned: 0
    SELECT 'com_flexicontent.tags' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
      values` AS `
      values`
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map`
      ON `map`.`datalayer_id` = `layers`.`id`
      WHERE `map`.`context_id` = '46'
      AND `map`.`context` = 'com_flexicontent.tags'
      AND `layers`.`published` = 1
      ORDER BY `layers`.`ordering` ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmaprefcontext_id,pwtseo_datalayers_map_datalayer_fkcontext_id4const1Using where; Using temporary; Using filesort
    1SIMPLElayerseq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.map.datalayer_id1Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Creating tmp table0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.14 ms
    Creating sort index0.02 ms
    Removing tmp table0.04 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/pwtseo/pwtseo.php:745
    10PlgSystemPWTSEO->getDataLayers()JROOT/plugins/system/pwtseo/pwtseo.php:678
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:869
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 17.193 MB Rows returned: 1
    SELECT `cascade_settings`
    
      FROM `bh48s_plg_pwtseo`
      WHERE `context` = 'com_menus.item'
      AND `context_id` = 167
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_plg_pwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    10JDatabaseDriver->loadResult()JROOT/plugins/system/pwtseo/pwtseo.php:2654
    9PlgSystemPWTSEO->shouldSettingsCascade()JROOT/plugins/system/pwtseo/pwtseo.php:902
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.21 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 17.203 MB Rows returned: 0
    SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`
    
      FROM `bh48s_plg_pwtseo` AS `pwtseo`
      WHERE `pwtseo`.`url` = '/realestate/recherche/tag/46-relation-item.html'
      AND `pwtseo`.`context` = 'com_menus.item'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    10JDatabaseDriver->loadObject()JROOT/plugins/system/pwtseo/pwtseo.php:665
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:939
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 0.39 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.213 MB Rows returned: 0
    SELECT 'com_menus.item' AS context,'/realestate/recherche/tag/46-relation-item.html' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
      values` AS `
      values`
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map`
      ON `map`.`datalayer_id` = `layers`.`id`
      WHERE `map`.`context_id` = '/realestate/recherche/tag/46-relation-item.html'
      AND `map`.`context` = 'com_menus.item'
      AND `layers`.`published` = 1
      ORDER BY `layers`.`ordering` ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmaprefcontext_id,pwtseo_datalayers_map_datalayer_fkcontext_id4const1Using where; Using temporary; Using filesort
    1SIMPLElayerseq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.map.datalayer_id1Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.10 ms
    Creating sort index0.01 ms
    Removing tmp table0.04 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/pwtseo/pwtseo.php:745
    10PlgSystemPWTSEO->getDataLayers()JROOT/plugins/system/pwtseo/pwtseo.php:678
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:939
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  36. Query Time: 0.23 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.215 MB Rows returned: 0
    SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`
    
      FROM `bh48s_plg_pwtseo` AS `pwtseo`
      WHERE `pwtseo`.`url` = '/realestate/recherche/tag/46-relation-item.html'
      AND `pwtseo`.`context` = 'com_pwtseo.custom'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    10JDatabaseDriver->loadObject()JROOT/plugins/system/pwtseo/pwtseo.php:665
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:943
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  37. Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 17.222 MB Rows returned: 0
    SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`,`item`.`language`
    
      FROM `bh48s_plg_pwtseo` AS `pwtseo`
      LEFT JOIN `bh48s_content` AS `item`
      ON `item`.`id` = 46
      WHERE `pwtseo`.`context_id` = '46'
      AND `pwtseo`.`context` = 'com_content.article'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEitemconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    10JDatabaseDriver->loadObject()JROOT/plugins/system/pwtseo/pwtseo.php:665
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:946
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  38. Query Time: 0.38 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.232 MB Rows returned: 0
    SELECT 'com_content.article' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
      values` AS `
      values`
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map`
      ON `map`.`datalayer_id` = `layers`.`id`
      WHERE `map`.`context_id` = '46'
      AND `map`.`context` = 'com_content.article'
      AND `layers`.`published` = 1
      ORDER BY `layers`.`ordering` ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmaprefcontext_id,pwtseo_datalayers_map_datalayer_fkcontext_id4const1Using where; Using temporary; Using filesort
    1SIMPLElayerseq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.map.datalayer_id1Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.10 ms
    Creating sort index0.01 ms
    Removing tmp table0.04 ms
    Creating sort index0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/pwtseo/pwtseo.php:745
    10PlgSystemPWTSEO->getDataLayers()JROOT/plugins/system/pwtseo/pwtseo.php:678
    9PlgSystemPWTSEO->getSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:946
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  39. Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.230 MB Rows returned: 0
    Duplicate queries: #40
    SELECT `layers`.`id`,`layers`.`title`,`layers`.`name`,`layers`.`fields`,`layers`.`language`,`layers`.`template`
    
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers`
      WHERE `published` = 1
      AND `language` = '*'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLElayersALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/pwtseo/pwtseo.php:811
    9PlgSystemPWTSEO->getDefaultDataLayers()JROOT/plugins/system/pwtseo/pwtseo.php:954
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  40. Query Time: 0.16 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 17.236 MB Rows returned: 0
    Duplicate queries: #39
    SELECT `layers`.`id`,`layers`.`title`,`layers`.`name`,`layers`.`fields`,`layers`.`language`,`layers`.`template`
    
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers`
      WHERE `published` = 1
      AND `language` = '*'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLElayersALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/pwtseo/pwtseo.php:811
    9PlgSystemPWTSEO->getDefaultDataLayers()JROOT/plugins/system/pwtseo/pwtseo.php:962
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  41. Query Time: 0.19 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 17.241 MB Rows returned: 1
    SELECT `id`
    
      FROM `bh48s_template_styles`
      WHERE `client_id` = 0
      AND `home` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_template_stylesrefidx_client_id,idx_client_id_homeidx_client_id_home1const2Using where; Using index
    Profile
    StatusDuration
    Starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/pwtseo/pwtseo.php:990
    8PlgSystemPWTSEO->getCurrentSEOData()JROOT/plugins/system/pwtseo/pwtseo.php:1304
    7PlgSystemPWTSEO->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1102
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 3 × SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical` 
      FROM `bh48s_plg_pwtseo` AS `pwtseo`
  2. 2 × SELECT i.id, i.*, ie.* , c.access as category_access, ty.access as type_access, 1 AS has_access, c.title AS maincat_title, c.alias AS maincat_alias, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug
      FROM bh48s_content AS i JOIN bh48s_flexicontent_items_ext AS ie
      ON ie.item_id = i.id JOIN bh48s_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN bh48s_flexicontent_types AS ty
      ON ie.type_id = ty.id JOIN bh48s_categories AS c
      ON c.id = i.catid
  3. 2 × SELECT `layers`.`id`,`layers`.`title`,`layers`.`name`,`layers`.`fields`,`layers`.`language`,`layers`.`template` 
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers`
  4. 1 × SELECT `data` 
      FROM `bh48s_session`
  5. 1 × SELECT `session_id` 
      FROM `bh48s_session`
  6. 1 × SELECT id, rules 
      FROM `bh48s_viewlevels
  7. 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
  8. 1 × SELECT lft,rgt 
      FROM bh48s_categories
  9. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `bh48s_assets`
  10. 1 × SELECT t.name, t.id, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM bh48s_flexicontent_tags AS t
  11. 1 × SELECT a.id as id, k.id as original_id 
      FROM bh48s_associations AS a JOIN bh48s_associations AS k
      ON a.`key`=k.`key` JOIN bh48s_content AS i
      ON i.id = k.id
      AND i.language = 'en-GB'
  12. 1 × SELECT t.tid, t.itemid 
      FROM bh48s_flexicontent_tags_item_relations AS t
  13. 1 × SELECT DISTINCT t.id AS _id, t.name, jt.id, jt.title, jt.description,  
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM bh48s_flexicontent_tags AS t JOIN bh48s_flexicontent_tags_item_relations AS i
      ON i.tid = t.id
      LEFT JOIN bh48s_tags AS jt
      ON jt.id = t.jtag_id
  14. 1 × SELECT c.catid, c.itemid 
      FROM bh48s_flexicontent_cats_item_relations AS c
  15. 1 × SELECT DISTINCT c.id, c.title, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM bh48s_categories AS c JOIN bh48s_flexicontent_cats_item_relations AS rel
      ON rel.catid = c.id
  16. 1 × SELECT DISTINCT itemid, 1 AS favs 
      FROM bh48s_flexicontent_favourites
  17. 1 × SELECT DISTINCT itemid, 1 AS fav 
      FROM bh48s_flexicontent_favourites
  18. 1 × SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email 
      FROM bh48s_content AS i
      LEFT JOIN bh48s_users AS u
      ON u.id = i.created_by
  19. 1 × SELECT i.id, u.name, u.username, u.email 
      FROM bh48s_content AS i
      LEFT JOIN bh48s_users AS u
      ON u.id = i.modified_by
  20. 1 × SELECT id, name 
      FROM bh48s_flexicontent_types
  21. 1 × SELECT * 
      FROM bh48s_content_rating
  22. 1 × SELECT *, field_id as extra_id 
      FROM bh48s_flexicontent_items_extravote
  23. 1 × SELECT field_id, value, item_id, valueorder, suborder 
      FROM bh48s_flexicontent_fields_item_relations
  24. 1 × SELECT fi.*, 
      CASE WHEN fi.access IN (0,1,1) THEN 1 ELSE 0 END AS has_access
      FROM bh48s_flexicontent_fields AS fi JOIN bh48s_flexicontent_fields_type_relations AS ftrel
      ON ftrel.field_id = fi.id
      AND ftrel.type_id = 7
  25. 1 × SELECT id, title 
      FROM bh48s_viewlevel
  26. 1 × SELECT DISTINCT lc.lang_id as id, lc.image as image_prefix, lc.lang_code as code, lc.title_native, lc.sef,lc.title as name 
      FROM bh48s_languages as lc
  27. 1 × SELECT f.*  
      FROM bh48s_flexicontent_fields AS f
  28. 1 × SELECT t.attribs, t.id 
      FROM bh48s_flexicontent_types AS
  29. 1 × SELECT 'com_flexicontent.tags' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
      values` AS `
      values`
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map`
      ON `map`.`datalayer_id` = `layers`.`id`
  30. 1 × SELECT `cascade_settings` 
      FROM `bh48s_plg_pwtseo`
  31. 1 × SELECT 'com_menus.item' AS context,'/realestate/recherche/tag/46-relation-item.html' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
      values` AS `
      values`
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map`
      ON `map`.`datalayer_id` = `layers`.`id`
  32. 1 × SELECT `pwtseo`.`id`,`pwtseo`.`context`,`pwtseo`.`context_id`,`pwtseo`.`focus_word`,`pwtseo`.`pwtseo_score`,`pwtseo`.`facebook_title`,`pwtseo`.`facebook_description`,`pwtseo`.`facebook_image`,`pwtseo`.`facebook_url`,`pwtseo`.`twitter_title`,`pwtseo`.`twitter_description`,`pwtseo`.`twitter_image`,`pwtseo`.`google_title`,`pwtseo`.`google_description`,`pwtseo`.`google_image`,`pwtseo`.`adv_open_graph`,`pwtseo`.`structureddata`,`pwtseo`.`override_page_title`,`pwtseo`.`page_title`,`pwtseo`.`expand_og`,`pwtseo`.`override_canonical`,`pwtseo`.`canonical`,`pwtseo`.`articletitleselector`,`pwtseo`.`twitter_card`,`pwtseo`.`twitter_site_username`,`pwtseo`.`cascade_settings`,`pwtseo`.`strip_canonical_choice`,`pwtseo`.`strip_canonical`,`item`.`language` 
      FROM `bh48s_plg_pwtseo` AS `pwtseo`
      LEFT JOIN `bh48s_content` AS `item`
      ON `item`.`id` = 46
  33. 1 × SELECT 'com_content.article' AS context,'46' AS context_id,`layers`.`id` AS `id`,`layers`.`title` AS `title`,`layers`.`name` AS `name`,`layers`.`fields` AS `fields`,`layers`.`language` AS `language`,`layers`.`template` AS `template`,`map`.`
      values` AS `
      values`
      FROM `bh48s_plg_pwtseo_datalayers` AS `layers` RIGHT JOIN `bh48s_plg_pwtseo_datalayers_map` AS `map`
      ON `map`.`datalayer_id` = `layers`.`id`
  34. 1 × SELECT `id` 
      FROM `bh48s_template_styles`
OTHER Tables:
  1. 1 × INSERT INTO `bh48s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'677671706673646e6b633570316e62613033706a36656a6d6c72', 1, 1701641813, 0, '', 0
  2. 1 × UPDATE `bh48s_extensions` 
      SET `params` = '{\"mediaversion\":\"dd092201cc60007848ec85419819afd0\"}'
  3. 1 × SHOW TABLE