SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505273 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505273 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200475,793777,517534,55326,849680,231551,366242,1031580,205277,632021,585980,918768,990421,119377,525962,885140,836350,510878,190285,750454,961436,912214,582410,718263,542903,173273,794209,149800,565359,29193,745786,709857,492663,397203,801900,120973,784746,905206,438374,97579,59029,838170,648530,780780,34641,830651,925403,23267,150389,695243,723926,20803,752893,526177,324975,820543,114080,412109,790807,973874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]