есть какой то универсальный способ чтобы узнать время запросов к бд?
вот есть тут сайтик 21 запрос на главной и по 13 на остальных

вот например посмотрите кто понимает. может тут чо можно укоротить?
и чо это за LIMIT 0,1 ?)))
я уже тут с 28 нашаманил до 21)

Показать скрытый текст

Array
(
[0] => Array
(
[0] => SELECT id, dns, language, fallback FROM tl_page WHERE type='root' AND (dns='localhost' OR dns='www.localhost' OR dns='') AND (language IN('ru','uk','en') OR fallback=1) AND (start='' OR start<1305032714) AND (stop='' OR stop>1305032714) AND published=1 ORDER BY dns DESC, language='ru' DESC, language='uk' DESC, language='en' DESC, sorting LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 6
[Extra] => Using where; Using filesort
)

)

[1] => Array
(
[0] => SELECT id, alias FROM tl_page WHERE pid=0 AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1305032714) AND (stop='' OR stop>1305032714) AND published=1 ORDER BY sorting LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)

)

[2] => Array
(
[0] => SELECT * FROM tl_page WHERE (id='7' OR alias='7') AND (start='' OR start<1305032714) AND (stop='' OR stop>1305032714) AND published=1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => index_merge
[possible_keys] => PRIMARY,alias
[key] => PRIMARY,alias
[key_len] => 4,130
[ref] =>
[rows] => 2
[Extra] => Using union(PRIMARY,alias); Using where
)

)

[3] => Array
(
[0] => SELECT * FROM tl_page WHERE id='7' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[4] => Array
(
[0] => SELECT * FROM tl_page WHERE id='0' LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)

)

[5] => Array
(
[0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id=0 LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)

)

[6] => Array
(
[0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.fallback=1 LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => l
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 6
[Extra] => Using where
)

)

[7] => Array
(
[0] => SELECT * FROM tl_module WHERE id='2' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[8] => Array
(
[0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1305032714) AND (p2.stop='' OR p2.stop>1305032714) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='0' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1305032714) AND (p1.stop='' OR p1.stop>1305032714) AND p1.published=1 ORDER BY p1.sorting
[1] => 6 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => p1
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 5
[Extra] => Using where; Using filesort
)

)

[9] => Array
(
[0] => SELECT id FROM tl_article WHERE pid='7' AND inColumn='main' AND (start='' OR start<1305032714) AND (stop='' OR stop>1305032714) AND published=1 ORDER BY sorting
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_article
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] => Using where; Using filesort
)

)

[10] => Array
(
[0] => SELECT * FROM tl_module WHERE id='8' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[11] => Array
(
[0] => SELECT id, protected, groups FROM tl_news_archive WHERE id IN(3)
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news_archive
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[12] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_news WHERE pid IN(3) AND (start='' OR start<1305032714) AND (stop='' OR stop>1305032714) AND published=1 ORDER BY date DESC
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where
)

)

[13] => Array
(
[0] => SELECT *, author AS authorId, (SELECT title FROM tl_news_archive WHERE tl_news_archive.id=tl_news.pid) AS archive, (SELECT jumpTo FROM tl_news_archive WHERE tl_news_archive.id=tl_news.pid) AS parentJumpTo, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_news WHERE pid IN(3) AND (start='' OR start<1305032714) AND (stop='' OR stop>1305032714) AND published=1 ORDER BY date DESC LIMIT 1,3
[1] => 3 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_news
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 3
[Extra] => Using where; Using filesort
)

)

[14] => Array
(
[0] => SELECT id, alias FROM tl_page WHERE id='3' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[15] => Array
(
[0] => SELECT * FROM tl_module WHERE id='10' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[16] => Array
(
[0] => SELECT id, protected, groups FROM tl_news_archive WHERE id IN(2)
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news_archive
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[17] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_news WHERE pid IN(2) AND (start='' OR start<1305032715) AND (stop='' OR stop>1305032715) AND published=1 ORDER BY date DESC
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_news
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where
)

)

[18] => Array
(
[0] => SELECT *, author AS authorId, (SELECT title FROM tl_news_archive WHERE tl_news_archive.id=tl_news.pid) AS archive, (SELECT jumpTo FROM tl_news_archive WHERE tl_news_archive.id=tl_news.pid) AS parentJumpTo, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_news WHERE pid IN(2) AND (start='' OR start<1305032715) AND (stop='' OR stop>1305032715) AND published=1 ORDER BY date DESC LIMIT 0,3
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_news
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 2
[Extra] => Using where; Using filesort
)

)

[19] => Array
(
[0] => SELECT id, alias FROM tl_page WHERE id='2' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_page
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[20] => Array
(
[0] => SELECT * FROM tl_module WHERE id='4' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_module
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)

)

[21] => Array
(
[0] => SELECT *, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (2) ORDER BY FIELD(id, 2)
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => PRIMARY
[table] => tl_style_sheet
[type] => system
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)

)

)

может кто знает ? красивые такие запросы или говно
я новенький в этой хуйне, сам не знаю нахуя сюда полез но интересно же

Добавлено через 23 минуты 35 секунд

-Цитата от Андрей Лютый

Сразу пишу, что проект большой и есть некоторые трудности. К примеру страница Профиля схожа с главным шаблоном лишь шапкой и подвалом. Структура блоков иная, есть около 10 отвёрстанных страниц, интегрировать уже начали по мелочи. Нужна помощь. Лучше конечно, чтобы помог человек разбирающийся в движке DLE 9.2, для которого не составит труда в случае необходимости спрограммировать какие-нить элементы.

Для большего понимания что нужно то:
http://rghost.ru/5764591 - Главная страница
http://rghost.ru/5764761 - Мои друзья
http://rghost.ru/5765081 - Мой профиль

Шаблоны страниц типовых разные. В этом и загвостка. Был тут один помощник W1ndy, только начал морозиться, что его в армию призывают, он там какие-то бумажки бегает собирает, но есть подозрение, что макеты он оставил себе, которые я у дизайнера заказывал.

нахуй тебе эти рэпперские сайты?
делай про политику, экономику пару дней посидел над таким сайтом и уже как ходячий телевизор
конечно если чувствуешь выгоду то делай. но полюбэ через год два захочешь чонить посерьезней новостной портал или там городской какой