Please note that this is a BETA version of the Teluguwishesh website which is still undergoing final testing before its official release.
SELECT `data`
FROM `news_session`
WHERE `session_id` = 'se57l51jdkb1q4pp9akbspb4e5'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | news_session | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
executing | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `session_id`
FROM `news_session`
WHERE `session_id` = 'se57l51jdkb1q4pp9akbspb4e5'
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | news_session | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
executing | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
INSERT INTO `news_session` (`session_id`, `client_id`, `time`)
VALUES ('se57l51jdkb1q4pp9akbspb4e5', 0, '1713878354')
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
update | 163.3 ms |
Waiting for query cache lock | 0.0 ms |
update | 0.0 ms |
end | 0.0 ms |
query end | 868.8 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.1 ms |
SELECT b.id
FROM news_usergroups AS a
LEFT JOIN news_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
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 |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
sending cached result to clien | 0.0 ms |
cleaning up | 0.0 ms |
SELECT id, rules
FROM `news_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | news_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
sending cached result to clien | 0.0 ms |
cleaning up | 0.0 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 news_menu AS m
LEFT JOIN news_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
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 | 85 | 100.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | teluguwi_TewisheshV3.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.4 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
storing result in query cache | 0.0 ms |
cleaning up | 0.1 ms |
UPDATE `news_extensions`
SET `params` = '{\"mediaversion\":\"6dd9c0a88bec96cfa66b54cdfe19448e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | news_extensions | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.1 ms |
updating | 56.4 ms |
end | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
end | 0.4 ms |
query end | 445.6 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.2 ms |
SELECT 'news' as type, i.id, i.catid, i.title AS title, i.alias, i.telugutitle, i.metadesc, i.metakey, c.name as section, c.alias as catalias, i.created
FROM news_k2_items AS i
INNER JOIN news_k2_categories AS c
ON c.id=i.catid
WHERE (i.title like '%'"chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt give helping hand"'%' or i.tags like '%'"chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt give helping hand"'%' or i.metakey like '%'"chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt give helping hand"'%')
AND i.trash = 0
AND i.published = 1
AND c.published = 1
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-23 13:19:16' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-23 13:19:16' )
ORDER BY i.created DESC
LIMIT 0, 50
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | i | ref | published,publish_up,catid | published | 2 | const | 75750 | 100.00 | Using where; Using filesort |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,trash | PRIMARY | 4 | teluguwi_TewisheshV3.i.catid | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.1 ms |
System lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 548.8 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 1.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
storing result in query cache | 0.8 ms |
cleaning up | 1.1 ms |
SELECT *
FROM news_tagmeta_rules
WHERE ( ( ('/search/ap cm chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt to give helping hand to ap.html' REGEXP BINARY url)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/search/ap+cm+chandrababu+naidu+said+that+the+central+govt+must+help+the+new+state+ap.+
from+past+few+days+chandrababu+naidu+targetting+cantral+govt+to+give+helping+hand+to+ap.html' REGEXP BINARY url)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('https://www.teluguwishesh.com/search/ap cm chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt to give helping hand to ap.html' REGEXP BINARY url)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('https://www.teluguwishesh.com/search/ap+cm+chandrababu+naidu+said+that+the+central+govt+must+help+the+new+state+ap.+
from+past+few+days+chandrababu+naidu+targetting+cantral+govt+to+give+helping+hand+to+ap.html' REGEXP BINARY url)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only=0) ) OR ( ('/search/ap cm chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt to give helping hand to ap.html' REGEXP url)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/search/ap+cm+chandrababu+naidu+said+that+the+central+govt+must+help+the+new+state+ap.+
from+past+few+days+chandrababu+naidu+targetting+cantral+govt+to+give+helping+hand+to+ap.html' REGEXP url)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('https://www.teluguwishesh.com/search/ap cm chandrababu naidu said that the central govt must help the new state ap.
from past few days chandrababu naidu targetting cantral govt to give helping hand to ap.html' REGEXP url)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('https://www.teluguwishesh.com/search/ap+cm+chandrababu+naidu+said+that+the+central+govt+must+help+the+new+state+ap.+
from+past+few+days+chandrababu+naidu+targetting+cantral+govt+to+give+helping+hand+to+ap.html' REGEXP url)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only=0) ) )
AND published=1
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | news_tagmeta_rules | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 131 | 100.00 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.1 ms |
System lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.3 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
storing result in query cache | 0.0 ms |
cleaning up | 0.1 ms |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM news_modules AS m
LEFT JOIN news_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN news_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 <= '2024-04-23 13:19:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-23 13:19:16')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 217 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 376 | 86.97 | Using where; Using filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | teluguwi_TewisheshV3.m.module,const | 1 | 100.00 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | teluguwi_TewisheshV3.m.id | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 1.9 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.4 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
freeing items | 0.0 ms |
storing result in query cache | 0.0 ms |
cleaning up | 0.0 ms |
UPDATE `news_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713878354;s:18:\"session.timer.last\";i:1713878354;s:17:\"session.timer.now\";i:1713878354;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:29:\"com_rssfactory.pseudocron.key\";s:32:\"376af0445864121508aa1a6fdde5d41d\";s:13:\"session.token\";s:32:\"38b62a19c34d95e09553f7d6f913c8ea\";}' , `time` = '1713878357'
WHERE `session_id` = 'se57l51jdkb1q4pp9akbspb4e5'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | news_session | range | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
updating | 60.9 ms |
end | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
end | 0.0 ms |
query end | 1223.2 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.1 ms |
1 × SELECT 'news' as type, i.id, i.catid, i.title AS title, i.alias, i.telugutitle, i.metadesc, i.metakey, c.name as section, c.alias as catalias, i.created
FROM news_k2_items AS i
INNER JOIN news_k2_categories AS c
ON c.id=i.catid
1 × SELECT *
FROM news_tagmeta_rules
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM news_modules AS m
LEFT JOIN news_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN news_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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 news_menu AS m
LEFT JOIN news_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, rules
FROM `news_viewlevels
1 × SELECT `session_id`
FROM `news_session`
1 × SELECT b.id
FROM news_usergroups AS a
LEFT JOIN news_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `data`
FROM `news_session`
1 × UPDATE `news_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713878354;s:18:\"session.timer.last\";i:1713878354;s:17:\"session.timer.now\";i:1713878354;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:29:\"com_rssfactory.pseudocron.key\";s:32:\"376af0445864121508aa1a6fdde5d41d\";s:13:\"session.token\";s:32:\"38b62a19c34d95e09553f7d6f913c8ea\";}' , `time` = '1713878357'
1 × UPDATE `news_extensions`
SET `params` = '{\"mediaversion\":\"6dd9c0a88bec96cfa66b54cdfe19448e\"}'
1 × INSERT INTO `news_session` (`session_id`, `client_id`, `time`)
VALUES ('se57l51jdkb1q4pp9akbspb4e5', 0, '1713878354'