SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_tag`.*, `xf_tagess_synonym_SynonymOf_1`.*, `xf_tag_Tag_2`.* FROM `xf_tag` LEFT JOIN `xf_tagess_synonym` AS `xf_tagess_synonym_SynonymOf_1` ON (`xf_tagess_synonym_SynonymOf_1`.`tag_id` = `xf_tag`.`tag_id`) LEFT JOIN `xf_tag` AS `xf_tag_Tag_2` ON (`xf_tag_Tag_2`.`tag_id` = `xf_tagess_synonym_SynonymOf_1`.`tag_id`) WHERE (`xf_tag`.`tag_url` = 'duel') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag | const | tag_url | tag_url | 302 | const | 1 | |
SIMPLE | xf_tagess_synonym_SynonymOf_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_tag_Tag_2 | const | PRIMARY | 1 |
SELECT add_user_id, COUNT(*) AS total_count FROM xf_tag_content WHERE tag_id = ? GROUP BY add_user_id ORDER BY total_count DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 1135 | Using where; Using temporary; Using filesort |
SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.* FROM `xf_user` LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`user_id` IN (0, 359, 5673, 16473, 9059, 360, 2119, 4974, 3295, 15515, 2048, 1917, 666, 2356, 13573, 5732, 1538, 7957, 2244, 6515, 1975, 1013, 9838, 820, 60, 2318, 5642, 795, 797, 1004, 7581, 596, 74, 71, 332, 3851, 1744, 703, 2651, 4954, 1308, 4803, 774, 12287, 1235, 14283, 114, 2595, 1206, 15703, 1494, 124, 3, 3250, 247, 17291, 3632, 1574, 4339, 56, 9427, 1473, 10223, 11, 4653, 6830, 17, 2813, 5714, 475, 554, 12134, 5956, 6676, 4739, 264, 461, 2301, 2511, 1797, 3263, 6770, 3289, 26608, 1864, 10100, 13204, 16570, 4058, 4846, 5082, 2217, 9019, 2476, 5363, 7618, 12396, 12440, 15027, 1024, 890, 2120, 1685, 2400, 7293, 9931, 4851, 908, 6302, 7682, 7053, 3134, 28264, 1937, 3006, 6660, 162, 640, 2017, 2430, 5340, 7115, 761, 33434, 510, 1158, 3055, 85, 8974, 806, 2749, 6439, 20540, 350, 4659, 5313, 9610, 1772, 906, 118, 2893, 4638, 687, 657, 929, 738, 8876, 13668, 11590, 391, 326, 11501, 5395, 534, 1897, 2689, 5735, 9417, 13604, 1433, 1250, 2639, 1745, 6672, 9449, 803, 2063, 4893, 6358, 9580, 9486, 338, 3014, 1195, 4315, 6789, 7463, 14545, 73, 1663, 2037, 2612, 3288, 1541, 3855, 6347, 6335, 6540, 9888, 7432, 2911, 15993, 14197, 27998, 2742, 2117, 1880, 5171, 2219, 1942, 4030, 6887, 6485, 8215, 12660, 5878, 17255, 31114, 37, 2097, 1611, 2983, 3083, 4775, 2560, 106, 3610, 11280, 12469, 7548, 1696, 16089, 15705, 848, 1483, 2247, 2398, 2966, 1, 5415, 5984, 4860, 7108, 7519, 781, 5237, 15138, 8380, 25465, 16668, 936, 748, 909, 782, 3441, 3933, 4115, 3229, 6289, 2655, 10059, 7067, 13074, 14287, 13622, 1141, 62, 2488, 1842, 2736, 4249, 591, 5376, 6341, 3598, 8483, 8216, 586, 13721, 18548, 35922, 821, 2194, 568, 984, 4917, 1839, 5130, 7302, 3711, 5588, 11345, 12345, 323, 10614, 16396, 34996, 618, 2157, 722, 944, 215, 3996, 4717, 7316, 8665, 8476, 11994, 13201, 5915, 15266, 16530, 20742, 400, 982, 2685, 1915, 3235, 3038, 2507, 1503, 6290, 7705, 5946, 8897, 8405, 14532, 15336, 16291, 32034, 344, 1258, 46, 2114, 577, 4080, 3562, 4949, 3969, 1886, 6809, 7622, 8104, 1786, 7539, 6819, 12098, 14615, 15384, 16652, 27109, 357, 1660, 2163, 2802, 962, 3713, 3446, 4162, 7270, 78, 12521, 12543, 15362, 21873, 4761, 348, 613, 2161, 2448, 594, 5208, 4901, 5681, 6499, 1318, 2653, 8205, 9198, 13112, 14668, 11141, 15510, 1048, 1446, 1773, 2233, 3436, 4534, 5772, 5859, 7730, 1077, 11643, 9811, 16103, 12751, 16918, 12771, 515, 2034, 2211, 3015, 3551, 3821, 4494, 1592, 6542, 6552, 6151, 2780, 9938, 11776, 13844, 15472, 13872, 30537, 621, 1305, 668, 2674, 6, 4215, 4694, 2792, 5557, 6304, 6100, 9345, 3743, 14666, 30530, 317, 428, 102, 3207, 4135, 1770, 1908, 2791, 2577, 8276, 4533, 11755, 5270, 13931, 14396, 14354, 27263)) LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | 439 | Using where | |
SIMPLE | xf_user_profile_Profile_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user.user_id | 1 |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
-- XFDB=noForceAllWrite UPDATE xf_session_activity SET ip = ?, controller_name = ?, controller_action = ?, view_state = ?, params = ?, view_date = ?, robot_key = ? WHERE user_id = ? AND unique_key = ?
SELECT `xf_cv6_dice`.* FROM `xf_cv6_dice` WHERE (`xf_cv6_dice`.`active` = '1') ORDER BY `xf_cv6_dice`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_cv6_dice | ALL | 6 | Using where; Using filesort |
SELECT `xf_tagess_synonym`.*, `xf_tag_Tag_1`.* FROM `xf_tagess_synonym` LEFT JOIN `xf_tag` AS `xf_tag_Tag_1` ON (`xf_tag_Tag_1`.`tag_id` = `xf_tagess_synonym`.`tag_id`) WHERE (`xf_tagess_synonym`.`parent_tag_id` = 183)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tagess_synonym | ref | parent_tag_id | parent_tag_id | 4 | const | 1 | Using index |
SIMPLE | xf_tag_Tag_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_tagess_synonym.tag_id | 1 |
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.* FROM `xf_node` LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1') WHERE (`xf_node`.`node_id` IN (184))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_page`.*, `xf_node_Node_1`.* FROM `xf_page` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_page`.`node_id`) WHERE (`xf_page`.`node_id` IN (184))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
bytes_sent | 11377 |
bytes_received | 103661 |
packets_sent | 118 |
packets_received | 1123 |
protocol_overhead_in | 4492 |
protocol_overhead_out | 472 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 306 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 164 |
bytes_received_prepare_response_packet | 40430 |
bytes_received_change_user_packet | 62270 |
packets_sent_command | 58 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 34 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 21 |
packets_received_prepare_response | 543 |
packets_received_change_user | 504 |
result_set_queries | 18 |
non_result_set_queries | 3 |
no_index_used | 1 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 18 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 18 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 486 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 486 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 486 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 178 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 467 |
proto_binary_fetched_int24 | 126 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1203 |
proto_binary_fetched_decimal | 471 |
proto_binary_fetched_float | 20 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 502 |
proto_binary_fetched_blob | 255 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 19 |
com_stmt_execute | 19 |
com_stmt_send_long_data | 0 |
com_stmt_close | 18 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 58203 |
gets | 7 |
gets.time | 0.006570659 |
sets | 0 |
sets.time | 0 |
deletes | 0 |
deletes.time | 0 |
flushes | 0 |
flushes.time | 0 |
bytes_sent | 0 |
bytes_received | 145899 |
time_compression | 0 |
time_decompression | 0.002595618 |
time_encoding | 0 |
time_decoding | 0.002653498 |