Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.10 ms Query time

0 Invalid entities

68 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.69 ms
(54.55%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.base_price AS base_price_4, t0_.compare_price AS compare_price_5, t0_.cost_price AS cost_price_6, t0_.is_available AS is_available_7, t0_.display_order AS display_order_8, t0_.preparation_time_minutes AS preparation_time_minutes_9, t0_.min_qty_per_order AS min_qty_per_order_10, t0_.max_qty_per_order AS max_qty_per_order_11, t0_.is_active AS is_active_12, t0_.product_image_name AS product_image_name_13, t0_.product_image_size AS product_image_size_14, t0_.product_image_mime_type AS product_image_mime_type_15, t0_.updated_at AS updated_at_16, t0_.imported_image_link AS imported_image_link_17, t0_.image_url800 AS image_url800_18, t0_.image_key AS image_key_19, t0_.image_cache_buster AS image_cache_buster_20, t1_.id AS id_21, t1_.code AS code_22, t1_.name AS name_23, t1_.display_name AS display_name_24, t1_.color AS color_25, t1_.icon AS icon_26, t1_.is_active AS is_active_27, t1_.display_order AS display_order_28, t2_.id AS id_29, t2_.code AS code_30, t2_.name AS name_31, t2_.description AS description_32, t2_.display_order AS display_order_33, t2_.is_active AS is_active_34, t2_.filter_operation AS filter_operation_35, t2_.icon AS icon_36, t2_.color AS color_37, t3_.id AS id_38, t3_.name AS name_39, t3_.display_order AS display_order_40, t0_.tenant_id AS tenant_id_41, t0_.tenant_product_category_id AS tenant_product_category_id_42, t1_.category_id AS category_id_43, t3_.master_category_id AS master_category_id_44, t3_.tenant_id AS tenant_id_45 FROM tenant_product t0_ LEFT JOIN tenant_product_tag t4_ ON t0_.id = t4_.tenant_product_id LEFT JOIN tag t1_ ON t1_.id = t4_.tag_id LEFT JOIN tag_category t2_ ON t1_.category_id = t2_.id LEFT JOIN tenant_product_category t3_ ON t0_.tenant_product_category_id = t3_.id WHERE t0_.tenant_id = ? AND t0_.is_active = 1 AND t0_.is_available = 1 ORDER BY t3_.display_order ASC, t0_.display_order ASC, t2_.display_order ASC, t1_.display_order ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.slug AS slug_3,
  t0_.base_price AS base_price_4,
  t0_.compare_price AS compare_price_5,
  t0_.cost_price AS cost_price_6,
  t0_.is_available AS is_available_7,
  t0_.display_order AS display_order_8,
  t0_.preparation_time_minutes AS preparation_time_minutes_9,
  t0_.min_qty_per_order AS min_qty_per_order_10,
  t0_.max_qty_per_order AS max_qty_per_order_11,
  t0_.is_active AS is_active_12,
  t0_.product_image_name AS product_image_name_13,
  t0_.product_image_size AS product_image_size_14,
  t0_.product_image_mime_type AS product_image_mime_type_15,
  t0_.updated_at AS updated_at_16,
  t0_.imported_image_link AS imported_image_link_17,
  t0_.image_url800 AS image_url800_18,
  t0_.image_key AS image_key_19,
  t0_.image_cache_buster AS image_cache_buster_20,
  t1_.id AS id_21,
  t1_.code AS code_22,
  t1_.name AS name_23,
  t1_.display_name AS display_name_24,
  t1_.color AS color_25,
  t1_.icon AS icon_26,
  t1_.is_active AS is_active_27,
  t1_.display_order AS display_order_28,
  t2_.id AS id_29,
  t2_.code AS code_30,
  t2_.name AS name_31,
  t2_.description AS description_32,
  t2_.display_order AS display_order_33,
  t2_.is_active AS is_active_34,
  t2_.filter_operation AS filter_operation_35,
  t2_.icon AS icon_36,
  t2_.color AS color_37,
  t3_.id AS id_38,
  t3_.name AS name_39,
  t3_.display_order AS display_order_40,
  t0_.tenant_id AS tenant_id_41,
  t0_.tenant_product_category_id AS tenant_product_category_id_42,
  t1_.category_id AS category_id_43,
  t3_.master_category_id AS master_category_id_44,
  t3_.tenant_id AS tenant_id_45
FROM
  tenant_product t0_
  LEFT JOIN tenant_product_tag t4_ ON t0_.id = t4_.tenant_product_id
  LEFT JOIN tag t1_ ON t1_.id = t4_.tag_id
  LEFT JOIN tag_category t2_ ON t1_.category_id = t2_.id
  LEFT JOIN tenant_product_category t3_ ON t0_.tenant_product_category_id = t3_.id
WHERE
  t0_.tenant_id = ?
  AND t0_.is_active = 1
  AND t0_.is_available = 1
ORDER BY
  t3_.display_order ASC,
  t0_.display_order ASC,
  t2_.display_order ASC,
  t1_.display_order ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.base_price AS base_price_4, t0_.compare_price AS compare_price_5, t0_.cost_price AS cost_price_6, t0_.is_available AS is_available_7, t0_.display_order AS display_order_8, t0_.preparation_time_minutes AS preparation_time_minutes_9, t0_.min_qty_per_order AS min_qty_per_order_10, t0_.max_qty_per_order AS max_qty_per_order_11, t0_.is_active AS is_active_12, t0_.product_image_name AS product_image_name_13, t0_.product_image_size AS product_image_size_14, t0_.product_image_mime_type AS product_image_mime_type_15, t0_.updated_at AS updated_at_16, t0_.imported_image_link AS imported_image_link_17, t0_.image_url800 AS image_url800_18, t0_.image_key AS image_key_19, t0_.image_cache_buster AS image_cache_buster_20, t1_.id AS id_21, t1_.code AS code_22, t1_.name AS name_23, t1_.display_name AS display_name_24, t1_.color AS color_25, t1_.icon AS icon_26, t1_.is_active AS is_active_27, t1_.display_order AS display_order_28, t2_.id AS id_29, t2_.code AS code_30, t2_.name AS name_31, t2_.description AS description_32, t2_.display_order AS display_order_33, t2_.is_active AS is_active_34, t2_.filter_operation AS filter_operation_35, t2_.icon AS icon_36, t2_.color AS color_37, t3_.id AS id_38, t3_.name AS name_39, t3_.display_order AS display_order_40, t0_.tenant_id AS tenant_id_41, t0_.tenant_product_category_id AS tenant_product_category_id_42, t1_.category_id AS category_id_43, t3_.master_category_id AS master_category_id_44, t3_.tenant_id AS tenant_id_45 FROM tenant_product t0_ LEFT JOIN tenant_product_tag t4_ ON t0_.id = t4_.tenant_product_id LEFT JOIN tag t1_ ON t1_.id = t4_.tag_id LEFT JOIN tag_category t2_ ON t1_.category_id = t2_.id LEFT JOIN tenant_product_category t3_ ON t0_.tenant_product_category_id = t3_.id WHERE t0_.tenant_id = 2 AND t0_.is_active = 1 AND t0_.is_available = 1 ORDER BY t3_.display_order ASC, t0_.display_order ASC, t2_.display_order ASC, t1_.display_order ASC;

#	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->getResult (line 688)
6	App\Repository\Tenant\TenantProductRepository->findActiveForTenantWithTags (line 40)
7	App\Controller\Tenant\MenuController->index (line 58)
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.75 ms
(24.27%)

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:

[
  2
]

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

#	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.66 ms
(21.18%)

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:

[
  "beach-burger"
]

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 = 'beach-burger' 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\Tenant\TenantProduct	37
App\Entity\Core\Tag	15
App\Entity\Tenant\TenantProductCategory	5
App\Entity\Core\TagCategory	4
App\Entity\Core\MasterProductCategory	4
App\Entity\Core\Tenant	1
App\Entity\Core\Subscription	1
App\Entity\Core\Plan	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.
App\Entity\Core\Tag	No errors.
App\Entity\Core\TagCategory	No errors.
App\Entity\Core\MasterProductCategory	No errors.

Symfony Profiler

GET https://beach-burger.appsconflow.com/menu/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping