japprecie
music to live through
  • Français (FR)
  • English (UK)
Receive website news:

Tag: voodoo

Search / Filtering
Text Search
Filters changed, please click to submit when done
All ABCDEFGHIJKLMNOPQRSTUVWXYZ
0123456789
Results 1 - 1 of 1
  • Animal Triste
    Interview
    Animal Triste's Interview Image 1
    2022
    Animal Triste's Interview
    Creatures of the night
    Read more...


Back to Top

© 2023 japprecie  -  Communicate  -  Links

×** [Flexisystem PLG: Adding css classes to BODY: 0.000 s]
0.000 seconds (0.000); 5.08 MB (5.083) - START: FLEXIcontent component
0.092 seconds (0.092); 10.39 MB (5.303) - END: FLEXIcontent component: (VIEW: category -- LAYOUT: tags)

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

-- [FC Fields Rendering: 0.01 s]
0.001 smaintext
0.001 stext
0.009 simage
0.001 sradio

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

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675455095,
                "last": 1675455095,
                "now": 1675455095
            },
            "token": "I0n1VnY96rDH9wM1Qat3BXUHLRRVqSJr"
        },
        "registry": {
            "com_flexicontent": {
                "min_word_len": 4
            },
            "use_limit_before_search_filt": 0,
            "filter_messages": null
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    },
    "__flexicontent": {
        "screenSizeCookieToBeAdded": 0,
        "screenSizeCookieTried": 1
    }
}

Profile Information

Time

Memory

Time: 15.11 ms / 15.11 ms Memory: 0.813 MB / 1.15 MB Application: afterLoad
Time: 49.93 ms / 65.04 ms Memory: 3.506 MB / 4.66 MB Application: afterInitialise
Time: 6.57 ms / 71.60 ms Memory: 0.190 MB / 4.85 MB Application: Before Access::preloadComponents (all components)
Time: 1.53 ms / 73.14 ms Memory: 0.060 MB / 4.90 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 73.17 ms Memory: -0.003 MB / 4.90 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.23 ms / 73.40 ms Memory: 0.017 MB / 4.92 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 1.80 ms / 75.20 ms Memory: 0.030 MB / 4.95 MB Application: afterRoute
Time: 40.13 ms / 115.33 ms Memory: 0.066 MB / 5.01 MB Application: beforeRenderComponent com_flexicontent
Time: 42.00 ms / 157.33 ms Memory: 2.681 MB / 7.70 MB Application: Before Access::getAssetRules (id:217 name:com_flexicontent)
Time: 0.12 ms / 157.45 ms Memory: 0.033 MB / 7.73 MB Application: After Access::getAssetRules (id:217 name:com_flexicontent)
Time: 39.60 ms / 197.05 ms Memory: 1.709 MB / 9.44 MB Application: Before Access::preloadPermissions (com_content)
Time: 2.15 ms / 199.21 ms Memory: 0.271 MB / 9.71 MB Application: After Access::preloadPermissions (com_content)
Time: 0.03 ms / 199.23 ms Memory: -0.019 MB / 9.69 MB Application: Before Access::getAssetRules (id:666 name:com_content.article.239)
Time: 0.05 ms / 199.29 ms Memory: 0.008 MB / 9.70 MB Application: After Access::getAssetRules (id:666 name:com_content.article.239)
Time: 9.29 ms / 208.58 ms Memory: 0.685 MB / 10.38 MB Application: afterRenderComponent com_flexicontent
Time: 1.92 ms / 210.50 ms Memory: 0.018 MB / 10.40 MB Application: afterDispatch
Time: 134.72 ms / 345.22 ms Memory: 0.629 MB / 11.03 MB Application: beforeRenderModule mod_languages (Sélecteur de langue)
Time: 2.53 ms / 347.75 ms Memory: 0.027 MB / 11.06 MB Application: afterRenderModule mod_languages (Sélecteur de langue)
Time: 0.07 ms / 347.82 ms Memory: -0.001 MB / 11.05 MB Application: beforeRenderModule mod_acymailing (AcyMailing Module)
Time: 5.06 ms / 352.88 ms Memory: 0.513 MB / 11.57 MB Application: afterRenderModule mod_acymailing (AcyMailing Module)
Time: 0.36 ms / 353.24 ms Memory: 0.004 MB / 11.57 MB Application: beforeRenderModule mod_custom (Lien Facebook)
Time: 0.33 ms / 353.56 ms Memory: 0.005 MB / 11.58 MB Application: afterRenderModule mod_custom (Lien Facebook)
Time: 145.87 ms / 499.43 ms Memory: 0.186 MB / 11.76 MB Application: afterRender

Database queries total: 36.89 ms

Memory Usage

12.52 MB (13,132,496 Bytes)

Database Queries

