https://staging.inscription.mmpp.fr/bordeaux/preinscription/pre-inscription/161

Query Metrics

14 Database Queries
8 Different statements
29.98 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.33 ms
(24.46%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.position AS position_2, m1_.id AS id_3, m1_.title AS title_4, m1_.content AS content_5, m1_.is_active AS is_active_6, m1_.created_on AS created_on_7, m1_.updated_on AS updated_on_8, m1_.meta_description AS meta_description_9, m0_.center_id AS center_id_10, m1_.formation_group_id AS formation_group_id_11, m1_.formulaire_id AS formulaire_id_12 FROM mmpp_formation_group m0_ INNER JOIN mmpp_formation m1_ ON m0_.id = m1_.formation_group_id WHERE m0_.center_id = ? AND m1_.is_active = true ORDER BY m0_.position ASC, m1_.title ASC
Parameters:
[
  2
]
6.21 ms
(20.71%)
4
SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.slug AS slug_4, t0.position AS position_5, t0.size AS size_6, t0.value AS value_7, t0.required AS required_8, t0.block_id AS block_id_9, t0.depends_on_id AS depends_on_id_10 FROM mmpp_form_field t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  207
]
5.90 ms
(19.69%)
4
SELECT t0.id AS id_1, t0.position AS position_2, t0.is_default AS is_default_3, t0.value AS value_4, t0.slug AS slug_5, t0.field_id AS field_id_6 FROM mmpp_form_field_choice_value t0 WHERE t0.field_id = ? ORDER BY t0.position ASC
Parameters:
[
  289
]
2.90 ms
(9.67%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mmpp_center t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "bordeaux"
]
2.01 ms
(6.70%)
1
SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.center_id AS center_id_4 FROM mmpp_config t0
Parameters:
[]
1.94 ms
(6.48%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.payment_type AS payment_type_4, t0.conversion_tracking_script AS conversion_tracking_script_5, t0.is_active AS is_active_6 FROM mmpp_form_formulaire t0 WHERE t0.id = ?
Parameters:
[
  "161"
]
1.87 ms
(6.25%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3 FROM mmpp_periode t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
  1
]
1.81 ms
(6.04%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.position AS position_4 FROM mmpp_form_block t0 INNER JOIN mmpp_form_formulaires_blocks ON t0.id = mmpp_form_formulaires_blocks.formulaireblock_id WHERE mmpp_form_formulaires_blocks.formulaire_id = ? ORDER BY t0.position ASC
Parameters:
[
  161
]

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.