SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430758 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430758 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102471,219096,1002503,596487,201330,758161,445035,670292,393422,88741,380692,567094,337466,828800,299016,923941,391764,688662,365110,489624,913511,965940,110915,939123,708449,103645,354997,687085,663792,397720,696984,844318,296345,957969,741911,615881,1044852,820631,788182,894842,521159,852865,96958,850723,67,660198,706979,206978,605400,268962,324559,235091,580468,448472,707179,220643,826633,1013808,714009,757712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]