Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.post_code AS post_code_3,
  t0.is_capital AS is_capital_4,
  t0.is_prefecture_capital AS is_prefecture_capital_5,
  t0.id_region AS id_region_6,
  t0.prefecture_id AS prefecture_id_7
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.post_code AS post_code_3, t0.is_capital AS is_capital_4, t0.is_prefecture_capital AS is_prefecture_capital_5, t0.id_region AS id_region_6, t0.prefecture_id AS prefecture_id_7 FROM city t0 WHERE t0.id = 650;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.id_sectorArea AS id_sectorArea_4
FROM
  activity t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.id_sectorArea AS id_sectorArea_4 FROM activity t0;

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.id = ?

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.id = 21170;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.description AS description_2,
  d0_.level AS level_3,
  d0_.activity_id AS activity_id_4
FROM
  degree d0_

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.level AS level_3, d0_.activity_id AS activity_id_4 FROM degree d0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2
FROM
  sector_area s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2 FROM sector_area s0_ ORDER BY s0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.url AS url_2,
  c0_.created_date AS created_date_3,
  c0_.updated_date AS updated_date_4,
  c0_.client_updated_date AS client_updated_date_5,
  c0_.other_city AS other_city_6,
  c0_.address_number AS address_number_7,
  c0_.address_locality AS address_locality_8,
  c0_.address_road AS address_road_9,
  c0_.phone_standard AS phone_standard_10,
  c0_.phone_other AS phone_other_11,
  c0_.email AS email_12,
  c0_.temporary_passwd AS temporary_passwd_13,
  c0_.latitude AS latitude_14,
  c0_.longitude AS longitude_15,
  c0_.maps_address AS maps_address_16,
  c0_.location_fixed AS location_fixed_17,
  c0_.agree_rgpd AS agree_rgpd_18,
  c0_.location_mode AS location_mode_19,
  c0_.unlocked AS unlocked_20,
  c0_.id_city AS id_city_21,
  c0_.id_region AS id_region_22,
  c0_.id_country AS id_country_23,
  c0_.id_contactCompany AS id_contactCompany_24,
  c0_.id_sectorArea AS id_sectorArea_25,
  c0_.id_legal_status AS id_legal_status_26,
  c0_.user_id AS user_id_27,
  c0_.id_image AS id_image_28
FROM
  company c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.url AS url_2, c0_.created_date AS created_date_3, c0_.updated_date AS updated_date_4, c0_.client_updated_date AS client_updated_date_5, c0_.other_city AS other_city_6, c0_.address_number AS address_number_7, c0_.address_locality AS address_locality_8, c0_.address_road AS address_road_9, c0_.phone_standard AS phone_standard_10, c0_.phone_other AS phone_other_11, c0_.email AS email_12, c0_.temporary_passwd AS temporary_passwd_13, c0_.latitude AS latitude_14, c0_.longitude AS longitude_15, c0_.maps_address AS maps_address_16, c0_.location_fixed AS location_fixed_17, c0_.agree_rgpd AS agree_rgpd_18, c0_.location_mode AS location_mode_19, c0_.unlocked AS unlocked_20, c0_.id_city AS id_city_21, c0_.id_region AS id_region_22, c0_.id_country AS id_country_23, c0_.id_contactCompany AS id_contactCompany_24, c0_.id_sectorArea AS id_sectorArea_25, c0_.id_legal_status AS id_legal_status_26, c0_.user_id AS user_id_27, c0_.id_image AS id_image_28 FROM company c0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2
FROM
  contract c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2 FROM contract c0_;

SELECT
  t0.id AS id_1,
  t0.created_date AS created_date_2,
  t0.updated_date AS updated_date_3,
  t0.client_updated_date AS client_updated_date_4,
  t0.name AS name_5,
  t0.type AS type_6,
  t0.agree_rgpd AS agree_rgpd_7,
  t0.description AS description_8,
  t0.address_number AS address_number_9,
  t0.address_locality AS address_locality_10,
  t0.address_road AS address_road_11,
  t0.phone_standard AS phone_standard_12,
  t0.phone_other AS phone_other_13,
  t0.email AS email_14,
  t0.latitude AS latitude_15,
  t0.longitude AS longitude_16,
  t0.maps_address AS maps_address_17,
  t0.other_activity1 AS other_activity1_18,
  t0.other_activity2 AS other_activity2_19,
  t0.other_activity3 AS other_activity3_20,
  t0.other_activity4 AS other_activity4_21,
  t0.other_activity5 AS other_activity5_22,
  t0.other_activity6 AS other_activity6_23,
  t0.registration AS registration_24,
  t0.other_degree AS other_degree_25,
  t0.location_mode AS location_mode_26,
  t0.id_city AS id_city_27,
  t0.id_region AS id_region_28,
  t0.id_country AS id_country_29,
  t0.id_image AS id_image_30,
  t0.user_id AS user_id_31,
  t0.id_sector_area1 AS id_sector_area1_32,
  t0.id_sector_area2 AS id_sector_area2_33,
  t0.id_sector_area3 AS id_sector_area3_34,
  t0.id_sector_area4 AS id_sector_area4_35,
  t0.id_sector_area5 AS id_sector_area5_36,
  t0.id_sector_area6 AS id_sector_area6_37
