SELECT * FROM cl_configs0.00064301490783691Всего 0.00064301490783691 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/tools.php" line #1406 SELECT * FROM cl_ui_langs WHERE status = '1' 0.00014805793762207Всего 0.00079107284545898 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #1659 SELECT u.id, u.username, u.avatar, u.followers, u.posts, u.following, u.country_id, u.website, u.about, u.last_active, u.is_online, u.fname, u.lname, u.email, u.verified, u.follow_privacy FROM cl_users u WHERE u.active = '1' AND u.id != 0 ORDER BY u.followers DESC, u.posts DESC LIMIT 50.00318217277526855Всего 0.0039732456207275 секMysqliDb->rawQuery() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #1005 SELECT h.id, h.tag, h.posts, COUNT(DISTINCT p.user_id) AS unique_users, COUNT(*) AS posts_count, MAX(ph.time) AS last_activity FROM cl_hashtags h JOIN cl_publications_hashtags ph ON ph.hashtag_id = h.id JOIN cl_publications p ON p.id = ph.publication_id WHERE CHAR_LENGTH(h.tag) >= 2 AND ph.time >= NOW() - INTERVAL 7 DAY GROUP BY h.id HAVING unique_users >= 1 ORDER BY unique_users DESC, last_activity DESC LIMIT 15; 0.08161115646362305Всего 0.085584402084351 секMysqliDb->rawQuery() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #385 SELECT id FROM cl_users WHERE username = 'KeyDach' LIMIT 10.00078392028808594Всего 0.086368322372437 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #671 SELECT * FROM cl_users WHERE id = '1528' LIMIT 10.00025606155395508Всего 0.086624383926392 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 SELECT * FROM cl_users WHERE id = '1528' LIMIT 10.00026583671569824Всего 0.08689022064209 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #357 SELECT * FROM cl_publications WHERE user_id = '1528' AND profile_pinned = 'Y' LIMIT 10.00019907951354980Всего 0.08708930015564 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/profile/app_ctrl.php" line #128 SELECT posts.`id` as offset_id, posts.`publication_id`, posts.`type`, posts.`user_id`, posts.`time` FROM `cl_posts` posts INNER JOIN `cl_publications` pubs ON posts.`publication_id` = pubs.`id` WHERE posts.`user_id` = 1528 AND pubs.`profile_pinned` = "N" ORDER BY posts.`id` DESC LIMIT 15; 0.00015902519226074Всего 0.0872483253479 секMysqliDb->rawQuery() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/profile/app_ctrl.php" line #37 SELECT * FROM cl_publications WHERE status IN ( 'active', 'inactive', 'deleted' ) AND id = '176184' LIMIT 10.00014591217041016Всего 0.087394237518311 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #699 SELECT * FROM cl_users WHERE id = '1528' LIMIT 10.00023412704467773Всего 0.087628364562988 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 SELECT * FROM cl_publications WHERE thread_id = '176184' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY likes_count DESC, replys_count DESC, reposts_count DESC, time DESC LIMIT 20.00025415420532227Всего 0.087882518768311 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #680 SELECT * FROM cl_users WHERE id = '1423' LIMIT 10.00023484230041504Всего 0.088117361068726 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 SELECT * FROM cl_publications WHERE status IN ( 'active', 'inactive', 'deleted' ) AND id = '176184' LIMIT 10.00014519691467285Всего 0.088262557983398 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #699 SELECT * FROM cl_users WHERE id = '1528' LIMIT 10.00023007392883301Всего 0.088492631912231 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 SELECT * FROM cl_users WHERE id = '1408' LIMIT 10.00022101402282715Всего 0.088713645935059 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 SELECT * FROM cl_pubmedia WHERE pub_id = '176188' 0.00012898445129395Всего 0.088842630386353 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #77 SELECT * FROM cl_publications WHERE status IN ( 'active', 'inactive', 'deleted' ) AND id = '176184' LIMIT 10.00014519691467285Всего 0.088987827301025 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #699 SELECT * FROM cl_users WHERE id = '1528' LIMIT 10.00022196769714355Всего 0.089209794998169 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 UPDATE cl_publications SET `views_count` = views_count+1 WHERE id = '176184' 0.00237488746643066Всего 0.0915846824646 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23 UPDATE cl_publications SET `views_count` = views_count+1 WHERE id = '176187' 0.00060296058654785Всего 0.092187643051147 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23 UPDATE cl_publications SET `views_count` = views_count+1 WHERE id = '176188' 0.00071477890014648Всего 0.092902421951294 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23