Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.zip_code AS zip_code_4,
  t0.town AS town_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.country_id AS country_id_10,
  t11.id AS id_12,
  t11.name AS name_13,
  t14.id AS id_15,
  t14.type AS type_16,
  t14.name AS name_17,
  t14.company AS company_18,
  t14.remarques AS remarques_19,
  t14.phone1 AS phone1_20,
  t14.phone2 AS phone2_21,
  t14.purchase_address_use_address AS purchase_address_use_address_22,
  t14.prix_m3_defaut AS prix_m3_defaut_23,
  t14.created_by AS created_by_24,
  t14.updated_by AS updated_by_25,
  t14.created_at AS created_at_26,
  t14.updated_at AS updated_at_27,
  t14.address_id AS address_id_28,
  t14.purchase_address_id AS purchase_address_id_29,
  t30.id AS id_31,
  t30.type AS type_32,
  t30.name AS name_33,
  t30.company AS company_34,
  t30.remarques AS remarques_35,
  t30.phone1 AS phone1_36,
  t30.phone2 AS phone2_37,
  t30.purchase_address_use_address AS purchase_address_use_address_38,
  t30.prix_m3_defaut AS prix_m3_defaut_39,
  t30.created_by AS created_by_40,
  t30.updated_by AS updated_by_41,
  t30.created_at AS created_at_42,
  t30.updated_at AS updated_at_43,
  t30.address_id AS address_id_44,
  t30.purchase_address_id AS purchase_address_id_45
FROM
  address t0
  LEFT JOIN country t11 ON t0.country_id = t11.id
  LEFT JOIN tiers t14 ON t14.address_id = t0.id
  LEFT JOIN tiers t30 ON t30.purchase_address_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.town AS town_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.country_id AS country_id_10, t11.id AS id_12, t11.name AS name_13, t14.id AS id_15, t14.type AS type_16, t14.name AS name_17, t14.company AS company_18, t14.remarques AS remarques_19, t14.phone1 AS phone1_20, t14.phone2 AS phone2_21, t14.purchase_address_use_address AS purchase_address_use_address_22, t14.prix_m3_defaut AS prix_m3_defaut_23, t14.created_by AS created_by_24, t14.updated_by AS updated_by_25, t14.created_at AS created_at_26, t14.updated_at AS updated_at_27, t14.address_id AS address_id_28, t14.purchase_address_id AS purchase_address_id_29, t30.id AS id_31, t30.type AS type_32, t30.name AS name_33, t30.company AS company_34, t30.remarques AS remarques_35, t30.phone1 AS phone1_36, t30.phone2 AS phone2_37, t30.purchase_address_use_address AS purchase_address_use_address_38, t30.prix_m3_defaut AS prix_m3_defaut_39, t30.created_by AS created_by_40, t30.updated_by AS updated_by_41, t30.created_at AS created_at_42, t30.updated_at AS updated_at_43, t30.address_id AS address_id_44, t30.purchase_address_id AS purchase_address_id_45 FROM address t0 LEFT JOIN country t11 ON t0.country_id = t11.id LEFT JOIN tiers t14 ON t14.address_id = t0.id LEFT JOIN tiers t30 ON t30.purchase_address_id = t0.id WHERE t0.id IN (1490, 1486, 1484, 1482, 1480, 1478, 1476, 1474, 1472, 1470, 1468, 1466, 1464, 1462, 1460, 1456, 1454, 1452, 1448, 1446);

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.description AS description_3,
  t0.type_price AS type_price_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.tiers_id AS tiers_id_9
FROM
  tiers_m3_price t0
WHERE
  t0.tiers_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.description AS description_3, t0.type_price AS type_price_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.tiers_id AS tiers_id_9 FROM tiers_m3_price t0 WHERE t0.tiers_id = 797;

DELETE FROM
  token
WHERE
  name IS NULL
  AND lifetime IS NOT NULL
  AND (create_time + lifetime) < ?

DELETE FROM token WHERE name IS NULL AND lifetime IS NOT NULL AND (create_time + lifetime) < 1730875078;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  tiers t0_
WHERE
  t0_.type IN (?)

SELECT COUNT(t0_.id) AS sclr_0 FROM tiers t0_ WHERE t0_.type IN ('PROPRIETAIRE');

SELECT
  t0.id AS id_1,
  t0.create_time AS create_time_2,
  t0.lifetime AS lifetime_3,
  t0.rights AS rights_4,
  t0.name AS name_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  token t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.lifetime AS lifetime_3, t0.rights AS rights_4, t0.name AS name_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM token t0 WHERE t0.id = 'TOKEN_90cfcc2c871a1a1389d44929fc5e959d2a4d305f';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.enable AS enable_5,
  t0.salt AS salt_6,
  t0.roles AS roles_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.phone AS phone_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.enable AS enable_5, t0.salt AS salt_6, t0.roles AS roles_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM user t0 WHERE t0.id = 13;

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.name AS name_2,
  t0_.company AS company_3,
  t0_.remarques AS remarques_4,
  t0_.phone1 AS phone1_5,
  t0_.phone2 AS phone2_6,
  t0_.purchase_address_use_address AS purchase_address_use_address_7,
  t0_.prix_m3_defaut AS prix_m3_defaut_8,
  t0_.created_by AS created_by_9,
  t0_.updated_by AS updated_by_10,
  t0_.created_at AS created_at_11,
  t0_.updated_at AS updated_at_12,
  t0_.address_id AS address_id_13,
  t0_.purchase_address_id AS purchase_address_id_14
FROM
  tiers t0_
WHERE
  t0_.type IN (?)
ORDER BY
  t0_.id DESC
LIMIT
  20

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.company AS company_3, t0_.remarques AS remarques_4, t0_.phone1 AS phone1_5, t0_.phone2 AS phone2_6, t0_.purchase_address_use_address AS purchase_address_use_address_7, t0_.prix_m3_defaut AS prix_m3_defaut_8, t0_.created_by AS created_by_9, t0_.updated_by AS updated_by_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, t0_.address_id AS address_id_13, t0_.purchase_address_id AS purchase_address_id_14 FROM tiers t0_ WHERE t0_.type IN ('PROPRIETAIRE') ORDER BY t0_.id DESC LIMIT 20;