SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 958913 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 958913 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747390,509227,44498,287875,670264,1017384,79344,632201,202872,32164,207664,10454,268558,121120,1044108,8368,1020650,1003731,1011179,385412,481475,515262,686203,478998,683604,642956,995220,715520,258403,694607,1008838,509731,98959,651180,341407,217267,588629,872255,177541,375154,232879,870932,531049,343169,483839,413869,1027544,621371,180368,680881,630154,736529,489857,393986,198280,619238,430158,679414,809385,455591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 958913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 958913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004441s ]