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

Daran - Le Monde Perdu

How to wrap yourself in a record

Daran - Le Monde Perdu Image 1
  • 2014
  • Daran - Le Monde Perdu Image 1
  • 11

So Daran plays solo guitar-voice-harmonica? Those who only like the rock music side of the figure will be disappointed. With this "lost world", he risks losing some people. On the other hand, those who like his acoustic fringe too and the quality French chanson, will love it. It’s my case.
This formula obviously highlights the lyrics. When they’re good, it’s absolutely touching. I like what Daran tells me, whispers in my ears too.
For it’s an intimate album. Gentle and smooth. Perfect for winter. You’ll be able to wrap yourself into.
Sublime sleeve. And the design of the booklet is in accord.
Overall, it’s magnificently sung – even more than usual.

From start, the guitar small drop of "Gens du Voyage" stays in your head. The picture is outlined well. In 2014, it feels good to take up this topic.
"Gentil" may be the liveliest track of the album. Which just goes to show. A new portrait of a poor guy. You find lost souls like this again all along the album (but you were warned, hey! you are in Le monde perdu - the lost world).
As it happens, with the song "Le Monde Perdu" come the first tears of the album. When the slide guitar enters, it’s fated. And so good.
The tracks come one after another more or less luckily, from the very beautiful lalalala with 2 voices in "Des Portes", until "Une Sorte d'Église" in this pared-down version which matches very well the atmosphere of the album.
Well-made lyrics. Special mention to “Comfort contains its opposite” and to “Love ends up as tragedy or pot-au-feu”. You’re not there for fun.
Harmonica is everywhere and this is getting much to me, especially when ending with a lacklustre "Le Bal des Poulets".

As a conclusion, I’m going to stop listening to Daran: far too much joyful for me. I’m going to go back to real depressive music like David Guetta’s. At least he never plays solo guitar-voice-harmonica.



Daran - Le Monde Perdu Image 1

  • 52 minutes and no time to get bored when you’re able to listen. Each song is consistent, full, perfectly measured in its length: neither too short nor too long (except maybe a little at the end of the record).

  • Des Portes
    Gens du Voyage
    Le Monde Perdu
  • Le Bal des Poulets
  • The sentence

    “Le confort contient son contraire” ("Tchernobyl")

  • him
    www.daran.ca (177 Hits)
  • ...And now, listen!
    • www.deezer.com/album/8775851 (158 Hits)
    • open.spotify.com/album/58Jnavxr2EZZhPU6MGyX9S (149 Hits)
  • Tags
    Daran | acoustic | lyrics | French chanson | voice | guitar | harmonica | solo

  • To be appreciated too...
    Volo
    Avec Son Frère
        2020

    Not without my brother       Daran
    Interview
        2018

    Alignment of planets       Daran
    Endorphine
        2017

    Degrowth hormone

  • Created
    14 February 2016

Back to Top

© 2023 japprecie  -  Communicate  -  Links

×** [Flexisystem PLG: Adding css classes to BODY: 0.001 s]
0.000 seconds (0.000); 5.04 MB (5.038) - START: FLEXIcontent component
0.227 seconds (0.227); 11.47 MB (6.432) - END: FLEXIcontent component: (VIEW: item)

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

-- [FC Fields Rendering: 0.16 s]
0.002 stitle
0.000 smaintext
0.000 screated
0.000 screatedby
0.000 smodified
0.000 smodifiedby
0.000 shits
0.000 stype
0.000 sversion
0.000 sstate
0.002 svoting
0.001 sfavourites
0.000 scategories
0.001 stags
0.098 simage
0.043 stoolbar
0.002 stext
0.007 srelation - Field rendered other fields. Time was (retrieval+render)= 0.012 s
0.001 stextarea
0.002 sweblink
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": 1675452432,
                "last": 1675452432,
                "now": 1675452432
            },
            "token": "Jo3uBWLYJxk6W3YTL4lsA6il54aCfP8L"
        },
        "registry": {},
        "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: 11.36 ms / 11.36 ms Memory: 0.813 MB / 1.15 MB Application: afterLoad
