Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.94 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.62 ms

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, p3_.id AS id_13, p3_.sort AS sort_14, p4_.id AS id_15, p4_.title AS title_16, p4_.locale AS locale_17, p5_.id AS id_18, p5_.image AS image_19, p5_.sort AS sort_20, p0_.particular_project_budget_id AS particular_project_budget_id_21, p0_.user_id AS user_id_22, p1_.translatable_id AS translatable_id_23, p4_.translatable_id AS translatable_id_24, p5_.particular_project_id AS particular_project_id_25 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id AND (s7_.locale = ?) LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id AND (p4_.locale = ?) LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id WHERE p0_.status = ? AND p0_.id = ?

Parameters:

[
  "en"
  "en"
  "active"
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.postcode AS postcode_2,
  p0_.year_of_construction AS year_of_construction_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p1_.id AS id_6,
  p1_.title AS title_7,
  p1_.description AS description_8,
  p1_.locale AS locale_9,
  s2_.id AS id_10,
  s2_.icon_image AS icon_image_11,
  s2_.sort AS sort_12,
  p3_.id AS id_13,
  p3_.sort AS sort_14,
  p4_.id AS id_15,
  p4_.title AS title_16,
  p4_.locale AS locale_17,
  p5_.id AS id_18,
  p5_.image AS image_19,
  p5_.sort AS sort_20,
  p0_.particular_project_budget_id AS particular_project_budget_id_21,
  p0_.user_id AS user_id_22,
  p1_.translatable_id AS translatable_id_23,
  p4_.translatable_id AS translatable_id_24,
  p5_.particular_project_id AS particular_project_id_25
FROM
  particular_project p0_
  LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id
  LEFT JOIN service s2_ ON s2_.id = p6_.service_id
  LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id
  AND (s7_.locale = ?)
  LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id
  LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id
  AND (p4_.locale = ?)
  LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id
WHERE
  p0_.status = ?
  AND p0_.id = ?

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, p3_.id AS id_13, p3_.sort AS sort_14, p4_.id AS id_15, p4_.title AS title_16, p4_.locale AS locale_17, p5_.id AS id_18, p5_.image AS image_19, p5_.sort AS sort_20, p0_.particular_project_budget_id AS particular_project_budget_id_21, p0_.user_id AS user_id_22, p1_.translatable_id AS translatable_id_23, p4_.translatable_id AS translatable_id_24, p5_.particular_project_id AS particular_project_id_25 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id AND (s7_.locale = 'en') LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id AND (p4_.locale = 'en') LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id WHERE p0_.status = 'active' AND p0_.id = 13;

#	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->getOneOrNullResult (line 737)
6	App\Repository\Particular\ParticularProjectRepository->findParticularProjectById (line 112)
7	App\Controller\Front\ParticularProjectController->detail (line 66)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.53 ms

SELECT c0_.id AS id_0, c0_.postcode AS postcode_1, c1_.id AS id_2, c1_.name AS name_3, c1_.locale AS locale_4, c0_.country_id AS country_id_5, c0_.province_id AS province_id_6, c1_.translatable_id AS translatable_id_7 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = ?) WHERE c0_.postcode = ?

Parameters:

[
  "en"
  "1025"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.postcode AS postcode_1,
  c1_.id AS id_2,
  c1_.name AS name_3,
  c1_.locale AS locale_4,
  c0_.country_id AS country_id_5,
  c0_.province_id AS province_id_6,
  c1_.translatable_id AS translatable_id_7
FROM
  city c0_
  LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = ?)
WHERE
  c0_.postcode = ?

SELECT c0_.id AS id_0, c0_.postcode AS postcode_1, c1_.id AS id_2, c1_.name AS name_3, c1_.locale AS locale_4, c0_.country_id AS country_id_5, c0_.province_id AS province_id_6, c1_.translatable_id AS translatable_id_7 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'en') WHERE c0_.postcode = '1025';

#	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->getOneOrNullResult (line 737)
6	App\Repository\Localisation\CityRepository->findCityByPostCode (line 36)
7	App\Controller\Front\ParticularProjectController->detail (line 73)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.46 ms

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, p3_.id AS id_13, p3_.sort AS sort_14, p4_.id AS id_15, p4_.title AS title_16, p4_.locale AS locale_17, p5_.id AS id_18, p5_.image AS image_19, p5_.sort AS sort_20, p0_.particular_project_budget_id AS particular_project_budget_id_21, p0_.user_id AS user_id_22, p1_.translatable_id AS translatable_id_23, p4_.translatable_id AS translatable_id_24, p5_.particular_project_id AS particular_project_id_25 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id AND (s7_.locale = ?) LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id AND (p4_.locale = ?) LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id WHERE p0_.status = ? AND s2_.id IN (NULL) AND p0_.id NOT IN (?) ORDER BY p0_.created_at DESC LIMIT 4

