Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.92 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.46 ms

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

Parameters:

[]

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

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Admin\SubscriptionController->index (line 24)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.45 ms

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.id = ?

Parameters:

[
  2
]

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.id = ?

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.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1795)
5	__TwigTemplate_20577ce7ac4fd141c2ebfc9e10e36b96::block_tbody (line 198)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_82b30245fa005914cd761b174796aa55->block_body (line 146)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_f142786ea8c46bc6ffe690b572a469e7->doDisplay (line 128)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_82b30245fa005914cd761b174796aa55->doDisplay (line 59)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_20577ce7ac4fd141c2ebfc9e10e36b96->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\Admin\SubscriptionController->index (line 23)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Subscription	1
App\Entity\Core\Tenant	1
App\Entity\Core\Plan	1

Entities Mapping

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

Symfony Profiler

GET https://admin.appsconflow.com/admin/subscription

Configuration Settings

Theme

Page Width