Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.sender_name AS sender_name_3,
  t0.sender_email AS sender_email_4,
  t0.sender_phone AS sender_phone_5,
  t0.sender_first_name AS sender_first_name_6,
  t0.sender_last_name AS sender_last_name_7,
  t0.recipient_name AS recipient_name_8,
  t0.recipient_phone AS recipient_phone_9,
  t0.recipient_address AS recipient_address_10,
  t0.recipient_first_name AS recipient_first_name_11,
  t0.recipient_last_name AS recipient_last_name_12,
  t0.recipient_city AS recipient_city_13,
  t0.recipient_district AS recipient_district_14,
  t0.pickup_method AS pickup_method_15,
  t0.pickup_address AS pickup_address_16,
  t0.package_description AS package_description_17,
  t0.package_type AS package_type_18,
  t0.weight AS weight_19,
  t0.declared_value AS declared_value_20,
  t0.price AS price_21,
  t0.insurance_amount AS insurance_amount_22,
  t0.home_delivery_fee AS home_delivery_fee_23,
  t0.packaging_fee AS packaging_fee_24,
  t0.total_amount AS total_amount_25,
  t0.status AS status_26,
  t0.payment_method AS payment_method_27,
  t0.payment_date AS payment_date_28,
  t0.stripe_payment_intent_id AS stripe_payment_intent_id_29,
  t0.payment_status AS payment_status_30,
  t0.notes AS notes_31,
  t0.special_instructions AS special_instructions_32,
  t0.home_delivery AS home_delivery_33,
  t0.insurance AS insurance_34,
  t0.packaging AS packaging_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.is_guest_reservation AS is_guest_reservation_38,
  t0.guest_email AS guest_email_39,
  t0.guest_first_name AS guest_first_name_40,
  t0.guest_last_name AS guest_last_name_41,
  t0.guest_phone AS guest_phone_42,
  t0.pickup_code AS pickup_code_43,
  t0.pickup_code_expires_at AS pickup_code_expires_at_44,
  t0.pickup_code_sent_at AS pickup_code_sent_at_45,
  t0.pickup_code_attempts AS pickup_code_attempts_46,
  t0.review_token AS review_token_47,
  t0.trip_id AS trip_id_48,
  t0.user_id AS user_id_49,
  t50.id AS id_51,
  t50.barcode AS barcode_52,
  t50.status AS status_53,
  t50.created_at AS created_at_54,
  t50.printed_at AS printed_at_55,
  t50.width AS width_56,
  t50.height AS height_57,
  t50.depth AS depth_58,
  t50.notes AS notes_59,
  t50.reservation_id AS reservation_id_60,
  t61.id AS id_62,
  t61.signature_path AS signature_path_63,
  t61.photo_path AS photo_path_64,
  t61.latitude AS latitude_65,
  t61.longitude AS longitude_66,
  t61.delivery_address AS delivery_address_67,
  t61.recipient_name_confirmed AS recipient_name_confirmed_68,
  t61.delivered_at AS delivered_at_69,
  t61.gps_accuracy AS gps_accuracy_70,
  t61.reservation_id AS reservation_id_71
FROM
  reservation t0
  LEFT JOIN label t50 ON t50.reservation_id = t0.id
  LEFT JOIN proof_of_delivery t61 ON t61.reservation_id = t0.id
