Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.valid AS valid_2,
  r0_.iso_code AS iso_code_3,
  r0_.phone_code AS phone_code_4,
  r0_.phone_digit AS phone_digit_5,
  r0_.id_country AS id_country_6,
  r0_.id_currency AS id_currency_7
FROM
  region r0_
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.valid AS valid_2, r0_.iso_code AS iso_code_3, r0_.phone_code AS phone_code_4, r0_.phone_digit AS phone_digit_5, r0_.id_country AS id_country_6, r0_.id_currency AS id_currency_7 FROM region r0_ ORDER BY r0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.api_token AS api_token_5,
  t0.diaspora AS diaspora_6,
  t0.phone AS phone_7,
  t0.enabled AS enabled_8,
  t0.email AS email_9,
  t0.valid_code AS valid_code_10,
  t0.last_login AS last_login_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.salt AS salt_13,
  t0.email_canonical AS email_canonical_14,
  t0.username_canonical AS username_canonical_15,
  t0.confirmation_token AS confirmation_token_16,
  t0.principal_school AS principal_school_17,
  t0.image_name AS image_name_18,
  t0.country_id AS country_id_19,
  t0.region_id AS region_id_20,
  t0.residence_country_id AS residence_country_id_21,
  t0.residence_region_id AS residence_region_id_22,
  t23.status AS status_24,
  t23.type AS type_25,
  t23.agree_rgpd AS agree_rgpd_26,
  t23.last_degree_year AS last_degree_year_27,
  t23.last_degree_month AS last_degree_month_28,
  t23.other_degree AS other_degree_29,
  t23.diaspora AS diaspora_30,
  t23.address_diaspora AS address_diaspora_31,
  t23.created_date AS created_date_32,
  t23.updated_date AS updated_date_33,
  t23.client_updated_date AS client_updated_date_34,
  t23.previousEndedContract AS previousEndedContract_35,
  t23.registration_student_school AS registration_student_school_36,
  t23.check_school AS check_school_37,
  t23.other_school AS other_school_38,
  t23.monthly_salary AS monthly_salary_39,
  t23.other_activity AS other_activity_40,
  t23.temporary_passwd AS temporary_passwd_41,
  t23.lastIdSatisfactionSalary AS lastIdSatisfactionSalary_42,
  t23.lastIdSatisfactionSearch AS lastIdSatisfactionSearch_43,
  t23.lastIdSatisfactionCreato AS lastIdSatisfactionCreato_44,
  t23.unlocked AS unlocked_45,
  t23.id AS id_46,
  t23.firstname AS firstname_47,
  t23.lastname AS lastname_48,
  t23.birth_date AS birth_date_49,
  t23.address_number AS address_number_50,
  t23.address_locality AS address_locality_51,
  t23.address_road AS address_road_52,
  t23.other_city AS other_city_53,
  t23.latitude AS latitude_54,
  t23.longitude AS longitude_55,
  t23.maps_address AS maps_address_56,
  t23.phone_mobile1 AS phone_mobile1_57,
  t23.phone_mobile2 AS phone_mobile2_58,
  t23.phone_mobile3 AS phone_mobile3_59,
  t23.phone_home AS phone_home_60,
  t23.phone_office AS phone_office_61,
  t23.location_mode AS location_mode_62,
  t23.email AS email_63,
  t23.sex AS sex_64,
  t23.residence_country_id AS residence_country_id_65,
  t23.residence_region_id AS residence_region_id_66,
  t23.id_degree AS id_degree_67,
  t23.school_id AS school_id_68,
  t23.lasted_company_id AS lasted_company_id_69,
  t23.activity_id AS activity_id_70,
  t23.id_sectorArea AS id_sectorArea_71,
  t23.lasted_contract_id AS lasted_contract_id_72,
  t23.lasted_company_id AS lasted_company_id_73,
  t23.user_id AS user_id_74,
  t23.id_city AS id_city_75,
  t23.id_region AS id_region_76,
  t23.id_country AS id_country_77,
  t23.id_image AS id_image_78,
  t79.id AS id_80,
  t79.name AS name_81,
  t79.url AS url_82,
  t79.created_date AS created_date_83,
  t79.updated_date AS updated_date_84,
  t79.client_updated_date AS client_updated_date_85,
  t79.other_city AS other_city_86,
  t79.address_number AS address_number_87,
  t79.address_locality AS address_locality_88,
  t79.address_road AS address_road_89,
  t79.phone_standard AS phone_standard_90,
  t79.phone_other AS phone_other_91,
  t79.email AS email_92,
  t79.temporary_passwd AS temporary_passwd_93,
  t79.latitude AS latitude_94,
  t79.longitude AS longitude_95,
  t79.maps_address AS maps_address_96,
  t79.location_fixed AS location_fixed_97,
  t79.agree_rgpd AS agree_rgpd_98,
  t79.location_mode AS location_mode_99,
  t79.unlocked AS unlocked_100,
  t79.id_city AS id_city_101,
  t79.id_region AS id_region_102,
  t79.id_country AS id_country_103,
  t79.id_contactCompany AS id_contactCompany_104,
  t79.id_sectorArea AS id_sectorArea_105,
  t79.id_legal_status AS id_legal_status_106,
  t79.user_id AS user_id_107,
  t79.id_image AS id_image_108,
  t109.id AS id_110,
  t109.created_date AS created_date_111,
  t109.updated_date AS updated_date_112,
  t109.client_updated_date AS client_updated_date_113,
  t109.name AS name_114,
  t109.type AS type_115,
  t109.agree_rgpd AS agree_rgpd_116,
  t109.description AS description_117,
  t109.address_number AS address_number_118,
  t109.address_locality AS address_locality_119,
  t109.address_road AS address_road_120,
  t109.phone_standard AS phone_standard_121,
  t109.phone_other AS phone_other_122,
  t109.email AS email_123,
  t109.latitude AS latitude_124,
  t109.longitude AS longitude_125,
  t109.maps_address AS maps_address_126,
  t109.other_activity1 AS other_activity1_127,
  t109.other_activity2 AS other_activity2_128,
  t109.other_activity3 AS other_activity3_129,
  t109.other_activity4 AS other_activity4_130,
  t109.other_activity5 AS other_activity5_131,
  t109.other_activity6 AS other_activity6_132,
  t109.registration AS registration_133,
  t109.other_degree AS other_degree_134,
  t109.location_mode AS location_mode_135,
  t109.id_city AS id_city_136,
  t109.id_region AS id_region_137,
  t109.id_country AS id_country_138,
  t109.id_image AS id_image_139,
  t109.user_id AS user_id_140,
  t109.id_sector_area1 AS id_sector_area1_141,
  t109.id_sector_area2 AS id_sector_area2_142,
  t109.id_sector_area3 AS id_sector_area3_143,
  t109.id_sector_area4 AS id_sector_area4_144,
  t109.id_sector_area5 AS id_sector_area5_145,
  t109.id_sector_area6 AS id_sector_area6_146
