Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.is_active AS is_active_9
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9 FROM `user` t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.api_key AS api_key_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.api_key AS api_key_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM brand t0 WHERE t0.id = '1';

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.created_at AS created_at_6,
  u0_.updated_at AS updated_at_7,
  u0_.is_active AS is_active_8
FROM
  `user` u0_
WHERE
  u0_.is_active = 1
  AND u0_.id NOT IN (
    SELECT
      u1_.id
    FROM
      brand b2_
      INNER JOIN brand_user b3_ ON b2_.id = b3_.brand_id
      INNER JOIN `user` u1_ ON u1_.id = b3_.user_id
    WHERE
      b2_.id = ?
  )
ORDER BY
  u0_.email ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.created_at AS created_at_6, u0_.updated_at AS updated_at_7, u0_.is_active AS is_active_8 FROM `user` u0_ WHERE u0_.is_active = 1 AND u0_.id NOT IN (SELECT u1_.id FROM brand b2_ INNER JOIN brand_user b3_ ON b2_.id = b3_.brand_id INNER JOIN `user` u1_ ON u1_.id = b3_.user_id WHERE b2_.id = 1) ORDER BY u0_.email ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.is_active AS is_active_9
FROM
  `user` t0
  INNER JOIN brand_user ON t0.id = brand_user.user_id
WHERE
  brand_user.brand_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_active AS is_active_9 FROM `user` t0 INNER JOIN brand_user ON t0.id = brand_user.user_id WHERE brand_user.brand_id = 1;

SELECT
  t0.id AS id_1,
  t0.partnership_extension AS partnership_extension_2,
  t0.is_active AS is_active_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.brand_id AS brand_id_7,
  t0.shop_id AS shop_id_8
FROM
  brand_shop t0
WHERE
  t0.brand_id = ?

SELECT t0.id AS id_1, t0.partnership_extension AS partnership_extension_2, t0.is_active AS is_active_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.brand_id AS brand_id_7, t0.shop_id AS shop_id_8 FROM brand_shop t0 WHERE t0.brand_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_url AS icon_url_3,
  t0.icon_filename AS icon_filename_4,
  t0.link_template AS link_template_5,
  t0.shop_type AS shop_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_url AS icon_url_3, t0.icon_filename AS icon_filename_4, t0.link_template AS link_template_5, t0.shop_type AS shop_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM shop t0 WHERE t0.id = 9;