GET https://amai-group.com/opportunites

Query Metrics

43 Database Queries
7 Different statements
26.68 ms Query time
0 Invalid entities
68 Managed entities

Queries

Group similar statements

# Time Info
1 1.30 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "opportunites"
]
2 2.48 ms
SELECT DISTINCT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ INNER JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s0_.menu_id = ? ORDER BY s0_.position_page ASC
Parameters:
[
  2
]
3 0.81 ms
SELECT s0_.id AS id_0, s0_.titre_principal AS titre_principal_1, s0_.sous_titre_principal AS sous_titre_principal_2, s0_.contenu_principal AS contenu_principal_3, s0_.code_image_principale AS code_image_principale_4, s0_.position_page AS position_page_5, s0_.code_fichier AS code_fichier_6, s0_.position_template AS position_template_7, s0_.background_image AS background_image_8, s0_.background_color AS background_color_9, s0_.lien_bouton_action1 AS lien_bouton_action1_10, s0_.lien_bouton_action2 AS lien_bouton_action2_11, s0_.lien_bouton_action3 AS lien_bouton_action3_12, s0_.titre_bouton_action1 AS titre_bouton_action1_13, s0_.titre_bouton_action2 AS titre_bouton_action2_14, s0_.titre_bouton_action3 AS titre_bouton_action3_15, s0_.reference AS reference_16, s0_.autre_document_code_fichier AS autre_document_code_fichier_17, s0_.parent_id AS parent_id_18, s0_.menu_id AS menu_id_19, s0_.actualite_evenement_id AS actualite_evenement_id_20 FROM section s0_ LEFT JOIN section s1_ ON s0_.id = s1_.parent_id WHERE s0_.parent_id IS NULL AND s1_.id IS NULL AND s0_.menu_id = ? ORDER BY s0_.position_page ASC
Parameters:
[
  2
]
4 0.99 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "opportunites"
]
5 0.60 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "accueil"
]
6 0.59 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "opportunites"
]
7 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "solutions"
]
8 0.39 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "evenements"
]
9 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "a-propos"
]
10 0.52 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.color AS color_3, t0.background_color AS background_color_4, t0.font_size AS font_size_5, t0.date AS date_6, t0.code AS code_7, t0.parent_id AS parent_id_8 FROM menu t0 WHERE t0.code = ? AND t0.parent_id IS NULL LIMIT 1
Parameters:
[
  "contact"
]
11 1.89 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = ?
Parameters:
[
  13
]
12 1.17 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "5PeDc5VTLJLeK8if"
]
13 0.43 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "5PeDc5VTLJLeK8if"
]
14 0.48 ms
SELECT t0.id AS id_1, t0.titre_principal AS titre_principal_2, t0.sous_titre_principal AS sous_titre_principal_3, t0.contenu_principal AS contenu_principal_4, t0.code_image_principale AS code_image_principale_5, t0.position_page AS position_page_6, t0.code_fichier AS code_fichier_7, t0.position_template AS position_template_8, t0.background_image AS background_image_9, t0.background_color AS background_color_10, t0.lien_bouton_action1 AS lien_bouton_action1_11, t0.lien_bouton_action2 AS lien_bouton_action2_12, t0.lien_bouton_action3 AS lien_bouton_action3_13, t0.titre_bouton_action1 AS titre_bouton_action1_14, t0.titre_bouton_action2 AS titre_bouton_action2_15, t0.titre_bouton_action3 AS titre_bouton_action3_16, t0.reference AS reference_17, t0.autre_document_code_fichier AS autre_document_code_fichier_18, t0.parent_id AS parent_id_19, t0.menu_id AS menu_id_20, t0.actualite_evenement_id AS actualite_evenement_id_21 FROM section t0 WHERE t0.parent_id = ?
Parameters:
[
  14
]
15 0.47 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = ?
Parameters:
[
  15
]
16 0.92 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "aGk6gxeAGkc2kyEJ"
]
17 0.42 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "Qvri1AJBNP6fKOq2"
]
18 0.41 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "k1LknSFFckLCP9Jk"
]
19 0.62 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "srOg9QNyITdJnN1f"
]
20 0.54 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "TXUw6B8REuqC4flW"
]
21 0.56 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "4SPuTnosytO4fHYj"
]
22 0.98 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = ?
Parameters:
[
  16
]
23 0.60 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "tl1XECTV5SBJZTk4"
]
24 0.39 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "YTSnMnPIjfdwilVf"
]
25 0.51 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "2x8Osf4zYVtVHGbw"
]
26 0.50 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "zeHS59ndl13Dk4PU"
]
27 0.43 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "MymTAPoxalayewqg"
]
28 0.40 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "xZaz4JEeloFz4CAu"
]
29 0.39 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "ZcEwbyOjBGIQPf1e"
]
30 0.46 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "pgoWdzM4WQIc5qwx"
]
31 0.45 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "8DqepPILIqJazUxs"
]
32 0.43 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "Kgv4o5O9KhNyfvEC"
]
33 0.44 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "YqzwcTDAXVTlBnYs"
]
34 0.42 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "lkGmbHkMhIKvrOoq"
]
35 0.38 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "xFpkZSlhCU38QI5p"
]
36 0.49 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "I3Dh21lWsxuOYhlu"
]
37 0.42 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "d6A96oSFYcBYAnrj"
]
38 0.38 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "1GcPpuxcRd3XGEdp"
]
39 0.41 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "fMaijYSXC5nHCMUk"
]
40 0.37 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "DPuUDe5Cp2WQIYaq"
]
41 0.39 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "bsBQLykfmzedryn4"
]
42 0.52 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.code_fichier AS code_fichier_4, t0.position_contenu AS position_contenu_5, t0.sous_titre AS sous_titre_6, t0.lien_bouton_action1 AS lien_bouton_action1_7, t0.lien_bouton_action2 AS lien_bouton_action2_8, t0.lien_bouton_action3 AS lien_bouton_action3_9, t0.titre_bouton_action1 AS titre_bouton_action1_10, t0.titre_bouton_action2 AS titre_bouton_action2_11, t0.titre_bouton_action3 AS titre_bouton_action3_12, t0.autre_document_code_fichier AS autre_document_code_fichier_13, t0.section_id AS section_id_14 FROM disposition t0 WHERE t0.section_id = ?
Parameters:
[
  17
]
43 0.45 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.type AS type_4, t0.location AS location_5, t0.size AS size_6, t0.reference_code AS reference_code_7, t0.temp AS temp_8, t0.lien AS lien_9 FROM files t0 WHERE t0.reference_code = ? LIMIT 1
Parameters:
[
  "Aowj2EJAeOXifbZD"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Disposition 30
App\Entity\Files 27
App\Entity\Menu 6
App\Entity\Section 5

Entities Mapping

Class Mapping errors
App\Entity\Menu No errors.
App\Entity\Section No errors.
App\Entity\ActualiteEvenement No errors.
App\Entity\Disposition No errors.
App\Entity\Files No errors.