SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548410 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548410 [ RunTime:0.002731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559447,913192,494612,370573,734414,36428,735952,115393,313282,414008,105617,121351,143357,783044,195273,578182,807346,226474,1006970,806105,233925,981307,3706,326007,150946,840778,592254,1016284,702777,213069,492878,424320,534659,170749,212692,647879,289385,102085,37420,1013969,477846,776322,195281,24622,38681,678598,146152,378013,760941,934077,476603,133182,414701,719687,153285,82940,486197,464180,427915,941629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001649s ]