Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.23 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.23 ms
(100.00%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.status AS status_4, t0.plan AS plan_5, t0.commission_rate AS commission_rate_6, t0.loyalty_expiration_months AS loyalty_expiration_months_7, t0.admin_note AS admin_note_8, t0.stripe_account_id AS stripe_account_id_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.primary_color AS primary_color_12, t0.accent_color AS accent_color_13, t0.bg_color AS bg_color_14, t0.fg_color AS fg_color_15, t0.contact_phone AS contact_phone_16, t0.contact_email AS contact_email_17, t0.contact_address AS contact_address_18, t0.disabled_payment_modes AS disabled_payment_modes_19, t0.pickup_instructions AS pickup_instructions_20, t0.is_itinerant AS is_itinerant_21, t0.pay_at_pickup_enabled AS pay_at_pickup_enabled_22, t0.legal_representative_phone AS legal_representative_phone_23, t0.legal_representative_role AS legal_representative_role_24, t0.siret AS siret_25, t0.siret_pending AS siret_pending_26, t0.vat_number AS vat_number_27, t0.logo_filename AS logo_filename_28, t0.logo_size AS logo_size_29, t0.logo_mime_type AS logo_mime_type_30, t0.cover_filename AS cover_filename_31, t0.cover_size AS cover_size_32, t0.cover_mime_type AS cover_mime_type_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35 FROM shops t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "popote"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.status AS status_4,
  t0.plan AS plan_5,
  t0.commission_rate AS commission_rate_6,
  t0.loyalty_expiration_months AS loyalty_expiration_months_7,
  t0.admin_note AS admin_note_8,
  t0.stripe_account_id AS stripe_account_id_9,
  t0.stripe_customer_id AS stripe_customer_id_10,
  t0.stripe_subscription_id AS stripe_subscription_id_11,
  t0.primary_color AS primary_color_12,
  t0.accent_color AS accent_color_13,
  t0.bg_color AS bg_color_14,
  t0.fg_color AS fg_color_15,
  t0.contact_phone AS contact_phone_16,
  t0.contact_email AS contact_email_17,
  t0.contact_address AS contact_address_18,
  t0.disabled_payment_modes AS disabled_payment_modes_19,
  t0.pickup_instructions AS pickup_instructions_20,
  t0.is_itinerant AS is_itinerant_21,
  t0.pay_at_pickup_enabled AS pay_at_pickup_enabled_22,
  t0.legal_representative_phone AS legal_representative_phone_23,
  t0.legal_representative_role AS legal_representative_role_24,
  t0.siret AS siret_25,
  t0.siret_pending AS siret_pending_26,
  t0.vat_number AS vat_number_27,
  t0.logo_filename AS logo_filename_28,
  t0.logo_size AS logo_size_29,
  t0.logo_mime_type AS logo_mime_type_30,
  t0.cover_filename AS cover_filename_31,
  t0.cover_size AS cover_size_32,
  t0.cover_mime_type AS cover_mime_type_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35
FROM
  shops t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.status AS status_4, t0.plan AS plan_5, t0.commission_rate AS commission_rate_6, t0.loyalty_expiration_months AS loyalty_expiration_months_7, t0.admin_note AS admin_note_8, t0.stripe_account_id AS stripe_account_id_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.primary_color AS primary_color_12, t0.accent_color AS accent_color_13, t0.bg_color AS bg_color_14, t0.fg_color AS fg_color_15, t0.contact_phone AS contact_phone_16, t0.contact_email AS contact_email_17, t0.contact_address AS contact_address_18, t0.disabled_payment_modes AS disabled_payment_modes_19, t0.pickup_instructions AS pickup_instructions_20, t0.is_itinerant AS is_itinerant_21, t0.pay_at_pickup_enabled AS pay_at_pickup_enabled_22, t0.legal_representative_phone AS legal_representative_phone_23, t0.legal_representative_role AS legal_representative_role_24, t0.siret AS siret_25, t0.siret_pending AS siret_pending_26, t0.vat_number AS vat_number_27, t0.logo_filename AS logo_filename_28, t0.logo_size AS logo_size_29, t0.logo_mime_type AS logo_mime_type_30, t0.cover_filename AS cover_filename_31, t0.cover_size AS cover_size_32, t0.cover_mime_type AS cover_mime_type_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35 FROM shops t0 WHERE t0.slug = 'popote' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\Tenant\ShopRepository->findOneBySlug (line 34)
5	App\Tenant\TenantResolverListener->__invoke (line 107)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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
App\Entity\Tenant\Shop	1

Entities Mapping

Class	Mapping errors
App\Entity\Tenant\Shop	No errors.
App\Entity\Audit\AuditLog	No errors.
App\Entity\Catalog\Category	No errors.
App\Entity\Catalog\CategoryTranslation	No errors.
App\Entity\Catalog\ProductPhoto	No errors.
App\Entity\Catalog\ProductTranslation	No errors.
App\Entity\Catalog\ProductionBatch	No errors.
App\Entity\Catalog\StockItem	No errors.
App\Entity\Catalog\Variant	No errors.
App\Entity\Catalog\Product	No errors.
App\Entity\Catalog\VatRate	No errors.
App\Entity\Cms\Page	No errors.
App\Entity\Identity\ResetPasswordRequest	No errors.
App\Entity\Identity\User	No errors.
App\Entity\Identity\AuthEvent	No errors.
App\Entity\Loyalty\Customer	No errors.
App\Entity\Loyalty\LoyaltyBalance	No errors.
App\Entity\Loyalty\LoyaltyProgram	No errors.
App\Entity\Loyalty\LoyaltyTransaction	No errors.
App\Entity\Marketing\CouponUsage	No errors.
App\Entity\Marketing\BroadcastMessage	No errors.
App\Entity\Marketing\ContactBlocklistEntry	No errors.
App\Entity\Marketing\ContactMessage	No errors.
App\Entity\Marketing\ContactMessageReply	No errors.
App\Entity\Marketing\ReservedSlug	No errors.
App\Entity\Marketing\UploadModeration	No errors.
App\Entity\Marketing\Coupon	No errors.
App\Entity\Ordering\Cart	No errors.
App\Entity\Ordering\CartItem	No errors.
App\Entity\Ordering\Invoice	No errors.
App\Entity\Ordering\OrderItem	No errors.
App\Entity\Ordering\Order	No errors.
App\Entity\Pos\CashRegisterSession	No errors.
App\Entity\Pos\PosPayment	No errors.
App\Entity\Pos\PosSaleItem	No errors.
App\Entity\Pos\ZReport	No errors.
App\Entity\Pos\PosSale	No errors.
App\Entity\Services\ClosureException	No errors.
App\Entity\Services\ServiceInstance	No errors.
App\Entity\Services\ServicePlan	No errors.
App\Entity\Services\Slot	No errors.
App\Entity\Support\SupportTicketMessage	No errors.
App\Entity\Support\SupportTemplate	No errors.
App\Entity\Support\SupportTicket	No errors.
App\Entity\Tenant\Place	No errors.
App\Entity\Tenant\ShopDomain	No errors.
App\Entity\Ops\AdminActionLog	No errors.
App\Entity\Ops\CronExecution	No errors.
App\Entity\Ops\WebhookDelivery	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://popote.pickium.fr/static/style/sys_files/index.js

Configuration Settings

Theme

Page Width