WPPM
  • Home
  • About
  • Author Login

  • Forgot your password?
  • Forgot your username?
  • Don't have an account?
  • You are here:  
  • Home
  • Author Login

Older Posts

  • Welcome to your blog
  • About your home page
  • Your Template
  • Your Modules

Blog Roll

  • Joomla! Community
  • Joomla! Leadership Blog

Most Read Posts

  • Welcome to your blog
  • About your home page
  • Your Template
  • Your Modules

  • Author Login

Back to Top

© 2021 WPPM

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.342 MB / 0.34 MB Application: afterLoad
Time: 81.2 ms / 81.3 ms Memory: 1.073 MB / 1.41 MB Application: afterInitialise
Time: 55.2 ms / 136.5 ms Memory: 0.335 MB / 1.75 MB Application: afterRoute
Time: 52.5 ms / 189.0 ms Memory: 0.666 MB / 2.41 MB Application: afterDispatch
Time: 4.9 ms / 193.9 ms Memory: 0.095 MB / 2.51 MB Application: beforeRenderModule mod_menu (Bottom Menu)
Time: 3.2 ms / 197.2 ms Memory: 0.027 MB / 2.54 MB Application: afterRenderModule mod_menu (Bottom Menu)
Time: 0.1 ms / 197.3 ms Memory: 0.000 MB / 2.53 MB Application: beforeRenderModule mod_tags_popular (Popular Tags)
Time: 2.6 ms / 199.9 ms Memory: 0.098 MB / 2.63 MB Application: afterRenderModule mod_tags_popular (Popular Tags)
Time: 0.1 ms / 200.0 ms Memory: 0.001 MB / 2.63 MB Application: beforeRenderModule mod_articles_category (Older Posts)
Time: 19.9 ms / 219.8 ms Memory: 0.500 MB / 3.13 MB Application: afterRenderModule mod_articles_category (Older Posts)
Time: 0.1 ms / 220.0 ms Memory: 0.000 MB / 3.04 MB Application: beforeRenderModule mod_weblinks (Blog Roll)
Time: 5.6 ms / 225.6 ms Memory: 0.181 MB / 3.22 MB Application: afterRenderModule mod_weblinks (Blog Roll)
Time: 0.1 ms / 225.6 ms Memory: 0.000 MB / 3.19 MB Application: beforeRenderModule mod_articles_archive (Archived Articles)
Time: 1.7 ms / 227.4 ms Memory: 0.027 MB / 3.22 MB Application: afterRenderModule mod_articles_archive (Archived Articles)
Time: 0.1 ms / 227.4 ms Memory: 0.000 MB / 3.22 MB Application: beforeRenderModule mod_articles_popular (Most Read Posts)
Time: 5.0 ms / 232.4 ms Memory: 0.185 MB / 3.41 MB Application: afterRenderModule mod_articles_popular (Most Read Posts)
Time: 0.1 ms / 232.5 ms Memory: 0.000 MB / 3.33 MB Application: beforeRenderModule mod_syndicate (Syndication)
Time: 1.0 ms / 233.5 ms Memory: 0.010 MB / 3.34 MB Application: afterRenderModule mod_syndicate (Syndication)
Time: 0.1 ms / 233.6 ms Memory: 0.000 MB / 3.34 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 2.7 ms / 236.3 ms Memory: 0.031 MB / 3.37 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.1 ms / 236.4 ms Memory: 0.000 MB / 3.37 MB Application: beforeRenderModule mod_custom (Image)
Time: 1.4 ms / 237.8 ms Memory: 0.013 MB / 3.38 MB Application: afterRenderModule mod_custom (Image)
Time: 0.1 ms / 237.9 ms Memory: 0.000 MB / 3.38 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 1.3 ms / 239.2 ms Memory: 0.018 MB / 3.40 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.1 ms / 239.3 ms Memory: 0.000 MB / 3.39 MB Application: beforeRenderModule mod_search (Search)
Time: 2.1 ms / 241.4 ms Memory: 0.026 MB / 3.42 MB Application: afterRenderModule mod_search (Search)
Time: 3.1 ms / 244.4 ms Memory: 0.016 MB / 3.43 MB Application: afterRender

Database queries total: 101.7 ms

