SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401731 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401731 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544535,1021757,579369,757564,113297,833291,249118,642620,522233,158906,297291,409555,273547,264992,307483,888309,690861,1033433,796430,314491,672192,422529,638483,372027,966736,439782,944749,676536,682373,237716,664389,158642,240375,282241,418154,478915,337213,1014871,213841,957327,119421,345414,512990,664584,222992,121674,879413,646901,95993,972501,892559,509482,595222,760276,963273,135796,685537,247028,469134,825152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]