GET https://test-examens-ifcyde.com/tests-examens

Query Metrics

24 Database Queries
8 Different statements
20.36 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "IFC_Config_To_Email"
]
2 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "IFC_Config_From_Email"
]
3 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "IFC_Configs_Domain"
]
4 2.16 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.shortname AS shortname_2, p0_.description AS description_3, p0_.price AS price_4, p0_.position AS position_5, p0_.type_produit AS type_produit_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image AS image_9, p0_.is_epreuve_only_choice AS is_epreuve_only_choice_10, p0_.is_require_inscription_motif AS is_require_inscription_motif_11, p0_.deleted AS deleted_12, p0_.color AS color_13, p0_.category_produit_id AS category_produit_id_14 FROM produit p0_ WHERE p0_.type_produit = ? AND p0_.category_produit_id IS NULL AND p0_.deleted = 0 GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[
  "examen"
]
5 4.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.description AS description_4 FROM category_produit t0 ORDER BY t0.position ASC
Parameters:
[]
6 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 ORDER BY t0.position ASC
Parameters:
[]
7 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM sf_configurations t0 ORDER BY t0.position ASC
Parameters:
[]
8 0.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM menu t0 WHERE t0.hook = ? LIMIT 1
Parameters:
[
  "Top"
]
9 1.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.value AS value_4, t0.link_value AS link_value_5, t0.blank_target AS blank_target_6, t0.active AS active_7, t0.cliquable AS cliquable_8, t0.position AS position_9, t0.display_children AS display_children_10, t0.display_title AS display_title_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.menu_id AS menu_id_14, t0.parent_item_menu_id AS parent_item_menu_id_15, t0.c_mspage_id AS c_mspage_id_16 FROM menu_item t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
10 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE ((t0.type_produit = ? AND t0.deleted = ?) AND t0.category_produit_id = ?) ORDER BY t0.position ASC
Parameters:
[
  "examen"
  0
  1
]
11 1.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  4
]
12 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE ((t0.type_produit = ? AND t0.deleted = ?) AND t0.category_produit_id = ?) ORDER BY t0.position ASC
Parameters:
[
  "examen"
  0
  2
]
13 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  8
]
14 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  9
]
15 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  5
]
16 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE ((t0.type_produit = ? AND t0.deleted = ?) AND t0.category_produit_id = ?) ORDER BY t0.position ASC
Parameters:
[
  "examen"
  0
  3
]
17 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  12
]
18 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  2
]
19 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  3
]
20 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  10
]
21 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.description AS description_4, t0.price AS price_5, t0.position AS position_6, t0.type_produit AS type_produit_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image AS image_10, t0.is_epreuve_only_choice AS is_epreuve_only_choice_11, t0.is_require_inscription_motif AS is_require_inscription_motif_12, t0.deleted AS deleted_13, t0.color AS color_14, t0.category_produit_id AS category_produit_id_15 FROM produit t0 WHERE ((t0.type_produit = ? AND t0.deleted = ?) AND t0.category_produit_id = ?) ORDER BY t0.position ASC
Parameters:
[
  "examen"
  0
  4
]
22 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  7
]
23 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  11
]
24 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.is_required AS is_required_5, t0.produit_id AS produit_id_6 FROM epreuve_produit t0 WHERE t0.produit_id = ?
Parameters:
[
  6
]

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\Configuration No errors.
App\Entity\Produit No errors.
App\Entity\CategoryProduit No errors.
App\Entity\SessionExamen
  • The mappings App\Entity\SessionExamen#updatedBy and App\Entity\User#sessionExamens are inconsistent with each other.
App\Entity\EpreuveProduit No errors.
App\Entity\CandidatureDetail No errors.
App\Entity\Menu No errors.
App\Entity\MenuItem No errors.
App\Entity\CMSPage No errors.