Query Metrics
5
Database Queries
4
Different statements
1.76 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.68 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.cost AS cost_3, p0_.image AS image_4, p0_.precommande AS precommande_5, p0_.apropos AS apropos_6, p0_.avertissement AS avertissement_7, p0_.precautions_emploi AS precautions_emploi_8, p0_.breve_description AS breve_description_9, p0_.volume AS volume_10, p0_.legende_image AS legende_image_11, p0_.metatitle AS metatitle_12, p0_.metadescription AS metadescription_13, p0_.name_english AS name_english_14, p0_.breve_description_english AS breve_description_english_15, p0_.apropos_english AS apropos_english_16, p0_.description_english AS description_english_17, p0_.avertissement_english AS avertissement_english_18, p0_.precautions_emploi_english AS precautions_emploi_english_19, p0_.langue AS langue_20, p0_.legal_notice AS legal_notice_21, p0_.legal_notice_english AS legal_notice_english_22, p0_.origin_and_current_production AS origin_and_current_production_23, p0_.origin_and_current_production_english AS origin_and_current_production_english_24, p0_.usage_tips AS usage_tips_25, p0_.usage_tips_english AS usage_tips_english_26, p0_.composition_and_precautions_for_use AS composition_and_precautions_for_use_27, p0_.composition_and_precautions_for_use_english AS composition_and_precautions_for_use_english_28, p0_.precautions_generales AS precautions_generales_29, p0_.precautions_generales_english AS precautions_generales_english_30, p0_.reference_sku AS reference_sku_31, p0_.featured AS featured_32, p0_.tva AS tva_33, p0_.is_month_product AS is_month_product_34, p0_.maj_date AS maj_date_35, p0_.status AS status_36, p0_.id_product_category AS id_product_category_37 FROM product p0_ WHERE p0_.featured = 1 AND p0_.status > ? ORDER BY p0_.maj_date DESC LIMIT 4
Parameters:
[
-2
]
|
| 2 | 0.36 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.cost AS cost_3, p0_.image AS image_4, p0_.precommande AS precommande_5, p0_.apropos AS apropos_6, p0_.avertissement AS avertissement_7, p0_.precautions_emploi AS precautions_emploi_8, p0_.breve_description AS breve_description_9, p0_.volume AS volume_10, p0_.legende_image AS legende_image_11, p0_.metatitle AS metatitle_12, p0_.metadescription AS metadescription_13, p0_.name_english AS name_english_14, p0_.breve_description_english AS breve_description_english_15, p0_.apropos_english AS apropos_english_16, p0_.description_english AS description_english_17, p0_.avertissement_english AS avertissement_english_18, p0_.precautions_emploi_english AS precautions_emploi_english_19, p0_.langue AS langue_20, p0_.legal_notice AS legal_notice_21, p0_.legal_notice_english AS legal_notice_english_22, p0_.origin_and_current_production AS origin_and_current_production_23, p0_.origin_and_current_production_english AS origin_and_current_production_english_24, p0_.usage_tips AS usage_tips_25, p0_.usage_tips_english AS usage_tips_english_26, p0_.composition_and_precautions_for_use AS composition_and_precautions_for_use_27, p0_.composition_and_precautions_for_use_english AS composition_and_precautions_for_use_english_28, p0_.precautions_generales AS precautions_generales_29, p0_.precautions_generales_english AS precautions_generales_english_30, p0_.reference_sku AS reference_sku_31, p0_.featured AS featured_32, p0_.tva AS tva_33, p0_.is_month_product AS is_month_product_34, p0_.maj_date AS maj_date_35, p0_.status AS status_36, p0_.id_product_category AS id_product_category_37 FROM product p0_ WHERE p0_.is_month_product = 1 AND p0_.status > ? ORDER BY p0_.maj_date DESC LIMIT 1
Parameters:
[
-2
]
|
| 3 | 0.25 ms |
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.description AS description_3, b0_.date_publication AS date_publication_4, b0_.nom_auteur AS nom_auteur_5, b0_.contenu AS contenu_6, b0_.statut AS statut_7, b0_.metatitle AS metatitle_8, b0_.metadescription AS metadescription_9, b0_.langue AS langue_10, b0_.auteur_id AS auteur_id_11, b0_.categorie_id AS categorie_id_12 FROM blog b0_ WHERE b0_.statut = 1 ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[] |
| 4 | 0.22 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.val AS val_2, c0_.num AS num_3, c0_.statut AS statut_4 FROM config c0_ WHERE c0_.num = ? AND c0_.statut = ?
Parameters:
[ 1 1 ] |
| 5 | 0.25 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.val AS val_2, c0_.num AS num_3, c0_.statut AS statut_4 FROM config c0_ WHERE c0_.num = ? AND c0_.statut = ?
Parameters:
[ 3 1 ] |
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\ProductCategory | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CategorieBlog | No errors. |
| App\Entity\Config | No errors. |