GET https://locamod-preprod.kwantic.fr/actualite/1-renouvellement-de-notre-label-se

Query Metrics

60 Database Queries
24 Different statements
35.44 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.96 ms
(16.81%)
11
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = ? AND t0.actif = ?
Parameters:
[
  2
  1
]
5.78 ms
(16.30%)
13
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.actif = ? AND t0.parent_id = ?
Parameters:
[
  1
  "1"
]
4.03 ms
(11.37%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.quote_background AS quote_background_5, t0.image_position AS image_position_6, t0.position AS position_7, t0.image_one_width AS image_one_width_8, t0.image_one_height AS image_one_height_9, t0.image_mode AS image_mode_10, t0.actualite_id AS actualite_id_11 FROM actualite_block t0 WHERE t0.actualite_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
2.33 ms
(6.56%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?)
Parameters:
[
  10
  11
  14
]
2.20 ms
(6.20%)
5
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.link_rewrite AS link_rewrite_5, t0.actif AS actif_6, t0.subtitle AS subtitle_7, t0.video_youtube_link AS video_youtube_link_8 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
1.53 ms
(4.33%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?)
Parameters:
[
  1
]
1.45 ms
(4.10%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.image AS image_4, t0.date_actualite AS date_actualite_5, t0.download_pdf AS download_pdf_6, t0.description AS description_7, t0.actif AS actif_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.link_rewrite AS link_rewrite_11 FROM actualite t0 WHERE t0.actif = ? AND t0.id = ? LIMIT 1
Parameters:
[
  1
  1
]
1.43 ms
(4.03%)
2
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  3
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
]
1.39 ms
(3.93%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_href AS custom_href_3, t0.type AS type_4, t0.target AS target_5, t0.position AS position_6, t0.emplacement AS emplacement_7 FROM menu_footer t0 WHERE t0.emplacement = ? ORDER BY t0.position ASC
Parameters:
[
  "menu_gauche"
]
1.16 ms
(3.26%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?, ?)
Parameters:
[
  26
  28
  61
  63
]
0.98 ms
(2.76%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.custom_href AS custom_href_3, t0.type AS type_4, t0.target AS target_5, t0.position AS position_6 FROM mega_menu t0 ORDER BY t0.position ASC
Parameters:
[]
0.89 ms
(2.51%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?)
Parameters:
[
  2
  6
]
0.74 ms
(2.09%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.short_description AS short_description_2, a0_.image AS image_3, a0_.date_actualite AS date_actualite_4, a0_.download_pdf AS download_pdf_5, a0_.description AS description_6, a0_.actif AS actif_7, a0_.meta_title AS meta_title_8, a0_.meta_description AS meta_description_9, a0_.link_rewrite AS link_rewrite_10 FROM actualite a0_ WHERE a0_.actif = 1 AND a0_.id NOT IN (?) ORDER BY a0_.date_actualite ASC LIMIT 10
Parameters:
[
  1
]
0.64 ms
(1.79%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  72
  122
  73
  74
  75
  123
  76
  77
]
0.61 ms
(1.72%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  108
  109
  110
  111
  112
  113
  114
  115
  116
  117
  118
  119
  120
  121
]
0.59 ms
(1.67%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  42
  43
  44
  45
  46
  47
  48
  49
  50
  51
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
]
0.54 ms
(1.52%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  64
  65
  66
  67
  68
  69
  63
  70
  71
]
0.52 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?)
Parameters:
[
  124
  126
]
0.52 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  102
  103
  104
  105
  106
  107
]
0.49 ms
(1.37%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.actif AS actif_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.48 ms
(1.35%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?, ?, ?)
Parameters:
[
  56
  57
  58
  59
  60
]
0.47 ms
(1.33%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.modele AS modele_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.link_rewrite AS link_rewrite_8, t0.ecoresponsable AS ecoresponsable_9, t0.fichetechnique AS fichetechnique_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.crit_air AS crit_air_13, t0.category_id AS category_id_14, t0.marque_id AS marque_id_15 FROM product t0 WHERE t0.category_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  7
  8
  9
  20
  24
  29
]
0.37 ms
(1.05%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  35
  36
  37
  38
  39
  40
  41
]
0.36 ms
(1.01%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.cover AS cover_3, t0.product_id AS product_id_4 FROM image t0 WHERE t0.product_id IN (?, ?, ?, ?, ?)
Parameters:
[
  30
  31
  32
  33
  34
]

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\Actualite No errors.
App\Entity\ActualiteBlock No errors.
App\Entity\MegaMenu No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\Caracteristique
  • The mappings App\Entity\Caracteristique#filters and App\Entity\Filters#caracteristique are inconsistent with each other.
App\Entity\Agence No errors.
App\Entity\Marque No errors.
App\Entity\Image No errors.
App\Entity\CaracteristiqueProduct No errors.
App\Entity\ProductBlocAvantage No errors.
App\Entity\ProductAssocie No errors.
App\Entity\QuizReponse No errors.
App\Entity\Devis No errors.
App\Entity\TrendingMachine No errors.
App\Entity\Page No errors.
App\Entity\PageBlock No errors.
App\Entity\MenuFooter No errors.