Das Blaue Haus Nürnberg

Das Blaue Haus Nürnberg
  • Home
        • beverages

      • We offer the best meals at the best value

        Our restaurant was an institution in Boston's North End. Now we have brought back the recipes and the spirit of the European to North Chelmsford. Located in a historic brick millhouse, European Restaurant combines a comfortable, yet elegant, atmosphere with authentic Italian cuisine. Come join us for lunch, dinner or a drink at the bar.

      • Allersbergerstr 185 / L4  
        90461 Nürnberg
        e-mail: net@dasblaue-haus.de

        (0049) 911 4720830

        • Öffnungszeiten
        • Montag bis Sonntag 11:30 – 00:00  Uhr
        • Warme Küche Montag bis Freitag 11:30 bis 15:00 Uhr und 17:00 bis 22:00 Uhr
        • Samstag- Sonntag Warme Küche 11:30 bis 22:00 Uhr
        • Ruhetag: kein Ruhetag
        • Late morning brunch
        • Elegant approach to cooking
        • Tasty desserts

      • 12/22

        Linda Smith

        solo program

        doors: 20pm

  • mittagkarte
  • abendkarte
  • das gibt immer
  • angebot
  • Contacts
  • Login
      • Login form:
        Forgot your password?
        or registration
  • Search
  • Salad menu:
    / view more
    • Caesar Salad
    • Roasted Beet Salad
    • Bistro Salad
    • Caprese Salad
    • Bella Salad
  • Grill menu:
    / view more

    • All Steaks Come with Parmesan Fries and Haricot Verts

    • Twin Filets
    • Grilled Ribeye
    • House Tumbled Steak Tips
    • Grilled Pork Chops with Maple Whiskey Glaze

      • Sauces~ Gorgonzola Butter, Chianti Demi, Roasted Garlic-Basil Butter

  • Seafood menu:
    / view more
    • Baked Haddock

      Grilled Asparagus, Yukon Potatoes

    • Cioppino

      Roma Tomatoes, Capers, Marinara served with Starch

    • Mussels Red

      Spicy Sausage, Red Sauce, Linguines

    • Shrimp Scampi

      Sauteed Shrimp and Scallion in a garlic scampi sauce

  • Pasta menu:
    / view more
    • Cavatapi

      Smoked Mozzarella, Sun-Dried Tomato, Spinach

    • Ricotta Gnocchi

      Broccolini, Sausage, Garlic, Parmesan

    • Eggplant Rollentini

      Poached Chicken, Spinach, Parmesan, Mozzarella Cheese

    • Chicken Broccoli Penne

      Fresh Garlic, Cream, Parmesan Cheese

    • Pasta Louise

Das Blaue Haus

Unser Restaurant Das Blaue Haus ist ideal und zentrumsnah im Nürbanum Nürnberg gelegen. Wir bieten Ihnen stets frisch zubereitete Speisen und eine täglich wechselnde Mittag- und Abendkarte. Große Terrasse direkt vor der Tür.

Allersbergerstr 185 / L4  
90461 Nürnberg
e-mail: net@dasblaue-haus.de

(0049) 911 4720830

  • Öffnungszeiten
  • Montag bis Sonntag 11:30 – 00:00  Uhr
  • Warme Küche Montag bis Freitag 11:30 bis 15:00 Uhr und 17:00 bis 22:00 Uhr
  • Samstag- Sonntag Warme Küche 11:30 bis 22:00 Uhr
  • Ruhetag: kein Ruhetag
icon
Das Blaue Haus Nürnberg

(0049) 911 4720830

Allersbergerstr 185 / L4,
90461 Nürnberg
e-mail: net@dasblaue-haus.de