FROM
  user t0
  LEFT JOIN person_degree t23 ON t23.user_id = t0.id
  LEFT JOIN company t79 ON t79.user_id = t0.id
  LEFT JOIN school t109 ON t109.user_id = t0.id
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.api_token AS api_token_5, t0.diaspora AS diaspora_6, t0.phone AS phone_7, t0.enabled AS enabled_8, t0.email AS email_9, t0.valid_code AS valid_code_10, t0.last_login AS last_login_11, t0.password_requested_at AS password_requested_at_12, t0.salt AS salt_13, t0.email_canonical AS email_canonical_14, t0.username_canonical AS username_canonical_15, t0.confirmation_token AS confirmation_token_16, t0.principal_school AS principal_school_17, t0.image_name AS image_name_18, t0.country_id AS country_id_19, t0.region_id AS region_id_20, t0.residence_country_id AS residence_country_id_21, t0.residence_region_id AS residence_region_id_22, t23.status AS status_24, t23.type AS type_25, t23.agree_rgpd AS agree_rgpd_26, t23.last_degree_year AS last_degree_year_27, t23.last_degree_month AS last_degree_month_28, t23.other_degree AS other_degree_29, t23.diaspora AS diaspora_30, t23.address_diaspora AS address_diaspora_31, t23.created_date AS created_date_32, t23.updated_date AS updated_date_33, t23.client_updated_date AS client_updated_date_34, t23.previousEndedContract AS previousEndedContract_35, t23.registration_student_school AS registration_student_school_36, t23.check_school AS check_school_37, t23.other_school AS other_school_38, t23.monthly_salary AS monthly_salary_39, t23.other_activity AS other_activity_40, t23.temporary_passwd AS temporary_passwd_41, t23.lastIdSatisfactionSalary AS lastIdSatisfactionSalary_42, t23.lastIdSatisfactionSearch AS lastIdSatisfactionSearch_43, t23.lastIdSatisfactionCreato AS lastIdSatisfactionCreato_44, t23.unlocked AS unlocked_45, t23.id AS id_46, t23.firstname AS firstname_47, t23.lastname AS lastname_48, t23.birth_date AS birth_date_49, t23.address_number AS address_number_50, t23.address_locality AS address_locality_51, t23.address_road AS address_road_52, t23.other_city AS other_city_53, t23.latitude AS latitude_54, t23.longitude AS longitude_55, t23.maps_address AS maps_address_56, t23.phone_mobile1 AS phone_mobile1_57, t23.phone_mobile2 AS phone_mobile2_58, t23.phone_mobile3 AS phone_mobile3_59, t23.phone_home AS phone_home_60, t23.phone_office AS phone_office_61, t23.location_mode AS location_mode_62, t23.email AS email_63, t23.sex AS sex_64, t23.residence_country_id AS residence_country_id_65, t23.residence_region_id AS residence_region_id_66, t23.id_degree AS id_degree_67, t23.school_id AS school_id_68, t23.lasted_company_id AS lasted_company_id_69, t23.activity_id AS activity_id_70, t23.id_sectorArea AS id_sectorArea_71, t23.lasted_contract_id AS lasted_contract_id_72, t23.lasted_company_id AS lasted_company_id_73, t23.user_id AS user_id_74, t23.id_city AS id_city_75, t23.id_region AS id_region_76, t23.id_country AS id_country_77, t23.id_image AS id_image_78, t79.id AS id_80, t79.name AS name_81, t79.url AS url_82, t79.created_date AS created_date_83, t79.updated_date AS updated_date_84, t79.client_updated_date AS client_updated_date_85, t79.other_city AS other_city_86, t79.address_number AS address_number_87, t79.address_locality AS address_locality_88, t79.address_road AS address_road_89, t79.phone_standard AS phone_standard_90, t79.phone_other AS phone_other_91, t79.email AS email_92, t79.temporary_passwd AS temporary_passwd_93, t79.latitude AS latitude_94, t79.longitude AS longitude_95, t79.maps_address AS maps_address_96, t79.location_fixed AS location_fixed_97, t79.agree_rgpd AS agree_rgpd_98, t79.location_mode AS location_mode_99, t79.unlocked AS unlocked_100, t79.id_city AS id_city_101, t79.id_region AS id_region_102, t79.id_country AS id_country_103, t79.id_contactCompany AS id_contactCompany_104, t79.id_sectorArea AS id_sectorArea_105, t79.id_legal_status AS id_legal_status_106, t79.user_id AS user_id_107, t79.id_image AS id_image_108, t109.id AS id_110, t109.created_date AS created_date_111, t109.updated_date AS updated_date_112, t109.client_updated_date AS client_updated_date_113, t109.name AS name_114, t109.type AS type_115, t109.agree_rgpd AS agree_rgpd_116, t109.description AS description_117, t109.address_number AS address_number_118, t109.address_locality AS address_locality_119, t109.address_road AS address_road_120, t109.phone_standard AS phone_standard_121, t109.phone_other AS phone_other_122, t109.email AS email_123, t109.latitude AS latitude_124, t109.longitude AS longitude_125, t109.maps_address AS maps_address_126, t109.other_activity1 AS other_activity1_127, t109.other_activity2 AS other_activity2_128, t109.other_activity3 AS other_activity3_129, t109.other_activity4 AS other_activity4_130, t109.other_activity5 AS other_activity5_131, t109.other_activity6 AS other_activity6_132, t109.registration AS registration_133, t109.other_degree AS other_degree_134, t109.location_mode AS location_mode_135, t109.id_city AS id_city_136, t109.id_region AS id_region_137, t109.id_country AS id_country_138, t109.id_image AS id_image_139, t109.user_id AS user_id_140, t109.id_sector_area1 AS id_sector_area1_141, t109.id_sector_area2 AS id_sector_area2_142, t109.id_sector_area3 AS id_sector_area3_143, t109.id_sector_area4 AS id_sector_area4_144, t109.id_sector_area5 AS id_sector_area5_145, t109.id_sector_area6 AS id_sector_area6_146 FROM user t0 LEFT JOIN person_degree t23 ON t23.user_id = t0.id LEFT JOIN company t79 ON t79.user_id = t0.id LEFT JOIN school t109 ON t109.user_id = t0.id WHERE t0.phone = '+254742542970' LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.valid AS valid_2,
  r0_.iso_code AS iso_code_3,
  r0_.phone_code AS phone_code_4,
  r0_.phone_digit AS phone_digit_5,
  r0_.id_country AS id_country_6,
  r0_.id_currency AS id_currency_7
