SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580985 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580985 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537950,878194,427230,220240,508823,872241,233647,156278,465972,472819,83090,847946,727036,642443,521946,86079,674020,399170,754041,1009971,277273,216269,538564,897469,668668,726504,538287,192373,713637,936059,523802,314413,647282,709152,656909,320064,248047,28614,85902,199621,468593,127304,299024,95034,832896,1021099,823026,654084,411299,126653,285603,885576,766326,479862,218674,353663,626756,830125,848913,192880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]