Query Metrics
6
Database Queries
6
Different statements
123.37 ms
Query time
0
Invalid entities
18
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
94.23 ms (76.38%) |
1 |
SELECT d0_.id AS id_0, d0_.state AS state_1, d0_.given_name AS given_name_2, d0_.family_name AS family_name_3, d0_.maiden_name AS maiden_name_4, d0_.birth_city AS birth_city_5, d0_.death_city AS death_city_6, d0_.birth_country AS birth_country_7, d0_.death_country AS death_country_8, d0_.birth_date AS birth_date_9, d0_.death_date AS death_date_10, d0_.additional_info AS additional_info_11, d0_.published_at AS published_at_12, d0_.gender AS gender_13, ST_AsEWKB(d0_.location) AS location_14, d0_.created_at AS created_at_15, d0_.updated_at AS updated_at_16, d0_.reference AS reference_17, d0_.reference_uuid AS reference_uuid_18, d0_.archived AS archived_19, c1_.id AS id_20, c1_.name AS name_21, ST_AsEWKB(c1_.location) AS location_22, ST_AsEWKB(c1_.shape) AS shape_23, c1_.city AS city_24, c1_.postal_code AS postal_code_25, c1_.insee_code AS insee_code_26, c1_.department AS department_27, c1_.osm_id AS osm_id_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, c1_.reference AS reference_31, c1_.reference_uuid AS reference_uuid_32, c1_.archived AS archived_33, g2_.id AS id_34, ST_AsEWKB(g2_.shape) AS shape_35, ST_AsEWKB(g2_.location) AS location_36, g2_.label AS label_37, g2_.section AS section_38, g2_.number AS number_39, g2_.kind AS kind_40, g2_.source AS source_41, g2_.external_id AS external_id_42, g2_.reference AS reference_43, g2_.reference_uuid AS reference_uuid_44, g2_.created_at AS created_at_45, g2_.updated_at AS updated_at_46, d0_.cemetery_id AS cemetery_id_47, d0_.grave_site_id AS grave_site_id_48, d0_.created_by AS created_by_49, d0_.updated_by AS updated_by_50, g2_.cemetery_id AS cemetery_id_51 FROM deceased d0_ INNER JOIN cemetery c1_ ON d0_.cemetery_id = c1_.id LEFT JOIN grave_site g2_ ON d0_.grave_site_id = g2_.id WHERE d0_.reference_uuid = ?
Parameters:
[
"1f14eb17-4fbd-6e68-8f4a-c3f663b97c00"
]
|
|
10.58 ms (8.58%) |
1 |
SELECT t0.id AS id_1, t0.siret AS siret_2, t0.company_name AS company_name_3, t0.vat_number AS vat_number_4, t0.stripe_account_id AS stripe_account_id_5, t0.stripe_account_type AS stripe_account_type_6, t0.stripe_charges_enabled AS stripe_charges_enabled_7, t0.stripe_payouts_enabled AS stripe_payouts_enabled_8, t0.stripe_details_submitted AS stripe_details_submitted_9, t0.stripe_transfers_capability AS stripe_transfers_capability_10, t0.stripe_disabled_reason AS stripe_disabled_reason_11, t0.stripe_requirements_due AS stripe_requirements_due_12, t0.stripe_onboarding_started_at AS stripe_onboarding_started_at_13, t0.stripe_onboarded_at AS stripe_onboarded_at_14, t0.stripe_synced_at AS stripe_synced_at_15, t0.legal_name AS legal_name_16, t0.legal_form AS legal_form_17, t0.rcs_number AS rcs_number_18, t0.rcs_city AS rcs_city_19, t0.ape_code AS ape_code_20, t0.share_capital AS share_capital_21, t0.vat_scheme AS vat_scheme_22, t0.tax_identification_number AS tax_identification_number_23, t0.date_of_birth AS date_of_birth_24, t0.place_of_birth AS place_of_birth_25, t0.billing_email AS billing_email_26, t0.billing_mandate_accepted_at AS billing_mandate_accepted_at_27, t0.billing_mandate_version AS billing_mandate_version_28, t0.self_billing_mandate_accepted_at AS self_billing_mandate_accepted_at_29, t0.self_billing_mandate_version AS self_billing_mandate_version_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.reference AS reference_33, t0.reference_uuid AS reference_uuid_34, t0.archived AS archived_35, t0.stripe_id AS stripe_id_36, t0.user_account_id AS user_account_id_37, t0.address_id AS address_id_38, t0.logo_id AS logo_id_39, t0.created_by AS created_by_40, t0.updated_by AS updated_by_41 FROM service_provider t0 WHERE t0.user_account_id = ?
Parameters:
[
10
]
|
|
7.87 ms (6.38%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.is_verified AS is_verified_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.roles AS roles_6, t0.active AS active_7, t0.country AS country_8, t0.language AS language_9, t0.locale AS locale_10, t0.timezone AS timezone_11, t0.last_login_at AS last_login_at_12, t0.last_login_from AS last_login_from_13, t0.profile_picture_name AS profile_picture_name_14, t0.detail AS detail_15, t0.adresse AS adresse_16, t0.complement_adresse AS complement_adresse_17, t0.ville AS ville_18, t0.code_postal AS code_postal_19, t0.given_name AS given_name_20, t0.additional_name AS additional_name_21, t0.family_name AS family_name_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.reference AS reference_25, t0.reference_uuid AS reference_uuid_26, t0.archived AS archived_27, t28.stripe_customer_id AS stripe_customer_id_29, t28.id AS id_30, t28.full_name AS full_name_31, t28.honorific_prefix AS honorific_prefix_32, t28.given_name AS given_name_33, t28.additional_name AS additional_name_34, t28.family_name AS family_name_35, t28.honorific_suffix AS honorific_suffix_36, t28.nickname AS nickname_37, t28.gender AS gender_38, t28.date_of_birth AS date_of_birth_39, t28.phone AS phone_40, t28.mobile AS mobile_41, t28.created_at AS created_at_42, t28.updated_at AS updated_at_43, t28.reference AS reference_44, t28.reference_uuid AS reference_uuid_45, t28.archived AS archived_46, t28.user_account_id AS user_account_id_47, t28.address_id AS address_id_48, t28.created_by AS created_by_49, t28.updated_by AS updated_by_50, t51.id AS id_52, t51.siret AS siret_53, t51.company_name AS company_name_54, t51.vat_number AS vat_number_55, t51.stripe_account_id AS stripe_account_id_56, t51.stripe_account_type AS stripe_account_type_57, t51.stripe_charges_enabled AS stripe_charges_enabled_58, t51.stripe_payouts_enabled AS stripe_payouts_enabled_59, t51.stripe_details_submitted AS stripe_details_submitted_60, t51.stripe_transfers_capability AS stripe_transfers_capability_61, t51.stripe_disabled_reason AS stripe_disabled_reason_62, t51.stripe_requirements_due AS stripe_requirements_due_63, t51.stripe_onboarding_started_at AS stripe_onboarding_started_at_64, t51.stripe_onboarded_at AS stripe_onboarded_at_65, t51.stripe_synced_at AS stripe_synced_at_66, t51.legal_name AS legal_name_67, t51.legal_form AS legal_form_68, t51.rcs_number AS rcs_number_69, t51.rcs_city AS rcs_city_70, t51.ape_code AS ape_code_71, t51.share_capital AS share_capital_72, t51.vat_scheme AS vat_scheme_73, t51.tax_identification_number AS tax_identification_number_74, t51.date_of_birth AS date_of_birth_75, t51.place_of_birth AS place_of_birth_76, t51.billing_email AS billing_email_77, t51.billing_mandate_accepted_at AS billing_mandate_accepted_at_78, t51.billing_mandate_version AS billing_mandate_version_79, t51.self_billing_mandate_accepted_at AS self_billing_mandate_accepted_at_80, t51.self_billing_mandate_version AS self_billing_mandate_version_81, t51.created_at AS created_at_82, t51.updated_at AS updated_at_83, t51.reference AS reference_84, t51.reference_uuid AS reference_uuid_85, t51.archived AS archived_86, t51.stripe_id AS stripe_id_87, t51.user_account_id AS user_account_id_88, t51.address_id AS address_id_89, t51.logo_id AS logo_id_90, t51.created_by AS created_by_91, t51.updated_by AS updated_by_92, t0.created_by AS created_by_93, t0.updated_by AS updated_by_94 FROM "user" t0 LEFT JOIN customer t28 ON t28.user_account_id = t0.id LEFT JOIN service_provider t51 ON t51.user_account_id = t0.id INNER JOIN favorite_deceased ON t0.id = favorite_deceased.user_id WHERE favorite_deceased.deceased_id = ?
Parameters:
[
4
]
|
|
4.75 ms (3.85%) |
1 |
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.message AS message_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.reference AS reference_7, t0.reference_uuid AS reference_uuid_8, t0.placed_by_id AS placed_by_id_9, t0.deceased_id AS deceased_id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM candle t0 WHERE t0.deceased_id = ?
Parameters:
[
4
]
|
|
3.50 ms (2.83%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.is_verified AS is_verified_2, u0_.password AS password_3, u0_.reset_token AS reset_token_4, u0_.roles AS roles_5, u0_.active AS active_6, u0_.country AS country_7, u0_.language AS language_8, u0_.locale AS locale_9, u0_.timezone AS timezone_10, u0_.last_login_at AS last_login_at_11, u0_.last_login_from AS last_login_from_12, u0_.profile_picture_name AS profile_picture_name_13, u0_.detail AS detail_14, u0_.adresse AS adresse_15, u0_.complement_adresse AS complement_adresse_16, u0_.ville AS ville_17, u0_.code_postal AS code_postal_18, u0_.given_name AS given_name_19, u0_.additional_name AS additional_name_20, u0_.family_name AS family_name_21, u0_.created_at AS created_at_22, u0_.updated_at AS updated_at_23, u0_.reference AS reference_24, u0_.reference_uuid AS reference_uuid_25, u0_.archived AS archived_26, u0_.created_by AS created_by_27, u0_.updated_by AS updated_by_28 FROM "user" u0_ WHERE LOWER(u0_.email) = ? LIMIT 1
Parameters:
[
"lamiedupain65@gmail.com"
]
|
|
2.43 ms (1.97%) |
1 |
SELECT t0.stripe_customer_id AS stripe_customer_id_1, t0.id AS id_2, t0.full_name AS full_name_3, t0.honorific_prefix AS honorific_prefix_4, t0.given_name AS given_name_5, t0.additional_name AS additional_name_6, t0.family_name AS family_name_7, t0.honorific_suffix AS honorific_suffix_8, t0.nickname AS nickname_9, t0.gender AS gender_10, t0.date_of_birth AS date_of_birth_11, t0.phone AS phone_12, t0.mobile AS mobile_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.reference AS reference_16, t0.reference_uuid AS reference_uuid_17, t0.archived AS archived_18, t0.user_account_id AS user_account_id_19, t0.address_id AS address_id_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22 FROM customer t0 WHERE t0.user_account_id = ?
Parameters:
[
10
]
|
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 | 7 |
| App\Entity\Customer | 5 |
| App\Entity\Candle | 3 |
| App\Entity\Address | 1 |
| App\Entity\Deceased | 1 |
| App\Entity\Cemetery | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Deceased | No errors. |
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
| App\Entity\RefreshToken | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Candle | No errors. |
| App\Entity\PurchaseOrder | No errors. |
| App\Entity\ServiceProvider | No errors. |
| App\Entity\MediaObject | No errors. |
| App\Entity\Conversation | No errors. |
| App\Entity\Cemetery | No errors. |
| App\Entity\GraveSite | No errors. |
| App\Entity\DeceasedRequest | No errors. |
| App\Entity\Forum | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\ServicePrice | No errors. |