SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290354 LIMIT 1 [ RunTime:0.002300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290354 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632005,990532,947171,728604,614410,464635,482332,289335,922997,915385,899171,392357,258030,952896,119476,294382,187872,675662,737094,763329,232834,726871,84566,852450,117844,799148,194050,349514,952701,601273,704687,96944,58264,260338,847359,943174,654272,653791,473854,74396,888064,705044,169210,482135,694481,464504,105674,401375,467859,66224,221226,219409,507604,532694,456938,472964,687340,438144,285722,624603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]