Query Metrics

5 Database Queries
5 Different statements
2.37 ms Query time
4 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.57 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 0.57 ms
SELECT w0_.name AS name_0, w0_.alias AS alias_1, w0_.styles AS styles_2, w0_.providers AS providers_3, w0_.mapping AS mapping_4, w0_.configs AS configs_5, w0_.options AS options_6, w0_.interactions AS interactions_7, w0_.conditions AS conditions_8, w0_.reference_roles AS reference_roles_9, w0_.status AS status_10, w0_.enabled AS enabled_11, w0_.above_fold AS above_fold_12, w0_.position AS position_13, w0_.is_source AS is_source_14, w0_.is_shortcut AS is_shortcut_15, w0_.id AS id_16, w0_.lock_expired AS lock_expired_17, w0_.created AS created_18, w0_.updated AS updated_19, w0_.deleted AS deleted_20, w0_.widget_type_id AS widget_type_id_21, w0_.layout_source_id AS layout_source_id_22, w0_.source_id AS source_id_23, w0_.root_id AS root_id_24, w0_.parent_id AS parent_id_25, w0_.layout_style_id AS layout_style_id_26, w0_.locker_id AS locker_id_27 FROM widget w0_ WHERE w0_.id = ? LIMIT 1
Parameters:
[
  "525599"
]
3 0.36 ms
SELECT t0.name AS name_1, t0.styles AS styles_2, t0.sku AS sku_3, t0.owner AS owner_4, t0.version AS version_5, t0.publishable AS publishable_6, t0.transparent AS transparent_7, t0.role AS role_8, t0.compatibles AS compatibles_9, t0.framework AS framework_10, t0.providers AS providers_11, t0.mapping AS mapping_12, t0.configs AS configs_13, t0.options AS options_14, t0.interactions AS interactions_15, t0.children AS children_16, t0.system AS system_17, t0.nilead_id AS nilead_id_18, t0.id AS id_19, t0.summary AS summary_20, t0.description AS description_21, t0.enabled AS enabled_22, t0.position AS position_23, t0.created AS created_24, t0.updated AS updated_25 FROM widget_type t0 WHERE t0.id IN (?)
Parameters:
[
  47
]
4 0.44 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:
[
  "block.widget_type"
  47
]
5 0.44 ms
SELECT t0.name AS name_1, t0.type AS type_2, t0.screens AS screens_3, t0.colors AS colors_4, t0.font_sizes AS font_sizes_5, t0.typographies AS typographies_6, t0.extra AS extra_7, t0.styles AS styles_8, t0.configs AS configs_9, t0.compiled AS compiled_10, t0.id AS id_11, t0.custom_id AS custom_id_12, t0.created AS created_13, t0.updated AS updated_14 FROM style t0 WHERE t0.id = ?
Parameters:
[
  49
]

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\TagBundle\Model\Tag 2
Nilead\TagBundle\Model\TagRelation 2
Nilead\AccountBundle\Model\Account 1
Nilead\PartyBundle\Model\Party 1
Nilead\BlockBundle\Model\Widget 1
Nilead\BlockBundle\Model\WidgetType 1
Nilead\BlockBundle\Model\Style 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\BlockBundle\Model\WidgetType No errors.
Nilead\BlockBundle\Model\Style No errors.
Nilead\ExtensionBundle\Model\Transformer No errors.
Nilead\ThemeBundle\Model\Page No errors.
Nilead\ThemeBundle\Model\Font No errors.
Nilead\BlockBundle\Model\WidgetChange 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\WidgetActivity No errors.
Nilead\BlockBundle\Model\Provider 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\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\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\PageGroup 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.