SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341523 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341523 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98694,63065,166077,156359,831898,698841,478752,361013,200051,52715,162285,183196,349607,113244,584771,1043645,41991,156756,414960,676809,760472,762538,230605,436623,1017398,530246,928561,626965,153347,344218,953362,467651,1030151,22167,857645,1018013,913382,909268,870628,372997,209074,722203,931641,871328,773205,9162,43538,803069,1003217,327953,49831,38428,230015,782045,991520,163170,596724,1033457,888174,145883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]