Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.departure_city AS departure_city_1,
  t0_.arrival_city AS arrival_city_2,
  t0_.departure_country AS departure_country_3,
  t0_.arrival_country AS arrival_country_4,
  t0_.departure_date AS departure_date_5,
  t0_.departure_time AS departure_time_6,
  t0_.deposit_deadline AS deposit_deadline_7,
  t0_.estimated_arrival_date AS estimated_arrival_date_8,
  t0_.price_per_kg AS price_per_kg_9,
  t0_.available_capacity AS available_capacity_10,
  t0_.max_capacity AS max_capacity_11,
  t0_.min_weight_per_package AS min_weight_per_package_12,
  t0_.max_weight_per_package AS max_weight_per_package_13,
  t0_.home_delivery_fee AS home_delivery_fee_14,
  t0_.packaging_fee AS packaging_fee_15,
  t0_.insurance_percentage AS insurance_percentage_16,
  t0_.offers_home_delivery AS offers_home_delivery_17,
  t0_.offers_packaging AS offers_packaging_18,
  t0_.offers_insurance AS offers_insurance_19,
  t0_.offers_photos AS offers_photos_20,
  t0_.offers_sms_tracking AS offers_sms_tracking_21,
  t0_.payment_methods AS payment_methods_22,
  t0_.notes AS notes_23,
  t0_.status AS status_24,
  t0_.is_active AS is_active_25,
  t0_.created_at AS created_at_26,
  t0_.updated_at AS updated_at_27,
  r1_.id AS id_28,
  r1_.reference AS reference_29,
  r1_.sender_name AS sender_name_30,
  r1_.sender_email AS sender_email_31,
  r1_.sender_phone AS sender_phone_32,
  r1_.sender_first_name AS sender_first_name_33,
  r1_.sender_last_name AS sender_last_name_34,
  r1_.recipient_name AS recipient_name_35,
  r1_.recipient_phone AS recipient_phone_36,
  r1_.recipient_address AS recipient_address_37,
  r1_.recipient_first_name AS recipient_first_name_38,
  r1_.recipient_last_name AS recipient_last_name_39,
  r1_.recipient_city AS recipient_city_40,
  r1_.recipient_district AS recipient_district_41,
  r1_.pickup_method AS pickup_method_42,
  r1_.pickup_address AS pickup_address_43,
  r1_.package_description AS package_description_44,
  r1_.package_type AS package_type_45,
  r1_.weight AS weight_46,
  r1_.declared_value AS declared_value_47,
  r1_.price AS price_48,
  r1_.insurance_amount AS insurance_amount_49,
  r1_.home_delivery_fee AS home_delivery_fee_50,
  r1_.packaging_fee AS packaging_fee_51,
  r1_.total_amount AS total_amount_52,
  r1_.status AS status_53,
  r1_.payment_method AS payment_method_54,
  r1_.payment_date AS payment_date_55,
  r1_.stripe_payment_intent_id AS stripe_payment_intent_id_56,
  r1_.payment_status AS payment_status_57,
  r1_.notes AS notes_58,
  r1_.special_instructions AS special_instructions_59,
  r1_.home_delivery AS home_delivery_60,
  r1_.insurance AS insurance_61,
  r1_.packaging AS packaging_62,
  r1_.created_at AS created_at_63,
  r1_.updated_at AS updated_at_64,
  r1_.is_guest_reservation AS is_guest_reservation_65,
  r1_.guest_email AS guest_email_66,
  r1_.guest_first_name AS guest_first_name_67,
  r1_.guest_last_name AS guest_last_name_68,
  r1_.guest_phone AS guest_phone_69,
  r1_.pickup_code AS pickup_code_70,
  r1_.pickup_code_expires_at AS pickup_code_expires_at_71,
  r1_.pickup_code_sent_at AS pickup_code_sent_at_72,
  r1_.pickup_code_attempts AS pickup_code_attempts_73,
  r1_.review_token AS review_token_74,
  g2_.id AS id_75,
  g2_.name AS name_76,
  g2_.description AS description_77,
  g2_.logo AS logo_78,
  g2_.phone_france AS phone_france_79,
  g2_.phone_destination AS phone_destination_80,
  g2_.email AS email_81,
  g2_.address_france AS address_france_82,
  g2_.postal_code_france AS postal_code_france_83,
  g2_.city_france AS city_france_84,
  g2_.country_france AS country_france_85,
  g2_.address_destination AS address_destination_86,
  g2_.destination_country AS destination_country_87,
  g2_.company_name AS company_name_88,
  g2_.siret AS siret_89,
  g2_.creation_year AS creation_year_90,
  g2_.manager_first_name AS manager_first_name_91,
  g2_.manager_last_name AS manager_last_name_92,
  g2_.kbis_file AS kbis_file_93,
  g2_.rib_file AS rib_file_94,
  g2_.cni_file AS cni_file_95,
  g2_.document_type AS document_type_96,
  g2_.sejour_verso_file AS sejour_verso_file_97,
  g2_.plan AS plan_98,
  g2_.destinations AS destinations_99,
  g2_.payment_methods AS payment_methods_100,
  g2_.gallery AS gallery_101,
  g2_.rating AS rating_102,
  g2_.review_count AS review_count_103,
  g2_.is_verified AS is_verified_104,
  g2_.is_suspended AS is_suspended_105,
  g2_.home_delivery AS home_delivery_106,
  g2_.packaging_service AS packaging_service_107,
  g2_.online_payment AS online_payment_108,
  g2_.sms_tracking AS sms_tracking_109,
  g2_.insurance AS insurance_110,
  g2_.accepts_bankily AS accepts_bankily_111,
  g2_.accepts_wave AS accepts_wave_112,
  g2_.accepts_orange_money AS accepts_orange_money_113,
  g2_.max_weight AS max_weight_114,
  g2_.insurance_percentage AS insurance_percentage_115,
  g2_.home_delivery_fee AS home_delivery_fee_116,
  g2_.packaging_fee AS packaging_fee_117,
  g2_.insurance_rate AS insurance_rate_118,
  g2_.photo_service AS photo_service_119,
  g2_.average_delivery_time AS average_delivery_time_120,
  g2_.slogan AS slogan_121,
  g2_.website AS website_122,
  g2_.facebook AS facebook_123,
  g2_.whatsapp AS whatsapp_124,
  g2_.notification_preferences AS notification_preferences_125,
  g2_.notification_channels AS notification_channels_126,
  g2_.next_billing_date AS next_billing_date_127,
  g2_.payment_method AS payment_method_128,
  g2_.stripe_customer_id AS stripe_customer_id_129,
  g2_.is_public_profile AS is_public_profile_130,
  g2_.accept_new_reservations AS accept_new_reservations_131,
  g2_.auto_boost AS auto_boost_132,
  g2_.two_factor_enabled AS two_factor_enabled_133,
  g2_.integrations AS integrations_134,
  g2_.created_at AS created_at_135,
  g2_.updated_at AS updated_at_136,
  g2_.profile_slug AS profile_slug_137,
  t0_.gp_id AS gp_id_138,
  r1_.trip_id AS trip_id_139,
  r1_.user_id AS user_id_140,
  g2_.user_id AS user_id_141