More European Restaurant Templates at TemplateMonster.com
Login or register
Forgot your password?
or registration

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1508212761,
                "last": 1508212761,
                "now": 1508212761
            },
            "client": {
                "forwarded": "54.166.150.10"
            },
            "token": "7rjShs2YJd86fn0quO6ZPjL4M5Y0GtE1"
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 10.26 ms / 10.26 ms Memory: 1.387 MB / 1.72 MB Application: afterLoad
Time: 45.25 ms / 55.52 ms Memory: 4.004 MB / 5.72 MB Application: afterInitialise
Time: 18.54 ms / 74.06 ms Memory: 1.718 MB / 7.44 MB Application: afterRoute
Time: 252.99 ms / 327.05 ms Memory: 0.245 MB / 7.68 MB Application: beforeRenderComponent com_content
Time: 5.43 ms / 332.48 ms Memory: 0.586 MB / 8.27 MB Application: Before Access::preloadComponents (all components)
Time: 1.27 ms / 333.75 ms Memory: 0.061 MB / 8.33 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 333.79 ms Memory: 0.000 MB / 8.33 MB Application: Before Access::preloadPermissions (com_content)
Time: 1.46 ms / 335.25 ms Memory: 0.169 MB / 8.49 MB Application: After Access::preloadPermissions (com_content)
Time: 0.03 ms / 335.28 ms Memory: 0.000 MB / 8.48 MB Application: Before Access::getAssetRules (id:64 name:com_content.category.8)
Time: 0.49 ms / 335.77 ms Memory: 0.027 MB / 8.51 MB Application: After Access::getAssetRules (id:64 name:com_content.category.8)
Time: 6.53 ms / 342.30 ms Memory: 0.212 MB / 8.72 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.09 ms / 342.39 ms Memory: 0.007 MB / 8.73 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 27.40 ms / 369.79 ms Memory: 1.268 MB / 10.00 MB Application: afterRenderComponent com_content
Time: 2.44 ms / 372.22 ms Memory: 0.171 MB / 10.17 MB Application: afterDispatch
Time: 14.40 ms / 386.62 ms Memory: 0.665 MB / 10.83 MB Application: beforeRenderModule mod_tm_olark_chat (Olark)
Time: 0.77 ms / 387.39 ms Memory: 0.050 MB / 10.88 MB Application: afterRenderModule mod_tm_olark_chat (Olark)
Time: 0.10 ms / 387.49 ms Memory: 0.000 MB / 10.88 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Time: 0.54 ms / 388.03 ms Memory: 0.046 MB / 10.93 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Time: 0.08 ms / 388.11 ms Memory: 0.007 MB / 10.93 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Time: 0.06 ms / 388.16 ms Memory: 0.000 MB / 10.91 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Time: 0.05 ms / 388.21 ms Memory: 0.000 MB / 10.91 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login or register)
Time: 6.28 ms / 394.49 ms Memory: 0.290 MB / 11.20 MB Application: afterRenderModule mod_socialloginandsocialshare (Login or register)
Time: 0.08 ms / 394.57 ms Memory: 0.000 MB / 11.19 MB Application: beforeRenderModule mod_custom (Footer address)
Time: 0.36 ms / 394.93 ms Memory: 0.006 MB / 11.20 MB Application: afterRenderModule mod_custom (Footer address)
Time: 0.05 ms / 394.98 ms Memory: 0.000 MB / 11.20 MB Application: beforeRenderModule mod_menu (Social media)
Time: 1.74 ms / 396.73 ms Memory: 0.045 MB / 11.24 MB Application: afterRenderModule mod_menu (Social media)
Time: 0.07 ms / 396.80 ms Memory: 0.000 MB / 11.24 MB Application: beforeRenderModule mod_custom (Map)
Time: 0.18 ms / 396.98 ms Memory: 0.003 MB / 11.24 MB Application: afterRenderModule mod_custom (Map)
Time: 0.08 ms / 397.06 ms Memory: 0.000 MB / 11.24 MB Application: beforeRenderModule mod_custom (Das Blaue Haus)
Time: 0.24 ms / 397.29 ms Memory: 0.003 MB / 11.24 MB Application: afterRenderModule mod_custom (Das Blaue Haus)
Time: 0.04 ms / 397.34 ms Memory: 0.000 MB / 11.24 MB Application: beforeRenderModule mod_custom (We offer)
Time: 0.18 ms / 397.52 ms Memory: 0.003 MB / 11.24 MB Application: afterRenderModule mod_custom (We offer)
Time: 0.04 ms / 397.56 ms Memory: 0.003 MB / 11.25 MB Application: beforeRenderModule mod_articles_news_adv (Offer2)
Time: 11.31 ms / 408.87 ms Memory: 0.267 MB / 11.52 MB Application: afterRenderModule mod_articles_news_adv (Offer2)
Time: 0.16 ms / 409.03 ms Memory: 0.000 MB / 11.46 MB Application: beforeRenderModule mod_caroufredsel (CaroufredSel)
Time: 13.50 ms / 422.53 ms Memory: 0.212 MB / 11.67 MB Application: afterRenderModule mod_caroufredsel (CaroufredSel)
Time: 0.17 ms / 422.70 ms Memory: 0.000 MB / 11.55 MB Application: beforeRenderModule mod_icemegamenu (Main menu)
Time: 11.16 ms / 433.86 ms Memory: 0.479 MB / 12.03 MB Application: beforeRenderModule mod_articles_categories (Categories)
Time: 3.71 ms / 437.57 ms Memory: 0.080 MB / 12.11 MB Application: afterRenderModule mod_articles_categories (Categories)
Time: 0.83 ms / 438.40 ms Memory: 0.021 MB / 12.13 MB Application: beforeRenderModule mod_custom (We offer the best meals at the best value)
Time: 0.20 ms / 438.60 ms Memory: 0.004 MB / 12.14 MB Application: afterRenderModule mod_custom (We offer the best meals at the best value)
Time: 0.78 ms / 439.37 ms Memory: 0.031 MB / 12.17 MB Application: beforeRenderModule mod_articles_news_adv (Offer2 megamenu)
Time: 5.45 ms / 444.82 ms Memory: 0.100 MB / 12.27 MB Application: afterRenderModule mod_articles_news_adv (Offer2 megamenu)
Time: 1.35 ms / 446.17 ms Memory: 0.000 MB / 12.23 MB Application: beforeRenderModule mod_menu (cooking menu)
Time: 1.10 ms / 447.26 ms Memory: 0.012 MB / 12.24 MB Application: afterRenderModule mod_menu (cooking menu)
Time: 0.79 ms / 448.05 ms Memory: 0.026 MB / 12.27 MB Application: beforeRenderModule mod_articles_single (12/22)
Time: 11.43 ms / 459.48 ms Memory: 0.177 MB / 12.45 MB Application: afterRenderModule mod_articles_single (12/22)
Time: 1.38 ms / 460.86 ms Memory: 0.000 MB / 12.44 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login form:)
Time: 1.63 ms / 462.49 ms Memory: 0.023 MB / 12.46 MB Application: afterRenderModule mod_socialloginandsocialshare (Login form:)
Time: 1.00 ms / 463.48 ms Memory: 0.022 MB / 12.49 MB Application: beforeRenderModule mod_search (Menu search)
Time: 0.75 ms / 464.24 ms Memory: 0.015 MB / 12.50 MB Application: afterRenderModule mod_search (Menu search)
Time: 7.96 ms / 472.19 ms Memory: 0.090 MB / 12.59 MB Application: afterRenderModule mod_icemegamenu (Main menu)
Time: 13.72 ms / 485.91 ms Memory: 0.709 MB / 13.30 MB Application: afterRender

Database queries total: 299.13 ms

Memory Usage

14.33 MB (15,030,928 Bytes)

Database Queries

58 Queries Logged 299.13 ms


5 duplicate found!

3 duplicates: #9  #29  #57
2 duplicates: #30  #47
  1. Query Time: 0.40 ms Query memory: 0.003 MB Memory before query: 3.275 MB
    DELETE 

      FROM `ajb18_session`

      WHERE `time` < '1508211861'
    Explain
    EXPLAIN not possible on query: DELETE FROM `ajb18_session` WHERE `time` < '1508211861'
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.07 ms
    updating0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/src/Application/CMSApplication.php:824
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:133
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:415
    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.29 ms After last query: 0.29 ms Query memory: 0.024 MB Memory before query: 3.291 MB Rows returned: 0
    SELECT `data`

      FROM `ajb18_session`

      WHERE `session_id` = 'e40c60d3cc635068fd28113efbe5fc0d'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_sessionconstPRIMARYPRIMARY766const1
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    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:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:831
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:133
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:415
    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.30 ms After last query: 1.02 ms Query memory: 0.021 MB Memory before query: 3.378 MB Rows returned: 0
    SELECT `session_id`

      FROM `ajb18_session`

      WHERE `session_id` = 'e40c60d3cc635068fd28113efbe5fc0d' 
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_sessionconstPRIMARYPRIMARY766const1Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    7JDatabaseDriver->loadResult()JROOT/libraries/src/Application/CMSApplication.php:178
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:833
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:133
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:415
    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.71 ms After last query: 0.07 ms Query memory: 0.003 MB Memory before query: 3.382 MB
    INSERT INTO `ajb18_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES 
('e40c60d3cc635068fd28113efbe5fc0d', 1, '1508212761', 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `ajb18_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('e40c60d3cc635068fd28113efbe5fc0d', 1, '1508212761', 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    update0.06 ms
    end0.01 ms
    query end0.44 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.00 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/src/Application/CMSApplication.php:218
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:833
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:133
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:415
    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.]
  5. Query Time: 0.67 ms After last query: 2.70 ms Query memory: 0.029 MB Memory before query: 3.585 MB Rows returned: 39
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `ajb18_extensions`

      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_extensionsrefextensionextension82const39Using index condition
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.24 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:450
    9Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:458
    6Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:46
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:114
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:596
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.34 ms After last query: 2.28 ms Query memory: 0.023 MB Memory before query: 3.779 MB Rows returned: 5
    SELECT id, rules

      FROM `ajb18_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1496
    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:310
    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:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.39 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 3.853 MB Rows returned: 2
    SELECT b.id

      FROM ajb18_usergroups AS a

      LEFT JOIN ajb18_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where; Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.02 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.00 ms
    Unlocking tables0.02 ms
    executing0.02 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1540
    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:310
    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:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.31 ms After last query: 0.61 ms Query memory: 0.043 MB Memory before query: 3.915 MB Rows returned: 91
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

      FROM ajb18_extensions

      WHERE enabled = 1 
      AND type = 'plugin' 
      AND state IN (0,1) 
      AND access IN (1,1,5)

      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_extensionsrefextensionextension82const117Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.54 ms
    Sending data0.13 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:343
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:348
    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:606
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.34 ms After last query: 16.60 ms Query memory: 0.024 MB Memory before query: 5.595 MB Rows returned: 10
    Duplicate queries: #29  #57
    SELECT * 
      FROM ajb18_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_loginradius_settingsALLNULLNO INDEX KEY COULD BE USEDNULLNULL10
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1496
    10JDatabaseDriver->loadAssocList()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
    9plgSystemSocialLoginTools::sociallogin_getsettings()JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
    8plgSystemSocialLoginAndSocialShare->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:686
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:688
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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: 1.90 ms After last query: 3.26 ms Query memory: 0.102 MB Memory before query: 5.903 MB Rows returned: 88
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

      FROM ajb18_menu AS m

      LEFT JOIN ajb18_extensions AS e 
      ON m.component_id = e.extension_id

      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0

      ORDER BY m.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const101Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.m.component_id1Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.58 ms
    Sending data0.46 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:446
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:551
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:405
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1146
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:798
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.73 ms After last query: 9.26 ms Query memory: 0.029 MB Memory before query: 7.060 MB Rows returned: 2
    SHOW FULL COLUMNS 
      FROM `ajb18_komento_configs`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ajb18_komento_configs`
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    closing tables0.00 ms
    Opening tables0.25 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Filling schema table0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    closing tables0.02 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.07 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:430
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    16Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    15Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_komento/tables/parent.php:18
    14KomentoParentTable->__construct()JROOT/administrator/components/com_komento/tables/configs.php:40
    13KomentoTableConfigs->__construct()JROOT/libraries/src/Table/Table.php:312
    12Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_komento/tables/parent.php:49
    11KomentoParentTable::getInstance()JROOT/components/com_komento/helpers/helper.php:99
    10Komento::getTable()JROOT/components/com_komento/helpers/helper.php:228
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/src/Router/SiteRouter.php:770
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:130
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1147
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:798
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.42 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 7.153 MB Rows returned: 1
    SELECT *

      FROM ajb18_komento_configs

      WHERE `component` = 'com_komento'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_komento_configsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.02 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    11JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:730
    10Joomla\CMS\Table\Table->load()JROOT/components/com_komento/helpers/helper.php:229
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/src/Router/SiteRouter.php:770
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:130
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1147
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:798
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.60 ms After last query: 4.10 ms Query memory: 0.025 MB Memory before query: 7.473 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

      FROM `ajb18_extensions`

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1116
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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: 247.58 ms After last query: 0.19 ms Query memory: 0.005 MB Memory before query: 7.464 MB
    UPDATE `ajb18_extensions`

      SET `params` = '{\"mediaversion\":\"67a14dd1983d66b22326876b9c911421\"}'

      WHERE `type` = 'library' 
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `ajb18_extensions` SET `params` = '{\"mediaversion\":\"67a14dd1983d66b22326876b9c911421\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    init0.09 ms
    updating0.09 ms
    end0.02 ms
    query end247.01 ms
    closing tables0.02 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1116
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.43 ms After last query: 2.53 ms Query memory: 0.025 MB Memory before query: 7.642 MB Rows returned: 1
    SELECT *

      FROM ajb18_languages

      WHERE published=1

      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.04 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.55 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 7.661 MB Rows returned: 5
    SELECT id, home, template, s.params

      FROM ajb18_template_styles as s

      LEFT JOIN ajb18_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

      WHERE s.client_id = 0 
      AND e.enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionextension82const5Using index condition; Using where
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL7Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.05 ms
    executing0.01 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:488
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:267
    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.97 ms After last query: 6.00 ms Query memory: 0.032 MB Memory before query: 8.274 MB Rows returned: 39
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `ajb18_assets`

      WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jbetolo','com_joomgallery','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_socialloginandsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_assetsrangeidx_asset_nameidx_asset_name202NULL40Using index condition
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.08 ms
    optimizing0.01 ms
    statistics0.14 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.36 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:142
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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: 1.11 ms After last query: 0.29 ms Query memory: 0.049 MB Memory before query: 8.326 MB Rows returned: 164
    SELECT `id`,`name`,`rules`,`parent_id`

      FROM `ajb18_assets`

      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_assetsALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL471Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.36 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:142
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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: 1.89 ms After last query: 2.26 ms Query memory: 0.039 MB Memory before query: 8.549 MB Rows returned: 5
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

      FROM ajb18_categories as c

      LEFT JOIN ajb18_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

      LEFT JOIN `ajb18_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id=8

      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; Using filesort
    1SIMPLEcALLcat_idx,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL56Using where
    1SIMPLEirefidx_state,idx_catididx_catid4dasblaue_haus_de_alam.c.id1Using where
    Profile
    StatusDuration
    starting0.22 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.14 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.02 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.01 ms
    Unlocking tables0.04 ms
    executing0.00 ms
    Creating tmp table0.35 ms
    Copying to tmp table0.29 ms
    Sorting result0.02 ms
    Sending data0.05 ms
    end0.01 ms
    removing tmp table0.07 ms
    end0.02 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:305
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:423
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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: 3.18 ms After last query: 3.36 ms Query memory: 0.039 MB Memory before query: 8.724 MB Rows returned: 1
    SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM ajb18_content AS a

      LEFT JOIN ajb18_categories AS c 
      ON c.id = a.catid

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN ajb18_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN ajb18_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN ajb18_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 8 OR a.catid IN (
SELECT sub.id

      FROM ajb18_categories as sub

      INNER JOIN ajb18_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt

      WHERE this.id = 8)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-17 03:59:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-17 03:59:21')

      ORDER BY  c.lft,  a.ordering,  a.created
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL56Using where; Using temporary; Using filesort
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4dasblaue_haus_de_alam.c.id1Using index condition; Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.modified_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL53Using where; Using index
    Profile
    StatusDuration
    starting0.28 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.09 ms
    optimizing0.04 ms
    statistics0.14 ms
    preparing0.10 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.05 ms
    executing0.00 ms
    Creating tmp table0.38 ms
    Copying to tmp table0.09 ms
    executing0.01 ms
    Sending data1.07 ms
    Sorting result0.02 ms
    Sending data0.05 ms
    end0.01 ms
    removing tmp table0.08 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    removing tmp table0.01 ms
    freeing items0.01 ms
    removing tmp table0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:556
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:423
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  21. Query Time: 1.37 ms After last query: 2.66 ms Query memory: 0.026 MB Memory before query: 8.853 MB Rows returned: 1
    SELECT COUNT(*)

      FROM ajb18_content AS a

      LEFT JOIN ajb18_categories AS c 
      ON c.id = a.catid

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN ajb18_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN ajb18_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN ajb18_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 8 OR a.catid IN (
SELECT sub.id

      FROM ajb18_categories as sub

      INNER JOIN ajb18_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt

      WHERE this.id = 8)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-17 03:59:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-17 03:59:21')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL56Using where
    1PRIMARYarefidx_access,idx_state,idx_catididx_catid4dasblaue_haus_de_alam.c.id1Using index condition; Using where
    2MATERIALIZEDthisconstPRIMARY,idx_left_rightPRIMARY4const1
    2MATERIALIZEDsubrangePRIMARY,idx_left_rightidx_left_right4NULL53Using where; Using index
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.04 ms
    statistics0.09 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.06 ms
    executing0.00 ms
    Sending data0.57 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.03 ms
    freeing items0.00 ms
    removing tmp table0.01 ms
    freeing items0.01 ms
    removing tmp table0.00 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1730
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:423
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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.73 ms After last query: 2.19 ms Query memory: 0.035 MB Memory before query: 9.044 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*

      FROM `ajb18_contentitem_tag_map` AS m 

      INNER JOIN `ajb18_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`

      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 8 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEtALLPRIMARY,tag_idx,idx_accessNO INDEX KEY COULD BE USEDNULLNULL16Using where
    1SIMPLEmrefidx_tag_typeidx_tag_type4dasblaue_haus_de_alam.t.id1Using index condition; Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.12 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:226
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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.92 ms After last query: 4.55 ms Query memory: 0.040 MB Memory before query: 9.399 MB Rows returned: 5
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM ajb18_categories as c

      LEFT JOIN ajb18_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=8

      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL56Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Sorting result0.07 ms
    Sending data0.06 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:305
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:197
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:133
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:108
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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: 1.01 ms After last query: 0.28 ms Query memory: 0.037 MB Memory before query: 9.430 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.04 ms
    statistics0.08 ms
    preparing0.06 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.02 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:108
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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.33 ms After last query: 5.67 ms Query memory: 0.027 MB Memory before query: 9.914 MB Rows returned: 1
    SELECT *

      FROM ajb18_komento_configs

      WHERE `component` = 'com_content'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_komento_configsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.02 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    18JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:730
    17Joomla\CMS\Table\Table->load()JROOT/components/com_komento/helpers/helper.php:202
    16Komento::getConfig()JROOT/components/com_komento/helpers/helper.php:697
    15Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    14plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    13plgContentKomento->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:119
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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.55 ms After last query: 1.32 ms Query memory: 0.030 MB Memory before query: 9.970 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
      FROM `ajb18_content` AS a 
      LEFT JOIN `ajb18_categories` AS c 
      ON c.id = a.catid 
      LEFT JOIN `ajb18_users` AS u 
      ON u.id = a.created_by 
      LEFT JOIN `ajb18_categories` AS parent 
      ON parent.id = c.parent_id 
      WHERE a.id = '2'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEcconstPRIMARYPRIMARY4const1
    1SIMPLEuconstPRIMARYPRIMARY4const1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.14 ms
    preparing0.01 ms
    Unlocking tables0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.04 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    19JDatabaseDriver->loadObject()JROOT/components/com_komento/helpers/database.php:151
    18KomentoDatabaseJoomla15->__call()JROOT/components/com_komento/helpers/database.php:40
    17KomentoDatabaseHelper->__call()JROOT/components/com_komento/komento_plugins/com_content.php:54
    16KomentoComcontent->load()JROOT/components/com_komento/helpers/helper.php:743
    15Komento::commentify()JROOT/plugins/content/komento/komento.php:166
    14plgContentKomento->execute()JROOT/plugins/content/komento/komento.php:80
    13plgContentKomento->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:119
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:42
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:392
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:367
    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:267
    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: 2.29 ms After last query: 10.84 ms Query memory: 0.032 MB Memory before query: 10.541 MB Rows returned: 30
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

      FROM ajb18_modules AS m

      LEFT JOIN ajb18_modules_menu AS mm 
      ON mm.moduleid = m.id

      LEFT JOIN ajb18_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-10-17 03:59:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-10-17 03:59:21') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)

      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLPRIMARY,published,newsfeedsNO INDEX KEY COULD BE USEDNULLNULL75Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4dasblaue_haus_de_alam.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403dasblaue_haus_de_alam.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.04 ms
    statistics0.09 ms
    preparing0.06 ms
    executing0.01 ms
    Sorting result0.30 ms
    Sending data0.82 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    15JDatabaseDriver->loadObjectList()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:433
    12Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:363
    11Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    10Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:581
    9Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/theme3196/includes/includes.php:123
    8include_once JROOT/templates/theme3196/includes/includes.phpJROOT/templates/theme3196/index.php:2
    7require JROOT/templates/theme3196/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1103
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.52 ms After last query: 2.71 ms Query memory: 0.029 MB Memory before query: 10.730 MB Rows returned: 1
    SELECT * 
      FROM ajb18_kunena_configuration 
      WHERE id=1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_kunena_configurationconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.04 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1455
    24JDatabaseDriver->loadAssoc()JROOT/libraries/kunena/config.php:287
    23KunenaConfig->load()JROOT/libraries/kunena/config.php:241
    22KunenaConfig::getInstance()JROOT/libraries/kunena/factory.php:26
    21KunenaFactory::getConfig()JROOT/libraries/kunena/route/route.php:266
    20KunenaRoute::initialize()JROOT/libraries/kunena/route/route.php:17
    19include_once JROOT/libraries/kunena/route/route.phpJROOT/libraries/loader.php:744
    18JLoader::_load()JROOT/libraries/loader.php:692
    17JLoader::_autoload()Same as call in the line below.
    16spl_autoload_call()JROOT/components/com_kunena/router.php:35
    15KunenaBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:528
    13Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:498
    12Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    11Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    10Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    9Joomla\CMS\Router\Route::_()JROOT/templates/theme3196/includes/includes.php:166
    8include_once JROOT/templates/theme3196/includes/includes.phpJROOT/templates/theme3196/index.php:2
    7require JROOT/templates/theme3196/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1103
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.35 ms After last query: 5.23 ms Query memory: 0.025 MB Memory before query: 10.951 MB Rows returned: 10
    Duplicate queries: #9  #57
    SELECT * 
      FROM ajb18_loginradius_settings
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_loginradius_settingsALLNULLNO INDEX KEY COULD BE USEDNULLNULL10
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1496
    12JDatabaseDriver->loadAssocList()JROOT/modules/mod_socialloginandsocialshare/helper.php:96
    11modSocialLoginAndSocialShareHelper::sociallogin_getsettings()JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.php:19
    10include JROOT/modules/mod_socialloginandsocialshare/mod_socialloginandsocialshare.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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: 1.46 ms After last query: 9.38 ms Query memory: 0.038 MB Memory before query: 11.382 MB Rows returned: 2
    Duplicate queries: #47
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM ajb18_content AS a

      LEFT JOIN ajb18_categories AS c 
      ON c.id = a.catid

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN ajb18_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN ajb18_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN ajb18_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (65) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-17 03:59:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-17 03:59:21')

      ORDER BY a.publish_up DESC 
      LIMIT 2
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1Using filesort
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const2Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    1SIMPLEveq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where
    Profile
    StatusDuration
    starting0.30 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.06 ms
    optimizing0.04 ms
    statistics0.12 ms
    preparing0.01 ms
    Unlocking tables0.09 ms
    executing0.01 ms
    Sorting result0.14 ms
    Sending data0.09 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:556
    12ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:107
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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: 1.00 ms After last query: 0.62 ms Query memory: 0.040 MB Memory before query: 11.449 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM ajb18_categories as c

      LEFT JOIN ajb18_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=65

      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL56Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Sorting result0.08 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:305
    22Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    21Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    20ContentRouter->getCategorySegment()Same as call in the line below.
    19call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    18Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    17Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    16Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:669
    15Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_articles_news_adv/helper.php:121
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.81 ms After last query: 0.80 ms Query memory: 0.039 MB Memory before query: 11.466 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_articles_news_adv/helper.php:131
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.81 ms After last query: 0.39 ms Query memory: 0.040 MB Memory before query: 11.483 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (65,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.02 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:326
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:289
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_articles_news_adv/helper.php:141
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.86 ms After last query: 0.89 ms Query memory: 0.039 MB Memory before query: 11.499 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (65,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.08 ms
    optimizing0.05 ms
    statistics0.10 ms
    preparing0.04 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:111
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_articles_news_adv/helper.php:131
    11ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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: 1.42 ms After last query: 5.11 ms Query memory: 0.039 MB Memory before query: 11.515 MB Rows returned: 4
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM ajb18_content AS a

      LEFT JOIN ajb18_categories AS c 
      ON c.id = a.catid

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN ajb18_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN ajb18_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN ajb18_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (64) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-17 03:59:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-17 03:59:21')

      ORDER BY a.ordering ASC 
      LIMIT 100
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1Using filesort
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const4Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    1SIMPLEveq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where
    Profile
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.06 ms
    optimizing0.04 ms
    statistics0.13 ms
    preparing0.01 ms
    Unlocking tables0.04 ms
    executing0.00 ms
    Sorting result0.11 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:556
    12ContentModelArticles->getItems()JROOT/modules/mod_caroufredsel/helper.php:67
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:42
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.83 ms After last query: 0.63 ms Query memory: 0.040 MB Memory before query: 11.638 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM ajb18_categories as c

      LEFT JOIN ajb18_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=64

      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL56Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Sorting result0.12 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:305
    22Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    21Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    20ContentRouter->getCategorySegment()Same as call in the line below.
    19call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    18Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    17Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    16Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:669
    15Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    12Joomla\CMS\Router\Route::_()JROOT/modules/mod_caroufredsel/helper.php:77
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:42
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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: 1.22 ms After last query: 0.48 ms Query memory: 0.039 MB Memory before query: 11.652 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'mod_elastislide.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (65,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.07 ms
    optimizing0.05 ms
    statistics0.10 ms
    preparing0.14 ms
    executing0.01 ms
    Sorting result0.04 ms
    Sending data0.05 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.02 ms
    updating status0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:111
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_caroufredsel/helper.php:85
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:42
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.96 ms After last query: 0.28 ms Query memory: 0.038 MB Memory before query: 11.662 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (64,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.06 ms
    optimizing0.04 ms
    statistics0.08 ms
    preparing0.06 ms
    executing0.01 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    19FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    18Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    17FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:326
    16PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:289
    15PlgSystemFields->onContentAfterDisplay()JROOT/libraries/joomla/event/event.php:70
    14JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    13JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    12Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/modules/mod_caroufredsel/helper.php:92
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:42
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  39. Query Time: 0.96 ms After last query: 0.68 ms Query memory: 0.039 MB Memory before query: 11.677 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'mod_elastislide.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (64,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.05 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    18PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    15JHtmlContent::prepare()Same as call in the line below.
    14call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    13Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:111
    12Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_caroufredsel/helper.php:85
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:42
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.35 ms After last query: 10.02 ms Query memory: 0.028 MB Memory before query: 11.845 MB Rows returned: 1
    SELECT id,parent_id 
      FROM ajb18_menu 
      WHERE id = 101
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.00 ms
    Unlocking tables0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.00 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.27 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 11.855 MB Rows returned: 1
    SELECT id,parent_id 
      FROM ajb18_menu 
      WHERE id = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEajb18_menuconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.00 ms
    Unlocking tables0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.00 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1652
    20JDatabaseDriver->loadObject()JROOT/modules/mod_icemegamenu/libs/menucore.php:83
    19IceMenuTree->getCurrentMenuItem()JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    18IceMenuTree->__construct()JROOT/modules/mod_icemegamenu/helper.php:46
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.59 ms After last query: 3.68 ms Query memory: 0.030 MB Memory before query: 12.001 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM ajb18_modules AS m 
      LEFT JOIN ajb18_modules_menu AS mm 
      ON mm.moduleid = m.id 
      WHERE  m.id in(155) 
      AND m.published > 0 
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Creating tmp table0.04 ms
    Copying to tmp table0.04 ms
    Removing duplicates0.01 ms
    Sending data0.02 ms
    end0.00 ms
    removing tmp table0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    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.92 ms After last query: 0.93 ms Query memory: 0.046 MB Memory before query: 12.088 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM ajb18_categories as c

      LEFT JOIN ajb18_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=11

      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL56Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.11 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Sorting result0.09 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.08 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    34JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    33JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:305
    32Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    31Joomla\CMS\Categories\Categories->get()JROOT/modules/mod_articles_categories/helper.php:34
    30ModArticlesCategoriesHelper::getList()Same as call in the line below.
    29call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    28Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:559
    27Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_articles_categories/mod_articles_categories.php:28
    26include JROOT/modules/mod_articles_categories/mod_articles_categories.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    25Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  44. Query Time: 1.11 ms After last query: 0.63 ms Query memory: 0.049 MB Memory before query: 12.110 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

      FROM ajb18_categories as c

      LEFT JOIN ajb18_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)

      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=54

      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1Using filesort
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL56Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.04 ms
    statistics0.15 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    executing0.01 ms
    Sorting result0.12 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.05 ms
    freeing items0.02 ms
    updating status0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    41JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    40JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:305
    39Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:186
    38Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    37ContentRouter->getCategorySegment()Same as call in the line below.
    36call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    35Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:86
    34Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    33Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:669
    32Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    31Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:154
    30Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:66
    29Joomla\CMS\Router\Route::_()JROOT/templates/theme3196/html/mod_articles_categories/default_items.php:14
    28require JROOT/templates/theme3196/html/mod_articles_categories/default_items.phpJROOT/modules/mod_articles_categories/tmpl/default.php:13
    27require JROOT/modules/mod_articles_categories/tmpl/default.phpJROOT/modules/mod_articles_categories/mod_articles_categories.php:35
    26include JROOT/modules/mod_articles_categories/mod_articles_categories.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    25Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  45. Query Time: 0.53 ms After last query: 0.39 ms Query memory: 0.030 MB Memory before query: 12.102 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM ajb18_modules AS m 
      LEFT JOIN ajb18_modules_menu AS mm 
      ON mm.moduleid = m.id 
      WHERE  m.id in(220) 
      AND m.published > 0 
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Creating tmp table0.02 ms
    Copying to tmp table0.03 ms
    Removing duplicates0.01 ms
    Sending data0.02 ms
    end0.00 ms
    removing tmp table0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  46. Query Time: 0.52 ms After last query: 0.44 ms Query memory: 0.030 MB Memory before query: 12.133 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM ajb18_modules AS m 
      LEFT JOIN ajb18_modules_menu AS mm 
      ON mm.moduleid = m.id 
      WHERE  m.id in(221) 
      AND m.published > 0 
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Creating tmp table0.01 ms
    Copying to tmp table0.02 ms
    Removing duplicates0.01 ms
    Sending data0.01 ms
    end0.00 ms
    removing tmp table0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.02 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  47. Query Time: 1.14 ms After last query: 0.63 ms Query memory: 0.045 MB Memory before query: 12.202 MB Rows returned: 2
    Duplicate queries: #30
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

      FROM ajb18_content AS a

      LEFT JOIN ajb18_categories AS c 
      ON c.id = a.catid

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_by

      LEFT JOIN ajb18_users AS uam 
      ON uam.id = a.modified_by

      LEFT JOIN ajb18_categories as parent 
      ON parent.id = c.parent_id

      LEFT JOIN ajb18_content_rating AS v 
      ON a.id = v.content_id

      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (65) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-17 03:59:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-17 03:59:21')

      ORDER BY a.publish_up DESC 
      LIMIT 2
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1Using filesort
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const2Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    1SIMPLEveq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where
    Profile
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.02 ms
    Table lock0.01 ms
    init0.08 ms
    optimizing0.05 ms
    statistics0.11 ms
    preparing0.01 ms
    Unlocking tables0.06 ms
    executing0.00 ms
    Sorting result0.05 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    32JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    31JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    30Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    29Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:556
    28ContentModelArticles->getItems()JROOT/modules/mod_articles_news_adv/helper.php:107
    27ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    26include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    25Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  48. Query Time: 1.05 ms After last query: 0.68 ms Query memory: 0.047 MB Memory before query: 12.273 MB Rows returned: 0
    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

      FROM ajb18_fields AS a

      LEFT JOIN `ajb18_languages` AS l 
      ON l.lang_code = a.language

      LEFT JOIN ajb18_users AS uc 
      ON uc.id=a.checked_out

      LEFT JOIN ajb18_viewlevels AS ag 
      ON ag.id = a.access

      LEFT JOIN ajb18_users AS ua 
      ON ua.id = a.created_user_id

      LEFT JOIN ajb18_fields_groups AS g 
      ON g.id = a.group_id

      LEFT JOIN `ajb18_fields_categories` AS fc 
      ON fc.field_id = a.id

      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (64,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)

      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28dasblaue_haus_de_alam.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4dasblaue_haus_de_alam.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4dasblaue_haus_de_alam.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.06 ms
    optimizing0.04 ms
    statistics0.08 ms
    preparing0.05 ms
    executing0.01 ms
    Sorting result0.03 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    40JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    39JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    38Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:327
    37FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    36Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    35FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:378
    34PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    33JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    32JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    31JHtmlContent::prepare()Same as call in the line below.
    30call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    29Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:111
    28Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_articles_news_adv/helper.php:131
    27ModArticlesNewsAdvHelper::getList()JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    26include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    25Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/modules/mod_icemegamenu/libs/module_helper.php:123
    23IceModuleHelper->_renderModule()JROOT/modules/mod_icemegamenu/libs/module_helper.php:44
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  49. Query Time: 1.01 ms After last query: 2.30 ms Query memory: 0.030 MB Memory before query: 12.200 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM ajb18_modules AS m 
      LEFT JOIN ajb18_modules_menu AS mm 
      ON mm.moduleid = m.id 
      WHERE  m.id in(222) 
      AND m.published > 0 
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    executing0.00 ms
    Creating tmp table0.02 ms
    Copying to tmp table0.03 ms
    Removing duplicates0.01 ms
    Sending data0.01 ms
    end0.00 ms
    removing tmp table0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.02 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  50. Query Time: 0.49 ms After last query: 1.40 ms Query memory: 0.030 MB Memory before query: 12.237 MB Rows returned: 1
    SELECT distinct(m.id), title, module, position, content, showtitle, params 
      FROM ajb18_modules AS m 
      LEFT JOIN ajb18_modules_menu AS mm 
      ON mm.moduleid = m.id 
      WHERE  m.id in(223) 
      AND m.published > 0 
      ORDER BY position, ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmconstPRIMARY,publishedPRIMARY4const1Using temporary
    1SIMPLEmmrefPRIMARYPRIMARY4const1Using index; Distinct
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.00 ms
    Creating tmp table0.02 ms
    Copying to tmp table0.02 ms
    Removing duplicates0.01 ms
    Sending data0.01 ms
    end0.00 ms
    removing tmp table0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.03 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT/modules/mod_icemegamenu/libs/module_helper.php:174
    23IceModuleHelper->_getModules()JROOT/modules/mod_icemegamenu/libs/module_helper.php:43
    22IceModuleHelper->getContentByModule()JROOT/modules/mod_icemegamenu/libs/menucore.php:168
    21IceMenuTree->_getSubmenuByType()JROOT/modules/mod_icemegamenu/libs/menucore.php:286
    20IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:461
    19IceMenuTree->_getLevelXML()JROOT/modules/mod_icemegamenu/libs/menucore.php:142
    18IceMenuTree->toXML()JROOT/modules/mod_icemegamenu/helper.php:104
    17modIceMegamenuHelper::buildXML()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    14Joomla\CMS\Cache\Controller\CallbackController->call()JROOT/modules/mod_icemegamenu/helper.php:116
    13modIceMegamenuHelper->getXML()JROOT/modules/mod_icemegamenu/helper.php:155
    12modIceMegamenuHelper->render()JROOT/templates/theme3196/html/mod_icemegamenu/default.php:23
    11require JROOT/templates/theme3196/html/mod_icemegamenu/default.phpJROOT/modules/mod_icemegamenu/mod_icemegamenu.php:71
    10include JROOT/modules/mod_icemegamenu/mod_icemegamenu.phpJROOT/libraries/src/Helper/ModuleHelper.php:201
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:491
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:782
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1117
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:273
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]
  51. Query Time: 0.92 ms After last query: 2.01 ms Query memory: 0.044 MB Memory before query: 12.348 MB Rows returned: 1