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 (183410, 183406, 183407, 183408, 183409, 183397, 183398, 183399, 183400, 183401, 183389, 183375, 183364, 183359, 183360, 183361, 183362, 183363, 183358, 183357, 183354, 183355, 183356, 183351, 183352, 183353, 183349, 183350, 183344, 183345, 183346, 183347, 183348, 183340, 183341, 183342, 183343, 183336, 183337, 183338, 183339, 183332, 183333, 183334, 183335, 183331, 183327, 183328, 183329, 183330, 183323, 183324, 183325, 183326, 183322, 183321, 183319, 183320, 183314, 183315, 183316, 183309, 183310, 183311, 183312, 183313, 183301, 183302, 183303, 183300, 183289, 183290, 183291, 183292, 183293, 183294, 183281, 183282, 183283, 183284, 183279, 183280, 183278, 183272, 183273, 183274, 183275, 183276, 183277, 183271, 183270, 183269, 183268, 183267, 183265, 183266, 183264, 183263, 183261, 183262, 183180, 183181, 183174, 183175, 183176, 183177, 183173, 183172, 183169, 183170, 183171, 183166, 183167, 183168, 183165, 183149, 183150, 183151, 183136, 183125, 183126, 183113, 183098, 183099, 183100, 183101, 183102, 183091, 183092, 183093, 183094, 183095, 183096, 183097, 183079, 183080, 183076, 183073, 183074, 183075, 183072, 183069, 183070, 183071, 183067, 183068, 183066, 183064, 183065, 183057, 183058, 183059, 183060, 183061, 183062, 183063, 183056, 183054, 183055, 183051, 183052, 183053, 183046, 183047, 183048, 183049, 183050, 183045, 183044, 183025, 183015, 183024, 183023, 183022, 183021, 183020, 183019, 183018, 183017, 183016, 183014, 183013, 183012, 183011, 183010, 183009, 183008, 183007, 183005, 183006, 183001, 183002, 183003, 183004, 182992, 182993, 182994, 182995, 182996, 182997))
Run Time: 0.006023
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.000965
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