Symfony Profiler

SELECT
  DISTINCT id_0,
  MIN(sclr_44) AS dctrn_minrownum
FROM
  (
    SELECT
      b0_.id AS id_0,
      b0_.is_active AS is_active_1,
      b0_.last_visit AS last_visit_2,
      b0_.next_visit AS next_visit_3,
      b0_.number_of_visits AS number_of_visits_4,
      b0_.assigned_repair_person AS assigned_repair_person_5,
      b0_.name AS name_6,
      b0_.brand AS brand_7,
      b0_.model AS model_8,
      b0_.bicycode AS bicycode_9,
      b0_.is_electric AS is_electric_10,
      b0_.size AS size_11,
      b0_.type AS type_12,
      b0_.collection AS collection_13,
      b0_.condition AS condition_14,
      b0_.purchase_date AS purchase_date_15,
      b0_.technical_data AS technical_data_16,
      b0_.administrative_data AS administrative_data_17,
      b0_.created_at AS created_at_18,
      b0_.updated_at AS updated_at_19,
      b0_.created_by AS created_by_20,
      b0_.updated_by AS updated_by_21,
      b0_.jb_ref AS jb_ref_22,
      j1_.id AS id_23,
      j1_.username AS username_24,
      j1_.password AS password_25,
      j1_.roles AS roles_26,
      j1_.firstname AS firstname_27,
      j1_.lastname AS lastname_28,
      j1_.email AS email_29,
      j1_.is_verified AS is_verified_30,
      j1_.is_active AS is_active_31,
      j1_.phone_number AS phone_number_32,
      j1_.dialing_code AS dialing_code_33,
      j1_.created_at AS created_at_34,
      j1_.updated_at AS updated_at_35,
      j1_.created_by AS created_by_36,
      j1_.updated_by AS updated_by_37,
      j1_.siret AS siret_38,
      j1_.company_name AS company_name_39,
      j1_.addresses AS addresses_40,
      j1_.avatar_path AS avatar_path_41,
      f2_.id AS id_42,
      f2_.fleet_name AS fleet_name_43,
      ROW_NUMBER() OVER(
        ORDER BY
          b0_.created_at DESC
      ) AS sclr_44,
      j1_.type AS type_45
    FROM
      bike b0_
      LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id
      AND j1_.type IN ('customer', 'fleet')
      LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id
      LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id
    WHERE
      b0_.is_active = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  10

SELECT DISTINCT id_0, MIN(sclr_44) AS dctrn_minrownum FROM (SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.last_visit AS last_visit_2, b0_.next_visit AS next_visit_3, b0_.number_of_visits AS number_of_visits_4, b0_.assigned_repair_person AS assigned_repair_person_5, b0_.name AS name_6, b0_.brand AS brand_7, b0_.model AS model_8, b0_.bicycode AS bicycode_9, b0_.is_electric AS is_electric_10, b0_.size AS size_11, b0_.type AS type_12, b0_.collection AS collection_13, b0_.condition AS condition_14, b0_.purchase_date AS purchase_date_15, b0_.technical_data AS technical_data_16, b0_.administrative_data AS administrative_data_17, b0_.created_at AS created_at_18, b0_.updated_at AS updated_at_19, b0_.created_by AS created_by_20, b0_.updated_by AS updated_by_21, b0_.jb_ref AS jb_ref_22, j1_.id AS id_23, j1_.username AS username_24, j1_.password AS password_25, j1_.roles AS roles_26, j1_.firstname AS firstname_27, j1_.lastname AS lastname_28, j1_.email AS email_29, j1_.is_verified AS is_verified_30, j1_.is_active AS is_active_31, j1_.phone_number AS phone_number_32, j1_.dialing_code AS dialing_code_33, j1_.created_at AS created_at_34, j1_.updated_at AS updated_at_35, j1_.created_by AS created_by_36, j1_.updated_by AS updated_by_37, j1_.siret AS siret_38, j1_.company_name AS company_name_39, j1_.addresses AS addresses_40, j1_.avatar_path AS avatar_path_41, f2_.id AS id_42, f2_.fleet_name AS fleet_name_43, ROW_NUMBER() OVER(ORDER BY b0_.created_at DESC) AS sclr_44, j1_.type AS type_45 FROM bike b0_ LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id AND j1_.type IN ('customer', 'fleet') LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id WHERE b0_.is_active = 1) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.is_verified AS is_verified_8,
  t0.is_active AS is_active_9,
  t0.phone_number AS phone_number_10,
  t0.dialing_code AS dialing_code_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.siret AS siret_16,
  t0.company_name AS company_name_17,
  t0.addresses AS addresses_18,
  t0.avatar_path AS avatar_path_19,
  t0.type
FROM
  jb_user t0
WHERE
  t0.email = ?
  AND t0.type IN (
    'user', 'customer', 'repairer', 'manager',
    'fleet'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 WHERE t0.email = 'jb@manager.local' AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet') LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.is_active AS is_active_1,
  b0_.last_visit AS last_visit_2,
  b0_.next_visit AS next_visit_3,
  b0_.number_of_visits AS number_of_visits_4,
  b0_.assigned_repair_person AS assigned_repair_person_5,
  b0_.name AS name_6,
  b0_.brand AS brand_7,
  b0_.model AS model_8,
  b0_.bicycode AS bicycode_9,
  b0_.is_electric AS is_electric_10,
  b0_.size AS size_11,
  b0_.type AS type_12,
  b0_.collection AS collection_13,
  b0_.condition AS condition_14,
  b0_.purchase_date AS purchase_date_15,
  b0_.technical_data AS technical_data_16,
  b0_.administrative_data AS administrative_data_17,
  b0_.created_at AS created_at_18,
  b0_.updated_at AS updated_at_19,
  b0_.created_by AS created_by_20,
  b0_.updated_by AS updated_by_21,
  b0_.jb_ref AS jb_ref_22,
  j1_.id AS id_23,
  j1_.username AS username_24,
  j1_.password AS password_25,
  j1_.roles AS roles_26,
  j1_.firstname AS firstname_27,
  j1_.lastname AS lastname_28,
  j1_.email AS email_29,
  j1_.is_verified AS is_verified_30,
  j1_.is_active AS is_active_31,
  j1_.phone_number AS phone_number_32,
  j1_.dialing_code AS dialing_code_33,
  j1_.created_at AS created_at_34,
  j1_.updated_at AS updated_at_35,
  j1_.created_by AS created_by_36,
  j1_.updated_by AS updated_by_37,
  j1_.siret AS siret_38,
  j1_.company_name AS company_name_39,
  j1_.addresses AS addresses_40,
  j1_.avatar_path AS avatar_path_41,
  f2_.id AS id_42,
  f2_.fleet_name AS fleet_name_43,
  j1_.type AS type_44
FROM
  bike b0_
  LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id
  AND j1_.type IN ('customer', 'fleet')
  LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id
  LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id
WHERE
  b0_.is_active = ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.last_visit AS last_visit_2, b0_.next_visit AS next_visit_3, b0_.number_of_visits AS number_of_visits_4, b0_.assigned_repair_person AS assigned_repair_person_5, b0_.name AS name_6, b0_.brand AS brand_7, b0_.model AS model_8, b0_.bicycode AS bicycode_9, b0_.is_electric AS is_electric_10, b0_.size AS size_11, b0_.type AS type_12, b0_.collection AS collection_13, b0_.condition AS condition_14, b0_.purchase_date AS purchase_date_15, b0_.technical_data AS technical_data_16, b0_.administrative_data AS administrative_data_17, b0_.created_at AS created_at_18, b0_.updated_at AS updated_at_19, b0_.created_by AS created_by_20, b0_.updated_by AS updated_by_21, b0_.jb_ref AS jb_ref_22, j1_.id AS id_23, j1_.username AS username_24, j1_.password AS password_25, j1_.roles AS roles_26, j1_.firstname AS firstname_27, j1_.lastname AS lastname_28, j1_.email AS email_29, j1_.is_verified AS is_verified_30, j1_.is_active AS is_active_31, j1_.phone_number AS phone_number_32, j1_.dialing_code AS dialing_code_33, j1_.created_at AS created_at_34, j1_.updated_at AS updated_at_35, j1_.created_by AS created_by_36, j1_.updated_by AS updated_by_37, j1_.siret AS siret_38, j1_.company_name AS company_name_39, j1_.addresses AS addresses_40, j1_.avatar_path AS avatar_path_41, f2_.id AS id_42, f2_.fleet_name AS fleet_name_43, j1_.type AS type_44 FROM bike b0_ LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id AND j1_.type IN ('customer', 'fleet') LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id WHERE b0_.is_active = 1 AND b0_.id IN ('1f0d6b43-9171-6db0-97a9-c7f1284015c3', '1f0d6b39-7a41-61e0-9c4d-c50023f1bc04', '1f0d69b4-ce0a-63ac-93ea-f914adb90aba', '1f0d696d-2e3e-6d9c-b91f-d3222596bc14', '1f0d5ee4-cdae-68b6-abf5-cffd4f370ac0', '1f0d5edf-1c6e-611e-8d9c-bb716f6753a8', '1f0d5c5c-73f9-6a62-a8de-63fbc77587c8', '1f0d5c53-d0f1-6fde-b361-83b53778fc1b', '1f0d5bd5-4717-6526-b367-83e4dc4bfe1f', '1f0d5bd1-975b-6cde-b931-ed66789e1b93') ORDER BY b0_.created_at DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.is_active AS is_active_1,
          b0_.last_visit AS last_visit_2,
          b0_.next_visit AS next_visit_3,
          b0_.number_of_visits AS number_of_visits_4,
          b0_.assigned_repair_person AS assigned_repair_person_5,
          b0_.name AS name_6,
          b0_.brand AS brand_7,
          b0_.model AS model_8,
          b0_.bicycode AS bicycode_9,
          b0_.is_electric AS is_electric_10,
          b0_.size AS size_11,
          b0_.type AS type_12,
          b0_.collection AS collection_13,
          b0_.condition AS condition_14,
          b0_.purchase_date AS purchase_date_15,
          b0_.technical_data AS technical_data_16,
          b0_.administrative_data AS administrative_data_17,
          b0_.created_at AS created_at_18,
          b0_.updated_at AS updated_at_19,
          b0_.created_by AS created_by_20,
          b0_.updated_by AS updated_by_21,
          b0_.jb_ref AS jb_ref_22,
          j1_.id AS id_23,
          j1_.username AS username_24,
          j1_.password AS password_25,
          j1_.roles AS roles_26,
          j1_.firstname AS firstname_27,
          j1_.lastname AS lastname_28,
          j1_.email AS email_29,
          j1_.is_verified AS is_verified_30,
          j1_.is_active AS is_active_31,
          j1_.phone_number AS phone_number_32,
          j1_.dialing_code AS dialing_code_33,
          j1_.created_at AS created_at_34,
          j1_.updated_at AS updated_at_35,
          j1_.created_by AS created_by_36,
          j1_.updated_by AS updated_by_37,
          j1_.siret AS siret_38,
          j1_.company_name AS company_name_39,
          j1_.addresses AS addresses_40,
          j1_.avatar_path AS avatar_path_41,
          f2_.id AS id_42,
          f2_.fleet_name AS fleet_name_43,
          j1_.type AS type_44
        FROM
          bike b0_
          LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id
          AND j1_.type IN ('customer', 'fleet')
          LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id
          LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id
        WHERE
          b0_.is_active = ?
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.last_visit AS last_visit_2, b0_.next_visit AS next_visit_3, b0_.number_of_visits AS number_of_visits_4, b0_.assigned_repair_person AS assigned_repair_person_5, b0_.name AS name_6, b0_.brand AS brand_7, b0_.model AS model_8, b0_.bicycode AS bicycode_9, b0_.is_electric AS is_electric_10, b0_.size AS size_11, b0_.type AS type_12, b0_.collection AS collection_13, b0_.condition AS condition_14, b0_.purchase_date AS purchase_date_15, b0_.technical_data AS technical_data_16, b0_.administrative_data AS administrative_data_17, b0_.created_at AS created_at_18, b0_.updated_at AS updated_at_19, b0_.created_by AS created_by_20, b0_.updated_by AS updated_by_21, b0_.jb_ref AS jb_ref_22, j1_.id AS id_23, j1_.username AS username_24, j1_.password AS password_25, j1_.roles AS roles_26, j1_.firstname AS firstname_27, j1_.lastname AS lastname_28, j1_.email AS email_29, j1_.is_verified AS is_verified_30, j1_.is_active AS is_active_31, j1_.phone_number AS phone_number_32, j1_.dialing_code AS dialing_code_33, j1_.created_at AS created_at_34, j1_.updated_at AS updated_at_35, j1_.created_by AS created_by_36, j1_.updated_by AS updated_by_37, j1_.siret AS siret_38, j1_.company_name AS company_name_39, j1_.addresses AS addresses_40, j1_.avatar_path AS avatar_path_41, f2_.id AS id_42, f2_.fleet_name AS fleet_name_43, j1_.type AS type_44 FROM bike b0_ LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id AND j1_.type IN ('customer', 'fleet') LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id WHERE b0_.is_active = 1 ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  COUNT(a1_.id) AS sclr_2
FROM
  bike b0_
  LEFT JOIN appointment a1_ ON b0_.id = a1_.bike_id
GROUP BY
  b0_.id,
  b0_.name
ORDER BY
  sclr_2 DESC

SELECT b0_.id AS id_0, b0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM bike b0_ LEFT JOIN appointment a1_ ON b0_.id = a1_.bike_id GROUP BY b0_.id, b0_.name ORDER BY sclr_2 DESC;

SELECT
  DISTINCT f0_.fleet_name AS fleet_name_0
FROM
  bike b1_
  INNER JOIN fleet_company_bike f2_ ON b1_.id = f2_.bike_id
  INNER JOIN fleet_company f0_ ON f0_.id = f2_.fleet_company_id
ORDER BY
  f0_.fleet_name ASC

SELECT DISTINCT f0_.fleet_name AS fleet_name_0 FROM bike b1_ INNER JOIN fleet_company_bike f2_ ON b1_.id = f2_.bike_id INNER JOIN fleet_company f0_ ON f0_.id = f2_.fleet_company_id ORDER BY f0_.fleet_name ASC;

SELECT
  DISTINCT b0_.jb_ref AS jb_ref_0
FROM
  bike b0_
ORDER BY
  b0_.jb_ref ASC

SELECT DISTINCT b0_.jb_ref AS jb_ref_0 FROM bike b0_ ORDER BY b0_.jb_ref ASC;

SELECT
  DISTINCT b0_.brand AS brand_0
FROM
  bike b0_
WHERE
  b0_.brand IS NOT NULL
ORDER BY
  b0_.brand ASC

SELECT DISTINCT b0_.brand AS brand_0 FROM bike b0_ WHERE b0_.brand IS NOT NULL ORDER BY b0_.brand ASC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.is_verified AS is_verified_8,
  t0.is_active AS is_active_9,
  t0.phone_number AS phone_number_10,
  t0.dialing_code AS dialing_code_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.siret AS siret_16,
  t0.company_name AS company_name_17,
  t0.addresses AS addresses_18,
  t0.avatar_path AS avatar_path_19,
  t0.type
FROM
  jb_user t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'user', 'customer', 'repairer', 'manager',
    'fleet'
  )

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 WHERE t0.id = '9865f19a-3280-4867-8389-7de183a9f91f' AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet');

SELECT
  DISTINCT b0_.type AS type_0
FROM
  bike b0_
WHERE
  b0_.type IS NOT NULL
ORDER BY
  b0_.type ASC

SELECT DISTINCT b0_.type AS type_0 FROM bike b0_ WHERE b0_.type IS NOT NULL ORDER BY b0_.type ASC;

SELECT
  DISTINCT b0_.model AS model_0
FROM
  bike b0_
WHERE
  b0_.model IS NOT NULL
ORDER BY
  b0_.model ASC

SELECT DISTINCT b0_.model AS model_0 FROM bike b0_ WHERE b0_.model IS NOT NULL ORDER BY b0_.model ASC;