SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 39 | Using where |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('dbtCreditsCurrencies')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_seo_package_redirect`.* FROM `xf_seo_package_redirect` WHERE (`xf_seo_package_redirect`.`active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_seo_package_redirect | ALL | 1 | Using where |
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`.* FROM `xf_tag` WHERE (`xf_tag`.`tag_url` = 'pokemon') 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 |
SELECT `xf_tag_result_cache`.* FROM `xf_tag_result_cache` WHERE (`xf_tag_result_cache`.`tag_id` = 11 AND `xf_tag_result_cache`.`user_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id | tag_id_user_id | 8 | const,const | 1 |
SELECT content_type, content_id FROM xf_tag_content WHERE tag_id = ? AND visible = 1 ORDER BY content_date DESC LIMIT 200
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 | 196 | Using where |
SELECT `xf_thread`.*, `xf_seo_package_metadata_SEOPackageMetadata_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_post_FirstPost_5`.*, `xf_permission_cache_content_Permissions_6`.* FROM `xf_thread` LEFT JOIN `xf_seo_package_metadata` AS `xf_seo_package_metadata_SEOPackageMetadata_1` ON (`xf_seo_package_metadata_SEOPackageMetadata_1`.`content_type` = 'thread' AND `xf_seo_package_metadata_SEOPackageMetadata_1`.`content_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_5` ON (`xf_post_FirstPost_5`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` IN (24268, 24185, 24024, 24016, 24006, 24005, 23961, 23908, 23816, 23707, 23692, 23678, 23640, 23638, 23628, 23568, 23465, 23464, 23446, 23445, 23412, 23229, 23172, 23152, 23070, 23068, 23027, 23008, 23005, 23004, 22908, 22875, 22838, 22805, 22797, 22783, 22761, 22759, 22756, 22751, 22747, 22740, 22739, 22727, 22721, 22714, 22704, 22694, 22686, 22675, 22663, 22644, 22639, 22617, 22606, 22579, 22546, 22523, 22498, 22434, 22426, 22423, 22354, 22352, 22297, 22239, 22222, 22203, 22184, 22179, 22158, 22136, 22110, 22097, 22032, 22013, 21996, 21900, 21858, 21847, 21809, 21802, 21766, 21753, 21719, 21706, 21693, 21671, 21637, 21636, 21595, 21594, 21586, 21541, 21533, 21532, 21531, 21530, 21485, 21429, 21412, 21393, 21362, 21323, 21309, 21291, 21252, 21249, 21218, 21183, 21167, 21145, 21105, 21094, 21067, 21038, 21035, 20945, 20922, 20905, 20899, 20854, 20848, 20818, 20778, 20651, 20597, 20376, 20364, 20357, 20352, 20291, 20078, 20077, 20076, 20047, 19940, 19907, 19778, 19743, 19715, 19677, 19667, 19557, 19365, 19354, 19245, 19230, 19187, 19177, 19037, 19033, 18926, 18754, 18751, 18705, 18658, 18628, 18623, 18615, 18594, 18500, 18411, 18218, 18214, 18139, 18038, 17991, 17734, 17668, 17620, 17554, 17552, 17511, 17326, 17270, 17116, 17074, 17027, 17022, 17001, 16960, 16936, 16825, 16789, 16781, 16673))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | 187 | Using where | |
SIMPLE | xf_seo_package_metadata_SEOPackageMetadata_1 | eq_ref | PRIMARY | PRIMARY | 156 | const,u769187343_pokemon_xf_new.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_5 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,u769187343_pokemon_xf_new.xf_node_Node_3.node_id | 1 | Using where |
BEGIN
UPDATE `xf_tag_result_cache` SET `expiry_date` = ? WHERE `result_cache_id` = 1312
COMMIT
SELECT `xf_seo_package_redirect`.* FROM `xf_seo_package_redirect` WHERE (`xf_seo_package_redirect`.`active` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_seo_package_redirect | ALL | 1 | Using where |
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 SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total, SUM(IF(user_id > 0, 1, 0)) AS members, SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests FROM xf_session_activity WHERE view_date >= ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | 1565 | Using where |
SELECT `xf_session_activity`.*, `xf_user_User_1`.* FROM `xf_session_activity` INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`) WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1714808189) ORDER BY `xf_session_activity`.`view_date` DESC LIMIT 50
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | PRIMARY | 4 | 11 | Using where; Using filesort | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_session_activity.user_id | 1 | Using where |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('forumStatistics')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.* FROM `xf_user` INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`) INNER 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_profile_Profile_1`.`dob_day` = 4) AND (`xf_user_profile_Profile_1`.`dob_month` = 5) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1683275789) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') ORDER BY `xf_user`.`username` ASC LIMIT 12
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile_Profile_1 | ref | PRIMARY,dob | dob | 2 | const,const | 183 | Using temporary; Using filesort |
SIMPLE | xf_user | eq_ref|filter | PRIMARY,user_state,last_activity | user_state|last_activity | 5|4 | const,u769187343_pokemon_xf_new.xf_user_profile_Profile_1.user_id | 1 (1%) | Using index condition; Using where; Using rowid filter |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_user_profile_Profile_1.user_id | 1 | Using where |
SELECT `xf_thread`.*, `xf_seo_package_metadata_SEOPackageMetadata_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.* FROM `xf_thread` LEFT JOIN `xf_seo_package_metadata` AS `xf_seo_package_metadata_SEOPackageMetadata_1` ON (`xf_seo_package_metadata_SEOPackageMetadata_1`.`content_type` = 'thread' AND `xf_seo_package_metadata_SEOPackageMetadata_1`.`content_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`) WHERE (`xf_thread`.`home_sticky` = 1) AND (`xf_thread`.`node_id` IN ('17', '16', '29')) ORDER BY `xf_thread`.`post_date` DESC LIMIT 4
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | index | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | post_date | 4 | 38 | Using where | |
SIMPLE | xf_seo_package_metadata_SEOPackageMetadata_1 | eq_ref | PRIMARY | PRIMARY | 156 | const,u769187343_pokemon_xf_new.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.user_id | 1 |
SELECT `xf_thread`.*, `xf_seo_package_metadata_SEOPackageMetadata_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.* FROM `xf_thread` LEFT JOIN `xf_seo_package_metadata` AS `xf_seo_package_metadata_SEOPackageMetadata_1` ON (`xf_seo_package_metadata_SEOPackageMetadata_1`.`content_type` = 'thread' AND `xf_seo_package_metadata_SEOPackageMetadata_1`.`content_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`) WHERE (`xf_thread`.`node_id` IN ('17', '16', '29')) ORDER BY `xf_thread`.`post_date` DESC LIMIT 4
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | index | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | post_date | 4 | 38 | Using where | |
SIMPLE | xf_seo_package_metadata_SEOPackageMetadata_1 | eq_ref | PRIMARY | PRIMARY | 156 | const,u769187343_pokemon_xf_new.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.user_id | 1 |
SELECT `xf_thread`.*, `xf_seo_package_metadata_SEOPackageMetadata_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.* FROM `xf_thread` LEFT JOIN `xf_seo_package_metadata` AS `xf_seo_package_metadata_SEOPackageMetadata_1` ON (`xf_seo_package_metadata_SEOPackageMetadata_1`.`content_type` = 'thread' AND `xf_seo_package_metadata_SEOPackageMetadata_1`.`content_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`) WHERE (`xf_thread`.`node_id` = '121') ORDER BY `xf_thread`.`shop_creation` DESC LIMIT 7
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | node_id_last_post_date | 4 | const | 5 | Using where; Using filesort |
SIMPLE | xf_seo_package_metadata_SEOPackageMetadata_1 | eq_ref | PRIMARY | PRIMARY | 156 | const,u769187343_pokemon_xf_new.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.user_id | 1 |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`view_date` >= 1714808189) AND (`xf_session_activity`.`user_id` = 38051) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_xc_feedback_user`.* FROM `xf_xc_feedback_user` WHERE (`xf_xc_feedback_user`.`user_id` = 38051) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('xc_none_rating_count')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`view_date` >= 1714808189) AND (`xf_session_activity`.`user_id` = 1561) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_xc_feedback_user`.* FROM `xf_xc_feedback_user` WHERE (`xf_xc_feedback_user`.`user_id` = 1561) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`view_date` >= 1714808189) AND (`xf_session_activity`.`user_id` = 1355) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_xc_feedback_user`.* FROM `xf_xc_feedback_user` WHERE (`xf_xc_feedback_user`.`user_id` = 1355) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xc_feedback_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`view_date` >= 1714808189) AND (`xf_session_activity`.`user_id` = 1) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | ref | PRIMARY,view_date | PRIMARY | 4 | const | 1 | Using where |
SELECT `xf_xc_feedback_user`.* FROM `xf_xc_feedback_user` WHERE (`xf_xc_feedback_user`.`user_id` = 1) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_xc_feedback_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_session_activity`.* FROM `xf_session_activity` WHERE (`xf_session_activity`.`view_date` >= 1714808189) AND (`xf_session_activity`.`user_id` = 62) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_xc_feedback_user`.* FROM `xf_xc_feedback_user` WHERE (`xf_xc_feedback_user`.`user_id` = 62) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
bytes_sent | 24504 |
bytes_received | 1805875 |
packets_sent | 356 |
packets_received | 3238 |
protocol_overhead_in | 12952 |
protocol_overhead_out | 1424 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1116 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 428 |
bytes_received_prepare_response_packet | 208884 |
bytes_received_change_user_packet | 1594127 |
packets_sent_command | 177 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 124 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 62 |
packets_received_prepare_response | 2452 |
packets_received_change_user | 540 |
result_set_queries | 56 |
non_result_set_queries | 6 |
no_index_used | 2 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 56 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 57 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 484 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 484 |
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 | 484 |
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 | 3851 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 3537 |
proto_binary_fetched_int24 | 1564 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 16937 |
proto_binary_fetched_decimal | 49 |
proto_binary_fetched_float | 396 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 2 |
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 | 6539 |
proto_binary_fetched_blob | 3230 |
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 | 4 |
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 | 58 |
com_stmt_execute | 58 |
com_stmt_send_long_data | 0 |
com_stmt_close | 57 |
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 | 1574879 |