Query Metrics
9
Database Queries
7
Different statements
5.09 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.02 ms |
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.plan AS plan_22, t0.destinations AS destinations_23, t0.payment_methods AS payment_methods_24, t0.gallery AS gallery_25, t0.rating AS rating_26, t0.review_count AS review_count_27, t0.is_verified AS is_verified_28, t0.is_suspended AS is_suspended_29, t0.home_delivery AS home_delivery_30, t0.packaging_service AS packaging_service_31, t0.online_payment AS online_payment_32, t0.sms_tracking AS sms_tracking_33, t0.insurance AS insurance_34, t0.accepts_bankily AS accepts_bankily_35, t0.accepts_wave AS accepts_wave_36, t0.accepts_orange_money AS accepts_orange_money_37, t0.max_weight AS max_weight_38, t0.insurance_percentage AS insurance_percentage_39, t0.home_delivery_fee AS home_delivery_fee_40, t0.packaging_fee AS packaging_fee_41, t0.insurance_rate AS insurance_rate_42, t0.photo_service AS photo_service_43, t0.average_delivery_time AS average_delivery_time_44, t0.slogan AS slogan_45, t0.website AS website_46, t0.facebook AS facebook_47, t0.whatsapp AS whatsapp_48, t0.notification_preferences AS notification_preferences_49, t0.notification_channels AS notification_channels_50, t0.next_billing_date AS next_billing_date_51, t0.payment_method AS payment_method_52, t0.stripe_customer_id AS stripe_customer_id_53, t0.is_public_profile AS is_public_profile_54, t0.accept_new_reservations AS accept_new_reservations_55, t0.auto_boost AS auto_boost_56, t0.two_factor_enabled AS two_factor_enabled_57, t0.integrations AS integrations_58, t0.created_at AS created_at_59, t0.updated_at AS updated_at_60, t0.user_id AS user_id_61 FROM gp t0 WHERE t0.is_verified = ? AND t0.is_suspended = ? ORDER BY t0.rating DESC LIMIT 8
Parameters:
[ 1 0 ] |
| 2 | 1.74 ms |
SELECT t0_.departure_city AS departure_city_0, t0_.arrival_city AS arrival_city_1, t0_.arrival_country AS arrival_country_2, MIN(t0_.price_per_kg) AS sclr_3, COUNT(DISTINCT t0_.gp_id) AS sclr_4, COUNT(t0_.id) AS sclr_5 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 g1_.is_verified = ? GROUP BY t0_.departure_city, t0_.arrival_city, t0_.arrival_country ORDER BY sclr_5 DESC LIMIT 8
Parameters:
[ 1 "active" 0 1 ] |
| 3 | 0.36 ms |
SELECT COUNT(*) FROM gp t0 WHERE t0.is_verified = ? AND t0.is_suspended = ?
Parameters:
[ 1 0 ] |
| 4 | 0.34 ms |
SELECT COUNT(*) FROM trip t0 WHERE t0.is_active = ? AND t0.status = ?
Parameters:
[ 1 "active" ] |
| 5 | 0.33 ms |
SELECT AVG(g0_.rating) AS sclr_0 FROM gp g0_ WHERE g0_.is_verified = ? AND g0_.is_suspended = ? AND g0_.rating > 0
Parameters:
[ 1 0 ] |
| 6 | 0.44 ms |
SELECT COUNT(DISTINCT t0_.arrival_country) AS sclr_0 FROM trip t0_ WHERE t0_.is_active = ?
Parameters:
[
1
]
|
| 7 | 0.33 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:
[] |
| 8 | 0.25 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:
[] |
| 9 | 0.28 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\GP | 3 |
| App\Entity\User | 3 |
| App\Entity\Settings | 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\Settings | No errors. |