www.750karaj.ir
  • Persian (Fa)
  • English (UK)
  • Home
  • Contact us
  • About us

Home

تسهیل امور در راستای دولت الکترونیک – گواهی اشتغال به تحصیل دانشجویی (همه دانشگاهها غیر از دانشگاه آزاد و دانشگاههای زیر نظر وزارت بهداشت)

  • Print
  • Email

 با راه اندازی سامانه سجاد وزارت علوم (https://portal.saorg.ir) امکان دریافت غیر حضوری گواهی اشتغال به تحصیل و ترجمه آن وجود دارد.

 مراحل دریافت غیرحضوری گواهی اشتغال به تحصیل

نمونه گواهی اشتغال به تحصیل دانشجویی الکترونیکی


 

تسهیل امور در راستای دولت الکترونیک – بیمه مرکزی (بیمه شخص ثالث و بدنه خودرو، بیمه مسئولیت ...)

  • Print
  • Email

 بیمه مرکزی جمهوری اسلامی ایران یکی از پیشگامان در زمینه ارائه خدمات الکترونیکی است. با مراجعه به وب سایت https://www.centinsur.ir از قسمت میز خدمات الکترونیک می توانید نسبت به ثبت درخواست و دریافت سوابق بیمه شخص ثالث خودرو، بیمه بدنه، بیمه مسئولیت ... اقدام بفرمایید. لازم به ذکر است ارسال فایل pdf دریافتی از وب سایت بیمه مرکزی  برای ترجمه رسمی و تایید کافی است و نیازی به مراجعه به دارالترجمه نیست.

 نحوه دریافت سوابق بیمه شخص ثالث، بیمه بدنه، بیمه مسئولیت ...

 نمونه سوابق بیمه شخص ثالث، بیمه بدنه، بیمه مسئولیت ...

نامه بیمه مرکزی به مدیر کل اسناد و امور مترجمان رسمی قوه قضائیه


 

تسهیل امور در راستای دولت الکترونیک – گواهی عدم سوء پیشینه

  • Print
  • Email

گواهی عدم سوء پیشینه که توسط دفاتر پلیس 10+ صادر می شد هم هزینه بیشتری داشت و هم اعتبار آن یک ماه قید می‌شد. اما در فرایند جدید، گواهی عدم سوء پیشینه را می توانید هم به صورت حضوری از طریق دفاتر خدمات قضایی و هم به صورت غیر حضوری دریافت نمایید. نسخه جدید گواهی عدم سوء پیشینه تاریخ انقضاء ندارند و فقط در آن قید شده که ظرف مدت 2 ماه از تاریخ صدور قابل استعلام از طریق سامانه https://adliran.ir می باشد.

الف) به صورت حضوری: برای درخواست حضوری لازم است به یک دفتر خدمات قضایی مراجعه کنید. برای یافتن نزدیک ترین دفتر به آدرس https://adliran.ir/Home/GetPolice مراجعه بفرمایید.

ب) غیرحضوری: برای دریافت خدمات غیر حضوری لازم است قبلا در سامانه ثنا ثبت نام کرده باشید. در صورت عدم ثبت نام لازم است با مراجعه به یکی از دفاتر خدمات قضایی (https://adliran.ir/Home/GetPolice) این کار را انجام دهید و می توانید همانجا تقاضای گواهی عدم سوء پیشینه را هم بدهید.

ب-1) از طریق اپلیکیشن موبایل عدالت همراه (این اپلیکیشن را می توانید از وب سایت https://adliran.ir یا از بازار دانلود و نصب نمایید). با کد ملی و رمز ثنا وارد شده و رمز موقت که به موبایل شما ارسال خواهد شد را وارد کنید و در صفحه اول قسمت گواهی عدم سوء پیشینه را لمس کرده و مراحل را تا انتها دنبال کنید. در نهایت شماره پیگیری و تاریخ صدور گواهی را به دارالترجمه اعلام کنید تا ترجمه و تایید انجام شود.

ب-2) از طریق وب سایت https://adliran.ir

1- وارد وب سایت https://adliran.ir شوید.

 2- از منوی سمت راست صفحه و در قسمت سرتیتر اطلاع رسانی، گزینه ثبت درخواست گواهی عدم سوء پیشینه را انتخاب کنید .

 3- کد ملی و رمز شخصی را وارد کنید. رمز موقت برای موبایل شما ارسال خواهد شد. آنرا وارد کرده و وارد مرحله بعدی شوید.

 4- گزینه درخواست جدید را انتخاب کنید و هزینه را پرداخت کنید. نهایتا کد رهگیری و تاریخ گواهی را برای دارالترجمه ارسال کنید تا کار ترجمه و تایید انجام شود.

 5- برای دریافت گواهی وارد سامانه https://adliran.ir شده و از قسمت خدمات ویژه بخش ابلاغ الکترونیک قضایی را انتخاب کنید و با وارد کردن کد ملی و رمز ثنا و رمز موقت وارد قسمت ابلاغیه های جدید شوید و شماره رهگیری و تاریخ گواهی عدم سوء پیشینه را برای دارالترجمه ارسال کنید. می توانید از قسمت دریافت نسخه چاپی، نسخه چاپی را ملاحظه بفرمایید.

نکته: مطابق با متن گواهی عدم سوء پیشینه، نسخه الکترونیک این گواهی کافی و معتبر بوده و نیاز به مهر ندارد و به همین صورت قابل ترجمه و تایید است. اما می توانید با مراجعه به دفتر خدمات قضایی با پرداخت هزینه نسخه مهر شده آنرا دریافت کنید.

