SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256030 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256030 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585053,351455,787764,433383,468286,300288,608904,920398,695686,466390,260586,122311,573170,320068,931276,706887,904517,740249,348647,788795,917930,267448,820133,45603,563757,697175,551998,695078,79123,40047,355319,908228,1035805,1008825,312352,130970,32519,118484,885102,561159,95946,324413,386085,855484,816561,660315,846481,891867,332972,880775,212325,634769,728709,850988,992783,379564,92654,1003374,736882,625980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003897s ]