GET https://develop.colisbled.fr/trip/2

Query Metrics

6 Database Queries
4 Different statements
4.89 ms Query time
1 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 2.48 ms
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 = ?
Parameters:
[
  2
]
2 0.52 ms
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 = ?
Parameters:
[
  2
]
3 0.43 ms
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 = ?
Parameters:
[
  2
]
4 0.54 ms
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
Parameters:
[]
5 0.35 ms
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
Parameters:
[]
6 0.58 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Trip 1
App\Entity\Reservation 1
App\Entity\Label 1
App\Entity\ProofOfDelivery 1
App\Entity\GP 1
App\Entity\User 1
App\Entity\Settings 1

Entities Mapping

Class Mapping errors
App\Entity\Trip No errors.
App\Entity\Reservation
  • The field App\Entity\Reservation#disputes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Dispute#reservation does not contain the required 'inversedBy: "disputes"' attribute.
App\Entity\GP No errors.
App\Entity\User No errors.
App\Entity\PackageTracking No errors.
App\Entity\Label No errors.
App\Entity\ProofOfDelivery No errors.
App\Entity\Notification No errors.
App\Entity\Dispute No errors.
App\Entity\Review No errors.
App\Entity\Favorite No errors.
App\Entity\GpPhoto No errors.
App\Entity\Subscription No errors.
App\Entity\Payment No errors.
App\Entity\PackageType No errors.
App\Entity\GpNewsletterSubscription No errors.
App\Entity\Settings No errors.