Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4,
  t5.id AS id_6,
  t5.postcode AS postcode_7,
  t5.slug AS slug_8,
  t5.lat AS lat_9,
  t5.lng AS lng_10,
  t5.country_id AS country_id_11
FROM
  cities_translation t0
  LEFT JOIN cities t5 ON t0.translatable_id = t5.id
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36721;

SELECT
  t0.id AS id_1,
  t0.postcode AS postcode_2,
  t0.slug AS slug_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5,
  t0.country_id AS country_id_6
FROM
  cities t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = 36721;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.reference AS reference_2,
  t0_.slug AS slug_3,
  t0_.intro AS intro_4,
  t0_.description AS description_5,
  t0_.start_date AS start_date_6,
  t0_.end_date AS end_date_7,
  t0_.published_at AS published_at_8,
  t0_.closed_at AS closed_at_9,
  t0_.cancelled_at AS cancelled_at_10,
  t0_.status AS status_11,
  t0_.permanent AS permanent_12,
  t0_.partners AS partners_13,
  t0_.created_at AS created_at_14,
  t0_.updated_at AS updated_at_15,
  t1_.id AS id_16,
  t1_.name AS name_17,
  t1_.email AS email_18,
  t1_.phone AS phone_19,
  t1_.phone_two AS phone_two_20,
  t1_.phone_three AS phone_three_21,
  t1_.manager AS manager_22,
  t1_.license_number AS license_number_23,
  t1_.website AS website_24,
  t1_.facebook AS facebook_25,
  t1_.twitter AS twitter_26,
  t1_.instagram AS instagram_27,
  t1_.youtube AS youtube_28,
  p2_.id AS id_29,
  p2_.name AS name_30,
  p2_.description AS description_31,
  p2_.address AS address_32,
  p2_.additional_address AS additional_address_33,
  p2_.postcode AS postcode_34,
  p2_.identify_number AS identify_number_35,
  p2_.website AS website_36,
  p2_.prepaid_amount AS prepaid_amount_37,
  p2_.sponsor_code AS sponsor_code_38,
  p2_.sponsor_points AS sponsor_points_39,
  p2_.reference AS reference_40,
  p2_.sepa_name AS sepa_name_41,
  p2_.population AS population_42,
  p2_.typology AS typology_43,
  p2_.is_rdc AS is_rdc_44,
  p2_.is_contract_historic AS is_contract_historic_45,
  p2_.collectivity_service_code AS collectivity_service_code_46,
  p2_.is_number_ej AS is_number_ej_47,
  p2_.demo AS demo_48,
  p2_.vat AS vat_49,
  p2_.logo AS logo_50,
  p2_.is_data_different_invoice AS is_data_different_invoice_51,
  p2_.other_name AS other_name_52,
  p2_.other_address AS other_address_53,
  p2_.other_identify_number AS other_identify_number_54,
  p2_.manual_renewal AS manual_renewal_55,
  p2_.testimony_answered AS testimony_answered_56,
  p2_.is_cmd AS is_cmd_57,
  p2_.notes AS notes_58,
  p2_.date_invitation_ceo_interview AS date_invitation_ceo_interview_59,
  p2_.date_ceo_interview AS date_ceo_interview_60,
  p2_.top_ranking AS top_ranking_61,
  p2_.rdc_feeling AS rdc_feeling_62,
  p2_.created_at AS created_at_63,
  p2_.updated_at AS updated_at_64,
  p2_.deleted_at AS deleted_at_65,
  p2_.lat AS lat_66,
  p2_.lng AS lng_67,
  t0_.project_id AS project_id_68,
  t0_.promoter_id AS promoter_id_69,
  t0_.category_id AS category_id_70,
  t0_.thumbnail_id AS thumbnail_id_71,
  t0_.structure_id AS structure_id_72,
  t1_.logo_id AS logo_id_73,
  t1_.project_id AS project_id_74,
  p2_.type_id AS type_id_75,
  p2_.category_id AS category_id_76,
  p2_.city_id AS city_id_77,
  p2_.user_id AS user_id_78,
  p2_.othet_city_id AS othet_city_id_79,
  p2_.intercommunality_id AS intercommunality_id_80,
  p2_.attachments AS attachments_81
