Symfony Profiler

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_.reference AS reference_18,
  t1_.description AS description_19,
  t1_.vat AS vat_20,
  t1_.date AS date_21,
  t1_.start_time AS start_time_22,
  t1_.end_time AS end_time_23,
  t1_.address AS address_24,
  t1_.type AS type_25,
  t1_.ticket_information AS ticket_information_26,
  t1_.ticket_instruction AS ticket_instruction_27,
  t1_.capacity AS capacity_28,
  t1_.status AS status_29,
  t1_.published_at AS published_at_30,
  t1_.closed_at AS closed_at_31,
  t1_.cancelled_at AS cancelled_at_32,
  t1_.recurrence_week_days AS recurrence_week_days_33,
  t1_.start_date AS start_date_34,
  t1_.end_date AS end_date_35,
  t1_.created_at AS created_at_36,
  t1_.updated_at AS updated_at_37,
  t1_.lat AS lat_38,
  t1_.lng AS lng_39,
  t2_.id AS id_40,
  t2_.name AS name_41,
  t2_.email AS email_42,
  t2_.phone AS phone_43,
  t2_.phone_two AS phone_two_44,
  t2_.phone_three AS phone_three_45,
  t2_.manager AS manager_46,
  t2_.license_number AS license_number_47,
  t2_.website AS website_48,
  t2_.facebook AS facebook_49,
  t2_.twitter AS twitter_50,
  t2_.instagram AS instagram_51,
  t2_.youtube AS youtube_52,
  p3_.id AS id_53,
  p3_.name AS name_54,
  p3_.description AS description_55,
  p3_.address AS address_56,
  p3_.additional_address AS additional_address_57,
  p3_.postcode AS postcode_58,
  p3_.identify_number AS identify_number_59,
  p3_.website AS website_60,
  p3_.prepaid_amount AS prepaid_amount_61,
  p3_.sponsor_code AS sponsor_code_62,
  p3_.sponsor_points AS sponsor_points_63,
  p3_.reference AS reference_64,
  p3_.sepa_name AS sepa_name_65,
  p3_.population AS population_66,
  p3_.typology AS typology_67,
  p3_.is_rdc AS is_rdc_68,
  p3_.is_contract_historic AS is_contract_historic_69,
  p3_.collectivity_service_code AS collectivity_service_code_70,
  p3_.is_number_ej AS is_number_ej_71,
  p3_.demo AS demo_72,
  p3_.vat AS vat_73,
  p3_.logo AS logo_74,
  p3_.is_data_different_invoice AS is_data_different_invoice_75,
  p3_.other_name AS other_name_76,
  p3_.other_address AS other_address_77,
  p3_.other_identify_number AS other_identify_number_78,
  p3_.manual_renewal AS manual_renewal_79,
  p3_.testimony_answered AS testimony_answered_80,
  p3_.is_cmd AS is_cmd_81,
  p3_.notes AS notes_82,
  p3_.date_invitation_ceo_interview AS date_invitation_ceo_interview_83,
  p3_.date_ceo_interview AS date_ceo_interview_84,
  p3_.top_ranking AS top_ranking_85,
  p3_.rdc_feeling AS rdc_feeling_86,
  p3_.created_at AS created_at_87,
  p3_.updated_at AS updated_at_88,
  p3_.deleted_at AS deleted_at_89,
  p3_.lat AS lat_90,
  p3_.lng AS lng_91,
  t0_.project_id AS project_id_92,
  t0_.promoter_id AS promoter_id_93,
  t0_.category_id AS category_id_94,
  t0_.thumbnail_id AS thumbnail_id_95,
  t0_.structure_id AS structure_id_96,
  t1_.city_id AS city_id_97,
  t1_.plan_id AS plan_id_98,
  t1_.thumbnail_id AS thumbnail_id_99,
  t1_.event_id AS event_id_100,
  t2_.logo_id AS logo_id_101,
  t2_.project_id AS project_id_102,
  p3_.type_id AS type_id_103,
  p3_.category_id AS category_id_104,
  p3_.city_id AS city_id_105,
  p3_.user_id AS user_id_106,
  p3_.othet_city_id AS othet_city_id_107,
  p3_.intercommunality_id AS intercommunality_id_108,
  p3_.attachments AS attachments_109
