SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_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 (178156, 176709, 174405, 173041, 172534, 170582, 168871, 168348, 165205, 163140, 162591, 154259, 154108, 150684, 150039, 149600, 148838, 148695, 148662, 148458, 148389, 148271, 147666, 146896, 146834, 144888, 141607, 140226, 138834, 137328, 135618, 129021, 127718, 126936, 125620, 124695, 125404, 123503, 121144, 117804, 116013, 113562, 113266, 107850, 107386, 106633, 106412, 104808, 104511, 102659, 102505, 100901, 105447, 98911, 95753, 95713, 95527, 91999, 91952, 91950, 91862, 91737, 91278, 91118, 90861, 90860, 90857, 90743, 90618, 90322, 90140, 89829, 89049, 89007, 88997, 88895, 88692, 88672, 88654, 80356, 80336, 76789, 72932, 70203, 62883, 62395, 58712, 53142, 45100, 43787, 40363, 39447, 35797, 26290, 21338, 18997, 16826, 13773, 12717, 7877))
Run Time: 0.043185
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 100 | Using where |
| SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.node_id | 1 | |
| SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_forum_Forum_1.node_id | 1 | |
| SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.user_id | 1 | |
| SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.first_post_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,carder_admin_bd.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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 3240
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 77
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/TagRepository.php at line 745
- XF\Repository\TagRepository->getResultSetData() in src/XF/ResultSet.php at line 313
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 294
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/TagController.php at line 143
- XF\Pub\Controller\TagController->actionTag() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 510, 0, 1770616457, {"thread-178156":["thread",178156],"thread-176709":["thread",176709],"thread-174405":["thread",174405],"thread-173041":["thread",173041],"thread-172534":["thread",172534],"thread-170582":["thread",170582],"thread-168871":["thread",168871],"thread-168348":["thread",168348],"thread-165205":["thread",165205],"thread-163140":["thread",163140],"thread-162591":["thread",162591],"thread-154259":["thread",154259],"thread-154108":["thread",154108],"thread-150684":["thread",150684],"thread-150039":["thread",150039],"thread-149600":["thread",149600],"thread-148838":["thread",148838],"thread-148695":["thread",148695],"thread-148662":["thread",148662],"thread-148458":["thread",148458],"thread-148389":["thread",148389],"thread-148271":["thread",148271],"thread-147666":["thread",147666],"thread-146896":["thread",146896],"thread-146834":["thread",146834],"thread-144888":["thread",144888],"thread-141607":["thread",141607],"thread-140226":["thread",140226],"thread-138834":["thread",138834],"thread-137328":["thread",137328],"thread-135618":["thread",135618],"thread-129021":["thread",129021],"thread-127718":["thread",127718],"thread-126936":["thread",126936],"thread-125620":["thread",125620],"thread-124695":["thread",124695],"thread-125404":["thread",125404],"thread-123503":["thread",123503],"thread-121144":["thread",121144],"thread-117804":["thread",117804],"thread-116013":["thread",116013],"thread-113562":["thread",113562],"thread-113266":["thread",113266],"thread-107850":["thread",107850],"thread-107386":["thread",107386],"thread-106633":["thread",106633],"thread-106412":["thread",106412],"thread-104808":["thread",104808],"thread-104511":["thread",104511],"thread-102659":["thread",102659],"thread-102505":["thread",102505],"thread-100901":["thread",100901],"thread-105447":["thread",105447],"thread-98911":["thread",98911],"xfmg_media-205":["xfmg_media",205],"xfmg_media-197":["xfmg_media",197],"xfmg_media-190":["xfmg_media",190],"thread-95753":["thread",95753],"thread-95713":["thread",95713],"thread-95527":["thread",95527],"thread-91999":["thread",91999],"thread-91952":["thread",91952],"thread-91950":["thread",91950],"thread-91862":["thread",91862],"thread-91737":["thread",91737],"thread-91278":["thread",91278],"thread-91118":["thread",91118],"thread-90861":["thread",90861],"thread-90860":["thread",90860],"thread-90857":["thread",90857],"thread-90743":["thread",90743],"thread-90618":["thread",90618],"thread-90322":["thread",90322],"thread-90140":["thread",90140],"thread-89829":["thread",89829],"thread-89049":["thread",89049],"thread-89007":["thread",89007],"thread-88997":["thread",88997],"thread-88895":["thread",88895],"thread-88692":["thread",88692],"thread-88672":["thread",88672],"thread-88654":["thread",88654],"thread-80356":["thread",80356],"thread-80336":["thread",80336],"thread-76789":["thread",76789],"thread-72932":["thread",72932],"thread-70203":["thread",70203],"thread-62883":["thread",62883],"thread-62395":["thread",62395],"thread-58712":["thread",58712],"thread-53142":["thread",53142],"thread-45100":["thread",45100],"thread-43787":["thread",43787],"thread-40363":["thread",40363],"thread-39447":["thread",39447],"thread-35797":["thread",35797],"thread-26290":["thread",26290],"thread-21338":["thread",21338],"thread-18997":["thread",18997],"thread-16826":["thread",16826],"thread-13773":["thread",13773],"thread-12717":["thread",12717],"thread-7877":["thread",7877]}, NULL, 1770612857
Run Time: 0.001024
- 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 219
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1572
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1300
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/TagController.php at line 156
- XF\Pub\Controller\TagController->actionTag() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23