Консоль отладки Joomla!

Time

Memory

115 SQL-запросов зафиксировано 161.2 ms

1. Query Time: 0.48 ms

   DELETE 
   
     FROM `sar_session`
   
     WHERE `time` < '1576490383'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sar_session	range	time	time	45	const	1	100.00	Using where

   Profile

   Error
   SQL=SHOW PROFILES

   Call Stack

   JROOT/libraries/cms/application/cms.php:703

   JROOT/libraries/cms/application/cms.php:140

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

   JROOT/libraries/cms/application/cms.php:341

   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.29 ms After last query: 0.25 ms

   SELECT `session_id`
   
     FROM `sar_session`
   
     WHERE `session_id` = 'h2rm7fbppqudbbinrvqtud54p1' 
     LIMIT 0, 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sar_session	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

   Profile

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

   Call Stack

   JROOT/libraries/cms/application/cms.php:184

   JROOT/libraries/cms/application/cms.php:712

   JROOT/libraries/cms/application/cms.php:140

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

   JROOT/libraries/cms/application/cms.php:341

   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.31 ms After last query: 0.19 ms

   INSERT INTO `sar_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('h2rm7fbppqudbbinrvqtud54p1', 0, '1576491283')

   Explain

   EXPLAIN not possible on query: INSERT INTO `sar_session` (`session_id`, `client_id`, `time`) VALUES ('h2rm7fbppqudbbinrvqtud54p1', 0, '1576491283')

   Profile

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

   Call Stack

   JROOT/libraries/cms/application/cms.php:216

   JROOT/libraries/cms/application/cms.php:712

   JROOT/libraries/cms/application/cms.php:140

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

   JROOT/libraries/cms/application/cms.php:341

   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: 0.43 ms After last query: 4.79 ms

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sar_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

   Profile

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

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:395

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

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:539

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

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

   ---

5. Query Time: 0.17 ms After last query: 1.64 ms

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

   Profile

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

   Call Stack

   JROOT/libraries/joomla/access/access.php:336

   JROOT/libraries/joomla/access/access.php:405

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:544

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

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

   ---

6. Query Time: 0.15 ms After last query: 0.82 ms

   SELECT id, rules
   
     FROM `sar_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sar_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	NULL

   Profile

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

   Call Stack

   JROOT/libraries/joomla/access/access.php:422

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:544

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

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

   ---

7. Query Time: 0.65 ms After last query: 0.23 ms

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sar_extensions	ref	extension	extension	62	const	58	100.00	Using index condition; Using where; Using filesort

   Profile

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

   Call Stack

   JROOT/libraries/cms/plugin/helper.php:312

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:544

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

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

   ---

8. Query Time: 1.08 ms After last query: 0.59 ms

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sar_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

   Profile

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

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:395

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

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:597

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

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

   ---

9. Query Time: 0.82 ms After last query: 21.36 ms

   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 sar_menu AS m
   
     LEFT JOIN sar_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

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	29	100.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.m.component_id	1	100.00	Using where

   Profile

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

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

   JROOT/libraries/cms/application/site.php:250

   JROOT/libraries/cms/router/site.php:210

   JROOT/libraries/cms/router/router.php:391

   JROOT/libraries/cms/router/router.php:184

   JROOT/libraries/cms/router/site.php:82

   JROOT/libraries/cms/application/cms.php:1043

   JROOT/libraries/cms/application/site.php:727

   JROOT/libraries/cms/application/site.php:202

   JROOT/libraries/cms/application/cms.php:264

   JROOT/index.php:40

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

   ---

10. Query Time: 1.40 ms After last query: 1.88 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sar_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

    Profile

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

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

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

11. Query Time: 0.42 ms After last query: 0.32 ms

    UPDATE `sar_extensions`
    
      SET `params` = '{\"mediaversion\":\"b3acca9bff51b4fdc39b90ecb213bde9\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sar_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

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

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

12. Query Time: 0.31 ms After last query: 3.41 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sar_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

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

    JROOT/libraries/cms/component/helper.php:91

    JROOT/components/com_content/router.php:26

    JROOT/libraries/cms/router/site.php:437

    JROOT/libraries/cms/router/site.php:395

    JROOT/libraries/cms/router/router.php:216

    JROOT/libraries/cms/router/site.php:98

    JROOT/libraries/joomla/application/route.php:62

    JROOT/plugins/system/sef/sef.php:49

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

    JROOT/libraries/cms/application/site.php:727

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