FROM
  tk_events t0_
  LEFT JOIN tk_seances t1_ ON t0_.id = t1_.event_id
  LEFT JOIN tk_promoters t2_ ON t0_.promoter_id = t2_.id
  INNER JOIN projects p3_ ON t0_.project_id = p3_.id
WHERE
  t0_.id = ?
ORDER BY
  t1_.date ASC,
  t1_.start_time ASC,
  t1_.end_time ASC

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_.reference AS reference_18, t1_.description AS description_19, t1_.vat AS vat_20, t1_.date AS date_21, t1_.start_time AS start_time_22, t1_.end_time AS end_time_23, t1_.address AS address_24, t1_.type AS type_25, t1_.ticket_information AS ticket_information_26, t1_.ticket_instruction AS ticket_instruction_27, t1_.capacity AS capacity_28, t1_.status AS status_29, t1_.published_at AS published_at_30, t1_.closed_at AS closed_at_31, t1_.cancelled_at AS cancelled_at_32, t1_.recurrence_week_days AS recurrence_week_days_33, t1_.start_date AS start_date_34, t1_.end_date AS end_date_35, t1_.created_at AS created_at_36, t1_.updated_at AS updated_at_37, t1_.lat AS lat_38, t1_.lng AS lng_39, t2_.id AS id_40, t2_.name AS name_41, t2_.email AS email_42, t2_.phone AS phone_43, t2_.phone_two AS phone_two_44, t2_.phone_three AS phone_three_45, t2_.manager AS manager_46, t2_.license_number AS license_number_47, t2_.website AS website_48, t2_.facebook AS facebook_49, t2_.twitter AS twitter_50, t2_.instagram AS instagram_51, t2_.youtube AS youtube_52, p3_.id AS id_53, p3_.name AS name_54, p3_.description AS description_55, p3_.address AS address_56, p3_.additional_address AS additional_address_57, p3_.postcode AS postcode_58, p3_.identify_number AS identify_number_59, p3_.website AS website_60, p3_.prepaid_amount AS prepaid_amount_61, p3_.sponsor_code AS sponsor_code_62, p3_.sponsor_points AS sponsor_points_63, p3_.reference AS reference_64, p3_.sepa_name AS sepa_name_65, p3_.population AS population_66, p3_.typology AS typology_67, p3_.is_rdc AS is_rdc_68, p3_.is_contract_historic AS is_contract_historic_69, p3_.collectivity_service_code AS collectivity_service_code_70, p3_.is_number_ej AS is_number_ej_71, p3_.demo AS demo_72, p3_.vat AS vat_73, p3_.logo AS logo_74, p3_.is_data_different_invoice AS is_data_different_invoice_75, p3_.other_name AS other_name_76, p3_.other_address AS other_address_77, p3_.other_identify_number AS other_identify_number_78, p3_.manual_renewal AS manual_renewal_79, p3_.testimony_answered AS testimony_answered_80, p3_.is_cmd AS is_cmd_81, p3_.notes AS notes_82, p3_.date_invitation_ceo_interview AS date_invitation_ceo_interview_83, p3_.date_ceo_interview AS date_ceo_interview_84, p3_.top_ranking AS top_ranking_85, p3_.rdc_feeling AS rdc_feeling_86, p3_.created_at AS created_at_87, p3_.updated_at AS updated_at_88, p3_.deleted_at AS deleted_at_89, p3_.lat AS lat_90, p3_.lng AS lng_91, t0_.project_id AS project_id_92, t0_.promoter_id AS promoter_id_93, t0_.category_id AS category_id_94, t0_.thumbnail_id AS thumbnail_id_95, t0_.structure_id AS structure_id_96, t1_.city_id AS city_id_97, t1_.plan_id AS plan_id_98, t1_.thumbnail_id AS thumbnail_id_99, t1_.event_id AS event_id_100, t2_.logo_id AS logo_id_101, t2_.project_id AS project_id_102, p3_.type_id AS type_id_103, p3_.category_id AS category_id_104, p3_.city_id AS city_id_105, p3_.user_id AS user_id_106, p3_.othet_city_id AS othet_city_id_107, p3_.intercommunality_id AS intercommunality_id_108, p3_.attachments AS attachments_109 FROM tk_events t0_ LEFT JOIN tk_seances t1_ ON t0_.id = t1_.event_id LEFT JOIN tk_promoters t2_ ON t0_.promoter_id = t2_.id INNER JOIN projects p3_ ON t0_.project_id = p3_.id WHERE t0_.id = 588 ORDER BY t1_.date ASC, t1_.start_time ASC, t1_.end_time 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_.project_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_.project_id = 4563 ORDER BY t0_.name ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.reference AS reference_2,
  t0_.description AS description_3,
  t0_.vat AS vat_4,
  t0_.date AS date_5,
  t0_.start_time AS start_time_6,
  t0_.end_time AS end_time_7,
  t0_.address AS address_8,
  t0_.type AS type_9,
  t0_.ticket_information AS ticket_information_10,
  t0_.ticket_instruction AS ticket_instruction_11,
  t0_.capacity AS capacity_12,
  t0_.status AS status_13,
  t0_.published_at AS published_at_14,
  t0_.closed_at AS closed_at_15,
  t0_.cancelled_at AS cancelled_at_16,
  t0_.recurrence_week_days AS recurrence_week_days_17,
  t0_.start_date AS start_date_18,
  t0_.end_date AS end_date_19,
  t0_.created_at AS created_at_20,
  t0_.updated_at AS updated_at_21,
  t0_.lat AS lat_22,
  t0_.lng AS lng_23,
  t1_.id AS id_24,
  t1_.name AS name_25,
  t1_.reference AS reference_26,
  t1_.slug AS slug_27,
  t1_.intro AS intro_28,
  t1_.description AS description_29,
  t1_.start_date AS start_date_30,
  t1_.end_date AS end_date_31,
  t1_.published_at AS published_at_32,
  t1_.closed_at AS closed_at_33,
  t1_.cancelled_at AS cancelled_at_34,
  t1_.status AS status_35,
  t1_.permanent AS permanent_36,
  t1_.partners AS partners_37,
  t1_.created_at AS created_at_38,
  t1_.updated_at AS updated_at_39,
  p2_.id AS id_40,
  p2_.name AS name_41,
  p2_.description AS description_42,
  p2_.address AS address_43,
  p2_.additional_address AS additional_address_44,
  p2_.postcode AS postcode_45,
  p2_.identify_number AS identify_number_46,
  p2_.website AS website_47,
  p2_.prepaid_amount AS prepaid_amount_48,
  p2_.sponsor_code AS sponsor_code_49,
  p2_.sponsor_points AS sponsor_points_50,
  p2_.reference AS reference_51,
  p2_.sepa_name AS sepa_name_52,
  p2_.population AS population_53,
  p2_.typology AS typology_54,
  p2_.is_rdc AS is_rdc_55,
  p2_.is_contract_historic AS is_contract_historic_56,
  p2_.collectivity_service_code AS collectivity_service_code_57,
  p2_.is_number_ej AS is_number_ej_58,
  p2_.demo AS demo_59,
  p2_.vat AS vat_60,
  p2_.logo AS logo_61,
  p2_.is_data_different_invoice AS is_data_different_invoice_62,
  p2_.other_name AS other_name_63,
  p2_.other_address AS other_address_64,
  p2_.other_identify_number AS other_identify_number_65,
  p2_.manual_renewal AS manual_renewal_66,
  p2_.testimony_answered AS testimony_answered_67,
  p2_.is_cmd AS is_cmd_68,
  p2_.notes AS notes_69,
  p2_.date_invitation_ceo_interview AS date_invitation_ceo_interview_70,
  p2_.date_ceo_interview AS date_ceo_interview_71,
  p2_.top_ranking AS top_ranking_72,
  p2_.rdc_feeling AS rdc_feeling_73,
  p2_.created_at AS created_at_74,
  p2_.updated_at AS updated_at_75,
  p2_.deleted_at AS deleted_at_76,
  p2_.lat AS lat_77,
  p2_.lng AS lng_78,
  t3_.id AS id_79,
  t3_.name AS name_80,
  t3_.price AS price_81,
  t3_.quantity AS quantity_82,
  t3_.nominative AS nominative_83,
  t3_.sale_type AS sale_type_84,
  t3_.on_counter AS on_counter_85,
  t3_.online AS online_86,
  t0_.city_id AS city_id_87,
  t0_.plan_id AS plan_id_88,
  t0_.thumbnail_id AS thumbnail_id_89,
  t0_.event_id AS event_id_90,
  t1_.project_id AS project_id_91,
  t1_.promoter_id AS promoter_id_92,
  t1_.category_id AS category_id_93,
  t1_.thumbnail_id AS thumbnail_id_94,
  t1_.structure_id AS structure_id_95,
  p2_.type_id AS type_id_96,
  p2_.category_id AS category_id_97,
  p2_.city_id AS city_id_98,
  p2_.user_id AS user_id_99,
  p2_.othet_city_id AS othet_city_id_100,
  p2_.intercommunality_id AS intercommunality_id_101,
  p2_.attachments AS attachments_102,
  t3_.seance_id AS seance_id_103,
  t3_.zone_id AS zone_id_104,
  t3_.project_id AS project_id_105
FROM
  tk_seances t0_
  INNER JOIN tk_events t1_ ON t0_.event_id = t1_.id
  INNER JOIN projects p2_ ON t1_.project_id = p2_.id
  LEFT JOIN tk_seances_prices t3_ ON t0_.id = t3_.seance_id
WHERE
  t0_.event_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.date ASC,
  t0_.start_time ASC,
  t0_.end_time ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.reference AS reference_2, t0_.description AS description_3, t0_.vat AS vat_4, t0_.date AS date_5, t0_.start_time AS start_time_6, t0_.end_time AS end_time_7, t0_.address AS address_8, t0_.type AS type_9, t0_.ticket_information AS ticket_information_10, t0_.ticket_instruction AS ticket_instruction_11, t0_.capacity AS capacity_12, t0_.status AS status_13, t0_.published_at AS published_at_14, t0_.closed_at AS closed_at_15, t0_.cancelled_at AS cancelled_at_16, t0_.recurrence_week_days AS recurrence_week_days_17, t0_.start_date AS start_date_18, t0_.end_date AS end_date_19, t0_.created_at AS created_at_20, t0_.updated_at AS updated_at_21, t0_.lat AS lat_22, t0_.lng AS lng_23, t1_.id AS id_24, t1_.name AS name_25, t1_.reference AS reference_26, t1_.slug AS slug_27, t1_.intro AS intro_28, t1_.description AS description_29, t1_.start_date AS start_date_30, t1_.end_date AS end_date_31, t1_.published_at AS published_at_32, t1_.closed_at AS closed_at_33, t1_.cancelled_at AS cancelled_at_34, t1_.status AS status_35, t1_.permanent AS permanent_36, t1_.partners AS partners_37, t1_.created_at AS created_at_38, t1_.updated_at AS updated_at_39, p2_.id AS id_40, p2_.name AS name_41, p2_.description AS description_42, p2_.address AS address_43, p2_.additional_address AS additional_address_44, p2_.postcode AS postcode_45, p2_.identify_number AS identify_number_46, p2_.website AS website_47, p2_.prepaid_amount AS prepaid_amount_48, p2_.sponsor_code AS sponsor_code_49, p2_.sponsor_points AS sponsor_points_50, p2_.reference AS reference_51, p2_.sepa_name AS sepa_name_52, p2_.population AS population_53, p2_.typology AS typology_54, p2_.is_rdc AS is_rdc_55, p2_.is_contract_historic AS is_contract_historic_56, p2_.collectivity_service_code AS collectivity_service_code_57, p2_.is_number_ej AS is_number_ej_58, p2_.demo AS demo_59, p2_.vat AS vat_60, p2_.logo AS logo_61, p2_.is_data_different_invoice AS is_data_different_invoice_62, p2_.other_name AS other_name_63, p2_.other_address AS other_address_64, p2_.other_identify_number AS other_identify_number_65, p2_.manual_renewal AS manual_renewal_66, p2_.testimony_answered AS testimony_answered_67, p2_.is_cmd AS is_cmd_68, p2_.notes AS notes_69, p2_.date_invitation_ceo_interview AS date_invitation_ceo_interview_70, p2_.date_ceo_interview AS date_ceo_interview_71, p2_.top_ranking AS top_ranking_72, p2_.rdc_feeling AS rdc_feeling_73, p2_.created_at AS created_at_74, p2_.updated_at AS updated_at_75, p2_.deleted_at AS deleted_at_76, p2_.lat AS lat_77, p2_.lng AS lng_78, t3_.id AS id_79, t3_.name AS name_80, t3_.price AS price_81, t3_.quantity AS quantity_82, t3_.nominative AS nominative_83, t3_.sale_type AS sale_type_84, t3_.on_counter AS on_counter_85, t3_.online AS online_86, t0_.city_id AS city_id_87, t0_.plan_id AS plan_id_88, t0_.thumbnail_id AS thumbnail_id_89, t0_.event_id AS event_id_90, t1_.project_id AS project_id_91, t1_.promoter_id AS promoter_id_92, t1_.category_id AS category_id_93, t1_.thumbnail_id AS thumbnail_id_94, t1_.structure_id AS structure_id_95, p2_.type_id AS type_id_96, p2_.category_id AS category_id_97, p2_.city_id AS city_id_98, p2_.user_id AS user_id_99, p2_.othet_city_id AS othet_city_id_100, p2_.intercommunality_id AS intercommunality_id_101, p2_.attachments AS attachments_102, t3_.seance_id AS seance_id_103, t3_.zone_id AS zone_id_104, t3_.project_id AS project_id_105 FROM tk_seances t0_ INNER JOIN tk_events t1_ ON t0_.event_id = t1_.id INNER JOIN projects p2_ ON t1_.project_id = p2_.id LEFT JOIN tk_seances_prices t3_ ON t0_.id = t3_.seance_id WHERE t0_.event_id = 588 AND t0_.status = 1 ORDER BY t0_.date ASC, t0_.start_time ASC, t0_.end_time ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.vat AS vat_3,
  t0_.status AS status_4,
  t0_.published_at AS published_at_5,
  t0_.start_date AS start_date_6,
  t0_.end_date AS end_date_7,
  t0_.closed_at AS closed_at_8,
  t0_.cancelled_at AS cancelled_at_9,
  t0_.capacity AS capacity_10,
  t0_.capacity_by_order AS capacity_by_order_11,
  t0_.created_at AS created_at_12,
  t0_.updated_at AS updated_at_13,
  t1_.id AS id_14,
  t1_.name AS name_15,
  t1_.reference AS reference_16,
  t1_.slug AS slug_17,
  t1_.intro AS intro_18,
  t1_.description AS description_19,
  t1_.start_date AS start_date_20,
  t1_.end_date AS end_date_21,
  t1_.published_at AS published_at_22,
  t1_.closed_at AS closed_at_23,
  t1_.cancelled_at AS cancelled_at_24,
  t1_.status AS status_25,
  t1_.permanent AS permanent_26,
  t1_.partners AS partners_27,
  t1_.created_at AS created_at_28,
  t1_.updated_at AS updated_at_29,
  p2_.id AS id_30,
  p2_.name AS name_31,
  p2_.description AS description_32,
  p2_.address AS address_33,
  p2_.additional_address AS additional_address_34,
  p2_.postcode AS postcode_35,
  p2_.identify_number AS identify_number_36,
  p2_.website AS website_37,
  p2_.prepaid_amount AS prepaid_amount_38,
  p2_.sponsor_code AS sponsor_code_39,
  p2_.sponsor_points AS sponsor_points_40,
  p2_.reference AS reference_41,
  p2_.sepa_name AS sepa_name_42,
  p2_.population AS population_43,
  p2_.typology AS typology_44,
  p2_.is_rdc AS is_rdc_45,
  p2_.is_contract_historic AS is_contract_historic_46,
  p2_.collectivity_service_code AS collectivity_service_code_47,
  p2_.is_number_ej AS is_number_ej_48,
  p2_.demo AS demo_49,
  p2_.vat AS vat_50,
  p2_.logo AS logo_51,
  p2_.is_data_different_invoice AS is_data_different_invoice_52,
  p2_.other_name AS other_name_53,
  p2_.other_address AS other_address_54,
  p2_.other_identify_number AS other_identify_number_55,
  p2_.manual_renewal AS manual_renewal_56,
  p2_.testimony_answered AS testimony_answered_57,
  p2_.is_cmd AS is_cmd_58,
  p2_.notes AS notes_59,
  p2_.date_invitation_ceo_interview AS date_invitation_ceo_interview_60,
  p2_.date_ceo_interview AS date_ceo_interview_61,
  p2_.top_ranking AS top_ranking_62,
  p2_.rdc_feeling AS rdc_feeling_63,
  p2_.created_at AS created_at_64,
  p2_.updated_at AS updated_at_65,
  p2_.deleted_at AS deleted_at_66,
  p2_.lat AS lat_67,
  p2_.lng AS lng_68,
  t3_.id AS id_69,
  t3_.name AS name_70,
  t3_.reference AS reference_71,
  t3_.description AS description_72,
  t3_.vat AS vat_73,
  t3_.date AS date_74,
  t3_.start_time AS start_time_75,
  t3_.end_time AS end_time_76,
  t3_.address AS address_77,
  t3_.type AS type_78,
  t3_.ticket_information AS ticket_information_79,
  t3_.ticket_instruction AS ticket_instruction_80,
  t3_.capacity AS capacity_81,
  t3_.status AS status_82,
  t3_.published_at AS published_at_83,
  t3_.closed_at AS closed_at_84,
  t3_.cancelled_at AS cancelled_at_85,
  t3_.recurrence_week_days AS recurrence_week_days_86,
  t3_.start_date AS start_date_87,
  t3_.end_date AS end_date_88,
  t3_.created_at AS created_at_89,
  t3_.updated_at AS updated_at_90,
  t3_.lat AS lat_91,
  t3_.lng AS lng_92,
  t4_.id AS id_93,
  t4_.name AS name_94,
  t4_.price AS price_95,
  t4_.quantity AS quantity_96,
  t4_.nominative AS nominative_97,
  t4_.sale_type AS sale_type_98,
  t4_.on_counter AS on_counter_99,
  t4_.online AS online_100,
  t0_.event_id AS event_id_101,
  t1_.project_id AS project_id_102,
  t1_.promoter_id AS promoter_id_103,
  t1_.category_id AS category_id_104,
  t1_.thumbnail_id AS thumbnail_id_105,
  t1_.structure_id AS structure_id_106,
  p2_.type_id AS type_id_107,
  p2_.category_id AS category_id_108,
  p2_.city_id AS city_id_109,
  p2_.user_id AS user_id_110,
  p2_.othet_city_id AS othet_city_id_111,
  p2_.intercommunality_id AS intercommunality_id_112,
  p2_.attachments AS attachments_113,
  t3_.city_id AS city_id_114,
  t3_.plan_id AS plan_id_115,
  t3_.thumbnail_id AS thumbnail_id_116,
  t3_.event_id AS event_id_117,
  t4_.pack_id AS pack_id_118,
  t4_.project_id AS project_id_119
