Query Metrics
10
Database Queries
6
Different statements
4.95 ms
Query time
4
Invalid entities
40
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.69 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.id = ?
Parameters:
[
16366
]
|
| 2 | 0.61 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"57263057-0616-4e9e-8ad2-4861572ef659"
]
|
| 3 | 0.37 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.topic_id AS topic_id_6 FROM user_favorite_topics t0 WHERE t0.user_id = ?
Parameters:
[
16366
]
|
| 4 | 0.61 ms |
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.label AS label_2, t0_.version AS version_3, t0_.emoji AS emoji_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.target_id AS target_id_7 FROM topic t0_
Parameters:
[] |
| 5 | 0.61 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.label AS label_3, t0.version AS version_4, t0.emoji AS emoji_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.target_id AS target_id_8 FROM topic t0 WHERE t0.version = ?
Parameters:
[
2
]
|
| 6 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM topic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
22
]
|
| 7 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM topic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
21
]
|
| 8 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM topic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
25
]
|
| 9 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM topic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
24
]
|
| 10 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM topic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
23
]
|
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\Topic | 23 |
| App\Entity\TopicTranslation | 15 |
| App\Entity\User | 1 |
| App\Entity\Invitation | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Invitation | No errors. |
| App\Entity\Plan |
|
| App\Entity\Company |
|
| App\Entity\Organization | No errors. |
| App\Entity\UserOrganizationAssignment |
|
| App\Entity\UserFavoriteTopics | No errors. |
| App\Entity\Transaction | No errors. |
| App\Entity\Voucher |
|
| App\Entity\Webhook | No errors. |
| App\Entity\UserLog | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\UserOrganizationAssignmentHistory | No errors. |
| App\Entity\Issuance | No errors. |
| App\Entity\Topic | No errors. |
| App\Entity\TopicTranslation | No errors. |