نمونه گواهی عدم سوء پشینه


 

Introduction

  • Print
  • Email

 

Under the management of Masoud Shokrollahi, an official translator to the Judiciary of I. R. Iran, License No. 978, M. A. in translation studies, DTO commenced its operation in Karaj, Alborz Province, Iran on Dec. 22, 2008.

 

With several years of experience in official translation in Iran and believing in direct and specialized translation service according to ratified tariff, Mr. Shokrollahi personally established DTO.

 

Reasonable price and standard translation are among the mottos of DTO.

 

DTO has had the honor of serving natural and legal entities and shall do its utmost to serve its clients.

 

 

 

Official Translator

 

Masoud Shokrollahi
Education:
B.A. in Law from Payame Noor University (PNU)
M.A. in Translation Studies from University of Isfahan
B. A. in English Language and Translation from University of Qom

Experience: 

Aug. 30, 2008 up to now: Official translator to the Judiciary of I. R. Iran (English Language)

Membership: 

Aug. 30, 2008 up to now: Iranian Association of Official Translators (IAOT

 

  • You are here:  
  • Home

Main menu

  • Home
  • Contact us
  • About us

 آموزشگاه زبان ظفر

 02133247533

 



آدرس: کرج، میدان آزادگان، زیر پل آزادگان، ضلع جنوبی خیابان مطهری، نبش کوچه سبحانی، پلاک 50، طبقه 4، واحد 8

 کدپستی: 3143953579

تلفن: 34213134-026 و 34213135-026 و 34458314-026

فاکس: 34458314-026

نقشه

 

Back to Top

© 2022 www.750karaj.ir

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1660829452,
                "last": 1660829452,
                "now": 1660829452
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "47a90775a5658d90eabdb44e770c81c2e1a7c078": {
                    "link": "http:\/\/www.750karaj.ir\/index.php\/en\/2-uncategorised\/133-2021-01-07-05-26-12",
                    "expiry": 1660829452
                },
                "6bfc6d55f1e03441a739d1c7879f67a29f0e0a61": {
                    "link": "http:\/\/www.750karaj.ir\/index.php\/en\/2-uncategorised\/128-2021-01-06-04-23-03",
                    "expiry": 1660829452
                },
                "b002aed3ba914ccacdc07b9197ece5cef91dc547": {
                    "link": "http:\/\/www.750karaj.ir\/index.php\/en\/2-uncategorised\/125-2021-01-05-04-46-03",
                    "expiry": 1660829452
                },
                "03cac6b7e2f9abc7e803c9866ce3fe4d61050983": {
                    "link": "http:\/\/www.750karaj.ir\/index.php\/en\/about-us",
                    "expiry": 1660829452
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 12.57 ms / 12.57 ms Memory: 0.539 MB / 0.92 MB Application: afterLoad
Time: 76.21 ms / 88.78 ms Memory: 3.652 MB / 4.57 MB Application: afterInitialise
Time: 26.67 ms / 115.45 ms Memory: 1.489 MB / 6.06 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.27 ms / 116.72 ms Memory: 0.029 MB / 6.09 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.08 ms / 116.80 ms Memory: 0.000 MB / 6.09 MB Application: Start JAccess::getAssetRules Old (1)
Time: 0.46 ms / 117.26 ms Memory: 0.013 MB / 6.10 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.20 ms / 117.47 ms Memory: 0.001 MB / 6.10 MB Application: afterRoute
Time: 14.07 ms / 131.53 ms Memory: 0.189 MB / 6.29 MB Application: beforeRenderComponent com_content
Time: 10.38 ms / 141.92 ms Memory: 0.471 MB / 6.76 MB Application: Start JAccess::preload(components)
Time: 14.52 ms / 156.44 ms Memory: 0.188 MB / 6.95 MB Application: Finish JAccess::preload(components)
Time: 72.06 ms / 228.49 ms Memory: 1.994 MB / 8.94 MB Application: afterRenderComponent com_content
Time: 17.79 ms / 246.29 ms Memory: 0.068 MB / 9.01 MB Application: afterDispatch
Time: 16.72 ms / 263.01 ms Memory: 0.166 MB / 9.18 MB Application: beforeRenderModule mod_custom (آدرس و نقشه)
Time: 1.16 ms / 264.17 ms Memory: 0.028 MB / 9.21 MB Application: afterRenderModule mod_custom (آدرس و نقشه)
Time: 0.07 ms / 264.25 ms Memory: 0.000 MB / 9.21 MB Application: beforeRenderModule mod_menu (Main menu)
Time: 2.85 ms / 267.09 ms Memory: 0.067 MB / 9.27 MB Application: afterRenderModule mod_menu (Main menu)
Time: 0.06 ms / 267.15 ms Memory: 0.000 MB / 9.27 MB Application: beforeRenderModule mod_custom (آموزشگاه ظفر)
Time: 0.34 ms / 267.50 ms Memory: 0.004 MB / 9.27 MB Application: afterRenderModule mod_custom (آموزشگاه ظفر)
Time: 0.08 ms / 267.58 ms Memory: 0.038 MB / 9.31 MB Application: beforeRenderModule mod_breadcrumbs (مسیر سایت)
Time: 1.70 ms / 269.27 ms Memory: 0.043 MB / 9.35 MB Application: afterRenderModule mod_breadcrumbs (مسیر سایت)
Time: 0.13 ms / 269.40 ms Memory: 0.009 MB / 9.36 MB Application: beforeRenderModule mod_maximenuck (Top menu)
Time: 20.36 ms / 289.76 ms Memory: 0.602 MB / 9.97 MB Application: afterRenderModule mod_maximenuck (Top menu)
Time: 0.16 ms / 289.93 ms Memory: 0.000 MB / 9.94 MB Application: beforeRenderModule mod_search (جستجو Search)
Time: 1.26 ms / 291.19 ms Memory: 0.016 MB / 9.96 MB Application: afterRenderModule mod_search (جستجو Search)
Time: 0.05 ms / 291.23 ms Memory: 0.000 MB / 9.95 MB Application: beforeRenderModule mod_custom (عکس بالای صفحه)
Time: 0.32 ms / 291.56 ms Memory: 0.003 MB / 9.96 MB Application: afterRenderModule mod_custom (عکس بالای صفحه)
Time: 0.08 ms / 291.64 ms Memory: 0.000 MB / 9.96 MB Application: beforeRenderModule mod_languages (Language Switcher)
Time: 1.80 ms / 293.44 ms Memory: 0.029 MB / 9.98 MB Application: afterRenderModule mod_languages (Language Switcher)
Time: 22.69 ms / 316.13 ms Memory: 0.452 MB / 10.44 MB Application: afterRender

Database queries total: 98.50 ms

Memory Usage

10.97 MB (11,498,696 Bytes)

Database Queries

31 Queries Logged 98.50 ms


2 duplicate found!

2 duplicates: #13  #14
  1. Query Time: 1.19 ms Query memory: 0.007 MB Memory before query: 2.468 MB Rows returned: 0
    SELECT `data`
    
      FROM `ryqdu_session`
      WHERE `session_id` = '7d29c62cf943b6124144cc476f9ea8a1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_sessionconstPRIMARYPRIMARY766const1100.00
    Profile
    StatusDuration
    Starting0.16 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.07 ms
    Checking permissions0.02 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.07 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Executing0.04 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.08 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.03 ms
    Waiting for query cache lock0.05 ms
    Updating status0.02 ms
    Storing result in query cache0.45 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()Same as call in the line below.
    11session_start()JROOT/libraries/joomla/session/handler/native.php:259
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:773
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 1.41 ms After last query: 4.38 ms Query memory: 0.004 MB Memory before query: 2.594 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `ryqdu_session`
      WHERE `session_id` = '7d29c62cf943b6124144cc476f9ea8a1'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_sessionconstPRIMARYPRIMARY766const1100.00Using index
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.08 ms
    Checking permissions0.03 ms
    Opening tables0.04 ms
    After opening tables0.03 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.03 ms
    Init0.05 ms
    Optimizing0.06 ms
    Statistics0.08 ms
    Preparing0.03 ms
    Executing0.05 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.02 ms
    Waiting for query cache lock0.09 ms
    Updating status0.24 ms
    Waiting for query cache lock0.02 ms
    Updating status0.02 ms
    Storing result in query cache0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 2.11 ms After last query: 0.25 ms Query memory: 0.003 MB Memory before query: 2.599 MB
    INSERT INTO `ryqdu_session`
    (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('7d29c62cf943b6124144cc476f9ea8a1', 0, 1, '1660829452', 0, '')
    Explain
    EXPLAIN not possible on query: INSERT INTO `ryqdu_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('7d29c62cf943b6124144cc476f9ea8a1', 0, 1, '1660829452', 0, '')
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init for update0.03 ms
    Update0.12 ms
    Waiting for query cache lock0.02 ms
    Update0.02 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit1.29 ms
    Closing tables0.03 ms
    Unlocking tables0.02 ms
    Closing tables0.04 ms
    Starting cleanup0.06 ms
    Freeing items0.09 ms
    Updating status0.05 ms
    Reset for next command0.03 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:212
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 1.38 ms After last query: 4.14 ms Query memory: 0.004 MB Memory before query: 2.774 MB Rows returned: 32
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `ryqdu_extensions`
      WHERE `type` = 'component'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_extensionsrefextensionextension82const32100.00Using index condition
    Profile
    StatusDuration
    Starting0.13 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.08 ms
    Checking permissions0.03 ms
    Opening tables0.04 ms
    After opening tables0.03 ms
    System lock0.02 ms
    Table lock0.03 ms
    Waiting for query cache lock0.08 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.13 ms
    Preparing0.04 ms
    Executing0.02 ms
    Sending data0.23 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.08 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.01 ms
    Storing result in query cache0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.44 ms After last query: 2.36 ms Query memory: 0.005 MB Memory before query: 2.969 MB Rows returned: 2
    SELECT b.id
    
      FROM ryqdu_usergroups AS a
      LEFT JOIN ryqdu_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1100.00
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL8100.00Using where; Using index
    Profile
    StatusDuration
    Starting0.15 ms
    Waiting for query cache lock0.02 ms
    Init0.03 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.03 ms
    Sending cached result to clien0.11 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    10JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:835
    9JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:904
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.50 ms After last query: 0.90 ms Query memory: 0.005 MB Memory before query: 3.014 MB Rows returned: 5
    SELECT id, rules
    
      FROM `ryqdu_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5100.00
    Profile
    StatusDuration
    Starting0.24 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.02 ms
    Sending cached result to clien0.17 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:921
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 2.38 ms After last query: 0.22 ms Query memory: 0.004 MB Memory before query: 3.022 MB Rows returned: 53
    SELECT folder AS type, element AS name, params
    
      FROM ryqdu_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_lenrefrowsfilteredExtra
    1SIMPLEryqdu_extensionsrefextensionextension82const61100.00Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    Starting0.12 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.13 ms
    Checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.03 ms
    System lock0.02 ms
    Table lock0.03 ms
    Waiting for query cache lock0.04 ms
    Init0.08 ms
    Optimizing0.10 ms
    Statistics0.14 ms
    Preparing0.07 ms
    Sorting result0.04 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index0.87 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.03 ms
    Closing tables0.03 ms
    Unlocking tables0.03 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.11 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.04 ms
    Waiting for query cache lock0.03 ms
    Updating status0.02 ms
    Storing result in query cache0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    7JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.86 ms After last query: 12.65 ms Query memory: 0.005 MB Memory before query: 3.854 MB Rows returned: 2
    SELECT *
    
      FROM ryqdu_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2100.00Using where; Using filesort
    Profile
    StatusDuration
    Starting0.17 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.03 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.03 ms
    Sending cached result to clien0.11 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    8JLanguageHelper::getLanguages()JROOT/plugins/system/languagefilter/languagefilter.php:97
    7PlgSystemLanguageFilter->__construct()JROOT/libraries/cms/plugin/helper.php:255
    6JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    5JPluginHelper::importPlugin()JROOT/libraries/cms/application/cms.php:669
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:681
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 1.54 ms After last query: 0.51 ms Query memory: 0.005 MB Memory before query: 3.875 MB Rows returned: 2
    SELECT element
    
      FROM ryqdu_extensions
      WHERE type = 'language'
      AND client_id = 0
      AND enabled = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_extensionsrefextensionextension82const4100.00Using index condition; Using where
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.09 ms
    Checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.03 ms
    System lock0.03 ms
    Table lock0.05 ms
    Waiting for query cache lock0.05 ms
    Init0.09 ms
    Optimizing0.05 ms
    Statistics0.12 ms
    Preparing0.07 ms
    Executing0.03 ms
    Sending data0.13 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.03 ms
    Closing tables0.03 ms
    Unlocking tables0.02 ms
    Closing tables0.12 ms
    Starting cleanup0.03 ms
    Freeing items0.11 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.06 ms
    Waiting for query cache lock0.02 ms
    Updating status0.02 ms
    Storing result in query cache0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:90
    8JLanguageMultilang::getSiteLangs()JROOT/plugins/system/languagefilter/languagefilter.php:108
    7PlgSystemLanguageFilter->__construct()JROOT/libraries/cms/plugin/helper.php:255
    6JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    5JPluginHelper::importPlugin()JROOT/libraries/cms/application/cms.php:669
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:681
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 1.75 ms After last query: 12.02 ms Query memory: 0.009 MB Memory before query: 4.356 MB Rows returned: 15
    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 ryqdu_menu AS m
      LEFT JOIN ryqdu_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_lenrefrowsfilteredExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const15100.00Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4karajir_jooml70.m.component_id1100.00Using where
    Profile
    StatusDuration
    Starting0.14 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.15 ms
    Checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.04 ms
    Init0.05 ms
    Optimizing0.04 ms
    Statistics0.09 ms
    Preparing0.06 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.03 ms
    Creating sort index0.27 ms
    Waiting for query cache lock0.02 ms
    Creating sort index0.10 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.04 ms
    Starting cleanup0.03 ms
    Freeing items0.22 ms
    Updating status0.02 ms
    Waiting for query cache lock0.01 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.01 ms
    Storing result in query cache5.84 ms
    Reset for next command0.06 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    18JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    17JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    16JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:145
    15JMenu::getInstance()JROOT/libraries/cms/application/cms.php:439
    14JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    13JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    12JRouterSite->__construct()JROOT/libraries/cms/router/router.php:197
    11JRouter::getInstance()JROOT/libraries/cms/application/cms.php:535
    10JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    9JApplicationSite::getRouter()JROOT/plugins/system/languagefilter/languagefilter.php:130
    8PlgSystemLanguageFilter->onAfterInitialise()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:670
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:681
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.13 ms After last query: 25.32 ms Query memory: 0.009 MB Memory before query: 6.024 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `ryqdu_assets`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ryqdu_assets`
    Profile
    StatusDuration
    Starting0.23 ms
    Checking permissions0.03 ms
    Closing tables0.02 ms
    Opening tables0.55 ms
    After opening tables0.03 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init0.03 ms
    Optimizing0.03 ms
    Statistics0.03 ms
    Preparing0.04 ms
    Executing0.02 ms
    Filling schema table0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    Checking permissions0.14 ms
    Closing tables0.03 ms
    Executing0.02 ms
    Sending data0.08 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Removing tmp table0.21 ms
    Closing tables0.04 ms
    Unlocking tables0.02 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.06 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    16JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    15JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    14JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:308
    13JTable::getInstance()JROOT/libraries/joomla/access/access.php:696
    12JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    11JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    10JUser->authorise()JROOT/plugins/system/sourcerer/helper.php:74
    9PlgSystemSourcererHelper->__construct()JROOT/plugins/system/sourcerer/sourcerer.php:92
    8PlgSystemSourcerer->onAfterRoute()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1125
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.37 ms After last query: 1.06 ms Query memory: 0.007 MB Memory before query: 6.059 MB Rows returned: 1
    SELECT *
    
      FROM ryqdu_assets
      WHERE `id` = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_assetsconstPRIMARYPRIMARY4const1100.00
    Profile
    StatusDuration
    Starting0.12 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.02 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    14JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:719
    13JTable->load()JROOT/libraries/joomla/access/access.php:697
    12JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    11JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    10JUser->authorise()JROOT/plugins/system/sourcerer/helper.php:74
    9PlgSystemSourcererHelper->__construct()JROOT/plugins/system/sourcerer/sourcerer.php:92
    8PlgSystemSourcerer->onAfterRoute()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1125
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.46 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 6.064 MB Rows returned: 1
    Duplicate queries: #14
    SELECT a.rules
    
      FROM ryqdu_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaindex_mergePRIMARY,idx_asset_namePRIMARY,idx_asset_name4,202NULL2100.00Using union(PRIMARY,idx_asset_name); Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.02 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    12JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:652
    11JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    10JUser->authorise()JROOT/plugins/system/sourcerer/helper.php:74
    9PlgSystemSourcererHelper->__construct()JROOT/plugins/system/sourcerer/sourcerer.php:92
    8PlgSystemSourcerer->onAfterRoute()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1125
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.34 ms After last query: 0.88 ms Query memory: 0.006 MB Memory before query: 6.088 MB Rows returned: 1
    Duplicate queries: #13
    SELECT a.rules
    
      FROM ryqdu_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaindex_mergePRIMARY,idx_asset_namePRIMARY,idx_asset_name4,202NULL2100.00Using union(PRIMARY,idx_asset_name); Using where
    Profile
    StatusDuration
    Starting0.09 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.04 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.02 ms
    Sending cached result to clien0.10 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    13JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:652
    12JAccess::getAssetRules()JROOT/libraries/joomla/access/access.php:176
    11JAccess::check()JROOT/libraries/joomla/user/user.php:394
    10JUser->authorise()JROOT/plugins/system/sourcerer/helper.php:74
    9PlgSystemSourcererHelper->__construct()JROOT/plugins/system/sourcerer/sourcerer.php:92
    8PlgSystemSourcerer->onAfterRoute()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1125
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 1.30 ms After last query: 0.79 ms Query memory: 0.006 MB Memory before query: 6.137 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `ryqdu_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using index condition
    Profile
    StatusDuration
    Starting0.09 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.09 ms
    Checking permissions0.03 ms
    Opening tables0.04 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.04 ms
    Init0.05 ms
    Optimizing0.04 ms
    Statistics0.17 ms
    Preparing0.05 ms
    Executing0.02 ms
    Sending data0.11 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.03 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.04 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.04 ms
    Waiting for query cache lock0.02 ms
    Updating status0.02 ms
    Storing result in query cache3.63 ms
    Reset for next command0.05 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    12JDatabaseDriver->loadObject()JROOT/libraries/joomla/cache/controller/callback.php:152
    11JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    10JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    9JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    8JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 5.98 ms After last query: 0.22 ms Query memory: 0.005 MB Memory before query: 6.128 MB
    UPDATE `ryqdu_extensions`
    
      SET `params` = '{\"mediaversion\":\"eed7e37542dc014b79e40ca84ae15d79\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_extensionsrangeelement_clientid,element_folder_clientid,extensionextension484NULL1100.00Using where
    Profile
    StatusDuration
    Starting0.19 ms
    Checking permissions0.03 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Init for update0.16 ms
    Updating0.20 ms
    End of update loop0.03 ms
    Waiting for query cache lock0.02 ms
    End of update loop0.09 ms
    Query end0.02 ms
    Commit1.32 ms
    Closing tables0.03 ms
    Unlocking tables0.02 ms
    Closing tables0.02 ms
    Starting cleanup0.02 ms
    Freeing items0.12 ms
    Updating status0.06 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    9JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    8JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 1.27 ms After last query: 3.93 ms Query memory: 0.004 MB Memory before query: 6.282 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM ryqdu_template_styles as s
      LEFT JOIN ryqdu_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_lenrefrowsfilteredExtra
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionextension82const4100.00Using index condition; Using where
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL475.00Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.08 ms
    Checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.07 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.08 ms
    Preparing0.07 ms
    Executing0.02 ms
    Sending data0.13 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.04 ms
    Starting cleanup0.02 ms
    Freeing items0.09 ms
    Updating status0.02 ms
    Waiting for query cache lock0.02 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.03 ms
    Storing result in query cache8.29 ms
    Reset for next command0.06 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 1.56 ms After last query: 11.44 ms Query memory: 0.009 MB Memory before query: 6.762 MB Rows returned: 32
    SELECT element
    
      FROM ryqdu_extensions
      WHERE type = 'component'
      AND enabled = '1'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_extensionsrefextensionextension82const32100.00Using index condition; Using where
    Profile
    StatusDuration
    Starting0.16 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.09 ms
    Checking permissions0.03 ms
    Opening tables0.06 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.04 ms
    Waiting for query cache lock0.04 ms
    Init0.05 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.27 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.02 ms
    Waiting for query cache lock0.02 ms
    Updating status0.04 ms
    Waiting for query cache lock0.05 ms
    Updating status0.02 ms
    Storing result in query cache10.78 ms
    Reset for next command0.05 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    19JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:413
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 11.01 ms After last query: 0.22 ms Query memory: 0.009 MB Memory before query: 6.775 MB Rows returned: 32
    SELECT a.name, a.rules
    
      FROM ryqdu_assets AS a
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_questions','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap') OR a.name = 'root.1')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaALLidx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL20016.50Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock0.04 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.05 ms
    Checking permissions0.02 ms
    Sending cached result to clien0.10 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    19JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:441
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 10.35 ms After last query: 3.11 ms Query memory: 0.008 MB Memory before query: 6.989 MB Rows returned: 4
    SELECT 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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM ryqdu_content AS a
      INNER JOIN ryqdu_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN ryqdu_categories AS c
      ON c.id = a.catid
      LEFT JOIN ryqdu_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ryqdu_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN ryqdu_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ryqdu_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-18 13:30:52')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-18 13:30:52')
      AND a.language in ('en-GB','*')
      ORDER BY c.lft, a.featured DESC, fp.ordering,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 4
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYfpALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL9100.00Using temporary; Using filesort
    1PRIMARYaeq_refPRIMARY,idx_access,idx_catid,idx_languagePRIMARY4karajir_jooml70.fp.content_id1100.00Using where
    1PRIMARYceq_refPRIMARY,idx_accessPRIMARY4karajir_jooml70.a.catid1100.00Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4karajir_jooml70.a.created_by1100.00Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4karajir_jooml70.a.modified_by1100.00Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4karajir_jooml70.c.parent_id1100.00Using where
    1PRIMARYveq_refPRIMARYPRIMARY4karajir_jooml70.a.id1100.00Using where
    1PRIMARY<derived2>refkey0key05karajir_jooml70.c.id2100.00Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL13100.00Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.17 ms
    Waiting for query cache lock0.03 ms
    Init0.02 ms
    Checking query cache for query0.55 ms
    Checking permissions0.03 ms
    Opening tables1.10 ms
    After opening tables0.04 ms
    System lock0.03 ms
    Table lock0.03 ms
    Waiting for query cache lock0.39 ms
    Init0.26 ms
    Optimizing0.10 ms
    Optimizing0.03 ms
    Statistics0.13 ms
    Statistics0.24 ms
    Preparing0.07 ms
    Creating tmp table0.04 ms
    Sorting result0.06 ms
    Preparing0.09 ms
    Creating tmp table0.25 ms
    Sorting result0.05 ms
    Executing0.02 ms
    Sending data0.18 ms
    Executing0.02 ms
    Sending data0.07 ms
    Creating sort index0.04 ms
    Removing tmp table0.03 ms
    Creating sort index1.31 ms
    Creating sort index0.21 ms
    Waiting for query cache lock0.03 ms
    Creating sort index0.06 ms
    Waiting for query cache lock0.02 ms
    Creating sort index0.08 ms
    Waiting for query cache lock0.03 ms
    Creating sort index2.96 ms
    Waiting for query cache lock0.04 ms
    Creating sort index0.12 ms
    Waiting for query cache lock0.02 ms
    Creating sort index0.04 ms
    Waiting for query cache lock0.02 ms
    Creating sort index0.06 ms
    Removing tmp table0.64 ms
    Creating sort index0.05 ms
    End of update loop0.03 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Removing tmp table0.07 ms
    Closing tables0.03 ms
    Unlocking tables0.02 ms
    Closing tables0.05 ms
    Starting cleanup0.02 ms
    Freeing items0.11 ms
    Updating status0.02 ms
    Waiting for query cache lock0.02 ms
    Updating status0.04 ms
    Waiting for query cache lock0.02 ms
    Updating status0.02 ms
    Storing result in query cache0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    15JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    14JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 4.12 ms After last query: 4.23 ms Query memory: 0.007 MB Memory before query: 7.308 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `ryqdu_contentitem_tag_map` AS m
      INNER JOIN `ryqdu_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 133
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4karajir_jooml70.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.10 ms
    Waiting for query cache lock3.65 ms
    Init0.04 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.05 ms
    Sending cached result to clien0.12 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:693
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 1.65 ms After last query: 0.68 ms Query memory: 0.007 MB Memory before query: 7.325 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `ryqdu_contentitem_tag_map` AS m
      INNER JOIN `ryqdu_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 128
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4karajir_jooml70.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Waiting for query cache lock1.31 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.03 ms
    Sending cached result to clien0.08 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:693
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.19 ms After last query: 0.42 ms Query memory: 0.007 MB Memory before query: 7.342 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `ryqdu_contentitem_tag_map` AS m
      INNER JOIN `ryqdu_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 125
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4karajir_jooml70.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.07 ms
    Waiting for query cache lock1.83 ms
    Init0.03 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.03 ms
    Checking permissions0.03 ms
    Sending cached result to clien0.08 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:693
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.32 ms After last query: 0.58 ms Query memory: 0.007 MB Memory before query: 7.359 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `ryqdu_contentitem_tag_map` AS m
      INNER JOIN `ryqdu_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4karajir_jooml70.m.tag_id1100.00Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.02 ms
    Sending cached result to clien0.07 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    14JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:693
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 3.02 ms After last query: 2.31 ms Query memory: 0.007 MB Memory before query: 7.440 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM ryqdu_content AS a
      INNER JOIN ryqdu_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN ryqdu_categories AS c
      ON c.id = a.catid
      LEFT JOIN ryqdu_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ryqdu_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN ryqdu_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ryqdu_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-18 13:30:52')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-18 13:30:52')
      AND a.language in ('en-GB','*')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYfpindexPRIMARYPRIMARY4NULL9100.00Using index
    1PRIMARYaeq_refPRIMARY,idx_access,idx_catid,idx_languagePRIMARY4karajir_jooml70.fp.content_id1100.00Using where
    1PRIMARYceq_refPRIMARY,idx_accessPRIMARY4karajir_jooml70.a.catid1100.00Using where
    1PRIMARY<derived2>refkey0key05karajir_jooml70.c.id2100.00Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL13100.00Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.21 ms
    Checking permissions0.02 ms
    Opening tables0.10 ms
    After opening tables0.03 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.82 ms
    Init0.12 ms
    Optimizing0.08 ms
    Optimizing0.03 ms
    Statistics0.14 ms
    Statistics0.18 ms
    Preparing0.06 ms
    Creating tmp table0.03 ms
    Sorting result0.04 ms
    Preparing0.02 ms
    Unlocking tables0.02 ms
    Preparing0.06 ms
    Executing0.02 ms
    Sending data0.08 ms
    Executing0.02 ms
    Sending data0.05 ms
    Creating sort index0.04 ms
    Removing tmp table0.02 ms
    Creating sort index0.15 ms
    End of update loop0.02 ms
    Query end0.02 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Removing tmp table0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.03 ms
    Starting cleanup0.04 ms
    Freeing items0.10 ms
    Updating status0.02 ms
    Waiting for query cache lock0.02 ms
    Updating status0.04 ms
    Waiting for query cache lock0.03 ms
    Updating status0.02 ms
    Storing result in query cache0.03 ms
    Reset for next command0.03 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    15JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:337
    14JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:278
    13JModelList->getTotal()JROOT/libraries/legacy/model/list.php:228
    12JModelList->getPagination()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 2.31 ms After last query: 19.99 ms Query memory: 0.010 MB Memory before query: 8.438 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 ryqdu_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN ryqdu_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
      AND s.rgt <= c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=2
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_right,idx_languageNO INDEX KEY COULD BE USEDNULLNULL1384.62Using where
    1PRIMARY<derived2>refkey0key05karajir_jooml70.c.id2100.00Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL13100.00Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.18 ms
    Waiting for query cache lock1.75 ms
    Init0.05 ms
    Checking query cache for query0.03 ms
    Checking privileges on cached 0.03 ms
    Checking permissions0.05 ms
    Sending cached result to clien0.14 ms
    Updating status0.03 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    18JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    17JCategories->get()JROOT/components/com_content/helpers/route.php:44
    16ContentHelperRoute::getArticleRoute()JROOT/components/com_content/views/featured/tmpl/default_item.php:28
    15include JROOT/components/com_content/views/featured/tmpl/default_item.phpJROOT/libraries/legacy/view/legacy.php:677
    14JViewLegacy->loadTemplate()JROOT/components/com_content/views/featured/tmpl/default.php:36
    13include JROOT/components/com_content/views/featured/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:677
    12JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:216
    11JViewLegacy->display()JROOT/components/com_content/views/featured/view.html.php:159
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.56 ms After last query: 15.55 ms Query memory: 0.010 MB Memory before query: 8.866 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 ryqdu_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN ryqdu_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
      AND s.rgt <= c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=8
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_right,idx_languageNO INDEX KEY COULD BE USEDNULLNULL1384.62Using where
    1PRIMARY<derived2>refkey0key05karajir_jooml70.c.id2100.00Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx203NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,idx_left_rightidx_left_right8NULL13100.00Using where; Using index; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.21 ms
    Waiting for query cache lock0.03 ms
    Init0.02 ms
    Checking query cache for query0.03 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.03 ms
    Sending cached result to clien0.08 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    18JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    17JCategories->get()JROOT/components/com_content/helpers/route.php:44
    16ContentHelperRoute::getArticleRoute()JROOT/components/com_content/views/featured/tmpl/default_item.php:28
    15include JROOT/components/com_content/views/featured/tmpl/default_item.phpJROOT/libraries/legacy/view/legacy.php:677
    14JViewLegacy->loadTemplate()JROOT/components/com_content/views/featured/tmpl/default.php:65
    13include JROOT/components/com_content/views/featured/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:677
    12JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:216
    11JViewLegacy->display()JROOT/components/com_content/views/featured/view.html.php:159
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 1.67 ms After last query: 2.60 ms Query memory: 0.005 MB Memory before query: 9.072 MB Rows returned: 3
    SELECT language,id
    
      FROM `ryqdu_menu`
      WHERE home = 1
      AND published = 1
      AND client_id = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_menurefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const16100.00Using where
    Profile
    StatusDuration
    Starting0.17 ms
    Waiting for query cache lock1.18 ms
    Init0.02 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.03 ms
    Sending cached result to clien0.09 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:121
    8JLanguageMultilang::getSiteHomePages()JROOT/plugins/system/languagefilter/languagefilter.php:697
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/site.php:196
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 12.26 ms After last query: 1.85 ms Query memory: 0.005 MB Memory before query: 9.120 MB Rows returned: 0
    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `ryqdu_menu` AS `c`
      INNER JOIN `ryqdu_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `ryqdu_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `ryqdu_menu` AS `c2`
      ON a2.id = c2.`id`
      WHERE c.id = 102
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.17 ms
    Waiting for query cache lock11.79 ms
    Init0.04 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.02 ms
    Checking permissions0.04 ms
    Sending cached result to clien0.15 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    10JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/associations.php:101
    9JLanguageAssociations::getAssociations()JROOT/administrator/components/com_menus/helpers/menus.php:284
    8MenusHelper::getAssociations()JROOT/plugins/system/languagefilter/languagefilter.php:714
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/site.php:196
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 13.16 ms After last query: 3.37 ms Query memory: 0.007 MB Memory before query: 9.133 MB Rows returned: 8
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ryqdu_modules AS m
      LEFT JOIN ryqdu_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN ryqdu_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 <= '2022-08-18 13:30:52')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-18 13:30:52')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 102 OR mm.menuid <= 0)
      AND m.language IN ('en-GB','*')
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmrefPRIMARY,published,newsfeeds,idx_languagepublished1const16100.00Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4karajir_jooml70.m.id1100.00Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403karajir_jooml70.m.module,const1100.00Using index condition; Using where
    Profile
    StatusDuration
    Starting0.11 ms
    Waiting for query cache lock0.02 ms
    Init0.02 ms
    Checking query cache for query0.19 ms
    Checking permissions0.02 ms
    Opening tables0.05 ms
    After opening tables0.03 ms
    System lock0.02 ms
    Table lock0.02 ms
    Waiting for query cache lock0.10 ms
    Init0.08 ms
    Optimizing0.06 ms
    Statistics0.13 ms
    Preparing0.07 ms
    Sorting result0.03 ms
    Executing0.02 ms
    Sending data0.02 ms
    Creating sort index0.61 ms
    Waiting for query cache lock3.45 ms
    Creating sort index5.61 ms
    Waiting for query cache lock1.89 ms
    Creating sort index0.13 ms
    End of update loop0.03 ms
    Query end0.03 ms
    Commit0.02 ms
    Closing tables0.02 ms
    Unlocking tables0.02 ms
    Closing tables0.04 ms
    Starting cleanup0.02 ms
    Freeing items0.10 ms
    Updating status0.02 ms
    Waiting for query cache lock0.02 ms
    Updating status0.03 ms
    Waiting for query cache lock0.02 ms
    Updating status0.02 ms
    Storing result in query cache0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    12JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:425
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:361
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    8JDocumentHtml->countModules()JROOT/templates/protostar/index.php:94
    7require JROOT/templates/protostar/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1072
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 8.93 ms After last query: 14.93 ms Query memory: 0.007 MB Memory before query: 9.928 MB Rows returned: 26
    SELECT *
    			
      FROM ryqdu_modules
      WHERE published=1
      ORDER BY id ;
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEryqdu_modulesrefpublishedpublished1const26100.00Using where; Using filesort
    Profile
    StatusDuration
    Starting0.13 ms
    Waiting for query cache lock8.16 ms
    Init0.04 ms
    Checking query cache for query0.02 ms
    Checking privileges on cached 0.06 ms
    Checking permissions0.05 ms
    Sending cached result to clien0.19 ms
    Updating status0.02 ms
    Reset for next command0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/modules/mod_maximenuck/helper.php:434
    12modMaximenuckHelper::CreateModulesList()JROOT/modules/mod_maximenuck/helper.php:62
    11modMaximenuckHelper::getItems()JROOT/modules/mod_maximenuck/mod_maximenuck.php:44
    10include JROOT/modules/mod_maximenuck/mod_maximenuck.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->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. 4 × SELECT `m`.`tag_id`,`t`.* 
      FROM `ryqdu_contentitem_tag_map` AS m
      INNER JOIN `ryqdu_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 2 × SELECT a.rules 
      FROM ryqdu_assets AS a
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `ryqdu_extensions`
  4. 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 ryqdu_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 2 × SELECT element 
      FROM ryqdu_extensions
  6. 1 × SELECT a.name, a.rules 
      FROM ryqdu_assets AS a
  7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM ryqdu_modules AS m
      LEFT JOIN ryqdu_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN ryqdu_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  8. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `ryqdu_menu` AS `c`
      INNER JOIN `ryqdu_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `ryqdu_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `ryqdu_menu` AS `c2`
      ON a2.id = c2.`id`
  9. 1 × SELECT language,id 
      FROM `ryqdu_menu`
  10. 1 × SELECT COUNT(*) 
      FROM ryqdu_content AS a
      INNER JOIN ryqdu_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN ryqdu_categories AS c
      ON c.id = a.catid
      LEFT JOIN ryqdu_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ryqdu_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN ryqdu_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ryqdu_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  11. 1 × SELECT 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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM ryqdu_content AS a
      INNER JOIN ryqdu_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN ryqdu_categories AS c
      ON c.id = a.catid
      LEFT JOIN ryqdu_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN ryqdu_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN ryqdu_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN ryqdu_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM ryqdu_categories AS cat JOIN ryqdu_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  12. 1 × SELECT `data` 
      FROM `ryqdu_session`
  13. 1 × SELECT id, home, template, s.params 
      FROM ryqdu_template_styles as s
      LEFT JOIN ryqdu_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  14. 1 × SELECT `session_id` 
      FROM `ryqdu_session`
  15. 1 × SELECT * 
      FROM ryqdu_assets
  16. 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 ryqdu_menu AS m
      LEFT JOIN ryqdu_extensions AS e
      ON m.component_id = e.extension_id
  17. 1 × SELECT * 
      FROM ryqdu_languages
  18. 1 × SELECT folder AS type, element AS name, params 
      FROM ryqdu_extensions
  19. 1 × SELECT id, rules 
      FROM `ryqdu_viewlevels
  20. 1 × SELECT b.id 
      FROM ryqdu_usergroups AS a
      LEFT JOIN ryqdu_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  21. 1 × SELECT *    
      FROM ryqdu_modules
OTHER Tables:
  1. 1 × INSERT INTO `ryqdu_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('7d29c62cf943b6124144cc476f9ea8a1', 0, 1, '1660829452', 0, ''
  2. 1 × SHOW FULL COLUMNS 
      FROM `ryqdu_assets
  3. 1 × UPDATE `ryqdu_extensions` 
      SET `params` = '{\"mediaversion\":\"eed7e37542dc014b79e40ca84ae15d79\"}'