SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480678 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480678 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244655,391842,631552,22631,1005478,469136,322513,34033,519414,135931,1025863,853707,910423,167379,207594,571155,645923,876028,938189,285734,295602,761987,1019824,256280,484881,522917,208880,79109,1030013,1004627,493648,757137,405734,418728,349238,562649,190472,603577,685122,353146,598870,686502,863977,41241,237873,729868,782258,678215,115488,250460,505981,67541,947917,652360,1024127,544084,626391,1038325,152190,165951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]