Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.81 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.81 ms

SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.name AS name_2, s0_.status AS status_3, s0_.plan AS plan_4, s0_.commission_rate AS commission_rate_5, s0_.loyalty_expiration_months AS loyalty_expiration_months_6, s0_.admin_note AS admin_note_7, s0_.stripe_account_id AS stripe_account_id_8, s0_.stripe_customer_id AS stripe_customer_id_9, s0_.stripe_subscription_id AS stripe_subscription_id_10, s0_.primary_color AS primary_color_11, s0_.accent_color AS accent_color_12, s0_.bg_color AS bg_color_13, s0_.fg_color AS fg_color_14, s0_.contact_phone AS contact_phone_15, s0_.contact_email AS contact_email_16, s0_.contact_address AS contact_address_17, s0_.disabled_payment_modes AS disabled_payment_modes_18, s0_.pickup_instructions AS pickup_instructions_19, s0_.is_itinerant AS is_itinerant_20, s0_.legal_representative_phone AS legal_representative_phone_21, s0_.legal_representative_role AS legal_representative_role_22, s0_.siret AS siret_23, s0_.siret_pending AS siret_pending_24, s0_.vat_number AS vat_number_25, s0_.logo_filename AS logo_filename_26, s0_.logo_size AS logo_size_27, s0_.logo_mime_type AS logo_mime_type_28, s0_.cover_filename AS cover_filename_29, s0_.cover_size AS cover_size_30, s0_.cover_mime_type AS cover_mime_type_31, s0_.created_at AS created_at_32, s0_.updated_at AS updated_at_33 FROM shops s0_ INNER JOIN shop_domains s1_ ON (s1_.shop_id = s0_.id) WHERE s1_.hostname = ? AND s1_.verified_at IS NOT NULL

Parameters:

[
  "ftp.pickium.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.slug AS slug_1,
  s0_.name AS name_2,
  s0_.status AS status_3,
  s0_.plan AS plan_4,
  s0_.commission_rate AS commission_rate_5,
  s0_.loyalty_expiration_months AS loyalty_expiration_months_6,
  s0_.admin_note AS admin_note_7,
  s0_.stripe_account_id AS stripe_account_id_8,
  s0_.stripe_customer_id AS stripe_customer_id_9,
  s0_.stripe_subscription_id AS stripe_subscription_id_10,
  s0_.primary_color AS primary_color_11,
  s0_.accent_color AS accent_color_12,
  s0_.bg_color AS bg_color_13,
  s0_.fg_color AS fg_color_14,
  s0_.contact_phone AS contact_phone_15,
  s0_.contact_email AS contact_email_16,
  s0_.contact_address AS contact_address_17,
  s0_.disabled_payment_modes AS disabled_payment_modes_18,
  s0_.pickup_instructions AS pickup_instructions_19,
  s0_.is_itinerant AS is_itinerant_20,
  s0_.legal_representative_phone AS legal_representative_phone_21,
  s0_.legal_representative_role AS legal_representative_role_22,
  s0_.siret AS siret_23,
  s0_.siret_pending AS siret_pending_24,
  s0_.vat_number AS vat_number_25,
  s0_.logo_filename AS logo_filename_26,
  s0_.logo_size AS logo_size_27,
  s0_.logo_mime_type AS logo_mime_type_28,
  s0_.cover_filename AS cover_filename_29,
  s0_.cover_size AS cover_size_30,
  s0_.cover_mime_type AS cover_mime_type_31,
  s0_.created_at AS created_at_32,
  s0_.updated_at AS updated_at_33
FROM
  shops s0_
  INNER JOIN shop_domains s1_ ON (s1_.shop_id = s0_.id)
WHERE
  s1_.hostname = ?
  AND s1_.verified_at IS NOT NULL

SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.name AS name_2, s0_.status AS status_3, s0_.plan AS plan_4, s0_.commission_rate AS commission_rate_5, s0_.loyalty_expiration_months AS loyalty_expiration_months_6, s0_.admin_note AS admin_note_7, s0_.stripe_account_id AS stripe_account_id_8, s0_.stripe_customer_id AS stripe_customer_id_9, s0_.stripe_subscription_id AS stripe_subscription_id_10, s0_.primary_color AS primary_color_11, s0_.accent_color AS accent_color_12, s0_.bg_color AS bg_color_13, s0_.fg_color AS fg_color_14, s0_.contact_phone AS contact_phone_15, s0_.contact_email AS contact_email_16, s0_.contact_address AS contact_address_17, s0_.disabled_payment_modes AS disabled_payment_modes_18, s0_.pickup_instructions AS pickup_instructions_19, s0_.is_itinerant AS is_itinerant_20, s0_.legal_representative_phone AS legal_representative_phone_21, s0_.legal_representative_role AS legal_representative_role_22, s0_.siret AS siret_23, s0_.siret_pending AS siret_pending_24, s0_.vat_number AS vat_number_25, s0_.logo_filename AS logo_filename_26, s0_.logo_size AS logo_size_27, s0_.logo_mime_type AS logo_mime_type_28, s0_.cover_filename AS cover_filename_29, s0_.cover_size AS cover_size_30, s0_.cover_mime_type AS cover_mime_type_31, s0_.created_at AS created_at_32, s0_.updated_at AS updated_at_33 FROM shops s0_ INNER JOIN shop_domains s1_ ON (s1_.shop_id = s0_.id) WHERE s1_.hostname = 'ftp.pickium.fr' AND s1_.verified_at IS NOT NULL;

#	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->getOneOrNullResult (line 737)
6	App\Repository\Tenant\ShopRepository->findOneByCustomHostname (line 51)
7	App\Tenant\TenantResolverListener->__invoke (line 100)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	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

Entities Mapping

Class	Mapping errors
App\Entity\Tenant\Shop	No errors.
App\Entity\Tenant\ShopDomain	No errors.
App\Entity\Audit\AuditLog	No errors.
App\Entity\Catalog\Category	No errors.
App\Entity\Catalog\CategoryTranslation	No errors.
App\Entity\Catalog\Product	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\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\Coupon	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\Ordering\Cart	No errors.
App\Entity\Ordering\CartItem	No errors.
App\Entity\Ordering\Invoice	No errors.
App\Entity\Ordering\Order	No errors.
App\Entity\Ordering\OrderItem	No errors.
App\Entity\Pos\CashRegisterSession	No errors.
App\Entity\Pos\PosPayment	No errors.
App\Entity\Pos\PosSale	No errors.
App\Entity\Pos\PosSaleItem	No errors.
App\Entity\Pos\ZReport	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\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://ftp.pickium.fr/

Configuration Settings

Theme

Page Width