FROM
  trip t0_
  LEFT JOIN reservation r1_ ON t0_.id = r1_.trip_id
  LEFT JOIN gp g2_ ON t0_.gp_id = g2_.id
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.departure_city AS departure_city_1, t0_.arrival_city AS arrival_city_2, t0_.departure_country AS departure_country_3, t0_.arrival_country AS arrival_country_4, t0_.departure_date AS departure_date_5, t0_.departure_time AS departure_time_6, t0_.deposit_deadline AS deposit_deadline_7, t0_.estimated_arrival_date AS estimated_arrival_date_8, t0_.price_per_kg AS price_per_kg_9, t0_.available_capacity AS available_capacity_10, t0_.max_capacity AS max_capacity_11, t0_.min_weight_per_package AS min_weight_per_package_12, t0_.max_weight_per_package AS max_weight_per_package_13, t0_.home_delivery_fee AS home_delivery_fee_14, t0_.packaging_fee AS packaging_fee_15, t0_.insurance_percentage AS insurance_percentage_16, t0_.offers_home_delivery AS offers_home_delivery_17, t0_.offers_packaging AS offers_packaging_18, t0_.offers_insurance AS offers_insurance_19, t0_.offers_photos AS offers_photos_20, t0_.offers_sms_tracking AS offers_sms_tracking_21, t0_.payment_methods AS payment_methods_22, t0_.notes AS notes_23, t0_.status AS status_24, t0_.is_active AS is_active_25, t0_.created_at AS created_at_26, t0_.updated_at AS updated_at_27, r1_.id AS id_28, r1_.reference AS reference_29, r1_.sender_name AS sender_name_30, r1_.sender_email AS sender_email_31, r1_.sender_phone AS sender_phone_32, r1_.sender_first_name AS sender_first_name_33, r1_.sender_last_name AS sender_last_name_34, r1_.recipient_name AS recipient_name_35, r1_.recipient_phone AS recipient_phone_36, r1_.recipient_address AS recipient_address_37, r1_.recipient_first_name AS recipient_first_name_38, r1_.recipient_last_name AS recipient_last_name_39, r1_.recipient_city AS recipient_city_40, r1_.recipient_district AS recipient_district_41, r1_.pickup_method AS pickup_method_42, r1_.pickup_address AS pickup_address_43, r1_.package_description AS package_description_44, r1_.package_type AS package_type_45, r1_.weight AS weight_46, r1_.declared_value AS declared_value_47, r1_.price AS price_48, r1_.insurance_amount AS insurance_amount_49, r1_.home_delivery_fee AS home_delivery_fee_50, r1_.packaging_fee AS packaging_fee_51, r1_.total_amount AS total_amount_52, r1_.status AS status_53, r1_.payment_method AS payment_method_54, r1_.payment_date AS payment_date_55, r1_.stripe_payment_intent_id AS stripe_payment_intent_id_56, r1_.payment_status AS payment_status_57, r1_.notes AS notes_58, r1_.special_instructions AS special_instructions_59, r1_.home_delivery AS home_delivery_60, r1_.insurance AS insurance_61, r1_.packaging AS packaging_62, r1_.created_at AS created_at_63, r1_.updated_at AS updated_at_64, r1_.is_guest_reservation AS is_guest_reservation_65, r1_.guest_email AS guest_email_66, r1_.guest_first_name AS guest_first_name_67, r1_.guest_last_name AS guest_last_name_68, r1_.guest_phone AS guest_phone_69, r1_.pickup_code AS pickup_code_70, r1_.pickup_code_expires_at AS pickup_code_expires_at_71, r1_.pickup_code_sent_at AS pickup_code_sent_at_72, r1_.pickup_code_attempts AS pickup_code_attempts_73, r1_.review_token AS review_token_74, g2_.id AS id_75, g2_.name AS name_76, g2_.description AS description_77, g2_.logo AS logo_78, g2_.phone_france AS phone_france_79, g2_.phone_destination AS phone_destination_80, g2_.email AS email_81, g2_.address_france AS address_france_82, g2_.postal_code_france AS postal_code_france_83, g2_.city_france AS city_france_84, g2_.country_france AS country_france_85, g2_.address_destination AS address_destination_86, g2_.destination_country AS destination_country_87, g2_.company_name AS company_name_88, g2_.siret AS siret_89, g2_.creation_year AS creation_year_90, g2_.manager_first_name AS manager_first_name_91, g2_.manager_last_name AS manager_last_name_92, g2_.kbis_file AS kbis_file_93, g2_.rib_file AS rib_file_94, g2_.cni_file AS cni_file_95, g2_.document_type AS document_type_96, g2_.sejour_verso_file AS sejour_verso_file_97, g2_.plan AS plan_98, g2_.destinations AS destinations_99, g2_.payment_methods AS payment_methods_100, g2_.gallery AS gallery_101, g2_.rating AS rating_102, g2_.review_count AS review_count_103, g2_.is_verified AS is_verified_104, g2_.is_suspended AS is_suspended_105, g2_.home_delivery AS home_delivery_106, g2_.packaging_service AS packaging_service_107, g2_.online_payment AS online_payment_108, g2_.sms_tracking AS sms_tracking_109, g2_.insurance AS insurance_110, g2_.accepts_bankily AS accepts_bankily_111, g2_.accepts_wave AS accepts_wave_112, g2_.accepts_orange_money AS accepts_orange_money_113, g2_.max_weight AS max_weight_114, g2_.insurance_percentage AS insurance_percentage_115, g2_.home_delivery_fee AS home_delivery_fee_116, g2_.packaging_fee AS packaging_fee_117, g2_.insurance_rate AS insurance_rate_118, g2_.photo_service AS photo_service_119, g2_.average_delivery_time AS average_delivery_time_120, g2_.slogan AS slogan_121, g2_.website AS website_122, g2_.facebook AS facebook_123, g2_.whatsapp AS whatsapp_124, g2_.notification_preferences AS notification_preferences_125, g2_.notification_channels AS notification_channels_126, g2_.next_billing_date AS next_billing_date_127, g2_.payment_method AS payment_method_128, g2_.stripe_customer_id AS stripe_customer_id_129, g2_.is_public_profile AS is_public_profile_130, g2_.accept_new_reservations AS accept_new_reservations_131, g2_.auto_boost AS auto_boost_132, g2_.two_factor_enabled AS two_factor_enabled_133, g2_.integrations AS integrations_134, g2_.created_at AS created_at_135, g2_.updated_at AS updated_at_136, g2_.profile_slug AS profile_slug_137, t0_.gp_id AS gp_id_138, r1_.trip_id AS trip_id_139, r1_.user_id AS user_id_140, g2_.user_id AS user_id_141 FROM trip t0_ LEFT JOIN reservation r1_ ON t0_.id = r1_.trip_id LEFT JOIN gp g2_ ON t0_.gp_id = g2_.id WHERE t0_.id = 2;

