• +251111550811
  • +251111550812
  • eeucommunication@gmail.com
EEU
  • Abouts
    • Our Mandate
    • Mission, Vision & Core Values
    • Corporate Structure
    • Our History
    • EEU Profile
    • Our Service Charter
  • Statistics&Tariffs
    • Tariffs
      • Domestic
      • Industrial
      • Commercial
    • Statistics
      • Transmission
      • Distribution
      • Regional
  • Projects
    • ERP
    • UEAP
    • Other Projects
  • PublicInfo
    • Power Interruptions
    • PrePaid User Guide
    • PostPaid User Guide
    • Consumer Rights and Obligations
    • Compliants Handling
    • Ease of Doing Business
    • FAQ
    • Notice
    • CBE Bill Payment
  • Opportunities
    • Vacancy
    • Tender
    • Downloads

headernew2013

Customer Satisfaction Survey Amharic Version January 07, 2021

  • Print
Hits: 20

Customer Satisfaction Survey Amharic Version January 07, 2021

Customer Satisfaction Survey English Version January 07, 2021

  • Print
Hits: 14

Customer Satisfaction Survey English Version January 07, 2021

PROGRESS REPORT OF EEU GENDER WORK PROGRAM FROM JULY 2019 - JUNE 2020

  • Print
Hits: 19

PROGRESS REPORT OF EEU GENDER WORK PROGRAM FROM JULY 2019 - JUNE 2020

ETHIOPIAN ELECTRIC UTILITY CITIZEN ENGAGEMENT PROGRAM FOR 2019-2020

  • Print
Hits: 26

ETHIOPIAN ELECTRIC UTILITY CITIZEN ENGAGEMENT PROGRAM FOR 2019-2020

የግብዓት አቅርቦት ችግሮችን ለመፍታት የሃገር ውስጥ አምራች ድርጅቶች ድርሻ ከፍተኛ መሆኑ ተጠቆመ

  • Print
Hits: 75
የኢትዮጵያ ኤሌክትሪክ አገልግሎት ዛሬ ታህሳስ 21 ቀን 2013 ዓ.ም ሜክሲኮ በሚገኘው የተቋሙ መሰብሰቢያ አዳራሽ ከዲስትሪቢዩሽን ዕቃ አምራች ድርጅቶች ጋር ውይይት አካሂዷል፡፡sales5
በውይይት መድረኩ የኢትዮጵያ ኤሌክትሪክ አገልግሎት ዋና ስራ አስፈፃሚ አቶ ሽፈራው ተሊላ፣ የዲስትሪቢዩሽን ዕቃ አምራች ድርጅቶች ዋና ስራ አስፈፃሚዎች፣ የክልል ኤሌክትሪክ አገልግሎት ስራ አስፈፃሚዎች፣የተቋሙ ከፍተኛ የስራ አመራሮች እና ጉዳዩ የሚመለከታቸው የስራ ሀላፊዎች ተሳታፊ ሆነውበታል፡፡

Read more: የግብዓት አቅርቦት ችግሮችን ለመፍታት የሃገር ውስጥ አምራች ድርጅቶች ድርሻ ከፍተኛ መሆኑ ተጠቆመ

  1. የሚኖ የፀሐይ ሃይል ማመንጫ ፕሮጀክት አገልግሎት መስጠት ጀመረ
  2. የስማርት ሜትር መሰረተ ልማት ዝርጋታ ለማከናወን የሚያስችል የውል ስምምነት ተፈረመ
  3. በትግራይ ክልል ተቋርጦ የነበረውን የኤሌክትሪክ አገልግሎት ሙሉ ለሙሉ ወደነበረበት ለመመለስ እየተሰራ ነው
  4. የተቋሙን የግብዓት አቅርቦት ችግሮችን ለመቅረፍ በርካታ ስራዎች በመሰራት ላይ ናቸው

Apply for Job

Vacancies Not Avaliable

ERP Links

EEU Employees

EEU Customers

EEU Vendor

EEU Web Portal User Manual

EEU CITZEN ENGAGEMENT 

Public Forum Manual

Girivance Redress Procedure

EEU Customer Satsfaction

CITZEN ENGAGEMENT(CE) Main Summery Report

 

የኢነርጂ አዋጅ

የሚኒስትሮች ምክር ቤት የኢነርጂ ደንብ

EEU Work Progress Report Final Draft

 

Careers@EEU

E-Recruitment

 

Emergency operation free call center

 

Phoneicon2CAll

CUSTOMER CARE

  • Customer Payment Centers
  • Understand Your Bill
  • Inquiry/ Compliant
  • Paying Your Bill
  • Current Tariff
  • Meter Information

Most Read Posts

  • የግብዓት አቅርቦት ችግሮችን ለመፍታት የሃገር ውስጥ አምራች ድርጅቶች ድርሻ ከፍተኛ መሆኑ ተጠቆመ
  • የሚኖ የፀሐይ ሃይል ማመንጫ ፕሮጀክት አገልግሎት መስጠት ጀመረ
  • ETHIOPIAN ELECTRIC UTILITY CITIZEN ENGAGEMENT PROGRAM FOR 2019-2020

Archived Articles

  • November, 2019
Last month January 2021 Next month
S M T W T F S
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

Contact Us

  • Emergency
  • Head Office
  • Social Media
  • Feedback

Media Center

  • News
  • Gallery
  • EEU TV
  • Press Release
  • Events

Electrical Tips

  • Electric Safety Tips
  • Energy Saving Tips

CUSTOMER CARE

  • Customer Payment Centers
  • Understand Your Bill
  • Inquiry/ Compliant
  • Paying Your Bill
  • Current Tariff
  • Meter Information
© 2018 Ethiopian Electric Utility.

Main Menu

  • Contact
  • Publications
    • Annual Reports
    • Region Reports
    • News Letter
    • Magazines
    • Plans
    • PlansLog
    • Forms And Templates
    • Communication

Search

bls certification

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1610741895,
                "last": 1610741895,
                "now": 1610741895
            },
            "token": "4VWeK4gJMEoNpBLB9JzUyLrUPFBY8Xsh"
        },
        "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: 48.06 ms / 48.06 ms Memory: 1.372 MB / 1.49 MB Application: afterLoad
