Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

23.34 ms Query time

2 Invalid entities

1405 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.58 ms
(58.15%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.status = ? ORDER BY r0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.address AS address_2,
  r0_.zipcode AS zipcode_3,
  r0_.city AS city_4,
  r0_.phone AS phone_5,
  r0_.email AS email_6,
  r0_.siret AS siret_7,
  r0_.tva_number AS tva_number_8,
  r0_.created_at AS created_at_9,
  r0_.type AS type_10,
  r0_.status AS status_11,
  r0_.commercial_zone AS commercial_zone_12,
  r0_.country AS country_13,
  r0_.verify_by_bd AS verify_by_bd_14,
  r0_.verify_by_na AS verify_by_na_15,
  r0_.verify_by_rl AS verify_by_rl_16,
  r0_.admin_comment AS admin_comment_17,
  r0_.close AS close_18,
  r0_.type_profile AS type_profile_19,
  r0_.reseau AS reseau_20,
  r0_.groupe AS groupe_21,
  r0_.imported AS imported_22,
  r0_.sap_code AS sap_code_23,
  r0_.activity_id AS activity_id_24,
  r0_.rachat_matiere_id AS rachat_matiere_id_25,
  r0_.network_id AS network_id_26,
  r0_.retailer_group_id AS retailer_group_id_27
FROM
  retailer r0_
WHERE
  r0_.status = ?
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.status = 1 ORDER BY r0_.name 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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
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 202)
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	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

