SELECT * FROM cl_configs0.00099682807922363Всего 0.00099682807922363 сек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.00022196769714355Всего 0.0012187957763672 сек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.00665712356567383Всего 0.007875919342041 сек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.09646105766296387Всего 0.104336977005 сек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 = '301190' LIMIT 10.00025510787963867Всего 0.10459208488464 сек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 = '1788' LIMIT 10.00032615661621094Всего 0.10491824150085 сек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 = '1788' LIMIT 10.00029492378234863Всего 0.1052131652832 сек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 ( '3031', '3032' ) 0.00012898445129395Всего 0.1053421497345 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 SELECT id FROM cl_users WHERE username = 'power' LIMIT 10.00193285942077637Всего 0.10727500915527 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #689 SELECT * FROM cl_pubmedia WHERE pub_id = '301190' 0.00013709068298340Всего 0.10741209983826 сек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 = '301190' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY likes_count DESC, replys_count DESC, reposts_count DESC, time DESC LIMIT 20.00025177001953125Всего 0.10766386985779 сек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 = '1788' LIMIT 10.00032091140747070Всего 0.10798478126526 сек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 ( '3031', '3032' ) 0.00010085105895996Всего 0.10808563232422 сек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 ( '3031', '3032' ) 0.00008606910705566Всего 0.10817170143127 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 SELECT id FROM cl_users WHERE username = 'power' LIMIT 10.00202178955078125Всего 0.11019349098206 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #689 SELECT * FROM cl_publications WHERE status IN ( 'active', 'inactive', 'deleted' ) AND id = '301190' LIMIT 10.00019979476928711Всего 0.11039328575134 сек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 = '1788' LIMIT 10.00030899047851562Всего 0.11070227622986 сек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 = '301190' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY id DESC LIMIT 300.00024795532226562Всего 0.11095023155212 сек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 = '301191' AND status IN ( 'active', 'inactive', 'deleted' ) ORDER BY id DESC LIMIT 20.00019097328186035Всего 0.11114120483398 сек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 = '1788' LIMIT 10.00030303001403809Всего 0.11144423484802 сек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 ( '3031', '3032' ) 0.00010991096496582Всего 0.11155414581299 сек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 ( '3031', '3032' ) 0.00008511543273926Всего 0.11163926124573 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 SELECT id FROM cl_users WHERE username = 'power' LIMIT 10.00186109542846680Всего 0.11350035667419 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/user.php" line #689 SELECT * FROM cl_publications WHERE status IN ( 'active', 'inactive', 'deleted' ) AND id = '301190' LIMIT 10.00018787384033203Всего 0.11368823051453 сек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 = '1788' LIMIT 10.00030207633972168Всего 0.11399030685425 сек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 = '301190' 0.00280499458312988Всего 0.11679530143738 сек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 = '301191' 0.00064015388488770Всего 0.11743545532227 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23