SELECT
  t0.id AS id_1,
  t0.site_logo AS site_logo_2,
  t0.contact_email AS contact_email_3,
  t0.contact_phone AS contact_phone_4,
  t0.updated_at AS updated_at_5,
  t0.stripe_test_secret_key AS stripe_test_secret_key_6,
  t0.stripe_test_publishable_key AS stripe_test_publishable_key_7,
  t0.stripe_live_secret_key AS stripe_live_secret_key_8,
  t0.stripe_live_publishable_key AS stripe_live_publishable_key_9,
  t0.stripe_webhook_secret AS stripe_webhook_secret_10,
  t0.stripe_mode AS stripe_mode_11,
  t0.smtp_host AS smtp_host_12,
  t0.smtp_port AS smtp_port_13,
  t0.smtp_username AS smtp_username_14,
  t0.smtp_password AS smtp_password_15,
  t0.smtp_encryption AS smtp_encryption_16,
  t0.smtp_sender_email AS smtp_sender_email_17,
  t0.smtp_sender_name AS smtp_sender_name_18,
  t0.footer_tagline AS footer_tagline_19,
  t0.footer_description AS footer_description_20,
  t0.social_facebook AS social_facebook_21,
  t0.social_twitter AS social_twitter_22,
  t0.social_instagram AS social_instagram_23,
  t0.social_whatsapp AS social_whatsapp_24,
  t0.social_linkedin AS social_linkedin_25,
  t0.footer_whatsapp AS footer_whatsapp_26,
  t0.footer_hours AS footer_hours_27,
  t0.footer_stat_packages AS footer_stat_packages_28,
  t0.footer_stat_gps AS footer_stat_gps_29,
  t0.footer_stat_destinations AS footer_stat_destinations_30,
  t0.footer_stat_rating AS footer_stat_rating_31,
  t0.app_store_url AS app_store_url_32,
  t0.google_play_url AS google_play_url_33
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_logo AS site_logo_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4, t0.updated_at AS updated_at_5, t0.stripe_test_secret_key AS stripe_test_secret_key_6, t0.stripe_test_publishable_key AS stripe_test_publishable_key_7, t0.stripe_live_secret_key AS stripe_live_secret_key_8, t0.stripe_live_publishable_key AS stripe_live_publishable_key_9, t0.stripe_webhook_secret AS stripe_webhook_secret_10, t0.stripe_mode AS stripe_mode_11, t0.smtp_host AS smtp_host_12, t0.smtp_port AS smtp_port_13, t0.smtp_username AS smtp_username_14, t0.smtp_password AS smtp_password_15, t0.smtp_encryption AS smtp_encryption_16, t0.smtp_sender_email AS smtp_sender_email_17, t0.smtp_sender_name AS smtp_sender_name_18, t0.footer_tagline AS footer_tagline_19, t0.footer_description AS footer_description_20, t0.social_facebook AS social_facebook_21, t0.social_twitter AS social_twitter_22, t0.social_instagram AS social_instagram_23, t0.social_whatsapp AS social_whatsapp_24, t0.social_linkedin AS social_linkedin_25, t0.footer_whatsapp AS footer_whatsapp_26, t0.footer_hours AS footer_hours_27, t0.footer_stat_packages AS footer_stat_packages_28, t0.footer_stat_gps AS footer_stat_gps_29, t0.footer_stat_destinations AS footer_stat_destinations_30, t0.footer_stat_rating AS footer_stat_rating_31, t0.app_store_url AS app_store_url_32, t0.google_play_url AS google_play_url_33 FROM settings t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.barcode AS barcode_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.printed_at AS printed_at_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.depth AS depth_8,
  t0.notes AS notes_9,
  t0.reservation_id AS reservation_id_10
FROM
  label t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.barcode AS barcode_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.printed_at AS printed_at_5, t0.width AS width_6, t0.height AS height_7, t0.depth AS depth_8, t0.notes AS notes_9, t0.reservation_id AS reservation_id_10 FROM label t0 WHERE t0.reservation_id = 2;

SELECT
  t0.id AS id_1,
  t0.signature_path AS signature_path_2,
  t0.photo_path AS photo_path_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.delivery_address AS delivery_address_6,
  t0.recipient_name_confirmed AS recipient_name_confirmed_7,
  t0.delivered_at AS delivered_at_8,
  t0.gps_accuracy AS gps_accuracy_9,
  t0.reservation_id AS reservation_id_10
FROM
  proof_of_delivery t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.signature_path AS signature_path_2, t0.photo_path AS photo_path_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.delivery_address AS delivery_address_6, t0.recipient_name_confirmed AS recipient_name_confirmed_7, t0.delivered_at AS delivered_at_8, t0.gps_accuracy AS gps_accuracy_9, t0.reservation_id AS reservation_id_10 FROM proof_of_delivery t0 WHERE t0.reservation_id = 2;