SELECT * FROM cl_configs0.00080800056457520Всего 0.0008080005645752 сек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.0009620189666748 сек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.00358915328979492Всего 0.0045511722564697 сек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.05071806907653809Всего 0.055269241333008 сек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.00031089782714844Всего 0.055580139160156 сек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 = 'instagram' LIMIT 10.00011301040649414Всего 0.05569314956665 сек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 = 2007) ORDER BY `time` DESC, `id` DESC LIMIT 15 0.00077509880065918Всего 0.05646824836731 сек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 = '1788' LIMIT 10.00043988227844238Всего 0.056908130645752 сек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 ( '3772', '3773', '3774', '3775', '3776', '3777', '3778', '3779', '3780', '3781', '3782', '3783', '3784', '3785', '3786' ) 0.00024986267089844Всего 0.05715799331665 сек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 ( '3772', '3773', '3774', '3775', '3776', '3777', '3778', '3779', '3780', '3781', '3782', '3783', '3784', '3785', '3786', '3787', '3788', '2007', '3789', '3790', '3791', '3792', '3793', '3794', '3795', '3796', '3797', '3798', '3799', '3800' ) 0.00023293495178223Всего 0.057390928268433 сек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 = '379557' 0.00022912025451660Всего 0.057620048522949 сек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 = '1946' LIMIT 10.00039696693420410Всего 0.058017015457153 сек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 ( '3623', '432', '572', '3621', '3625' ) 0.00018000602722168Всего 0.058197021484375 сек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 ( '3623', '432', '572', '3621', '3625', '1622', '432', '3626', '3627', '3628', '571', '535', '3629', '3630', '3631', '3632', '3633', '3634', '3635', '3636', '3638', '3638', '2007', '2205', '3639', '2339', '3640', '3641', '3642', '3643', '2787', '3644', '402', '3645', '3646', '3647', '3648', '3649' ) 0.00024104118347168Всего 0.058438062667847 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 SELECT * FROM cl_users WHERE id = '1342' LIMIT 10.00039482116699219Всего 0.058832883834839 сек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 ( '2006', '2007', '1766', '531', '2008', '1888', '1146', '38', '1632', '1633', '1634', '535', '1623', '1635' ) 0.00021409988403320Всего 0.059046983718872 секMysqliDb->get() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #337 UPDATE cl_publications SET `views_count` = views_count+1 WHERE id = '379557' 0.00303196907043457Всего 0.062078952789307 сек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 = '361488' 0.00084185600280762Всего 0.062920808792114 сек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 = '143856' 0.00060200691223145Всего 0.063522815704346 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23