SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007690s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377840 LIMIT 1 [ RunTime:0.007634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377840 [ RunTime:0.005737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440742,288110,669832,422578,216564,647567,545092,169263,608109,333036,566279,767432,877498,703083,244736,260191,413976,595106,442654,475944,172804,437448,446704,711425,209931,526323,98946,870844,244607,596852,441017,121229,455163,133527,397364,304771,410871,681032,889876,455302,380360,408312,133053,66935,360850,170337,742606,555168,45875,418667,573428,34120,169700,1048893,509429,907861,519936,157255,496254,746180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]