Новости

SQL: 4, 3.00 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.88 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-10 23:30:57, 2026-05-10 23:30:57	1.09 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 10	1, 2026-05-10 23:30:57, 2026-05-10 23:30:57	2.34 ms.