SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.008007
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000751
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_search
WHERE search_id = ?
Params: 11866466
Run Time: 0.000602
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000487
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category_map | index | PRIMARY | PRIMARY | 8 | | 83 | Using where; Using index |
SELECT media.*
,
album.*, albumviewperm.*,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, media.username, user.username) AS username,
attachment.attachment_id, attachment.data_id, attachment.attach_date,data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xengallery_media AS media
LEFT JOIN xengallery_album AS album ON
(album.album_id = media.album_id)
LEFT JOIN xengallery_album_permission as albumviewperm ON
(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
LEFT JOIN xengallery_category AS category FORCE INDEX (PRIMARY) ON
(category.category_id = media.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = media.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = media.user_id)
LEFT JOIN xf_attachment AS attachment ON
(attachment.content_type = 'xengallery_media' AND attachment.attachment_id = media.attachment_id)
LEFT JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE (
media.media_privacy = 'public'
OR IF(media.category_id > 0, media.category_id IN (1, 2, 4, 5, 6, 7, 9), NULL)) AND (media.media_state IN ('visible')) AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
ORDER BY media.media_date DESC, media.media_id DESC
LIMIT 200
Run Time: 0.016017
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ALL | | | | | 64 | Using where; Using temporary; Using filesort |
SIMPLE | album | ALL | PRIMARY | | | | 3 | Using where; Using join buffer (hash join) |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | hsvgtsr.album.album_id,const | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | hsvgtsr.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.attachment.data_id | 1 | |
SELECT media.*
,
album.*, albumviewperm.*,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, media.username, user.username) AS username,
attachment.attachment_id, attachment.data_id, attachment.attach_date,data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xengallery_media AS media FORCE INDEX (media_date)
LEFT JOIN xengallery_album AS album ON
(album.album_id = media.album_id)
LEFT JOIN xengallery_album_permission as albumviewperm ON
(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
LEFT JOIN xengallery_category AS category FORCE INDEX (PRIMARY) ON
(category.category_id = media.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = media.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = media.user_id)
LEFT JOIN xf_attachment AS attachment ON
(attachment.content_type = 'xengallery_media' AND attachment.attachment_id = media.attachment_id)
LEFT JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE (media.media_id IN (63, 62, 61, 60, 59, 58, 57, 56, 55, 54, 53, 52, 51, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 4, 3, 2, 1)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.002457
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ALL | | | | | 64 | Using where |
SIMPLE | album | ALL | PRIMARY | | | | 3 | Using where; Using join buffer (hash join) |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | hsvgtsr.album.album_id,const | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | hsvgtsr.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | hsvgtsr.attachment.data_id | 1 | |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["xengallery_media",63],["xengallery_media",62],["xengallery_media",61],["xengallery_media",60],["xengallery_media",59],["xengallery_media",58],["xengallery_media",57],["xengallery_media",56],["xengallery_media",55],["xengallery_media",54],["xengallery_media",53],["xengallery_media",52],["xengallery_media",51],["xengallery_media",50],["xengallery_media",49],["xengallery_media",48],["xengallery_media",47],["xengallery_media",46],["xengallery_media",45],["xengallery_media",44],["xengallery_media",43],["xengallery_media",42],["xengallery_media",41],["xengallery_media",40],["xengallery_media",39],["xengallery_media",38],["xengallery_media",37],["xengallery_media",36],["xengallery_media",35],["xengallery_media",34],["xengallery_media",33],["xengallery_media",32],["xengallery_media",31],["xengallery_media",30],["xengallery_media",29],["xengallery_media",28],["xengallery_media",27],["xengallery_media",26],["xengallery_media",25],["xengallery_media",24],["xengallery_media",23],["xengallery_media",22],["xengallery_media",21],["xengallery_media",20],["xengallery_media",19],["xengallery_media",18],["xengallery_media",17],["xengallery_media",16],["xengallery_media",15],["xengallery_media",14],["xengallery_media",13],["xengallery_media",12],["xengallery_media",11],["xengallery_media",10],["xengallery_media",9],["xengallery_media",8],["xengallery_media",7],["xengallery_media",4],["xengallery_media",3],["xengallery_media",2],["xengallery_media",1]], 61, xengallery_media, , ["findNew"], date, 0, , [], 0, 1714126810, 36479db84cc074f46b51a4d21e63f89a
Run Time: 0.003333
SELECT option_value FROM xf_option WHERE option_id = 'currentVersionId'
Run Time: 0.000337
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_option | const | PRIMARY | PRIMARY | 52 | const | 1 | |
INSERT INTO `xf_error_log` (`exception_date`, `user_id`, `ip_address`, `exception_type`, `message`, `filename`, `line`, `trace_string`, `request_state`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: 1714126810, 0, ^, Zend_Db_Statement_Mysqli_Exception, Mysqli prepare error: Table './hsvgtsr/xf_session' is marked as crashed and last (automatic?) repair failed, library/Zend/Db/Statement/Mysqli.php, 77, #0 /home/hsvgts/hsv-gtsr.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/hsvgts/hsv-gtsr.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/hsvgts/hsv-gtsr.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/hsvgts/hsv-gtsr.com/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/hsvgts/hsv-gtsr.com/library/XenForo/Session.php(856): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
#5 /home/hsvgts/hsv-gtsr.com/library/XenForo/Session.php(574): XenForo_Session->saveSessionToSource('60f2869bf749a92...', false)
#6 /home/hsvgts/hsv-gtsr.com/library/XenForo/Controller.php(414): XenForo_Session->save()
#7 /home/hsvgts/hsv-gtsr.com/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_Redirect), 'XenForo_Control...', 'Media')
#8 /home/hsvgts/hsv-gtsr.com/library/XenForo/FrontController.php(358): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_Redirect), 'XenForo_Control...', 'Media')
#9 /home/hsvgts/hsv-gtsr.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/hsvgts/hsv-gtsr.com/index.php(13): XenForo_FrontController->run()
#11 {main}, a:3:{s:3:"url";s:59:"http://hsv-gtsr.com/find-new/11866466/media?page=7&_debug=1";s:4:"_GET";a:2:{s:4:"page";s:1:"7";s:6:"_debug";s:1:"1";}s:5:"_POST";a:0:{}}
Run Time: 0.010148
SELECT option_value FROM xf_option WHERE option_id = 'currentVersionId'
Run Time: 0.000340
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_option | const | PRIMARY | PRIMARY | 52 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'xengallery_bb_code_tag_gallery', 'xengallery_tab_links', 'EWRatendo2_Navtabs', 'EWRporta2_Navtabs', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000661
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('atendo2_calendar')
Params: 1
Run Time: 0.000775
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |