SELECT * FROM cl_configs0.00078892707824707Всего 0.00078892707824707 сек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.00018286705017090Всего 0.00097179412841797 сек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.00676798820495605Всего 0.007739782333374 сек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.09795188903808594Всего 0.10569167137146 сек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.00028419494628906Всего 0.10597586631775 сек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 = 'MidnightThoughts' LIMIT 10.00010418891906738Всего 0.10608005523682 сек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 = 5456) ORDER BY `time` DESC, `id` DESC LIMIT 15 0.00073289871215820Всего 0.10681295394897 сек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 = '3250' LIMIT 10.00038695335388184Всего 0.10719990730286 сек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 ( '5344', '5345', '5346', '5471', '5453', '5454', '5455', '5456', '5457', '5458' ) 0.00016593933105469Всего 0.10736584663391 сек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 ( '5344', '5345', '5346', '5471', '5453', '5454', '5455', '5456', '5457', '5458', '5459', '5460', '5461', '5462', '5463', '5464', '5465', '5466', '5467' ) 0.00017309188842773Всего 0.10753893852234 сек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 = '633587' 0.00015783309936523Всего 0.1076967716217 сек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 = '3250' LIMIT 10.00036883354187012Всего 0.10806560516357 сек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 ( '5346', '5468', '5469', '5453', '5454', '5455' ) 0.00013995170593262Всего 0.10820555686951 сек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 ( '5346', '5468', '5469', '5453', '5454', '5455', '5456', '5457', '5458', '5459', '5460', '5461', '5462', '5463', '5464', '5465', '5466', '5467', '5470' ) 0.00017499923706055Всего 0.10838055610657 сек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 = '633586' 0.00013613700866699Всего 0.10851669311523 сек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 = '3250' LIMIT 10.00036597251892090Всего 0.10888266563416 сек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 ( '5453', '5454', '5455', '5456', '5457', '5458', '5459', '5460', '5461', '5462' ) 0.00015091896057129Всего 0.10903358459473 сек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 ( '5453', '5454', '5455', '5456', '5457', '5458', '5459', '5460', '5461', '5462', '5463', '5464', '5465', '5466', '5467' ) 0.00015020370483398Всего 0.10918378829956 сек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 = '633585' 0.00013303756713867Всего 0.1093168258667 сек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 = '633587' 0.00268983840942383Всего 0.11200666427612 сек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 = '633586' 0.00077486038208008Всего 0.1127815246582 сек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 = '633585' 0.00051712989807129Всего 0.11329865455627 секMysqliDb->update() >> file "/var/www/twitty/data/www/ai.twitty.ru/twitty_web/core/components/post.php" line #23