SELECT  u1.`surname`, u1.`firstname`, u1.`patronymic`, u1.`gender`, u1.`birthday`, u1.`user_gto_id`, u1.`region`, u1.`division`, u1.`locality`, u1.`street`, u1.`house`, u1.`block`, u1.`actual_region`, u1.`a
ctual_division`, u1.`actual_locality`, u1.`actual_street`, u1.`actual_house`, u1.`actual_block`, u1.`education`, u1.`employment`,  s1.`cert_seria`, s1.`cert_number`, s1.`user_id`, s1.`stage_id`, s1.`year`,
s1.`sign`, s1.`year`, s1.`center_id`, s1.`region_id`, s1.`handed`, s1.`status`, s1.`trials` FROM `signs_archive` s1 INNER JOIN `users` u1  ON s1.`user_id` = u1.`oId`  WHERE  ( s1.`handed` >= '2019-10-01 00:
00:00' and s1.`handed` <= '2019-12-31 23:59:59' and s1.`sign` = 1 );
SET timestamp=1579690235;
# Log_slow_rate_type: session  Log_slow_rate_limit: 1000
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0
# QC_Hit: No  Full_scan: Yes  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# Bytes_sent: 171182989  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# Query_time: 20.276120  Lock_time: 0.000037  Rows_sent: 170973  Rows_examined: 3592985  Rows_affected: 0
# Schema: gto  Last_errno: 0  Killed: 0
# User@Host: gto[gto] @ s.service.gto.ru [185.194.32.167]  Id: 5875852
# Time: 200122 13:50:35
SELECT  u1.`surname`, u1.`firstname`, u1.`patronymic`, u1.`gender`, u1.`birthday`, u1.`user_gto_id`, u1.`region`, u1.`division`, u1.`locality`, u1.`street`, u1.`house`, u1.`block`, u1.`actual_region`, u1.`a
ctual_division`, u1.`actual_locality`, u1.`actual_street`, u1.`actual_house`, u1.`actual_block`, u1.`education`, u1.`employment`,  s1.`cert_seria`, s1.`cert_number`, s1.`user_id`, s1.`stage_id`, s1.`year`,
s1.`sign`, s1.`year`, s1.`center_id`, s1.`region_id`, s1.`handed`, s1.`status`, s1.`trials` FROM `signs_archive` s1 INNER JOIN `users` u1  ON s1.`user_id` = u1.`oId`  WHERE  ( s1.`handed` >= '2019-10-01 00:
00:00' and s1.`handed` <= '2019-12-31 23:59:59' and s1.`sign` = 1 );
SET timestamp=1579690157;
# Log_slow_rate_type: session  Log_slow_rate_limit: 1000
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0
# QC_Hit: No  Full_scan: Yes  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# Bytes_sent: 171182989  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# Query_time: 13.261713  Lock_time: 0.000083  Rows_sent: 170973  Rows_examined: 3592985  Rows_affected: 0
# Schema: gto  Last_errno: 0  Killed: 0
# User@Host: gto[gto] @ s.service.gto.ru [185.194.32.167]  Id: 5875429
# Time: 200122 13:49:17
SELECT  u1.`surname`, u1.`firstname`, u1.`patronymic`, u1.`gender`, u1.`birthday`, u1.`user_gto_id`, u1.`region`, u1.`division`, u1.`locality`, u1.`street`, u1.`house`, u1.`block`, u1.`actual_region`, u1.`a
ctual_division`, u1.`actual_locality`, u1.`actual_street`, u1.`actual_house`, u1.`actual_block`, u1.`education`, u1.`employment`,  s1.`cert_seria`, s1.`cert_number`, s1.`user_id`, s1.`stage_id`, s1.`year`,
s1.`sign`, s1.`year`, s1.`center_id`, s1.`region_id`, s1.`handed`, s1.`status`, s1.`trials` FROM `signs_archive` s1 INNER JOIN `users` u1  ON s1.`user_id` = u1.`oId`  WHERE  ( s1.`handed` >= '2019-10-01 00:
00:00' and s1.`handed` <= '2019-12-31 23:59:59' and s1.`sign` = 1 );
SET timestamp=1579690032;
# Log_slow_rate_type: session  Log_slow_rate_limit: 1000
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0
# QC_Hit: No  Full_scan: Yes  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# Bytes_sent: 171182989  Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0
# Query_time: 14.432375  Lock_time: 0.000047  Rows_sent: 170973  Rows_examined: 3592985  Rows_affected: 0
# Schema: gto  Last_errno: 0  Killed: 0
# User@Host: gto[gto] @ s.service.gto.ru [185.194.32.167]  Id: 5874927
# Time: 200122 13:47:12