Time: 195.22 ms / 243.28 ms Memory: 4.787 MB / 6.28 MB Application: afterInitialise
Time: 35.10 ms / 278.38 ms Memory: 0.637 MB / 6.91 MB Application: afterRoute
Time: 3.58 ms / 281.96 ms Memory: 0.032 MB / 6.94 MB Application: beforeRenderComponent com_content
Time: 26.14 ms / 308.09 ms Memory: 0.765 MB / 7.71 MB Application: Before Access::preloadComponents (all components)
Time: 3.22 ms / 311.32 ms Memory: 0.052 MB / 7.76 MB Application: After Access::preloadComponents (all components)
Time: 0.12 ms / 311.44 ms Memory: 0.000 MB / 7.76 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 2.08 ms / 313.52 ms Memory: 0.032 MB / 7.79 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 212.09 ms / 525.61 ms Memory: 1.891 MB / 9.68 MB Application: afterRenderComponent com_content
Time: 11.43 ms / 537.05 ms Memory: 0.101 MB / 9.78 MB Application: afterDispatch
Time: 100.45 ms / 637.50 ms Memory: 0.968 MB / 10.75 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 20.89 ms / 658.39 ms Memory: 0.164 MB / 10.92 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.16 ms / 658.55 ms Memory: 0.000 MB / 10.91 MB Application: beforeRenderModule mod_search (Search)
Time: 4.00 ms / 662.55 ms Memory: 0.017 MB / 10.93 MB Application: afterRenderModule mod_search (Search)
Time: 0.13 ms / 662.68 ms Memory: 0.000 MB / 10.92 MB Application: beforeRenderModule mod_ultimatefacebooklikeboxslider (Ultimate Facebook Like Box Slider)
Time: 2.46 ms / 665.14 ms Memory: 0.018 MB / 10.94 MB Application: afterRenderModule mod_ultimatefacebooklikeboxslider (Ultimate Facebook Like Box Slider)
Time: 0.32 ms / 665.46 ms Memory: 0.001 MB / 10.94 MB Application: beforeRenderModule mod_menu (CUSTOMER CARE)
Time: 11.09 ms / 676.55 ms Memory: 0.056 MB / 11.00 MB Application: afterRenderModule mod_menu (CUSTOMER CARE)
Time: 0.27 ms / 676.82 ms Memory: 0.000 MB / 10.99 MB Application: beforeRenderModule mod_menu (Electrical Tips)
Time: 5.48 ms / 682.30 ms Memory: 0.028 MB / 11.02 MB Application: afterRenderModule mod_menu (Electrical Tips)
Time: 0.24 ms / 682.54 ms Memory: 0.000 MB / 11.02 MB Application: beforeRenderModule mod_menu (Media Center)
Time: 9.84 ms / 692.38 ms Memory: 0.057 MB / 11.08 MB Application: afterRenderModule mod_menu (Media Center)
Time: 0.25 ms / 692.63 ms Memory: 0.000 MB / 11.07 MB Application: beforeRenderModule mod_menu (Contact Us )
Time: 8.45 ms / 701.07 ms Memory: 0.050 MB / 11.12 MB Application: afterRenderModule mod_menu (Contact Us )
Time: 0.24 ms / 701.31 ms Memory: 0.000 MB / 11.12 MB Application: beforeRenderModule mod_custom (Apply for Job)
Time: 2.94 ms / 704.25 ms Memory: 0.007 MB / 11.13 MB Application: afterRenderModule mod_custom (Apply for Job)
Time: 0.13 ms / 704.39 ms Memory: 0.000 MB / 11.12 MB Application: beforeRenderModule mod_custom (ERP Links)
Time: 1.85 ms / 706.24 ms Memory: 0.005 MB / 11.13 MB Application: afterRenderModule mod_custom (ERP Links)
Time: 0.13 ms / 706.37 ms Memory: 0.000 MB / 11.13 MB Application: beforeRenderModule mod_custom (Careers@EEU)
Time: 1.87 ms / 708.24 ms Memory: 0.005 MB / 11.13 MB Application: afterRenderModule mod_custom (Careers@EEU)
Time: 0.13 ms / 708.36 ms Memory: 0.000 MB / 11.13 MB Application: beforeRenderModule mod_custom (Emergency operation free call center)
Time: 1.85 ms / 710.21 ms Memory: 0.005 MB / 11.13 MB Application: afterRenderModule mod_custom (Emergency operation free call center)
Time: 0.14 ms / 710.35 ms Memory: 0.000 MB / 11.13 MB Application: beforeRenderModule mod_menu (CUSTOMER CARE)
Time: 9.00 ms / 719.35 ms Memory: 0.008 MB / 11.14 MB Application: afterRenderModule mod_menu (CUSTOMER CARE)
Time: 0.15 ms / 719.50 ms Memory: 0.000 MB / 11.14 MB Application: beforeRenderModule mod_articles_popular (Most Read Posts)
Time: 15.96 ms / 735.46 ms Memory: 0.105 MB / 11.24 MB Application: afterRenderModule mod_articles_popular (Most Read Posts)
Time: 0.23 ms / 735.69 ms Memory: 0.000 MB / 11.18 MB Application: beforeRenderModule mod_articles_archive (Archived Articles)
Time: 5.56 ms / 741.25 ms Memory: 0.035 MB / 11.21 MB Application: afterRenderModule mod_articles_archive (Archived Articles)
Time: 0.16 ms / 741.41 ms Memory: 0.000 MB / 11.21 MB Application: beforeRenderModule mod_jevents_cal (Calendar)
Time: 48.05 ms / 789.46 ms Memory: 1.094 MB / 12.31 MB Application: Before Access::getAssetRules (id:102 name:com_jevents)
Time: 0.19 ms / 789.64 ms Memory: 0.005 MB / 12.31 MB Application: After Access::getAssetRules (id:102 name:com_jevents)
Time: 70.01 ms / 859.65 ms Memory: 1.172 MB / 13.48 MB Application: afterRenderModule mod_jevents_cal (Calendar)
Time: 0.46 ms / 860.11 ms Memory: 0.014 MB / 13.50 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)
Time: 28.46 ms / 888.57 ms Memory: 0.298 MB / 13.80 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)
Time: 0.27 ms / 888.84 ms Memory: 0.000 MB / 13.77 MB Application: beforeRenderModule mod_custom (Header)
Time: 1.89 ms / 890.73 ms Memory: 0.005 MB / 13.78 MB Application: afterRenderModule mod_custom (Header)
Time: 17.10 ms / 907.83 ms Memory: 0.165 MB / 13.94 MB Application: afterRender