7.10 ms
(30.41%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.favorite_apps AS favorite_apps_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.favorite_apps AS favorite_apps_8 FROM user t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
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 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.95 ms
(4.09%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.active AS active_2, m0_.position AS position_3, m0_.is_vrac AS is_vrac_4, m0_.always_bad AS always_bad_5, m0_.created_at AS created_at_6, m0_.parent_id AS parent_id_7 FROM material_type m0_ WHERE m0_.active = ? ORDER BY m0_.parent_id ASC, m0_.position ASC, m0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.active AS active_2,
  m0_.position AS position_3,
  m0_.is_vrac AS is_vrac_4,
  m0_.always_bad AS always_bad_5,
  m0_.created_at AS created_at_6,
  m0_.parent_id AS parent_id_7
FROM
  material_type m0_
WHERE
  m0_.active = ?
ORDER BY
  m0_.parent_id ASC,
  m0_.position ASC,
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.active AS active_2, m0_.position AS position_3, m0_.is_vrac AS is_vrac_4, m0_.always_bad AS always_bad_5, m0_.created_at AS created_at_6, m0_.parent_id AS parent_id_7 FROM material_type m0_ WHERE m0_.active = 1 ORDER BY m0_.parent_id ASC, m0_.position ASC, m0_.name 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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
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\Component\Form\Extension\Core\Type\CollectionType->buildView (line 64)
21	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
22	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
23	Symfony\Component\Form\Form->createView (line 892)
24	Symfony\Component\Form\Form->createView (line 895)
25	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.89 ms
(3.82%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.activity_id = ? ORDER BY r0_.name ASC

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.address AS address_2,
  r0_.zipcode AS zipcode_3,
  r0_.city AS city_4,
  r0_.phone AS phone_5,
  r0_.email AS email_6,
  r0_.siret AS siret_7,
  r0_.tva_number AS tva_number_8,
  r0_.created_at AS created_at_9,
  r0_.type AS type_10,
  r0_.status AS status_11,
  r0_.commercial_zone AS commercial_zone_12,
  r0_.country AS country_13,
  r0_.verify_by_bd AS verify_by_bd_14,
  r0_.verify_by_na AS verify_by_na_15,
  r0_.verify_by_rl AS verify_by_rl_16,
  r0_.admin_comment AS admin_comment_17,
  r0_.close AS close_18,
  r0_.type_profile AS type_profile_19,
  r0_.reseau AS reseau_20,
  r0_.groupe AS groupe_21,
  r0_.imported AS imported_22,
  r0_.sap_code AS sap_code_23,
  r0_.activity_id AS activity_id_24,
  r0_.rachat_matiere_id AS rachat_matiere_id_25,
  r0_.network_id AS network_id_26,
  r0_.retailer_group_id AS retailer_group_id_27
FROM
  retailer r0_
WHERE
  r0_.activity_id = ?
ORDER BY
  r0_.name ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.address AS address_2, r0_.zipcode AS zipcode_3, r0_.city AS city_4, r0_.phone AS phone_5, r0_.email AS email_6, r0_.siret AS siret_7, r0_.tva_number AS tva_number_8, r0_.created_at AS created_at_9, r0_.type AS type_10, r0_.status AS status_11, r0_.commercial_zone AS commercial_zone_12, r0_.country AS country_13, r0_.verify_by_bd AS verify_by_bd_14, r0_.verify_by_na AS verify_by_na_15, r0_.verify_by_rl AS verify_by_rl_16, r0_.admin_comment AS admin_comment_17, r0_.close AS close_18, r0_.type_profile AS type_profile_19, r0_.reseau AS reseau_20, r0_.groupe AS groupe_21, r0_.imported AS imported_22, r0_.sap_code AS sap_code_23, r0_.activity_id AS activity_id_24, r0_.rachat_matiere_id AS rachat_matiere_id_25, r0_.network_id AS network_id_26, r0_.retailer_group_id AS retailer_group_id_27 FROM retailer r0_ WHERE r0_.activity_id = 14 ORDER BY r0_.name 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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
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 202)
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	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.34 ms
(1.44%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.locale AS locale_6, u0_.favorite_apps AS favorite_apps_7 FROM user u0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.firstname AS firstname_4,
  u0_.lastname AS lastname_5,
  u0_.locale AS locale_6,
  u0_.favorite_apps AS favorite_apps_7
FROM
  user u0_

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.firstname AS firstname_4, u0_.lastname AS lastname_5, u0_.locale AS locale_6, u0_.favorite_apps AS favorite_apps_7 FROM user u0_;

#	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 35)
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 202)
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	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.32 ms
(1.38%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.created_at AS created_at_2, b0_.width AS width_3, b0_.height AS height_4, b0_.depth AS depth_5, b0_.weight AS weight_6, b0_.empty_stack_number AS empty_stack_number_7, b0_.tracer_box_no AS tracer_box_no_8, b0_.tracer_activated AS tracer_activated_9, b0_.reference AS reference_10, b0_.box_brand_id AS box_brand_id_11, b0_.box_profiling_id AS box_profiling_id_12, b0_.box_category_id AS box_category_id_13 FROM box b0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.created_at AS created_at_2,
  b0_.width AS width_3,
  b0_.height AS height_4,
  b0_.depth AS depth_5,
  b0_.weight AS weight_6,
  b0_.empty_stack_number AS empty_stack_number_7,
  b0_.tracer_box_no AS tracer_box_no_8,
  b0_.tracer_activated AS tracer_activated_9,
  b0_.reference AS reference_10,
  b0_.box_brand_id AS box_brand_id_11,
  b0_.box_profiling_id AS box_profiling_id_12,
  b0_.box_category_id AS box_category_id_13
FROM
  box b0_

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.created_at AS created_at_2, b0_.width AS width_3, b0_.height AS height_4, b0_.depth AS depth_5, b0_.weight AS weight_6, b0_.empty_stack_number AS empty_stack_number_7, b0_.tracer_box_no AS tracer_box_no_8, b0_.tracer_activated AS tracer_activated_9, b0_.reference AS reference_10, b0_.box_brand_id AS box_brand_id_11, b0_.box_profiling_id AS box_profiling_id_12, b0_.box_category_id AS box_category_id_13 FROM box b0_;

#	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 35)
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\Component\Form\Extension\Core\Type\CollectionType->buildView (line 64)
21	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
22	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
23	Symfony\Component\Form\Form->createView (line 892)
24	Symfony\Component\Form\Form->createView (line 895)
25	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.16 ms
(0.71%)

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM box_category b0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  box_category b0_

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM box_category b0_;

#	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 35)
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\Component\Form\Extension\Core\Type\CollectionType->buildView (line 64)
21	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
22	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
23	Symfony\Component\Form\Form->createView (line 892)
24	Symfony\Component\Form\Form->createView (line 895)
25	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 44)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	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\Retailer	1127
App\Entity\Group	123
App\Entity\Box	71
App\Entity\Activity	27
App\Entity\User	20
App\Entity\BoxCategory	14
App\Entity\MaterialType	12
App\Entity\Profiling	11

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Log	No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry	No errors.
Gedmo\Loggable\Entity\LogEntry	No errors.
App\Entity\MaterialEntry	No errors.
App\Entity\Retailer	No errors.
App\Entity\MaterialEntryWeighing	No errors.
App\Entity\Activity	No errors.
App\Entity\Network	No errors.
App\Entity\Group	No errors.
App\Entity\MaterialType	No errors.
App\Entity\BoxCategory	No errors.
App\Entity\Box	No errors.
App\Entity\BoxQty	No errors.
App\Entity\Contact	The mappings App\Entity\Contact#serviceList and App\Entity\Service#contacts are inconsistent with each other. If association App\Entity\Contact#serviceList is many-to-one, then the inversed side App\Entity\Service#contacts has to be one-to-many.
App\Entity\Delivery	The mappings App\Entity\Delivery#carrier and App\Entity\Retailer#deliveries are inconsistent with each other.
App\Entity\Address	No errors.
App\Entity\RetailerBoxSpec	No errors.
App\Entity\Profiling	No errors.
App\Entity\Iban	No errors.
App\Entity\Preparation	No errors.
App\Entity\SiretResult	No errors.
App\Entity\BoxBrand	No errors.
App\Entity\DeliveryItem	No errors.
App\Entity\TransportationType	No errors.
App\Entity\PreparationItem	No errors.

Symfony Profiler

GET https://dev.veka-ws.ovh/admin?crudAction=new&crudControllerFqcn=App%5CController%5CAdmin%5CMaterialEntryCrudController

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping