SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000198
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT EWRmedio_media.*, EWRmedio_categories.*, EWRmedio_services.*, xf_user.*, EWRmedio_media.service_value2 AS service_value2,
IF(xf_user.username IS NULL, EWRmedio_media.username, xf_user.username) AS username, xf_liked_content.like_date
FROM EWRmedio_media
LEFT JOIN EWRmedio_categories ON (EWRmedio_categories.category_id = EWRmedio_media.category_id)
LEFT JOIN EWRmedio_services ON (EWRmedio_services.service_id = EWRmedio_media.service_id)
LEFT JOIN xf_user ON (xf_user.user_id = EWRmedio_media.user_id)
LEFT JOIN xf_liked_content
ON (xf_liked_content.content_type = 'media'
AND xf_liked_content.content_id = EWRmedio_media.media_id
AND xf_liked_content.like_user_id = 0)
WHERE EWRmedio_media.media_id = ?
Params: 794
Run Time: 0.000903
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | EWRmedio_media | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | EWRmedio_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | EWRmedio_services | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_liked_content | const | content_type_id_like_user_id | content_type_id_like_user_id | 85 | const,const,const | 0 | unique row not found |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: e8aafe0c91a17989800a4731192f4cd7, a:5:{s:12:"sessionStart";i:1369530694;s:2:"ip";i:921364273;s:9:"userAgent";s:9:"CCBot/2.0";s:7:"isRobot";b:0;s:16:"previousActivity";i:0;}, 1369534294
Run Time: 0.000111
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date)
Params: 0, 921364273, 921364273, EWRmedio_ControllerPublic_Media_Media, Report, valid, media_id=794, 1369530694
Run Time: 0.000070
SELECT COUNT(*) AS user_count FROM addonchat_who
Run Time: 0.000098
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | addonchat_who | index | | PRIMARY | 4 | | 1 | Using index |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home', 'nhra_navbar_tab', 'nascar_navbar_tab', 'indy_navbar_tab', 'AddonChat_Tab')Params: 1
Run Time: 0.000163
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 231 | | 4 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'EWRmedio_MediaReport', 'EWRporta_Navtabs', 'xfr_useralbums_links', 'AddonChat_Tab_Links', 'EWRmedio_Navtabs', 'tinhte_xentag_hook_message_content', 'tinhte_xentag_hook_message_notices', 'tinhte_xentag_hook_post_private_controls', 'tinhte_xentag_hook_post_public_controls', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?Params: 5, 1
Run Time: 0.000403
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 9 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('collapsible_sidebar_arrow')
AND style_id = ?
AND language_id = ?Params: 5, 1
Run Time: 0.000135
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('ltt_ticker')
AND style_id = ?
AND language_id = ?Params: 5, 1
Run Time: 0.000103
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('merc_code_render')
AND style_id = ?
AND language_id = ?Params: 5, 1
Run Time: 0.000106
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('collapsible_sidebar_js')
AND style_id = ?
AND language_id = ?Params: 5, 1
Run Time: 0.000109
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
INSERT INTO merc_ad_view (ad_id)
VALUES (11)
Run Time: 0.000041