Database queries total: 97.72 ms

Memory Usage

14.31 MB (15,001,128 Bytes)

Database Queries

26 Queries Logged 97.72 ms


  1. Query Time: 0.59 ms Query memory: 0.013 MB Memory before query: 3.220 MB Rows returned: 0
    SELECT `data`
    
      FROM `pnu4z_session`
      WHERE `session_id` = 'c0j7ru37114fjgkdicmqca24v1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_sessionconstPRIMARYPRIMARY766const1
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.25 ms
    preparing0.01 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 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:854
    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:451
    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.35 ms After last query: 4.04 ms Query memory: 0.008 MB Memory before query: 3.338 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `pnu4z_session`
      WHERE `session_id` = 'c0j7ru37114fjgkdicmqca24v1'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_sessionconstPRIMARYPRIMARY766const1Using index
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 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:214
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT\libraries\src\Application\CMSApplication.php:856
    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:451
    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: 1.54 ms After last query: 0.38 ms Query memory: 0.005 MB Memory before query: 3.347 MB
    INSERT INTO `pnu4z_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('c0j7ru37114fjgkdicmqca24v1', 1, '1610741895', 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `pnu4z_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('c0j7ru37114fjgkdicmqca24v1', 1, '1610741895', 0, '', 0)
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    update0.26 ms
    end0.01 ms
    query end1.03 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT\libraries\src\Application\CMSApplication.php:254
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT\libraries\src\Application\CMSApplication.php:856
    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:451
    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.83 ms After last query: 8.83 ms Query memory: 0.018 MB Memory before query: 3.608 MB Rows returned: 36
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `pnu4z_extensions`
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_extensionsrefextensionextension82const36Using index condition
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.39 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    11JDatabaseDriver->loadObjectList()JROOT\libraries\src\Component\ComponentHelper.php:423
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT\libraries\src\Component\ComponentHelper.php:431
    7Joomla\CMS\Component\ComponentHelper::load()JROOT\libraries\src\Component\ComponentHelper.php:497
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT\libraries\src\Component\ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT\libraries\src\Component\ComponentHelper.php:103
    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:303
    1Joomla\CMS\Application\CMSApplication->execute()JROOT\index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.37 ms After last query: 8.03 ms Query memory: 0.009 MB Memory before query: 3.844 MB Rows returned: 5
    SELECT id, rules
    
      FROM `pnu4z_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 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
    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:303
    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.46 ms After last query: 0.38 ms Query memory: 0.010 MB Memory before query: 3.860 MB Rows returned: 2
    SELECT b.id
    
      FROM pnu4z_usergroups AS a
      LEFT JOIN pnu4z_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.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.01 ms
    Unlocking tables0.03 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 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
    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:303
    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: 1.66 ms After last query: 1.90 ms Query memory: 0.011 MB Memory before query: 3.932 MB Rows returned: 79
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM pnu4z_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
    1SIMPLEpnu4z_extensionsrefextensionextension82const97Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.72 ms
    Sending data0.30 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.08 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:303
    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: 2.57 ms After last query: 29.31 ms Query memory: 0.031 MB Memory before query: 4.822 MB Rows returned: 69
    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 pnu4z_menu AS m
      LEFT JOIN pnu4z_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_language1const99Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4eeuprjoom.m.component_id1Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.63 ms
    Sending data1.43 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    30JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    29JDatabaseDriver->loadObjectList()JROOT\libraries\src\Menu\SiteMenu.php:93
    28Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    27call_user_func_array()JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    26Joomla\CMS\Cache\Controller\CallbackController->get()JROOT\libraries\src\Menu\SiteMenu.php:101
    25Joomla\CMS\Menu\SiteMenu->load()JROOT\libraries\src\Menu\AbstractMenu.php:76
    24Joomla\CMS\Menu\AbstractMenu->__construct()JROOT\libraries\src\Menu\SiteMenu.php:62
    23Joomla\CMS\Menu\SiteMenu->__construct()JROOT\libraries\src\Menu\AbstractMenu.php:131
    22Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT\libraries\src\Application\CMSApplication.php:482
    21Joomla\CMS\Application\CMSApplication->getMenu()JROOT\libraries\src\Application\SiteApplication.php:275
    20Joomla\CMS\Application\SiteApplication->getMenu()JROOT\libraries\src\Application\SiteApplication.php:436
    19Joomla\CMS\Application\SiteApplication->getTemplate()JROOT\libraries\src\HTML\HTMLHelper.php:365
    18Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()JROOT\libraries\src\HTML\HTMLHelper.php:712
    17Joomla\CMS\HTML\HTMLHelper::script()Same as call in the line below.
    16call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    15Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    14Joomla\CMS\HTML\HTMLHelper::_()JROOT\libraries\cms\html\jquery.php:52
    13JHtmlJquery::framework()Same as call in the line below.
    12call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    11Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    10Joomla\CMS\HTML\HTMLHelper::_()JROOT\plugins\system\helixultimate\platform\options.php:17
    9require_once JROOT\plugins\system\helixultimate\platform\options.phpJROOT\plugins\system\helixultimate\platform\platform.php:13
    8require_once JROOT\plugins\system\helixultimate\platform\platform.phpJROOT\plugins\system\helixultimate\helixultimate.php:15
    7require_once JROOT\plugins\system\helixultimate\helixultimate.phpJROOT\libraries\src\Plugin\PluginHelper.php:253
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT\libraries\src\Plugin\PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT\libraries\src\Application\CMSApplication.php:721
    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:303
    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.74 ms After last query: 5.48 ms Query memory: 0.028 MB Memory before query: 5.147 MB Rows returned: 4
    SELECT id, home, template, s.params
    
      FROM pnu4z_template_styles as s
      LEFT JOIN pnu4z_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 USEDNULLNULL6Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.08 ms
    preparing0.06 ms
    executing0.01 ms
    Sending data0.21 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.06 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\Application\SiteApplication.php:488
    19Joomla\CMS\Application\SiteApplication->getTemplate()JROOT\libraries\src\HTML\HTMLHelper.php:365
    18Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()JROOT\libraries\src\HTML\HTMLHelper.php:712
    17Joomla\CMS\HTML\HTMLHelper::script()Same as call in the line below.
    16call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    15Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    14Joomla\CMS\HTML\HTMLHelper::_()JROOT\libraries\cms\html\jquery.php:52
    13JHtmlJquery::framework()Same as call in the line below.
    12call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    11Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    10Joomla\CMS\HTML\HTMLHelper::_()JROOT\plugins\system\helixultimate\platform\options.php:17
    9require_once JROOT\plugins\system\helixultimate\platform\options.phpJROOT\plugins\system\helixultimate\platform\platform.php:13
    8require_once JROOT\plugins\system\helixultimate\platform\platform.phpJROOT\plugins\system\helixultimate\helixultimate.php:15
    7require_once JROOT\plugins\system\helixultimate\helixultimate.phpJROOT\libraries\src\Plugin\PluginHelper.php:253
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT\libraries\src\Plugin\PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT\libraries\src\Application\CMSApplication.php:721
    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:303
    1Joomla\CMS\Application\CMSApplication->execute()JROOT\index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.72 ms After last query: 4.34 ms Query memory: 0.022 MB Memory before query: 5.219 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `pnu4z_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.26 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    28JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1652
    27JDatabaseDriver->loadObject()JROOT\libraries\src\Helper\LibraryHelper.php:167
    26Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    25call_user_func_array()JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    24Joomla\CMS\Cache\Controller\CallbackController->get()JROOT\libraries\src\Helper\LibraryHelper.php:175
    23Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT\libraries\src\Helper\LibraryHelper.php:43
    22Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT\libraries\src\Helper\LibraryHelper.php:90
    21Joomla\CMS\Helper\LibraryHelper::getParams()JROOT\libraries\src\Version.php:321
    20Joomla\CMS\Version->getMediaVersion()JROOT\libraries\src\Factory.php:778
    19Joomla\CMS\Factory::createDocument()JROOT\libraries\src\Factory.php:234
    18Joomla\CMS\Factory::getDocument()JROOT\libraries\src\HTML\HTMLHelper.php:731
    17Joomla\CMS\HTML\HTMLHelper::script()Same as call in the line below.
    16call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    15Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    14Joomla\CMS\HTML\HTMLHelper::_()JROOT\libraries\cms\html\jquery.php:52
    13JHtmlJquery::framework()Same as call in the line below.
    12call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    11Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    10Joomla\CMS\HTML\HTMLHelper::_()JROOT\plugins\system\helixultimate\platform\options.php:17
    9require_once JROOT\plugins\system\helixultimate\platform\options.phpJROOT\plugins\system\helixultimate\platform\platform.php:13
    8require_once JROOT\plugins\system\helixultimate\platform\platform.phpJROOT\plugins\system\helixultimate\helixultimate.php:15
    7require_once JROOT\plugins\system\helixultimate\helixultimate.phpJROOT\libraries\src\Plugin\PluginHelper.php:253
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT\libraries\src\Plugin\PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT\libraries\src\Application\CMSApplication.php:721
    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:303
    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: 2.12 ms After last query: 0.60 ms Query memory: 0.016 MB Memory before query: 5.223 MB
    UPDATE `pnu4z_extensions`
    
      SET `params` = '{\"mediaversion\":\"a737d1b91707c107d457a2a2b9ff2e30\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `pnu4z_extensions` SET `params` = '{\"mediaversion\":\"a737d1b91707c107d457a2a2b9ff2e30\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.11 ms
    updating0.26 ms
    end0.01 ms
    query end1.49 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT\libraries\src\Helper\LibraryHelper.php:117
    22Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT\libraries\src\Version.php:372
    21Joomla\CMS\Version->setMediaVersion()JROOT\libraries\src\Version.php:331
    20Joomla\CMS\Version->getMediaVersion()JROOT\libraries\src\Factory.php:778
    19Joomla\CMS\Factory::createDocument()JROOT\libraries\src\Factory.php:234
    18Joomla\CMS\Factory::getDocument()JROOT\libraries\src\HTML\HTMLHelper.php:731
    17Joomla\CMS\HTML\HTMLHelper::script()Same as call in the line below.
    16call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    15Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    14Joomla\CMS\HTML\HTMLHelper::_()JROOT\libraries\cms\html\jquery.php:52
    13JHtmlJquery::framework()Same as call in the line below.
    12call_user_func_array()JROOT\libraries\src\HTML\HTMLHelper.php:239
    11Joomla\CMS\HTML\HTMLHelper::call()JROOT\libraries\src\HTML\HTMLHelper.php:146
    10Joomla\CMS\HTML\HTMLHelper::_()JROOT\plugins\system\helixultimate\platform\options.php:17
    9require_once JROOT\plugins\system\helixultimate\platform\options.phpJROOT\plugins\system\helixultimate\platform\platform.php:13
    8require_once JROOT\plugins\system\helixultimate\platform\platform.phpJROOT\plugins\system\helixultimate\helixultimate.php:15
    7require_once JROOT\plugins\system\helixultimate\helixultimate.phpJROOT\libraries\src\Plugin\PluginHelper.php:253
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT\libraries\src\Plugin\PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT\libraries\src\Application\CMSApplication.php:721
    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:303
    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.82 ms After last query: 102.25 ms Query memory: 0.009 MB Memory before query: 6.926 MB Rows returned: 1
    SELECT *
    
      FROM pnu4z_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.38 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 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:303
    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: 2.20 ms After last query: 28.71 ms Query memory: 0.018 MB Memory before query: 7.714 MB Rows returned: 34
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pnu4z_assets`
      WHERE `name` IN ('root.1','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_fsf','com_installer','com_jce','com_jevents','com_joomlaupdate','com_jsecurelite','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_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_assetsrangeidx_asset_nameidx_asset_name202NULL37Using index condition
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.11 ms
    optimizing0.02 ms
    statistics0.27 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data1.35 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.06 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\Access\Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT\libraries\src\Access\Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT\libraries\src\Access\Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT\libraries\src\Access\Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT\libraries\src\User\User.php:398
    15Joomla\CMS\User\User->authorise()JROOT\components\com_content\models\articles.php:114
    14ContentModelArticles->populateState()JROOT\components\com_content\models\featured.php:44
    13ContentModelFeatured->populateState()JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:435
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT\libraries\src\MVC\View\HtmlView.php:423
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT\components\com_content\views\featured\view.html.php:54
    10ContentViewFeatured->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:43
    6require_once JROOT\components\com_content\content.phpJROOT\libraries\src\Component\ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT\libraries\src\Component\ComponentHelper.php:357
    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:303
    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: 56.88 ms After last query: 6.72 ms Query memory: 0.023 MB Memory before query: 7.856 MB Rows returned: 9
    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
      FROM pnu4z_content AS a
      LEFT JOIN pnu4z_categories AS c
      ON c.id = a.catid
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pnu4z_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pnu4z_categories as parent
      ON parent.id = c.parent_id
      WHERE a.featured = 1
      AND a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-15 20:18:15')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-15 20:18:15')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL53Using where; Using temporary; Using filesort
    1SIMPLEarefidx_access,idx_state,idx_catid,idx_featured_catididx_featured_catid5const,eeuprjoom.c.id3Using index condition; Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4eeuprjoom.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4eeuprjoom.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4eeuprjoom.c.parent_id1Using where
    Profile
    StatusDuration
    starting0.24 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.11 ms
    optimizing0.06 ms
    statistics1.14 ms
    preparing0.11 ms
    executing0.01 ms
    Creating tmp table1.34 ms
    Copying to tmp table50.61 ms
    Sorting result1.14 ms
    Sending data0.57 ms
    end0.01 ms
    removing tmp table1.19 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.02 ms
    updating status0.08 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\MVC\Model\BaseDatabaseModel.php:308
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT\libraries\src\MVC\Model\ListModel.php:187
    14Joomla\CMS\MVC\Model\ListModel->getItems()JROOT\components\com_content\models\articles.php:558
    13ContentModelArticles->getItems()JROOT\components\com_content\models\featured.php:125
    12ContentModelFeatured->getItems()JROOT\libraries\src\MVC\View\HtmlView.php:423
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT\components\com_content\views\featured\view.html.php:55
    10ContentViewFeatured->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:43
    6require_once JROOT\components\com_content\content.phpJROOT\libraries\src\Component\ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT\libraries\src\Component\ComponentHelper.php:357
    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:303
    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: 4.07 ms After last query: 9.64 ms Query memory: 0.013 MB Memory before query: 8.219 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM pnu4z_content AS a
      LEFT JOIN pnu4z_categories AS c
      ON c.id = a.catid
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pnu4z_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pnu4z_categories as parent
      ON parent.id = c.parent_id
      WHERE a.featured = 1
      AND a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-15 20:18:15')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-15 20:18:15')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL53Using where
    1SIMPLEarefidx_access,idx_state,idx_catid,idx_featured_catididx_featured_catid5const,eeuprjoom.c.id3Using index condition; Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.05 ms
    statistics0.16 ms
    preparing0.01 ms
    Unlocking tables0.08 ms
    executing0.01 ms
    Sending data3.31 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1730
    15JDatabaseDriver->loadResult()JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:335
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT\libraries\src\MVC\Model\ListModel.php:282
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT\libraries\src\MVC\Model\ListModel.php:232
    12Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT\libraries\src\MVC\View\HtmlView.php:423
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT\components\com_content\views\featured\view.html.php:56
    10ContentViewFeatured->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:43
    6require_once JROOT\components\com_content\content.phpJROOT\libraries\src\Component\ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT\libraries\src\Component\ComponentHelper.php:357
    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:303
    1Joomla\CMS\Application\CMSApplication->execute()JROOT\index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 1.09 ms After last query: 24.17 ms Query memory: 0.022 MB Memory before query: 8.768 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 `pnu4z_categories` AS `s`
      INNER JOIN `pnu4z_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.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 = 9
      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 USEDNULLNULL53Using where
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.07 ms
    optimizing0.04 ms
    statistics0.20 ms
    preparing0.01 ms
    Unlocking tables0.04 ms
    executing0.01 ms
    Sorting result0.17 ms
    Sending data0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.02 ms
    updating status0.06 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\Categories\Categories.php:314
    20Joomla\CMS\Categories\Categories->_load()JROOT\libraries\src\Categories\Categories.php:186
    19Joomla\CMS\Categories\Categories->get()JROOT\administrator\components\com_fields\models\fields.php:197
    18FieldsModelFields->getListQuery()JROOT\libraries\src\MVC\Model\ListModel.php:133
    17Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT\libraries\src\MVC\Model\ListModel.php:187
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT\administrator\components\com_fields\helpers\fields.php:136
    15FieldsHelper::getFields()JROOT\plugins\system\fields\fields.php:427
    14PlgSystemFields->onContentPrepare()Same as call in the line below.
    13call_user_func_array()JROOT\libraries\joomla\event\event.php:70
    12JEvent->update()JROOT\libraries\joomla\event\dispatcher.php:160
    11JEventDispatcher->trigger()JROOT\components\com_content\views\featured\view.html.php:98
    10ContentViewFeatured->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:43
    6require_once JROOT\components\com_content\content.phpJROOT\libraries\src\Component\ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT\libraries\src\Component\ComponentHelper.php:357
    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:303
    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.96 ms After last query: 2.07 ms Query memory: 0.021 MB Memory before query: 8.833 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 pnu4z_fields AS a
      LEFT JOIN `pnu4z_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pnu4z_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pnu4z_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pnu4z_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `pnu4z_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 (9,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_langcode28eeuprjoom.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4eeuprjoom.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4eeuprjoom.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4eeuprjoom.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4eeuprjoom.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4eeuprjoom.a.id1Using where; Using index
    Profile
    StatusDuration
    starting0.17 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.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.08 ms
    optimizing0.05 ms
    statistics0.11 ms
    preparing0.08 ms
    executing0.01 ms
    Sorting result0.04 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.02 ms
    updating status0.06 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\MVC\Model\BaseDatabaseModel.php:308
    18Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT\administrator\components\com_fields\models\fields.php:327
    17FieldsModelFields->_getList()JROOT\libraries\src\MVC\Model\ListModel.php:187
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT\administrator\components\com_fields\helpers\fields.php:136
    15FieldsHelper::getFields()JROOT\plugins\system\fields\fields.php:427
    14PlgSystemFields->onContentPrepare()Same as call in the line below.
    13call_user_func_array()JROOT\libraries\joomla\event\event.php:70
    12JEvent->update()JROOT\libraries\joomla\event\dispatcher.php:160
    11JEventDispatcher->trigger()JROOT\components\com_content\views\featured\view.html.php:98
    10ContentViewFeatured->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:43
    6require_once JROOT\components\com_content\content.phpJROOT\libraries\src\Component\ComponentHelper.php:382
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT\libraries\src\Component\ComponentHelper.php:357
    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:303
    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: 2.44 ms After last query: 111.45 ms Query memory: 0.014 MB Memory before query: 9.715 MB Rows returned: 6
    SHOW FULL COLUMNS 
      FROM `pnu4z_template_styles`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `pnu4z_template_styles`
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    Opening tables1.21 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Filling schema table0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    checking permissions0.06 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    closing tables0.01 ms
    executing0.01 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.57 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    14JDatabaseDriver->loadObjectList()JROOT\libraries\joomla\database\driver\mysqli.php:430
    13JDatabaseDriverMysqli->getTableColumns()JROOT\libraries\src\Table\Table.php:245
    12Joomla\CMS\Table\Table->getFields()JROOT\libraries\src\Table\Table.php:164
    11Joomla\CMS\Table\Table->__construct()JROOT\administrator\components\com_templates\tables\style.php:30
    10TemplatesTableStyle->__construct()JROOT\libraries\src\Table\Table.php:312
    9Joomla\CMS\Table\Table::getInstance()JROOT\plugins\system\helixultimate\helixultimate.php:41
    8plgSystemHelixultimate->onAfterDispatch()Same as call in the line below.
    7call_user_func_array()JROOT\libraries\joomla\event\event.php:70
    6JEvent->update()JROOT\libraries\joomla\event\dispatcher.php:160
    5JEventDispatcher->trigger()JROOT\libraries\src\Application\BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT\libraries\src\Application\SiteApplication.php:199
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT\libraries\src\Application\SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT\libraries\src\Application\CMSApplication.php:303
    1Joomla\CMS\Application\CMSApplication->execute()JROOT\index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.50 ms After last query: 2.76 ms Query memory: 0.010 MB Memory before query: 9.754 MB Rows returned: 1
    SELECT *
    
      FROM pnu4z_template_styles
      WHERE `id` = '9'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_template_stylesconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    Unlocking tables0.02 ms
    executing0.01 ms
    Sending data0.12 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1455
    10JDatabaseDriver->loadAssoc()JROOT\libraries\src\Table\Table.php:731
    9Joomla\CMS\Table\Table->load()JROOT\plugins\system\helixultimate\helixultimate.php:42
    8plgSystemHelixultimate->onAfterDispatch()Same as call in the line below.
    7call_user_func_array()JROOT\libraries\joomla\event\event.php:70
    6JEvent->update()JROOT\libraries\joomla\event\dispatcher.php:160
    5JEventDispatcher->trigger()JROOT\libraries\src\Application\BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT\libraries\src\Application\SiteApplication.php:199
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT\libraries\src\Application\SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT\libraries\src\Application\CMSApplication.php:303
    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: 2.01 ms After last query: 67.15 ms Query memory: 0.017 MB Memory before query: 10.694 MB Rows returned: 28
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM pnu4z_modules AS m
      LEFT JOIN pnu4z_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN pnu4z_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 <= '2021-01-15 20:18:15')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-15 20:18:15')
      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
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const36Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4eeuprjoom.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403eeuprjoom.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.05 ms
    optimizing0.05 ms
    statistics0.12 ms
    preparing0.08 ms
    executing0.01 ms
    Sorting result0.35 ms
    Sending data1.00 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 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()Same as call in the line below.
    17call_user_func_array()JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    16Joomla\CMS\Cache\Controller\CallbackController->get()JROOT\libraries\src\Helper\ModuleHelper.php:433
    15Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT\libraries\src\Helper\ModuleHelper.php:363
    14Joomla\CMS\Helper\ModuleHelper::load()JROOT\libraries\src\Helper\ModuleHelper.php:87
    13Joomla\CMS\Helper\ModuleHelper::getModules()JROOT\libraries\src\Document\HtmlDocument.php:581
    12Joomla\CMS\Document\HtmlDocument->countModules()JROOT\plugins\system\helixultimate\core\helixultimate.php:562
    11HelixUltimate->count_modules()JROOT\plugins\system\helixultimate\core\helixultimate.php:370
    10HelixUltimate->get_current_row()JROOT\plugins\system\helixultimate\core\helixultimate.php:304
    9HelixUltimate->get_recursive_layout()JROOT\plugins\system\helixultimate\core\helixultimate.php:272
    8HelixUltimate->render_layout()JROOT\templates\shaper_helixultimate\index.php:120
    7require JROOT\templates\shaper_helixultimate\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:1126
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    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: 8.75 ms After last query: 120.64 ms Query memory: 0.021 MB Memory before query: 11.194 MB Rows returned: 3
    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
      FROM pnu4z_content AS a
      LEFT JOIN pnu4z_categories AS c
      ON c.id = a.catid
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pnu4z_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pnu4z_categories as parent
      ON parent.id = c.parent_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 (8,9)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-15 20:18:15')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-15 20:18:15')
      AND a.created >= DATE_SUB('2021-01-15 20:18:15', INTERVAL 30 DAY)
      ORDER BY a.hits DESC
      LIMIT 3
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcALLPRIMARY,idx_accessNO INDEX KEY COULD BE USEDNULLNULL53Using where; Using temporary; Using filesort
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4eeuprjoom.c.id4Using index condition; Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4eeuprjoom.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4eeuprjoom.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4eeuprjoom.c.parent_id1Using where
    Profile
    StatusDuration
    starting0.24 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.11 ms
    optimizing0.06 ms
    statistics0.16 ms
    preparing0.10 ms
    executing0.01 ms
    Creating tmp table1.28 ms
    Copying to tmp table5.41 ms
    Sorting result0.07 ms
    Sending data0.32 ms
    end0.01 ms
    removing tmp table0.63 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.02 ms
    freeing items0.02 ms
    updating status0.07 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:558
    12ContentModelArticles->getItems()JROOT\modules\mod_articles_popular\helper.php:76
    11ModArticlesPopularHelper::getList()JROOT\modules\mod_articles_popular\mod_articles_popular.php:15
    10include JROOT\modules\mod_articles_popular\mod_articles_popular.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:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT\libraries\src\Document\HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT\libraries\src\Application\CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    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.60 ms After last query: 6.40 ms Query memory: 0.012 MB Memory before query: 11.219 MB Rows returned: 1
    SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
    
      FROM pnu4z_content
      WHERE state = 2
      GROUP BY YEAR(`created`), MONTH(`created`)
      ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC
      LIMIT 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpnu4z_contentrefidx_stateidx_state1const5Using where; Using temporary; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Creating tmp table0.04 ms
    Copying to tmp table0.06 ms
    Sorting result0.02 ms
    Sending data0.02 ms
    end0.01 ms
    removing tmp table0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    12JDatabaseDriver->loadObjectList()JROOT\modules\mod_articles_archive\helper.php:51
    11ModArchiveHelper::getList()JROOT\modules\mod_articles_archive\mod_articles_archive.php:17
    10include JROOT\modules\mod_articles_archive\mod_articles_archive.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:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT\libraries\src\Document\HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT\libraries\src\Application\CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    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: 2.75 ms After last query: 77.77 ms Query memory: 0.023 MB Memory before query: 13.166 MB Rows returned: 18
    SHOW FULL COLUMNS 
      FROM `pnu4z_jev_users`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `pnu4z_jev_users`
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    Opening tables1.21 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Filling schema table0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    checking permissions0.06 ms
    checking permissions0.03 ms
    checking permissions0.03 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.03 ms
    checking permissions0.02 ms
    checking permissions0.03 ms
    closing tables0.01 ms
    executing0.01 ms
    Sending data0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.55 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.07 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    26JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    25JDatabaseDriver->loadObjectList()JROOT\libraries\joomla\database\driver\mysqli.php:430
    24JDatabaseDriverMysqli->getTableColumns()JROOT\libraries\src\Table\Table.php:245
    23Joomla\CMS\Table\Table->getFields()JROOT\libraries\src\Table\Table.php:164
    22Joomla\CMS\Table\Table->__construct()JROOT\administrator\components\com_jevents\tables\jevuser.php:69
    21TableUser->__construct()JROOT\components\com_jevents\libraries\helper.php:2308
    20JEVHelper::getAuthorisedUser()JROOT\components\com_jevents\libraries\helper.php:1201
    19JEVHelper::isEventCreator()JROOT\components\com_jevents\libraries\filters\Published.php:50
    18jevPublishedFilter->__construct()JROOT\components\com_jevents\libraries\filters.php:142
    17jevFilterProcessing->__construct()JROOT\components\com_jevents\libraries\filters.php:200
    16jevFilterProcessing::getInstance()JROOT\components\com_jevents\libraries\dbmodel.php:2323
    15JEventsDBModel->listIcalEvents()JROOT\components\com_jevents\libraries\dbmodel.php:2698
    14JEventsDBModel->listIcalEventsByMonth()JROOT\components\com_jevents\libraries\datamodel.php:243
    13JEventsDataModel->getCalendarData()JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
    12FlatModCalView->_displayCalendarMod()JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
    11DefaultModCalView->getCal()JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
    10include JROOT\modules\mod_jevents_cal\mod_jevents_cal.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:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT\libraries\src\Document\HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT\libraries\src\Application\CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    1Joomla\CMS\Application\CMSApplication->execute()JROOT\index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.91 ms After last query: 9.76 ms Query memory: 0.025 MB Memory before query: 13.336 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 `pnu4z_categories` AS `c`
      WHERE (c.extension='com_jevents' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrangecat_idx,idx_accesscat_idx207NULL4Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.06 ms
    optimizing0.03 ms
    statistics0.14 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.12 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    Unlocking tables0.01 ms
    freeing items0.01 ms
    updating status0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    25JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    24JDatabaseDriver->loadObjectList()JROOT\libraries\src\Categories\Categories.php:314
    23Joomla\CMS\Categories\Categories->_load()JROOT\components\com_jevents\helpers\category.php:47
    22JEventsCategories->_load()JROOT\libraries\src\Categories\Categories.php:186
    21Joomla\CMS\Categories\Categories->get()JROOT\components\com_jevents\libraries\dbmodel.php:90
    20JEventsDBModel->accessibleCategoryList()JROOT\components\com_jevents\libraries\datamodel.php:886
    19JEventsDataModel->accessibleCategoryList()JROOT\components\com_jevents\libraries\filters\Category.php:39
    18jevCategoryFilter->__construct()JROOT\components\com_jevents\libraries\filters.php:142
    17jevFilterProcessing->__construct()JROOT\components\com_jevents\libraries\filters.php:200
    16jevFilterProcessing::getInstance()JROOT\components\com_jevents\libraries\dbmodel.php:2323
    15JEventsDBModel->listIcalEvents()JROOT\components\com_jevents\libraries\dbmodel.php:2698
    14JEventsDBModel->listIcalEventsByMonth()JROOT\components\com_jevents\libraries\datamodel.php:243
    13JEventsDataModel->getCalendarData()JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
    12FlatModCalView->_displayCalendarMod()JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
    11DefaultModCalView->getCal()JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
    10include JROOT\modules\mod_jevents_cal\mod_jevents_cal.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:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT\libraries\src\Document\HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT\libraries\src\Application\CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    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.62 ms After last query: 0.77 ms Query memory: 0.018 MB Memory before query: 13.364 MB Rows returned: 1
    SELECT c.id
    
      FROM pnu4z_categories AS c
      WHERE c.access IN (1,1,5)
      AND c.published = 1
      AND c.language in ('en-GB','*')
      AND c.extension = 'com_jevents'
      ORDER BY c.lft asc
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcrangecat_idx,idx_access,idx_languagecat_idx207NULL2Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.13 ms
    preparing0.04 ms
    executing0.01 ms
    Sorting result0.08 ms
    Sending data0.03 ms
    end0.01 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
    22JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1540
    21JDatabaseDriver->loadColumn()JROOT\components\com_jevents\libraries\dbmodel.php:172
    20JEventsDBModel->accessibleCategoryList()JROOT\components\com_jevents\libraries\datamodel.php:886
    19JEventsDataModel->accessibleCategoryList()JROOT\components\com_jevents\libraries\filters\Category.php:39
    18jevCategoryFilter->__construct()JROOT\components\com_jevents\libraries\filters.php:142
    17jevFilterProcessing->__construct()JROOT\components\com_jevents\libraries\filters.php:200
    16jevFilterProcessing::getInstance()JROOT\components\com_jevents\libraries\dbmodel.php:2323
    15JEventsDBModel->listIcalEvents()JROOT\components\com_jevents\libraries\dbmodel.php:2698
    14JEventsDBModel->listIcalEventsByMonth()JROOT\components\com_jevents\libraries\datamodel.php:243
    13JEventsDataModel->getCalendarData()JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
    12FlatModCalView->_displayCalendarMod()JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
    11DefaultModCalView->getCal()JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
    10include JROOT\modules\mod_jevents_cal\mod_jevents_cal.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:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT\libraries\src\Document\HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT\libraries\src\Application\CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    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: 1.20 ms After last query: 4.90 ms Query memory: 0.030 MB Memory before query: 13.405 MB Rows returned: 0
    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM pnu4z_jevents_repetition as rpt
      INNER JOIN pnu4z_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      INNER JOIN pnu4z_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      INNER JOIN pnu4z_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN pnu4z_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
      WHERE ev.catid IN(-1,17)
      AND rpt.endrepeat >= '2021-01-01 00:00:00'
      AND rpt.startrepeat <= '2021-01-31 23:59:59'
      AND NOT (rpt.startrepeat < '2021-01-01 00:00:00'
      AND det.multiday=0)
      AND ev.state=1
      AND ev.access IN (1,1,5)
      AND icsf.state=1
      AND icsf.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLErptrangeeventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeatstartrepeat5NULL1Using index condition; Using where
    1SIMPLEeveq_refPRIMARY,icsid,stateidx,evaccessPRIMARY4eeuprjoom.rpt.eventid1Using where
    1SIMPLEicsfeq_refPRIMARY,stateidxPRIMARY4eeuprjoom.ev.icsid1Using where
    1SIMPLEdeteq_refPRIMARY,multidayPRIMARY4eeuprjoom.rpt.eventdetail_id1Using where
    1SIMPLErrALLeventidNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    starting0.18 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.01 ms
    Table lock0.01 ms
    init0.10 ms
    optimizing0.06 ms
    statistics0.18 ms
    preparing0.10 ms
    executing0.01 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    freeing items0.02 ms
    updating status0.09 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT\libraries\joomla\database\driver.php:1691
    17JDatabaseDriver->loadObjectList()JROOT\components\com_jevents\libraries\dbmodel.php:2570
    16JEventsDBModel->_cachedlistIcalEvents()JROOT\components\com_jevents\libraries\dbmodel.php:2519
    15JEventsDBModel->listIcalEvents()JROOT\components\com_jevents\libraries\dbmodel.php:2698
    14JEventsDBModel->listIcalEventsByMonth()JROOT\components\com_jevents\libraries\datamodel.php:243
    13JEventsDataModel->getCalendarData()JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
    12FlatModCalView->_displayCalendarMod()JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
    11DefaultModCalView->getCal()JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
    10include JROOT\modules\mod_jevents_cal\mod_jevents_cal.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:783
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT\libraries\src\Document\HtmlDocument.php:557
    4Joomla\CMS\Document\HtmlDocument->render()JROOT\libraries\src\Application\CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT\libraries\src\Application\SiteApplication.php:780
    2Joomla\CMS\Application\SiteApplication->render()JROOT\libraries\src\Application\CMSApplication.php:309
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 2 × 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
      FROM pnu4z_content AS a
      LEFT JOIN pnu4z_categories AS c
      ON c.id = a.catid
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pnu4z_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pnu4z_categories as parent
      ON parent.id = c.parent_id
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
     
      FROM `pnu4z_extensions`
  3. 1 × SELECT *
     
      FROM pnu4z_template_styles
  4. 1 × 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 pnu4z_fields AS a
      LEFT JOIN `pnu4z_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pnu4z_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pnu4z_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pnu4z_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `pnu4z_fields_categories` AS fc
      ON fc.field_id = a.id
  5. 1 × 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 `pnu4z_categories` AS `s`
      INNER JOIN `pnu4z_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
     
      FROM pnu4z_modules AS m
      LEFT JOIN pnu4z_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN pnu4z_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  7. 1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
     
      FROM pnu4z_content
  8. 1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
      FROM pnu4z_jevents_repetition as rpt
      INNER JOIN pnu4z_jevents_vevent as ev
      ON rpt.eventid = ev.ev_id
      INNER JOIN pnu4z_jevents_icsfile as icsf
      ON icsf.ics_id=ev.icsid
      INNER JOIN pnu4z_jevents_vevdetail as det
      ON det.evdet_id = rpt.eventdetail_id
      LEFT JOIN pnu4z_jevents_rrule as rr
      ON rr.eventid = rpt.eventid
  9. 1 × SELECT c.id
     
      FROM pnu4z_categories AS c
  10. 1 × 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 `pnu4z_categories` AS `c`
  11. 1 × SELECT COUNT(*)
     
      FROM pnu4z_content AS a
      LEFT JOIN pnu4z_categories AS c
      ON c.id = a.catid
      LEFT JOIN pnu4z_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pnu4z_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pnu4z_categories as parent
      ON parent.id = c.parent_id
  12. 1 × SELECT `id`,`name`,`rules`,`parent_id`
     
      FROM `pnu4z_assets`
  13. 1 × SELECT b.id
     
      FROM pnu4z_usergroups AS a
      LEFT JOIN pnu4z_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  14. 1 × SELECT id, rules
     
      FROM `pnu4z_viewlevels
  15. 1 × SELECT `session_id`
     
      FROM `pnu4z_session`
  16. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
     
      FROM pnu4z_extensions
  17. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
     
      FROM pnu4z_menu AS m
      LEFT JOIN pnu4z_extensions AS e
      ON m.component_id = e.extension_id
  18. 1 × SELECT *
     
      FROM pnu4z_languages
  19. 1 × SELECT id, home, template, s.params
     
      FROM pnu4z_template_styles as s
      LEFT JOIN pnu4z_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  20. 1 × SELECT `data`
     
      FROM `pnu4z_session`
OTHER Tables:
  1. 1 × SHOW FULL COLUMNS 
      FROM `pnu4z_jev_users
  2. 1 × SHOW FULL COLUMNS 
      FROM `pnu4z_template_styles
  3. 1 × UPDATE `pnu4z_extensions`
     
      SET `params` = '{\"mediaversion\":\"a737d1b91707c107d457a2a2b9ff2e30\"}'
  4. 1 × INSERT INTO `pnu4z_session`
     (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('c0j7ru37114fjgkdicmqca24v1', 1, '1610741895', 0, '', 0