SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280801 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280801 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954592,368232,811756,993681,223874,722878,141796,158020,900541,697984,500814,345735,594056,759420,856349,151160,371024,750067,790746,220960,660111,744543,265358,358417,895934,128893,438813,751804,1037979,104807,40689,1032391,455990,1045326,43692,758795,824448,845398,107731,978460,318492,555701,668495,973192,784643,27320,344425,841242,254074,578260,127176,740425,256942,242813,437648,644112,889542,83036,225195,831922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]