Новости

SQL: 4, 2.99 MB, 0.04 sec.

#	Запрос	Привязки	Время
0	select * from `cms_ban_ip` where ? BETWEEN `ip1` AND `ip2` limit 1	0	0.44 ms.
1	select * from `news_sections` where `parent` = ? and `news_sections`.`deleted_at` is null	0	0.53 ms.
2	select count(*) as aggregate from `news_articles` where `active` = ? and (`active_from` is null or `active_from` <= ?) and (`active_to` is null or `active_to` >= ?) and `news_articles`.`deleted_at` is null	1, 2026-10-07 12:36:50, 2026-10-07 12:36:50	1.36 ms.
3	select `news_articles`., (select count() from `news_comments` where `news_articles`.`id` = `news_comments`.`article_id` and `news_comments`.`deleted_at` is null) as `comments_count`, (select sum(`news_votes`.`vote`) from `news_votes` where `news_articles`.`id` = `news_votes`.`article_id`) as `votes_sum_vote` from `news_articles` where `active` = ? and (`active_from` is null or `active_from` <= ?) and (`active_to` is null or `active_to` >= ?) and `news_articles`.`deleted_at` is null order by `id` desc limit 10 offset 20	1, 2026-10-07 12:36:50, 2026-10-07 12:36:50	3.91 ms.