SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.001186
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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
u.user_id,
u.user_group_id,
u.secondary_group_ids,
a.data
from
xf_user as u
inner join xf_user_authenticate as a on u.user_id = a.user_id
where
u.username = ''
limit 1Run Time: 0.000436
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: da98627426a9d9a23cc1af9ce65dc1f7, a:5:{s:12:"sessionStart";i:1369356585;s:2:"ip";i:921351355;s:9:"userAgent";s:9:"CCBot/2.0";s:7:"isRobot";b:0;s:16:"previousActivity";i:0;}, 1369360185
Run Time: 0.000116
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, 921351355, 921351355, AddonChat_ControllerPublic_Index, Embed, valid, , 1369356585
Run Time: 0.000065
SELECT COUNT(*) AS user_count FROM addonchat_who
Run Time: 0.000114
| 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.000176
| 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', 'AddonChat_Public_Embed', '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.000460
| 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.000166
| 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.000111
| 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.000118
| 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.000128
| 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