Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.19 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.31 ms

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.active AS active_3, c0_.slug AS slug_4, c0_.promoted AS promoted_5, c0_.image_path AS image_path_6, c0_.active_product_count AS active_product_count_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.active = ? ORDER BY c0_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.position AS position_1,
  c0_.name AS name_2,
  c0_.active AS active_3,
  c0_.slug AS slug_4,
  c0_.promoted AS promoted_5,
  c0_.image_path AS image_path_6,
  c0_.active_product_count AS active_product_count_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
WHERE
  c0_.parent_id IS NULL
  AND c0_.active = ?
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.position AS position_1, c0_.name AS name_2, c0_.active AS active_3, c0_.slug AS slug_4, c0_.promoted AS promoted_5, c0_.image_path AS image_path_6, c0_.active_product_count AS active_product_count_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.active = 1 ORDER BY c0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\HomeController->menuCategories (line 103)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
14	__TwigTemplate_3bf5d59318e18a9425ed37295ba89bd1->doDisplay (line 297)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_6fe63fbd20178586564fca3ac72a4f03->doDisplay (line 60)
17	Twig\Template->yield (line 461)
18	Twig\Template->display (line 416)
19	Twig\Template->render (line 431)
20	Twig\TemplateWrapper->render (line 53)
21	Twig\Environment->render (line 343)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\PageController->about (line 36)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 7)

0.88 ms

SELECT COUNT(c0_.id) AS sclr_0 FROM cart c1_ LEFT JOIN cart_item c0_ ON c1_.id = c0_.cart_id WHERE c1_.session_id = ?

Parameters:

