SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 604313 LIMIT 1 [ RunTime:0.001690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 604313 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163186,786658,84992,924018,324327,768661,250211,428082,339381,27196,60339,401160,580680,99579,1047025,358310,716222,608997,1037828,830912,573733,705466,874355,483476,372483,528771,13576,134155,367770,802326,936078,573150,429589,455103,617106,253517,993726,475290,441475,340685,639145,444765,123787,821581,577470,1003340,972932,145156,641399,19392,238847,195693,27530,128995,582813,704898,756218,1010856,967379,1015817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 604313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 604313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]