SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005758s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319190 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319190 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198923,938203,1004179,310281,213810,718532,239237,7790,1022682,300566,556787,53073,907415,512416,651481,737588,462521,143309,16003,385410,865366,631954,224517,655233,428830,425257,1020263,848884,321862,761146,1011511,94780,286844,968282,282722,395797,322551,382287,953994,1031418,557775,552046,1034737,422716,833048,185486,1040184,243195,160997,554582,522276,298814,578950,73071,384217,848702,593646,21608,573418,36496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]