SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430058 LIMIT 1 [ RunTime:0.001408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430058 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487239,493234,811819,430187,735275,104390,670350,165048,529814,251917,21635,485407,240518,730326,108682,272642,395204,45543,481784,8795,250239,647454,848533,212163,54563,960407,271862,578052,757104,621146,584801,424200,827153,344010,87234,919254,190093,740521,245321,116224,181661,957750,697526,109032,153317,934184,1020645,935672,510635,5518,1029470,578099,659392,757130,260257,871848,804922,35200,470216,550497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001117s ]