SELECT * FROM cl_configs0.00068712234497070Всего 0.0006871223449707 сек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.00016903877258301Всего 0.00085616111755371 сек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.00392222404479980Всего 0.0047783851623535 сек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.05070710182189941Всего 0.055485486984253 сек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.00027990341186523Всего 0.055765390396118 сек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 = 'сосопавлиашвили' LIMIT 10.00010991096496582Всего 0.055875301361084 сек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 = 3398) ORDER BY `time` DESC, `id` DESC LIMIT 15 0.00071620941162109Всего 0.056591510772705 сек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 = '1299' LIMIT 10.00038385391235352Всего 0.056975364685059 сек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 ( '3398', '3399', '3400', '3401', '2597' ) 0.00014615058898926Всего 0.057121515274048 сек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 ( '3398', '3399', '3400', '3401', '2597', '3395', '3396', '3397', '1129', '1134', '1133', '1129', '3365', '3366', '3360', '3175', '3367', '3368', '1236', '1232', '1146', '38', '3369', '3371', '3372', '1147', '1148', '1412', '3373', '1341', '1457', '1213', '1324', '1141', '1063' ) 0.00024199485778809Всего 0.057363510131836 сек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 = '327664' 0.00018119812011719Всего 0.057544708251953 сек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 = '1299' LIMIT 10.00036716461181641Всего 0.05791187286377 сек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 ( '3398', '3399', '3400', '3401', '2597' ) 0.00013399124145508Всего 0.058045864105225 сек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 ( '3398', '3399', '3400', '3401', '2597', '3395', '3396', '3397', '1129', '1134', '1133', '1129', '3365', '3366', '3360', '3007', '3175', '3367', '3368', '1232', '1146', '38', '3369', '3370', '3371', '3372', '1147', '1148', '1412', '3373', '1341', '1457', '1213', '1324', '1141', '1063' ) 0.00023794174194336Всего 0.058283805847168 сек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 = '327649' 0.00015282630920410Всего 0.058436632156372 сек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 = '327664' 0.00271105766296387Всего 0.061147689819336 сек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 = '327649' 0.00082778930664062Всего 0.061975479125977 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23