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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
5.69 ms
(27.94%)
11
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
]
4.51 ms
(22.16%)
1
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:
[]
2.59 ms
(12.72%)
4
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
]
2.16 ms
(10.60%)
1
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"
]
1.79 ms
(8.80%)
3
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"
]
1.54 ms
(7.57%)
1
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
]
1.09 ms
(5.33%)
2
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:
[]
0.99 ms
(4.88%)
1
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"
]

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.