Parameters:

[
  "en"
  "en"
  "active"
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.postcode AS postcode_2,
  p0_.year_of_construction AS year_of_construction_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p1_.id AS id_6,
  p1_.title AS title_7,
  p1_.description AS description_8,
  p1_.locale AS locale_9,
  s2_.id AS id_10,
  s2_.icon_image AS icon_image_11,
  s2_.sort AS sort_12,
  p3_.id AS id_13,
  p3_.sort AS sort_14,
  p4_.id AS id_15,
  p4_.title AS title_16,
  p4_.locale AS locale_17,
  p5_.id AS id_18,
  p5_.image AS image_19,
  p5_.sort AS sort_20,
  p0_.particular_project_budget_id AS particular_project_budget_id_21,
  p0_.user_id AS user_id_22,
  p1_.translatable_id AS translatable_id_23,
  p4_.translatable_id AS translatable_id_24,
  p5_.particular_project_id AS particular_project_id_25
FROM
  particular_project p0_
  LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id
  LEFT JOIN service s2_ ON s2_.id = p6_.service_id
  LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id
  AND (s7_.locale = ?)
  LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id
  LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id
  AND (p4_.locale = ?)
  LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id
WHERE
  p0_.status = ?
  AND s2_.id IN (NULL)
  AND p0_.id NOT IN (?)
ORDER BY
  p0_.created_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, p3_.id AS id_13, p3_.sort AS sort_14, p4_.id AS id_15, p4_.title AS title_16, p4_.locale AS locale_17, p5_.id AS id_18, p5_.image AS image_19, p5_.sort AS sort_20, p0_.particular_project_budget_id AS particular_project_budget_id_21, p0_.user_id AS user_id_22, p1_.translatable_id AS translatable_id_23, p4_.translatable_id AS translatable_id_24, p5_.particular_project_id AS particular_project_id_25 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id AND (s7_.locale = 'en') LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id AND (p4_.locale = 'en') LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id WHERE p0_.status = 'active' AND s2_.id IN (NULL) AND p0_.id NOT IN (13) ORDER BY p0_.created_at DESC LIMIT 4;

#	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\Particular\ParticularProjectRepository->findParticularProjectsByServices (line 136)
7	App\Controller\Front\ParticularProjectController->detail (line 82)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.33 ms

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.phone AS phone_6, t0.password AS password_7, t0.language AS language_8, t0.roles AS roles_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM user t0 WHERE t0.id = ?

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.lastname AS lastname_3,
  t0.firstname AS firstname_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.password AS password_7,
  t0.language AS language_8,
  t0.roles AS roles_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.phone AS phone_6, t0.password AS password_7, t0.language AS language_8, t0.roles AS roles_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM user t0 WHERE t0.id = 46;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\User\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User\User->__get (line 153)
7	App\Entity\User\User->getLastname (line 102)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_1e74eefd03211e7f73eb49ea3c3ffb2d::block_content (line 101)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_fdfe382cd43826d26e5a6c38eae2173e->doDisplay (line 123)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_1e74eefd03211e7f73eb49ea3c3ffb2d->doDisplay (line 53)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\Front\ParticularProjectController->detail (line 84)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
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
App\Entity\Particular\ParticularProject	1
App\Entity\User\User	1
App\Entity\Particular\ParticularProjectTranslation	1
App\Entity\Particular\ParticularProjectBudget	1
App\Entity\Particular\ParticularProjectBudgetTranslation	1

Entities Mapping

Class	Mapping errors
App\Entity\Particular\ParticularProject	No errors.
App\Entity\Particular\ParticularProjectTranslation	No errors.
App\Entity\Service\Service	No errors.
App\Entity\Service\ServiceTranslation	No errors.
App\Entity\Particular\ParticularProjectBudget	No errors.
App\Entity\Particular\ParticularProjectBudgetTranslation	No errors.
App\Entity\Particular\ParticularProjectImage	No errors.
App\Entity\User\User	No errors.
App\Entity\Localisation\City	No errors.
App\Entity\Localisation\CityTranslation	No errors.
App\Entity\Localisation\Country	No errors.
App\Entity\Localisation\Province	No errors.
App\Entity\Company\Company	No errors.
App\Entity\Particular\ParticularCompanyWishlist	No errors.
App\Entity\Company\CompanyProjectWishlist	No errors.

Symfony Profiler

GET https://www.renovaweb.hb-preprod.com/en/project/13-titre-du-projet%252A

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping