SELECT * FROM cl_configs0.00064611434936523Всего 0.00064611434936523 сек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.00015401840209961Всего 0.00080013275146484 сек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.00540685653686523Всего 0.0062069892883301 сек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.07980990409851074Всего 0.086016893386841 секMysqliDb->rawQuery() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #385 SELECT * FROM cl_publications WHERE admin_pinned = 'Y' LIMIT 10.00036716461181641Всего 0.086384057998657 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/explore/app_ctrl.php" line #185 SELECT id FROM cl_hashtags WHERE tag = 'foryoirpage' LIMIT 10.00015497207641602Всего 0.086539030075073 секMysqliDb->getOne() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #409 SELECT cl_publications.* FROM `cl_publications` INNER JOIN cl_users u ON u.id = cl_publications.user_id WHERE `status` = "active" AND `target` = "publication" AND `admin_pinned` = "N" AND `priv_wcs` = "everyone" AND EXISTS ( SELECT 1 FROM cl_publications_hashtags ph WHERE ph.publication_id = cl_publications.id AND ph.hashtag_id = 5809) ORDER BY `time` DESC, `id` DESC LIMIT 15 0.00085401535034180Всего 0.087393045425415 секMysqliDb->rawQuery() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/apps/explore/app_ctrl.php" line #122 SELECT * FROM cl_users WHERE id = '3477' LIMIT 10.00033617019653320Всего 0.087729215621948 сек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 ( '5807', '591', '5808', '5809', '5810', '5811', '5812', '5813', '5814' ) 0.00019097328186035Всего 0.087920188903809 сек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 ( '5807', '591', '5808', '5809', '5810', '5811', '5812', '5813', '5814', '5478', '5479', '5477', '5482', '5483', '5484', '5485', '5486', '5487', '5488', '5489', '5815' ) 0.00019717216491699Всего 0.088117361068726 сек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 = '670859' 0.00020194053649902Всего 0.088319301605225 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #77 SELECT * FROM cl_users WHERE id = '3477' LIMIT 10.00031995773315430Всего 0.088639259338379 сек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 ( '5807', '591', '5808', '5809', '5810', '5811', '5812', '5813', '5814' ) 0.00017595291137695Всего 0.088815212249756 сек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 ( '5807', '591', '5808', '5809', '5810', '5811', '5812', '5813', '5814', '5478', '5479', '5477', '5482', '5483', '5484', '5485', '5486', '5487', '5488', '5489', '5815' ) 0.00020003318786621Всего 0.089015245437622 сек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 = '670855' 0.00015401840209961Всего 0.089169263839722 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #77 SELECT * FROM cl_users WHERE id = '3477' LIMIT 10.00029206275939941Всего 0.089461326599121 сек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 ( '5807', '591', '5808', '5809', '5810', '5811', '5812', '5813', '5814' ) 0.00016093254089355Всего 0.089622259140015 сек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 ( '5807', '591', '5808', '5809', '5810', '5811', '5812', '5813', '5814', '5478', '5479', '5477', '5482', '5483', '5484', '5485', '5486', '5487', '5488', '5489', '5815' ) 0.00019097328186035Всего 0.089813232421875 сек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 = '670854' 0.00015306472778320Всего 0.089966297149658 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #77 UPDATE cl_publications SET `views_count` = views_count+1 WHERE id = '670859' 0.00239300727844238Всего 0.092359304428101 сек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 = '670855' 0.00060796737670898Всего 0.09296727180481 сек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 = '670854' 0.00076603889465332Всего 0.093733310699463 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23