GET https://www.renovaweb.hb-preprod.com/trouver-un-projet

Query Metrics

14 Database Queries
5 Different statements
7.98 ms Query time
0 Invalid entities
134 Managed entities

Queries

Group similar statements

# Time Info
1 2.64 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, s3_.id AS id_13, s3_.title AS title_14, s3_.slug AS slug_15, s3_.profession_title AS profession_title_16, s3_.profession_description AS profession_description_17, s3_.seo_title AS seo_title_18, s3_.seo_description AS seo_description_19, s3_.seo_image AS seo_image_20, s3_.locale AS locale_21, p4_.id AS id_22, p4_.sort AS sort_23, p5_.id AS id_24, p5_.title AS title_25, p5_.locale AS locale_26, p0_.particular_project_budget_id AS particular_project_budget_id_27, p0_.user_id AS user_id_28, p1_.translatable_id AS translatable_id_29, s3_.translatable_id AS translatable_id_30, p5_.translatable_id AS translatable_id_31 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 s3_ ON s2_.id = s3_.translatable_id AND (s3_.locale = ?) LEFT JOIN particular_project_budget p4_ ON p0_.particular_project_budget_id = p4_.id LEFT JOIN particular_project_budget_translation p5_ ON p4_.id = p5_.translatable_id AND (p5_.locale = ?) WHERE p0_.status IN (?) ORDER BY p0_.created_at DESC
Parameters:
[
  "fr"
  "fr"
  "active"
]
2 0.58 ms
SELECT s0_.id AS id_0, s0_.icon_image AS icon_image_1, s0_.sort AS sort_2, s1_.id AS id_3, s1_.title AS title_4, s1_.slug AS slug_5, s1_.profession_title AS profession_title_6, s1_.profession_description AS profession_description_7, s1_.seo_title AS seo_title_8, s1_.seo_description AS seo_description_9, s1_.seo_image AS seo_image_10, s1_.locale AS locale_11, s1_.translatable_id AS translatable_id_12 FROM service s0_ LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?)
Parameters:
[
  "fr"
]
3 1.84 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 = ?)
Parameters:
[
  "fr"
]
4 0.46 ms
SELECT p0_.id AS id_0, p0_.sort AS sort_1, p1_.id AS id_2, p1_.title AS title_3, p1_.locale AS locale_4, p1_.translatable_id AS translatable_id_5 FROM particular_project_budget p0_ LEFT JOIN particular_project_budget_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.locale = ?)
Parameters:
[
  "fr"
]
5 0.29 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  17
]
6 0.23 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  16
]
7 0.28 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  15
]
8 0.24 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  14
]
9 0.25 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  13
]
10 0.23 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  12
]
11 0.23 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  11
]
12 0.23 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  10
]
13 0.25 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  9
]
14 0.24 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.sort AS sort_3, t0.particular_project_id AS particular_project_id_4 FROM particular_project_image t0 WHERE t0.particular_project_id = ?
Parameters:
[
  8
]

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\Localisation\City 22
App\Entity\Localisation\CityTranslation 22
App\Entity\Service\Service 20
App\Entity\Service\ServiceTranslation 20
App\Entity\Particular\ParticularProjectTranslation 15
App\Entity\Particular\ParticularProjectImage 12
App\Entity\Particular\ParticularProject 10
App\Entity\Particular\ParticularProjectBudget 4
App\Entity\Particular\ParticularProjectBudgetTranslation 4
App\Entity\User\User 3
App\Entity\Localisation\Country 1
App\Entity\Localisation\Province 1