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', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 36 | Using where |
SELECT `xf_dbtech_mail_digest`.* FROM `xf_dbtech_mail_digest` LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_dbtech_mail_digest | ALL | 1 |
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_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.* FROM `xf_thread` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_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_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` = '470') LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 470) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 40) AND (`xf_post`.`position` < 60)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | 19 | Using where; Using filesort | |
| SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_post.user_id | 1 | |
| SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_user_User_1.user_id | 1 | |
| SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_user_User_1.user_id | 1 | |
| SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_user_User_1.user_id | 1 | |
| SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | sikhphi_xf_feb_4_2019.xf_user_User_1.user_id,func | 1 |
SELECT alert_id
FROM xf_user_alert
WHERE alerted_user_id = ?
AND view_date = 0
AND event_date < ?
AND content_type IN ('post')
AND content_id IN (2661, 2728, 2909, 6052, 9927, 10228, 19234, 19348, 19352, 19358, 19359, 20014, 20017, 20018, 20019, 20028, 20030, 20035, 20037, 20038)| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_user_alert | range | alertedUserId_eventDate,contentType_contentId,viewDate_eventDate | alertedUserId_eventDate | 8 | 1 | Using where |
INSERT INTO xf_thread_view (thread_id, total) VALUES (? , 1) ON DUPLICATE KEY UPDATE total = total + 1
SELECT
post_main.post_id,
(
SELECT post_id
FROM xf_post AS post_tmp
WHERE post_tmp.user_id = post_main.user_id
AND post_tmp.position < post_main.position
AND post_tmp.position < post_main.position
AND post_tmp.thread_id = 470
AND post_tmp.message_state IN ('visible')
ORDER BY post_tmp.post_id ASC
LIMIT 1
) AS previous_post_id
FROM
(
SELECT DISTINCT user_id, post_id, position
FROM xf_post AS post
WHERE post.thread_id = 470
AND post.message_state IN ('visible')
AND post.position >= 40
AND post.position < 60
) AS post_main| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | <derived3> | ALL | 20 | |||||
| DERIVED | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | 19 | Using where | |
| DEPENDENT SUBQUERY | post_tmp | ref | thread_id_post_date,thread_id_position,user_id | user_id | 4 | post_main.user_id | 27 | Using where; Using filesort |
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)
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 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_andy_featured_posts`.* FROM `xf_andy_featured_posts`
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_andy_featured_posts | index | PRIMARY | 4 | 2 | Using index |
SELECT `xf_post`.* FROM `xf_post` WHERE (`xf_post`.`post_id` = 189116) LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.* FROM `xf_thread` LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) WHERE (`xf_thread`.`thread_id` = 41316) LIMIT 1
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_forum_Forum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_node_Node_2 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.* FROM `xf_thread` FORCE INDEX (`last_post_date`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1544141519) ORDER BY `xf_thread`.`last_post_date` DESC LIMIT 18
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | 419 | Using where | |
| SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_thread.node_id | 1 | Using where |
| SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_forum_Forum_1.node_id | 1 | |
| SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_thread.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sikhphi_xf_feb_4_2019.xf_node_Node_2.node_id | 1 | |
| SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_thread.last_post_user_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 (515))
| 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_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`.`lft` > 509 AND `xf_node`.`rgt` < 892)) AND (`xf_node`.`display_in_list` = 1) ORDER BY `xf_node`.`lft` ASC
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_node | ref | display_in_list,lft | display_in_list | 1 | const | 193 | Using where |
| SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sikhphi_xf_feb_4_2019.xf_node.node_id | 1 |
SELECT `xf_category`.*, `xf_node_Node_1`.* FROM `xf_category` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`) WHERE (`xf_category`.`node_id` IN (515))
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_category | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.* FROM `xf_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`) WHERE (`xf_forum`.`node_id` IN (665, 354, 355, 358, 359, 518, 519, 520, 521, 522, 523, 524, 525, 360, 526, 527, 528, 529, 530, 531, 532, 533, 361, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 362, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 363, 560, 561, 562, 563, 364, 565, 365, 566, 567, 568, 366, 569, 570, 571, 572, 573, 574, 367, 575, 576, 577, 370, 578, 579, 580, 581, 371, 582, 583, 584, 585, 372, 373, 374, 586, 587, 375, 588, 591, 592, 593, 594, 595, 596, 597, 376, 598, 599, 600, 601, 602, 603, 604, 377, 605, 606, 607, 378, 609, 608, 610, 611, 612, 613, 614, 615, 379, 616, 618, 380, 619, 617, 381, 620, 621, 622, 623, 624, 625, 626, 382, 627, 628, 383, 629, 630, 384, 631, 632, 633, 385, 634, 635, 636, 386, 637, 638, 639, 640, 641, 387, 642, 643, 644, 645, 646, 647, 388, 649, 648, 650, 651, 652, 653, 389, 654, 655, 390, 656, 657, 391, 658, 659, 392, 393, 394, 395, 396, 397, 398, 399, 660, 400, 661, 402, 403, 485))
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|
| SIMPLE | xf_forum | ALL | PRIMARY | 421 | Using where | |||
| SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_forum.node_id | 1 | |
| SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_forum.last_post_user_id | 1 | |
| SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | sikhphi_xf_feb_4_2019.xf_forum.last_thread_id | 1 |
| bytes_sent | 20683 |
| bytes_received | 1662145 |
| packets_sent | 220 |
| packets_received | 2348 |
| protocol_overhead_in | 9392 |
| protocol_overhead_out | 880 |
| bytes_received_ok_packet | 0 |
| bytes_received_eof_packet | 0 |
| bytes_received_rset_header_packet | 549 |
| bytes_received_rset_field_meta_packet | 0 |
| bytes_received_rset_row_packet | 214 |
| bytes_received_prepare_response_packet | 152367 |
| bytes_received_change_user_packet | 1508176 |
| packets_sent_command | 109 |
| packets_received_ok | 0 |
| packets_received_eof | 0 |
| packets_received_rset_header | 61 |
| packets_received_rset_field_meta | 0 |
| packets_received_rset_row | 38 |
| packets_received_prepare_response | 1656 |
| packets_received_change_user | 555 |
| result_set_queries | 34 |
| non_result_set_queries | 4 |
| no_index_used | 4 |
| bad_index_used | 0 |
| slow_queries | 0 |
| buffered_sets | 0 |
| unbuffered_sets | 0 |
| ps_buffered_sets | 34 |
| ps_unbuffered_sets | 0 |
| flushed_normal_sets | 0 |
| flushed_ps_sets | 0 |
| ps_prepared_never_executed | 0 |
| ps_prepared_once_executed | 35 |
| rows_fetched_from_server_normal | 0 |
| rows_fetched_from_server_ps | 521 |
| rows_buffered_from_client_normal | 0 |
| rows_buffered_from_client_ps | 521 |
| 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 | 521 |
| 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 | 15590 |
| proto_binary_fetched_tinyint | 0 |
| proto_binary_fetched_short | 2852 |
| proto_binary_fetched_int24 | 697 |
| proto_binary_fetched_int | 0 |
| proto_binary_fetched_bigint | 7944 |
| proto_binary_fetched_decimal | 82 |
| proto_binary_fetched_float | 0 |
| 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 | 4631 |
| proto_binary_fetched_blob | 1997 |
| 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 | 36 |
| com_stmt_execute | 36 |
| com_stmt_send_long_data | 0 |
| com_stmt_close | 35 |
| 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 | 1493080 |