Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.20 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.68 ms
(56.74%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expires_at AS expires_at_4, t0.starts_at AS starts_at_5, t0.cancelled_at AS cancelled_at_6, t0.status AS status_7, t0.payment_gateways AS payment_gateways_8, t0.billing_cycle AS billing_cycle_9, t0.billing_period AS billing_period_10, t0.price_snapshot AS price_snapshot_11, t0.max_products AS max_products_12, t0.max_active_products AS max_active_products_13, t0.used_products AS used_products_14, t0.max_users AS max_users_15, t0.used_users AS used_users_16, t0.has_ordenes AS has_ordenes_17, t0.has_pos AS has_pos_18, t0.has_kitchen AS has_kitchen_19, t0.has_sms AS has_sms_20, t0.tenant_id AS tenant_id_21, t0.plan_id AS plan_id_22 FROM subscription t0 WHERE t0.tenant_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.expires_at AS expires_at_4,
  t0.starts_at AS starts_at_5,
  t0.cancelled_at AS cancelled_at_6,
  t0.status AS status_7,
  t0.payment_gateways AS payment_gateways_8,
  t0.billing_cycle AS billing_cycle_9,
  t0.billing_period AS billing_period_10,
  t0.price_snapshot AS price_snapshot_11,
  t0.max_products AS max_products_12,
  t0.max_active_products AS max_active_products_13,
  t0.used_products AS used_products_14,
  t0.max_users AS max_users_15,
  t0.used_users AS used_users_16,
  t0.has_ordenes AS has_ordenes_17,
  t0.has_pos AS has_pos_18,
  t0.has_kitchen AS has_kitchen_19,
  t0.has_sms AS has_sms_20,
  t0.tenant_id AS tenant_id_21,
  t0.plan_id AS plan_id_22
FROM
  subscription t0
WHERE
  t0.tenant_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expires_at AS expires_at_4, t0.starts_at AS starts_at_5, t0.cancelled_at AS cancelled_at_6, t0.status AS status_7, t0.payment_gateways AS payment_gateways_8, t0.billing_cycle AS billing_cycle_9, t0.billing_period AS billing_period_10, t0.price_snapshot AS price_snapshot_11, t0.max_products AS max_products_12, t0.max_active_products AS max_active_products_13, t0.used_products AS used_products_14, t0.max_users AS max_users_15, t0.used_users AS used_users_16, t0.has_ordenes AS has_ordenes_17, t0.has_pos AS has_pos_18, t0.has_kitchen AS has_kitchen_19, t0.has_sms AS has_sms_20, t0.tenant_id AS tenant_id_21, t0.plan_id AS plan_id_22 FROM subscription t0 WHERE t0.tenant_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\Tenant\MenuController->index (line 34)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.52 ms
(43.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.settings AS settings_4, t0.subdomain AS subdomain_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email AS email_8, t0.status AS status_9, t0.hero_image_name AS hero_image_name_10, t0.hero_image_size AS hero_image_size_11, t0.hero_image_mime_type AS hero_image_mime_type_12, t0.hero_image_url AS hero_image_url_13, t0.hero_image_key AS hero_image_key_14, t0.hero_image_cache_buster AS hero_image_cache_buster_15, t0.description AS description_16, t0.address_line1 AS address_line1_17, t0.address_line2 AS address_line2_18, t0.pueblo AS pueblo_19, t0.tel1 AS tel1_20, t0.tel2 AS tel2_21, t0.ig_link AS ig_link_22, t0.fb_link AS fb_link_23, t0.location AS location_24 FROM tenant t0 WHERE t0.subdomain = ? LIMIT 1

Parameters:

[
  "la-braza"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.identifier AS identifier_3,
  t0.settings AS settings_4,
  t0.subdomain AS subdomain_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.email AS email_8,
  t0.status AS status_9,
  t0.hero_image_name AS hero_image_name_10,
  t0.hero_image_size AS hero_image_size_11,
  t0.hero_image_mime_type AS hero_image_mime_type_12,
  t0.hero_image_url AS hero_image_url_13,
  t0.hero_image_key AS hero_image_key_14,
  t0.hero_image_cache_buster AS hero_image_cache_buster_15,
  t0.description AS description_16,
  t0.address_line1 AS address_line1_17,
  t0.address_line2 AS address_line2_18,
  t0.pueblo AS pueblo_19,
  t0.tel1 AS tel1_20,
  t0.tel2 AS tel2_21,
  t0.ig_link AS ig_link_22,
  t0.fb_link AS fb_link_23,
  t0.location AS location_24
FROM
  tenant t0
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.settings AS settings_4, t0.subdomain AS subdomain_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email AS email_8, t0.status AS status_9, t0.hero_image_name AS hero_image_name_10, t0.hero_image_size AS hero_image_size_11, t0.hero_image_mime_type AS hero_image_mime_type_12, t0.hero_image_url AS hero_image_url_13, t0.hero_image_key AS hero_image_key_14, t0.hero_image_cache_buster AS hero_image_cache_buster_15, t0.description AS description_16, t0.address_line1 AS address_line1_17, t0.address_line2 AS address_line2_18, t0.pueblo AS pueblo_19, t0.tel1 AS tel1_20, t0.tel2 AS tel2_21, t0.ig_link AS ig_link_22, t0.fb_link AS fb_link_23, t0.location AS location_24 FROM tenant t0 WHERE t0.subdomain = 'la-braza' 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\EventListener\Core\TenantListener->onKernelRequest (line 41)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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\Core\Tenant	1

Entities Mapping

Class	Mapping errors
App\Entity\Core\Tenant	No errors.
App\Entity\Core\Subscription	No errors.
App\Entity\Core\SubscriptionHistory	No errors.
App\Entity\Tenant\TenantProduct	No errors.
App\Entity\Tenant\TenantProductCategory	No errors.
App\Entity\Core\Plan	No errors.

Symfony Profiler

GET https://la-braza.appsconflow.com/menu/

Configuration Settings

Theme

Page Width