FROM
  region r0_
WHERE
  r0_.valid = 1
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.valid AS valid_2, r0_.iso_code AS iso_code_3, r0_.phone_code AS phone_code_4, r0_.phone_digit AS phone_digit_5, r0_.id_country AS id_country_6, r0_.id_currency AS id_currency_7 FROM region r0_ WHERE r0_.valid = 1 ORDER BY r0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.valid AS valid_1,
  c0_.name AS name_2,
  c0_.iso_code AS iso_code_3,
  c0_.phone_code AS phone_code_4,
  c0_.phone_digit AS phone_digit_5,
  c0_.id_currency AS id_currency_6
FROM
  country c0_
WHERE
  c0_.valid = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.valid AS valid_1, c0_.name AS name_2, c0_.iso_code AS iso_code_3, c0_.phone_code AS phone_code_4, c0_.phone_digit AS phone_digit_5, c0_.id_currency AS id_currency_6 FROM country c0_ WHERE c0_.valid = 1 ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.id_region AS id_region_3
FROM
  prefecture t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id = 1;

SELECT
  s0_.id AS id_0,
  s0_.created_date AS created_date_1,
  s0_.updated_date AS updated_date_2,
  s0_.client_updated_date AS client_updated_date_3,
  s0_.name AS name_4,
  s0_.type AS type_5,
  s0_.agree_rgpd AS agree_rgpd_6,
  s0_.description AS description_7,
  s0_.address_number AS address_number_8,
  s0_.address_locality AS address_locality_9,
  s0_.address_road AS address_road_10,
  s0_.phone_standard AS phone_standard_11,
  s0_.phone_other AS phone_other_12,
  s0_.email AS email_13,
  s0_.latitude AS latitude_14,
  s0_.longitude AS longitude_15,
  s0_.maps_address AS maps_address_16,
  s0_.other_activity1 AS other_activity1_17,
  s0_.other_activity2 AS other_activity2_18,
  s0_.other_activity3 AS other_activity3_19,
  s0_.other_activity4 AS other_activity4_20,
  s0_.other_activity5 AS other_activity5_21,
  s0_.other_activity6 AS other_activity6_22,
  s0_.registration AS registration_23,
  s0_.other_degree AS other_degree_24,
  s0_.location_mode AS location_mode_25,
  s0_.id_city AS id_city_26,
  s0_.id_region AS id_region_27,
  s0_.id_country AS id_country_28,
  s0_.id_image AS id_image_29,
  s0_.user_id AS user_id_30,
  s0_.id_sector_area1 AS id_sector_area1_31,
  s0_.id_sector_area2 AS id_sector_area2_32,
  s0_.id_sector_area3 AS id_sector_area3_33,
  s0_.id_sector_area4 AS id_sector_area4_34,
  s0_.id_sector_area5 AS id_sector_area5_35,
  s0_.id_sector_area6 AS id_sector_area6_36
