SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474410 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474410 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645693,428901,537548,665009,34647,326013,520337,360771,560284,585116,995612,12892,105199,814629,524748,501644,13959,786337,200148,445406,194632,982153,111312,9009,394269,961277,655437,852371,824247,188202,584883,323768,103703,626201,947820,275700,297995,942720,332884,1021344,635851,89075,309796,220797,658804,725744,99107,895981,554280,875245,1005123,860753,976541,148662,171417,192875,427534,145179,835544,660857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]