Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.73 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.01 ms
(58.39%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = ?

Parameters:

[
  "e1d213a7-a827-410f-8a36-623e68f7991b"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.name AS name_4,
  t0.surname AS surname_5,
  t0.roles AS roles_6,
  t0.mobile_phone AS mobile_phone_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.zip_code AS zip_code_10,
  t0.state AS state_11,
  t0.country AS country_12,
  t0.price_modifier AS price_modifier_13,
  t0.password AS password_14,
  t0.reset_password_token AS reset_password_token_15,
  t0.locale AS locale_16,
  t0.double_factor_method AS double_factor_method_17,
  t0.auth_code AS auth_code_18,
  t0.google_authenticator_secret AS google_authenticator_secret_19,
  t0.disabled_at AS disabled_at_20,
  t0.last_login_at AS last_login_at_21,
  t0.last_login_ip AS last_login_ip_22,
  t0.previous_login_at AS previous_login_at_23,
  t0.previous_login_ip AS previous_login_ip_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = 'e1d213a7-a827-410f-8a36-623e68f7991b';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 211)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 161)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

0.72 ms
(41.61%)

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price_including_vat AS price_including_vat_5, t0.featured AS featured_6, t0.price AS price_7, t0.currency AS currency_8, t0.vat_rate AS vat_rate_9, t0.enabled AS enabled_10, t0.stock AS stock_11, t0.image_path AS image_path_12, t0.show_title AS show_title_13, t0.show_content AS show_content_14, t0.imported AS imported_15, t0.imported_code AS imported_code_16, t0.is_set AS is_set_17, t0.obsolete AS obsolete_18, t0.visibility_role AS visibility_role_19, t0.metadata AS metadata_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.plan_path AS plan_path_25, t23.exploded_path AS exploded_path_26, t23.assembly_path AS assembly_path_27, t23.extra_info AS extra_info_28, t23.created_at AS created_at_29, t23.updated_at AS updated_at_30, t23.product_id AS product_id_31 FROM products t0 LEFT JOIN set_details t23 ON t23.product_id = t0.id WHERE t0.id = ?

Parameters:

[
  "cf2e73e1-7927-5e95-a16b-831a03e29090"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.price_including_vat AS price_including_vat_5,
  t0.featured AS featured_6,
  t0.price AS price_7,
  t0.currency AS currency_8,
  t0.vat_rate AS vat_rate_9,
  t0.enabled AS enabled_10,
  t0.stock AS stock_11,
  t0.image_path AS image_path_12,
  t0.show_title AS show_title_13,
  t0.show_content AS show_content_14,
  t0.imported AS imported_15,
  t0.imported_code AS imported_code_16,
  t0.is_set AS is_set_17,
  t0.obsolete AS obsolete_18,
  t0.visibility_role AS visibility_role_19,
  t0.metadata AS metadata_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t23.id AS id_24,
  t23.plan_path AS plan_path_25,
  t23.exploded_path AS exploded_path_26,
  t23.assembly_path AS assembly_path_27,
  t23.extra_info AS extra_info_28,
  t23.created_at AS created_at_29,
  t23.updated_at AS updated_at_30,
  t23.product_id AS product_id_31
FROM
  products t0
  LEFT JOIN set_details t23 ON t23.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price_including_vat AS price_including_vat_5, t0.featured AS featured_6, t0.price AS price_7, t0.currency AS currency_8, t0.vat_rate AS vat_rate_9, t0.enabled AS enabled_10, t0.stock AS stock_11, t0.image_path AS image_path_12, t0.show_title AS show_title_13, t0.show_content AS show_content_14, t0.imported AS imported_15, t0.imported_code AS imported_code_16, t0.is_set AS is_set_17, t0.obsolete AS obsolete_18, t0.visibility_role AS visibility_role_19, t0.metadata AS metadata_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.plan_path AS plan_path_25, t23.exploded_path AS exploded_path_26, t23.assembly_path AS assembly_path_27, t23.extra_info AS extra_info_28, t23.created_at AS created_at_29, t23.updated_at AS updated_at_30, t23.product_id AS product_id_31 FROM products t0 LEFT JOIN set_details t23 ON t23.product_id = t0.id WHERE t0.id = 'cf2e73e1-7927-5e95-a16b-831a03e29090';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 177)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
legacy	doctrine.dbal.legacy_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\User	2
App\Entity\Product	1
App\Entity\SetDetail	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\SetDetail	No errors.
App\Entity\ProductRelation	No errors.
App\Entity\ProductImage	No errors.
App\Entity\Category	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\ProductLibrary	No errors.
App\Entity\SetDetailBalloon	No errors.
App\Entity\SetDetailLine	No errors.
App\Entity\SetDetailImage	No errors.
App\Entity\Machine	No errors.