demo, MySQL - rextester

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

select version() as 'mysql version';
DROP TABLE IF EXISTS laptop;
DROP TABLE IF EXISTS make;
DROP TABLE IF EXISTS line;
DROP TABLE IF EXISTS networking;
DROP TABLE IF EXISTS laptop_networking;
CREATE TABLE laptop (id int, make int, line int, model varchar(255));
CREATE TABLE make (id int, name varchar(255), `other info` varchar(255));
CREATE TABLE line (id int, name varchar(255), `other info` varchar(255));
CREATE TABLE networking (id int, name varchar(255), `other info` varchar(255));
CREATE TABLE laptop_networking (id int, networking int, laptop int);

INSERT INTO laptop (id, make, line, model)
VALUES
    (1, 1, 1, 'Late 2015 13"');

INSERT INTO make (id, name, `other info`)
VALUES
    (1, 'Apple', NULL);

INSERT INTO line (id, name, `other info`)
VALUES
    (1, 'MacBook Pro', NULL);

INSERT INTO networking (id, name, `other info`)
VALUES
    (1, 'A wifi card', NULL),
    (2, 'Another card', NULL),
    (3, 'Yet another', NULL);

INSERT INTO laptop_networking (id, networking, laptop)
VALUES
    (1, 3, 1),
    (2, 1, 1);

SELECT laptop.id,
       make.id AS makeID,
       make.name AS makeName,
       line.id AS lineID,
       line.name AS lineName,
       laptop.model,
       t.networking
FROM laptop
INNER JOIN make
    ON laptop.make = make.id
INNER JOIN line
    ON laptop.line = line.id
INNER JOIN
(
    SELECT t1.laptop, GROUP_CONCAT(t2.name) AS networking
    FROM laptop_networking t1
    INNER JOIN networking t2
        ON t1.networking = t2.id
    GROUP BY t1.laptop
) t
    ON laptop.id = t.laptop
WHERE laptop.id = 1


absolute service time: 0,4 sec