SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009401 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009401 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71068,863995,644681,751849,134508,1004729,201231,951250,221590,1046031,512614,79611,494006,725970,694475,114792,568279,428512,1020019,143741,857850,392003,736469,957986,583865,355132,142691,56017,995109,751097,827947,233155,108297,313549,596066,312487,36638,841004,1048314,765295,623105,836894,453847,1026245,840170,888677,556394,322193,763971,1002022,784305,950922,753992,478593,800186,674302,710291,6030,243127,629950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]