SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486513 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486513 [ RunTime:0.005699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357323,646333,9134,929739,983236,88454,654837,505202,748074,942003,410385,151750,885774,567776,732208,297040,948808,209450,435888,891647,365046,355541,497332,817525,449230,863250,346867,162761,279806,374162,665522,105912,56383,811697,45165,76499,1039932,1003680,912964,508446,285701,770146,242128,156407,920077,959945,220643,274097,135595,138883,149667,439436,376508,955084,367157,120574,85466,596223,745928,894985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]