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.000425
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 (16469, 16468, 16467, 16466, 16465, 16464, 16463, 16462, 16461, 16460, 16459, 16458, 16457, 16456, 16455, 16454, 16453, 16452, 16451, 16450, 16449, 16448, 16447, 16446, 16445, 16444, 16443, 16442, 16441, 16440, 16439, 16438, 16437, 16436, 16435, 16434, 16433, 16432, 16431, 16430, 16429, 16428, 16427, 16426, 16425, 16424, 16423, 16422, 16421, 16420, 16419, 16418, 16417, 16416, 16415, 16414, 16413, 16412, 16411, 16410, 16409, 16408, 16407, 16406, 16405, 16404, 16403, 16402, 16401, 16400, 16399, 16398, 16397, 16396, 16395, 16394, 16393, 16392, 16391, 16390, 16389, 16388, 16387, 16386, 16385, 16384, 16383))
Run Time: 0.003109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 87 | 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: 3915, 0, 1716077290, {"thread-85991":["thread",85991],"xfmg_media-16469":["xfmg_media",16469],"xfmg_media-16468":["xfmg_media",16468],"xfmg_media-16467":["xfmg_media",16467],"xfmg_media-16466":["xfmg_media",16466],"xfmg_media-16465":["xfmg_media",16465],"xfmg_media-16464":["xfmg_media",16464],"xfmg_media-16463":["xfmg_media",16463],"xfmg_media-16462":["xfmg_media",16462],"xfmg_media-16461":["xfmg_media",16461],"xfmg_media-16460":["xfmg_media",16460],"xfmg_media-16459":["xfmg_media",16459],"xfmg_media-16458":["xfmg_media",16458],"xfmg_media-16457":["xfmg_media",16457],"xfmg_media-16456":["xfmg_media",16456],"xfmg_media-16455":["xfmg_media",16455],"xfmg_media-16454":["xfmg_media",16454],"xfmg_media-16453":["xfmg_media",16453],"xfmg_media-16452":["xfmg_media",16452],"xfmg_media-16451":["xfmg_media",16451],"xfmg_media-16450":["xfmg_media",16450],"xfmg_media-16449":["xfmg_media",16449],"xfmg_media-16448":["xfmg_media",16448],"xfmg_media-16447":["xfmg_media",16447],"xfmg_media-16446":["xfmg_media",16446],"xfmg_media-16445":["xfmg_media",16445],"xfmg_media-16444":["xfmg_media",16444],"xfmg_media-16443":["xfmg_media",16443],"xfmg_media-16442":["xfmg_media",16442],"xfmg_media-16441":["xfmg_media",16441],"xfmg_media-16440":["xfmg_media",16440],"xfmg_media-16439":["xfmg_media",16439],"xfmg_media-16438":["xfmg_media",16438],"xfmg_media-16437":["xfmg_media",16437],"xfmg_media-16436":["xfmg_media",16436],"xfmg_media-16435":["xfmg_media",16435],"xfmg_media-16434":["xfmg_media",16434],"xfmg_media-16433":["xfmg_media",16433],"xfmg_media-16432":["xfmg_media",16432],"xfmg_media-16431":["xfmg_media",16431],"xfmg_media-16430":["xfmg_media",16430],"xfmg_media-16429":["xfmg_media",16429],"xfmg_media-16428":["xfmg_media",16428],"xfmg_media-16427":["xfmg_media",16427],"xfmg_media-16426":["xfmg_media",16426],"xfmg_media-16425":["xfmg_media",16425],"xfmg_media-16424":["xfmg_media",16424],"xfmg_media-16423":["xfmg_media",16423],"xfmg_media-16422":["xfmg_media",16422],"xfmg_media-16421":["xfmg_media",16421],"xfmg_media-16420":["xfmg_media",16420],"xfmg_media-16419":["xfmg_media",16419],"xfmg_media-16418":["xfmg_media",16418],"xfmg_media-16417":["xfmg_media",16417],"xfmg_media-16416":["xfmg_media",16416],"xfmg_media-16415":["xfmg_media",16415],"xfmg_media-16414":["xfmg_media",16414],"xfmg_media-16413":["xfmg_media",16413],"xfmg_media-16412":["xfmg_media",16412],"xfmg_media-16411":["xfmg_media",16411],"xfmg_media-16410":["xfmg_media",16410],"xfmg_media-16409":["xfmg_media",16409],"xfmg_media-16408":["xfmg_media",16408],"xfmg_media-16407":["xfmg_media",16407],"xfmg_media-16406":["xfmg_media",16406],"xfmg_media-16405":["xfmg_media",16405],"xfmg_media-16404":["xfmg_media",16404],"xfmg_media-16403":["xfmg_media",16403],"xfmg_media-16402":["xfmg_media",16402],"xfmg_media-16401":["xfmg_media",16401],"xfmg_media-16400":["xfmg_media",16400],"xfmg_media-16399":["xfmg_media",16399],"xfmg_media-16398":["xfmg_media",16398],"xfmg_media-16397":["xfmg_media",16397],"xfmg_media-16396":["xfmg_media",16396],"xfmg_media-16395":["xfmg_media",16395],"xfmg_media-16394":["xfmg_media",16394],"xfmg_media-16393":["xfmg_media",16393],"xfmg_media-16392":["xfmg_media",16392],"xfmg_media-16391":["xfmg_media",16391],"xfmg_media-16390":["xfmg_media",16390],"xfmg_media-16389":["xfmg_media",16389],"xfmg_media-16388":["xfmg_media",16388],"xfmg_media-16387":["xfmg_media",16387],"xfmg_media-16386":["xfmg_media",16386],"xfmg_media-16385":["xfmg_media",16385],"xfmg_media-16384":["xfmg_media",16384],"xfmg_media-16383":["xfmg_media",16383]}, , 1716073690
Run Time: 0.000223
- 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