Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.79 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.22 ms
(88.01%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9 FROM sylius_channel t0 WHERE t0.code = ? ORDER BY t0.id ASC LIMIT 1

Parameters:

[
  "web"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9
FROM
  sylius_channel t0
WHERE
  t0.code = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9 FROM sylius_channel t0 WHERE t0.code = 'web' ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->findOneByCode (line 42)
4	AppBundle\Sylius\Channel\ChannelResolver->doGetChannel (line 55)
5	AppBundle\Sylius\Channel\ChannelResolver->findChannel (line 40)
6	Sylius\Component\Channel\Context\RequestBased\CompositeRequestResolver->findChannel (line 38)
7	Sylius\Component\Channel\Context\RequestBased\ChannelContext->getChannelForRequest (line 39)
8	Sylius\Component\Channel\Context\RequestBased\ChannelContext->getChannel (line 31)
9	Sylius\Component\Channel\Context\CompositeChannelContext->getChannel (line 38)
10	Sylius\Bundle\ChannelBundle\Collector\ChannelCollector->collect (line 54)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 169)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 108)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 214)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 202)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 239)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
27	Symfony\Component\HttpKernel\Kernel->handle (line 208)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.57 ms
(11.99%)

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.code AS code_0,
  s0_.name AS name_1,
  s0_.hostname AS hostname_2
FROM
  sylius_channel s0_

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	Sylius\Bundle\ChannelBundle\Doctrine\ORM\ChannelRepository->findAllWithBasicData (line 55)
7	Sylius\Bundle\ChannelBundle\Collector\ChannelCollector->collect (line 61)
8	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 169)
9	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 108)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 214)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 202)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 117)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
22	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 239)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
24	Symfony\Component\HttpKernel\Kernel->handle (line 208)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

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
Sylius\Component\Channel\Model\Channel	1

Entities Mapping

