SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31816 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31816 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742125,1025611,986595,819630,50701,819144,92364,960716,305186,100892,858605,430879,190620,592006,591199,15641,341384,736009,104224,159540,620563,320786,554587,976086,1040,905329,103130,532812,416650,150297,516338,485831,265746,693096,118746,226322,207011,305089,750995,980209,157514,689812,121359,511485,864328,761810,585912,389819,294037,679053,723762,628966,429830,661702,793087,339734,908549,967716,233462,831708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]