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` = 'character') 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 | 802 | 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, 4739, 2244, 9059, 56, 7293, 666, 21206, 5236, 5629, 1158, 62, 9839, 890, 1574, 1592, 4058, 4339, 16473, 10146, 11309, 22999, 3295, 124, 2217, 8665, 1313, 162, 7957, 1842, 6789, 4213, 1034, 8558, 9427, 5642, 4657, 8729, 16961, 23090, 6474, 4637, 6534, 10132, 10236, 1, 6561, 5808, 7099, 8476, 30698, 6918, 5047, 3652, 7977, 12728, 12807, 687, 2911, 4365, 461, 7067, 9345, 2780, 15593, 24398, 878, 5363, 16570, 7682, 3250, 1660, 5208, 9337, 4533, 79, 10100, 14811, 25442, 27255, 85, 596, 13573, 19375, 28815, 13271, 7839, 8469, 3055, 5714, 2799, 11560, 5956, 9838, 13420, 781, 297, 1130, 4197, 2400, 2539, 9483, 13328, 22300, 1103, 3590, 9990, 104, 30455, 32034, 1206, 7896, 8115, 8136, 74, 2853, 3969, 119, 2897, 5537, 5387, 7537, 7581, 7463, 9616, 10143, 10576, 9641, 1072, 2063, 13778, 14598, 15395, 15661, 16638, 20474, 24979, 19207, 28080, 33923, 36566, 77, 3207, 3006, 369, 2921, 4038, 6477, 3632, 7510, 7122, 8268, 8997, 10060, 8979, 10621, 8985, 11368, 12721, 13593, 14368, 12198, 12180, 16657, 17392, 20051, 10333, 28189, 20970, 28127, 36092, 107, 3077, 4155, 6234, 2157, 6515, 7517, 7270, 8272, 368, 9700, 10077, 10145, 10788, 11976, 11277, 877, 14741, 16069, 16794, 22964, 25189, 24179, 22164, 30797, 34482, 239, 3729, 475, 6201, 6618, 722, 7376, 782, 9206, 7245, 2012, 12287, 13827, 14756, 16088, 16799, 23531, 27243, 28332, 30964, 35277, 12011, 367, 3767, 2124, 3618, 657, 6589, 842, 4775, 9266, 6853, 332, 10229, 5492, 9450, 10639, 13906, 14779, 15617, 16125, 17211, 17227, 19079, 27275, 28553, 31031, 26178, 38992, 3841, 429, 3562, 4663, 6626, 435, 8005, 8274, 8742, 9449, 10787, 12894, 13953, 15638, 16159, 17260, 23800, 21108, 12930, 35305, 32211, 3876, 73, 534, 5398, 1834, 2560, 879, 4560, 530, 8054, 9353, 9249, 3362, 10684, 11757, 15383, 13087, 14095, 12839, 4974, 16210, 17366, 25626, 27401, 28587, 31389, 27444, 700, 4005, 1315, 5130, 4626, 3784, 3854, 420, 7157, 5671, 7901, 8356, 9329, 9807, 10417, 1925, 11782, 12250, 14185, 14875, 15431, 16234, 17478, 23805, 25659, 27421, 28917, 31740, 35186, 39887, 707, 4233, 4717, 4315, 5035, 3100, 6239, 7165, 1752, 7582, 9467, 8448, 1877, 11159, 11786, 8405, 13280, 14233, 14948, 15384, 16366, 17531, 22139, 23839, 27099, 22551, 27263, 33887, 41009, 1784, 4243, 4945, 1025, 5340, 1987, 6447, 7240, 7464, 5376, 8843, 9293, 9902, 3743, 10440, 9752, 11819, 13306, 8064, 15733, 16371, 16546, 26118, 20540, 29691, 36085, 35774, 1788, 4362, 1318, 11300, 4659, 577, 5988, 2595, 6757, 6403, 7734, 6642, 9392, 6566, 3229, 12469, 4257, 11800, 12280, 12715, 14973, 16892, 16385, 17828, 24012, 20844, 27671, 10108, 36109, 15225, 2285, 4389, 372, 5624, 6030, 6106, 7757, 8111, 8454, 800, 9572, 9924, 10124, 10514, 6439, 11858, 6209, 13065, 9929, 15130, 15768, 16369, 18976, 21056, 26119, 225, 29763, 32903, 41214, 2325, 4429, 6053, 6829, 1864, 5270, 5672, 8876, 9504, 9881, 10140, 10543, 11871, 12592, 14371, 12557, 13409, 16439, 19081, 24380, 24373, 22131, 30258, 36289, 34140, 2644, 5262, 5785, 6125, 2361, 4162, 7302, 7763, 8532, 510, 5389, 5392, 10545, 11139, 11513, 5167, 13617, 14369, 15112, 15823, 16451, 13579, 22575, 26647, 16602, 30371, 33038, 31988, 32623, 2643, 4668, 2749, 2114, 5939, 6047, 7385, 2392, 8137, 8529, 8776, 18, 5815, 8728, 2356, 11490, 13673, 14498, 12660, 14545, 15777, 19970, 21515, 25276, 27934, 31036, 21873, 2675, 2161, 5352, 2530, 6545, 7232, 8965, 806, 8518, 10562, 5174, 11654, 12675, 13646, 12390, 15372, 16640, 20092, 24837, 25830, 25107, 30534, 33807, 14899)) LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | 544 | 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 |
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` = 12)
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 | 12650 |
bytes_received | 96670 |
packets_sent | 112 |
packets_received | 1216 |
protocol_overhead_in | 4864 |
protocol_overhead_out | 448 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 297 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 112 |
bytes_received_prepare_response_packet | 40187 |
bytes_received_change_user_packet | 55599 |
packets_sent_command | 55 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 33 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 20 |
packets_received_prepare_response | 534 |
packets_received_change_user | 609 |
result_set_queries | 18 |
non_result_set_queries | 2 |
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 | 17 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 591 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 591 |
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 | 591 |
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 | 182 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 467 |
proto_binary_fetched_int24 | 126 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1306 |
proto_binary_fetched_decimal | 576 |
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 | 253 |
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 | 18 |
com_stmt_execute | 18 |
com_stmt_send_long_data | 0 |
com_stmt_close | 17 |
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 | 50910 |
gets | 7 |
gets.time | 0.006284548 |
sets | 0 |
sets.time | 0 |
deletes | 0 |
deletes.time | 0 |
flushes | 0 |
flushes.time | 0 |
bytes_sent | 0 |
bytes_received | 145256 |
time_compression | 0 |
time_decompression | 0.002655022 |
time_encoding | 0 |
time_decoding | 0.00257575 |