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

Query Metrics

20 Database Queries
8 Different statements
38.74 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.20 ms
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 2.00 ms
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:
[
  "159"
]
3 7.15 ms
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
]
4 1.88 ms
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
]
5 1.99 ms
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:
[]
6 1.81 ms
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:
[
  159
]
7 1.50 ms
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
]
8 1.58 ms
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
]
9 1.41 ms
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:
[
  222
]
10 1.56 ms
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:
[
  340
]
11 1.29 ms
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:
[
  402
]
12 1.66 ms
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:
[
  208
]
13 1.70 ms
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:
[
  403
]
14 1.53 ms
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:
[
  404
]
15 1.57 ms
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:
[
  226
]
16 1.45 ms
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:
[
  375
]
17 1.39 ms
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:
[
  454
]
18 1.25 ms
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:
[
  377
]
19 1.52 ms
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:
[
  408
]
20 1.30 ms
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:
[
  216
]

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.