13. Query Time: 0.12 ms After last query: 1.13 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sar_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

    Profile

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

    Call Stack

    JROOT/libraries/joomla/language/helper.php:166

    JROOT/libraries/cms/application/site.php:306

    JROOT/libraries/cms/application/site.php:122

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

14. Query Time: 0.40 ms After last query: 0.53 ms

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	sarhandbal_new.s.template,const	1	100.00	Using index condition; Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/application/site.php:455

    JROOT/libraries/cms/application/site.php:152

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

15. Query Time: 0.16 ms After last query: 17.60 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    JROOT/libraries/joomla/access/access.php:250

    JROOT/libraries/joomla/user/user.php:356

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

    JROOT/components/com_content/models/featured.php:39

    JROOT/libraries/legacy/model/legacy.php:415

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

16. Query Time: 0.10 ms After last query: 0.84 ms

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
    1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	11	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/access/access.php:250

    JROOT/libraries/joomla/access/access.php:110

    JROOT/libraries/joomla/user/user.php:365

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

    JROOT/components/com_content/models/featured.php:39

    JROOT/libraries/legacy/model/legacy.php:415

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

17. Query Time: 124.20 ms After last query: 1.07 ms

    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, 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,(
    SELECT MAX(contact.id) AS id
    
      FROM sar_contact_details AS contact
    
      WHERE contact.published = 1 
      AND contact.user_id = a.created_by) as contactid,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 sar_content AS a
    
      LEFT JOIN sar_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sar_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sar_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sar_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sar_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM sar_categories AS cat JOIN sar_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 sar_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      WHERE 
      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 <= '2019-12-16 10:14:43') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-16 10:14:43') 
      AND a.catid IN (8,15)
    
      ORDER BY   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC   
      LIMIT 140, 35

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	ALL	PRIMARY,idx_catid	NO INDEX KEY COULD BE USED	NULL	NULL	2312	100.00	Using where; Using temporary; Using filesort
    1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.catid	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.c.parent_id	1	100.00	Using where
    1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.id	1	100.00	Using where; Using index
    1	PRIMARY	v	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	<derived3>	ref	<auto_key0>	<auto_key0>	4	sarhandbal_new.c.id	4	100.00	Using where; Using index
    3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
    3	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	21	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
    2	DEPENDENT SUBQUERY	contact	ref	idx_state	idx_state	1	const	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/legacy/model/legacy.php:301

    JROOT/libraries/legacy/model/list.php:171

    JROOT/components/com_content/models/articles.php:546

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

18. Query Time: 0.49 ms After last query: 4.48 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sar_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

    Profile

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

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:395

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

    JROOT/libraries/cms/component/helper.php:91

    JROOT/libraries/cms/helper/tags.php:396

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

19. Query Time: 0.39 ms After last query: 0.30 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3174 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

20. Query Time: 0.12 ms After last query: 0.69 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3172 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

21. Query Time: 0.13 ms After last query: 0.56 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3171 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

22. Query Time: 0.29 ms After last query: 0.48 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3170 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

23. Query Time: 0.12 ms After last query: 0.94 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3169 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

24. Query Time: 0.07 ms After last query: 0.76 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3168 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

25. Query Time: 0.30 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3167 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

26. Query Time: 0.24 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3166 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

27. Query Time: 0.29 ms After last query: 0.50 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3165 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

28. Query Time: 0.26 ms After last query: 0.46 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3164 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

29. Query Time: 0.45 ms After last query: 0.48 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3163 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

30. Query Time: 0.30 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3162 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

31. Query Time: 0.31 ms After last query: 0.54 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3161 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

32. Query Time: 0.11 ms After last query: 0.53 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3160 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

33. Query Time: 0.35 ms After last query: 0.50 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3159 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

34. Query Time: 0.12 ms After last query: 0.54 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3158 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

35. Query Time: 0.26 ms After last query: 0.54 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3157 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

36. Query Time: 0.23 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3156 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

37. Query Time: 0.36 ms After last query: 0.49 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3155 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

38. Query Time: 0.13 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3154 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

39. Query Time: 0.14 ms After last query: 0.55 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3153 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

40. Query Time: 0.15 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3152 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

41. Query Time: 0.13 ms After last query: 0.55 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3151 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

42. Query Time: 0.13 ms After last query: 0.54 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3150 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

