Environmental News Network - New Climate Change Study: Number of People Suffering Extreme Droughts will Double

Details: By Michigan State University; 11.Jan

Michigan State University is leading a global research effort to offer the first worldwide view of how climate change could affect water availability and drought severity in the decades to come.

By the late 21st century, global land area and population facing extreme droughts could more than double — increasing from 3% during 1976-2005 to 7%-8%, according to Yadu Pokhrel, associate professor of civil and environmental engineering in MSU’s College of Engineering, and lead author of the research published in Nature Climate Change.

“More and more people will suffer from extreme droughts if a medium-to-high level of global warming continues and water management is maintained at its present state,” Pokhrel said. “Areas of the Southern Hemisphere, where water scarcity is already a problem, will be disproportionately affected. We predict this increase in water scarcity will affect food security and escalate human migration and conflict.”

Read more: Michigan State University

Photo Credit: jodylehigh via Pixabay

J! Info Request Session Profile Queries41

51.542MB637ms

Joomla! Version	5.0.0
PHP Version	8.1.32
Identity	guest
Response	200
Template	ja_purity_iv
Database	Server mysql Version 5.7.41 Collation utf8_unicode_ci Conn Collation utf8mb4_general_ci

$_GET: []
$_POST: []
$_SESSION: array:1 [ "joomla" => "***redacted***" ]
$_COOKIE: []
$_SERVER: array:66 [ "CONTEXT_DOCUMENT_ROOT" => "/home/enn/public_html/dev24.enn.com" "CONTEXT_PREFIX" => ...

session: array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747295645 "last" => 1747295645...
registry: array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user: array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...

afterLoad (3.56MB) (45.64ms)
afterInitialise (7.73MB) (74.75ms)
afterRoute (974.37KB) (13.18ms)
beforeRenderComponent com_content (463.38KB) (8.7ms)
Before Access::preloadComponents (all components) (564.02KB) (6.46ms)
After Access::preloadComponents (all components) (113.16KB) (807μs)
Before Access::preloadPermissions (com_content) (4.07KB) (27μs)
After Access::preloadPermissions (com_content) (13.46MB) (41.06ms)
Before Access::getAssetRules (id:26676 name:com_content.article.66702) (1MB) (2.03ms)
After Access::getAssetRules (id:26676 name:com_content.article.66702) (26.87KB) (531μs)
afterRenderComponent com_content (4.6MB) (355ms)
afterDispatch (28.16KB) (603μs)
beforeRenderRawModule mod_menu (mainmenu) (1.21MB) (64.44ms)
afterRenderRawModule mod_menu (mainmenu) (280.23KB) (6.48ms)
beforeRenderModule mod_menu (mainmenu) (704B) (13μs)
afterRenderModule mod_menu (mainmenu) (19.35KB) (472μs)
afterRender (572.77KB) (14.5ms)

1 x afterRenderComponent com_content (4.6MB) (55.75%)	355.05ms
1 x afterInitialise (7.73MB) (11.74%)	74.75ms
1 x beforeRenderRawModule mod_menu (mainmenu) (1.21MB) (10.12%)	64.44ms
1 x afterLoad (3.56MB) (7.17%)	45.64ms
1 x After Access::preloadPermissions (com_content) (13.46MB) (6.45%)	41.06ms
1 x afterRender (572.77KB) (2.28%)	14.50ms
1 x afterRoute (974.37KB) (2.07%)	13.18ms
1 x beforeRenderComponent com_content (463.38KB) (1.37%)	8.70ms
1 x afterRenderRawModule mod_menu (mainmenu) (280.23KB) (1.02%)	6.48ms
1 x Before Access::preloadComponents (all components) (564.02KB) (1.01%)	6.46ms
1 x Before Access::getAssetRules (id:26676 name:com_content.article.66702) (1MB) (0.32%)	2.03ms
1 x After Access::preloadComponents (all components) (113.16KB) (0.13%)	807μs
1 x afterDispatch (28.16KB) (0.09%)	603μs
1 x After Access::getAssetRules (id:26676 name:com_content.article.66702) (26.87KB) (0.08%)	531μs
1 x afterRenderModule mod_menu (mainmenu) (19.35KB) (0.07%)	472μs
1 x Before Access::preloadPermissions (com_content) (4.07KB) (0%)	27μs
1 x beforeRenderModule mod_menu (mainmenu) (704B) (0%)	13μs

41 statements were executed, 19 of which were duplicates, 22 unique242ms5.61MB

SELECT @@SESSION.sql_mode;109μs1.57KB/libraries/src/Session/MetadataManager.php:184Copy
SELECT `session_id` FROM `w283h_session` WHERE `session_id` = :session_id LIMIT 1152μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
INSERT INTO `w283h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)224μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
SELECT `id`,`rules` FROM `w283h_viewlevels`57μs976B/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id` FROM `w283h_usergroups` AS `a` LEFT JOIN `w283h_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest61μs2.27KBParams/libraries/src/Access/Access.php:868Copy
SELECT * FROM w283h_menu WHERE alias ='articles' AND published=1146μs4.09KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352Copy
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 `w283h_categories` AS `s` INNER JOIN `w283h_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`132μs5.27KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `id`,`name`,`rules`,`parent_id` FROM `w283h_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44)177μs8.12KBParams/libraries/src/Access/Access.php:357Copy
SELECT `id`,`name`,`rules`,`parent_id` FROM `w283h_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 03.2ms1.11MBParams/libraries/src/Access/Access.php:301Copy
SHOW FULL COLUMNS FROM `w283h_content`430μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
UPDATE `w283h_content` SET `hits` = (`hits` + 1) WHERE `id` = '66702'1.06ms48B/libraries/src/Table/Table.php:1349Copy
SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `w283h_content` AS `a` INNER JOIN `w283h_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `w283h_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `w283h_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `w283h_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `w283h_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)470μs8.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
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 `w283h_categories` AS `s` INNER JOIN `w283h_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`136μs5.31KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `m`.`tag_id`,`t`.* FROM `w283h_contentitem_tag_map` AS `m` INNER JOIN `w283h_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)71.89ms5.28KBParams/libraries/src/Helper/TagsHelper.php:388Copy
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 `w283h_categories` AS `s` INNER JOIN `w283h_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`157μs5.31KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM w283h_fields AS a LEFT JOIN `w283h_languages` AS l ON l.lang_code = a.language LEFT JOIN w283h_users AS uc ON uc.id=a.checked_out LEFT JOIN w283h_viewlevels AS ag ON ag.id = a.access LEFT JOIN w283h_users AS ua ON ua.id = a.created_user_id LEFT JOIN w283h_fields_groups AS g ON g.id = a.group_id LEFT JOIN `w283h_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC138μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 152μs3.34KB/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 146μs856B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT u.id, u.name, u.username, u.params FROM w283h_users AS u LEFT JOIN w283h_user_usergroup_map AS g ON g.user_id = u.id WHERE u.id = '240' GROUP BY u.id72μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
SELECT enabled FROM w283h_extensions WHERE `type` = 'plugin' AND `element` = 'profile'41μs856B/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:467Copy
SELECT profile_key, profile_value FROM w283h_user_profiles WHERE user_id = 240 AND profile_key LIKE 'profile.%' ORDER BY ordering44μs1.06KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
SHOW FULL COLUMNS FROM `w283h_users`314μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT * FROM `w283h_users` WHERE `id` = :userid119μs4.41KBParams/libraries/src/Table/User.php:106Copy
SELECT `g`.`id`,`g`.`title` FROM `w283h_usergroups` AS `g` INNER JOIN `w283h_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid73μs1.82KBParams/libraries/src/Table/User.php:134Copy
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM w283h_fields AS a LEFT JOIN `w283h_languages` AS l ON l.lang_code = a.language LEFT JOIN w283h_users AS uc ON uc.id=a.checked_out LEFT JOIN w283h_viewlevels AS ag ON ag.id = a.access LEFT JOIN w283h_users AS ua ON ua.id = a.created_user_id LEFT JOIN w283h_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC121μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECT `name` FROM `w283h_users` WHERE id = '240'77μs856B/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
SELECT username FROM w283h_users WHERE id=24049μs856B/plugins/system/t4/src/t4/MVC/Router/T4.php:288Copy
SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `w283h_content` AS `a` LEFT JOIN `w283h_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC161ms4.38MBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
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 `w283h_categories` AS `s` INNER JOIN `w283h_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`178μs5.31KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT u.id, u.name, u.username, u.params FROM w283h_users AS u LEFT JOIN w283h_user_usergroup_map AS g ON g.user_id = u.id WHERE u.id = '240' GROUP BY u.id83μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
SELECT enabled FROM w283h_extensions WHERE `type` = 'plugin' AND `element` = 'profile'45μs856B/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:467Copy
SELECT profile_key, profile_value FROM w283h_user_profiles WHERE user_id = 240 AND profile_key LIKE 'profile.%' ORDER BY ordering45μs1.06KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 154μs11.84KB/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 143μs856B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 151μs856B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 139μs856B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 144μs856B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT option_value FROM w283h_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 137μs856B/administrator/components/com_imagerecycle/helpers/imagerecycle.php:172Copy
SELECT * FROM `w283h_schemaorg` WHERE `itemId` = :itemId AND `context` = :context214μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:408Copy
SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `w283h_content` AS `a` INNER JOIN `w283h_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `w283h_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `w283h_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `w283h_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `w283h_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)180μs8.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `w283h_scheduler_tasks` AS `a` WHERE `a`.`state` = 1232μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy