Самое большое количество запросов при выводе главной страницы, т.к. обычно туда "напихивают" максимальное количество модулей. При минимальном количестве модулей вывод главной страницы сопровождается примерно 30 запросами к БД.
p.s. сказанное верно для версии 1.2
Время генерации страницы: 0.6561 сек. Количество запросов: 148 Время выполнения запросов: 0.5269 Запросы: Текст запросов Время Отобрано SET TIME_ZONE='-2:00' 0.000081 SET NAMES cp1251 0.000040 SELECT * FROM cms_banlist WHERE ip = '82.207.115.188' AND status=1 0.000080 0 SELECT * FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) 0.000231 0 SELECT id FROM cms_online WHERE (sess_id = 'a77d51baf9c23b7c45436a9704b47a58' AND ip = '82.207.115.188') 0.000168 1 UPDATE cms_online SET lastdate = NOW(), user_id = '1', viewurl = '/' WHERE (sess_id = 'a77d51baf9c23b7c45436a9704b47a58' AND ip = '82.207.115.188') 0.000300 update - обработано: 1 SELECT id FROM cms_stats WHERE (ip = '82.207.115.188' AND page = '/') 0.000045 1 SELECT allow_group FROM cms_menu WHERE id = 1 LIMIT 1 0.000056 1 SELECT template FROM cms_menu WHERE id = 1 LIMIT 1 0.000043 1 SELECT id FROM cms_user_msg WHERE to_id = 1 AND is_new = 1 0.034406 0 SELECT m.id FROM cms_modules m, cms_modules_bind mb WHERE m.position = 'left' AND m.published = 1 AND m.id = mb.module_id AND (mb.menu_id = 1 OR mb.menu_id = 0) 0.000070 8 SELECT *, m.id as mid FROM cms_modules m, cms_modules_bind mb WHERE m.position = 'left' AND m.published = 1 AND m.id = mb.module_id AND (mb.menu_id = 1 OR mb.menu_id = 0) ORDER BY m.ordering ASC 0.001222 8 SELECT config FROM cms_modules WHERE id = '20' 0.000061 1 SELECT config FROM cms_modules WHERE id = '66' 0.000052 1 SELECT id as getfield FROM cms_blogs WHERE user_id = 1 0.000142 1 SELECT p.imageurl, u.is_deleted as is_deleted FROM cms_user_profiles p, cms_users u WHERE p.user_id = 1 AND p.user_id = u.id LIMIT 1 0.000187 1 SELECT id FROM cms_user_msg WHERE to_id = 1 AND is_new = 1 0.000046 0 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000058 6 SELECT * FROM cms_filter_rules 0.000055 2 SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = 1 0.000056 1 SELECT id as getfield FROM cms_menu WHERE parent_id=0 0.000050 1 SELECT * FROM cms_menu WHERE id = 1 AND NSDiffer = '' 0.000070 1 SELECT * FROM cms_menu WHERE NSLeft > 1 AND NSRight < 176 AND NSDiffer = '' ORDER BY NSLeft,ordering 0.000168 87 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000059 6 SELECT * FROM cms_filter_rules 0.000051 2 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000055 6 SELECT * FROM cms_filter_rules 0.000052 2 SELECT config FROM cms_modules WHERE id = '23' 0.000048 1 SELECT f.*, a.title album_title FROM cms_photo_files f, cms_photo_albums a WHERE f.album_id = a.id AND f.published = 1 ORDER BY RAND() LIMIT 1 0.001455 1 SELECT config FROM cms_modules WHERE id = '49' 0.000054 1 SELECT DISTINCT o.user_id, u.*, DATE_FORMAT(u.regdate, '%d-%m-%Y (%H:%i)') as fdate, p.gender as gender FROM cms_users u, cms_online o, cms_user_profiles p WHERE o.user_id = u.id AND p.user_id = u.id AND u.is_deleted = 0 AND u.is_locked = 0 ORDER BY u.regdate DESC 0.000508 1 SELECT id FROM cms_online WHERE user_id = 0 0.000109 1 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000056 6 SELECT * FROM cms_filter_rules 0.000050 2 SELECT id FROM cms_stats GROUP BY ip 0.108817 4,370 SELECT id FROM cms_stats 0.074541 66,678 SELECT *, m.id as mid FROM cms_modules m, cms_modules_bind mb WHERE m.position = 'top' AND m.published = 1 AND m.id = mb.module_id AND (mb.menu_id = 1 OR mb.menu_id = 0) ORDER BY m.ordering ASC 0.001827 12 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000063 6 SELECT * FROM cms_filter_rules 0.000057 2 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000061 6 SELECT * FROM cms_filter_rules 0.000058 2 SELECT config FROM cms_modules WHERE id = '97' 0.000056 1 SELECT NSLeft, NSRight FROM cms_category WHERE id=33 ORDER BY id ASC 0.000053 1 SELECT DISTINCT con.*, DATE_FORMAT(con.pubdate, '%d-%m-%Y (%H:%i)') as fdate, u.nickname as author, cat.title as cat FROM cms_content con, cms_category cat, cms_users u WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id AND (con.category_id = cat.id AND cat.NSLeft >= 32 AND cat.NSRight <= 33) AND ( con.is_end='0' OR (con.is_end='1' AND con.enddate > NOW()) ) ORDER BY con.pubdate DESC LIMIT 3 0.004375 1 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '339' 0.000080 0 SELECT config FROM cms_modules WHERE id = '19' 0.000059 1 SELECT NSLeft, NSRight FROM cms_category WHERE id=2 ORDER BY id ASC 0.000050 1 SELECT DISTINCT con.*, DATE_FORMAT(con.pubdate, '%d-%m-%Y (%H:%i)') as fdate, u.nickname as author, cat.title as cat FROM cms_content con, cms_category cat, cms_users u WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id AND (con.category_id = cat.id AND cat.NSLeft >= 51 AND cat.NSRight <= 62) AND ( con.is_end='0' OR (con.is_end='1' AND con.enddate > NOW()) ) ORDER BY con.pubdate DESC LIMIT 8 0.012983 8 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '342' 0.000578 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '341' 0.000062 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '340' 0.000057 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '338' 0.000057 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '334' 0.000056 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '333' 0.000054 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '332' 0.000056 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '331' 0.000061 1 SELECT config FROM cms_modules WHERE id = '64' 0.000060 1 SELECT p.*, b.title as blog, b.owner as owner, b.id as blog_id, IF(DATE_FORMAT(p.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(p.pubdate, 'Сегодня в %H:%i'), DATE_FORMAT(p.pubdate, '%d-%m-%Y')) as fpubdate, b.user_id as uid FROM cms_blog_posts p, cms_blogs b WHERE p.blog_id = b.id ORDER BY p.pubdate DESC LIMIT 4 0.000337 1 SELECT * FROM cms_filters WHERE published = 1 ORDER BY id ASC 0.000063 6 SELECT * FROM cms_filter_rules 0.000057 2 SELECT variable, value FROM `sverdlov_first`.smf_settings 0.053127 SELECT m.ID_TOPIC, max(m.ID_MSG)ID_MSG, m.ID_BOARD, m.ID_MEMBER, m.posterTime, m.subject, m.posterName, t.numReplies, t.numViews, count(ID_MSG)numTopics, b.name, m.body FROM smf_messages m, smf_topics t, smf_boards b WHERE t.ID_TOPIC=m.ID_TOPIC and m.ID_BOARD=b.ID_BOARD GROUP by ID_TOPIC ORDER by ID_MSG desc LIMIT 10 0.068360 1 SELECT config FROM cms_modules WHERE id = '102' 0.000237 1 SELECT config FROM cms_modules WHERE id = '71' 0.000065 1 SELECT i.title, i.id, i.city as city, u.id as user_id, u.nickname as nickname, IF(DATE_FORMAT(i.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(i.pubdate, 'Cегодня'), IF(DATEDIFF(NOW(), i.pubdate)=1, DATE_FORMAT(i.pubdate, 'Вчера'),DATE_FORMAT(i.pubdate, '%d.%m.%Y') )) as pubdate FROM cms_board_items i, cms_users u, cms_board_cats cat WHERE i.user_id = u.id AND i.category_id = cat.id ORDER BY i.pubdate DESC LIMIT 10 0.000338 6 SELECT config FROM cms_modules WHERE id = '73' 0.000060 1 SELECT c.*, IF(DATE_FORMAT(c.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(c.pubdate, 'Cегодня'), IF(DATEDIFF(NOW(), c.pubdate)=1, DATE_FORMAT(c.pubdate, 'Вчера'),DATE_FORMAT(c.pubdate, '%d/%m/%Y') )) as pubdate FROM cms_clubs c WHERE c.published = 1 ORDER BY c.pubdate DESC LIMIT 2 0.000226 0 SELECT config FROM cms_modules WHERE id = '98' 0.000055 1 SELECT NSLeft, NSRight FROM cms_category WHERE id=22 ORDER BY id ASC 0.000053 1 SELECT DISTINCT con.*, DATE_FORMAT(con.pubdate, '%d-%m-%Y (%H:%i)') as fdate, u.nickname as author, cat.title as cat FROM cms_content con, cms_category cat, cms_users u WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id AND (con.category_id = cat.id AND cat.NSLeft >= 2 AND cat.NSRight <= 7) AND ( con.is_end='0' OR (con.is_end='1' AND con.enddate > NOW()) ) ORDER BY con.pubdate DESC LIMIT 8 0.006333 8 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '336' 0.000078 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '335' 0.000056 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '323' 0.000059 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '299' 0.000058 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '298' 0.000057 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '290' 0.000059 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '272' 0.000060 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '271' 0.000054 0 SELECT config FROM cms_modules WHERE id = '100' 0.000058 1 SELECT DISTINCT con.*, DATE_FORMAT(con.pubdate, '%d-%m-%Y (%H:%i)') as fdate, u.nickname as author, cat.title as cat FROM cms_content con, cms_category cat, cms_users u WHERE con.published = 1 AND con.showlatest = 1 AND con.user_id = u.id AND con.category_id = 35 AND ( con.is_end='0' OR (con.is_end='1' AND con.enddate > NOW()) ) ORDER BY con.pubdate DESC LIMIT 5 0.016812 5 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '315' 0.000377 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '315' 0.000053 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '315' 0.000050 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '315' 0.000049 0 SELECT * FROM cms_comments WHERE target = 'article' AND target_id = '315' 0.000049 0 SELECT config FROM cms_modules WHERE id = '101' 0.000051 1 SELEC
Время генерации страницы: 0.5338 сек. Количество запросов: 285 Время выполнения запросов: 0.3056 Запросы: Текст запросов Время Отобрано SET TIME_ZONE='-2:00' 0.000094 SET NAMES cp1251 0.000047 SELECT * FROM cms_banlist WHERE ip = '82.207.115.188' AND status=1 0.000077 0 SELECT * FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE) 0.000208 0 SELECT id FROM cms_online WHERE (sess_id = 'a77d51baf9c23b7c45436a9704b47a58' AND ip = '82.207.115.188') 0.000162 1 UPDATE cms_online SET lastdate = NOW(), user_id = '1', viewurl = '/users/0/1/profile.html' WHERE (sess_id = 'a77d51baf9c23b7c45436a9704b47a58' AND ip = '82.207.115.188') 0.000266 update - обработано: 1 SELECT id FROM cms_stats WHERE (ip = '82.207.115.188' AND page = '/users/0/1/profile.html') 0.049295 1 SELECT u.*, p.*, u.id as id, u.is_deleted as is_deleted, IFNULL(p.gender, 0) as gender, g.title as grp, IF(DATE_FORMAT(u.regdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(u.regdate, 'Сегодня, %H:%i'), DATE_FORMAT(u.regdate, '%d, %M %Y')) as fregdate, IF(DATE_FORMAT(u.birthdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(u.birthdate, 'Сегодня!'), DATE_FORMAT(u.birthdate, '%d, %M %Y')) as birthdate, IF(DATE_FORMAT(u.logdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(u.logdate, 'Cегодня в %H:%i'), IF(DATEDIFF(NOW(), u.logdate)=1, DATE_FORMAT(u.logdate, 'Вчера в %H:%i'),DATE_FORMAT(u.logdate, '%d-%m-%Y в %H:%i') )) as flogdate FROM cms_users u, cms_user_profiles p, cms_user_groups g WHERE u.is_locked = 0 AND p.user_id = u.id AND u.id = 1 AND u.group_id = g.id LIMIT 1 0.000580 1 ...
Время генерации страницы: 0.4345 сек. Количество запросов: 71 Время выполнения запросов: 0.3676 ...
Время генерации страницы: 3.9828 сек. Количество запросов: 44 Время выполнения запросов: 1.4650 Запросы:...
Для сбора и вывода такой статистики нужно менять файлы движка 😥
Это у меня в 1.2. В 1.5 еще не разобрался, как сделать так же.
Мало-много, понятие растяжимое 😊 Безусловно в сравнении с узкоспециализированными пакетами по количеству запросов instantcms конечно же проигрывает. Но это неизбежно.А 44 запроса это разве мало? Я ничем не хочу обругать CMS но я думаю как раз на оптимизацию запросов к БД и механизмы кеширования разработчикам нужно уделить внимание в будующих версиях.
Виктор а вы не в курсе какой максимум уников в сутки держит движок?
44 запроса — это много по сравнению, опять же, с узкоспециализированными пакетами. Но я, например, не включал ни одного модуля на кеширование.
С другой стороны, оптимизацией запросов всерьез никто еще не занимался. И я думаю, тут есть резерв.
Сто касается количества уников, то мне не совсем понятен вопрос. Причем здесь уники? Я один могу создать на сайте нагрузку, которую и десять уников не сделают 😊 Ведь instant отличается от того же торрент-трекера функциональностью. И посетитель может делать массу дел, сами понимаете все перечислять что он может значит делать повторное описание системы 😊
Кое-кто ранее приводил цифры по посещаемости, но я не помню. Поищите на форуме.