Symfony Profiler

Query Metrics

22 Database Queries

2 Different statements

13.87 ms Query time

0 Invalid entities

43 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

10.59 ms
(76.35%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.is_public AS is_public_6, t0.is_enabled AS is_enabled_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.email_message_id AS email_message_id_12, t0.email_template_id AS email_template_id_13 FROM app_media t0 WHERE t0.id = ?

Parameters:

[
  30408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.is_public AS is_public_6,
  t0.is_enabled AS is_enabled_7,
  t0.deleted_at AS deleted_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.email_message_id AS email_message_id_12,
  t0.email_template_id AS email_template_id_13
FROM
  app_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.is_public AS is_public_6, t0.is_enabled AS is_enabled_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.email_message_id AS email_message_id_12, t0.email_template_id AS email_template_id_13 FROM app_media t0 WHERE t0.id = 30408;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 43)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 781)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 799)
5	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 365)
6	Proxies\__CG__\App\Entity\Media::Doctrine\ORM\Proxy\{closure} (line 472)
7	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
8	Proxies\__CG__\App\Entity\Media->__get (line 184)
9	App\Entity\Media->getFilename (line 59)
10	Twig\Extension\CoreExtension->getAttribute (line 1909)
11	__TwigTemplate_1087583b975101e1681bffa4c1ec690f::block_body (line 401)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_a95b6751f5b7cfe4b0402295e41dddcd->doDisplay (line 106)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_1087583b975101e1681bffa4c1ec690f->doDisplay (line 61)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 253)
24	App\Controller\SecurityController->login (line 44)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 197)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

3.28 ms
(23.65%)

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.is_shown AS is_shown_4, a0_.url AS url_5, a0_.backoffice_url AS backoffice_url_6, a0_.customer_url AS customer_url_7, a0_.tutorial_url AS tutorial_url_8, a0_.commercial_name AS commercial_name_9, a0_.phone_number AS phone_number_10, a0_.street AS street_11, a0_.postcode AS postcode_12, a0_.city AS city_13, a0_.country AS country_14, a0_.has_pricing AS has_pricing_15, a0_.has_pricing_from_api AS has_pricing_from_api_16, a0_.has_export AS has_export_17, a0_.note AS note_18, a0_.email AS email_19, a0_.deleted_at AS deleted_at_20, a0_.created_at AS created_at_21, a0_.updated_at AS updated_at_22, a0_.uuid AS uuid_23, a0_.type_id AS type_id_24, a0_.logo_id AS logo_id_25, a0_.broker_id AS broker_id_26, a0_.parent_id AS parent_id_27, a0_.user_id AS user_id_28 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC

Parameters:

[
  "wholesaler"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.is_enabled AS is_enabled_3,
  a0_.is_shown AS is_shown_4,
  a0_.url AS url_5,
  a0_.backoffice_url AS backoffice_url_6,
  a0_.customer_url AS customer_url_7,
  a0_.tutorial_url AS tutorial_url_8,
  a0_.commercial_name AS commercial_name_9,
  a0_.phone_number AS phone_number_10,
  a0_.street AS street_11,
  a0_.postcode AS postcode_12,
  a0_.city AS city_13,
  a0_.country AS country_14,
  a0_.has_pricing AS has_pricing_15,
  a0_.has_pricing_from_api AS has_pricing_from_api_16,
  a0_.has_export AS has_export_17,
  a0_.note AS note_18,
  a0_.email AS email_19,
  a0_.deleted_at AS deleted_at_20,
  a0_.created_at AS created_at_21,
  a0_.updated_at AS updated_at_22,
  a0_.uuid AS uuid_23,
  a0_.type_id AS type_id_24,
  a0_.logo_id AS logo_id_25,
  a0_.broker_id AS broker_id_26,
  a0_.parent_id AS parent_id_27,
  a0_.user_id AS user_id_28
FROM
  app_partner a0_
  LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id
WHERE
  a1_.identifier = ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.is_shown AS is_shown_4, a0_.url AS url_5, a0_.backoffice_url AS backoffice_url_6, a0_.customer_url AS customer_url_7, a0_.tutorial_url AS tutorial_url_8, a0_.commercial_name AS commercial_name_9, a0_.phone_number AS phone_number_10, a0_.street AS street_11, a0_.postcode AS postcode_12, a0_.city AS city_13, a0_.country AS country_14, a0_.has_pricing AS has_pricing_15, a0_.has_pricing_from_api AS has_pricing_from_api_16, a0_.has_export AS has_export_17, a0_.note AS note_18, a0_.email AS email_19, a0_.deleted_at AS deleted_at_20, a0_.created_at AS created_at_21, a0_.updated_at AS updated_at_22, a0_.uuid AS uuid_23, a0_.type_id AS type_id_24, a0_.logo_id AS logo_id_25, a0_.broker_id AS broker_id_26, a0_.parent_id AS parent_id_27, a0_.user_id AS user_id_28 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = 'wholesaler' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 43)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
4	Doctrine\ORM\Query->_doExecute (line 330)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
6	Doctrine\ORM\AbstractQuery->execute (line 1172)
7	Doctrine\ORM\AbstractQuery->getResult (line 907)
8	App\Repository\PartnerRepository->getAll (line 73)
9	App\Controller\SecurityController->login (line 42)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Partner	21
App\Entity\Media	21
App\Entity\Term	1

Entities Mapping

Class	Mapping errors
App\Entity\Partner	No errors.
App\Entity\Term	No errors.
App\Entity\Media	No errors.
App\Entity\Broker	No errors.
App\Entity\User	No errors.
App\Entity\Product	No errors.
App\Entity\Taxonomy	No errors.
App\Entity\BrokerPartner	No errors.
App\Entity\PartnerContact	No errors.
App\Entity\EmailMessage	No errors.
App\Entity\EmailTemplate	No errors.

Symfony Profiler

GET https://d.app.gocrm.fr/login

Configuration Settings

Theme

Page Width