SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498911 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498911 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231241,474545,368883,823373,308515,889746,270491,896327,138034,161185,1047849,288344,777935,871098,427325,395911,729298,664960,161109,215263,709779,982203,7617,310015,644228,588075,347966,175770,444137,791398,486042,521819,948840,582809,557659,14222,788648,40524,834075,91135,63624,1047600,307412,412686,555812,529087,28909,702525,579767,106886,975890,650456,266188,933308,164306,100418,384641,592127,208372,499879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]