SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80218 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80218 [ RunTime:0.002908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223840,469944,580146,251497,177488,1010000,116251,399263,997095,395572,878355,170476,722781,235288,673193,691504,594121,397690,367505,818994,497227,152371,653555,721934,1874,661499,480406,703621,972855,38470,740539,433954,193979,15916,696137,904776,736457,572470,766286,22944,703890,761370,24831,737409,952076,159562,896969,231697,727174,589657,1023178,278930,731887,496147,46487,265927,271691,701976,65303,167379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]