Query Metrics

10 Database Queries
8 Different statements
3.72 ms Query time
4 Invalid entities
16 Managed entities

Queries

Group similar statements

# Time Info
1 0.71 ms
SELECT p0_.name AS name_0, p0_.route AS route_1, p0_.domain AS domain_2, p0_.path AS path_3, p0_.resource AS resource_4, p0_.lang AS lang_5, p0_.providers AS providers_6, p0_.layouts AS layouts_7, p0_.meta AS meta_8, p0_.custom_header_code AS custom_header_code_9, p0_.custom_footer_code AS custom_footer_code_10, p0_.etag AS etag_11, p0_.cache_ttl AS cache_ttl_12, p0_.public AS public_13, p0_.permission AS permission_14, p0_.searchable AS searchable_15, p0_.sitemap AS sitemap_16, p0_.id AS id_17, p0_.custom_id AS custom_id_18, p0_.configurations AS configurations_19, p0_.enabled AS enabled_20, p0_.created AS created_21, p0_.updated AS updated_22, p0_.deleted AS deleted_23, p0_.type AS type_24, p0_.system AS system_25, p0_.group_id AS group_id_26, p0_.og_layout AS og_layout_27, p0_.extension_id AS extension_id_28 FROM page p0_ WHERE p0_.path = ? AND p0_.route = ? LIMIT 1
Parameters:
[
  "item"
  "nilead.theme.frontend.page.sluggable_resource_show"
]
2 0.43 ms
SELECT t0.name AS name_1, t0.route AS route_2, t0.domain AS domain_3, t0.path AS path_4, t0.resource AS resource_5, t0.lang AS lang_6, t0.providers AS providers_7, t0.layouts AS layouts_8, t0.meta AS meta_9, t0.custom_header_code AS custom_header_code_10, t0.custom_footer_code AS custom_footer_code_11, t0.etag AS etag_12, t0.cache_ttl AS cache_ttl_13, t0.public AS public_14, t0.permission AS permission_15, t0.searchable AS searchable_16, t0.sitemap AS sitemap_17, t0.id AS id_18, t0.custom_id AS custom_id_19, t0.configurations AS configurations_20, t0.enabled AS enabled_21, t0.created AS created_22, t0.updated AS updated_23, t0.deleted AS deleted_24, t0.type AS type_25, t0.system AS system_26, t0.group_id AS group_id_27, t0.og_layout AS og_layout_28, t0.extension_id AS extension_id_29 FROM page t0 WHERE t0.id = ?
Parameters:
[
  595
]
3 0.38 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "595"
  "es"
  "Nilead\ThemeBundle\Model\Page"
]
4 0.26 ms
SELECT e0_.name AS name_0, e0_.route AS route_1, e0_.path AS path_2, e0_.source AS source_3, e0_.private AS private_4, e0_.id AS id_5, e0_.custom_id AS custom_id_6, e0_.description AS description_7, e0_.created AS created_8, e0_.updated AS updated_9, e0_.system AS system_10, e0_.form_definition AS form_definition_11, e0_.`references` AS references_12, e0_.configurations AS configurations_13 FROM extension e0_ WHERE e0_.source = ? AND e0_.route = ? LIMIT 1
Parameters:
[
  "content.content"
  "item"
]
5 0.43 ms
SELECT c0_.name AS name_0, c0_.summary AS summary_1, c0_.description AS description_2, c0_.position AS position_3, c0_.id AS id_4, c0_.custom_id AS custom_id_5, c0_.slug AS slug_6, c0_.featured AS featured_7, c0_.created AS created_8, c0_.updated AS updated_9, c0_.deleted AS deleted_10, c0_.lock_expired AS lock_expired_11, c0_.published AS published_12, c0_.enabled AS enabled_13, c0_.locker_id AS locker_id_14, c0_.extension_id AS extension_id_15, c0_.owner_id AS owner_id_16 FROM content c0_ WHERE c0_.slug = ? AND c0_.extension_id = ? LIMIT 1
Parameters:
[
  "polybutylene"
  56
]
6 0.40 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:
[
  "content.content"
  219
]
7 0.31 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:
[
  "content.content"
  219
]
8 0.25 ms
SELECT t0.name AS name_1, t0.summary AS summary_2, t0.description AS description_3, t0.position AS position_4, t0.id AS id_5, t0.custom_id AS custom_id_6, t0.slug AS slug_7, t0.featured AS featured_8, t0.created AS created_9, t0.updated AS updated_10, t0.deleted AS deleted_11, t0.lock_expired AS lock_expired_12, t0.published AS published_13, t0.enabled AS enabled_14, t0.locker_id AS locker_id_15, t0.extension_id AS extension_id_16, t0.owner_id AS owner_id_17 FROM content t0 WHERE t0.id = ?
Parameters:
[
  219
]
9 0.29 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:
[
  "content.content"
  219
]
10 0.26 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "219"
  "es"
  "Nilead\ContentBundle\Model\Content"
]

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\ExtensionBundle\Model\ExtensionField 13
Nilead\ThemeBundle\Model\Page 1
Nilead\ExtensionBundle\Model\Extension 1
Nilead\ContentBundle\Model\Content 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\AccountBundle\Model\Account No errors.
Nilead\AccountBundle\Model\AccountGroup No errors.
Nilead\PartyBundle\Model\Party No errors.
Nilead\ThemeBundle\Model\Email No errors.
Nilead\BlockBundle\Model\Widget No errors.
Nilead\MediaBundle\Model\File 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\PartyInbox No errors.
Nilead\PartyBundle\Model\PartyNotification No errors.
Nilead\CoreBundle\Model\AccessToken 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\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\SecurityBundle\Model\ResourceAssignee 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.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.