GET https://nileadtheme.mynilead.com/app_dev.php/backend/party/party_notification/summary.json

Query Metrics

8 Database Queries
8 Different statements
7.82 ms Query time
4 Invalid entities
32 Managed entities

Queries

Group similar statements

# 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

Entities Mapping

Class Mapping errors
Nilead\SeoBundle\Model\Redirect No errors.
Nilead\SettingBundle\Model\Configuration No errors.
Nilead\ThemeBundle\Model\Theme No errors.
Nilead\LocalizationBundle\Model\Language No errors.
Nilead\MediaBundle\Model\File No errors.
Nilead\BlockBundle\Model\Widget No errors.
Nilead\CartBundle\Model\Cart No errors.
Nilead\InventoryBundle\Model\InventoryItem
  • The association Nilead\InventoryBundle\Model\InventoryItem#stockable refers to the inverse side field Nilead\ProductBundle\Model\Variant#inventoryItems which does not exist.
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\AccountBundle\Model\Account No errors.
Nilead\AccountBundle\Model\AccountGroup No errors.
Nilead\SecurityBundle\Model\ResourceAssignee No errors.
Nilead\SearchBundle\Model\SearchPreset2 No errors.
Nilead\SearchBundle\Model\Searcher No errors.
Nilead\AccountBundle\Model\AccountToken No errors.
Nilead\AddressBundle\Model\Address No errors.
Nilead\AddressBundle\Model\GeoBoundary 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\BlockBundle\Model\Wireframe No errors.
Nilead\BlockBundle\Model\DesignProject
  • The field Nilead\BlockBundle\Model\DesignProject#feedback is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Nilead\BlockBundle\Model\DesignFeedback#project does not contain the required 'inversedBy="feedback"' attribute.
Nilead\BlockBundle\Model\DesignPage
  • The field Nilead\BlockBundle\Model\DesignPage#childPages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Nilead\BlockBundle\Model\DesignPage#parentPage does not contain the required 'inversedBy="childPages"' attribute.
  • The field Nilead\BlockBundle\Model\DesignPage#sections is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Nilead\BlockBundle\Model\DesignSection#page does not contain the required 'inversedBy="sections"' attribute.
Nilead\BlockBundle\Model\DesignSection No errors.
Nilead\BlockBundle\Model\DesignFeedback No errors.
Nilead\BlockBundle\Model\DesignMessage 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\Container No errors.
Nilead\InventoryBundle\Model\ContainerType No errors.
Nilead\InventoryBundle\Model\Facility No errors.
Nilead\InventoryBundle\Model\StockItem No errors.
Nilead\InventoryBundle\Model\InventoryItemAdjustment No errors.
Nilead\InventoryBundle\Model\InventoryItemVariance No errors.
Nilead\InventoryBundle\Model\InventoryItemVarianceReason No errors.
Nilead\LogBundle\Model\Activity No errors.
Nilead\NavigationBundle\Model\Navigation No errors.
Nilead\NotificationBundle\Model\Hook No errors.
Nilead\NotificationBundle\Model\HookInstance No errors.
Nilead\NotificationBundle\Model\HookSchedule No errors.
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\PartyConversation No errors.
Nilead\PartyBundle\Model\PartyList 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\CollectionNote No errors.
Nilead\PaymentBundle\Model\CollectionNoteItem No errors.
Nilead\PaymentBundle\Model\PaymentMethod No errors.
Nilead\PaymentBundle\Model\PaymentReference No errors.
Nilead\PricingBundle\Model\Currency No errors.
Nilead\ProductBundle\Model\Product No errors.
Nilead\ProductBundle\Model\Property No errors.
Nilead\ProductBundle\Model\PropertyGroup No errors.
Nilead\ProductBundle\Model\ProductProperty 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\ProductBundle\Model\VariantVersion No errors.
Nilead\ProjectBundle\Model\Plan No errors.
Nilead\ProjectBundle\Model\PlanPrototype No errors.
Nilead\ProjectBundle\Model\Milestone 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\ReviewBundle\Model\Review No errors.
Nilead\ReviewBundle\Model\Rate No errors.
Nilead\ReviewBundle\Model\RatingSummary No errors.
Nilead\SalesBundle\Model\Order No errors.
Nilead\SalesBundle\Model\OrderItem No errors.
Nilead\SalesBundle\Model\OrderAdjustment No errors.
Nilead\SalesBundle\Model\OrderRole No errors.
Nilead\SalesBundle\Model\Subscription No errors.
Nilead\SalesBundle\Model\SubscriptionItem No errors.
Nilead\SalesBundle\Model\Pipeline No errors.
Nilead\SalesBundle\Model\Stage No errors.
Nilead\SalesBundle\Model\Deal No errors.
Nilead\SalesBundle\Model\Campaign No errors.
Nilead\SecurityBundle\Model\Token No errors.
Nilead\SeoBundle\Model\Seo No errors.
Nilead\SeoBundle\Model\RouteSeo No errors.
Nilead\SeoBundle\Model\CustomUrl No errors.
Nilead\SeoBundle\Model\Audience No errors.
Nilead\SeoBundle\Model\Experiment No errors.
Nilead\ShipmentBundle\Model\Shipment No errors.
Nilead\ShipmentBundle\Model\ShipmentItem
  • The field Nilead\ShipmentBundle\Model\ShipmentItem#inventoryItemAdjustments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Nilead\InventoryBundle\Model\InventoryItemAdjustment#shipmentItem does not contain the required 'inversedBy="inventoryItemAdjustments"' attribute.
Nilead\ShipmentBundle\Model\ShipmentAddress No errors.
Nilead\ShipmentBundle\Model\ShippingCarrier No errors.
Nilead\ShipmentBundle\Model\ShippingCategory No errors.
Nilead\ShipmentBundle\Model\ShippingMethod No errors.
Nilead\ShipmentBundle\Model\ShippingMethodAdjuster No errors.
Nilead\ShipmentBundle\Model\Rule No errors.
Nilead\TagBundle\Model\Tag No errors.
Nilead\TagBundle\Model\TagRelation No errors.
Nilead\TaskBundle\Model\Task No errors.
Nilead\TaxationBundle\Model\TaxCategory No errors.
Nilead\TaxationBundle\Model\TaxRate No errors.
Nilead\ThemeBundle\Model\ThemeFile No errors.
Nilead\ThemeBundle\Model\Page No errors.
Nilead\ThemeBundle\Model\PageGroup No errors.
Nilead\ThemeBundle\Model\Font No errors.
Nilead\CoreBundle\Model\Draft No errors.
Nilead\CoreBundle\Model\Export No errors.
Nilead\CoreBundle\Model\Migration No errors.
Nilead\CoreBundle\Model\MigrationRun No errors.
Nilead\CoreBundle\Model\MigrationPassData No errors.
Nilead\FlowBundle\Model\Flow No errors.
Nilead\SearchBundle\Model\SearchIndex No errors.
Nilead\SearchBundle\Model\SearchPreset No errors.
Nilead\SearchBundle\Model\SearchSave No errors.
Nilead\LocalizationBundle\Model\Phrase No errors.