FROM
  tk_events t0_
  LEFT JOIN tk_promoters t1_ ON t0_.promoter_id = t1_.id
  INNER JOIN projects p2_ ON t0_.project_id = p2_.id
WHERE
  t0_.project_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.start_date DESC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.reference AS reference_2, t0_.slug AS slug_3, t0_.intro AS intro_4, t0_.description AS description_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.published_at AS published_at_8, t0_.closed_at AS closed_at_9, t0_.cancelled_at AS cancelled_at_10, t0_.status AS status_11, t0_.permanent AS permanent_12, t0_.partners AS partners_13, t0_.created_at AS created_at_14, t0_.updated_at AS updated_at_15, t1_.id AS id_16, t1_.name AS name_17, t1_.email AS email_18, t1_.phone AS phone_19, t1_.phone_two AS phone_two_20, t1_.phone_three AS phone_three_21, t1_.manager AS manager_22, t1_.license_number AS license_number_23, t1_.website AS website_24, t1_.facebook AS facebook_25, t1_.twitter AS twitter_26, t1_.instagram AS instagram_27, t1_.youtube AS youtube_28, p2_.id AS id_29, p2_.name AS name_30, p2_.description AS description_31, p2_.address AS address_32, p2_.additional_address AS additional_address_33, p2_.postcode AS postcode_34, p2_.identify_number AS identify_number_35, p2_.website AS website_36, p2_.prepaid_amount AS prepaid_amount_37, p2_.sponsor_code AS sponsor_code_38, p2_.sponsor_points AS sponsor_points_39, p2_.reference AS reference_40, p2_.sepa_name AS sepa_name_41, p2_.population AS population_42, p2_.typology AS typology_43, p2_.is_rdc AS is_rdc_44, p2_.is_contract_historic AS is_contract_historic_45, p2_.collectivity_service_code AS collectivity_service_code_46, p2_.is_number_ej AS is_number_ej_47, p2_.demo AS demo_48, p2_.vat AS vat_49, p2_.logo AS logo_50, p2_.is_data_different_invoice AS is_data_different_invoice_51, p2_.other_name AS other_name_52, p2_.other_address AS other_address_53, p2_.other_identify_number AS other_identify_number_54, p2_.manual_renewal AS manual_renewal_55, p2_.testimony_answered AS testimony_answered_56, p2_.is_cmd AS is_cmd_57, p2_.notes AS notes_58, p2_.date_invitation_ceo_interview AS date_invitation_ceo_interview_59, p2_.date_ceo_interview AS date_ceo_interview_60, p2_.top_ranking AS top_ranking_61, p2_.rdc_feeling AS rdc_feeling_62, p2_.created_at AS created_at_63, p2_.updated_at AS updated_at_64, p2_.deleted_at AS deleted_at_65, p2_.lat AS lat_66, p2_.lng AS lng_67, t0_.project_id AS project_id_68, t0_.promoter_id AS promoter_id_69, t0_.category_id AS category_id_70, t0_.thumbnail_id AS thumbnail_id_71, t0_.structure_id AS structure_id_72, t1_.logo_id AS logo_id_73, t1_.project_id AS project_id_74, p2_.type_id AS type_id_75, p2_.category_id AS category_id_76, p2_.city_id AS city_id_77, p2_.user_id AS user_id_78, p2_.othet_city_id AS othet_city_id_79, p2_.intercommunality_id AS intercommunality_id_80, p2_.attachments AS attachments_81 FROM tk_events t0_ LEFT JOIN tk_promoters t1_ ON t0_.promoter_id = t1_.id INNER JOIN projects p2_ ON t0_.project_id = p2_.id WHERE t0_.project_id = 4719 AND t0_.status = 1 ORDER BY t0_.start_date DESC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.slug AS slug_3,
  t0_.phone AS phone_4,
  t0_.phone_two AS phone_two_5,
  t0_.phone_three AS phone_three_6,
  t0_.representative_name AS representative_name_7,
  t0_.identify_number AS identify_number_8,
  t0_.bank_iban AS bank_iban_9,
  t0_.bank_bic AS bank_bic_10,
  t0_.bank_holder AS bank_holder_11,
  t0_.available_vat AS available_vat_12,
  t0_.address AS address_13,
  t0_.contact_email AS contact_email_14,
  t0_.website AS website_15,
  t0_.facebook AS facebook_16,
  t0_.twitter AS twitter_17,
  t0_.instagram AS instagram_18,
  t0_.youtube AS youtube_19,
  t0_.status AS status_20,
  t0_.sales_terms AS sales_terms_21,
  t0_.is_public AS is_public_22,
  t0_.opened_at AS opened_at_23,
  t0_.closing_text AS closing_text_24,
  t0_.google_analytics AS google_analytics_25,
  p1_.id AS id_26,
  p1_.name AS name_27,
  p1_.description AS description_28,
  p1_.address AS address_29,
  p1_.additional_address AS additional_address_30,
  p1_.postcode AS postcode_31,
  p1_.identify_number AS identify_number_32,
  p1_.website AS website_33,
  p1_.prepaid_amount AS prepaid_amount_34,
  p1_.sponsor_code AS sponsor_code_35,
  p1_.sponsor_points AS sponsor_points_36,
  p1_.reference AS reference_37,
  p1_.sepa_name AS sepa_name_38,
  p1_.population AS population_39,
  p1_.typology AS typology_40,
  p1_.is_rdc AS is_rdc_41,
  p1_.is_contract_historic AS is_contract_historic_42,
  p1_.collectivity_service_code AS collectivity_service_code_43,
  p1_.is_number_ej AS is_number_ej_44,
  p1_.demo AS demo_45,
  p1_.vat AS vat_46,
  p1_.logo AS logo_47,
  p1_.is_data_different_invoice AS is_data_different_invoice_48,
  p1_.other_name AS other_name_49,
  p1_.other_address AS other_address_50,
  p1_.other_identify_number AS other_identify_number_51,
  p1_.manual_renewal AS manual_renewal_52,
  p1_.testimony_answered AS testimony_answered_53,
  p1_.is_cmd AS is_cmd_54,
  p1_.notes AS notes_55,
  p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_56,
  p1_.date_ceo_interview AS date_ceo_interview_57,
  p1_.top_ranking AS top_ranking_58,
  p1_.rdc_feeling AS rdc_feeling_59,
  p1_.created_at AS created_at_60,
  p1_.updated_at AS updated_at_61,
  p1_.deleted_at AS deleted_at_62,
  p1_.lat AS lat_63,
  p1_.lng AS lng_64,
  t0_.logo_id AS logo_id_65,
  t0_.city_id AS city_id_66,
  t0_.project_id AS project_id_67,
  p1_.type_id AS type_id_68,
  p1_.category_id AS category_id_69,
  p1_.city_id AS city_id_70,
  p1_.user_id AS user_id_71,
  p1_.othet_city_id AS othet_city_id_72,
  p1_.intercommunality_id AS intercommunality_id_73,
  p1_.attachments AS attachments_74
