SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557276 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557276 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871566,868941,971060,370582,243093,136866,396594,137932,685466,350350,269757,592711,645832,170115,532601,591962,164114,795652,24581,520964,811655,378293,863925,881594,793598,350347,229138,327402,912709,518904,668536,392461,541067,540887,912290,622676,961241,334313,770818,905159,717232,696047,305626,447530,314663,265368,256121,142298,852936,278893,556222,297789,359477,912497,517359,1047395,40380,710728,187741,487982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]