https://dev.ici-grenoble.org/structure/lunion-syndicale-solidaires

Query Metrics

17 Database Queries
5 Different statements
5.60 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.subtitle AS subtitle_1, t0.address AS address_2, t0.postal_code AS postal_code_3, t0.town AS town_4, t0.phone AS phone_5, t0.email AS email_6, t0.website AS website_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.id AS id_10, t0.tmp_old_ids AS tmp_old_ids_11, t0.name AS name_12, t0.title AS title_13, t0.slug AS slug_14, t0.chapo AS chapo_15, t0.content AS content_16, t0.tmp_keywords AS tmp_keywords_17, t0.priority AS priority_18, t0.published AS published_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.host_id AS host_id_22, t0.includer_id AS includer_id_23 FROM structure t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "lunion-syndicale-solidaires"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  152
]
3 0.69 ms
SELECT t0.subtitle AS subtitle_1, t0.address AS address_2, t0.postal_code AS postal_code_3, t0.town AS town_4, t0.phone AS phone_5, t0.email AS email_6, t0.website AS website_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.id AS id_10, t0.tmp_old_ids AS tmp_old_ids_11, t0.name AS name_12, t0.title AS title_13, t0.slug AS slug_14, t0.chapo AS chapo_15, t0.content AS content_16, t0.tmp_keywords AS tmp_keywords_17, t0.priority AS priority_18, t0.published AS published_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.host_id AS host_id_22, t0.includer_id AS includer_id_23 FROM structure t0 INNER JOIN structure_structure_seealso ON t0.id = structure_structure_seealso.seealso_structure_target WHERE structure_structure_seealso.seealso_structure_source = ? ORDER BY t0.priority DESC, t0.name ASC
Parameters:
[
  152
]
4 0.62 ms
SELECT t0.id AS id_1, t0.tmp_old_ids AS tmp_old_ids_2, t0.name AS name_3, t0.title AS title_4, t0.slug AS slug_5, t0.chapo AS chapo_6, t0.content AS content_7, t0.tmp_keywords AS tmp_keywords_8, t0.priority AS priority_9, t0.published AS published_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM question_answer t0 INNER JOIN structure_question_answer ON t0.id = structure_question_answer.question_answer_id WHERE structure_question_answer.structure_id = ? ORDER BY t0.priority DESC, t0.name ASC
Parameters:
[
  152
]
5 0.32 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_question_answer ON t0.id = media_question_answer.media_id WHERE media_question_answer.question_answer_id = ?
Parameters:
[
  173
]
6 0.10 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_question_answer ON t0.id = media_question_answer.media_id WHERE media_question_answer.question_answer_id = ?
Parameters:
[
  208
]
7 0.85 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_question_answer ON t0.id = media_question_answer.media_id WHERE media_question_answer.question_answer_id = ?
Parameters:
[
  262
]
8 0.23 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_question_answer ON t0.id = media_question_answer.media_id WHERE media_question_answer.question_answer_id = ?
Parameters:
[
  87
]
9 0.22 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_question_answer ON t0.id = media_question_answer.media_id WHERE media_question_answer.question_answer_id = ?
Parameters:
[
  181
]
10 0.23 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_question_answer ON t0.id = media_question_answer.media_id WHERE media_question_answer.question_answer_id = ?
Parameters:
[
  89
]
11 0.27 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  227
]
12 0.23 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  155
]
13 0.23 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  544
]
14 0.23 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  548
]
15 0.25 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  129
]
16 0.21 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  153
]
17 0.19 ms
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_structure ON t0.id = media_structure.media_id WHERE media_structure.structure_id = ?
Parameters:
[
  109
]

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\Structure No errors.
App\Entity\Media No errors.
App\Entity\Tag No errors.
App\Entity\Event No errors.
App\Entity\QuestionAnswer No errors.
App\Entity\Theme No errors.
App\Entity\Article No errors.
App\Entity\Newsletter No errors.
App\Entity\Page No errors.