Query Metrics
8
Database Queries
8
Different statements
7.82 ms
Query time
4
Invalid entities
32
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.50 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.salt AS salt_5, t0.password AS password_6, t0.confirmation_token AS confirmation_token_7, t0.last_login AS last_login_8, t0.password_requested AS password_requested_9, t0.account_registered AS account_registered_10, t0.account_expired AS account_expired_11, t0.account_locked AS account_locked_12, t0.credentials_expired AS credentials_expired_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.id AS id_15, t0.enabled AS enabled_16, t0.created AS created_17, t0.updated AS updated_18, t0.party_id AS party_id_19 FROM account t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 2 | 5.43 ms |
SELECT count(p0_.id) AS sclr_0 FROM party_notification p0_ WHERE (p0_.party_id IS NULL OR p0_.party_id = ?) AND p0_.`read` IS NULL ORDER BY p0_.id DESC
Parameters:
[
6
]
|
| 3 | 0.26 ms |
SELECT p0_.summary AS summary_0, p0_.`read` AS read_1, p0_.context AS context_2, p0_.id AS id_3, p0_.type AS type_4, p0_.description AS description_5, p0_.created AS created_6, p0_.updated AS updated_7, p0_.party_id AS party_id_8 FROM party_notification p0_ WHERE p0_.party_id IS NULL OR p0_.party_id = ? ORDER BY p0_.id DESC LIMIT 25
Parameters:
[
6
]
|
| 4 | 0.56 ms |
SELECT t0.name AS name_1, t0.signature AS signature_2, t0.nilead_id AS nilead_id_3, t0.stripe_id AS stripe_id_4, t0.handle AS handle_5, t0.email AS email_6, t0.domain AS domain_7, t0.ip AS ip_8, t0.timezone AS timezone_9, t0.locale AS locale_10, t0.channel AS channel_11, t0.status AS status_12, t0.prefix AS prefix_13, t0.first_name AS first_name_14, t0.middle_name AS middle_name_15, t0.last_name AS last_name_16, t0.title AS title_17, t0.suffix AS suffix_18, t0.birth_date AS birth_date_19, t0.gender AS gender_20, t0.phone AS phone_21, t0.followup_period AS followup_period_22, t0.followup_last_notify AS followup_last_notify_23, t0.followup_next_notify AS followup_next_notify_24, t0.followup_snooze_until AS followup_snooze_until_25, t0.same_as AS same_as_26, t0.industry AS industry_27, t0.sic AS sic_28, t0.settings AS settings_29, t0.id AS id_30, t0.custom_id AS custom_id_31, t0.type AS type_32, t0.summary AS summary_33, t0.finite_state AS finite_state_34, t0.created AS created_35, t0.updated AS updated_36, t0.avatar AS avatar_37, t38.username AS username_39, t38.username_canonical AS username_canonical_40, t38.email AS email_41, t38.email_canonical AS email_canonical_42, t38.salt AS salt_43, t38.password AS password_44, t38.confirmation_token AS confirmation_token_45, t38.last_login AS last_login_46, t38.password_requested AS password_requested_47, t38.account_registered AS account_registered_48, t38.account_expired AS account_expired_49, t38.account_locked AS account_locked_50, t38.credentials_expired AS credentials_expired_51, t38.google_authenticator_secret AS google_authenticator_secret_52, t38.id AS id_53, t38.enabled AS enabled_54, t38.created AS created_55, t38.updated AS updated_56, t38.party_id AS party_id_57, t0.extension_id AS extension_id_58, t0.assignee_id AS assignee_id_59, t0.owner_id AS owner_id_60 FROM party t0 LEFT JOIN account t38 ON t38.party_id = t0.id WHERE t0.id = ?
Parameters:
[
6
]
|
| 5 | 0.30 ms |
SELECT t0.name AS name_1, t0.route AS route_2, t0.path AS path_3, t0.source AS source_4, t0.private AS private_5, t0.id AS id_6, t0.custom_id AS custom_id_7, t0.description AS description_8, t0.created AS created_9, t0.updated AS updated_10, t0.system AS system_11, t0.form_definition AS form_definition_12, t0.`references` AS references_13, t0.configurations AS configurations_14 FROM extension t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 6 | 0.33 ms |
SELECT t0_.name AS name_0, t0_.id AS id_1, t0_.color AS color_2, t0_.created AS created_3, t0_.updated AS updated_4, t1_.source AS source_5, t1_.entity_id AS entity_id_6, t1_.id AS id_7, t1_.created AS created_8, t1_.updated AS updated_9, t1_.tag_id AS tag_id_10 FROM tag t0_ INNER JOIN tag_relation t1_ ON t0_.id = t1_.tag_id AND (t1_.source = ? AND t1_.entity_id = ?)
Parameters:
[ "party.party" 6 ] |
| 7 | 0.22 ms |
SELECT e0_.field AS field_0, e0_.value AS value_1, e0_.entity_id AS entity_id_2, e0_.source AS source_3, e0_.id AS id_4 FROM extension_field e0_ WHERE e0_.source = ? AND e0_.entity_id = ?
Parameters:
[ "party.party" 6 ] |
| 8 | 0.23 ms |
SELECT t0.name AS name_1, t0.is_primary AS is_primary_2, t0.synced AS synced_3, t0.id AS id_4, t0.type AS type_5, t0.configurations AS configurations_6, t0.value AS value_7, t0.party_id AS party_id_8 FROM party_contact t0 WHERE t0.party_id = ?
Parameters:
[
6
]
|
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 |
|---|---|
| Nilead\PartyBundle\Model\PartyNotification | 25 |
| Nilead\PartyBundle\Model\PartyContact | 4 |
| Nilead\AccountBundle\Model\Account | 1 |
| Nilead\PartyBundle\Model\Party | 1 |
| Nilead\ExtensionBundle\Model\Extension | 1 |