FROM
  school s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.created_date AS created_date_1, s0_.updated_date AS updated_date_2, s0_.client_updated_date AS client_updated_date_3, s0_.name AS name_4, s0_.type AS type_5, s0_.agree_rgpd AS agree_rgpd_6, s0_.description AS description_7, s0_.address_number AS address_number_8, s0_.address_locality AS address_locality_9, s0_.address_road AS address_road_10, s0_.phone_standard AS phone_standard_11, s0_.phone_other AS phone_other_12, s0_.email AS email_13, s0_.latitude AS latitude_14, s0_.longitude AS longitude_15, s0_.maps_address AS maps_address_16, s0_.other_activity1 AS other_activity1_17, s0_.other_activity2 AS other_activity2_18, s0_.other_activity3 AS other_activity3_19, s0_.other_activity4 AS other_activity4_20, s0_.other_activity5 AS other_activity5_21, s0_.other_activity6 AS other_activity6_22, s0_.registration AS registration_23, s0_.other_degree AS other_degree_24, s0_.location_mode AS location_mode_25, s0_.id_city AS id_city_26, s0_.id_region AS id_region_27, s0_.id_country AS id_country_28, s0_.id_image AS id_image_29, s0_.user_id AS user_id_30, s0_.id_sector_area1 AS id_sector_area1_31, s0_.id_sector_area2 AS id_sector_area2_32, s0_.id_sector_area3 AS id_sector_area3_33, s0_.id_sector_area4 AS id_sector_area4_34, s0_.id_sector_area5 AS id_sector_area5_35, s0_.id_sector_area6 AS id_sector_area6_36 FROM school s0_ ORDER BY s0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.post_code AS post_code_2,
  c0_.is_capital AS is_capital_3,
  c0_.is_prefecture_capital AS is_prefecture_capital_4,
  c0_.id_region AS id_region_5,
  c0_.prefecture_id AS prefecture_id_6
