Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.81 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.25 ms
(69.24%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_daily AS price_daily_2, p0_.price_monthly AS price_monthly_3, p0_.price_annually AS price_annually_4, p0_.max_products AS max_products_5, p0_.max_active_products AS max_active_products_6, p0_.max_users AS max_users_7, p0_.included_features AS included_features_8, p0_.is_active AS is_active_9, p0_.has_ordenes AS has_ordenes_10, p0_.has_pos AS has_pos_11, p0_.has_kitchen AS has_kitchen_12, p0_.has_sms AS has_sms_13, p0_.payment_gateways AS payment_gateways_14 FROM plan p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price_daily AS price_daily_2,
  p0_.price_monthly AS price_monthly_3,
  p0_.price_annually AS price_annually_4,
  p0_.max_products AS max_products_5,
  p0_.max_active_products AS max_active_products_6,
  p0_.max_users AS max_users_7,
  p0_.included_features AS included_features_8,
  p0_.is_active AS is_active_9,
  p0_.has_ordenes AS has_ordenes_10,
  p0_.has_pos AS has_pos_11,
  p0_.has_kitchen AS has_kitchen_12,
  p0_.has_sms AS has_sms_13,
  p0_.payment_gateways AS payment_gateways_14
FROM
  plan p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_daily AS price_daily_2, p0_.price_monthly AS price_monthly_3, p0_.price_annually AS price_annually_4, p0_.max_products AS max_products_5, p0_.max_active_products AS max_active_products_6, p0_.max_users AS max_users_7, p0_.included_features AS included_features_8, p0_.is_active AS is_active_9, p0_.has_ordenes AS has_ordenes_10, p0_.has_pos AS has_pos_11, p0_.has_kitchen AS has_kitchen_12, p0_.has_sms AS has_sms_13, p0_.payment_gateways AS payment_gateways_14 FROM plan p0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 454)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Controller\Admin\SubscriptionController->new (line 44)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.56 ms
(30.76%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.identifier AS identifier_2, t0_.settings AS settings_3, t0_.subdomain AS subdomain_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.email AS email_7, t0_.status AS status_8, t0_.hero_image_name AS hero_image_name_9, t0_.hero_image_size AS hero_image_size_10, t0_.hero_image_mime_type AS hero_image_mime_type_11, t0_.hero_image_url AS hero_image_url_12, t0_.hero_image_key AS hero_image_key_13, t0_.hero_image_cache_buster AS hero_image_cache_buster_14, t0_.description AS description_15, t0_.address_line1 AS address_line1_16, t0_.address_line2 AS address_line2_17, t0_.pueblo AS pueblo_18, t0_.tel1 AS tel1_19, t0_.tel2 AS tel2_20, t0_.ig_link AS ig_link_21, t0_.fb_link AS fb_link_22, t0_.location AS location_23 FROM tenant t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.identifier AS identifier_2,
  t0_.settings AS settings_3,
  t0_.subdomain AS subdomain_4,
  t0_.created_at AS created_at_5,
  t0_.updated_at AS updated_at_6,
  t0_.email AS email_7,
  t0_.status AS status_8,
  t0_.hero_image_name AS hero_image_name_9,
  t0_.hero_image_size AS hero_image_size_10,
  t0_.hero_image_mime_type AS hero_image_mime_type_11,
  t0_.hero_image_url AS hero_image_url_12,
  t0_.hero_image_key AS hero_image_key_13,
  t0_.hero_image_cache_buster AS hero_image_cache_buster_14,
  t0_.description AS description_15,
  t0_.address_line1 AS address_line1_16,
  t0_.address_line2 AS address_line2_17,
  t0_.pueblo AS pueblo_18,
  t0_.tel1 AS tel1_19,
  t0_.tel2 AS tel2_20,
  t0_.ig_link AS ig_link_21,
  t0_.fb_link AS fb_link_22,
  t0_.location AS location_23
FROM
  tenant t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.identifier AS identifier_2, t0_.settings AS settings_3, t0_.subdomain AS subdomain_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.email AS email_7, t0_.status AS status_8, t0_.hero_image_name AS hero_image_name_9, t0_.hero_image_size AS hero_image_size_10, t0_.hero_image_mime_type AS hero_image_mime_type_11, t0_.hero_image_url AS hero_image_url_12, t0_.hero_image_key AS hero_image_key_13, t0_.hero_image_cache_buster AS hero_image_cache_buster_14, t0_.description AS description_15, t0_.address_line1 AS address_line1_16, t0_.address_line2 AS address_line2_17, t0_.pueblo AS pueblo_18, t0_.tel1 AS tel1_19, t0_.tel2 AS tel2_20, t0_.ig_link AS ig_link_21, t0_.fb_link AS fb_link_22, t0_.location AS location_23 FROM tenant t0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 454)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Controller\Admin\SubscriptionController->new (line 44)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	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	3
App\Entity\Core\Plan	2

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/new

Configuration Settings

Theme

Page Width