SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510292 LIMIT 1 [ RunTime:0.001024s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510292 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303521,944794,209689,577984,333973,718343,667109,568342,896694,988770,874537,171407,229231,536730,197598,366143,534236,774168,708028,678025,618887,519815,326571,117772,892799,1003742,342810,307224,437377,688046,155415,67718,590512,437933,396447,286862,540105,509871,60499,74204,744573,434968,600045,372620,130103,546889,1046408,41093,442043,232010,709187,423263,236844,253597,349033,300704,885868,371094,38263,419600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003191s ]