Memory Usage

4.15 MB (4,356,272 Bytes)

Database Queries

38 Queries Logged 101.7 ms


8 duplicate found!

2 duplicates: #22  #34
2 duplicates: #23  #35
2 duplicates: #24  #36
2 duplicates: #25  #37
  1. Query Time: 0.15 ms Query memory: 0.015 MB Memory before query: 0.763 MB Rows returned: 0
    SELECT `data`
    
      FROM `q3246_session`
      WHERE `session_id` = '0lvpio9bjdg9u31ra07p6k25o2'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_sessionconstPRIMARYPRIMARY602const1100.00NULL
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    executing0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/session/storage/database.php:46
    JROOT/libraries/joomla/session/session.php:658
    JROOT/libraries/joomla/session/session.php:596
    JROOT/libraries/cms/application/cms.php:668
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  2. Query Time: 0.12 ms After last query: 2.66 ms Query memory: 0.008 MB Memory before query: 0.811 MB
    DELETE 
    
      FROM `q3246_session`
      WHERE `time` < '1614220737'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_sessionrangetimetime45const1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    updating0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/cms.php:685
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  3. Query Time: 0.10 ms After last query: 0.11 ms Query memory: 0.012 MB Memory before query: 0.823 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `q3246_session`
      WHERE `session_id` = '0lvpio9bjdg9u31ra07p6k25o2'
      LIMIT 0, 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_sessionconstPRIMARYPRIMARY602const1100.00Using index
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    executing0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/cms.php:175
    JROOT/libraries/cms/application/cms.php:694
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  4. Query Time: 23.03 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 0.835 MB
    INSERT INTO `q3246_session`
    (`session_id`, `client_id`, `time`) 
      VALUES ('0lvpio9bjdg9u31ra07p6k25o2', 0, '1614221637')
    Explain
    EXPLAIN not possible on query: INSERT INTO `q3246_session` (`session_id`, `client_id`, `time`) VALUES ('0lvpio9bjdg9u31ra07p6k25o2', 0, '1614221637')
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    update0.1 ms
    end0.0 ms
    query end22.9 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/cms.php:207
    JROOT/libraries/cms/application/cms.php:694
    JROOT/libraries/cms/application/cms.php:131
    JROOT/libraries/cms/application/site.php:63
    JROOT/libraries/cms/application/cms.php:328
    JROOT/libraries/joomla/factory.php:124
    JROOT/index.php:37
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  5. Query Time: 0.21 ms After last query: 6.37 ms Query memory: 0.015 MB Memory before query: 0.913 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM q3246_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/libraries/cms/application/site.php:570
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  6. Query Time: 0.17 ms After last query: 2.02 ms Query memory: 0.014 MB Memory before query: 0.931 MB Rows returned: 2
    SELECT b.id
    
      FROM q3246_usergroups AS a
      LEFT JOIN q3246_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3100.00Using where; Using index
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:334
    JROOT/libraries/joomla/access/access.php:403
    JROOT/libraries/joomla/user/user.php:428
    JROOT/libraries/cms/plugin/helper.php:298
    JROOT/libraries/cms/plugin/helper.php:165
    JROOT/libraries/cms/application/site.php:575
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  7. Query Time: 0.11 ms After last query: 0.98 ms Query memory: 0.013 MB Memory before query: 0.951 MB Rows returned: 5
    SELECT id, rules
    
      FROM `q3246_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5100.00NULL
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:420
    JROOT/libraries/joomla/user/user.php:428
    JROOT/libraries/cms/plugin/helper.php:298
    JROOT/libraries/cms/plugin/helper.php:165
    JROOT/libraries/cms/application/site.php:575
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  8. Query Time: 0.38 ms After last query: 0.16 ms Query memory: 0.013 MB Memory before query: 0.970 MB Rows returned: 40
    SELECT folder AS type, element AS name, params
    
      FROM q3246_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefextensionextension62const52100.00Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.2 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/plugin/helper.php:312
    JROOT/libraries/cms/plugin/helper.php:165
    JROOT/libraries/cms/application/site.php:575
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  9. Query Time: 0.16 ms After last query: 0.30 ms Query memory: 0.014 MB Memory before query: 1.033 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM q3246_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/libraries/cms/application/site.php:628
    JROOT/libraries/cms/application/site.php:209
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  10. Query Time: 0.40 ms After last query: 19.91 ms Query memory: 0.026 MB Memory before query: 1.469 MB Rows returned: 13
    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 q3246_menu AS m
      LEFT JOIN q3246_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_language1const13100.00Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4markamel_wppm.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/menu/site.php:47
    JROOT/libraries/cms/menu/menu.php:64
    JROOT/libraries/cms/menu/menu.php:118
    JROOT/libraries/cms/application/cms.php:353
    JROOT/libraries/cms/application/site.php:279
    JROOT/libraries/cms/router/site.php:218
    JROOT/libraries/cms/router/router.php:408
    JROOT/libraries/cms/router/router.php:192
    JROOT/libraries/cms/router/site.php:90
    JROOT/libraries/cms/application/cms.php:1018
    JROOT/libraries/cms/application/site.php:749
    JROOT/libraries/cms/application/site.php:231
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  11. Query Time: 0.17 ms After last query: 1.36 ms Query memory: 0.024 MB Memory before query: 1.630 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM q3246_extensions
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefelement_clientid,element_folder_clientid,extensionextension364const,const1100.00Using index condition
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/library/helper.php:156
    JROOT/libraries/cms/library/helper.php:47
    JROOT/libraries/cms/library/helper.php:90
    JROOT/libraries/cms/version/version.php:179
    JROOT/libraries/joomla/factory.php:734
    JROOT/libraries/joomla/factory.php:215
    JROOT/plugins/system/sef/sef.php:30
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:1027
    JROOT/libraries/cms/application/site.php:749
    JROOT/libraries/cms/application/site.php:231
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  12. Query Time: 42.28 ms After last query: 0.21 ms Query memory: 0.018 MB Memory before query: 1.637 MB
    UPDATE `q3246_extensions`
    
      SET `params` = '{\"mediaversion\":\"f71128f6c36555b2205c3f43106227e2\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrangeelement_clientid,element_folder_clientid,extensionextension364const,const1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    updating0.0 ms
    end0.0 ms
    query end42.1 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.1 ms
    Call Stack
    JROOT/libraries/cms/library/helper.php:119
    JROOT/libraries/cms/version/version.php:230
    JROOT/libraries/cms/version/version.php:189
    JROOT/libraries/joomla/factory.php:734
    JROOT/libraries/joomla/factory.php:215
    JROOT/plugins/system/sef/sef.php:30
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/libraries/cms/application/cms.php:1027
    JROOT/libraries/cms/application/site.php:749
    JROOT/libraries/cms/application/site.php:231
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  13. Query Time: 0.20 ms After last query: 8.02 ms Query memory: 0.013 MB Memory before query: 1.763 MB Rows returned: 1
    SELECT *
    
      FROM q3246_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/language/helper.php:166
    JROOT/libraries/cms/application/site.php:336
    JROOT/libraries/cms/application/site.php:135
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  14. Query Time: 0.23 ms After last query: 0.35 ms Query memory: 0.010 MB Memory before query: 1.784 MB Rows returned: 2
    SELECT id, home, template, s.params
    
      FROM q3246_template_styles as s
      LEFT JOIN q3246_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
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL4100.00Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid303markamel_wppm.s.template,const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/application/site.php:486
    JROOT/libraries/cms/application/site.php:165
    JROOT/libraries/cms/application/site.php:237
    JROOT/libraries/cms/application/cms.php:251
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  15. Query Time: 0.61 ms After last query: 53.19 ms Query memory: 0.019 MB Memory before query: 2.451 MB Rows returned: 12
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM q3246_modules AS m
      LEFT JOIN q3246_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN q3246_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-02-25 02:53:57')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-02-25 02:53:57')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 102 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const15100.00Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4markamel_wppm.m.id1100.00Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid303markamel_wppm.m.module,const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.2 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.1 ms
    Call Stack
    JROOT/libraries/cms/module/helper.php:376
    JROOT/libraries/cms/module/helper.php:84
    JROOT/libraries/joomla/document/html/html.php:497
    JROOT/templates/protostar/index.php:49
    JROOT/libraries/joomla/document/html/html.php:576
    JROOT/libraries/joomla/document/html/html.php:634
    JROOT/libraries/joomla/document/html/html.php:452
    JROOT/libraries/cms/application/cms.php:974
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  16. Query Time: 0.18 ms After last query: 7.09 ms Query memory: 0.027 MB Memory before query: 2.630 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM q3246_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/modules/mod_tags_popular/helper.php:66
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:518
    JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  17. Query Time: 0.33 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 2.647 MB Rows returned: 0
    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias
    
      FROM `q3246_contentitem_tag_map` AS `m`
      INNER JOIN `q3246_tags` AS `t`
      ON `tag_id` = t.id
      INNER JOIN `q3246_ucm_content` AS `c`
      ON `m`.`core_content_id` = `c`.`core_content_id`
      WHERE `t`.`access` IN (1,1,5)
      AND `t`.`published` = 1
      AND `m`.`type_alias` = `c`.`core_type_alias`
      AND `c`.`core_state` = 1
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2021-02-25 02:53:57')
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2021-02-25 02:53:57')
      GROUP BY `tag_id`,`title`,`access`,`alias`
      ORDER BY `count` DESC
      LIMIT 0, 8
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tag,idx_core_content_idNO INDEX KEY COULD BE USEDNULLNULL1100.00Using temporary; Using filesort
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    1SIMPLEceq_refPRIMARY,tag_idx,idx_content_typePRIMARY4markamel_wppm.m.core_content_id1100.00Using where
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.0 ms
    end0.0 ms
    removing tmp table0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.1 ms
    Call Stack
    JROOT/modules/mod_tags_popular/helper.php:94
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:518
    JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  18. Query Time: 0.18 ms After last query: 7.23 ms Query memory: 0.028 MB Memory before query: 2.780 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM q3246_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/modules/mod_articles_category/helper.php:53
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  19. Query Time: 0.12 ms After last query: 0.44 ms Query memory: 0.028 MB Memory before query: 2.821 MB Rows returned: 1
    SELECT a.rules
    
      FROM q3246_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:248
    JROOT/libraries/joomla/user/user.php:364
    JROOT/components/com_content/models/articles.php:449
    JROOT/libraries/legacy/model/list.php:115
    JROOT/libraries/legacy/model/list.php:167
    JROOT/components/com_content/models/articles.php:537
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  20. Query Time: 0.46 ms After last query: 1.12 ms Query memory: 0.029 MB Memory before query: 2.858 MB Rows returned: 2
    SELECT b.rules
    
      FROM q3246_assets AS a
      LEFT JOIN q3246_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaconstidx_asset_nameidx_asset_name152const1100.00Using temporary; Using filesort
    1SIMPLEbALLidx_lft_rgtNO INDEX KEY COULD BE USEDNULLNULL4723.40Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.2 ms
    Creating sort index0.0 ms
    end0.0 ms
    removing tmp table0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/access/access.php:248
    JROOT/libraries/joomla/access/access.php:109
    JROOT/libraries/joomla/user/user.php:373
    JROOT/components/com_content/models/articles.php:449
    JROOT/libraries/legacy/model/list.php:115
    JROOT/libraries/legacy/model/list.php:167
    JROOT/components/com_content/models/articles.php:537
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  21. Query Time: 1.07 ms After last query: 0.22 ms Query memory: 0.035 MB Memory before query: 2.890 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 q3246_content AS a
      LEFT JOIN q3246_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN q3246_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN q3246_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM q3246_categories AS cat JOIN q3246_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.catid IN (9)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-25 02:53:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-25 02:53:57')
      ORDER BY a.created DESC
      LIMIT 0, 6
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYaALLidx_access,idx_catidNO INDEX KEY COULD BE USEDNULLNULL666.67Using where
    1PRIMARYfpeq_refPRIMARYPRIMARY4markamel_wppm.a.id1100.00Using where; Using index
    1PRIMARYuaeq_refPRIMARYPRIMARY4markamel_wppm.a.created_by1100.00Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4markamel_wppm.a.modified_by1100.00Using where
    1PRIMARYparentconstPRIMARYPRIMARY4const1100.00Using where
    1PRIMARYvALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4const1100.00Using where; Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_languageidx_left_right8NULL9100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.1 ms
    System lock0.0 ms
    optimizing0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.1 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.0 ms
    removing tmp table0.0 ms
    Creating sort index0.2 ms
    Creating sort index0.1 ms
    end0.0 ms
    removing tmp table0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:171
    JROOT/components/com_content/models/articles.php:537
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  22. Query Time: 0.21 ms After last query: 2.92 ms Query memory: 0.030 MB Memory before query: 2.984 MB Rows returned: 0
    Duplicate queries: #34
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 3
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  23. Query Time: 0.19 ms After last query: 0.33 ms Query memory: 0.030 MB Memory before query: 3.014 MB Rows returned: 0
    Duplicate queries: #35
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 4
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  24. Query Time: 0.18 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 3.044 MB Rows returned: 0
    Duplicate queries: #36
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 6
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  25. Query Time: 0.18 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 3.074 MB Rows returned: 0
    Duplicate queries: #37
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 5
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_category/helper.php:201
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  26. Query Time: 0.86 ms After last query: 1.99 ms Query memory: 0.031 MB Memory before query: 3.133 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 q3246_categories as c
      LEFT JOIN q3246_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM q3246_categories AS cat JOIN q3246_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 (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id=9
      AND badcats.id is null
      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_rightNO INDEX KEY COULD BE USEDNULLNULL955.56Using where
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4markamel_wppm.c.id2100.00Using where; Not exists; Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_languageidx_left_right8NULL9100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.1 ms
    System lock0.0 ms
    optimizing0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.0 ms
    removing tmp table0.0 ms
    Creating sort index0.2 ms
    Creating sort index0.0 ms
    end0.0 ms
    removing tmp table0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/categories/categories.php:288
    JROOT/libraries/legacy/categories/categories.php:181
    JROOT/components/com_content/helpers/route.php:41
    JROOT/modules/mod_articles_category/helper.php:235
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/module/helper.php:488
    JROOT/modules/mod_articles_category/mod_articles_category.php:61
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  27. Query Time: 0.18 ms After last query: 5.06 ms Query memory: 0.025 MB Memory before query: 3.117 MB Rows returned: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM q3246_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_weblinks'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid302const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/modules/mod_weblinks/helper.php:53
    JROOT/modules/mod_weblinks/mod_weblinks.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  28. Query Time: 0.27 ms After last query: 0.40 ms Query memory: 0.024 MB Memory before query: 3.152 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM `q3246_weblinks` AS a
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1,5)
      AND a.catid = 8
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-25 02:53:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-25 02:53:57')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1100.00NULL
    1SIMPLEarefidx_access,idx_state,idx_catididx_state1const2100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4markamel_wppm.a.created_by1100.00Using where; Using index
    1SIMPLEuameq_refPRIMARYPRIMARY4markamel_wppm.a.modified_by1100.00Using where; Using index
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.1 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:327
    JROOT/libraries/legacy/model/list.php:276
    JROOT/libraries/legacy/model/list.php:310
    JROOT/libraries/legacy/model/list.php:171
    JROOT/components/com_weblinks/models/category.php:82
    JROOT/modules/mod_weblinks/helper.php:93
    JROOT/modules/mod_weblinks/mod_weblinks.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  29. Query Time: 0.36 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 3.165 MB Rows returned: 2
    SELECT a.*, c.published AS c_published, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM `q3246_weblinks` AS a
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
      WHERE a.access IN (1,1,5)
      AND a.catid = 8
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.state != -2
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-25 02:53:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-25 02:53:57')
      ORDER BY title asc
      LIMIT 0, 5
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1100.00Using filesort
    1SIMPLEarefidx_access,idx_state,idx_catididx_state1const2100.00Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4markamel_wppm.a.created_by1100.00Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4markamel_wppm.a.modified_by1100.00Using where; Using index
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:171
    JROOT/components/com_weblinks/models/category.php:82
    JROOT/modules/mod_weblinks/helper.php:93
    JROOT/modules/mod_weblinks/mod_weblinks.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  30. Query Time: 0.19 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 3.205 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_weblinks.weblink'
      AND `m`.`content_item_id` = 1
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_weblinks/models/category.php:95
    JROOT/modules/mod_weblinks/helper.php:93
    JROOT/modules/mod_weblinks/mod_weblinks.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  31. Query Time: 0.18 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 3.227 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_weblinks.weblink'
      AND `m`.`content_item_id` = 2
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_weblinks/models/category.php:95
    JROOT/modules/mod_weblinks/helper.php:93
    JROOT/modules/mod_weblinks/mod_weblinks.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  32. Query Time: 0.19 ms After last query: 1.70 ms Query memory: 0.019 MB Memory before query: 3.219 MB Rows returned: 0
    SELECT MONTH(`created`) AS created_month,created, id, title,YEAR(`created`) AS created_year
    
      FROM q3246_content
      WHERE state = 2
      AND checked_out = 0
      GROUP BY created_year DESC, created_month DESC
      LIMIT 0, 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_contentrefidx_checkout,idx_stateidx_state1const1100.00Using where; Using temporary; Using filesort
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.0 ms
    end0.0 ms
    removing tmp table0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/modules/mod_articles_archive/helper.php:49
    JROOT/modules/mod_articles_archive/mod_articles_archive.php:17
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  33. Query Time: 1.00 ms After last query: 1.87 ms Query memory: 0.032 MB Memory before query: 3.265 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 q3246_content AS a
      LEFT JOIN q3246_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN q3246_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN q3246_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM q3246_categories AS cat JOIN q3246_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.catid IN (9)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-25 02:53:57')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-25 02:53:57')
      ORDER BY a.hits DESC
      LIMIT 0, 5
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1100.00Using temporary; Using filesort
    1PRIMARYaALLidx_access,idx_catidNO INDEX KEY COULD BE USEDNULLNULL666.67Using where
    1PRIMARYfpeq_refPRIMARYPRIMARY4markamel_wppm.a.id1100.00Using where; Using index
    1PRIMARYuaeq_refPRIMARYPRIMARY4markamel_wppm.a.created_by1100.00Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4markamel_wppm.a.modified_by1100.00Using where
    1PRIMARYparentconstPRIMARYPRIMARY4const1100.00Using where
    1PRIMARYvALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    1PRIMARY<derived2>ref<auto_key0><auto_key0>4const1100.00Using where; Using index
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2100.00Using index condition; Using temporary; Using filesort
    2DERIVEDcatindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_languageidx_left_right8NULL9100.00Using where; Using index; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.1 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.1 ms
    System lock0.0 ms
    optimizing0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    statistics0.1 ms
    preparing0.0 ms
    Creating tmp table0.0 ms
    Sorting result0.0 ms
    executing0.0 ms
    Sending data0.1 ms
    executing0.0 ms
    Sending data0.0 ms
    Creating sort index0.0 ms
    removing tmp table0.0 ms
    Creating sort index0.2 ms
    Creating sort index0.1 ms
    end0.0 ms
    removing tmp table0.1 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    removing tmp table0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:171
    JROOT/components/com_content/models/articles.php:537
    JROOT/modules/mod_articles_popular/helper.php:64
    JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  34. Query Time: 0.20 ms After last query: 0.41 ms Query memory: 0.027 MB Memory before query: 3.342 MB Rows returned: 0
    Duplicate queries: #22
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 3
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_popular/helper.php:64
    JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  35. Query Time: 0.19 ms After last query: 0.28 ms Query memory: 0.027 MB Memory before query: 3.368 MB Rows returned: 0
    Duplicate queries: #23
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 4
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_popular/helper.php:64
    JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  36. Query Time: 0.18 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 3.395 MB Rows returned: 0
    Duplicate queries: #24
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 6
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_popular/helper.php:64
    JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  37. Query Time: 0.18 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 3.422 MB Rows returned: 0
    Duplicate queries: #25
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 5
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmALLidx_tag_type,idx_tagNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4markamel_wppm.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    optimizing0.0 ms
    statistics0.0 ms
    preparing0.0 ms
    executing0.0 ms
    Sending data0.0 ms
    end0.0 ms
    query end0.0 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/cms/helper/tags.php:412
    JROOT/components/com_content/models/articles.php:663
    JROOT/modules/mod_articles_popular/helper.php:64
    JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:696
    JROOT/libraries/joomla/document/html/html.php:474
    JROOT/libraries/cms/application/cms.php:988
    JROOT/libraries/cms/application/site.php:731
    JROOT/libraries/cms/application/cms.php:257
    JROOT/index.php:40
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

  38. Query Time: 26.37 ms After last query: 12.84 ms Query memory: 0.003 MB Memory before query: 3.438 MB
    UPDATE `q3246_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1614221637;s:18:\"session.timer.last\";i:1614221637;s:17:\"session.timer.now\";i:1614221637;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"c9ef1f4585e8a9b5a87750643675872f\";}' , `time` = '1614221637'
      WHERE `session_id` = '0lvpio9bjdg9u31ra07p6k25o2'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEq3246_sessionrangePRIMARYPRIMARY602const1100.00Using where
    Profile
    StatusDuration
    starting0.0 ms
    checking permissions0.0 ms
    Opening tables0.0 ms
    init0.0 ms
    System lock0.0 ms
    updating0.1 ms
    end0.0 ms
    query end26.2 ms
    closing tables0.0 ms
    freeing items0.0 ms
    cleaning up0.0 ms
    Call Stack
    JROOT/libraries/joomla/session/storage/database.php:85
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 10 × SELECT `m`.`tag_id`,`t`.* 
      FROM `q3246_contentitem_tag_map` AS m
      INNER JOIN `q3246_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 6 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM q3246_extensions
  3. 2 × 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 q3246_content AS a
      LEFT JOIN q3246_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN q3246_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN q3246_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM q3246_categories AS cat JOIN q3246_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  4. 1 × SELECT b.rules 
      FROM q3246_assets AS a
      LEFT JOIN q3246_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  5. 1 × SELECT a.rules 
      FROM q3246_assets AS a
  6. 1 × SELECT COUNT(*) 
      FROM `q3246_weblinks` AS a
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
  7. 1 × SELECT MONTH(`created`) AS created_month,created, id, title,YEAR(`created`) AS created_year 
      FROM q3246_content
  8. 1 × SELECT a.*, c.published AS c_published, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM `q3246_weblinks` AS a
      LEFT JOIN q3246_categories AS c
      ON c.id = a.catid
      LEFT JOIN q3246_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN q3246_users AS uam
      ON uam.id = a.modified_by
  9. 1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias 
      FROM `q3246_contentitem_tag_map` AS `m`
      INNER JOIN `q3246_tags` AS `t`
      ON `tag_id` = t.id
      INNER JOIN `q3246_ucm_content` AS `c`
      ON `m`.`core_content_id` = `c`.`core_content_id`
  10. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM q3246_categories as c
      LEFT JOIN q3246_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM q3246_categories AS cat JOIN q3246_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  11. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM q3246_modules AS m
      LEFT JOIN q3246_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN q3246_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  12. 1 × SELECT id, rules 
      FROM `q3246_viewlevels
  13. 1 × SELECT b.id 
      FROM q3246_usergroups AS a
      LEFT JOIN q3246_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  14. 1 × SELECT `session_id` 
      FROM `q3246_session`
  15. 1 × SELECT folder AS type, element AS name, params 
      FROM q3246_extensions
  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 q3246_menu AS m
      LEFT JOIN q3246_extensions AS e
      ON m.component_id = e.extension_id
  17. 1 × SELECT id, home, template, s.params 
      FROM q3246_template_styles as s
      LEFT JOIN q3246_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  18. 1 × SELECT * 
      FROM q3246_languages
  19. 1 × SELECT `data` 
      FROM `q3246_session`
OTHER Tables:
  1. 1 × UPDATE `q3246_session` 
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1614221637;s:18:\"session.timer.last\";i:1614221637;s:17:\"session.timer.now\";i:1614221637;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"c9ef1f4585e8a9b5a87750643675872f\";}' , `time` = '1614221637'
  2. 1 × UPDATE `q3246_extensions` 
      SET `params` = '{\"mediaversion\":\"f71128f6c36555b2205c3f43106227e2\"}'
  3. 1 × INSERT INTO `q3246_session` (`session_id`, `client_id`, `time`) 
      VALUES ('0lvpio9bjdg9u31ra07p6k25o2', 0, '1614221637'
  4. 1 × DELETE  
      FROM `q3246_session`