SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.000571
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 38 | 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/DataRegistry.php at line 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 1905
- XF\App->preLoadData() in src/XF/App.php at line 1893
- XF\App->setup() in src/XF/Pub/App.php at line 93
- XF\Pub\App->setup() in src/XF.php at line 490
- XF::setupApp() in src/XF.php at line 513
- XF::runApp() in index.php at line 20
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.*
FROM `xf_mg_media_item`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`)
WHERE (`xf_mg_media_item`.`media_id` IN (16962, 16961, 16960, 16959, 16958, 16957, 16956, 16955, 16954, 16953, 16952, 16951, 16950, 16949, 16948, 16947, 16946, 16945, 16944, 16943, 16942, 16941, 16940, 16939, 16938, 16937, 16936, 16935, 16934, 16933, 16932, 16931, 16930, 16929, 16928, 16927, 16926, 16925, 16924, 16923, 16922, 16921, 16920, 16919, 16918, 16917, 16916, 16915, 16914, 16913, 16912, 16911, 16910, 16909, 16908, 16907, 16906, 16905, 16904, 16903, 16902, 16901, 16900, 16899, 16898, 16897, 16896, 16895, 16894, 16893, 16892, 16891, 16890, 16889, 16888, 16886, 16885, 16884, 16883))
Run Time: 0.002841
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 79 | Using where |
SIMPLE | xf_mg_album_Album_1 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_mg_media_item.category_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,devadriaforum.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_attachment_Attachment_4.data_id | 1 | |
- 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 1387
- 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 2729
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->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/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 263
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 3985, 0, 1716695612, {"xfmg_media-16962":["xfmg_media",16962],"xfmg_media-16961":["xfmg_media",16961],"xfmg_media-16960":["xfmg_media",16960],"xfmg_media-16959":["xfmg_media",16959],"xfmg_media-16958":["xfmg_media",16958],"xfmg_media-16957":["xfmg_media",16957],"xfmg_media-16956":["xfmg_media",16956],"xfmg_media-16955":["xfmg_media",16955],"xfmg_media-16954":["xfmg_media",16954],"xfmg_media-16953":["xfmg_media",16953],"xfmg_media-16952":["xfmg_media",16952],"xfmg_media-16951":["xfmg_media",16951],"xfmg_media-16950":["xfmg_media",16950],"xfmg_media-16949":["xfmg_media",16949],"xfmg_media-16948":["xfmg_media",16948],"xfmg_media-16947":["xfmg_media",16947],"xfmg_media-16946":["xfmg_media",16946],"xfmg_media-16945":["xfmg_media",16945],"xfmg_media-16944":["xfmg_media",16944],"xfmg_media-16943":["xfmg_media",16943],"xfmg_media-16942":["xfmg_media",16942],"xfmg_media-16941":["xfmg_media",16941],"xfmg_media-16940":["xfmg_media",16940],"xfmg_media-16939":["xfmg_media",16939],"xfmg_media-16938":["xfmg_media",16938],"xfmg_media-16937":["xfmg_media",16937],"xfmg_media-16936":["xfmg_media",16936],"xfmg_media-16935":["xfmg_media",16935],"xfmg_media-16934":["xfmg_media",16934],"xfmg_media-16933":["xfmg_media",16933],"xfmg_media-16932":["xfmg_media",16932],"xfmg_media-16931":["xfmg_media",16931],"xfmg_media-16930":["xfmg_media",16930],"xfmg_media-16929":["xfmg_media",16929],"xfmg_media-16928":["xfmg_media",16928],"xfmg_media-16927":["xfmg_media",16927],"xfmg_media-16926":["xfmg_media",16926],"xfmg_media-16925":["xfmg_media",16925],"xfmg_media-16924":["xfmg_media",16924],"xfmg_media-16923":["xfmg_media",16923],"thread-86046":["thread",86046],"xfmg_media-16922":["xfmg_media",16922],"xfmg_media-16921":["xfmg_media",16921],"xfmg_media-16920":["xfmg_media",16920],"xfmg_media-16919":["xfmg_media",16919],"xfmg_media-16918":["xfmg_media",16918],"xfmg_media-16917":["xfmg_media",16917],"xfmg_media-16916":["xfmg_media",16916],"xfmg_media-16915":["xfmg_media",16915],"xfmg_media-16914":["xfmg_media",16914],"xfmg_media-16913":["xfmg_media",16913],"xfmg_media-16912":["xfmg_media",16912],"xfmg_media-16911":["xfmg_media",16911],"xfmg_media-16910":["xfmg_media",16910],"xfmg_media-16909":["xfmg_media",16909],"xfmg_media-16908":["xfmg_media",16908],"xfmg_media-16907":["xfmg_media",16907],"xfmg_media-16906":["xfmg_media",16906],"xfmg_media-16905":["xfmg_media",16905],"xfmg_media-16904":["xfmg_media",16904],"xfmg_media-16903":["xfmg_media",16903],"xfmg_media-16902":["xfmg_media",16902],"xfmg_media-16901":["xfmg_media",16901],"xfmg_media-16900":["xfmg_media",16900],"xfmg_media-16899":["xfmg_media",16899],"xfmg_media-16898":["xfmg_media",16898],"xfmg_media-16897":["xfmg_media",16897],"xfmg_media-16896":["xfmg_media",16896],"xfmg_media-16895":["xfmg_media",16895],"xfmg_media-16894":["xfmg_media",16894],"xfmg_media-16893":["xfmg_media",16893],"xfmg_media-16892":["xfmg_media",16892],"xfmg_media-16891":["xfmg_media",16891],"xfmg_media-16890":["xfmg_media",16890],"xfmg_media-16889":["xfmg_media",16889],"xfmg_media-16888":["xfmg_media",16888],"xfmg_media-16886":["xfmg_media",16886],"xfmg_media-16885":["xfmg_media",16885],"xfmg_media-16884":["xfmg_media",16884],"xfmg_media-16883":["xfmg_media",16883]}, , 1716692012
Run Time: 0.000200
- 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 223
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 263
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20