SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499879 LIMIT 1 [ RunTime:0.001008s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499879 [ RunTime:0.002695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809162,543344,52168,469940,11324,109015,211248,66532,826884,870963,651761,420034,651594,962294,1007950,474338,707364,764208,658310,448034,239894,270756,935598,945003,581378,973650,440560,121787,1020721,208856,134153,730057,317208,939019,626249,19552,158029,167906,611131,64201,474012,109276,559766,672456,223670,114731,815118,88369,260862,674338,507270,351990,430187,291574,340352,129003,410796,941451,775516,180667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]