SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45713 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45713 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032127,609149,26351,628469,439868,939438,590804,466257,640338,312850,841155,966370,407004,879784,425307,19157,972305,422180,682977,421403,713315,1042555,378975,890484,232327,611050,176113,58261,890654,866218,662061,900701,305325,594169,479998,123366,261273,856005,945721,566069,119505,154255,943374,376836,143801,609690,389450,732817,1039393,288837,873016,230383,613677,1026293,838925,9685,834273,55499,622498,554588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]