Time: 33.14 ms / 44.50 ms Memory: 3.474 MB / 4.62 MB Application: afterInitialise
Time: 3.45 ms / 47.95 ms Memory: 0.186 MB / 4.81 MB Application: Before Access::preloadComponents (all components)
Time: 1.87 ms / 49.82 ms Memory: 0.060 MB / 4.87 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 49.86 ms Memory: -0.003 MB / 4.87 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.24 ms / 50.10 ms Memory: 0.013 MB / 4.88 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 2.84 ms / 52.94 ms Memory: 0.034 MB / 4.91 MB Application: afterRoute
Time: 0.87 ms / 53.81 ms Memory: 0.056 MB / 4.97 MB Application: beforeRenderComponent com_flexicontent
Time: 65.51 ms / 119.32 ms Memory: 3.840 MB / 8.81 MB Application: Before Access::preloadPermissions (com_content)
Time: 1.53 ms / 120.85 ms Memory: 0.269 MB / 9.08 MB Application: After Access::preloadPermissions (com_content)
Time: 0.03 ms / 120.88 ms Memory: -0.019 MB / 9.06 MB Application: Before Access::getAssetRules (id:327 name:com_content.article.92)
Time: 0.05 ms / 120.93 ms Memory: 0.008 MB / 9.07 MB Application: After Access::getAssetRules (id:327 name:com_content.article.92)
Time: 156.44 ms / 277.37 ms Memory: 2.390 MB / 11.46 MB Application: Before Access::getAssetRules (id:217 name:com_flexicontent)
Time: 0.14 ms / 277.51 ms Memory: 0.032 MB / 11.49 MB Application: After Access::getAssetRules (id:217 name:com_flexicontent)
Time: 3.73 ms / 281.24 ms Memory: -0.020 MB / 11.47 MB Application: afterRenderComponent com_flexicontent
Time: 4.05 ms / 285.28 ms Memory: 0.037 MB / 11.51 MB Application: afterDispatch
Time: 19.60 ms / 304.88 ms Memory: 1.102 MB / 12.61 MB Application: beforeRenderModule mod_languages (Sélecteur de langue)
Time: 2.88 ms / 307.77 ms Memory: 0.029 MB / 12.64 MB Application: afterRenderModule mod_languages (Sélecteur de langue)
Time: 0.04 ms / 307.81 ms Memory: -0.001 MB / 12.64 MB Application: beforeRenderModule mod_acymailing (AcyMailing Module)
Time: 4.48 ms / 312.29 ms Memory: 0.474 MB / 13.11 MB Application: afterRenderModule mod_acymailing (AcyMailing Module)
Time: 139.67 ms / 451.96 ms Memory: 0.112 MB / 13.22 MB Application: afterRender

Database queries total: 67.56 ms

Memory Usage

14.61 MB (15,316,688 Bytes)

Database Queries

121 Queries Logged 67.56 ms


35 duplicate found!

