SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22106 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22106 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322024,95141,412419,693774,592457,474582,907876,91780,593491,455588,883580,206068,1012725,482026,86017,734059,729091,669070,275350,428493,401091,433404,317528,353214,995597,801590,193640,342975,1967,636460,23300,644570,17827,424774,58487,569348,439164,300593,768209,374955,974215,511141,199862,32888,955493,972282,589969,514460,473505,456260,957596,286647,923388,551631,233248,786517,743003,74973,317011,906963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]