https://new.geneve-ville-vivante.ch/

Query Metrics

6 Database Queries
5 Different statements
4.54 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.46 ms
(32.29%)
1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.short_description AS short_description_2, t0_.description AS description_3, t0_.slug AS slug_4, t0_.id AS id_5, t0_.name AS name_6, t0_.short_description AS short_description_7, t0_.description AS description_8, t0_.slug AS slug_9, t1_.id AS id_10, t1_.started_at AS started_at_11, t1_.ended_at AS ended_at_12, u2_.id AS id_13, u2_.username AS username_14, u2_.email AS email_15, u2_.roles AS roles_16, u2_.password AS password_17, u2_.slug AS slug_18, u2_.name AS name_19, u2_.first_name AS first_name_20, u2_.birth_date AS birth_date_21, u2_.is_banned AS is_banned_22, u2_.is_active AS is_active_23, u2_.created_at AS created_at_24, u2_.updated_at AS updated_at_25, u2_.activation_code AS activation_code_26, u2_.phone AS phone_27, u2_.nickname AS nickname_28, u2_.image_name AS image_name_29, u2_.password_reset_code AS password_reset_code_30, u2_.is_public_profile AS is_public_profile_31, u2_.logged_at AS logged_at_32, t3_.id AS id_33, t3_.name AS name_34, t3_.short_description AS short_description_35, t3_.description AS description_36, t0_.parent_id AS parent_id_37, t1_.user_id AS user_id_38, t1_.team_id AS team_id_39 FROM team t0_ INNER JOIN team_member t1_ ON t0_.id = t1_.team_id INNER JOIN user u2_ ON t1_.user_id = u2_.id INNER JOIN team_role_team_member t4_ ON t1_.id = t4_.team_member_id INNER JOIN team_role t3_ ON t3_.id = t4_.team_role_id WHERE t0_.slug = ?
Parameters:
[
  "geneve-ville-vivante"
]
1.03 ms
(22.73%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_url AS image_url_3, t0.slug AS slug_4 FROM header_banner t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "gvv"
]
0.95 ms
(21.04%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4 FROM header_title_subtitle t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "be-gvv"
]
0.62 ms
(13.73%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.color AS color_5, t0.slug AS slug_6, t0.acronym AS acronym_7, t0.is_show_team AS is_show_team_8, t0.image_name AS image_name_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_visible AS is_visible_12, t0.is_show_home AS is_show_home_13, t0.parent_id AS parent_id_14, t0.team_id AS team_id_15 FROM project t0 WHERE t0.is_show_home = ?
Parameters:
[
  1
]
0.46 ms
(10.21%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.color AS color_5, t0.slug AS slug_6, t0.acronym AS acronym_7, t0.is_show_team AS is_show_team_8, t0.image_name AS image_name_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_visible AS is_visible_12, t0.is_show_home AS is_show_home_13, t0.parent_id AS parent_id_14, t0.team_id AS team_id_15 FROM project t0 WHERE t0.team_id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\HeaderBanner No errors.
App\Entity\HeaderTitleSubtitle No errors.
App\Entity\Project No errors.
App\Entity\Team No errors.
App\Entity\User No errors.
App\Entity\TeamMember No errors.
App\Entity\TeamRole No errors.