FROM
  tk_packs t0_
  INNER JOIN tk_events t1_ ON t0_.event_id = t1_.id
  INNER JOIN projects p2_ ON t1_.project_id = p2_.id
  INNER JOIN tk_packs_seances t5_ ON t0_.id = t5_.pack_id
  INNER JOIN tk_seances t3_ ON t3_.id = t5_.seance_id
  LEFT JOIN tk_packs_prices t4_ ON t0_.id = t4_.pack_id
WHERE
  t0_.event_id = ?
  AND t0_.status = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.vat AS vat_3, t0_.status AS status_4, t0_.published_at AS published_at_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.closed_at AS closed_at_8, t0_.cancelled_at AS cancelled_at_9, t0_.capacity AS capacity_10, t0_.capacity_by_order AS capacity_by_order_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t1_.id AS id_14, t1_.name AS name_15, t1_.reference AS reference_16, t1_.slug AS slug_17, t1_.intro AS intro_18, t1_.description AS description_19, t1_.start_date AS start_date_20, t1_.end_date AS end_date_21, t1_.published_at AS published_at_22, t1_.closed_at AS closed_at_23, t1_.cancelled_at AS cancelled_at_24, t1_.status AS status_25, t1_.permanent AS permanent_26, t1_.partners AS partners_27, t1_.created_at AS created_at_28, t1_.updated_at AS updated_at_29, p2_.id AS id_30, p2_.name AS name_31, p2_.description AS description_32, p2_.address AS address_33, p2_.additional_address AS additional_address_34, p2_.postcode AS postcode_35, p2_.identify_number AS identify_number_36, p2_.website AS website_37, p2_.prepaid_amount AS prepaid_amount_38, p2_.sponsor_code AS sponsor_code_39, p2_.sponsor_points AS sponsor_points_40, p2_.reference AS reference_41, p2_.sepa_name AS sepa_name_42, p2_.population AS population_43, p2_.typology AS typology_44, p2_.is_rdc AS is_rdc_45, p2_.is_contract_historic AS is_contract_historic_46, p2_.collectivity_service_code AS collectivity_service_code_47, p2_.is_number_ej AS is_number_ej_48, p2_.demo AS demo_49, p2_.vat AS vat_50, p2_.logo AS logo_51, p2_.is_data_different_invoice AS is_data_different_invoice_52, p2_.other_name AS other_name_53, p2_.other_address AS other_address_54, p2_.other_identify_number AS other_identify_number_55, p2_.manual_renewal AS manual_renewal_56, p2_.testimony_answered AS testimony_answered_57, p2_.is_cmd AS is_cmd_58, p2_.notes AS notes_59, p2_.date_invitation_ceo_interview AS date_invitation_ceo_interview_60, p2_.date_ceo_interview AS date_ceo_interview_61, p2_.top_ranking AS top_ranking_62, p2_.rdc_feeling AS rdc_feeling_63, p2_.created_at AS created_at_64, p2_.updated_at AS updated_at_65, p2_.deleted_at AS deleted_at_66, p2_.lat AS lat_67, p2_.lng AS lng_68, t3_.id AS id_69, t3_.name AS name_70, t3_.reference AS reference_71, t3_.description AS description_72, t3_.vat AS vat_73, t3_.date AS date_74, t3_.start_time AS start_time_75, t3_.end_time AS end_time_76, t3_.address AS address_77, t3_.type AS type_78, t3_.ticket_information AS ticket_information_79, t3_.ticket_instruction AS ticket_instruction_80, t3_.capacity AS capacity_81, t3_.status AS status_82, t3_.published_at AS published_at_83, t3_.closed_at AS closed_at_84, t3_.cancelled_at AS cancelled_at_85, t3_.recurrence_week_days AS recurrence_week_days_86, t3_.start_date AS start_date_87, t3_.end_date AS end_date_88, t3_.created_at AS created_at_89, t3_.updated_at AS updated_at_90, t3_.lat AS lat_91, t3_.lng AS lng_92, t4_.id AS id_93, t4_.name AS name_94, t4_.price AS price_95, t4_.quantity AS quantity_96, t4_.nominative AS nominative_97, t4_.sale_type AS sale_type_98, t4_.on_counter AS on_counter_99, t4_.online AS online_100, t0_.event_id AS event_id_101, t1_.project_id AS project_id_102, t1_.promoter_id AS promoter_id_103, t1_.category_id AS category_id_104, t1_.thumbnail_id AS thumbnail_id_105, t1_.structure_id AS structure_id_106, p2_.type_id AS type_id_107, p2_.category_id AS category_id_108, p2_.city_id AS city_id_109, p2_.user_id AS user_id_110, p2_.othet_city_id AS othet_city_id_111, p2_.intercommunality_id AS intercommunality_id_112, p2_.attachments AS attachments_113, t3_.city_id AS city_id_114, t3_.plan_id AS plan_id_115, t3_.thumbnail_id AS thumbnail_id_116, t3_.event_id AS event_id_117, t4_.pack_id AS pack_id_118, t4_.project_id AS project_id_119 FROM tk_packs t0_ INNER JOIN tk_events t1_ ON t0_.event_id = t1_.id INNER JOIN projects p2_ ON t1_.project_id = p2_.id INNER JOIN tk_packs_seances t5_ ON t0_.id = t5_.pack_id INNER JOIN tk_seances t3_ ON t3_.id = t5_.seance_id LEFT JOIN tk_packs_prices t4_ ON t0_.id = t4_.pack_id WHERE t0_.event_id = 588 AND t0_.status = 1 ORDER BY t0_.name ASC;