SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516027 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516027 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103176,306859,991492,447671,14998,975423,641984,516187,248524,739878,941729,1008790,286304,949130,608966,126180,48028,50043,583954,792961,890645,634131,738462,546793,147838,1034657,610733,116005,1012806,383950,305633,672555,3740,673090,525227,242906,696865,8729,147915,533873,504216,641626,266979,53071,683970,100209,652890,705582,882510,92255,706972,587582,971856,572713,572155,193530,359622,1007599,815660,26983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]