Joomla! Debug Console

Time

Memory

18 Queries Logged 189.5 ms

1. Query Time: 4.19 ms Query memory: 0.009 MB Memory before query: 1.539 MB Rows returned: 0

   SELECT `data`
   
     FROM `alqig_session`
   
     WHERE `session_id` = 'v7172he6p3415k9fc1poaggon2'

   Explain

   EXPLAIN not possible on query: SELECT `data` FROM `alqig_session` WHERE `session_id` = 'v7172he6p3415k9fc1poaggon2'

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1357

   JROOT\libraries\joomla\session\storage\database.php:44

   JROOT\libraries\joomla\session\session.php:665

   JROOT\libraries\joomla\session\session.php:603

   JROOT\libraries\cms\application\cms.php:739

   JROOT\libraries\cms\application\cms.php:131

   JROOT\libraries\cms\application\site.php:63

   JROOT\libraries\cms\application\cms.php:399

   JROOT\libraries\joomla\factory.php:125

   JROOT\index.php:42

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 25.74 ms After last query: 1.99 ms Query memory: 0.005 MB Memory before query: 1.656 MB

   DELETE 
   
     FROM `alqig_session`
   
     WHERE `time` < '1685464641'

   Explain

   EXPLAIN not possible on query: DELETE FROM `alqig_session` WHERE `time` < '1685464641'

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\cms\application\cms.php:756

   JROOT\libraries\cms\application\cms.php:131

   JROOT\libraries\cms\application\site.php:63

   JROOT\libraries\cms\application\cms.php:399

   JROOT\libraries\joomla\factory.php:125

   JROOT\index.php:42

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 3.76 ms After last query: 0.14 ms Query memory: 0.007 MB Memory before query: 1.663 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `alqig_session`
   
     WHERE `session_id` = 'v7172he6p3415k9fc1poaggon2' 
     LIMIT 0, 1

   Explain

   EXPLAIN not possible on query: SELECT `session_id` FROM `alqig_session` WHERE `session_id` = 'v7172he6p3415k9fc1poaggon2' LIMIT 0, 1

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1357

   JROOT\libraries\cms\application\cms.php:176

   JROOT\libraries\cms\application\cms.php:765

   JROOT\libraries\cms\application\cms.php:131

   JROOT\libraries\cms\application\site.php:63

   JROOT\libraries\cms\application\cms.php:399

   JROOT\libraries\joomla\factory.php:125

   JROOT\index.php:42

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 68.60 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 1.671 MB

   INSERT INTO `alqig_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('v7172he6p3415k9fc1poaggon2', 0, '1685465541')

   Explain

   EXPLAIN not possible on query: INSERT INTO `alqig_session` (`session_id`, `client_id`, `time`) VALUES ('v7172he6p3415k9fc1poaggon2', 0, '1685465541')

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\cms\application\cms.php:208

   JROOT\libraries\cms\application\cms.php:765

   JROOT\libraries\cms\application\cms.php:131

   JROOT\libraries\cms\application\site.php:63

   JROOT\libraries\cms\application\cms.php:399

   JROOT\libraries\joomla\factory.php:125

   JROOT\index.php:42

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 3.58 ms After last query: 3.29 ms Query memory: 0.011 MB Memory before query: 1.899 MB Rows returned: 31

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM alqig_extensions
   
     WHERE `type` = 'component'

   Explain

   EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM alqig_extensions WHERE `type` = 'component'

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1318

   JROOT\libraries\joomla\cache\controller\callback.php:157

   JROOT\libraries\cms\component\helper.php:435

   JROOT\libraries\cms\component\helper.php:43

   JROOT\libraries\cms\component\helper.php:120

   JROOT\libraries\cms\application\site.php:584

   JROOT\libraries\cms\application\site.php:209

   JROOT\libraries\cms\application\cms.php:252

   JROOT\index.php:45

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 3.34 ms After last query: 1.09 ms Query memory: 0.009 MB Memory before query: 1.982 MB Rows returned: 2

   SELECT b.id
   
     FROM alqig_usergroups AS a
   
     LEFT JOIN alqig_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   EXPLAIN not possible on query: SELECT b.id FROM alqig_usergroups AS a LEFT JOIN alqig_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1167

   JROOT\libraries\joomla\access\access.php:332

   JROOT\libraries\joomla\access\access.php:401

   JROOT\libraries\joomla\user\user.php:453

   JROOT\libraries\cms\plugin\helper.php:296

   JROOT\libraries\cms\plugin\helper.php:163

   JROOT\libraries\cms\application\site.php:589

   JROOT\libraries\cms\application\site.php:209

   JROOT\libraries\cms\application\cms.php:252

   JROOT\index.php:45

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 3.49 ms After last query: 0.50 ms Query memory: 0.008 MB Memory before query: 2.018 MB Rows returned: 5

   SELECT id, rules
   
     FROM `alqig_viewlevels`

   Explain

   EXPLAIN not possible on query: SELECT id, rules FROM `alqig_viewlevels`

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1123

   JROOT\libraries\joomla\access\access.php:418

   JROOT\libraries\joomla\user\user.php:453

   JROOT\libraries\cms\plugin\helper.php:296

   JROOT\libraries\cms\plugin\helper.php:163

   JROOT\libraries\cms\application\site.php:589

   JROOT\libraries\cms\application\site.php:209

   JROOT\libraries\cms\application\cms.php:252

   JROOT\index.php:45

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 3.61 ms After last query: 0.14 ms Query memory: 0.008 MB Memory before query: 2.030 MB Rows returned: 37

   SELECT folder AS type, element AS name, params
   
     FROM alqig_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM alqig_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1318

   JROOT\libraries\cms\plugin\helper.php:310

   JROOT\libraries\cms\plugin\helper.php:163

   JROOT\libraries\cms\application\site.php:589

   JROOT\libraries\cms\application\site.php:209

   JROOT\libraries\cms\application\cms.php:252

   JROOT\index.php:45

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 8.13 ms After last query: 13.87 ms Query memory: 0.018 MB Memory before query: 2.738 MB Rows returned: 37

   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 alqig_menu AS m
   
     LEFT JOIN alqig_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

   EXPLAIN not possible on query: 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 alqig_menu AS m LEFT JOIN alqig_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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   JROOT\libraries\joomla\database\driver.php:1318

   JROOT\libraries\cms\menu\site.php:45

   JROOT\libraries\cms\menu\menu.php:64

   JROOT\libraries\cms\menu\menu.php:118

   JROOT\libraries\cms\application\cms.php:424

   JROOT\libraries\cms\application\site.php:272

   JROOT\libraries\cms\router\site.php:57

   JROOT\libraries\cms\router\router.php:196

   JROOT\libraries\cms\application\cms.php:520

   JROOT\libraries\cms\application\site.php:407

   JROOT\libraries\cms\application\cms.php:1088

   JROOT\libraries\cms\application\site.php:763

   JROOT\libraries\cms\application\site.php:215

   JROOT\libraries\cms\application\cms.php:252

   JROOT\index.php:45

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 3.96 ms After last query: 2.40 ms Query memory: 0.015 MB Memory before query: 3.052 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM alqig_extensions
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM alqig_extensions WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1279

    JROOT\libraries\joomla\cache\controller\callback.php:157

    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:189

    JROOT\libraries\joomla\factory.php:736

    JROOT\libraries\joomla\factory.php:216

    JROOT\plugins\system\sef\sef.php:29

    JROOT\libraries\joomla\event\event.php:69

    JROOT\libraries\joomla\event\dispatcher.php:160

    JROOT\libraries\joomla\application\base.php:106

    JROOT\libraries\cms\application\cms.php:1098

    JROOT\libraries\cms\application\site.php:763

    JROOT\libraries\cms\application\site.php:215

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 28.87 ms After last query: 3.41 ms Query memory: 0.011 MB Memory before query: 3.116 MB

    UPDATE `alqig_extensions`
    
      SET `params` = '{\"mediaversion\":\"0e97a8062d7493c60661e795c769b37f\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `alqig_extensions` SET `params` = '{\"mediaversion\":\"0e97a8062d7493c60661e795c769b37f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\cms\library\helper.php:119

    JROOT\libraries\cms\version\version.php:240

    JROOT\libraries\cms\version\version.php:199

    JROOT\libraries\joomla\factory.php:736

    JROOT\libraries\joomla\factory.php:216

    JROOT\plugins\system\sef\sef.php:29

    JROOT\libraries\joomla\event\event.php:69

    JROOT\libraries\joomla\event\dispatcher.php:160

    JROOT\libraries\joomla\application\base.php:106

    JROOT\libraries\cms\application\cms.php:1098

    JROOT\libraries\cms\application\site.php:763

    JROOT\libraries\cms\application\site.php:215

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 3.95 ms After last query: 4.77 ms Query memory: 0.009 MB Memory before query: 3.329 MB Rows returned: 1

    SELECT *
    
      FROM alqig_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM alqig_languages WHERE published=1 ORDER BY ordering ASC

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1318

    JROOT\libraries\joomla\language\helper.php:164

    JROOT\libraries\cms\application\site.php:329

    JROOT\libraries\cms\application\site.php:135

    JROOT\libraries\cms\application\site.php:230

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 4.48 ms After last query: 0.32 ms Query memory: 0.006 MB Memory before query: 3.343 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM alqig_template_styles as s
    
      LEFT JOIN alqig_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

    EXPLAIN not possible on query: SELECT id, home, template, s.params FROM alqig_template_styles as s LEFT JOIN alqig_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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1318

    JROOT\libraries\cms\application\site.php:484

    JROOT\libraries\cms\application\site.php:165

    JROOT\libraries\cms\application\site.php:230

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 4.24 ms After last query: 11.08 ms Query memory: 0.015 MB Memory before query: 3.920 MB Rows returned: 1

    SELECT a.rules
    
      FROM alqig_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    Explain

    EXPLAIN not possible on query: SELECT a.rules FROM alqig_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1167

    JROOT\libraries\joomla\access\access.php:246

    JROOT\libraries\joomla\user\user.php:384

    JROOT\components\com_content\models\articles.php:107

    JROOT\components\com_content\models\featured.php:42

    JROOT\libraries\legacy\model\legacy.php:439

    JROOT\libraries\legacy\view\legacy.php:401

    JROOT\components\com_content\views\featured\view.html.php:46

    JROOT\libraries\legacy\controller\legacy.php:690

    JROOT\components\com_content\controller.php:104

    JROOT\libraries\legacy\controller\legacy.php:728

    JROOT\components\com_content\content.php:38

    JROOT\libraries\cms\component\helper.php:392

    JROOT\libraries\cms\component\helper.php:372

    JROOT\libraries\cms\application\site.php:191

    JROOT\libraries\cms\application\site.php:230

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 3.43 ms After last query: 1.02 ms Query memory: 0.016 MB Memory before query: 3.955 MB Rows returned: 2

    SELECT b.rules
    
      FROM alqig_assets AS a
    
      LEFT JOIN alqig_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

    EXPLAIN not possible on query: SELECT b.rules FROM alqig_assets AS a LEFT JOIN alqig_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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1167

    JROOT\libraries\joomla\access\access.php:246

    JROOT\libraries\joomla\access\access.php:107

    JROOT\libraries\joomla\user\user.php:393

    JROOT\components\com_content\models\articles.php:107

    JROOT\components\com_content\models\featured.php:42

    JROOT\libraries\legacy\model\legacy.php:439

    JROOT\libraries\legacy\view\legacy.php:401

    JROOT\components\com_content\views\featured\view.html.php:46

    JROOT\libraries\legacy\controller\legacy.php:690

    JROOT\components\com_content\controller.php:104

    JROOT\libraries\legacy\controller\legacy.php:728

    JROOT\components\com_content\content.php:38

    JROOT\libraries\cms\component\helper.php:392

    JROOT\libraries\cms\component\helper.php:372

    JROOT\libraries\cms\application\site.php:191

    JROOT\libraries\cms\application\site.php:230

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 6.18 ms After last query: 0.76 ms Query memory: 0.021 MB Memory before query: 3.998 MB Rows returned: 0

    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 alqig_content AS a
    
      LEFT JOIN alqig_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN alqig_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN alqig_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN alqig_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN alqig_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM alqig_categories AS cat JOIN alqig_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
    
      INNER JOIN alqig_content_frontpage AS fp 
      ON fp.content_id = a.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 <= '2023-05-30 16:52:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-30 16:52:21')
    
      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 0, 4

    Explain

    EXPLAIN not possible on query: 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 alqig_content AS a LEFT JOIN alqig_categories AS c ON c.id = a.catid LEFT JOIN alqig_users AS ua ON ua.id = a.created_by LEFT JOIN alqig_users AS uam ON uam.id = a.modified_by LEFT JOIN alqig_categories as parent ON parent.id = c.parent_id LEFT JOIN alqig_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM alqig_categories AS cat JOIN alqig_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 INNER JOIN alqig_content_frontpage AS fp ON fp.content_id = a.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 <= '2023-05-30 16:52:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-30 16:52:21') 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 0, 4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1318

    JROOT\libraries\legacy\model\legacy.php:312

    JROOT\libraries\legacy\model\list.php:185

    JROOT\components\com_content\models\articles.php:537

    JROOT\components\com_content\models\featured.php:90

    JROOT\libraries\legacy\view\legacy.php:401

    JROOT\components\com_content\views\featured\view.html.php:47

    JROOT\libraries\legacy\controller\legacy.php:690

    JROOT\components\com_content\controller.php:104

    JROOT\libraries\legacy\controller\legacy.php:728

    JROOT\components\com_content\content.php:38

    JROOT\libraries\cms\component\helper.php:392

    JROOT\libraries\cms\component\helper.php:372

    JROOT\libraries\cms\application\site.php:191

    JROOT\libraries\cms\application\site.php:230

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 4.91 ms After last query: 1.21 ms Query memory: 0.014 MB Memory before query: 4.084 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM alqig_content AS a
    
      LEFT JOIN alqig_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN alqig_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN alqig_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN alqig_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN alqig_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM alqig_categories AS cat JOIN alqig_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
    
      INNER JOIN alqig_content_frontpage AS fp 
      ON fp.content_id = a.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 <= '2023-05-30 16:52:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-30 16:52:21')

    Explain

    EXPLAIN not possible on query: SELECT COUNT(*) FROM alqig_content AS a LEFT JOIN alqig_categories AS c ON c.id = a.catid LEFT JOIN alqig_users AS ua ON ua.id = a.created_by LEFT JOIN alqig_users AS uam ON uam.id = a.modified_by LEFT JOIN alqig_categories as parent ON parent.id = c.parent_id LEFT JOIN alqig_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM alqig_categories AS cat JOIN alqig_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 INNER JOIN alqig_content_frontpage AS fp ON fp.content_id = a.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 <= '2023-05-30 16:52:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-30 16:52:21')

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1357

    JROOT\libraries\legacy\model\legacy.php:341

    JROOT\libraries\legacy\model\list.php:290

    JROOT\libraries\legacy\model\list.php:235

    JROOT\libraries\legacy\view\legacy.php:401

    JROOT\components\com_content\views\featured\view.html.php:48

    JROOT\libraries\legacy\controller\legacy.php:690

    JROOT\components\com_content\controller.php:104

    JROOT\libraries\legacy\controller\legacy.php:728

    JROOT\components\com_content\content.php:38

    JROOT\libraries\cms\component\helper.php:392

    JROOT\libraries\cms\component\helper.php:372

    JROOT\libraries\cms\application\site.php:191

    JROOT\libraries\cms\application\site.php:230

    JROOT\libraries\cms\application\cms.php:252

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 5.04 ms After last query: 11.98 ms Query memory: 0.012 MB Memory before query: 4.505 MB Rows returned: 8

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM alqig_modules AS m
    
      LEFT JOIN alqig_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN alqig_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 <= '2023-05-30 16:52:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 16:52:21') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM alqig_modules AS m LEFT JOIN alqig_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN alqig_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 <= '2023-05-30 16:52:21') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 16:52:21') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT\libraries\joomla\database\driver.php:1318

    JROOT\libraries\cms\module\helper.php:407

    JROOT\libraries\cms\module\helper.php:350

    JROOT\libraries\cms\module\helper.php:84

    JROOT\libraries\joomla\document\html\renderer\modules.php:41

    JROOT\libraries\joomla\document\html\html.php:411

    JROOT\libraries\joomla\document\html\html.php:697

    JROOT\libraries\joomla\document\html\html.php:477

    JROOT\libraries\cms\application\cms.php:1059

    JROOT\libraries\cms\application\site.php:745

    JROOT\libraries\cms\application\cms.php:258

    JROOT\index.php:45

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT extension_id AS id, element AS "option", params, enabled
    
     FROM alqig_extensions

2. 1 × SELECT b.rules
    
     FROM alqig_assets AS a
    
     LEFT JOIN alqig_assets AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

3. 1 × SELECT a.rules
    
     FROM alqig_assets AS a

4. 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 alqig_content AS a
    
     LEFT JOIN alqig_categories AS c 
     ON c.id = a.catid
    
     LEFT JOIN alqig_users AS ua 
     ON ua.id = a.created_by
    
     LEFT JOIN alqig_users AS uam 
     ON uam.id = a.modified_by
    
     LEFT JOIN alqig_categories as parent 
     ON parent.id = c.parent_id
    
     LEFT JOIN alqig_content_rating AS v 
     ON a.id = v.content_id
    
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM alqig_categories AS cat JOIN alqig_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

5. 1 × SELECT COUNT(*)
    
     FROM alqig_content AS a
    
     LEFT JOIN alqig_categories AS c 
     ON c.id = a.catid
    
     LEFT JOIN alqig_users AS ua 
     ON ua.id = a.created_by
    
     LEFT JOIN alqig_users AS uam 
     ON uam.id = a.modified_by
    
     LEFT JOIN alqig_categories as parent 
     ON parent.id = c.parent_id
    
     LEFT JOIN alqig_content_rating AS v 
     ON a.id = v.content_id
    
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM alqig_categories AS cat JOIN alqig_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
     FROM alqig_modules AS m
    
     LEFT JOIN alqig_modules_menu AS mm 
     ON mm.moduleid = m.id
    
     LEFT JOIN alqig_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

7. 1 × SELECT id, home, template, s.params
    
     FROM alqig_template_styles as s
    
     LEFT JOIN alqig_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

8. 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 alqig_menu AS m
    
     LEFT JOIN alqig_extensions AS e 
     ON m.component_id = e.extension_id

9. 1 × SELECT b.id
    
     FROM alqig_usergroups AS a
    
     LEFT JOIN alqig_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

10. 1 × SELECT `session_id`
     
      FROM `alqig_session`

11. 1 × SELECT id, rules
     
      FROM `alqig_viewlevels

12. 1 × SELECT folder AS type, element AS name, params
     
      FROM alqig_extensions

13. 1 × SELECT `data`
     
      FROM `alqig_session`

14. 1 × SELECT *
     
      FROM alqig_languages

OTHER Tables:

1. 1 × UPDATE `alqig_extensions`
    
     SET `params` = '{\"mediaversion\":\"0e97a8062d7493c60661e795c769b37f\"}'

2. 1 × INSERT INTO `alqig_session`
    (`session_id`, `client_id`, `time`) 
     VALUES 
    ('v7172he6p3415k9fc1poaggon2', 0, '1685465541'

3. 1 × DELETE 
    
     FROM `alqig_session`