FROM
  school t0
WHERE
  t0.id_region = ?

SELECT t0.id AS id_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.client_updated_date AS client_updated_date_4, t0.name AS name_5, t0.type AS type_6, t0.agree_rgpd AS agree_rgpd_7, t0.description AS description_8, t0.address_number AS address_number_9, t0.address_locality AS address_locality_10, t0.address_road AS address_road_11, t0.phone_standard AS phone_standard_12, t0.phone_other AS phone_other_13, t0.email AS email_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.maps_address AS maps_address_17, t0.other_activity1 AS other_activity1_18, t0.other_activity2 AS other_activity2_19, t0.other_activity3 AS other_activity3_20, t0.other_activity4 AS other_activity4_21, t0.other_activity5 AS other_activity5_22, t0.other_activity6 AS other_activity6_23, t0.registration AS registration_24, t0.other_degree AS other_degree_25, t0.location_mode AS location_mode_26, t0.id_city AS id_city_27, t0.id_region AS id_region_28, t0.id_country AS id_country_29, t0.id_image AS id_image_30, t0.user_id AS user_id_31, t0.id_sector_area1 AS id_sector_area1_32, t0.id_sector_area2 AS id_sector_area2_33, t0.id_sector_area3 AS id_sector_area3_34, t0.id_sector_area4 AS id_sector_area4_35, t0.id_sector_area5 AS id_sector_area5_36, t0.id_sector_area6 AS id_sector_area6_37 FROM school t0 WHERE t0.id_region = 174;

SELECT
  t0.id AS id_1,
  t0.valid AS valid_2,
  t0.name AS name_3,
  t0.iso_code AS iso_code_4,
  t0.phone_code AS phone_code_5,
  t0.phone_digit AS phone_digit_6,
  t0.id_currency AS id_currency_7
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valid AS valid_2, t0.name AS name_3, t0.iso_code AS iso_code_4, t0.phone_code AS phone_code_5, t0.phone_digit AS phone_digit_6, t0.id_currency AS id_currency_7 FROM country t0 WHERE t0.id = 29;

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_
WHERE
  s0_.id_country = '29'
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_ WHERE s0_.id_country = '29' ORDER BY s0_.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
  AND c0_.id IN (?)
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 AND c0_.id IN ('29') ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.phone_code AS phone_code_1,
  c0_.phone_digit AS phone_digit_2
FROM
  country c0_
WHERE
  c0_.id <> ?

SELECT c0_.id AS id_0, c0_.phone_code AS phone_code_1, c0_.phone_digit AS phone_digit_2 FROM country c0_ WHERE c0_.id <> 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.post_code AS post_code_3,
  t0.is_capital AS is_capital_4,
  t0.is_prefecture_capital AS is_prefecture_capital_5,
  t0.id_region AS id_region_6,
  t0.prefecture_id AS prefecture_id_7
FROM
  city t0
WHERE
  t0.id_region = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.post_code AS post_code_3, t0.is_capital AS is_capital_4, t0.is_prefecture_capital AS is_prefecture_capital_5, t0.id_region AS id_region_6, t0.prefecture_id AS prefecture_id_7 FROM city t0 WHERE t0.id_region = 174;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.valid AS valid_3,
  t0.iso_code AS iso_code_4,
  t0.phone_code AS phone_code_5,
  t0.phone_digit AS phone_digit_6,
  t0.id_country AS id_country_7,
  t0.id_currency AS id_currency_8
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.valid AS valid_3, t0.iso_code AS iso_code_4, t0.phone_code AS phone_code_5, t0.phone_digit AS phone_digit_6, t0.id_country AS id_country_7, t0.id_currency AS id_currency_8 FROM region t0 WHERE t0.id = 174;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.url AS url_2
FROM
  image i0_

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.url AS url_2 FROM image i0_;

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.role AS role_2,
  t0.pseudo AS pseudo_3
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.pseudo AS pseudo_3 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 21170;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.valid AS valid_3,
  t0.iso_code AS iso_code_4,
  t0.phone_code AS phone_code_5,
  t0.phone_digit AS phone_digit_6,
  t0.id_country AS id_country_7,
  t0.id_currency AS id_currency_8
FROM
  region t0
WHERE
  t0.id_country = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.valid AS valid_3, t0.iso_code AS iso_code_4, t0.phone_code AS phone_code_5, t0.phone_digit AS phone_digit_6, t0.id_country AS id_country_7, t0.id_currency AS id_currency_8 FROM region t0 WHERE t0.id_country = 29;

SELECT
  r0_.id AS id_0,
  r0_.phone_code AS phone_code_1,
  r0_.phone_digit AS phone_digit_2
FROM
  region r0_
WHERE
  r0_.id <> ?

SELECT r0_.id AS id_0, r0_.phone_code AS phone_code_1, r0_.phone_digit AS phone_digit_2 FROM region r0_ WHERE r0_.id <> 29;

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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.id_region AS id_region_2
FROM
  prefecture p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.id_region AS id_region_2 FROM prefecture p0_ ORDER BY p0_.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 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;