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` = 'jedi') 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 | 1451 | 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, 12287, 937, 30966, 22999, 2217, 17824, 890, 21108, 4739, 4974, 23090, 3985, 9931, 877, 4339, 11753, 1, 31653, 12771, 23378, 23839, 435, 124, 19060, 29323, 21741, 287, 39322, 30662, 12557, 3743, 666, 22300, 5398, 8136, 9, 10132, 903, 56, 14298, 19375, 16238, 6290, 13049, 645, 16668, 28643, 85, 7053, 37300, 19842, 326, 27021, 4657, 3632, 1696, 27943, 27739, 125, 78, 376, 1878, 2911, 71, 4197, 34140, 8170, 21214, 27228, 18088, 27800, 74, 7702, 6439, 4637, 15059, 2244, 8115, 29839, 18532, 27097, 29066, 3976, 10427, 30612, 33887, 3435, 1103, 18034, 15470, 36972, 12427, 2756, 7067, 24398, 21206, 3562, 9486, 17734, 24717, 9838, 8161, 18736, 18983, 16467, 19520, 6335, 9432, 16880, 16365, 25868, 227, 7099, 1886, 14308, 32157, 18136, 4512, 12834, 11444, 16112, 24590, 28538, 30968, 35832, 32635, 906, 1318, 4962, 15336, 18077, 29691, 34998, 4606, 8216, 8326, 11447, 12777, 21570, 18905, 27082, 32832, 40845, 7240, 10320, 7376, 14477, 19882, 17408, 8979, 7154, 33106, 35257, 10393, 3737, 24934, 33434, 6667, 7293, 9843, 26127, 6477, 360, 16103, 13846, 21438, 27109, 30818, 7517, 10495, 1908, 19155, 25657, 30225, 32616, 692, 9580, 79, 30763, 26910, 5158, 12900, 16921, 24012, 17909, 1772, 359, 11810, 12733, 13721, 17747, 22324, 27366, 28155, 127, 1917, 5673, 8178, 15065, 5174, 22467, 13614, 24837, 25276, 30871, 28238, 3218, 39537, 11, 5674, 10905, 12099, 13271, 17946, 21817, 1345, 166, 908, 2409, 4433, 5066, 3362, 9154, 10059, 10592, 12142, 5732, 14246, 16284, 19078, 16914, 22964, 22633, 20540, 26848, 25142, 24737, 30371, 29269, 30106, 26874, 34483, 36756, 39564, 26692, 1289, 2644, 33, 6094, 2844, 8434, 10023, 10661, 11957, 12743, 15130, 16963, 19081, 21202, 21568, 25913, 9078, 27576, 28049, 29628, 24280, 17098, 35761, 324, 914, 2675, 6080, 7134, 12660, 4219, 10989, 475, 13292, 14287, 15964, 18142, 21442, 22817, 21873, 9501, 3202, 29476, 26608, 32180, 34430, 36805, 42664, 107, 7757, 9278, 10240, 12221, 12873, 13295, 14349, 16063, 17200, 18183, 21314, 23634, 18254, 16428, 27637, 28606, 2184, 30964, 32890, 30299, 37619, 40540, 14062, 348, 1034, 3248, 5228, 6358, 4445, 7805, 8472, 9348, 6044, 11280, 10558, 13521, 11560, 11379, 16211, 18209, 21525, 23153, 24194, 16982, 27024, 27749, 12086, 29637, 13409, 30455, 32394, 26353, 34620, 33136, 35246, 34518, 29049, 1660, 3441, 5340, 6448, 7176, 7504, 5946, 10337, 13502, 9415, 12655, 12719, 17336, 18434, 3811, 23770, 22401, 27756, 20944, 26097, 30633, 31007, 32145, 12011, 36085, 37951, 42712, 522, 1807, 3716, 5464, 8698, 9059, 12912, 13611, 16180, 17122, 18130, 7122, 24848, 2356, 30534, 28264, 36014, 31346, 41624, 35655, 3996, 1025, 5513, 6347, 7241, 11501, 12069, 12957, 13584, 14508, 13604, 5270, 19926, 17433, 24014, 25083, 24675, 17592, 31162, 32434, 32867, 36270, 37405, 28515, 297, 5430, 8005, 8758, 11624, 5363, 13692, 14517, 15475, 13914, 1707, 18547, 19873, 21527, 23209, 12317, 25085, 20293, 19966, 29166, 29782, 25482, 31169, 35376, 35546, 30870, 40596, 38, 6, 2035, 5485, 2107, 9262, 10463, 12147, 13074, 15487, 15593, 13343, 18601, 22027, 26263, 27148, 23561, 29921, 21018, 6918, 33907, 27444, 36073, 35133, 383, 1299, 3773, 5652, 6626, 7806, 8889, 6853, 11770, 13053, 13931, 14615, 16459, 17553, 18624, 21638, 20572, 11378, 21359, 27968, 29960, 29133, 22175, 26338, 36599, 35880, 37957, 652, 10762, 5659, 929, 7518, 7682, 10541, 3126, 12123, 13087, 14838, 11135, 16591, 3244, 18435, 13668, 21275, 4223, 25320, 26339, 21540, 30256, 11309, 26677, 38819, 40970, 700, 2017, 289, 5671, 7519, 7783, 7521, 9991, 10684, 11832, 12626, 14910, 12807, 18746, 4058, 21516, 21412, 24099, 761, 24192, 29320, 26471, 27998, 32622, 34282, 35564, 35410, 34138, 18555, 119, 5784, 6863, 7039, 272, 9969, 10944, 3384, 8518, 15638, 21014, 17116, 24486, 24088, 25968, 27566, 1029, 31591, 2630, 32623, 781, 13778, 42336, 37, 3006, 5873, 2048, 7611, 3250, 11934, 12843, 13781, 15677, 21020, 27417, 28121, 29362, 24370, 32692, 36969, 32303, 35, 958, 4414, 4194, 7080, 9173, 68, 14256, 15090, 15370, 8380, 19069, 13019, 22639, 18827, 11300, 24221, 26321, 21601, 30873, 31646, 15832, 21138, 32521, 39495, 42410)) LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | range | PRIMARY | PRIMARY | 4 | 622 | 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` = 23)
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 | 14267 |
bytes_received | 106426 |
packets_sent | 118 |
packets_received | 1306 |
protocol_overhead_in | 5224 |
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 | 65035 |
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 | 687 |
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 | 669 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 669 |
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 | 669 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 2 |
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 | 181 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 468 |
proto_binary_fetched_int24 | 126 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1388 |
proto_binary_fetched_decimal | 654 |
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 | 249 |
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 | 59876 |
gets | 7 |
gets.time | 0.005669246 |
sets | 0 |
sets.time | 0 |
deletes | 0 |
deletes.time | 0 |
flushes | 0 |
flushes.time | 0 |
bytes_sent | 0 |
bytes_received | 145276 |
time_compression | 0 |
time_decompression | 0.002572486 |
time_encoding | 0 |
time_decoding | 0.002247491 |