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

Tag: search

Filters changed, please click to submit when done
Results 1 - 3 of 3
2
Image Title Description Last updated
No image 16 - Map module in Flexicontent Now we will create 2 map modules to dosplay all easte in an interactive map. Flexicontent map module can create map with GoogleMap API or ... Thursday, 01 April 2021 19:28
No image 14 - Filter and search in Flexicontent In flexicontent all fields can be searchaeable and filtreable, but you need to check what you want in order to preserve the performance of you site ... Wednesday, 10 February 2021 14:54
No image 04 - Create Basic fields like room, price state for Estate In this part we will create all basic field for Estate State : Select list Price : Texte field with input mask Room | Bedroom | Garages: Select list ... Friday, 15 January 2021 14:01

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.26 MB (9.259) - START: FLEXIcontent component
0.088 seconds (0.088); 19.54 MB (10.285) - 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.04 s]

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701633475,
                "last": 1701633475,
                "now": 1701633475
            },
            "token": "iaK1DrMXxcwjXFPrw1K68oM0oTOCdYkY"
        },
        "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": 1701633476
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 12.14 ms / 12.14 ms Memory: 1.929 MB / 2.32 MB Application: afterLoad
Time: 380.88 ms / 393.02 ms Memory: 5.459 MB / 7.78 MB Application: afterInitialise
Time: 8.04 ms / 401.06 ms Memory: 0.928 MB / 8.71 MB Application: Before Access::preloadComponents (all components)
Time: 0.64 ms / 401.70 ms Memory: 0.060 MB / 8.77 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 401.72 ms Memory: -0.004 MB / 8.76 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Time: 0.31 ms / 402.03 ms Memory: 0.026 MB / 8.79 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Time: 4.92 ms / 406.94 ms Memory: 0.248 MB / 9.04 MB Application: afterRoute
Time: 1.32 ms / 408.27 ms Memory: 0.108 MB / 9.15 MB Application: beforeRenderComponent com_flexicontent
Time: 23.43 ms / 431.69 ms Memory: 2.920 MB / 12.07 MB Application: Before Access::getAssetRules (id:43 name:com_flexicontent)
Time: 0.08 ms / 431.78 ms Memory: 0.031 MB / 12.10 MB Application: After Access::getAssetRules (id:43 name:com_flexicontent)
Time: 64.83 ms / 496.61 ms Memory: 7.401 MB / 19.50 MB Application: afterRenderComponent com_flexicontent
Time: 0.17 ms / 496.78 ms Memory: 0.005 MB / 19.50 MB Application: afterDispatch
Time: 17.83 ms / 514.62 ms Memory: 0.652 MB / 20.16 MB Application: afterRender

Database queries total: 362.86 ms

Memory Usage

20.77 MB (21,774,264 Bytes)

Database Queries

45 Queries Logged 362.86 ms


2 duplicate found!

