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

Query Metrics

8 Database Queries
8 Different statements
7.75 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.29 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.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
]
2 0.37 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 1.97 ms
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
]
4 1.40 ms
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
]
5 0.73 ms
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
]
6 0.60 ms
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
]
7 0.83 ms
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
]
8 0.57 ms
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
]

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
  • 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\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
  • The field Nilead\BlockBundle\Model\DesignProject#styles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Nilead\BlockBundle\Model\DesignStyle#project does not contain the required 'inversedBy="styles"' attribute.
  • 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\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
  • 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\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
  • The association Nilead\NotificationBundle\Model\HookSchedule#hookInstance refers to the inverse side field Nilead\NotificationBundle\Model\HookInstance#hookSchedules which does not exist.
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
  • The field 'Nilead\PricingBundle\Model\Currency#rate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
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.