WHERE
  t0.trip_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.sender_name AS sender_name_3, t0.sender_email AS sender_email_4, t0.sender_phone AS sender_phone_5, t0.sender_first_name AS sender_first_name_6, t0.sender_last_name AS sender_last_name_7, t0.recipient_name AS recipient_name_8, t0.recipient_phone AS recipient_phone_9, t0.recipient_address AS recipient_address_10, t0.recipient_first_name AS recipient_first_name_11, t0.recipient_last_name AS recipient_last_name_12, t0.recipient_city AS recipient_city_13, t0.recipient_district AS recipient_district_14, t0.pickup_method AS pickup_method_15, t0.pickup_address AS pickup_address_16, t0.package_description AS package_description_17, t0.package_type AS package_type_18, t0.weight AS weight_19, t0.declared_value AS declared_value_20, t0.price AS price_21, t0.insurance_amount AS insurance_amount_22, t0.home_delivery_fee AS home_delivery_fee_23, t0.packaging_fee AS packaging_fee_24, t0.total_amount AS total_amount_25, t0.status AS status_26, t0.payment_method AS payment_method_27, t0.payment_date AS payment_date_28, t0.stripe_payment_intent_id AS stripe_payment_intent_id_29, t0.payment_status AS payment_status_30, t0.notes AS notes_31, t0.special_instructions AS special_instructions_32, t0.home_delivery AS home_delivery_33, t0.insurance AS insurance_34, t0.packaging AS packaging_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.is_guest_reservation AS is_guest_reservation_38, t0.guest_email AS guest_email_39, t0.guest_first_name AS guest_first_name_40, t0.guest_last_name AS guest_last_name_41, t0.guest_phone AS guest_phone_42, t0.pickup_code AS pickup_code_43, t0.pickup_code_expires_at AS pickup_code_expires_at_44, t0.pickup_code_sent_at AS pickup_code_sent_at_45, t0.pickup_code_attempts AS pickup_code_attempts_46, t0.review_token AS review_token_47, t0.trip_id AS trip_id_48, t0.user_id AS user_id_49, t50.id AS id_51, t50.barcode AS barcode_52, t50.status AS status_53, t50.created_at AS created_at_54, t50.printed_at AS printed_at_55, t50.width AS width_56, t50.height AS height_57, t50.depth AS depth_58, t50.notes AS notes_59, t50.reservation_id AS reservation_id_60, t61.id AS id_62, t61.signature_path AS signature_path_63, t61.photo_path AS photo_path_64, t61.latitude AS latitude_65, t61.longitude AS longitude_66, t61.delivery_address AS delivery_address_67, t61.recipient_name_confirmed AS recipient_name_confirmed_68, t61.delivered_at AS delivered_at_69, t61.gps_accuracy AS gps_accuracy_70, t61.reservation_id AS reservation_id_71 FROM reservation t0 LEFT JOIN label t50 ON t50.reservation_id = t0.id LEFT JOIN proof_of_delivery t61 ON t61.reservation_id = t0.id WHERE t0.trip_id = 2;

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,
  g1_.id AS id_28,
  g1_.name AS name_29,
  g1_.description AS description_30,
  g1_.logo AS logo_31,
  g1_.phone_france AS phone_france_32,
  g1_.phone_destination AS phone_destination_33,
  g1_.email AS email_34,
  g1_.address_france AS address_france_35,
  g1_.postal_code_france AS postal_code_france_36,
  g1_.city_france AS city_france_37,
  g1_.country_france AS country_france_38,
  g1_.address_destination AS address_destination_39,
  g1_.destination_country AS destination_country_40,
  g1_.company_name AS company_name_41,
  g1_.siret AS siret_42,
  g1_.creation_year AS creation_year_43,
  g1_.manager_first_name AS manager_first_name_44,
  g1_.manager_last_name AS manager_last_name_45,
  g1_.kbis_file AS kbis_file_46,
  g1_.rib_file AS rib_file_47,
  g1_.cni_file AS cni_file_48,
  g1_.document_type AS document_type_49,
  g1_.sejour_verso_file AS sejour_verso_file_50,
  g1_.plan AS plan_51,
  g1_.destinations AS destinations_52,
  g1_.payment_methods AS payment_methods_53,
  g1_.gallery AS gallery_54,
  g1_.rating AS rating_55,
  g1_.review_count AS review_count_56,
  g1_.is_verified AS is_verified_57,
  g1_.is_suspended AS is_suspended_58,
  g1_.home_delivery AS home_delivery_59,
  g1_.packaging_service AS packaging_service_60,
  g1_.online_payment AS online_payment_61,
  g1_.sms_tracking AS sms_tracking_62,
  g1_.insurance AS insurance_63,
  g1_.accepts_bankily AS accepts_bankily_64,
  g1_.accepts_wave AS accepts_wave_65,
  g1_.accepts_orange_money AS accepts_orange_money_66,
  g1_.max_weight AS max_weight_67,
  g1_.insurance_percentage AS insurance_percentage_68,
  g1_.home_delivery_fee AS home_delivery_fee_69,
  g1_.packaging_fee AS packaging_fee_70,
  g1_.insurance_rate AS insurance_rate_71,
  g1_.photo_service AS photo_service_72,
  g1_.average_delivery_time AS average_delivery_time_73,
  g1_.slogan AS slogan_74,
  g1_.website AS website_75,
  g1_.facebook AS facebook_76,
  g1_.whatsapp AS whatsapp_77,
  g1_.notification_preferences AS notification_preferences_78,
  g1_.notification_channels AS notification_channels_79,
  g1_.next_billing_date AS next_billing_date_80,
  g1_.payment_method AS payment_method_81,
  g1_.stripe_customer_id AS stripe_customer_id_82,
  g1_.is_public_profile AS is_public_profile_83,
  g1_.accept_new_reservations AS accept_new_reservations_84,
  g1_.auto_boost AS auto_boost_85,
  g1_.two_factor_enabled AS two_factor_enabled_86,
  g1_.integrations AS integrations_87,
  g1_.created_at AS created_at_88,
  g1_.updated_at AS updated_at_89,
  g1_.profile_slug AS profile_slug_90,
  t0_.gp_id AS gp_id_91,
  g1_.user_id AS user_id_92
