SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547045 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547045 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425842,369612,143460,862249,122086,184891,679760,577754,198587,178627,665627,422180,8255,606789,28278,559036,941271,966006,455011,952492,921691,537141,923284,120050,216362,427668,180857,279197,377065,42392,443973,972398,870748,689217,496960,504493,651590,985451,565986,379047,777164,80209,425678,330612,234415,53253,336831,1048746,280012,352009,542694,532327,663989,257540,235937,111127,496222,89868,475427,159051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001148s ]