SELECT * FROM cl_configs0.00053000450134277Всего 0.00053000450134277 сек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.00012898445129395Всего 0.00065898895263672 сек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.00918889045715332Всего 0.00984787940979 сек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.10003089904785156Всего 0.10987877845764 сек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 = 'jopa' LIMIT 10.00124096870422363Всего 0.11111974716187 сек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 = '2408' LIMIT 10.00044488906860352Всего 0.11156463623047 сек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 = '2408' LIMIT 10.00041294097900391Всего 0.11197757720947 сек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 = '2408' AND profile_pinned = 'Y' LIMIT 10.00027918815612793Всего 0.1122567653656 сек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` = 2408 AND pubs.`profile_pinned` = "N" ORDER BY posts.`id` DESC LIMIT 15; 0.00019907951354980Всего 0.11245584487915 сек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 = '450605' LIMIT 10.00021600723266602Всего 0.11267185211182 сек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 = '2408' LIMIT 10.00036501884460449Всего 0.11303687095642 сек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 = '450605' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY likes_count DESC, replys_count DESC, reposts_count DESC, time DESC LIMIT 20.00032901763916016Всего 0.11336588859558 сек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 = '2329' LIMIT 10.00037813186645508Всего 0.11374402046204 сек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 = '450605' LIMIT 10.00025391578674316Всего 0.11399793624878 сек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 = '2408' LIMIT 10.00041794776916504Всего 0.11441588401794 сек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 = '450547' LIMIT 10.00025701522827148Всего 0.11467289924622 сек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 = '2408' LIMIT 10.00038599967956543Всего 0.11505889892578 сек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 = '450605' 0.00058794021606445Всего 0.11564683914185 сек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 = '450610' 0.00078892707824707Всего 0.11643576622009 сек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 = '450547' 0.00064492225646973Всего 0.11708068847656 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23