FROM
  city c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.post_code AS post_code_2, c0_.is_capital AS is_capital_3, c0_.is_prefecture_capital AS is_prefecture_capital_4, c0_.id_region AS id_region_5, c0_.prefecture_id AS prefecture_id_6 FROM city c0_;

SELECT
  r0_.id AS id_0,
  r0_.role AS role_1,
  r0_.pseudo AS pseudo_2
FROM
  role r0_
ORDER BY
  r0_.pseudo ASC

SELECT r0_.id AS id_0, r0_.role AS role_1, r0_.pseudo AS pseudo_2 FROM role r0_ ORDER BY r0_.pseudo ASC;

SELECT
  c0_.id AS id_0,
  c0_.valid AS valid_1,
  c0_.name AS name_2,
  c0_.iso_code AS iso_code_3,
  c0_.phone_code AS phone_code_4,
  c0_.phone_digit AS phone_digit_5,
  c0_.id_currency AS id_currency_6
FROM
  country c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.valid AS valid_1, c0_.name AS name_2, c0_.iso_code AS iso_code_3, c0_.phone_code AS phone_code_4, c0_.phone_digit AS phone_digit_5, c0_.id_currency AS id_currency_6 FROM country c0_ ORDER BY c0_.name ASC;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.valid AS valid_2,
  r0_.iso_code AS iso_code_3,
  r0_.phone_code AS phone_code_4,
  r0_.phone_digit AS phone_digit_5,
  r0_.id_country AS id_country_6,
  r0_.id_currency AS id_currency_7
FROM
  region r0_

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.valid AS valid_2, r0_.iso_code AS iso_code_3, r0_.phone_code AS phone_code_4, r0_.phone_digit AS phone_digit_5, r0_.id_country AS id_country_6, r0_.id_currency AS id_currency_7 FROM region r0_;