SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (228385, 228383, 228384, 228379, 228380, 228381, 228382, 228375, 228376, 228377, 228378, 228371, 228372, 228373, 228369, 228370, 228358, 228359, 228360, 228361, 228362, 228363, 228364, 228365, 228366, 228367, 228368, 228343, 228344, 228345, 228326, 228323, 228324, 228325, 228302, 228303, 228304, 228305, 228301, 228300, 228298, 228299, 228293, 228294, 228295, 228296, 228297, 228287, 228288, 228289, 228290, 228291, 228292, 228286, 228281, 228282, 228283, 228284, 228285, 228271, 228272, 228273, 228274, 228275, 228276, 228277, 228278, 228279, 228280, 228269, 228270, 228262, 228263, 228264, 228265, 228266, 228267, 228268, 228258, 228259, 228260, 228261, 228255, 228256, 228257, 228252, 228253, 228254, 228249, 228250, 228251, 228244, 228245, 228246, 228247, 228248, 228243, 228242, 228240, 228241, 228233, 228234, 228235, 228236, 228237, 228238, 228239, 228232, 228230, 228231, 228229, 228228, 228227, 228226, 228225, 228224, 228222, 228223, 228221, 228220, 228217, 228218, 228219, 228211, 228212, 228213, 228214, 228215, 228216, 228199, 228200, 228201, 228202, 228203, 228204, 228205, 228206, 228207, 228208, 228209, 228210, 228198, 228182, 228183, 228184, 228164, 228165, 228166, 228153, 228154, 228155, 228139, 228140, 228137, 228138, 228136, 228131, 228132, 228133, 228134, 228135, 228127, 228128, 228129, 228130, 228126, 228123, 228124, 228125, 228121, 228122, 228111, 228112, 228113, 228114, 228115, 228116, 228117, 228118, 228119, 228120, 228106, 228107, 228108, 228109, 228110, 228097, 228098, 228099, 228100, 228101, 228102, 228103, 228104, 228105, 228096, 228091, 228092, 228093, 228094))
Run Time: 0.007891
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | megasliv.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,megasliv.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Repository/Search.php at line 33
- XF\Repository\Search->runSearch() in src/addons/DCom/QuickSearch/XF/Repository/Search.php at line 9
- DCom\QuickSearch\XF\Repository\Search->runSearch() in src/XF/Pub/Controller/Search.php at line 437
- XF\Pub\Controller\Search->runSearch() in src/XF/Pub/Controller/Search.php at line 270
- XF\Pub\Controller\Search->actionMember() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 27
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('admin_navigation', 'admin_templates', 'attachments', 'bb_code_media_sites', 'captcha_questions', 'connected_account_providers', 'contacts', 'conversation_messages', 'cron_entries', 'dbtech_user_upgrade_coupons_long', 'email_templates', 'rss_feed_importers', 'graphs', 'lfs_sticked_link_purchases', 'liamw_macros_globalmacros', 'login_as_users', 'member_stats', 'navigation', 'nf_tickets_categories', 'nf_tickets_kb_articles', 'nf_tickets_messages', 'nf_tickets_tickets', 'nodes', 'notices', 'options', 'pages', 'payment_profiles', 'phrases', 'posts', 'profile_posts', 'profile_post_comments', 'public_templates', 'reports', 'siropu_ads_manager_ads', 'siropu_ads_manager_invs', 'style_properties', 'tags', 'thdonate_campaigns', 'thdonate_comments', 'thdonate_donations', 'threads', 'custom_thread_fields', 'thread_prefixes', 'thread_prompts', 'ticket_messages', 'trophies', 'users', 'custom_user_fields', 'user_groups', 'user_upgrades', 'username_changes', 'warnings', 'widgets', 'xfmg_albums', 'xfmg_comments', 'xfmg_medias')
Params: 3
Run Time: 0.000808
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 56 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 374
- XF\Language->loadPhrases() in src/XF/Language.php at line 261
- XF\Language->getPhraseText() in src/XF/Language.php at line 132
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/Phrase.php at line 61
- XF\Phrase->__toString() in src/XF.php at line 1192
- XF::escapeString() in src/XF/Template/Templater.php at line 1205
- XF\Template\Templater->escape() in src/XF/Template/Templater.php at line 1088
- XF\Template\Templater->filter() in internal_data/code_cache/templates/l3/s21/public/helper_js_global.php at line 128
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s21/public/PAGE_CONTAINER.php at line 2811
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 27