FROM
  tk_structures t0_
  INNER JOIN projects p1_ ON t0_.project_id = p1_.id
WHERE
  t0_.id = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.phone AS phone_4, t0_.phone_two AS phone_two_5, t0_.phone_three AS phone_three_6, t0_.representative_name AS representative_name_7, t0_.identify_number AS identify_number_8, t0_.bank_iban AS bank_iban_9, t0_.bank_bic AS bank_bic_10, t0_.bank_holder AS bank_holder_11, t0_.available_vat AS available_vat_12, t0_.address AS address_13, t0_.contact_email AS contact_email_14, t0_.website AS website_15, t0_.facebook AS facebook_16, t0_.twitter AS twitter_17, t0_.instagram AS instagram_18, t0_.youtube AS youtube_19, t0_.status AS status_20, t0_.sales_terms AS sales_terms_21, t0_.is_public AS is_public_22, t0_.opened_at AS opened_at_23, t0_.closing_text AS closing_text_24, t0_.google_analytics AS google_analytics_25, p1_.id AS id_26, p1_.name AS name_27, p1_.description AS description_28, p1_.address AS address_29, p1_.additional_address AS additional_address_30, p1_.postcode AS postcode_31, p1_.identify_number AS identify_number_32, p1_.website AS website_33, p1_.prepaid_amount AS prepaid_amount_34, p1_.sponsor_code AS sponsor_code_35, p1_.sponsor_points AS sponsor_points_36, p1_.reference AS reference_37, p1_.sepa_name AS sepa_name_38, p1_.population AS population_39, p1_.typology AS typology_40, p1_.is_rdc AS is_rdc_41, p1_.is_contract_historic AS is_contract_historic_42, p1_.collectivity_service_code AS collectivity_service_code_43, p1_.is_number_ej AS is_number_ej_44, p1_.demo AS demo_45, p1_.vat AS vat_46, p1_.logo AS logo_47, p1_.is_data_different_invoice AS is_data_different_invoice_48, p1_.other_name AS other_name_49, p1_.other_address AS other_address_50, p1_.other_identify_number AS other_identify_number_51, p1_.manual_renewal AS manual_renewal_52, p1_.testimony_answered AS testimony_answered_53, p1_.is_cmd AS is_cmd_54, p1_.notes AS notes_55, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_56, p1_.date_ceo_interview AS date_ceo_interview_57, p1_.top_ranking AS top_ranking_58, p1_.rdc_feeling AS rdc_feeling_59, p1_.created_at AS created_at_60, p1_.updated_at AS updated_at_61, p1_.deleted_at AS deleted_at_62, p1_.lat AS lat_63, p1_.lng AS lng_64, t0_.logo_id AS logo_id_65, t0_.city_id AS city_id_66, t0_.project_id AS project_id_67, p1_.type_id AS type_id_68, p1_.category_id AS category_id_69, p1_.city_id AS city_id_70, p1_.user_id AS user_id_71, p1_.othet_city_id AS othet_city_id_72, p1_.intercommunality_id AS intercommunality_id_73, p1_.attachments AS attachments_74 FROM tk_structures t0_ INNER JOIN projects p1_ ON t0_.project_id = p1_.id WHERE t0_.id = 140 ORDER BY t0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.vat_information AS vat_information_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5,
  t6.id AS id_7,
  t6.iso_code AS iso_code_8,
  t6.call_prefix AS call_prefix_9,
  t6.need_zip_code AS need_zip_code_10,
  t6.zip_code_format AS zip_code_format_11,
  t6.display_tax_label AS display_tax_label_12,
  t6.vat AS vat_13,
  t6.enabled AS enabled_14,
  t6.zone_id AS zone_id_15,
  t6.currency_id AS currency_id_16