FROM
  trip t0_
  LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id
WHERE
  t0_.is_active = ?
  AND t0_.status = ?
  AND g1_.is_suspended = ?
  AND LOWER(t0_.departure_city) LIKE LOWER(?)
  AND LOWER(t0_.arrival_city) LIKE LOWER(?)
  AND t0_.available_capacity > 0
ORDER BY
  t0_.departure_date ASC
LIMIT
  12

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, g1_.id AS id_28, g1_.name AS name_29, g1_.description AS description_30, g1_.logo AS logo_31, g1_.phone_france AS phone_france_32, g1_.phone_destination AS phone_destination_33, g1_.email AS email_34, g1_.address_france AS address_france_35, g1_.postal_code_france AS postal_code_france_36, g1_.city_france AS city_france_37, g1_.country_france AS country_france_38, g1_.address_destination AS address_destination_39, g1_.destination_country AS destination_country_40, g1_.company_name AS company_name_41, g1_.siret AS siret_42, g1_.creation_year AS creation_year_43, g1_.manager_first_name AS manager_first_name_44, g1_.manager_last_name AS manager_last_name_45, g1_.kbis_file AS kbis_file_46, g1_.rib_file AS rib_file_47, g1_.cni_file AS cni_file_48, g1_.document_type AS document_type_49, g1_.sejour_verso_file AS sejour_verso_file_50, g1_.plan AS plan_51, g1_.destinations AS destinations_52, g1_.payment_methods AS payment_methods_53, g1_.gallery AS gallery_54, g1_.rating AS rating_55, g1_.review_count AS review_count_56, g1_.is_verified AS is_verified_57, g1_.is_suspended AS is_suspended_58, g1_.home_delivery AS home_delivery_59, g1_.packaging_service AS packaging_service_60, g1_.online_payment AS online_payment_61, g1_.sms_tracking AS sms_tracking_62, g1_.insurance AS insurance_63, g1_.accepts_bankily AS accepts_bankily_64, g1_.accepts_wave AS accepts_wave_65, g1_.accepts_orange_money AS accepts_orange_money_66, g1_.max_weight AS max_weight_67, g1_.insurance_percentage AS insurance_percentage_68, g1_.home_delivery_fee AS home_delivery_fee_69, g1_.packaging_fee AS packaging_fee_70, g1_.insurance_rate AS insurance_rate_71, g1_.photo_service AS photo_service_72, g1_.average_delivery_time AS average_delivery_time_73, g1_.slogan AS slogan_74, g1_.website AS website_75, g1_.facebook AS facebook_76, g1_.whatsapp AS whatsapp_77, g1_.notification_preferences AS notification_preferences_78, g1_.notification_channels AS notification_channels_79, g1_.next_billing_date AS next_billing_date_80, g1_.payment_method AS payment_method_81, g1_.stripe_customer_id AS stripe_customer_id_82, g1_.is_public_profile AS is_public_profile_83, g1_.accept_new_reservations AS accept_new_reservations_84, g1_.auto_boost AS auto_boost_85, g1_.two_factor_enabled AS two_factor_enabled_86, g1_.integrations AS integrations_87, g1_.created_at AS created_at_88, g1_.updated_at AS updated_at_89, g1_.profile_slug AS profile_slug_90, t0_.gp_id AS gp_id_91, g1_.user_id AS user_id_92 FROM trip t0_ LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id WHERE t0_.is_active = 1 AND t0_.status = 'active' AND g1_.is_suspended = 0 AND LOWER(t0_.departure_city) LIKE LOWER('%paris%') AND LOWER(t0_.arrival_city) LIKE LOWER('%dakar%') AND t0_.available_capacity > 0 ORDER BY t0_.departure_date ASC LIMIT 12;

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
  COUNT(t0_.id) AS sclr_0
FROM
  trip t0_
  LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id
WHERE
  t0_.is_active = ?
  AND t0_.status = ?
  AND g1_.is_suspended = ?
  AND LOWER(t0_.departure_city) LIKE LOWER(?)
  AND LOWER(t0_.arrival_city) LIKE LOWER(?)
  AND t0_.available_capacity > 0

SELECT COUNT(t0_.id) AS sclr_0 FROM trip t0_ LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id WHERE t0_.is_active = 1 AND t0_.status = 'active' AND g1_.is_suspended = 0 AND LOWER(t0_.departure_city) LIKE LOWER('%paris%') AND LOWER(t0_.arrival_city) LIKE LOWER('%dakar%') AND t0_.available_capacity > 0;