Query Metrics
8
Database Queries
6
Different statements
6.40 ms
Query time
1
Invalid entities
10
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.53 ms (23.91%) |
3 |
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:
[] |
|
1.48 ms (23.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.phone_france AS phone_france_5, t0.phone_destination AS phone_destination_6, t0.email AS email_7, t0.address_france AS address_france_8, t0.postal_code_france AS postal_code_france_9, t0.city_france AS city_france_10, t0.country_france AS country_france_11, t0.address_destination AS address_destination_12, t0.destination_country AS destination_country_13, t0.company_name AS company_name_14, t0.siret AS siret_15, t0.creation_year AS creation_year_16, t0.manager_first_name AS manager_first_name_17, t0.manager_last_name AS manager_last_name_18, t0.kbis_file AS kbis_file_19, t0.rib_file AS rib_file_20, t0.cni_file AS cni_file_21, t0.document_type AS document_type_22, t0.sejour_verso_file AS sejour_verso_file_23, t0.plan AS plan_24, t0.destinations AS destinations_25, t0.payment_methods AS payment_methods_26, t0.gallery AS gallery_27, t0.rating AS rating_28, t0.review_count AS review_count_29, t0.is_verified AS is_verified_30, t0.is_suspended AS is_suspended_31, t0.home_delivery AS home_delivery_32, t0.packaging_service AS packaging_service_33, t0.online_payment AS online_payment_34, t0.sms_tracking AS sms_tracking_35, t0.insurance AS insurance_36, t0.accepts_bankily AS accepts_bankily_37, t0.accepts_wave AS accepts_wave_38, t0.accepts_orange_money AS accepts_orange_money_39, t0.max_weight AS max_weight_40, t0.insurance_percentage AS insurance_percentage_41, t0.home_delivery_fee AS home_delivery_fee_42, t0.packaging_fee AS packaging_fee_43, t0.insurance_rate AS insurance_rate_44, t0.photo_service AS photo_service_45, t0.average_delivery_time AS average_delivery_time_46, t0.slogan AS slogan_47, t0.website AS website_48, t0.facebook AS facebook_49, t0.whatsapp AS whatsapp_50, t0.notification_preferences AS notification_preferences_51, t0.notification_channels AS notification_channels_52, t0.next_billing_date AS next_billing_date_53, t0.payment_method AS payment_method_54, t0.stripe_customer_id AS stripe_customer_id_55, t0.is_public_profile AS is_public_profile_56, t0.accept_new_reservations AS accept_new_reservations_57, t0.auto_boost AS auto_boost_58, t0.two_factor_enabled AS two_factor_enabled_59, t0.integrations AS integrations_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.profile_slug AS profile_slug_63, t0.user_id AS user_id_64 FROM gp t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
|
1.31 ms (20.42%) |
1 |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.author_name AS author_name_4, t0.is_verified AS is_verified_5, t0.is_approved AS is_approved_6, t0.created_at AS created_at_7, t0.gp_id AS gp_id_8, t0.user_id AS user_id_9 FROM review t0 WHERE t0.gp_id = ? AND t0.is_approved = ? ORDER BY t0.created_at DESC LIMIT 10
Parameters:
[ 1 1 ] |
|
0.87 ms (13.56%) |
1 |
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
]
|
|
0.73 ms (11.37%) |
1 |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.original_name AS original_name_3, t0.description AS description_4, t0.is_main AS is_main_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_approved AS is_approved_9, t0.moderated_at AS moderated_at_10, t0.rejection_reason AS rejection_reason_11, t0.gp_id AS gp_id_12, t0.moderated_by_id AS moderated_by_id_13 FROM gp_photo t0 WHERE t0.gp_id = ?
Parameters:
[
1
]
|
|
0.49 ms (7.68%) |
1 |
SELECT t0.id AS id_1, t0.departure_city AS departure_city_2, t0.arrival_city AS arrival_city_3, t0.departure_country AS departure_country_4, t0.arrival_country AS arrival_country_5, t0.departure_date AS departure_date_6, t0.departure_time AS departure_time_7, t0.deposit_deadline AS deposit_deadline_8, t0.estimated_arrival_date AS estimated_arrival_date_9, t0.price_per_kg AS price_per_kg_10, t0.available_capacity AS available_capacity_11, t0.max_capacity AS max_capacity_12, t0.min_weight_per_package AS min_weight_per_package_13, t0.max_weight_per_package AS max_weight_per_package_14, t0.home_delivery_fee AS home_delivery_fee_15, t0.packaging_fee AS packaging_fee_16, t0.insurance_percentage AS insurance_percentage_17, t0.offers_home_delivery AS offers_home_delivery_18, t0.offers_packaging AS offers_packaging_19, t0.offers_insurance AS offers_insurance_20, t0.offers_photos AS offers_photos_21, t0.offers_sms_tracking AS offers_sms_tracking_22, t0.payment_methods AS payment_methods_23, t0.notes AS notes_24, t0.status AS status_25, t0.is_active AS is_active_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.gp_id AS gp_id_29 FROM trip t0 WHERE t0.gp_id = ?
Parameters:
[
1
]
|
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\User | 2 |
| App\Entity\Trip | 2 |
| App\Entity\GP | 1 |
| App\Entity\Review | 1 |
| App\Entity\Settings | 1 |
| App\Entity\Reservation | 1 |
| App\Entity\Label | 1 |
| App\Entity\ProofOfDelivery | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\GP | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Trip | 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\Reservation |
|
| 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. |