Class	Mapping errors
Sylius\Component\Product\Model\Product	No errors.
AppBundle\Entity\Sylius\Product	No errors.
Sylius\Component\Product\Model\ProductOptionValue	No errors.
AppBundle\Entity\Sylius\ProductOptionValue	No errors.
Sylius\Component\Product\Model\ProductVariant	No errors.
AppBundle\Entity\Sylius\ProductVariant	No errors.
Sylius\Component\Taxation\Model\TaxCategory	No errors.
AppBundle\Entity\Sylius\TaxCategory	No errors.
Sylius\Component\Promotion\Model\Promotion	No errors.
AppBundle\Entity\Sylius\Promotion	No errors.
Sylius\Component\Order\Model\Order	No errors.
AppBundle\Entity\Sylius\Order	No errors.
AppBundle\Entity\TaskCollection	No errors.
AppBundle\Entity\Delivery	No errors.
Sylius\Component\Promotion\Model\PromotionCoupon	No errors.
AppBundle\Entity\Sylius\PromotionCoupon	No errors.
AppBundle\Entity\Zone	No errors.
Sylius\Component\Currency\Model\ExchangeRate	No errors.
AppBundle\Entity\LocalBusiness	No errors.
Sylius\Component\Product\Model\ProductOption	No errors.
AppBundle\Entity\Sylius\ProductOption	No errors.
Sylius\Component\Taxation\Model\TaxRate	No errors.
AppBundle\Entity\Sylius\TaxRate	No errors.
Sylius\Component\Payment\Model\PaymentMethod	No errors.
Sylius\Component\Taxonomy\Model\Taxon	No errors.
AppBundle\Entity\Sylius\Taxon	No errors.
AppBundle\Entity\Sylius\ProductOptions	No errors.
Sylius\Component\Attribute\Model\AttributeValue	No errors.
Sylius\Component\Product\Model\ProductAttributeValue	No errors.
Sylius\Component\Product\Model\ProductAssociation	No errors.
AppBundle\Entity\Sylius\ProductImage	No errors.
AppBundle\Entity\ReusablePackagings	No errors.
Sylius\Component\Product\Model\ProductTranslation	No errors.
AppBundle\Entity\Delivery\PricingRule	No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation	No errors.
AppBundle\Entity\Sylius\ProductVariantOptionValue	No errors.
AppBundle\Entity\BusinessRestaurantGroup	No errors.
AppBundle\Entity\Delivery\PricingRuleSet	No errors.
Sylius\Component\Product\Model\ProductVariantTranslation	No errors.
AppBundle\Entity\Sylius\ProductVariantTranslation	No errors.
AppBundle\Entity\Sylius\TaxCategoryCountry	No errors.
Sylius\Component\Promotion\Model\PromotionTranslation	No errors.
Sylius\Component\Promotion\Model\PromotionRule	No errors.
Sylius\Component\Promotion\Model\PromotionAction	No errors.
AppBundle\Entity\Sylius\OrderTimeline	No errors.
AppBundle\Entity\Sylius\FrozenOrder	No errors.
AppBundle\Entity\Sylius\OrderReceipt	No errors.
AppBundle\Entity\Sylius\OrderInvitation	No errors.
AppBundle\Entity\Sylius\LoopeatOrderDetails	No errors.
AppBundle\Entity\LoopEat\OrderCredentials	No errors.
Sylius\Component\Payment\Model\Payment	No errors.
AppBundle\Entity\Sylius\Payment	No errors.
AppBundle\Entity\Sylius\OrderEvent	No errors.
Sylius\Component\Order\Model\OrderItem	No errors.
AppBundle\Entity\Sylius\OrderItem	No errors.
Sylius\Component\Order\Model\Adjustment	No errors.
AppBundle\Entity\Sylius\OrderVendor	No errors.
AppBundle\Entity\Sylius\OrderBookmark	No errors.
AppBundle\Entity\Sylius\OrderExport	No errors.
AppBundle\Entity\Base\PostalAddress	No errors.
AppBundle\Entity\Address	No errors.
Sylius\Component\Channel\Model\Channel	No errors.
AppBundle\Entity\BusinessAccount	No errors.
AppBundle\Entity\Task\RecurrenceRule	No errors.
Sylius\Component\Customer\Model\Customer	No errors.
AppBundle\Entity\Sylius\Customer	No errors.
AppBundle\Entity\TaskCollectionItem	No errors.
AppBundle\Entity\Store	No errors.
Sylius\Component\Currency\Model\Currency	No errors.
AppBundle\Entity\Restaurant\Pledge	No errors.
AppBundle\Entity\MercadopagoAccount	No errors.
AppBundle\Entity\Restaurant\PreparationTimeRule	No errors.
AppBundle\Entity\RestaurantStripeAccount	No errors.
AppBundle\Entity\ReusablePackaging	No errors.
AppBundle\Entity\LocalBusiness\DayOfWeekAddress	No errors.
AppBundle\Entity\LocalBusiness\DayOfWeekDeliveryPerimeterExpression	No errors.
AppBundle\Entity\Contract	No errors.
AppBundle\Entity\Organization	No errors.
AppBundle\Entity\Hub	No errors.
AppBundle\Entity\Delivery\FailureReasonSet	No errors.
AppBundle\Entity\LocalBusiness\FulfillmentMethod	No errors.
AppBundle\Entity\ClosingRule	No errors.
AppBundle\Entity\Cuisine	No errors.
Nucleos\UserBundle\Model\User	No errors.
AppBundle\Entity\User	No errors.
Sylius\Component\Product\Model\ProductOptionTranslation	No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation	No errors.
AppBundle\Entity\Sylius\ProductTaxon	No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation	No errors.
Craue\ConfigBundle\Entity\BaseSetting	No errors.
AppBundle\Entity\Delivery\ImportQueue	No errors.
AppBundle\Entity\LocalBusiness\CollectionItem	No errors.
AppBundle\Entity\BusinessAccountInvitation	No errors.
AppBundle\Entity\Tagging	No errors.
AppBundle\Entity\TaskList	No errors.
AppBundle\Entity\Woopit\QuoteRequest	No errors.
AppBundle\Entity\Edenred\CustomerCredentials	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
AppBundle\Entity\RefreshToken	No errors.
AppBundle\Entity\Task\Group	No errors.
AppBundle\Entity\Restaurant\PledgeVote	No errors.
AppBundle\Entity\DeliveryQuote	No errors.
AppBundle\Entity\Sylius\FrozenOrderFooterItem	No errors.
AppBundle\Entity\StoreTimeSlot	No errors.
AppBundle\Entity\RemotePushToken	No errors.
AppBundle\Entity\Sylius\ExportCommand	No errors.
AppBundle\Entity\Task\ImportQueue	No errors.
AppBundle\Entity\BusinessRestaurantGroupRestaurantMenu	No errors.
AppBundle\Entity\TaskEvent	No errors.
AppBundle\Entity\LocalBusiness\Collection	No errors.
AppBundle\Entity\Bot	No errors.
AppBundle\Entity\Sylius\FrozenOrderLineItem	No errors.
AppBundle\Entity\Woopit\WoopitIntegration	No errors.
AppBundle\Entity\Trailer	No errors.
AppBundle\Entity\Delivery\FailureReason	No errors.
AppBundle\Entity\Refund	No errors.
AppBundle\Entity\Incident\Incident	No errors.
AppBundle\Entity\Urbantz\Hub	No errors.
AppBundle\Entity\CityZone	No errors.
AppBundle\Entity\TaskList\Item	No errors.
AppBundle\Entity\CubeJsonQuery	No errors.
AppBundle\Entity\Webhook	No errors.
AppBundle\Entity\Invitation	No errors.
AppBundle\Entity\Urbantz\Delivery	No errors.
AppBundle\Entity\PackageSet	No errors.
AppBundle\Entity\DeliveryForm	No errors.
AppBundle\Entity\Setting	No errors.
AppBundle\Entity\Tag	No errors.
AppBundle\Entity\Task	No errors.
AppBundle\Entity\WebhookExecution	No errors.
AppBundle\Entity\Vehicle\Trailer	No errors.
AppBundle\Entity\DeliveryFormSubmission	No errors.
AppBundle\Entity\Incident\IncidentEvent	No errors.
AppBundle\Entity\Edifact\EDIFACTMessage	No errors.
AppBundle\Entity\OptinConsent	No errors.
AppBundle\Entity\UI\HomepageBlock	No errors.
AppBundle\Entity\Tour	No errors.
AppBundle\Entity\TimeSlot	No errors.
AppBundle\Entity\Package	No errors.
AppBundle\Entity\Vehicle	No errors.
AppBundle\Entity\TrackingPosition	No errors.
AppBundle\Entity\Incident\IncidentImage	No errors.
AppBundle\Entity\LoopEat\CustomerCredentials	No errors.
AppBundle\Entity\Sylius\OrderReceiptFooterItem	No errors.
AppBundle\Entity\Woopit\Delivery	No errors.
AppBundle\Entity\TaskImage	No errors.
AppBundle\Entity\Warehouse	No errors.
AppBundle\Entity\Paygreen\CustomerDetails	No errors.
AppBundle\Entity\Sylius\OrderReceiptLineItem	No errors.
AppBundle\Entity\StripeAccount	No errors.
AppBundle\Entity\Notification	No errors.
AppBundle\Entity\Task\Package	No errors.
AppBundle\Entity\ApiApp	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Sylius\Component\Locale\Model\Locale	No errors.
Sylius\Component\Attribute\Model\AttributeTranslation	No errors.
Sylius\Component\Attribute\Model\Attribute	No errors.
Sylius\Component\Order\Model\OrderSequence	No errors.
Sylius\Component\Order\Model\OrderItemUnit	No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation	No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation	No errors.
Sylius\Component\Product\Model\ProductAssociationType	No errors.
Sylius\Component\Product\Model\ProductAttribute	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionAction	No errors.
Sylius\Component\Promotion\Model\CatalogPromotion	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionTranslation	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionScope	No errors.
Sylius\Component\Customer\Model\CustomerGroup	No errors.
League\Bundle\OAuth2ServerBundle\Model\AbstractClient	No errors.
League\Bundle\OAuth2ServerBundle\Model\AuthorizationCode	No errors.
League\Bundle\OAuth2ServerBundle\Model\RefreshToken	No errors.
League\Bundle\OAuth2ServerBundle\Model\Client	No errors.
League\Bundle\OAuth2ServerBundle\Model\AccessToken	No errors.
Nucleos\UserBundle\Model\Group	No errors.

Symfony Profiler

HEAD http://dev.shamscout.delivery/en/favicon.ico

Configuration Settings

Theme

Page Width