Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.20 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.20 ms

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.label AS label_2, s0_.item_type AS item_type_3, s0_.url AS url_4, s0_.icon AS icon_5, s0_.sort_order AS sort_order_6, s0_.is_active AS is_active_7, s0_.requires_published_entity AS requires_published_entity_8, s1_.id AS id_9, s1_.code AS code_10, s1_.label AS label_11, s1_.description AS description_12, s1_.icon AS icon_13, s1_.sort_order AS sort_order_14, s1_.is_system AS is_system_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.code AS code_18, s2_.table_name AS table_name_19, s2_.label AS label_20, s2_.label_plural AS label_plural_21, s2_.description AS description_22, s2_.soft_delete AS soft_delete_23, s2_.audited AS audited_24, s2_.company_scoped AS company_scoped_25, s2_.site_scoped AS site_scoped_26, s2_.api_enabled AS api_enabled_27, s2_.ui_enabled AS ui_enabled_28, s2_.is_active AS is_active_29, s2_.status AS status_30, s2_.published_version AS published_version_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s3_.id AS id_34, s3_.code AS code_35, s3_.label AS label_36, s3_.item_type AS item_type_37, s3_.url AS url_38, s3_.icon AS icon_39, s3_.sort_order AS sort_order_40, s3_.is_active AS is_active_41, s3_.requires_published_entity AS requires_published_entity_42, s0_.module_id AS module_id_43, s0_.parent_id AS parent_id_44, s0_.entity_id AS entity_id_45, s2_.module_id AS module_id_46, s3_.module_id AS module_id_47, s3_.parent_id AS parent_id_48, s3_.entity_id AS entity_id_49 FROM studio_menu_item s0_ LEFT JOIN studio_module s1_ ON s0_.module_id = s1_.id LEFT JOIN studio_entity s2_ ON s0_.entity_id = s2_.id LEFT JOIN studio_menu_item s3_ ON s0_.parent_id = s3_.id ORDER BY s0_.sort_order ASC, s0_.label ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.label AS label_2,
  s0_.item_type AS item_type_3,
  s0_.url AS url_4,
  s0_.icon AS icon_5,
  s0_.sort_order AS sort_order_6,
  s0_.is_active AS is_active_7,
  s0_.requires_published_entity AS requires_published_entity_8,
  s1_.id AS id_9,
  s1_.code AS code_10,
  s1_.label AS label_11,
  s1_.description AS description_12,
  s1_.icon AS icon_13,
  s1_.sort_order AS sort_order_14,
  s1_.is_system AS is_system_15,
  s1_.is_active AS is_active_16,
  s2_.id AS id_17,
  s2_.code AS code_18,
  s2_.table_name AS table_name_19,
  s2_.label AS label_20,
  s2_.label_plural AS label_plural_21,
  s2_.description AS description_22,
  s2_.soft_delete AS soft_delete_23,
  s2_.audited AS audited_24,
  s2_.company_scoped AS company_scoped_25,
  s2_.site_scoped AS site_scoped_26,
  s2_.api_enabled AS api_enabled_27,
  s2_.ui_enabled AS ui_enabled_28,
  s2_.is_active AS is_active_29,
  s2_.status AS status_30,
  s2_.published_version AS published_version_31,
  s2_.created_at AS created_at_32,
  s2_.updated_at AS updated_at_33,
  s3_.id AS id_34,
  s3_.code AS code_35,
  s3_.label AS label_36,
  s3_.item_type AS item_type_37,
  s3_.url AS url_38,
  s3_.icon AS icon_39,
  s3_.sort_order AS sort_order_40,
  s3_.is_active AS is_active_41,
  s3_.requires_published_entity AS requires_published_entity_42,
  s0_.module_id AS module_id_43,
  s0_.parent_id AS parent_id_44,
  s0_.entity_id AS entity_id_45,
  s2_.module_id AS module_id_46,
  s3_.module_id AS module_id_47,
  s3_.parent_id AS parent_id_48,
  s3_.entity_id AS entity_id_49
FROM
  studio_menu_item s0_
  LEFT JOIN studio_module s1_ ON s0_.module_id = s1_.id
  LEFT JOIN studio_entity s2_ ON s0_.entity_id = s2_.id
  LEFT JOIN studio_menu_item s3_ ON s0_.parent_id = s3_.id
ORDER BY
  s0_.sort_order ASC,
  s0_.label ASC

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.label AS label_2, s0_.item_type AS item_type_3, s0_.url AS url_4, s0_.icon AS icon_5, s0_.sort_order AS sort_order_6, s0_.is_active AS is_active_7, s0_.requires_published_entity AS requires_published_entity_8, s1_.id AS id_9, s1_.code AS code_10, s1_.label AS label_11, s1_.description AS description_12, s1_.icon AS icon_13, s1_.sort_order AS sort_order_14, s1_.is_system AS is_system_15, s1_.is_active AS is_active_16, s2_.id AS id_17, s2_.code AS code_18, s2_.table_name AS table_name_19, s2_.label AS label_20, s2_.label_plural AS label_plural_21, s2_.description AS description_22, s2_.soft_delete AS soft_delete_23, s2_.audited AS audited_24, s2_.company_scoped AS company_scoped_25, s2_.site_scoped AS site_scoped_26, s2_.api_enabled AS api_enabled_27, s2_.ui_enabled AS ui_enabled_28, s2_.is_active AS is_active_29, s2_.status AS status_30, s2_.published_version AS published_version_31, s2_.created_at AS created_at_32, s2_.updated_at AS updated_at_33, s3_.id AS id_34, s3_.code AS code_35, s3_.label AS label_36, s3_.item_type AS item_type_37, s3_.url AS url_38, s3_.icon AS icon_39, s3_.sort_order AS sort_order_40, s3_.is_active AS is_active_41, s3_.requires_published_entity AS requires_published_entity_42, s0_.module_id AS module_id_43, s0_.parent_id AS parent_id_44, s0_.entity_id AS entity_id_45, s2_.module_id AS module_id_46, s3_.module_id AS module_id_47, s3_.parent_id AS parent_id_48, s3_.entity_id AS entity_id_49 FROM studio_menu_item s0_ LEFT JOIN studio_module s1_ ON s0_.module_id = s1_.id LEFT JOIN studio_entity s2_ ON s0_.entity_id = s2_.id LEFT JOIN studio_menu_item s3_ ON s0_.parent_id = s3_.id ORDER BY s0_.sort_order ASC, s0_.label 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\Studio\StudioMenuItemRepository->findAllOrdered (line 29)
7	App\Repository\Studio\StudioMenuItemRepository->findVisibleForErp (line 40)
8	App\Twig\ErpExtension->getGlobals (line 34)
9	Twig\ExtensionSet->getGlobals (line 362)
10	Twig\Environment->getGlobals (line 922)
11	Twig\Template->yield (line 456)
12	Twig\Template->display (line 416)
13	Twig\Template->render (line 431)
14	Twig\TemplateWrapper->render (line 53)
15	Twig\Environment->render (line 343)
16	Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener->injectToolbar (line 163)
17	Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener->onKernelResponse (line 151)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 228)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 279)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 92)
25	Symfony\Component\HttpKernel\Kernel->handle (line 205)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
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

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://novaerp.watys.fr/assets/js/qr_modal.js

Configuration Settings

Theme

Page Width