43. Query Time: 0.11 ms After last query: 0.49 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3149 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

44. Query Time: 0.13 ms After last query: 0.49 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3148 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

45. Query Time: 0.13 ms After last query: 0.55 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3147 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

46. Query Time: 0.14 ms After last query: 0.50 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3146 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

47. Query Time: 0.13 ms After last query: 0.51 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3145 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

48. Query Time: 0.12 ms After last query: 0.58 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3144 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

49. Query Time: 0.11 ms After last query: 0.47 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3143 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

50. Query Time: 0.10 ms After last query: 0.62 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3142 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

51. Query Time: 0.10 ms After last query: 0.55 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3141 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

52. Query Time: 0.11 ms After last query: 0.49 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3140 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

53. Query Time: 0.11 ms After last query: 0.54 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sar_contentitem_tag_map` AS m 
    
      INNER JOIN `sar_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 3139 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	sarhandbal_new.m.tag_id	1	100.00	Using where

    Profile

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

    Call Stack

    JROOT/libraries/cms/helper/tags.php:416

    JROOT/components/com_content/models/articles.php:672

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

54. Query Time: 21.36 ms After last query: 1.77 ms

    SELECT COUNT(*)
    
      FROM sar_content AS a
    
      LEFT JOIN sar_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sar_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sar_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sar_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sar_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM sar_categories AS cat JOIN sar_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 sar_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      WHERE 
      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 <= '2019-12-16 10:14:43') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-16 10:14:43') 
      AND a.catid IN (8,15)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	ALL	PRIMARY,idx_catid	NO INDEX KEY COULD BE USED	NULL	NULL	2312	100.00	Using where
    1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.catid	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.c.parent_id	1	100.00	Using where; Using index
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.id	1	100.00	Using where; Using index
    1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	sarhandbal_new.a.id	1	100.00	Using where; Using index
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	sarhandbal_new.c.id	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	21	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

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

    Call Stack

    JROOT/libraries/legacy/model/legacy.php:327

    JROOT/libraries/legacy/model/list.php:276

    JROOT/libraries/legacy/model/list.php:221

    JROOT/libraries/legacy/view/legacy.php:398

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

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

55. Query Time: 0.14 ms After last query: 17.96 ms

    SELECT * 
      FROM sar_oss_share_settings

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sar_oss_share_settings	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found

    Profile

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

    Call Stack

    JROOT/plugins/content/simplifiedsocialshare/simplifiedsocialshare.php:81

    JROOT/plugins/content/simplifiedsocialshare/simplifiedsocialshare.php:27

    JROOT/libraries/cms/plugin/helper.php:257

    JROOT/libraries/cms/plugin/helper.php:172

    JROOT/components/com_content/views/featured/view.html.php:88

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

56. Query Time: 0.17 ms After last query: 9.78 ms

    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 sar_categories as c
    
      LEFT JOIN sar_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 sar_categories AS cat JOIN sar_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=8 
      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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	21	85.71	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	sarhandbal_new.c.id	4	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	21	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

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

    Call Stack

    JROOT/libraries/legacy/categories/categories.php:288

    JROOT/libraries/legacy/categories/categories.php:181

    JROOT/components/com_content/helpers/route.php:39

    JROOT/plugins/content/jllike/jllike.php:121

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/components/com_content/views/featured/view.html.php:89

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:17

    JROOT/libraries/cms/component/helper.php:351

    JROOT/libraries/cms/component/helper.php:331

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:264

    JROOT/index.php:40

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

    ---

57. Query Time: 0.91 ms After last query: 98.28 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM sar_modules AS m
    
      LEFT JOIN sar_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN sar_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 <= '2019-12-16 10:14:43') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-16 10:14:43') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 138 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	10	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	sarhandbal_new.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sarhandbal_new.m.id	2	100.00	Using where; Using index

    Profile

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

    Call Stack

    JROOT/libraries/cms/module/helper.php:362

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

    JROOT/libraries/joomla/document/html/html.php:502

    JROOT/templates/sarhand/index.php:80

    JROOT/libraries/joomla/document/html/html.php:570

    JROOT/libraries/joomla/document/html/html.php:628

    JROOT/libraries/joomla/document/html/html.php:452

    JROOT/libraries/cms/application/cms.php:999

    JROOT/libraries/cms/application/site.php:709

    JROOT/libraries/cms/application/cms.php:270

    JROOT/index.php:40

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

    ---