SELECT * FROM cl_configs0.00062704086303711Всего 0.00062704086303711 сек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.00020098686218262Всего 0.00082802772521973 сек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.00465798377990723Всего 0.005486011505127 сек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.08937382698059082Всего 0.094859838485718 секMysqliDb->rawQuery() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #385 SELECT * FROM cl_publications WHERE status IN ( 'active', 'inactive', 'deleted' ) AND id = '671602' LIMIT 10.00026202201843262Всего 0.09512186050415 сек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 = '2396' LIMIT 10.00035095214843750Всего 0.095472812652588 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #1859 SELECT * FROM cl_users WHERE id = '2396' LIMIT 10.00038695335388184Всего 0.09585976600647 сек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 = '671602' 0.00016689300537109Всего 0.096026659011841 сек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 = '670895' LIMIT 10.00021791458129883Всего 0.09624457359314 сек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 = '2396' LIMIT 10.00030708312988281Всего 0.096551656723022 сек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 = '671602' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY id DESC LIMIT 300.00045704841613770Всего 0.09700870513916 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/thread/app_ctrl.php" line #95 SELECT * FROM cl_publications WHERE id = '670895' AND status IN ( 'active', 'inactive', 'deleted' ) LIMIT 10.00021004676818848Всего 0.097218751907349 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/thread/app_ctrl.php" line #67 SELECT * FROM cl_users WHERE id = '2396' LIMIT 10.00031399726867676Всего 0.097532749176025 сек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 = '670895' 0.00016212463378906Всего 0.097694873809814 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #77 SELECT * FROM cl_publications WHERE thread_id = '670895' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY likes_count DESC, replys_count DESC, reposts_count DESC, time DESC LIMIT 20.00033187866210938Всего 0.098026752471924 сек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 = '1083' LIMIT 10.00033998489379883Всего 0.098366737365723 сек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 = '670895' LIMIT 10.00022602081298828Всего 0.098592758178711 сек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 = '2396' LIMIT 10.00036597251892090Всего 0.098958730697632 сек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 = '2396' LIMIT 10.00044393539428711Всего 0.099402666091919 сек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 = '671605' 0.00020003318786621Всего 0.099602699279785 сек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 = '670895' LIMIT 10.00026988983154297Всего 0.099872589111328 сек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 = '2396' LIMIT 10.00044298171997070Всего 0.1003155708313 сек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 = '670895' 0.00330805778503418Всего 0.10362362861633 сек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 = '671602' 0.00088095664978027Всего 0.10450458526611 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23