Query Metrics
4
Database Queries
2
Different statements
10.60 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.50 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_.plan AS plan_49, g1_.destinations AS destinations_50, g1_.payment_methods AS payment_methods_51, g1_.gallery AS gallery_52, g1_.rating AS rating_53, g1_.review_count AS review_count_54, g1_.is_verified AS is_verified_55, g1_.is_suspended AS is_suspended_56, g1_.home_delivery AS home_delivery_57, g1_.packaging_service AS packaging_service_58, g1_.online_payment AS online_payment_59, g1_.sms_tracking AS sms_tracking_60, g1_.insurance AS insurance_61, g1_.accepts_bankily AS accepts_bankily_62, g1_.accepts_wave AS accepts_wave_63, g1_.accepts_orange_money AS accepts_orange_money_64, g1_.max_weight AS max_weight_65, g1_.insurance_percentage AS insurance_percentage_66, g1_.home_delivery_fee AS home_delivery_fee_67, g1_.packaging_fee AS packaging_fee_68, g1_.insurance_rate AS insurance_rate_69, g1_.photo_service AS photo_service_70, g1_.average_delivery_time AS average_delivery_time_71, g1_.slogan AS slogan_72, g1_.website AS website_73, g1_.facebook AS facebook_74, g1_.whatsapp AS whatsapp_75, g1_.notification_preferences AS notification_preferences_76, g1_.notification_channels AS notification_channels_77, g1_.next_billing_date AS next_billing_date_78, g1_.payment_method AS payment_method_79, g1_.stripe_customer_id AS stripe_customer_id_80, g1_.is_public_profile AS is_public_profile_81, g1_.accept_new_reservations AS accept_new_reservations_82, g1_.auto_boost AS auto_boost_83, g1_.two_factor_enabled AS two_factor_enabled_84, g1_.integrations AS integrations_85, g1_.created_at AS created_at_86, g1_.updated_at AS updated_at_87, t0_.gp_id AS gp_id_88, g1_.user_id AS user_id_89 FROM trip t0_ LEFT JOIN gp g1_ ON t0_.gp_id = g1_.id WHERE t0_.is_active = ? AND t0_.status = ? AND g1_.is_suspended = ? ORDER BY t0_.departure_date ASC LIMIT 6
Parameters:
[ 1 "active" 0 ] |
| 2 | 2.40 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 FROM settings t0 LIMIT 1
Parameters:
[] |
| 3 | 0.30 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 FROM settings t0 LIMIT 1
Parameters:
[] |
| 4 | 0.40 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 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\Settings | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Trip | No errors. |
| App\Entity\GP | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Settings | No errors. |