SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249106 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249106 [ RunTime:0.004581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50682,55607,681803,150335,388406,728965,533180,601806,671294,58749,693110,295287,571295,707256,681123,285026,874216,575306,561639,232829,203024,1043889,383564,300862,375924,296303,8007,708221,186776,980827,516360,543397,778077,724128,1002687,920217,963315,194228,555409,285778,568253,783833,771620,317678,613902,1042390,885672,350063,158964,775897,359929,641054,315726,208295,92314,537498,759853,889944,138597,591001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]