FROM
  countries_translation t0
  LEFT JOIN countries t6 ON t0.translatable_id = t6.id
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.vat_information AS vat_information_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.id AS id_7, t6.iso_code AS iso_code_8, t6.call_prefix AS call_prefix_9, t6.need_zip_code AS need_zip_code_10, t6.zip_code_format AS zip_code_format_11, t6.display_tax_label AS display_tax_label_12, t6.vat AS vat_13, t6.enabled AS enabled_14, t6.zone_id AS zone_id_15, t6.currency_id AS currency_id_16 FROM countries_translation t0 LEFT JOIN countries t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 8;

SELECT
  t0.id AS id_1,
  t0.iso_code AS iso_code_2,
  t0.call_prefix AS call_prefix_3,
  t0.need_zip_code AS need_zip_code_4,
  t0.zip_code_format AS zip_code_format_5,
  t0.display_tax_label AS display_tax_label_6,
  t0.vat AS vat_7,
  t0.enabled AS enabled_8,
  t0.zone_id AS zone_id_9,
  t0.currency_id AS currency_id_10
FROM
  countries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.iso_code AS iso_code_2, t0.call_prefix AS call_prefix_3, t0.need_zip_code AS need_zip_code_4, t0.zip_code_format AS zip_code_format_5, t0.display_tax_label AS display_tax_label_6, t0.vat AS vat_7, t0.enabled AS enabled_8, t0.zone_id AS zone_id_9, t0.currency_id AS currency_id_10 FROM countries t0 WHERE t0.id = 8;