SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261580 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261580 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029146,530116,682870,772892,369832,599506,188792,898453,139373,74975,590381,673658,1040347,410905,374525,752083,629451,357951,1041659,336429,210144,615022,576173,522570,211501,335564,832455,614288,530519,986747,1047124,611013,488456,968046,12844,1016398,487487,758451,705225,853250,240731,644454,479536,84950,787596,336529,138470,776646,204283,917213,556009,533524,551709,315898,806051,678194,729861,214801,565540,336638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]