[
  "59a0b11bb34aa87ccbfadbcd8eeced91"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cart c1_
  LEFT JOIN cart_item c0_ ON c1_.id = c0_.cart_id
WHERE
  c1_.session_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM cart c1_ LEFT JOIN cart_item c0_ ON c1_.id = c0_.cart_id WHERE c1_.session_id = '59a0b11bb34aa87ccbfadbcd8eeced91';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\CartRepository->countItemsForSessionId (line 109)
8	App\Service\HeaderViewService->getCartItemCount (line 37)
9	Twig\Extension\CoreExtension->getAttribute (line 1996)
10	__TwigTemplate_3bf5d59318e18a9425ed37295ba89bd1::doDisplay (line 528)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_6fe63fbd20178586564fca3ac72a4f03->doDisplay (line 60)
13	Twig\Template->yield (line 461)
14	Twig\Template->display (line 416)
15	Twig\Template->render (line 431)
16	Twig\TemplateWrapper->render (line 53)
17	Twig\Environment->render (line 343)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\PageController->about (line 36)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 7)

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
App\Entity\Category	5

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\CategoryTag	No errors.
Money\Currency	No errors.
Money\Money	No errors.
App\Entity\Product	No errors.
App\Entity\CategoryPromotion	No errors.
App\Entity\Supplier	No errors.
App\Entity\ProductStock	No errors.
App\Entity\ProductTag	No errors.
App\Entity\AbstractReview	No errors.
App\Entity\ProductReview	No errors.
App\Entity\ProductBought	No errors.
App\Entity\ProductDailyStat	No errors.
App\Entity\ProductImage	No errors.
App\Entity\ProductPromotion	No errors.
App\Entity\Tax	No errors.
App\Entity\Profile	No errors.
App\Entity\User	No errors.
App\Entity\SupplierReview	No errors.
App\Entity\SupplierNote	No errors.
App\Entity\SupplierBranch	No errors.
App\Entity\SupplierCertificate	No errors.
App\Entity\SupplierStorefrontRequest	No errors.
App\Entity\ProductReviewLike	No errors.
App\Entity\WarehouseBasket	No errors.
App\Entity\ShippingService	No errors.
App\Entity\Shipment	No errors.
App\Entity\MarketingAgentSuggestion	No errors.
App\Entity\TabletRentalAgreement	No errors.
App\Entity\HelpdeskTicket	No errors.
App\Entity\SupplierAdvertisingCampaign	No errors.
App\Entity\AuditEntry	No errors.
App\Entity\OrderTrackingHash	No errors.
App\Entity\UserInviteHash	No errors.
App\Entity\DocumentPackage	No errors.
App\Entity\AbstractMessage	No errors.
App\Entity\CarrierCourierMessage	No errors.
App\Entity\AbstractAccountingNote	No errors.
App\Entity\CarrierAccountingNote	No errors.
App\Entity\WarehouseFridgeSensor	No errors.
App\Entity\WarehouseFridge	No errors.
App\Entity\UserProductAvailabilityAlert	No errors.
App\Entity\ZipCodeSupported	No errors.
App\Entity\SupplierReportItem	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\CarrierTaskWorkerNote	No errors.
App\Entity\DeliverySlot	No errors.
App\Entity\SupplierProductMargin	No errors.
App\Entity\ShipmentPackageUsage	No errors.
App\Entity\CustomerDiscount	No errors.
App\Entity\AbstractHistoryAction	No errors.
App\Entity\SupplierReportHistoryAction	No errors.
App\Entity\AbstractDeviceToken	No errors.
App\Entity\SupplierBranchWorkerDeviceToken	No errors.
App\Entity\CarrierCourierPosition	No errors.
App\Entity\Cart	No errors.
App\Entity\Package	No errors.
App\Entity\ShippingPoi	No errors.
App\Entity\NewsletterDatabase	No errors.
App\Entity\Order	No errors.
App\Entity\HelpdeskFile	No errors.
App\Entity\CommerceRecommendationRule	No errors.
App\Entity\Banner	No errors.
App\Entity\CarrierTask	No errors.
App\Entity\MarginSettlementReport	No errors.
App\Entity\ImportTask	No errors.
App\Entity\Comment	No errors.
App\Entity\BlogPostComment	No errors.
App\Entity\AbstractReportInvoice	No errors.
App\Entity\Carrier	No errors.
App\Entity\ProductPriceHistory	No errors.
App\Entity\ShippingAdapterParameter	No errors.
App\Entity\CartItem	No errors.
App\Entity\SupplierReport	No errors.
App\Entity\UserRecentlyViewedProduct	No errors.
App\Entity\FurgonetkaDispatch	No errors.
App\Entity\DiscountCode	No errors.
App\Entity\SupplierAgreementTemplate	No errors.
App\Entity\SupplierHistoryAction	No errors.
App\Entity\CarrierTaskNote	No errors.
App\Entity\AuditSubject	No errors.
App\Entity\BlogPost	No errors.
App\Entity\OrderReturnRequest	No errors.
App\Entity\SupplierCategoryMargin	No errors.
App\Entity\CartDiscountCode	No errors.
App\Entity\OrderItem	No errors.
App\Entity\BlogTag	No errors.
App\Entity\ProductCustomerStat	No errors.
App\Entity\MobileOperationReceipt	No errors.
App\Entity\OrderPackagePlan	No errors.
App\Entity\CarrierHistoryAction	No errors.
App\Entity\CurrencyExchangeRate	No errors.
App\Entity\WarehouseBasketItem	No errors.
App\Entity\Payment	No errors.
App\Entity\UserDeviceToken	No errors.
App\Entity\OrderSequence	No errors.
App\Entity\HelpdeskTicketMessage	No errors.
App\Entity\ShipmentParcel	No errors.
App\Entity\LegalDocumentVersion	No errors.
App\Entity\SupplierDocument	No errors.
App\Entity\OrderConfirmHash	No errors.
App\Entity\UserHash	No errors.
App\Entity\StockRiskAlertState	No errors.
App\Entity\CarrierReportInvoice	No errors.
App\Entity\LegalDocumentAcceptance	No errors.
App\Entity\BankImportMatchProposal	No errors.
App\Entity\TabletDevice	No errors.
App\Entity\SupplierAgreementDispatch	No errors.
App\Entity\CommerceOrderAttribution	No errors.
App\Entity\Invoice	No errors.
App\Entity\CarrierReport	No errors.
App\Entity\UserSocialAccount	No errors.
App\Entity\UserMarketingReactivation	No errors.
App\Entity\CarrierReportItem	No errors.
App\Entity\DiscountCodeUsage	No errors.
App\Entity\HelpdeskTicketOrder	No errors.
App\Entity\FridgeTemperatureSensor	No errors.
App\Entity\ShippingZone	No errors.
App\Entity\HelpdeskTicketNote	No errors.
App\Entity\OrderEffect	No errors.
App\Entity\MarginSettlementReportItem	No errors.
App\Entity\DeliveryCost	No errors.
App\Entity\UserPasskey	No errors.
App\Entity\BankImportSession	No errors.
App\Entity\FridgeTemperatureSensorLog	No errors.
App\Entity\SupplierReportInvoice	No errors.
App\Entity\TabletRentalInvoice	No errors.
App\Entity\LegalAcceptanceLink	No errors.
App\Entity\DeliverySlotHold	No errors.
App\Entity\CommerceDailyMetric	No errors.
App\Entity\OrderHistory	No errors.
App\Entity\SupplierReportMessage	No errors.
App\Entity\OrderSupplierCode	No errors.
App\Entity\WarehouseWorkerMessage	No errors.
App\Entity\E2eRun	No errors.
App\Entity\OrderReturnRequestItem	No errors.
App\Entity\ShipmentItem	No errors.
App\Entity\ShipmentLabelJob	No errors.
App\Entity\SupplierAccountingNote	No errors.
App\Entity\OrderHistoryAction	No errors.
App\Entity\DeliveryBlackout	No errors.
App\Entity\CarrierCourier	No errors.
App\Entity\InternalWarehouse	No errors.
App\Entity\ProductStockDailySnapshot	No errors.
App\Entity\SupplierLegalDocumentStatus	No errors.
App\Entity\ShipmentDocumentPackage	No errors.
App\Entity\DeliveryWindowTemplate	No errors.
App\Entity\SupplierMessage	No errors.
App\Entity\SupplierBranchWorker	No errors.
App\Entity\LaunchWaitlistSignup	No errors.
App\Entity\ShippingPoiTranslation	No errors.
App\Entity\CarrierCourierDeviceToken	No errors.
App\Entity\OrderReviewToken	No errors.
App\Entity\ShippingPoiLabel	No errors.
App\Entity\SupplierTaxIdentity	No errors.
App\Entity\PaymentMethodConfig	No errors.
App\Entity\UserProductFavorite	No errors.
App\Entity\ShippingTax	No errors.
App\Entity\AdvertisingPlacement	No errors.
App\Entity\CarrierAdditionalRange	No errors.
App\Entity\CommerceExperiment	No errors.
App\Entity\CarrierReportMessage	No errors.
App\Entity\CarrierCourierHash	No errors.
App\Entity\UserMarketingReactivationProduct	No errors.
App\Entity\OrderNote	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Meilisearch\Bundle\Entity\Aggregator	No errors.
Webauthn\PublicKeyCredentialEntity	No errors.
Webauthn\PublicKeyCredentialUserEntity	No errors.
Webauthn\CredentialRecord	No errors.

Symfony Profiler

GET http://rm.local.besmartandpro.ngrok.dev/o_nas.html

Configuration Settings

Theme

Page Width