Новости

SQL: 4, 2.99 MB, 0.05 sec.

#	Запрос	Привязки	Время
0	select * from `cms_ban_ip` where ? BETWEEN `ip1` AND `ip2` limit 1	3628718433	0.58 ms.
1	select * from `news_sections` where `parent` = ? and `news_sections`.`deleted_at` is null	0	0.94 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-05-09 12:30:38, 2026-05-09 12:30:38	1.26 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-05-09 12:30:38, 2026-05-09 12:30:38	3.14 ms.