SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519029 LIMIT 1 [ RunTime:0.002163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519029 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763567,100577,36637,780995,143565,993598,536145,681236,209262,86638,576267,508504,951944,11217,118279,914457,230601,474422,122085,7370,622118,264708,748699,616370,246312,169671,524118,707517,314132,618426,975748,421085,327924,927110,915219,852458,799192,699315,6052,606561,37410,757257,954379,636130,140760,278115,828515,735880,852411,717780,620907,799383,387887,741564,891865,437957,1005153,582684,655183,77892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]