Query Metrics
11
Database Queries
8
Different statements
26.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.42 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.10 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:
[
"200"
]
|
| 3 | 7.71 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.70 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 | 2.01 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.94 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:
[
200
]
|
| 7 | 1.64 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.61 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.99 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:
[
229
]
|
| 10 | 1.57 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:
[
456
]
|
| 11 | 1.28 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Center | No errors. |
| App\Entity\FormationGroup | No errors. |
| App\Entity\Preinscription | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\InscriptionFileLog | No errors. |
| App\Entity\Formulaire | No errors. |
| App\Entity\FormulaireBlock | No errors. |
| App\Entity\InscriptionFile | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\Tarif | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Periode | No errors. |
| App\Entity\FormulaireField | No errors. |
| App\Entity\FormulaireFieldChoiceValue | No errors. |