SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529813 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529813 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826932,473837,92886,1008740,129485,792341,727037,492688,373459,1020528,859068,498346,861153,21939,140459,433735,978738,539981,152946,500139,974844,966915,702474,357442,286974,638954,237371,676756,155869,87422,397208,572431,248101,176901,556781,115508,398383,895498,36588,243009,44141,602929,193871,206741,346515,855650,230466,656403,835363,954846,728225,841281,211703,730318,449316,856784,580420,895949,547255,597348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001032s ]