GET https://nileadtheme.mynilead.com/app_dev.php/api/2.0/pricing/currency?limit=999

Query Metrics

5 Database Queries
5 Different statements
2.00 ms Query time
4 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.74 ms
SELECT c0_.namespace AS namespace_0, c0_.name AS name_1, c0_.value AS value_2, c0_.default_value AS default_value_3, c0_.id AS id_4, c0_.type AS type_5, c0_.created AS created_6, c0_.updated AS updated_7, c0_.system AS system_8 FROM configuration c0_ WHERE c0_.namespace = ?
Parameters:
[
  "general"
]
2 0.32 ms
SELECT s0_.resource AS resource_0, s0_.doctrine_settings AS doctrine_settings_1, s0_.elastic_settings AS elastic_settings_2, s0_.system_settings AS system_settings_3, s0_.user_settings AS user_settings_4, s0_.id AS id_5, s0_.name AS name_6, s0_.parent_id AS parent_id_7, s0_.extension_id AS extension_id_8 FROM search_preset_2 s0_ WHERE s0_.name = ? LIMIT 1
Parameters:
[
  "pricing.currency"
]
3 0.24 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.configurations AS configurations_3, s0_.system AS system_4, s0_.created AS created_5, s0_.updated AS updated_6 FROM searcher s0_ WHERE s0_.name = ? LIMIT 1
Parameters:
[
  "default"
]
4 0.49 ms
SELECT DISTINCT COUNT(DISTINCT c0_.id) AS sclr_0 FROM currency c0_
Parameters:
[]
5 0.21 ms
SELECT DISTINCT c0_.id AS id_0 FROM currency c0_ ORDER BY c0_.id DESC LIMIT 25
Parameters:
[]

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\SearchBundle\Model\SearchPreset2 1
Nilead\SearchBundle\Model\Searcher 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\AccountBundle\Model\AccountToken No errors.
Nilead\SecurityBundle\Model\ResourceAssignee No errors.
Nilead\SearchBundle\Model\SearchPreset2 No errors.
Nilead\SearchBundle\Model\Searcher No errors.
Nilead\SearchBundle\Model\SearchIndex 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\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\SearchPreset No errors.
Nilead\SearchBundle\Model\SearchSave No errors.
Nilead\LocalizationBundle\Model\Phrase No errors.