SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485343 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485343 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881630,878694,500410,248523,1007113,348201,101128,628872,585463,72935,902470,585406,560592,739881,152643,659627,863028,96299,706379,362215,681801,62643,208210,744309,764542,417036,45405,515461,608085,677439,18585,98712,527903,767930,394498,857623,115243,611670,513349,532559,551335,642007,580565,770629,154749,304013,49174,260742,1006062,407413,653590,138079,922130,584200,941398,1013914,63032,698947,785192,821883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]