SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80421 LIMIT 1 [ RunTime:0.004072s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80421 [ RunTime:0.001221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822544,986026,750395,141077,837367,730042,1023906,551824,833488,869996,90623,964636,195082,409816,820964,954295,592337,227216,833144,542458,526332,469592,696718,726155,729741,682505,992255,220435,410887,436095,320344,229484,992894,471978,148533,126156,198452,933475,348194,690210,46612,300908,628565,945999,584060,60569,64646,456378,437714,108370,830381,180820,534327,13447,284413,957598,514486,909258,53829,561562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]