56 Queries Logged 36.89 ms


  1. Query Time: 0.50 ms Query memory: 0.023 MB Memory before query: 1.498 MB Rows returned: 0
    SELECT `data`
    
      FROM `va2rq_session`
      WHERE `session_id` = X'3865656236666636616561623861383665356230626161626336323930316166'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 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.52 ms After last query: 0.41 ms Query memory: 0.020 MB Memory before query: 1.512 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `va2rq_session`
      WHERE `session_id` = X'3865656236666636616561623861383665356230626161626336323930316166'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 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: 0.44 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.517 MB
    INSERT INTO `va2rq_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3865656236666636616561623861383665356230626161626336323930316166', 1, 1675455095, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `va2rq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865656236666636616561623861383665356230626161626336323930316166', 1, 1675455095, 0, '', 0)
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.02 ms
    Update0.09 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.03 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.60 ms After last query: 1.42 ms Query memory: 0.021 MB Memory before query: 1.602 MB Rows returned: 6
    SELECT id, rules
    
      FROM `va2rq_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL6
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.14 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.05 ms
    Reset for next command0.05 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.57 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.615 MB Rows returned: 2
    SELECT b.id
    
      FROM va2rq_usergroups AS a
      LEFT JOIN va2rq_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 13
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.11 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 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.60 ms After last query: 10.31 ms Query memory: 0.021 MB Memory before query: 4.271 MB Rows returned: 1
    SELECT lft,rgt 
      FROM va2rq_categories
      WHERE id=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_categoriesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.11 ms
    After opening tables0.02 ms
    System lock0.02 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.01 ms
    Statistics0.08 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 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:100
    8require_once JROOT/administrator/components/com_flexicontent/defineconstants.phpJROOT/plugins/system/flexisystem/flexisystem.php:19
    7require_once JROOT/plugins/system/flexisystem/flexisystem.phpJROOT/libraries/src/Plugin/PluginHelper.php:251
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.72 ms After last query: 8.46 ms Query memory: 0.022 MB Memory before query: 4.493 MB Rows returned: 1
    SELECT `params`
    
      FROM `va2rq_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jchoptimize'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.16 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/libraries/fof40/Params/Params.php:55
    12FOF40\Params\Params->reload()JROOT/libraries/fof40/Params/Params.php:40
    11FOF40\Params\Params->__construct()JROOT/libraries/fof40/Container/Container.php:281
    10FOF40\Container\Container->FOF40\Container\{closure}()JROOT/libraries/fof40/Pimple/Container.php:115
    9FOF40\Pimple\Container->offsetGet()JROOT/libraries/fof40/Container/ContainerBase.php:27
    8FOF40\Container\ContainerBase->__get()JROOT/plugins/system/jchoptimize/jchoptimize.php:124
    7plgSystemJchoptimize->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    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.99 ms After last query: 14.09 ms Query memory: 0.021 MB Memory before query: 4.621 MB Rows returned: 1
    SELECT DISTINCT userid 
      FROM va2rq_session
      WHERE guest=0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_sessionindexNULLuserid5NULL116Using where
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.04 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.41 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/plugins/system/flexisystem/flexisystem.php:1382
    9plgSystemFlexisystem->checkinRecords()JROOT/plugins/system/flexisystem/flexisystem.php:206
    8plgSystemFlexisystem->onAfterInitialise()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:668
    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.]

  9. Query Time: 1.51 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 4.627 MB Rows returned: 0
    SELECT id, checked_out, checked_out_time 
      FROM va2rq_content
      WHERE checked_out > 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_contentrangeidx_checkoutidx_checkout4NULL1Using index condition
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.17 ms
    After opening tables0.01 ms
    System lock0.03 ms
    table lock0.01 ms
    init0.04 ms
    Optimizing0.02 ms
    Statistics0.85 ms
    Preparing0.03 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.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/flexisystem/flexisystem.php:1395
    9plgSystemFlexisystem->checkinRecords()JROOT/plugins/system/flexisystem/flexisystem.php:206
    8plgSystemFlexisystem->onAfterInitialise()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:668
    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.]

  10. Query Time: 0.62 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.632 MB Rows returned: 0
    SELECT id, checked_out, checked_out_time 
      FROM va2rq_categories
      WHERE checked_out > 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_categoriesrangeidx_checkoutidx_checkout4NULL1Using index condition
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.10 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/flexisystem/flexisystem.php:1395
    9plgSystemFlexisystem->checkinRecords()JROOT/plugins/system/flexisystem/flexisystem.php:206
    8plgSystemFlexisystem->onAfterInitialise()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:668
    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.]

  11. Query Time: 0.56 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 4.638 MB Rows returned: 1
    SELECT id, checked_out, checked_out_time 
      FROM va2rq_modules
      WHERE checked_out > 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_modulesALLNULLNO INDEX KEY COULD BE USEDNULLNULL79Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.08 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.10 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/flexisystem/flexisystem.php:1395
    9plgSystemFlexisystem->checkinRecords()JROOT/plugins/system/flexisystem/flexisystem.php:206
    8plgSystemFlexisystem->onAfterInitialise()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:668
    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.]

  12. Query Time: 0.55 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 4.644 MB Rows returned: 0
    SELECT id, checked_out, checked_out_time 
      FROM va2rq_menu
      WHERE checked_out > 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_menuALLNULLNO INDEX KEY COULD BE USEDNULLNULL373Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.21 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/flexisystem/flexisystem.php:1395
    9plgSystemFlexisystem->checkinRecords()JROOT/plugins/system/flexisystem/flexisystem.php:206
    8plgSystemFlexisystem->onAfterInitialise()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:668
    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.]

  13. Query Time: 0.50 ms After last query: 6.07 ms Query memory: 0.022 MB Memory before query: 4.839 MB Rows returned: 0
    SELECT i.id
    
      FROM `va2rq_flexicontent_tags` AS i
      WHERE i.`alias` = '490-voodoo'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEirefaliasalias767const1Using index condition
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.12 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.03 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/router.php:1067
    13_FlexicontentSiteRouter->_fc_route_getRecordIdByAlias()JROOT/components/com_flexicontent/router.php:1158
    12_FlexicontentSiteRouter->_fc_route_addRecordIdPrefix()JROOT/components/com_flexicontent/router.php:772
    11_FlexicontentSiteRouter->FLEXIcontentParseRoute()JROOT/components/com_flexicontent/router.php:37
    10FLEXIcontentParseRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9Joomla\CMS\Component\Router\RouterLegacy->parse()JROOT/libraries/src/Router/SiteRouter.php:438
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:139
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1142
    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.]

  14. Query Time: 1.32 ms After last query: 0.49 ms Query memory: 0.027 MB Memory before query: 4.850 MB Rows returned: 40
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `va2rq_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_banners','com_cache','com_carouselck','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_flexicontent','com_installer','com_jchoptimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_assetsrangeidx_asset_nameidx_asset_name202NULL41Using index condition
    Profile
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.16 ms
    After opening tables0.02 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.07 ms
    Optimizing0.04 ms
    Statistics0.14 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.48 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    15Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    14Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    13Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    12Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    11Joomla\CMS\User\User->authorise()JROOT/plugins/system/advancedmodules/src/Document.php:30
    10RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()JROOT/plugins/system/advancedmodules/advancedmodules.php:95
    9PlgSystemAdvancedModules->handleOnAfterRoute()JROOT/libraries/regularlabs/src/SystemPlugin.php:191
    8RegularLabs\Library\SystemPlugin->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.]

  15. Query Time: 0.50 ms After last query: 0.79 ms Query memory: 0.006 MB Memory before query: 4.920 MB
    UPDATE `va2rq_extensions`
    
      SET `params` = '{\"mediaversion\":\"60f3805eacf2d9beb84b733a0156b45f\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `va2rq_extensions` SET `params` = '{\"mediaversion\":\"60f3805eacf2d9beb84b733a0156b45f\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.03 ms
    table lock0.01 ms
    init for update0.08 ms
    Updating0.09 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.02 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    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/wbamp/wbamp.php:404
    8plgSystemWbamp->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.]

  16. Query Time: 1.60 ms After last query: 1.55 ms Query memory: 0.019 MB Memory before query: 5.006 MB Rows returned: 6
    SELECT id, home, template, s.params
    
      FROM va2rq_template_styles as s
      LEFT JOIN va2rq_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_template,idx_client_id,idx_client_id_homeNO INDEX KEY COULD BE USEDNULLNULL8Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403lahe0874_db.s.template,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.65 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.06 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    init0.03 ms
    Optimizing0.05 ms
    Statistics0.10 ms
    Preparing0.05 ms
    Executing0.01 ms
    Sending data0.16 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 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.]

  17. Query Time: 1.56 ms After last query: 73.22 ms Query memory: 0.025 MB Memory before query: 7.034 MB Rows returned: 1
    SHOW VARIABLES LIKE '%ft_min_word_len%'
    Explain
    EXPLAIN not possible on query: SHOW VARIABLES LIKE '%ft_min_word_len%'
    Profile
    StatusDuration
    Starting0.07 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.02 ms
    Optimizing0.03 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Filling schema table1.00 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Removing tmp table0.02 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    16JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/models/category.php:279
    15FlexicontentModelCategory->populateRecordState()JROOT/components/com_flexicontent/models/category.php:176
    14FlexicontentModelCategory->__construct()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    13Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    12Joomla\CMS\MVC\Factory\LegacyFactory->createModel()JROOT/libraries/src/MVC/Controller/BaseController.php:559
    11Joomla\CMS\MVC\Controller\BaseController->createModel()JROOT/libraries/src/MVC/Controller/BaseController.php:728
    10Joomla\CMS\MVC\Controller\BaseController->getModel()JROOT/libraries/src/MVC/Controller/BaseController.php:616
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_flexicontent/controller.php:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.80 ms After last query: 0.60 ms Query memory: 0.023 MB Memory before query: 7.067 MB Rows returned: 1
    SELECT *, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM va2rq_flexicontent_tags AS t
      WHERE t.id = 490
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.23 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.05 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/models/category.php:2159
    13FlexicontentModelCategory->getTag()JROOT/components/com_flexicontent/models/category.php:1986
    12FlexicontentModelCategory->getCategory()JROOT/components/com_flexicontent/views/category/view.html.php:79
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.75 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.074 MB Rows returned: 1
    SELECT * 
      FROM va2rq_tags AS t
      WHERE t.id = 486
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.14 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.02 ms
    Statistics0.10 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.03 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/models/category.php:2174
    13FlexicontentModelCategory->getTag()JROOT/components/com_flexicontent/models/category.php:1986
    12FlexicontentModelCategory->getCategory()JROOT/components/com_flexicontent/views/category/view.html.php:79
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.62 ms After last query: 1.86 ms Query memory: 0.024 MB Memory before query: 7.730 MB Rows returned: 7
    SELECT template as folder, cfgname, attribs, layout as type 
      FROM va2rq_flexicontent_layouts_conf
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_layouts_confALLNULLNO INDEX KEY COULD BE USEDNULLNULL7
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.10 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/tmpl.php:408
    15flexicontent_tmpl::getLayoutparams()JROOT/components/com_flexicontent/models/category.php:2725
    14FlexicontentModelCategory->getLayoutparams()JROOT/components/com_flexicontent/models/category.php:2499
    13FlexicontentModelCategory->_loadCategoryParams()JROOT/components/com_flexicontent/models/category.php:2061
    12FlexicontentModelCategory->getCategory()JROOT/components/com_flexicontent/views/category/view.html.php:79
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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: 1.03 ms After last query: 0.59 ms Query memory: 0.042 MB Memory before query: 7.730 MB Rows returned: 4
    SELECT fi.* 
      FROM va2rq_flexicontent_fields AS fi
      WHERE fi.published = 1
      AND fi.isfilter = 1
      AND fi.access IN (0,1,1,5)
      ORDER BY fi.ordering, fi.name
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfiALLNULLNO INDEX KEY COULD BE USEDNULLNULL40Using where; Using filesort
    Profile
    StatusDuration
    Starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.08 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.06 ms
    Optimizing0.03 ms
    Statistics0.08 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.28 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.04 ms
    Reset for next command0.02 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:4862
    17FlexicontentFields::getFilters()JROOT/components/com_flexicontent/models/category.php:1366
    16FlexicontentModelCategory->_buildFiltersWhere()JROOT/components/com_flexicontent/models/category.php:1096
    15FlexicontentModelCategory->_buildItemWhere()JROOT/components/com_flexicontent/models/category.php:544
    14FlexicontentModelCategory->_buildQuery()JROOT/components/com_flexicontent/models/category.php:365
    13FlexicontentModelCategory->getData()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/category/view.html.php:130
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.18 ms After last query: 2.42 ms Query memory: 0.023 MB Memory before query: 7.742 MB Rows returned: 1
    SELECT FOUND_ROWS()
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNo tables used
    Profile
    StatusDuration
    Starting0.20 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    After opening tables0.01 ms
    System lock0.02 ms
    table lock0.02 ms
    init0.11 ms
    Optimizing0.09 ms
    Statistics0.53 ms
    Preparing0.06 ms
    Creating tmp table0.03 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.12 ms
    Creating sort index0.02 ms
    Removing tmp table0.01 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/components/com_flexicontent/models/category.php:402
    13FlexicontentModelCategory->getData()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/category/view.html.php:130
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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: 1.40 ms After last query: 0.10 ms Query memory: 0.086 MB Memory before query: 7.750 MB Rows returned: 1
    SELECT i.*, ie.*, u.name as author, ty.name AS typename, ty.alias AS typealias, rel.catid as rel_catid, c.title AS maincat_title, c.alias AS maincat_alias, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, c.access as category_access, ty.access as type_access, 1 AS has_access
      FROM va2rq_content AS i JOIN va2rq_flexicontent_items_ext AS ie
      ON ie.item_id = i.id JOIN va2rq_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl
      ON tagtbl.id = tag.tid
      AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty
      ON ie.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel
      ON rel.itemid = i.id JOIN va2rq_categories AS c
      ON c.id = i.catid
      LEFT JOIN va2rq_users AS u
      ON u.id = i.created_by
      WHERE i.id IN (239)
      GROUP BY i.id
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARY,idx_catidPRIMARY4const1
    1SIMPLEieconstPRIMARY,type_idPRIMARY4const1
    1SIMPLEtyconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLErelrefitemiditemid4const1
    1SIMPLEtagrefPRIMARY,tid,itemiditemid4const13
    1SIMPLEtagtbleq_refPRIMARY,publishedPRIMARY4lahe0874_db.tag.tid1Using where
    Profile
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/models/category.php:432
    13FlexicontentModelCategory->getData()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/category/view.html.php:130
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.64 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 7.795 MB Rows returned: 1
    SELECT a.id as id, k.id as original_id 
      FROM va2rq_associations AS a JOIN va2rq_associations AS k
      ON a.`key`=k.`key` JOIN va2rq_content AS i
      ON i.id = k.id
      AND i.language = 'fr-FR'
      WHERE a.id IN (239)
      AND a.context = "com_content.item"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_keyPRIMARY206const,const1
    1SIMPLEkrefidx_keyidx_key128const2Using index
    1SIMPLEieq_refPRIMARY,idx_languagePRIMARY4lahe0874_db.k.id1Using where
    Profile
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.12 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.08 ms
    Optimizing0.04 ms
    Statistics0.27 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.09 ms
    Executing0.01 ms
    Sending data0.43 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.02 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:1062
    14flexicontent_db::getOriginalContentItemids()JROOT/components/com_flexicontent/models/category.php:442
    13FlexicontentModelCategory->getData()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/category/view.html.php:130
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.95 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 7.801 MB Rows returned: 1
    SELECT DISTINCT LOWER(SUBSTRING(i.title 
      FROM 1 FOR 1)) AS alpha
      FROM va2rq_flexicontent_items_tmp AS i JOIN va2rq_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl
      ON tagtbl.id = tag.tid
      AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty
      ON i.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel
      ON rel.itemid = i.id JOIN va2rq_categories AS c
      ON c.id = i.catid
      WHERE 1
      AND tag.tid = '490'
      AND ( i.state IN (1, -5) )
      AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) )
      AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) )
      AND (i .language = 'en-GB' OR i.language = '*')
      AND ty.access IN (0,1,1,5)
      AND c.access IN (0,1,1,5)
      AND i.access IN (0,1,1,5)
      ORDER BY alpha ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtagrefPRIMARY,tid,itemidPRIMARY4const1Using index; Using temporary; Using filesort
    1SIMPLEieq_refPRIMARY,state,catid,access,language,type_idPRIMARY4lahe0874_db.tag.itemid1Using index condition; Using where
    1SIMPLEtyeq_refPRIMARY,accessPRIMARY4lahe0874_db.i.type_id1Using where; Distinct
    1SIMPLEceq_refPRIMARY,idx_accessPRIMARY4lahe0874_db.i.catid1Using where; Distinct
    1SIMPLErelrefitemiditemid4lahe0874_db.i.id1Using where; Using index; Distinct
    1SIMPLEtagtbleq_refPRIMARY,publishedPRIMARY4lahe0874_db.tag.tid1Using where; Distinct
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.15 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    14JDatabaseDriver->loadColumn()JROOT/components/com_flexicontent/models/category.php:2759
    13FlexicontentModelCategory->getAlphaindex()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_flexicontent/views/category/view.html.php:134
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.46 ms After last query: 3.33 ms Query memory: 0.024 MB Memory before query: 7.832 MB Rows returned: 2
    SELECT DISTINCT lc.lang_id as id, lc.image as image_prefix, lc.lang_code as code, lc.title_native, lc.sef,lc.title as name
    
      FROM va2rq_languages as lc
      WHERE 1
      ORDER BY lc.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLElcALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using filesort
    Profile
    StatusDuration
    Starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.05 ms
    Statistics0.27 ms
    Preparing0.05 ms
    Creating tmp table0.02 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.08 ms
    Creating sort index0.02 ms
    Removing tmp table0.01 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 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:1857
    13flexicontent_html::loadFramework()JROOT/components/com_flexicontent/classes/helpers/html.php:1881
    12flexicontent_html::loadFramework()JROOT/components/com_flexicontent/views/category/view.html.php:177
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.42 ms After last query: 1.45 ms Query memory: 0.024 MB Memory before query: 7.852 MB Rows returned: 16
    SELECT t.tid, t.itemid 
      FROM va2rq_flexicontent_tags_item_relations AS t
      WHERE t.itemid IN (239)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtrefitemiditemid4const13
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1407
    14FlexicontentFields::_getTags()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:306
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.65 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 7.868 MB Rows returned: 16
    SELECT DISTINCT t.id, t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM va2rq_flexicontent_tags AS t JOIN va2rq_flexicontent_tags_item_relations AS i
      ON i.tid = t.id
      WHERE i.itemid IN (239)
      AND t.published = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEirefPRIMARY,tid,itemiditemid4const13Using temporary
    1SIMPLEteq_refPRIMARY,publishedPRIMARY4lahe0874_db.i.tid1Using where
    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.04 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1423
    14FlexicontentFields::_getTags()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:306
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.30 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 7.876 MB Rows returned: 1
    SELECT c.catid, c.itemid 
      FROM va2rq_flexicontent_cats_item_relations AS c
      WHERE c.itemid IN (239)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrefitemiditemid4const1
    Profile
    StatusDuration
    Starting0.06 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.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Creating tmp table0.04 ms
    Executing0.01 ms
    Sending data0.21 ms
    Removing tmp table0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1494
    14FlexicontentFields::_getCategories()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:307
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.45 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.885 MB Rows returned: 1
    SELECT DISTINCT c.id, c.title, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM va2rq_categories AS c JOIN va2rq_flexicontent_cats_item_relations AS rel
      ON rel.catid = c.id
      WHERE rel.itemid IN (239)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLErelrefPRIMARY,catid,itemiditemid4const1Using temporary
    1SIMPLEceq_refPRIMARYPRIMARY4lahe0874_db.rel.catid1
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1511
    14FlexicontentFields::_getCategories()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:307
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.29 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 7.892 MB Rows returned: 0
    SELECT DISTINCT itemid, 1 AS favs 
      FROM va2rq_flexicontent_favourites
      WHERE type = 0
      AND itemid IN ('239')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    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.02 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Creating tmp table0.03 ms
    Executing0.01 ms
    Sending data0.06 ms
    Removing tmp table0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1543
    14FlexicontentFields::_getFavourites()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:308
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.26 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 7.901 MB Rows returned: 0
    SELECT DISTINCT itemid, 1 AS fav 
      FROM va2rq_flexicontent_favourites
      WHERE type = 0
      AND itemid IN (239)
      AND userid = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1577
    14FlexicontentFields::_getFavoured()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:309
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.36 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 7.915 MB Rows returned: 1
    SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email 
      FROM va2rq_content AS i
      LEFT JOIN va2rq_users AS u
      ON u.id = i.created_by
      WHERE i.id IN ('239')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.03 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:1637
    14FlexicontentFields::_getAuthors()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:310
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.35 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 7.924 MB Rows returned: 1
    SELECT i.id, u.name, u.username, u.email 
      FROM va2rq_content AS i
      LEFT JOIN va2rq_users AS u
      ON u.id = i.modified_by
      WHERE i.id IN ('239')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    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.02 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 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:1611
    14FlexicontentFields::_getModifiers()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:311
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  35. Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 7.932 MB Rows returned: 1
    SELECT id, name 
      FROM va2rq_flexicontent_types
      WHERE id IN ('2')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_typesconstPRIMARYPRIMARY4const1
    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.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.03 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:1661
    14FlexicontentFields::_getTypenames()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:312
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  36. Query Time: 0.32 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.940 MB Rows returned: 0
    SELECT * 
      FROM va2rq_content_rating
      WHERE content_id IN ('239')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.03 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.03 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1693
    14FlexicontentFields::_getVotes()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:313
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  37. Query Time: 0.30 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 7.947 MB Rows returned: 0
    SELECT *, field_id as extra_id 
      FROM va2rq_flexicontent_items_extravote
      WHERE content_id IN ('239')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1699
    14FlexicontentFields::_getVotes()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:313
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  38. Query Time: 0.91 ms After last query: 0.06 ms Query memory: 0.041 MB Memory before query: 7.955 MB Rows returned: 26
    SELECT field_id, value, item_id, valueorder, suborder 
      FROM va2rq_flexicontent_fields_item_relations
      WHERE item_id IN (239)
      AND value > ""
      ORDER BY item_id, field_id, valueorder, suborder
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_fields_item_relationsrefitem_id,valueitem_id4const23Using where; Using filesort
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1284
    14FlexicontentFields::_getCustomValues()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:314
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  39. Query Time: 1.64 ms After last query: 0.13 ms Query memory: 0.101 MB Memory before query: 7.989 MB Rows returned: 40
    SELECT fi.*, 
      CASE WHEN fi.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_access
      FROM va2rq_flexicontent_fields AS fi JOIN va2rq_flexicontent_fields_type_relations AS ftrel
      ON ftrel.field_id = fi.id
      AND ftrel.type_id = 2
      WHERE fi.published = 1
      GROUP BY fi.id
      ORDER BY ftrel.ordering, fi.ordering, fi.name
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEftrelALLPRIMARY,field_id,type_idNO INDEX KEY COULD BE USEDNULLNULL54Using where; Using temporary; Using filesort
    1SIMPLEfieq_refPRIMARYPRIMARY4lahe0874_db.ftrel.field_id1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.09 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.44 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.03 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:355
    13FlexicontentFields::getItemFields()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:125
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  40. Query Time: 0.44 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 8.155 MB Rows returned: 5
    SELECT * 
      FROM va2rq_flexicontent_templates
      WHERE template = 'liste-cases'
      AND layout = 'category'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_templatesrefconfigurationconfiguration152const5Using index condition
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 ms
    init0.04 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.70 ms
    Creating sort index0.32 ms
    Removing tmp table0.10 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/tmpl.php:506
    14flexicontent_tmpl::getFieldsByPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1146
    13FlexicontentFields::renderPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  41. Query Time: 0.34 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 8.172 MB Rows returned: 14
    SELECT field_type 
      FROM va2rq_flexicontent_fields
      WHERE iscore=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_fieldsALLNULLNO INDEX KEY COULD BE USEDNULLNULL40Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    17JDatabaseDriver->loadColumn()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1856
    16FlexicontentFields::_getTypeToCoreFieldParams()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1766
    15FlexicontentFields::loadFieldConfig()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:785
    14FlexicontentFields::renderField()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1173
    13FlexicontentFields::renderPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  42. Query Time: 0.30 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 8.182 MB Rows returned: 1
    SELECT t.attribs, t.name, t.alias 
      FROM va2rq_flexicontent_types AS t
      WHERE t.id = 2
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.03 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.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    17JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1866
    16FlexicontentFields::_getTypeToCoreFieldParams()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1766
    15FlexicontentFields::loadFieldConfig()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:785
    14FlexicontentFields::renderField()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1173
    13FlexicontentFields::renderPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  43. Query Time: 0.39 ms After last query: 0.31 ms Query memory: 0.024 MB Memory before query: 8.219 MB Rows returned: 0
    SELECT attribs, published 
      FROM va2rq_flexicontent_fields
      WHERE name='text_fiche-album'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_fieldsALLNULLNO INDEX KEY COULD BE USEDNULLNULL40Using where
    Profile
    StatusDuration
    Starting0.03 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.03 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    16JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1819
    15FlexicontentFields::loadFieldConfig()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:785
    14FlexicontentFields::renderField()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1173
    13FlexicontentFields::renderPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  44. Query Time: 0.56 ms After last query: 8.84 ms Query memory: 0.026 MB Memory before query: 8.940 MB Rows returned: 2
    SELECT a.sef AS sef,a.lang_code AS lang_code
    
      FROM va2rq_languages AS a
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL2
    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.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.07 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/helpers/route.php:217
    19FlexicontentHelperRoute::_buildLanguageLookup()JROOT/components/com_flexicontent/helpers/route.php:356
    18FlexicontentHelperRoute::getItemRoute()JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.php:23
    17include JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.phpJROOT/plugins/flexicontent_fields/image/image.php:1867
    16plgFlexicontent_fieldsImage->onDisplayFieldValue()JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:428
    15FLEXIUtilities::call_FC_Field_Func()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:861
    14FlexicontentFields::renderField()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1230
    13FlexicontentFields::renderPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  45. Query Time: 0.44 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 8.951 MB Rows returned: 2
    SELECT t.attribs, t.id
    
      FROM va2rq_flexicontent_types AS t
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLNULLNO INDEX KEY COULD BE USEDNULLNULL2
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.06 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.03 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/helpers/route.php:293
    19FlexicontentHelperRoute::_getTypeParams()JROOT/components/com_flexicontent/helpers/route.php:384
    18FlexicontentHelperRoute::getItemRoute()JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.php:23
    17include JROOT/plugins/flexicontent_fields/image/tmpl/value_link_to_item.phpJROOT/plugins/flexicontent_fields/image/image.php:1867
    16plgFlexicontent_fieldsImage->onDisplayFieldValue()JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:428
    15FLEXIUtilities::call_FC_Field_Func()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:861
    14FlexicontentFields::renderField()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1230
    13FlexicontentFields::renderPositions()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:160
    12FlexicontentFields::getFields()JROOT/components/com_flexicontent/views/category/view.html.php:243
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  46. Query Time: 0.53 ms After last query: 1.63 ms Query memory: 0.022 MB Memory before query: 9.136 MB Rows returned: 1
    SELECT c.id 
      FROM va2rq_categories AS c
      WHERE id IN (81,80)
      AND id NOT IN (81)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrangePRIMARYPRIMARY4NULL2Using where; Using index
    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.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 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.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.04 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    13JDatabaseDriver->loadColumn()JROOT/components/com_flexicontent/classes/helpers/html.php:5639
    12flexicontent_html::calculateItemMarkups()JROOT/components/com_flexicontent/views/category/view.html.php:251
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  47. Query Time: 0.44 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 9.144 MB Rows returned: 6
    SELECT id, title 
      FROM va2rq_viewlevels
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_viewlevelsindexNULLidx_assetgroup_title_lookup402NULL6Using index
    Profile
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.03 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.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.08 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:78
    13flexicontent_db::getAccessNames()JROOT/components/com_flexicontent/classes/helpers/html.php:5652
    12flexicontent_html::calculateItemMarkups()JROOT/components/com_flexicontent/views/category/view.html.php:251
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  48. Query Time: 0.40 ms After last query: 1.29 ms Query memory: 0.022 MB Memory before query: 9.244 MB Rows returned: 2
    SELECT t.id, t.attribs 
      FROM va2rq_flexicontent_types AS t
      WHERE 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLNULLNO INDEX KEY COULD BE USEDNULLNULL2
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/db.php:148
    12flexicontent_db::getTypeAttribs()JROOT/components/com_flexicontent/views/category/view.html.php:583
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  49. Query Time: 0.46 ms After last query: 0.93 ms Query memory: 0.028 MB Memory before query: 9.379 MB Rows returned: 0
    SELECT f.*  
      FROM va2rq_flexicontent_fields AS f
      WHERE f.published = 1
      AND f.field_type = "fieldgroup"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfALLNULLNO INDEX KEY COULD BE USEDNULLNULL40Using where
    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.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.03 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:5593
    21FlexicontentFields::getFieldsPerGroup()JROOT/components/com_flexicontent/tmpl_common/filters.php:25
    20include JROOT/components/com_flexicontent/tmpl_common/filters.phpJROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.php:14
    19include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form_body.phpJROOT/components/com_flexicontent/tmpl_common/listings_filter_form.php:16
    18include JROOT/components/com_flexicontent/tmpl_common/listings_filter_form.phpJROOT/components/com_flexicontent/templates/liste-cases/category_items.php:88
    17include JROOT/components/com_flexicontent/templates/liste-cases/category_items.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/components/com_flexicontent/tmpl_common/category.php:120
    15include JROOT/components/com_flexicontent/tmpl_common/category.phpJROOT/components/com_flexicontent/templates/liste-cases/category.php:3
    14include JROOT/components/com_flexicontent/templates/liste-cases/category.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/category/view.html.php:1175
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  50. Query Time: 1.01 ms After last query: 1.75 ms Query memory: 0.071 MB Memory before query: 9.440 MB Rows returned: 287
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `va2rq_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_assetsALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL664Using where
    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.02 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.08 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    23Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    22Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    21Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    20Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    19Joomla\CMS\User\User->authorise()JROOT/components/com_flexicontent/classes/helpers/html.php:3281
    18flexicontent_html::editbutton()JROOT/components/com_flexicontent/templates/liste-cases/category_items.php:598
    17include JROOT/components/com_flexicontent/templates/liste-cases/category_items.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/components/com_flexicontent/tmpl_common/category.php:120
    15include JROOT/components/com_flexicontent/tmpl_common/category.phpJROOT/components/com_flexicontent/templates/liste-cases/category.php:3
    14include JROOT/components/com_flexicontent/templates/liste-cases/category.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/category/view.html.php:1175
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  51. Query Time: 0.41 ms After last query: 8.43 ms Query memory: 0.027 MB Memory before query: 10.431 MB Rows returned: 0
    SELECT catid  
      FROM va2rq_content
      WHERE id = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.09 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.61 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    22JDatabaseDriver->loadResult()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:280
    21ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:217
    20ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    19FlexicontentModelItem->__construct()JROOT/components/com_flexicontent/classes/helpers/html.php:2867
    18flexicontent_html::statebutton()JROOT/components/com_flexicontent/templates/liste-cases/category_items.php:603
    17include JROOT/components/com_flexicontent/templates/liste-cases/category_items.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    16Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/components/com_flexicontent/tmpl_common/category.php:120
    15include JROOT/components/com_flexicontent/tmpl_common/category.phpJROOT/components/com_flexicontent/templates/liste-cases/category.php:3
    14include JROOT/components/com_flexicontent/templates/liste-cases/category.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/category/view.html.php:1175
    11FlexicontentViewCategory->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:1361
    8FlexicontentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_flexicontent/flexicontent.php:265
    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.]

  52. Query Time: 0.70 ms After last query: 2.01 ms Query memory: 0.021 MB Memory before query: 10.400 MB Rows returned: 3
    SELECT language,id
    
      FROM `va2rq_menu`
      WHERE home = 1
      AND published = 1
      AND client_id = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_menuALLidx_client_id_parent_id_alias_languageNO INDEX KEY COULD BE USEDNULLNULL373Using where
    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.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    9JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/Multilanguage.php:107
    8Joomla\CMS\Language\Multilanguage::getSiteHomePages()JROOT/plugins/system/languagefilter/languagefilter.php:751
    7PlgSystemLanguageFilter->onAfterDispatch()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/SiteApplication.php:199
    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.]

  53. Query Time: 1.67 ms After last query: 1.32 ms Query memory: 0.063 MB Memory before query: 10.424 MB Rows returned: 41
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM va2rq_modules AS m
      LEFT JOIN va2rq_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      LEFT JOIN va2rq_advancedmodules as am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND e.enabled = 1
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefpublished,newsfeeds,idx_languagepublished1const48Using index condition; Using where; Using filesort
    1SIMPLEameq_refPRIMARYPRIMARY4lahe0874_db.m.id1Using where
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403lahe0874_db.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.26 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
    14PlgSystemAdvancedModuleHelper->getModuleList()JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
    13PlgSystemAdvancedModuleHelper->onPrepareModuleList()JROOT/libraries/joomla/event/dispatcher.php:165
    12JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    11Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Helper/ModuleHelper.php:366
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/templatefiche/index.php:80
    7require JROOT/templates/templatefiche/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    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.]

  54. Query Time: 0.65 ms After last query: 133.30 ms Query memory: 0.023 MB Memory before query: 11.059 MB Rows returned: 0
    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `va2rq_menu` AS `c`
      INNER JOIN `va2rq_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `va2rq_associations` AS `a2`
      ON `a`.`key` = `a2`.`key`
      INNER JOIN `va2rq_menu` AS `c2`
      ON a2.id = c2.`id`
      WHERE c.id = 575
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.07 ms
    Optimizing0.05 ms
    Statistics0.14 ms
    Preparing0.05 ms
    Sorting result0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.90 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/Associations.php:115
    13Joomla\CMS\Language\Associations::getAssociations()JROOT/administrator/components/com_menus/helpers/menus.php:321
    12MenusHelper::getAssociations()JROOT/modules/mod_languages/helper.php:58
    11ModLanguagesHelper::getList()JROOT/modules/mod_languages/mod_languages.php:17
    10include JROOT/modules/mod_languages/mod_languages.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:500
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

  55. Query Time: 0.55 ms After last query: 1.77 ms Query memory: 0.035 MB Memory before query: 11.098 MB Rows returned: 132
    SELECT * 
      FROM va2rq_acymailing_config
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_acymailing_configALLNULLNO INDEX KEY COULD BE USEDNULLNULL132
    Profile
    StatusDuration
    Starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.11 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/compat/joomla.php:464
    15acymailing_loadObjectList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    14cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:434
    13acymailing_config()JROOT/administrator/components/com_acymailing/compat/joomla.php:803
    12include_once JROOT/administrator/components/com_acymailing/compat/joomla.phpJROOT/administrator/components/com_acymailing/helpers/helper.php:21
    11include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/modules/mod_acymailing/mod_acymailing.php:12
    10include JROOT/modules/mod_acymailing/mod_acymailing.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:500
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

  56. Query Time: 0.54 ms After last query: 3.02 ms Query memory: 0.023 MB Memory before query: 11.571 MB Rows returned: 2
    SELECT * 
      FROM va2rq_acymailing_list
      WHERE type = 'list'
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_acymailing_listreftypeorderingindex,typeuseridindextypeorderingindex1const2Using index condition; Using where
    Profile
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.17 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/compat/joomla.php:464
    12acymailing_loadObjectList()JROOT/administrator/components/com_acymailing/classes/list.php:30
    11listClass->getLists()JROOT/modules/mod_acymailing/mod_acymailing.php:104
    10include JROOT/modules/mod_acymailing/mod_acymailing.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:500
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

55 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `va2rq_assets`
  2. 1 × SELECT `data` 
      FROM `va2rq_session`
  3. 1 × SELECT `session_id` 
      FROM `va2rq_session`
  4. 1 × SELECT id, rules 
      FROM `va2rq_viewlevels
  5. 1 × SELECT b.id 
      FROM va2rq_usergroups AS a
      LEFT JOIN va2rq_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  6. 1 × SELECT lft,rgt 
      FROM va2rq_categories
  7. 1 × SELECT `params` 
      FROM `va2rq_extensions`
  8. 1 × SELECT DISTINCT userid 
      FROM va2rq_session
  9. 1 × SELECT id, checked_out, checked_out_time 
      FROM va2rq_content
  10. 1 × SELECT id, checked_out, checked_out_time 
      FROM va2rq_categories
  11. 1 × SELECT id, checked_out, checked_out_time 
      FROM va2rq_modules
  12. 1 × SELECT id, checked_out, checked_out_time 
      FROM va2rq_menu
  13. 1 × SELECT i.id 
      FROM `va2rq_flexicontent_tags` AS i
  14. 1 × SELECT id, home, template, s.params 
      FROM va2rq_template_styles as s
      LEFT JOIN va2rq_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  15. 1 × SELECT *, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM va2rq_flexicontent_tags AS t
  16. 1 × SELECT * 
      FROM va2rq_tags AS t
  17. 1 × SELECT template as folder, cfgname, attribs, layout as type 
      FROM va2rq_flexicontent_layouts_con
  18. 1 × SELECT fi.* 
      FROM va2rq_flexicontent_fields AS fi
  19. 1 × SELECT FOUND_ROWS(
  20. 1 × SELECT i.*, ie.*, u.name as author, ty.name AS typename, ty.alias AS typealias, rel.catid as rel_catid, c.title AS maincat_title, c.alias AS maincat_alias, 
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, c.access as category_access, ty.access as type_access, 1 AS has_access
      FROM va2rq_content AS i JOIN va2rq_flexicontent_items_ext AS ie
      ON ie.item_id = i.id JOIN va2rq_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl
      ON tagtbl.id = tag.tid
      AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty
      ON ie.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel
      ON rel.itemid = i.id JOIN va2rq_categories AS c
      ON c.id = i.catid
      LEFT JOIN va2rq_users AS u
      ON u.id = i.created_by
  21. 1 × SELECT a.id as id, k.id as original_id 
      FROM va2rq_associations AS a JOIN va2rq_associations AS k
      ON a.`key`=k.`key` JOIN va2rq_content AS i
      ON i.id = k.id
      AND i.language = 'fr-FR'
  22. 1 × SELECT DISTINCT LOWER(SUBSTRING(i.title 
      FROM 1 FOR 1)) AS alpha
      FROM va2rq_flexicontent_items_tmp AS i JOIN va2rq_flexicontent_tags_item_relations AS tag
      ON tag.itemid = i.id JOIN va2rq_flexicontent_tags AS tagtbl
      ON tagtbl.id = tag.tid
      AND tagtbl.published = 1 JOIN va2rq_flexicontent_types AS ty
      ON i.type_id = ty.id JOIN va2rq_flexicontent_cats_item_relations AS rel
      ON rel.itemid = i.id JOIN va2rq_categories AS c
      ON c.id = i.catid
  23. 1 × SELECT DISTINCT lc.lang_id as id, lc.image as image_prefix, lc.lang_code as code, lc.title_native, lc.sef,lc.title as name 
      FROM va2rq_languages as lc
  24. 1 × SELECT t.tid, t.itemid 
      FROM va2rq_flexicontent_tags_item_relations AS t
  25. 1 × SELECT DISTINCT t.id, t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug
      FROM va2rq_flexicontent_tags AS t JOIN va2rq_flexicontent_tags_item_relations AS i
      ON i.tid = t.id
  26. 1 × SELECT c.catid, c.itemid 
      FROM va2rq_flexicontent_cats_item_relations AS c
  27. 1 × SELECT DISTINCT c.id, c.title, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM va2rq_categories AS c JOIN va2rq_flexicontent_cats_item_relations AS rel
      ON rel.catid = c.id
  28. 1 × SELECT DISTINCT itemid, 1 AS favs 
      FROM va2rq_flexicontent_favourites
  29. 1 × SELECT DISTINCT itemid, 1 AS fav 
      FROM va2rq_flexicontent_favourites
  30. 1 × SELECT i.id, u.name, i.created_by_alias as alias, u.username, u.email 
      FROM va2rq_content AS i
      LEFT JOIN va2rq_users AS u
      ON u.id = i.created_by
  31. 1 × SELECT i.id, u.name, u.username, u.email 
      FROM va2rq_content AS i
      LEFT JOIN va2rq_users AS u
      ON u.id = i.modified_by
  32. 1 × SELECT id, name 
      FROM va2rq_flexicontent_types
  33. 1 × SELECT * 
      FROM va2rq_content_rating
  34. 1 × SELECT *, field_id as extra_id 
      FROM va2rq_flexicontent_items_extravote
  35. 1 × SELECT field_id, value, item_id, valueorder, suborder 
      FROM va2rq_flexicontent_fields_item_relations
  36. 1 × SELECT fi.*, 
      CASE WHEN fi.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_access
      FROM va2rq_flexicontent_fields AS fi JOIN va2rq_flexicontent_fields_type_relations AS ftrel
      ON ftrel.field_id = fi.id
      AND ftrel.type_id = 2
  37. 1 × SELECT * 
      FROM va2rq_flexicontent_templates
  38. 1 × SELECT field_type 
      FROM va2rq_flexicontent_fields
  39. 1 × SELECT t.attribs, t.name, t.alias 
      FROM va2rq_flexicontent_types AS t
  40. 1 × SELECT attribs, published 
      FROM va2rq_flexicontent_fields
  41. 1 × SELECT a.sef AS sef,a.lang_code AS lang_code 
      FROM va2rq_languages AS
  42. 1 × SELECT t.attribs, t.id 
      FROM va2rq_flexicontent_types AS
  43. 1 × SELECT c.id 
      FROM va2rq_categories AS c
  44. 1 × SELECT id, title 
      FROM va2rq_viewlevel
  45. 1 × SELECT t.id, t.attribs 
      FROM va2rq_flexicontent_types AS t
  46. 1 × SELECT f.*  
      FROM va2rq_flexicontent_fields AS f
  47. 1 × SELECT catid  
      FROM va2rq_content
  48. 1 × SELECT language,id 
      FROM `va2rq_menu`
  49. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
      FROM va2rq_modules AS m
      LEFT JOIN va2rq_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      LEFT JOIN va2rq_advancedmodules as am
      ON am.moduleid = m.id
  50. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `va2rq_menu` AS `c`
      INNER JOIN `va2rq_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `va2rq_associations` AS `a2`
      ON `a`.`key` = `a2`.`key`
      INNER JOIN `va2rq_menu` AS `c2`
      ON a2.id = c2.`id`
  51. 1 × SELECT * 
      FROM va2rq_acymailing_confi
  52. 1 × SELECT * 
      FROM va2rq_acymailing_list
OTHER Tables:
  1. 1 × INSERT INTO `va2rq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3865656236666636616561623861383665356230626161626336323930316166', 1, 1675455095, 0, '', 0
  2. 1 × UPDATE `va2rq_extensions` 
      SET `params` = '{\"mediaversion\":\"60f3805eacf2d9beb84b733a0156b45f\"}'
  3. 1 × SHOW VARIABLES LIKE '%ft_min_word_len%