4 duplicates: #12  #16  #88  #89
2 duplicates: #40  #41
2 duplicates: #44  #107
2 duplicates: #45  #108
2 duplicates: #46  #109
2 duplicates: #47  #110
2 duplicates: #48  #111
2 duplicates: #49  #112
2 duplicates: #50  #113
2 duplicates: #51  #114
3 duplicates: #52  #83  #115
2 duplicates: #53  #116
2 duplicates: #54  #117
2 duplicates: #55  #118
2 duplicates: #91  #94
2 duplicates: #102  #103
  1. Query Time: 0.58 ms Query memory: 0.023 MB Memory before query: 1.498 MB Rows returned: 0
    SELECT `data`

      FROM `va2rq_session`

      WHERE `session_id` = X'3262396566633261316436626136396661336537613563653864386462353866'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_sessionconstPRIMARYPRIMARY194const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.42 ms After last query: 0.36 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'3262396566633261316436626136396661336537613563653864386462353866' 
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.42 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'3262396566633261316436626136396661336537613563653864386462353866', 1, 1675452432, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `va2rq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3262396566633261316436626136396661336537613563653864386462353866', 1, 1675452432, 0, '', 0)
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.61 ms After last query: 1.19 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
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.74 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
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.68 ms After last query: 10.51 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
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.86 ms After last query: 8.62 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
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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: 1.63 ms After last query: 6.11 ms Query memory: 0.027 MB Memory before query: 4.814 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
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.]
  9. Query Time: 0.73 ms After last query: 0.80 ms Query memory: 0.006 MB Memory before query: 4.885 MB
    UPDATE `va2rq_extensions`

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

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `va2rq_extensions` SET `params` = '{\"mediaversion\":\"acdbfbd7f0a657a3a7575cf7c88d8bc5\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    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.]
  10. Query Time: 0.76 ms After last query: 0.77 ms Query memory: 0.021 MB Memory before query: 4.908 MB Rows returned: 1
    SELECT attribs 
      FROM va2rq_flexicontent_types AS ty  JOIN va2rq_flexicontent_items_ext AS ie 
      ON ie.type_id = ty.id  
      WHERE ie.item_id = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEieconstPRIMARY,type_idPRIMARY4const1
    1SIMPLEtyconstPRIMARYPRIMARY4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    10JDatabaseDriver->loadResult()JROOT/plugins/system/flexisystem/flexisystem.php:589
    9plgSystemFlexisystem->redirectSiteComContent()JROOT/plugins/system/flexisystem/flexisystem.php:338
    8plgSystemFlexisystem->onAfterRoute()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1190
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  11. Query Time: 0.77 ms After last query: 43.50 ms Query memory: 0.025 MB Memory before query: 7.629 MB Rows returned: 1
    SELECT catid  
      FROM va2rq_flexicontent_cats_item_relations  
      WHERE itemid = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_cats_item_relationsrefitemiditemid4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:265
    17ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/base/base.php:198
    16FCModelAdmin->__construct()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
    15ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    14FlexicontentModelItem->__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.]
  12. Query Time: 0.64 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 7.639 MB Rows returned: 1
    Duplicate queries: #16  #88  #89
    SELECT catid  
      FROM va2rq_content 
      WHERE id = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_contentconstPRIMARYPRIMARY4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    18JDatabaseDriver->loadResult()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:280
    17ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/base/base.php:198
    16FCModelAdmin->__construct()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
    15ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    14FlexicontentModelItem->__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.]
  13. Query Time: 0.52 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 7.648 MB Rows returned: 2
    SELECT id, name 
      FROM va2rq_flexicontent_types
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_typesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4273
    18ParentClassItem->getItemType()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:294
    17ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/base/base.php:198
    16FCModelAdmin->__construct()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
    15ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    14FlexicontentModelItem->__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.]
  14. Query Time: 0.52 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 7.659 MB Rows returned: 1
    SELECT ie.type_id 
      FROM va2rq_flexicontent_items_ext as ie JOIN va2rq_flexicontent_types as t 
      ON ie.type_id=t.id 
      WHERE ie.item_id = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEieconstPRIMARY,type_idPRIMARY4const1
    1SIMPLEtconstPRIMARYPRIMARY4const1Using index
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    19JDatabaseDriver->loadResult()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4296
    18ParentClassItem->getItemType()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:294
    17ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/base/base.php:198
    16FCModelAdmin->__construct()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
    15ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    14FlexicontentModelItem->__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.]
  15. Query Time: 0.42 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 7.695 MB Rows returned: 1
    SELECT t.id, t.attribs 
      FROM va2rq_flexicontent_types AS t 
      WHERE 1 
      AND t.id = 2
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtconstPRIMARYPRIMARY4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    21JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/classes/helpers/db.php:123
    20flexicontent_db::getTypeAttribs()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4368
    19ParentClassItem->getTypeparams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:327
    18ParentClassItem->getComponentTypeParams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:298
    17ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/base/base.php:198
    16FCModelAdmin->__construct()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:192
    15ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    14FlexicontentModelItem->__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.]
  16. Query Time: 0.40 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 7.711 MB Rows returned: 1
    Duplicate queries: #12  #88  #89
    SELECT catid  
      FROM va2rq_content 
      WHERE id = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_contentconstPRIMARYPRIMARY4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:280
    16ParentClassItem->setId()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:217
    15ParentClassItem->__construct()JROOT/components/com_flexicontent/models/item.php:41
    14FlexicontentModelItem->__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.]
  17. Query Time: 0.59 ms After last query: 0.84 ms Query memory: 0.024 MB Memory before query: 7.745 MB Rows returned: 1
    SELECT i.id, i.version 
      FROM va2rq_content as i JOIN va2rq_categories AS c 
      ON i.catid=c.id 
      WHERE c.extension='com_content' 
      AND i.id=92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARY,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARY,cat_idxPRIMARY4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    15JDatabaseDriver->loadAssocList()JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:274
    14FLEXIUtilities::getCurrentVersions()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:544
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.]
  18. Query Time: 0.86 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 7.754 MB Rows returned: 1
    SELECT item_id as id, max(version_id) as version 
      FROM va2rq_flexicontent_versions 
      WHERE 1 
      AND item_id=92 
      GROUP BY item_id
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_versionsrefversion2itemversion2item4const10Using index
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    15JDatabaseDriver->loadAssocList()JROOT/components/com_flexicontent/classes/helpers/flexiutilities.php:233
    14FLEXIUtilities::getLastVersions()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:545
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.47 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 7.765 MB Rows returned: 1
    SELECT * 
      FROM va2rq_flexicontent_fields 
      WHERE field_type="voting"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_fieldsALLNULLNO INDEX KEY COULD BE USEDNULLNULL40Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    15JDatabaseDriver->loadObject()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4202
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.87 ms After last query: 0.30 ms Query memory: 0.027 MB Memory before query: 7.869 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `va2rq_flexicontent_items_ext`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `va2rq_flexicontent_items_ext`
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    19JDatabaseDriverMysqli->getTableColumns()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:295
    18flexicontent_items->getFields()JROOT/libraries/src/Table/Table.php:180
    17Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:247
    16flexicontent_items->__construct()JROOT/libraries/src/Table/Table.php:328
    15Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4203
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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: 0.81 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 7.886 MB Rows returned: 19
    SHOW FULL COLUMNS 
      FROM `va2rq_flexicontent_items_tmp`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `va2rq_flexicontent_items_tmp`
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    19JDatabaseDriverMysqli->getTableColumns()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:295
    18flexicontent_items->getFields()JROOT/libraries/src/Table/Table.php:180
    17Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:247
    16flexicontent_items->__construct()JROOT/libraries/src/Table/Table.php:328
    15Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4203
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.86 ms After last query: 0.11 ms Query memory: 0.034 MB Memory before query: 7.914 MB Rows returned: 31
    SHOW FULL COLUMNS 
      FROM `va2rq_content`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `va2rq_content`
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    20JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
    19Joomla\CMS\Table\Table->getFields()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:302
    18flexicontent_items->getFields()JROOT/libraries/src/Table/Table.php:180
    17Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:247
    16flexicontent_items->__construct()JROOT/libraries/src/Table/Table.php:328
    15Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4203
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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: 0.59 ms After last query: 0.53 ms Query memory: 0.040 MB Memory before query: 7.968 MB Rows returned: 1
    SELECT e.*, a.*

      FROM va2rq_content AS a

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

      WHERE `id` = '92'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEeconstPRIMARYPRIMARY4const1
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    16JDatabaseDriver->loadAssoc()JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:520
    15flexicontent_items->load()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4204
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.40 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 7.980 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.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.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.03 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/administrator/components/com_flexicontent/models/parentclassitem.php:4205
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.35 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 7.989 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.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.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
    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/administrator/components/com_flexicontent/models/parentclassitem.php:4205
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.41 ms After last query: 0.37 ms Query memory: 0.024 MB Memory before query: 8.023 MB Rows returned: 0
    SELECT attribs, published 
      FROM va2rq_flexicontent_fields 
      WHERE name='voting_fiche-album'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_fieldsALLNULLNO INDEX KEY COULD BE USEDNULLNULL40Using where
    Profile
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.02 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    16JDatabaseDriver->loadObject()JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1819
    15FlexicontentFields::loadFieldConfig()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4205
    14ParentClassItem->getVotingResolution()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:672
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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: 1.08 ms After last query: 0.29 ms Query memory: 0.039 MB Memory before query: 8.020 MB Rows returned: 1
    SELECT i.*, ie.*,mc.access as category_access, ty.access as type_access, 
      CASE WHEN ty.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_type_access, 
      CASE WHEN mc.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_mcat_access, 
      CASE WHEN  i.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_item_access,c.id AS catid, i.catid as maincatid,c.title AS category_title, c.alias AS category_alias, c.lft,c.rgt, mc.title AS maincat_title, mc.alias AS maincat_alias,ty.name AS typename, ty.alias as typealias,ua.name AS author,v.rating_count as rating_count, ROUND( v.rating_sum / v.rating_count ) AS rating, ((v.rating_sum / v.rating_count)*20) as score,
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug,
      CASE WHEN i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-02-03 19:27:12' THEN 0 ELSE 1 END as publication_scheduled,
      CASE WHEN i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-03 19:27:12' THEN 0 ELSE 1 END as publication_expired

      FROM va2rq_content AS i

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

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

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

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

      LEFT JOIN va2rq_flexicontent_cats_item_relations AS rel 
      ON rel.itemid = i.id 
      AND rel.catid = 82

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

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

      WHERE i.id = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEiconstPRIMARYPRIMARY4const1
    1SIMPLEieconstPRIMARYPRIMARY4const1
    1SIMPLEtyconstPRIMARYPRIMARY4const1
    1SIMPLEuaconstPRIMARYPRIMARY4const1
    1SIMPLEvconstPRIMARYPRIMARY4const0Unique row not found
    1SIMPLErelconstPRIMARY,catid,itemidPRIMARY8const,const1Using index
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEmcconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.21 ms
    checking permissions0.01 ms
    Opening tables0.08 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.12 ms
    Optimizing0.04 ms
    Statistics0.20 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 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.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:1662
    14JDatabaseDriver->loadObject()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:731
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.29 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 8.040 MB Rows returned: 0
    SELECT *

      FROM va2rq_content_rating

      WHERE content_id IN (92)
    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.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.02 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.02 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/administrator/components/com_flexicontent/models/parentclassitem.php:4148
    14ParentClassItem->getVotes()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:755
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.28 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.047 MB Rows returned: 0
    SELECT *, field_id as extra_id

      FROM va2rq_flexicontent_items_extravote

      WHERE content_id IN (92)
    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.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/administrator/components/com_flexicontent/models/parentclassitem.php:4155
    14ParentClassItem->getVotes()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:755
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.68 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 8.069 MB Rows returned: 2
    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

      FROM `va2rq_content` AS `c`

      INNER JOIN `va2rq_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_content.item'

      INNER JOIN `va2rq_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`

      INNER JOIN `va2rq_content` AS `c2` 
      ON a2.id = c2.`id`

      INNER JOIN `va2rq_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_content'

      WHERE c.id = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARYPRIMARY4const1Using index
    1SIMPLEaconstPRIMARY,idx_keyPRIMARY206const,const1
    1SIMPLEa2refidx_keyidx_key128const2Using index
    1SIMPLEc2eq_refPRIMARY,idx_catidPRIMARY4lahe0874_db.a2.id1Using where
    1SIMPLEcaeq_refPRIMARY,cat_idxPRIMARY4lahe0874_db.c2.catid1Using where
    Profile
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.03 ms
    Statistics0.14 ms
    Preparing0.01 ms
    Unlocking tables0.01 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.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/libraries/src/Language/Associations.php:115
    14Joomla\CMS\Language\Associations::getAssociations()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:782
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.46 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 8.073 MB Rows returned: 8
    SELECT DISTINCT tid

      FROM va2rq_flexicontent_tags_item_relations

      WHERE itemid = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_tags_item_relationsrefitemiditemid4const10Using where; Using temporary
    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.05 ms
    Preparing0.02 ms
    Creating tmp table0.04 ms
    Executing0.01 ms
    Sending data0.08 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    14JDatabaseDriver->loadColumn()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:975
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.39 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 8.081 MB Rows returned: 1
    SELECT DISTINCT catid

      FROM va2rq_flexicontent_cats_item_relations

      WHERE itemid = 92
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_flexicontent_cats_item_relationsrefitemiditemid4const1Using where; Using temporary
    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.04 ms
    Preparing0.02 ms
    Creating tmp table0.03 ms
    Executing0.01 ms
    Sending data0.03 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    14JDatabaseDriver->loadColumn()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1008
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.51 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 8.097 MB Rows returned: 2
    SELECT a.id as item_id, i.id as id, i.title, i.created as created, i.modified as modified,  i.language as language, i.language as lang, `a`.`key` as `key` 
      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 
      WHERE a.id IN (92) 
      AND a.context = 'com_content.item'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARY,idx_keyPRIMARY206const,const1
    1SIMPLEkrefidx_keyidx_key128const2Using index
    1SIMPLEieq_refPRIMARYPRIMARY4lahe0874_db.k.id1Using where
    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.09 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/db.php:1096
    15flexicontent_db::getLangAssocs()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:5251
    14ParentClassItem->getLangAssocs()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1033
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.34 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 8.111 MB Rows returned: 1
    SELECT title 
      FROM va2rq_viewlevels 
      WHERE id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_viewlevelsconstPRIMARYPRIMARY4const1
    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.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.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:5884
    14ParentClassItem->_afterLoad()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1046
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.30 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.119 MB Rows returned: 0
    SELECT  v.rating_count as rating_count, ROUND( v.rating_sum / v.rating_count ) AS rating, ((v.rating_sum / v.rating_count)*20) as score 
      FROM va2rq_content_rating AS v 
      WHERE v.content_id = 92
    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.01 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.03 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:1662
    15JDatabaseDriver->loadObject()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:5957
    14ParentClassItem->_afterLoad()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1046
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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: 8.126 MB Rows returned: 1
    SELECT name, email 
      FROM va2rq_users 
      WHERE id = 607
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_usersconstPRIMARYPRIMARY4const1
    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.02 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:1662
    15JDatabaseDriver->loadObject()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:5983
    14ParentClassItem->_afterLoad()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1046
    13ParentClassItem->_loadRecord()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:408
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.34 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 8.131 MB Rows returned: 1
    SELECT c.title, c.params 
      FROM va2rq_categories AS c 
      WHERE c.id = 82
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARYPRIMARY4const1
    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.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3730
    13ParentClassItem->_loadItemParams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:415
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.39 ms After last query: 2.71 ms Query memory: 0.024 MB Memory before query: 8.766 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.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.01 ms
    Preparing0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/helpers/tmpl.php:408
    15flexicontent_tmpl::getLayoutparams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:4380
    14ParentClassItem->getLayoutparams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3773
    13ParentClassItem->_loadItemParams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:415
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.05 ms After last query: 0.37 ms Query memory: 0.068 MB Memory before query: 8.813 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.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.07 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.63 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.02 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    19Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1489
    14ParentClassItem->getItemAccess()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3801
    13ParentClassItem->_loadItemParams()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:415
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.48 ms After last query: 0.85 ms Query memory: 0.024 MB Memory before query: 9.017 MB Rows returned: 1
    Duplicate queries: #41
    SELECT id, title, published, access, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
      FROM va2rq_categories 
      WHERE id IN (82) 
      AND extension="com_content"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_categoriesconstPRIMARY,cat_idxPRIMARY4const1
    Profile
    StatusDuration
    Starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 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.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.categories.php:78
    15flexicontent_cats->getParentCats()JROOT/components/com_flexicontent/classes/flexicontent.categories.php:124
    14flexicontent_cats->getParentlist()JROOT/components/com_flexicontent/models/item.php:108
    13FlexicontentModelItem->_check_viewing_access()JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:420
    12ParentClassItem->getItem()JROOT/components/com_flexicontent/views/item/view.html.php:118
    11FlexicontentViewItem->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.51 ms After last query: 2.18 ms Query memory: 0.023 MB Memory before query: 9.042 MB Rows returned: 1
    Duplicate queries: #40
    SELECT id, title, published, access, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
      FROM va2rq_categories 
      WHERE id IN (82) 
      AND extension="com_content"
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEva2rq_categoriesconstPRIMARY,cat_idxPRIMARY4const1
    Profile
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.04 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/components/com_flexicontent/classes/flexicontent.categories.php:78
    13flexicontent_cats->getParentCats()JROOT/components/com_flexicontent/classes/flexicontent.categories.php:124
    12flexicontent_cats->getParentlist()JROOT/components/com_flexicontent/views/item/view.html.php:157
    11FlexicontentViewItem->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.42 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 9.043 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.07 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.01 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.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/components/com_flexicontent/helpers/route.php:217
    13FlexicontentHelperRoute::_buildLanguageLookup()JROOT/components/com_flexicontent/helpers/route.php:532
    12FlexicontentHelperRoute::getCategoryRoute()JROOT/components/com_flexicontent/views/item/view.html.php:182
    11FlexicontentViewItem->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.57 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 9.058 MB Rows returned: 2