SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468612 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468612 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026083,92594,901415,760390,33908,527504,263524,633526,95016,940932,326418,206094,434901,271940,490158,635128,318405,741726,814950,205792,82492,273296,844192,532605,61239,972992,870984,400340,592141,397412,660215,928602,574253,82494,113178,265250,958779,863202,148531,795006,237985,496556,125483,75874,606972,529315,804663,697594,381538,220673,757214,214899,1029805,962395,380526,554672,470179,1007098,133561,123181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]