SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3881 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3881 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003350,312719,666467,628818,207368,670986,887139,221268,78752,571231,31029,285066,345378,483242,820828,411616,234578,150548,44905,1016053,257889,355539,537303,714883,644299,677995,1027911,50170,649355,989490,472092,828229,965000,113741,1004588,347880,548703,886114,611967,674953,92586,456305,623969,151123,606808,83926,569673,484469,303783,787275,432364,535321,324880,922779,662138,1040368,367555,503306,1038134,947429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]