为了能快速了解并处理您的问题,请提供以下基础信息:
相关截图(日志、错误):# Time: 2026-01-09T02:00:19.550020Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106608 # Query_time: 15.000581 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924019; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:00:25.835549Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106617 # Query_time: 6.000574 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924025; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:00:41.122473Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106618 # Query_time: 15.000631 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924041; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:00:44.413622Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106622 # Query_time: 3.000671 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924044; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(3)))v)/*'+(select(0)from(select(sleep(3)))v)+'"+(select(0)from(select(sleep(3)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:00:51.278233Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106629 # Query_time: 6.000504 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924051; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:01:16.567540Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106630 # Query_time: 25.000640 Lock_time: 0.000029 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924076; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(25)))v)/*'+(select(0)from(select(sleep(25)))v)+'"+(select(0)from(select(sleep(25)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%c%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:02:30.474705Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106759 # Query_time: 15.000553 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924150; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:02:37.049919Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106760 # Query_time: 6.000561 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924157; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:02:40.875752Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106761 # Query_time: 3.000620 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924160; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(3)))v)/*'+(select(0)from(select(sleep(3)))v)+'"+(select(0)from(select(sleep(3)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:02:56.158219Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106762 # Query_time: 15.000628 Lock_time: 0.000017 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924176; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:03:02.992561Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106765 # Query_time: 6.000665 Lock_time: 0.000016 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924182; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:03:28.271899Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106766 # Query_time: 25.000639 Lock_time: 0.000017 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924208; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point(0,(select(0)from(select(sleep(25)))v)/*'+(select(0)from(select(sleep(25)))v)+'"+(select(0)from(select(sleep(25)))v)+"*/),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:03:53.188185Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106798 # Query_time: 15.000535 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924233; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:04:08.467297Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106799 # Query_time: 15.000560 Lock_time: 0.000014 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924248; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:04:14.745775Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106804 # Query_time: 6.000533 Lock_time: 0.000013 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924254; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:04:18.024373Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106805 # Query_time: 3.000554 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924258; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(3)))v)/*'+(select(0)from(select(sleep(3)))v)+'"+(select(0)from(select(sleep(3)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:04:24.867579Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106821 # Query_time: 6.000631 Lock_time: 0.000030 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924264; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(6)))v)/*'+(select(0)from(select(sleep(6)))v)+'"+(select(0)from(select(sleep(6)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; # Time: 2026-01-09T02:04:50.154723Z # User@Host: aaaqqqwwcn[aaaqqqwwcn] @ localhost [127.0.0.1] Id: 106822 # Query_time: 25.000684 Lock_time: 0.000042 Rows_sent: 0 Rows_examined: 3 SET timestamp=1767924290; SELECT id,name,phone,longitude,latitude,business_start_time,business_end_time,status,round(st_distance_sphere(point((select(0)from(select(sleep(25)))v)/*'+(select(0)from(select(sleep(25)))v)+'"+(select(0)from(select(sleep(25)))v)+"*/,0),point(longitude, latitude))/1000,2) as distance,province_id,city_id,district_id,address,delivery_type,weekdays,license FROM `ls_shop` WHERE `del` = 0 AND FIND_IN_SET('1', `delivery_type`) AND `name` LIKE '%can I ask y%' ORDER BY `distance` ASC LIMIT 0,15; /www/server/mysql/bin/mysqld, Version: 5.7.43-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.43-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /usr/sbin/mysqld, Version: 8.0.45-0ubuntu0.22.04.1 ((Ubuntu)). started with: Tcp port: 0 Unix socket: /tmp/tmp.gKxjc7Ulzr/mysqld.sock Time Id Command Argument
|
|