SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457733 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457733 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557281,603912,237684,248600,756639,451186,559027,615068,637216,619505,884487,381849,431962,646622,759541,155169,434264,548090,228094,856638,539704,830212,917388,373564,752875,258748,722923,129528,151200,830802,386643,847877,898813,306863,208587,712002,214500,284592,579184,353209,525418,617009,895817,898461,844602,634518,940630,211202,120204,335459,291405,144725,965236,707855,275829,811821,451046,1013871,625581,389341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001038s ]