2 duplicates: #43  #44
  1. Query Time: 0.30 ms Query memory: 0.023 MB Memory before query: 4.091 MB Rows returned: 0
    SELECT `data`
    
      FROM `bh48s_session`
      WHERE `session_id` = X'6e6a357067343667696763763133746f72366e6339636e6e686e'
    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.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.04 ms
    Starting cleanup0.01 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.19 ms After last query: 0.90 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'6e6a357067343667696763763133746f72366e6339636e6e686e'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_sessionconstPRIMARYPRIMARY194const1Using 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.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.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.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: 311.35 ms After last query: 0.06 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'6e6a357067343667696763763133746f72366e6339636e6e686e', 1, 1701633475, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `bh48s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6e6a357067343667696763763133746f72366e6339636e6e686e', 1, 1701633475, 0, '', 0)
    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
    init for update0.01 ms
    Update0.05 ms
    Waiting for query cache lock0.00 ms
    Update0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit311.01 ms
    closing tables0.05 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.05 ms
    Reset for next command0.01 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: 26.78 ms After last query: 4.48 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.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
    Statistics26.37 ms
    Preparing0.06 ms
    Executing0.01 ms
    Sending data0.06 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 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.36 ms After last query: 0.17 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.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.02 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.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.75 ms After last query: 1.01 ms Query memory: 0.054 MB Memory before query: 4.839 MB Rows returned: 121
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM bh48s_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_extensionsALLextensionNO INDEX KEY COULD BE USEDNULLNULL288Using where; Using filesort
    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.03 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.40 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 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:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    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.]

  7. Query Time: 0.23 ms After last query: 15.09 ms Query memory: 0.021 MB Memory before query: 7.331 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.01 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.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
    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.]

  8. Query Time: 0.47 ms After last query: 8.46 ms Query memory: 0.072 MB Memory before query: 7.969 MB Rows returned: 20
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM bh48s_menu AS m
      LEFT JOIN bh48s_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const28Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.m.component_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.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.20 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
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:533
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
    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.52 ms After last query: 6.01 ms Query memory: 0.023 MB Memory before query: 8.711 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.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.01 ms
    Statistics0.07 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.20 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.]

  10. Query Time: 3.35 ms After last query: 0.68 ms Query memory: 0.006 MB Memory before query: 8.808 MB
    UPDATE `bh48s_extensions`
    
      SET `params` = '{\"mediaversion\":\"b030fac6b94713afbdfe73f48e956390\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `bh48s_extensions` SET `params` = '{\"mediaversion\":\"b030fac6b94713afbdfe73f48e956390\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    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
    init for update0.04 ms
    Updating0.04 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 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.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.]

  11. Query Time: 0.25 ms After last query: 1.52 ms Query memory: 0.019 MB Memory before query: 9.098 MB Rows returned: 1
    SELECT *
    
      FROM bh48s_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL3Using where; Using filesort
    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.02 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.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
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    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: 0.29 ms After last query: 0.30 ms Query memory: 0.019 MB Memory before query: 9.139 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM bh48s_template_styles as s
      LEFT JOIN bh48s_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const2
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403com3web5_flexirealestatedemo.s.template,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.04 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
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    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.26 ms After last query: 23.33 ms Query memory: 0.022 MB Memory before query: 12.057 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 = 17
      AND t.published = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtconstPRIMARY,publishedPRIMARY4const1
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 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.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
    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.]

  14. Query Time: 5.18 ms After last query: 1.55 ms Query memory: 3.176 MB Memory before query: 12.281 MB Rows returned: 3
    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 = 17
      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,itemidPRIMARY4const3Using 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.10 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.10 ms
    Preparing0.03 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data2.03 ms
    Creating sort index2.19 ms
    Removing tmp table0.40 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.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/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.]

  15. Query Time: 0.32 ms After last query: 1.01 ms Query memory: 0.023 MB Memory before query: 14.865 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 (98,96,92)
      AND a.context = "com_content.item"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEirefPRIMARY,idx_languageidx_language28const1Using where; Using index
    1SIMPLEkindexidx_keyidx_key128NULL1Using where; Using index; Using join buffer (flat, BNL join)
    1SIMPLEarefPRIMARY,idx_keyPRIMARY202const1Using 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.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.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
    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.]

  16. Query Time: 4.08 ms After last query: 0.10 ms Query memory: 3.175 MB Memory before query: 14.873 MB Rows returned: 3
    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 = 17
      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,itemidPRIMARY4const3Using 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.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.03 ms
    Statistics0.09 ms
    Preparing0.03 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data1.43 ms
    Creating sort index1.81 ms
    Removing tmp table0.37 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
    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.]

  17. Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 14.882 MB Rows returned: 19
    SELECT t.tid, t.itemid 
      FROM bh48s_flexicontent_tags_item_relations AS t
      WHERE t.itemid IN (98,96,92)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtindexitemidPRIMARY8NULL74Using where; Using 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.01 ms
    init0.01 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.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.]

  18. Query Time: 0.66 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 14.900 MB Rows returned: 14
    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 (98,96,92)
      AND t.published = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiindexPRIMARY,tid,itemidPRIMARY8NULL74Using where; Using index; Using 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.04 ms
    Preparing0.02 ms
    Creating tmp table0.02 ms
    Executing0.00 ms
    Sending data0.30 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.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: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.]

  19. Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 14.907 MB Rows returned: 3
    SELECT c.catid, c.itemid 
      FROM bh48s_flexicontent_cats_item_relations AS c
      WHERE c.itemid IN (98,96,92)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrangeitemiditemid4NULL3Using index condition
    Profile
    StatusDuration
    Starting0.02 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.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: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.]

  20. Query Time: 0.30 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 14.916 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 (98,96,92)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLErelrangePRIMARY,catid,itemiditemid4NULL3Using index condition; Using temporary
    1SIMPLEceq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.rel.catid1
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.02 ms
    Executing0.00 ms
    Sending data0.04 ms
    Removing tmp table0.01 ms
    Sending data0.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.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: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.]

  21. Query Time: 0.22 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 14.923 MB Rows returned: 0
    SELECT DISTINCT itemid, 1 AS favs 
      FROM bh48s_flexicontent_favourites
      WHERE type = 0
      AND itemid IN ('98','96','92')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_favouritesindexitemidPRIMARY16NULL9Using where; Using index; Using temporary
    Profile
    StatusDuration
    Starting0.02 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.02 ms
    Preparing0.01 ms
    Creating tmp table0.01 ms
    Executing0.00 ms
    Sending data0.02 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.]

  22. Query Time: 0.23 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 14.944 MB Rows returned: 0
    SELECT DISTINCT itemid, 1 AS fav 
      FROM bh48s_flexicontent_favourites
      WHERE type = 0
      AND itemid IN (98,96,92)
      AND userid = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_favouritesref|filteritemid,useriduserid|itemid4|4const1 (33%)Using where; Using temporary; Using rowid filter
    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.03 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: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.]

  23. Query Time: 0.25 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 14.951 MB Rows returned: 3
    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 ('98','96','92')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEirangePRIMARYPRIMARY4NULL3Using where
    1SIMPLEueq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.i.created_by1Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 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.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: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.]

  24. Query Time: 0.21 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 14.961 MB Rows returned: 3
    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 ('98','96','92')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEirangePRIMARYPRIMARY4NULL3Using where
    1SIMPLEueq_refPRIMARYPRIMARY4com3web5_flexirealestatedemo.i.modified_by1Using where
    Profile
    StatusDuration
    Starting0.02 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.02 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.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.]

  25. Query Time: 0.16 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 14.970 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.01 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.]

  26. Query Time: 0.17 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 14.979 MB Rows returned: 0
    SELECT * 
      FROM bh48s_content_rating
      WHERE content_id IN ('98','96','92')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_content_ratingALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1Using where
    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.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.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: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.]

  27. Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 14.986 MB Rows returned: 0
    SELECT *, field_id as extra_id 
      FROM bh48s_flexicontent_items_extravote
      WHERE content_id IN ('98','96','92')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    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.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.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: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.]

  28. Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 14.993 MB Rows returned: 3
    SELECT field_id, value, item_id, valueorder, suborder 
      FROM bh48s_flexicontent_fields_item_relations
      WHERE item_id IN (98,96,92)
      AND value > ""
      ORDER BY item_id, field_id, valueorder, suborder
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_flexicontent_fields_item_relationsrangeitem_id,valueitem_id4NULL3Using index condition; Using 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.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: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.]

  29. Query Time: 0.81 ms After last query: 0.03 ms Query memory: 0.039 MB Memory before query: 15.004 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.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.32 ms
    Creating sort index0.16 ms
    Removing tmp table0.08 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.00 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.]

  30. Query Time: 0.21 ms After last query: 0.80 ms Query memory: 0.023 MB Memory before query: 17.716 MB Rows returned: 3
    SELECT id, title 
      FROM bh48s_viewlevels
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEbh48s_viewlevelsindexNULLidx_assetgroup_title_lookup402NULL3Using index
    Profile
    StatusDuration
    Starting0.01 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.02 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.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.]

  31. Query Time: 0.21 ms After last query: 4.06 ms Query memory: 0.024 MB Memory before query: 18.873 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.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
    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.]

  32. Query Time: 0.27 ms After last query: 3.58 ms Query memory: 0.026 MB Memory before query: 19.182 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.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.07 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
    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.]

  33. Query Time: 0.21 ms After last query: 9.66 ms Query memory: 0.073 MB Memory before query: 19.222 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.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.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.]

  34. Query Time: 0.49 ms After last query: 31.85 ms Query memory: 0.024 MB Memory before query: 19.834 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.21 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.01 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.]

  35. Query Time: 0.26 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 19.845 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` = '17'
      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.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.04 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
    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.]

  36. Query Time: 0.44 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 19.855 MB Rows returned: 0
    SELECT 'com_flexicontent.tags' AS context,'17' 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` = '17'
      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.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.02 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Creating tmp table0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.11 ms
    Creating sort index0.02 ms
    Removing tmp table0.04 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
    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.]

  37. Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 19.855 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.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.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.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: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.]

  38. Query Time: 0.24 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 19.863 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/17-search.html'
      AND `pwtseo`.`context` = 'com_menus.item'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.01 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: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.]

  39. Query Time: 0.40 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 19.874 MB Rows returned: 0
    SELECT 'com_menus.item' AS context,'/realestate/recherche/tag/17-search.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/17-search.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.01 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.00 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.]

  40. Query Time: 0.22 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 19.875 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/17-search.html'
      AND `pwtseo`.`context` = 'com_pwtseo.custom'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpwtseoALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.02 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.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: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.]

  41. Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 19.882 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` = 17
      WHERE `pwtseo`.`context_id` = '17'
      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.01 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.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
    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.]

  42. Query Time: 0.39 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 19.893 MB Rows returned: 0
    SELECT 'com_content.article' AS context,'17' 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` = '17'
      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.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
    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.00 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.]

  43. Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 19.891 MB Rows returned: 0
    Duplicate queries: #44
    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.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.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: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.]

  44. Query Time: 0.19 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 19.896 MB Rows returned: 0
    Duplicate queries: #43
    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.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.01 ms
    Query end0.00 ms
    Commit0.01 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Starting cleanup0.01 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: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.]

  45. Query Time: 0.19 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 19.901 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.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
    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.]

41 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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM bh48s_extensions
  9. 1 × SELECT lft,rgt 
      FROM bh48s_categories
  10. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM bh48s_menu AS m
      LEFT JOIN bh48s_extensions AS e
      ON m.component_id = e.extension_id
  11. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `bh48s_assets`
  12. 1 × SELECT * 
      FROM bh48s_languages
  13. 1 × SELECT id, home, template, s.params 
      FROM bh48s_template_styles as s
      LEFT JOIN bh48s_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  14. 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
  15. 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'
  16. 1 × SELECT t.tid, t.itemid 
      FROM bh48s_flexicontent_tags_item_relations AS t
  17. 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
  18. 1 × SELECT c.catid, c.itemid 
      FROM bh48s_flexicontent_cats_item_relations AS c
  19. 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
  20. 1 × SELECT DISTINCT itemid, 1 AS favs 
      FROM bh48s_flexicontent_favourites
  21. 1 × SELECT DISTINCT itemid, 1 AS fav 
      FROM bh48s_flexicontent_favourites
  22. 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
  23. 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
  24. 1 × SELECT id, name 
      FROM bh48s_flexicontent_types
  25. 1 × SELECT * 
      FROM bh48s_content_rating
  26. 1 × SELECT *, field_id as extra_id 
      FROM bh48s_flexicontent_items_extravote
  27. 1 × SELECT field_id, value, item_id, valueorder, suborder 
      FROM bh48s_flexicontent_fields_item_relations
  28. 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
  29. 1 × SELECT id, title 
      FROM bh48s_viewlevel
  30. 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
  31. 1 × SELECT f.*  
      FROM bh48s_flexicontent_fields AS f
  32. 1 × SELECT t.attribs, t.id 
      FROM bh48s_flexicontent_types AS
  33. 1 × SELECT 'com_flexicontent.tags' AS context,'17' 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 `cascade_settings` 
      FROM `bh48s_plg_pwtseo`
  35. 1 × SELECT 'com_menus.item' AS context,'/realestate/recherche/tag/17-search.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`
  36. 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` = 17
  37. 1 × SELECT 'com_content.article' AS context,'17' 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`
  38. 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'6e6a357067343667696763763133746f72366e6339636e6e686e', 1, 1701633475, 0, '', 0
  2. 1 × UPDATE `bh48s_extensions` 
      SET `params` = '{\"mediaversion\":\"b030fac6b94713afbdfe73f48e956390\"}'
  3. 1 × SHOW TABLE