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` = 'dominion') 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 | 1325 | 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, 56, 12137, 359, 1685, 71, 1313, 1, 7053, 5675, 6335, 62, 16103, 17291, 937, 26042, 4775, 22950, 360, 12655, 13807, 4058, 11, 19826, 4365, 703, 3623, 14944, 7067, 4851, 4803, 102, 3126, 74, 15008, 4739, 22131, 4951, 2244, 12469, 2194, 2119, 5123, 12809, 4257, 420, 9811, 11339, 1318, 5732, 1103, 9752, 5735, 3969, 7571, 5793, 11309, 8529, 6151, 1574, 738, 79, 3632, 3430, 8136, 11560, 7122, 1772, 4653, 13871, 13593, 4974, 3289, 18, 4657, 9427, 37684, 8518, 1080, 1797, 1592, 11854, 8405, 4030, 12660, 909, 3280, 6830, 15716, 2655, 1937, 16914, 287, 16875, 2815, 13668, 73, 929, 1528, 3971, 2012, 6474, 20608, 1473, 26127, 2392, 25932, 68, 475, 774, 1745, 21568, 35025, 939, 7839, 15858, 5671, 8608, 1942, 26069, 17201, 12596, 4637, 7376, 4928, 15874, 5956, 14967, 24179, 18077, 348, 908, 12634, 1932, 429, 2134, 525, 4954, 15507, 5398, 7270, 41589, 107, 127, 1928, 938, 3699, 323, 8032, 10624, 14164, 27934, 4767, 3006, 21747, 890, 1842, 4824, 3409, 8077, 1077, 1879, 21758, 27475, 2186, 9281, 11285, 13681, 23752, 34583, 129, 3736, 5836, 12289, 5007, 10614, 1144, 1821, 2493, 2911, 6660, 9580, 2047, 22999, 1882, 9838, 692, 12410, 17909, 2120, 2048, 942, 9432, 1345, 22097, 26564, 17595, 5673, 4389, 4842, 8452, 18188, 35531, 792, 1700, 1917, 29303, 467, 958, 2205, 3077, 5220, 372, 26319, 6530, 10043, 9822, 15705, 1093, 15178, 4847, 10178, 12396, 603, 6852, 18490, 22415, 31979, 1423, 2600, 906, 5151, 6576, 6515, 4232, 12274, 14419, 13902, 15314, 20572, 24310, 16615, 37036, 225, 118, 999, 644, 5270, 2099, 5915, 12066, 12299, 14368, 12807, 13604, 14283, 17355, 23872, 30704, 879, 3985, 2617, 13873, 16714, 16995, 20550, 4932, 3737, 2140, 369, 1541, 5245, 1889, 2475, 8146, 11324, 13875, 13543, 15927, 15780, 27968, 31346, 618, 781, 3435, 4659, 10920, 5492, 2438, 11148, 13266, 12390, 16010, 16835, 19845, 15842, 29380, 34582, 358, 1034, 2301, 119, 1770, 3139, 7016, 3652, 2381, 12317, 14642, 900, 15960, 16847, 3, 2758, 1558, 4467, 6429, 1013, 8054, 12895, 14553, 5363, 26051, 399, 596, 1660, 356, 3718, 3083, 3295, 9483, 11370, 22631, 27952, 35312, 687, 2486, 1396, 8457, 12845, 10533, 14180, 12440, 19301, 6, 1211, 806, 751, 5939, 2476, 1453, 4339, 14005, 13612, 16108, 26020, 27444, 586, 1872, 10762, 4683, 2595, 15159, 1966, 3055, 8469, 11284, 6485, 15668, 10667, 21641, 471, 622, 1503, 3784, 842, 2530, 124, 78, 8178, 13046, 14633, 11420, 15483, 16833, 21138, 30554, 4, 1744, 666, 4362, 1696, 2560, 3124, 16473, 15703, 24221, 18610, 25755, 1795, 3707, 5082, 8558, 12930, 9894, 15531, 13822, 15181, 22069, 4763, 2549, 1707, 2507, 5925, 6106, 9486, 15831, 16149, 20490, 15031, 39421)) LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | 421 | 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` = 138)
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 | 11343 |
bytes_received | 116279 |
packets_sent | 118 |
packets_received | 1105 |
protocol_overhead_in | 4420 |
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 | 74888 |
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 | 486 |
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 | 468 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 468 |
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 | 468 |
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 | 177 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 466 |
proto_binary_fetched_int24 | 126 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1185 |
proto_binary_fetched_decimal | 453 |
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 | 257 |
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 | 70929 |
gets | 7 |
gets.time | 0.005664778 |
sets | 0 |
sets.time | 0 |
deletes | 0 |
deletes.time | 0 |
flushes | 0 |
flushes.time | 0 |
bytes_sent | 0 |
bytes_received | 145903 |
time_compression | 0 |
time_decompression | 0.002479268 |
time_encoding | 0 |
time_decoding | 0.002206572 |