SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34205 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34205 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543068,229938,24991,592990,439928,915252,969274,890422,816995,829730,974518,968093,395756,569728,322308,988054,164102,959796,169637,114221,207884,984294,533134,524343,367891,812535,735280,705283,633548,746800,432044,198845,616215,727986,402140,930402,283183,13601,503069,351716,766126,243039,107259,252087,874486,159373,220650,318036,251145,740496,717888,794842,311518,659814,544000,367487,329262,937120,651465,194006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]