GET https://locamod-preprod.kwantic.fr/produit/48-plaque-vibrante-400kg

Query Metrics

150 Database Queries
34 Different statements
78.46 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.87 ms
(11.31%)
17
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 INNER JOIN agence_category ON t0.id = agence_category.category_id WHERE agence_category.agence_id = ?
Parameters:
[
  1
]
8.82 ms
(11.25%)
17
SELECT t0.id AS id_1, t0.name AS name_2, t0.img_black AS img_black_3, t0.img AS img_4 FROM type_materiel t0 INNER JOIN agence_type_materiel ON t0.id = agence_type_materiel.type_materiel_id WHERE agence_type_materiel.agence_id = ?
Parameters:
[
  1
]
8.44 ms
(10.76%)
17
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 INNER JOIN agence_product ON t0.id = agence_product.product_id WHERE agence_product.agence_id = ?
Parameters:
[
  1
]
4.64 ms
(5.92%)
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
]
4.48 ms
(5.71%)
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"
]
3.87 ms
(4.93%)
9
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
]
2.75 ms
(3.51%)
4
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:
[
  56
]
2.75 ms
(3.51%)
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"
]
2.72 ms
(3.46%)
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.actif = ? AND t0.id = ? LIMIT 1
Parameters:
[
  1
  48
]
2.58 ms
(3.29%)
1
SELECT p0_.id AS id_0, p0_.description AS description_1, p0_.product_id AS product_id_2, p0_.bloc_avantage_id AS bloc_avantage_id_3 FROM product_bloc_avantage p0_ INNER JOIN bloc_avantage b1_ ON p0_.bloc_avantage_id = b1_.id INNER JOIN product p2_ ON p0_.product_id = p2_.id WHERE b1_.actif = 1 AND p2_.id = ? AND p2_.actif = 1 ORDER BY p0_.id ASC
Parameters:
[
  48
]
2.50 ms
(3.19%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.suffix AS suffix_4, t0.show_in_list_product AS show_in_list_product_5, t0.type_unite AS type_unite_6, t0.name_admin AS name_admin_7 FROM caracteristique t0 WHERE t0.id = ?
Parameters:
[
  23
]
2.30 ms
(2.94%)
8
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 = ? AND t0.cover = ? LIMIT 1
Parameters:
[
  48
  1
]
2.27 ms
(2.89%)
6
SELECT t0.id AS id_1, t0.value AS value_2, t0.caracteristique_id AS caracteristique_id_3 FROM caracteristique_values t0 WHERE t0.id = ?
Parameters:
[
  226
]
2.19 ms
(2.79%)
5
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.16 ms
(2.75%)
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.57 ms
(2.00%)
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:
[
  57
  58
  59
  60
]
1.55 ms
(1.97%)
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:
[
  48
]
1.53 ms
(1.96%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.class AS class_4 FROM region t0 WHERE t0.actif = ?
Parameters:
[
  1
]
1.51 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.caracteristique_id AS caracteristique_id_2, t0.product_id AS product_id_3, t0.caracteristique_values_id AS caracteristique_values_id_4 FROM caracteristique_product t0 WHERE t0.product_id = ?
Parameters:
[
  48
]
1.50 ms
(1.91%)
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:
[]
1.50 ms
(1.91%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.phone AS phone_4, t0.mail AS mail_5, t0.actif AS actif_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.link_rewrite AS link_rewrite_9, t0.horaires_lundi_jeudi_matin AS horaires_lundi_jeudi_matin_10, t0.horaires_lundi_jeudi_apres_midi AS horaires_lundi_jeudi_apres_midi_11, t0.horaires_vendredi_matin AS horaires_vendredi_matin_12, t0.horaires_vendredi_apres_midi AS horaires_vendredi_apres_midi_13, t0.itineraire AS itineraire_14, t0.review AS review_15, t0.image AS image_16, t0.region_id AS region_id_17 FROM agence t0 WHERE t0.region_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  6
  7
  8
  9
]
1.11 ms
(1.42%)
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.09 ms
(1.39%)
1
SELECT t0.id AS id_1, t0.product_parent_id AS product_parent_id_2, t0.product_id AS product_id_3 FROM product_associe t0 WHERE t0.product_parent_id = ?
Parameters:
[
  48
]
0.94 ms
(1.19%)
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:
[
  42
  43
  44
  45
  46
  47
  49
  50
]
0.81 ms
(1.03%)
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:
[
  15
  16
]
0.80 ms
(1.02%)
3
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.description AS description_4, t0.actif AS actif_5 FROM bloc_avantage t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.53 ms
(0.68%)
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.47 ms
(0.61%)
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:
[
  51
  52
  53
  54
  55
  56
  57
  58
  59
  60
  61
  62
]
0.41 ms
(0.53%)
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.40 ms
(0.51%)
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.37 ms
(0.47%)
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
]
0.34 ms
(0.43%)
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.33 ms
(0.43%)
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
  24
  29
]
0.32 ms
(0.41%)
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
]

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\Product No errors.
App\Entity\Category 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\Agence No errors.
App\Entity\QuizReponse No errors.
App\Entity\Devis No errors.
App\Entity\TrendingMachine No errors.
App\Entity\Caracteristique
  • The mappings App\Entity\Caracteristique#filters and App\Entity\Filters#caracteristique are inconsistent with each other.
App\Entity\BlocAvantage No errors.
App\Entity\MegaMenu No errors.
App\Entity\Page No errors.
App\Entity\PageBlock No errors.
App\Entity\CaracteristiqueValues No errors.
App\Entity\Filters
  • The association App\Entity\Filters#caracteristique refers to the inverse side field App\Entity\Caracteristique#Filters which does not exist.
App\Entity\Region No errors.
App\Entity\TypeMateriel No errors.
App\Entity\Contacts No errors.
App\Entity\OffreEmploi No errors.
App\Entity\MenuFooter No errors.