SELECT * FROM cl_configs0.00116109848022461Всего 0.0011610984802246 сек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.00033688545227051Всего 0.0014979839324951 сек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.00543093681335449Всего 0.0069289207458496 сек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.09653210639953613Всего 0.10346102714539 сек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 = '282483' LIMIT 10.00030183792114258Всего 0.10376286506653 сек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 = '1707' LIMIT 10.00049805641174316Всего 0.10426092147827 сек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 = '1707' LIMIT 10.00048685073852539Всего 0.1047477722168 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #230 SELECT id, tag FROM cl_hashtags WHERE id IN ( '2957', '2958', '2959' ) 0.00022006034851074Всего 0.10496783256531 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 SELECT id, tag FROM cl_hashtags WHERE id IN ( '2957', '2958', '2959', '2960', '2961', '2962', '6937', '2958', '2959', '2960', '2961', '2962', '2963', '6938' ) 0.00023198127746582Всего 0.10519981384277 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 SELECT * FROM cl_pubmedia WHERE pub_id = '282483' 0.00025415420532227Всего 0.1054539680481 сек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 = '282483' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY likes_count DESC, replys_count DESC, reposts_count DESC, time DESC LIMIT 20.00046110153198242Всего 0.10591506958008 сек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 = '1707' LIMIT 10.00047302246093750Всего 0.10638809204102 сек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 = '282483' LIMIT 10.00028991699218750Всего 0.1066780090332 сек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 = '1707' LIMIT 10.00046110153198242Всего 0.10713911056519 сек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 = '282483' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY id DESC LIMIT 300.00039291381835938Всего 0.10753202438354 сек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 thread_id = '282484' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY id DESC LIMIT 20.00034499168395996Всего 0.1078770160675 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/thread/app_ctrl.php" line #103 SELECT * FROM cl_users WHERE id = '1707' LIMIT 10.00047588348388672Всего 0.10835289955139 сек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 = '282483' LIMIT 10.00077605247497559Всего 0.10912895202637 сек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 = '1707' LIMIT 10.00036096572875977Всего 0.10948991775513 сек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 = '282483' 0.00232315063476562Всего 0.11181306838989 сек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 = '282484' 0.00089311599731445Всего 0.11270618438721 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23