Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.district_name AS district_name_1
FROM
  district d0_

SELECT d0_.id AS id_0, d0_.district_name AS district_name_1 FROM district d0_;

SELECT
  d0_.id AS id_0,
  d0_.activity AS activity_1
FROM
  domain_activity d0_

SELECT d0_.id AS id_0, d0_.activity AS activity_1 FROM domain_activity d0_;

SELECT
  j0_.id AS id_0,
  j0_.job AS job_1
FROM
  job j0_

SELECT j0_.id AS id_0, j0_.job AS job_1 FROM job j0_;

SELECT
  MIN(c0_.first_price) AS sclr_0,
  MAX(c0_.first_price) AS sclr_1
FROM
  compagny_info c0_
  INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id
  INNER JOIN district d2_ ON d1_.district_id = d2_.id
  INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id
  INNER JOIN job j4_ ON c0_.job_id = j4_.id

SELECT MIN(c0_.first_price) AS sclr_0, MAX(c0_.first_price) AS sclr_1 FROM compagny_info c0_ INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id INNER JOIN district d2_ ON d1_.district_id = d2_.id INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id INNER JOIN job j4_ ON c0_.job_id = j4_.id;

SELECT
  t0.id AS id_1,
  t0.district_name AS district_name_2
FROM
  district t0

SELECT t0.id AS id_1, t0.district_name AS district_name_2 FROM district t0;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 1;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 2;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 3;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 4;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 5;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 6;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 7;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 8;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 9;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 10;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 11;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 12;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 13;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 14;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 15;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 16;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 17;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 18;

SELECT
  count(d0_.id) AS sclr_0
FROM
  district d0_
  INNER JOIN department d1_ ON d0_.id = d1_.district_id
  INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id
WHERE
  d0_.id = ?

SELECT count(d0_.id) AS sclr_0 FROM district d0_ INNER JOIN department d1_ ON d0_.id = d1_.district_id INNER JOIN compagny_info c2_ ON d1_.id = c2_.department_compagny_id WHERE d0_.id = 19;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  compagny_info c0_
  INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id
  INNER JOIN district d2_ ON d1_.district_id = d2_.id
  INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id
  INNER JOIN job j4_ ON c0_.job_id = j4_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM compagny_info c0_ INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id INNER JOIN district d2_ ON d1_.district_id = d2_.id INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id INNER JOIN job j4_ ON c0_.job_id = j4_.id;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  compagny_info c0_
  INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id
  INNER JOIN district d2_ ON d1_.district_id = d2_.id
  INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id
  INNER JOIN job j4_ ON c0_.job_id = j4_.id
LIMIT
  12

SELECT DISTINCT c0_.id AS id_0 FROM compagny_info c0_ INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id INNER JOIN district d2_ ON d1_.district_id = d2_.id INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id INNER JOIN job j4_ ON c0_.job_id = j4_.id LIMIT 12;

SELECT
  c0_.id AS id_0,
  c0_.name_compagny AS name_compagny_1,
  c0_.birthday_compagny AS birthday_compagny_2,
  c0_.adress_compagny AS adress_compagny_3,
  c0_.postal_code_compagny AS postal_code_compagny_4,
  c0_.city_compagny AS city_compagny_5,
  c0_.country_compagny AS country_compagny_6,
  c0_.description_compagny AS description_compagny_7,
  c0_.identification_number_compagny AS identification_number_compagny_8,
  c0_.first_price AS first_price_9,
  c0_.rcs AS rcs_10,
  c0_.pourcentage_fees AS pourcentage_fees_11,
  c0_.legal_type AS legal_type_12,
  c0_.amount_limit_min_deposit AS amount_limit_min_deposit_13,
  c0_.pourcentage_deposit AS pourcentage_deposit_14,
  c0_.accepted_deposit AS accepted_deposit_15,
  d1_.id AS id_16,
  d1_.department_name AS department_name_17,
  d1_.number_department AS number_department_18,
  d2_.id AS id_19,
  d2_.district_name AS district_name_20,
  d3_.id AS id_21,
  d3_.activity AS activity_22,
  j4_.id AS id_23,
  j4_.job AS job_24,
  c0_.user_id AS user_id_25,
  c0_.domain_activity_id AS domain_activity_id_26,
  c0_.picture_profil_compagny_id AS picture_profil_compagny_id_27,
  c0_.job_id AS job_id_28,
  c0_.department_compagny_id AS department_compagny_id_29,
  d1_.district_id AS district_id_30
FROM
  compagny_info c0_
  INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id
  INNER JOIN district d2_ ON d1_.district_id = d2_.id
  INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id
  INNER JOIN job j4_ ON c0_.job_id = j4_.id
WHERE
  c0_.id IN (?, ?)

