Query Metrics
8
Database Queries
8
Different statements
7.75 ms
Query time
6
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.97 ms (25.42%) |
1 |
SELECT p0_.type AS type_0, p0_.summary AS summary_1, p0_.description AS description_2, p0_.`read` AS read_3, p0_.context AS context_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.id AS id_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
]
|
1.40 ms (18.05%) |
1 |
SELECT t0.custom_id AS custom_id_1, t0.nilead_id AS nilead_id_2, t0.stripe_id AS stripe_id_3, t0.handle AS handle_4, t0.email AS email_5, t0.type AS type_6, t0.domain AS domain_7, t0.ip AS ip_8, t0.title AS title_9, t0.prefix AS prefix_10, t0.name AS name_11, t0.first_name AS first_name_12, t0.middle_name AS middle_name_13, t0.last_name AS last_name_14, t0.suffix AS suffix_15, t0.birth_date AS birth_date_16, t0.gender AS gender_17, t0.summary AS summary_18, t0.signature AS signature_19, t0.phone AS phone_20, t0.status AS status_21, t0.finite_state AS finite_state_22, t0.channel AS channel_23, t0.industry AS industry_24, t0.sic AS sic_25, t0.same_as AS same_as_26, t0.followup_period AS followup_period_27, t0.followup_last_notify AS followup_last_notify_28, t0.followup_next_notify AS followup_next_notify_29, t0.followup_snooze_until AS followup_snooze_until_30, t0.created AS created_31, t0.updated AS updated_32, t0.timezone AS timezone_33, t0.locale AS locale_34, t0.settings AS settings_35, t0.id AS id_36, t37.username AS username_38, t37.username_canonical AS username_canonical_39, t37.email AS email_40, t37.email_canonical AS email_canonical_41, t37.salt AS salt_42, t37.password AS password_43, t37.confirmation_token AS confirmation_token_44, t37.enabled AS enabled_45, t37.last_login AS last_login_46, t37.password_requested AS password_requested_47, t37.account_registered AS account_registered_48, t37.account_expired AS account_expired_49, t37.account_locked AS account_locked_50, t37.credentials_expired AS credentials_expired_51, t37.google_authenticator_secret AS google_authenticator_secret_52, t37.created AS created_53, t37.updated AS updated_54, t37.id AS id_55, t37.party_id AS party_id_56, t0.avatar AS avatar_57, t0.extension_id AS extension_id_58, t0.owner_id AS owner_id_59, t0.assignee_id AS assignee_id_60 FROM party t0 LEFT JOIN account t37 ON t37.party_id = t0.id WHERE t0.id = ?
Parameters:
[
6
]
|
1.29 ms (16.63%) |
1 |
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.enabled AS enabled_8, t0.last_login AS last_login_9, t0.password_requested AS password_requested_10, t0.account_registered AS account_registered_11, t0.account_expired AS account_expired_12, t0.account_locked AS account_locked_13, t0.credentials_expired AS credentials_expired_14, t0.google_authenticator_secret AS google_authenticator_secret_15, t0.created AS created_16, t0.updated AS updated_17, t0.id AS id_18, t0.party_id AS party_id_19 FROM account t0 WHERE t0.id = ?
Parameters:
[
3
]
|
0.83 ms (10.68%) |
1 |
SELECT t0.name AS name_1, t0.summary AS summary_2, t0.path AS path_3, t0.converted_path AS converted_path_4, t0.size AS size_5, t0.metas AS metas_6, t0.ext AS ext_7, t0.unique_key AS unique_key_8, t0.type AS type_9, t0.filesystem AS filesystem_10, t0.token AS token_11, t0.folder AS folder_12, t0.object_id AS object_id_13, t0.object_source AS object_source_14, t0.created AS created_15, t0.updated AS updated_16, t0.external AS external_17, t0.id AS id_18 FROM file t0 WHERE t0.id = ?
Parameters:
[
18972
]
|
0.73 ms (9.38%) |
1 |
SELECT t0.custom_id AS custom_id_1, t0.name AS name_2, t0.route AS route_3, t0.path AS path_4, t0.source AS source_5, t0.description AS description_6, t0.form_definition AS form_definition_7, t0.`references` AS references_8, t0.configurations AS configurations_9, t0.system AS system_10, t0.private AS private_11, t0.created AS created_12, t0.updated AS updated_13, t0.id AS id_14 FROM extension t0 WHERE t0.id = ?
Parameters:
[
11
]
|
0.60 ms (7.78%) |
1 |
SELECT t0_.name AS name_0, t0_.color AS color_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.id AS id_4, t1_.entity_id AS entity_id_5, t1_.source AS source_6, t1_.created AS created_7, t1_.updated AS updated_8, t1_.id AS id_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 ] |
0.57 ms (7.29%) |
1 |
SELECT t0.name AS name_1, t0.type AS type_2, t0.value AS value_3, t0.is_primary AS is_primary_4, t0.synced AS synced_5, t0.configs AS configs_6, t0.id AS id_7, t0.party_id AS party_id_8 FROM party_contact t0 WHERE t0.party_id = ?
Parameters:
[
6
]
|
0.37 ms (4.76%) |
1 |
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
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
Nilead\SettingBundle\Model\Configuration | No errors. |
Nilead\ThemeBundle\Model\Theme | No errors. |
Nilead\LocalizationBundle\Model\Language | No errors. |
Nilead\SecurityBundle\Model\Token | No errors. |
Nilead\MediaBundle\Model\File | No errors. |
Nilead\BlockBundle\Model\Widget | No errors. |
Nilead\CartBundle\Model\Cart | No errors. |
Nilead\InventoryBundle\Model\InventoryItem |
|
Nilead\ExtensionBundle\Model\Extension | No errors. |
Nilead\QueueBundle\Model\JobLog | No errors. |
Nilead\SeoBundle\Model\Route | No errors. |
Nilead\TaxonBundle\Model\Taxon | No errors. |
Nilead\TicketBundle\Model\Ticket | No errors. |
Nilead\CommentBundle\Model\Thread | No errors. |
Nilead\CommentBundle\Model\Comment | No errors. |
Nilead\PartyBundle\Model\Party | No errors. |
Nilead\PartyBundle\Model\PartyInbox | No errors. |
Nilead\PartyBundle\Model\PartyNotification | No errors. |
Nilead\ThemeBundle\Model\Email | No errors. |
Nilead\CoreBundle\Model\AccessToken | No errors. |
Nilead\SearchBundle\Model\SearchSave | No errors. |
Nilead\AccountBundle\Model\Account | No errors. |
Nilead\AccountBundle\Model\AccountGroup | No errors. |
Nilead\SecurityBundle\Model\ResourceAssignee | No errors. |
Nilead\SearchBundle\Model\Searcher | No errors. |
Nilead\SearchBundle\Model\SearchIndex | No errors. |
Nilead\SearchBundle\Model\SearchPreset | No errors. |
Nilead\AddressBundle\Model\Address | No errors. |
Nilead\AddressBundle\Model\GeoBoundary | No errors. |
Nilead\BlockBundle\Model\Wireframe | No errors. |
Nilead\BlockBundle\Model\DesignProject |
|
Nilead\BlockBundle\Model\DesignPage |
|
Nilead\BlockBundle\Model\DesignSection | No errors. |
Nilead\BlockBundle\Model\DesignFeedback | No errors. |
Nilead\BlockBundle\Model\DesignStyle | No errors. |
Nilead\InventoryBundle\Model\Container | No errors. |
Nilead\InventoryBundle\Model\ContainerType | No errors. |
Nilead\InventoryBundle\Model\StockItem | No errors. |
Nilead\InventoryBundle\Model\InventoryItemVariance | No errors. |
Nilead\InventoryBundle\Model\InventoryItemVarianceReason | No errors. |
Nilead\MediaBundle\Model\GalleryItem | No errors. |
Nilead\MediaBundle\Model\Gallery | No errors. |
Nilead\PartyBundle\Model\PartyList | No errors. |
Nilead\PaymentBundle\Model\CollectionNote | No errors. |
Nilead\PaymentBundle\Model\CollectionNoteItem | No errors. |
Nilead\ProductBundle\Model\PropertyGroup | No errors. |
Nilead\ProductBundle\Model\ProductProperty | No errors. |
Nilead\ProductBundle\Model\VariantVersion | No errors. |
Nilead\ProductBundle\Model\Product | No errors. |
Nilead\ProjectBundle\Model\PlanPrototype | No errors. |
Nilead\ProjectBundle\Model\Milestone | No errors. |
Nilead\ReviewBundle\Model\Review | No errors. |
Nilead\ReviewBundle\Model\Rate | No errors. |
Nilead\ReviewBundle\Model\RatingSummary | No errors. |
Nilead\SalesBundle\Model\SubscriptionItem | No errors. |
Nilead\SalesBundle\Model\Stage | No errors. |
Nilead\SalesBundle\Model\Deal | No errors. |
Nilead\SalesBundle\Model\Campaign | No errors. |
Nilead\SalesBundle\Model\Order | No errors. |
Nilead\SalesBundle\Model\OrderItem | No errors. |
Nilead\SeoBundle\Model\Seo | No errors. |
Nilead\SeoBundle\Model\RouteSeo | No errors. |
Nilead\SeoBundle\Model\Audience | No errors. |
Nilead\SeoBundle\Model\Experiment | No errors. |
Nilead\ShipmentBundle\Model\ShipmentItem |
|
Nilead\ShipmentBundle\Model\ShippingCategory | No errors. |
Nilead\ShipmentBundle\Model\ShippingMethodAdjuster | No errors. |
Nilead\ShipmentBundle\Model\Rule | No errors. |
Nilead\TaxationBundle\Model\TaxCategory | No errors. |
Nilead\ThemeBundle\Model\PageGroup | No errors. |
Nilead\CoreBundle\Model\Draft | No errors. |
Nilead\FlowBundle\Model\Flow | No errors. |
Nilead\BlockBundle\Model\WidgetType | No errors. |
Nilead\BlockBundle\Model\WidgetActivity | No errors. |
Nilead\BlockBundle\Model\Provider | No errors. |
Nilead\BlockBundle\Model\Style | No errors. |
Nilead\CartBundle\Model\CartItem | No errors. |
Nilead\CartBundle\Model\WishList | No errors. |
Nilead\CartBundle\Model\WishListItem | No errors. |
Nilead\CheckoutBundle\Model\CheckoutContext | No errors. |
Nilead\ContentBundle\Model\Content | No errors. |
Nilead\DiscountBundle\Model\Discount | No errors. |
Nilead\ExtensionBundle\Model\Entity | No errors. |
Nilead\ExtensionBundle\Model\ExtensionField | No errors. |
Nilead\ExtensionBundle\Model\Transformer | No errors. |
Nilead\InventoryBundle\Model\Facility | No errors. |
Nilead\InventoryBundle\Model\InventoryItemAdjustment | No errors. |
Nilead\LogBundle\Model\Activity | No errors. |
Nilead\NotificationBundle\Model\Hook | No errors. |
Nilead\NotificationBundle\Model\HookInstance | No errors. |
Nilead\NotificationBundle\Model\HookSchedule |
|
Nilead\NotificationBundle\Model\HookReport | No errors. |
Nilead\NotificationBundle\Model\Notification | No errors. |
Nilead\NotificationBundle\Model\NotificationEvent | No errors. |
Nilead\NotificationBundle\Model\NotificationBatch | No errors. |
Nilead\PartyBundle\Model\PartyContact | No errors. |
Nilead\PartyBundle\Model\PartyOauth | No errors. |
Nilead\PartyBundle\Model\PartySetting | No errors. |
Nilead\PartyBundle\Model\PartyConversation | No errors. |
Nilead\PartyBundle\Model\Organization | No errors. |
Nilead\PaymentBundle\Model\Invoice | No errors. |
Nilead\PaymentBundle\Model\InvoiceItem | No errors. |
Nilead\PaymentBundle\Model\InvoiceAddress | No errors. |
Nilead\PaymentBundle\Model\Transaction | No errors. |
Nilead\PaymentBundle\Model\PaymentMethod | No errors. |
Nilead\PaymentBundle\Model\PaymentReference | No errors. |
Nilead\PricingBundle\Model\Currency |
|
Nilead\ProductBundle\Model\Property | No errors. |
Nilead\ProductBundle\Model\Option | No errors. |
Nilead\ProductBundle\Model\OptionValue | No errors. |
Nilead\ProductBundle\Model\Prototype | No errors. |
Nilead\ProductBundle\Model\Variant | No errors. |
Nilead\ProjectBundle\Model\Plan | No errors. |
Nilead\ProjectBundle\Model\PlanTask | No errors. |
Nilead\ProjectBundle\Model\TransactionEntry | No errors. |
Nilead\ProjectBundle\Model\TransactionType | No errors. |
Nilead\QueueBundle\Model\CronJob | No errors. |
Nilead\SalesBundle\Model\OrderAdjustment | No errors. |
Nilead\SalesBundle\Model\OrderRole | No errors. |
Nilead\SalesBundle\Model\Subscription | No errors. |
Nilead\SalesBundle\Model\Pipeline | No errors. |
Nilead\SeoBundle\Model\Redirect | No errors. |
Nilead\SeoBundle\Model\CustomUrl | No errors. |
Nilead\ShipmentBundle\Model\Shipment | No errors. |
Nilead\ShipmentBundle\Model\ShipmentAddress | No errors. |
Nilead\ShipmentBundle\Model\ShippingCarrier | No errors. |
Nilead\ShipmentBundle\Model\ShippingMethod | No errors. |
Nilead\TagBundle\Model\Tag | No errors. |
Nilead\TagBundle\Model\TagRelation | No errors. |
Nilead\TaskBundle\Model\Task | No errors. |
Nilead\TaxationBundle\Model\TaxRate | No errors. |
Nilead\ThemeBundle\Model\ThemeFile | No errors. |
Nilead\ThemeBundle\Model\Page | No errors. |
Nilead\ThemeBundle\Model\Font | No errors. |
Nilead\CoreBundle\Model\Migration | No errors. |
Nilead\CoreBundle\Model\MigrationRun | No errors. |
Nilead\CoreBundle\Model\MigrationPassData | No errors. |
Nilead\LocalizationBundle\Model\Phrase | No errors. |