GET https://develop.colisbled.fr/search?arrival=Dakar&departure=Paris

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.91 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, 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
Parameters:
[
  1
  "active"
  0
  "%Paris%"
  "%Dakar%"
]
2 0.87 ms
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
Parameters:
[
  1
  "active"
  0
  "%Paris%"
  "%Dakar%"
]
3 0.92 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:
[]
4 0.62 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.74 ms
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 = ?
Parameters:
[
  2
]
6 0.47 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\GP 1
App\Entity\User 1
App\Entity\Settings 1
App\Entity\Reservation 1
App\Entity\Label 1
App\Entity\ProofOfDelivery 1

Entities Mapping

Class Mapping errors
App\Entity\Trip No errors.
App\Entity\GP No errors.
App\Entity\User 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\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.
App\Entity\Label No errors.
App\Entity\ProofOfDelivery No errors.
App\Entity\PackageTracking No errors.
App\Entity\Notification No errors.
App\Entity\Dispute No errors.