SELECT c0_.id AS id_0, c0_.name_compagny AS name_compagny_1, c0_.birthday_compagny AS birthday_compagny_2, c0_.adress_compagny AS adress_compagny_3, c0_.postal_code_compagny AS postal_code_compagny_4, c0_.city_compagny AS city_compagny_5, c0_.country_compagny AS country_compagny_6, c0_.description_compagny AS description_compagny_7, c0_.identification_number_compagny AS identification_number_compagny_8, c0_.first_price AS first_price_9, c0_.rcs AS rcs_10, c0_.pourcentage_fees AS pourcentage_fees_11, c0_.legal_type AS legal_type_12, c0_.amount_limit_min_deposit AS amount_limit_min_deposit_13, c0_.pourcentage_deposit AS pourcentage_deposit_14, c0_.accepted_deposit AS accepted_deposit_15, d1_.id AS id_16, d1_.department_name AS department_name_17, d1_.number_department AS number_department_18, d2_.id AS id_19, d2_.district_name AS district_name_20, d3_.id AS id_21, d3_.activity AS activity_22, j4_.id AS id_23, j4_.job AS job_24, c0_.user_id AS user_id_25, c0_.domain_activity_id AS domain_activity_id_26, c0_.picture_profil_compagny_id AS picture_profil_compagny_id_27, c0_.job_id AS job_id_28, c0_.department_compagny_id AS department_compagny_id_29, d1_.district_id AS district_id_30 FROM compagny_info c0_ INNER JOIN department d1_ ON c0_.department_compagny_id = d1_.id INNER JOIN district d2_ ON d1_.district_id = d2_.id INNER JOIN domain_activity d3_ ON c0_.domain_activity_id = d3_.id INNER JOIN job j4_ ON c0_.job_id = j4_.id WHERE c0_.id IN (1, 2);

SELECT
  t0.id AS id_1,
  t0.activity AS activity_2
FROM
  domain_activity t0

SELECT t0.id AS id_1, t0.activity AS activity_2 FROM domain_activity t0;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.name AS name_6,
  t0.firstname AS firstname_7,
  t0.birthday AS birthday_8,
  t0.adress AS adress_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.country AS country_12,
  t0.phone AS phone_13,
  t0.pseudonym AS pseudonym_14,
  t0.registration_date AS registration_date_15,
  t0.statut_id AS statut_id_16,
  t0.compagny_id AS compagny_id_17,
  t0.bank_id AS bank_id_18,
  t0.profil_picture_id AS profil_picture_id_19,
  t0.notation_id AS notation_id_20,
  t0.statistic_id AS statistic_id_21
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.roles AS roles_5, t0.name AS name_6, t0.firstname AS firstname_7, t0.birthday AS birthday_8, t0.adress AS adress_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.pseudonym AS pseudonym_14, t0.registration_date AS registration_date_15, t0.statut_id AS statut_id_16, t0.compagny_id AS compagny_id_17, t0.bank_id AS bank_id_18, t0.profil_picture_id AS profil_picture_id_19, t0.notation_id AS notation_id_20, t0.statistic_id AS statistic_id_21 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.global_note AS global_note_2,
  t0.number_notation AS number_notation_3,
  t0.total_notation AS total_notation_4
FROM
  notation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.global_note AS global_note_2, t0.number_notation AS number_notation_3, t0.total_notation AS total_notation_4 FROM notation t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.picture_profile AS picture_profile_2
FROM
  profil_picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.picture_profile AS picture_profile_2
FROM
  profil_picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.name AS name_6,
  t0.firstname AS firstname_7,
  t0.birthday AS birthday_8,
  t0.adress AS adress_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.country AS country_12,
  t0.phone AS phone_13,
  t0.pseudonym AS pseudonym_14,
  t0.registration_date AS registration_date_15,
  t0.statut_id AS statut_id_16,
  t0.compagny_id AS compagny_id_17,
  t0.bank_id AS bank_id_18,
  t0.profil_picture_id AS profil_picture_id_19,
  t0.notation_id AS notation_id_20,
  t0.statistic_id AS statistic_id_21
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.roles AS roles_5, t0.name AS name_6, t0.firstname AS firstname_7, t0.birthday AS birthday_8, t0.adress AS adress_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.pseudonym AS pseudonym_14, t0.registration_date AS registration_date_15, t0.statut_id AS statut_id_16, t0.compagny_id AS compagny_id_17, t0.bank_id AS bank_id_18, t0.profil_picture_id AS profil_picture_id_19, t0.notation_id AS notation_id_20, t0.statistic_id AS statistic_id_21 FROM user t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.global_note AS global_note_2,
  t0.number_notation AS number_notation_3,
  t0.total_notation AS total_notation_4
FROM
  notation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.global_note AS global_note_2, t0.number_notation AS number_notation_3, t0.total_notation AS total_notation_4 FROM notation t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.picture_profile AS picture_profile_2
FROM
  profil_picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.picture_profile AS picture_profile_2
FROM
  profil_picture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = 4;