Query Metrics
32
Database Queries
21
Different statements
14.72 ms
Query time
1
Invalid entities
72
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.79 ms (18.94%) |
9 |
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[] |
|
1.41 ms (9.56%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.categorie_id WHERE produit_categorie.produit_id = ?
Parameters:
[
4
]
|
|
0.83 ms (5.64%) |
1 |
SELECT p0_.id AS id_0, SUM(o1_.product_quantity) AS sclr_1, SUM(o1_.subtotal_ht) AS sclr_2, SUM(o1_.sub_total_ttc) AS sclr_3 FROM order_details o1_ INNER JOIN produit p0_ ON o1_.produit_id = p0_.id INNER JOIN orders o2_ ON o1_.orders_id = o2_.id WHERE o2_.is_paid = ? GROUP BY p0_.id ORDER BY sclr_1 DESC LIMIT 3
Parameters:
[
1
]
|
|
0.79 ms (5.34%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.77 ms (5.26%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.prix AS prix_2, p0_.description AS description_3, p0_.nouveaute AS nouveaute_4, p0_.promotion AS promotion_5, p0_.actif AS actif_6, p0_.banniere AS banniere_7, p0_.slug AS slug_8, p0_.meta_titre AS meta_titre_9, p0_.meta_description AS meta_description_10, p0_.prix_ttc AS prix_ttc_11, p0_.cout_fournisseur AS cout_fournisseur_12, p0_.quantite AS quantite_13, p0_.reference AS reference_14, p0_.resume AS resume_15, p0_.caracteristiques AS caracteristiques_16, p0_.aliexpress_product_id AS aliexpress_product_id_17, p0_.aliexpress_product_url AS aliexpress_product_url_18, p0_.aliexpress_imported_at AS aliexpress_imported_at_19, p0_.updated_at AS updated_at_20, p0_.created_at AS created_at_21, p0_.marque_id AS marque_id_22, p0_.fournisseur_id AS fournisseur_id_23 FROM produit p0_ WHERE p0_.actif = 1 AND (p0_.nouveaute = 1 OR p0_.promotion IS NOT NULL)
Parameters:
[] |
|
0.76 ms (5.17%) |
2 |
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.button_contact AS button_contact_4, t0.ville_opti AS ville_opti_5, t0.meta_titre_produit AS meta_titre_produit_6, t0.meta_desc_produit AS meta_desc_produit_7, t0.meta_titre_vehicule AS meta_titre_vehicule_8, t0.meta_desc_vehicule AS meta_desc_vehicule_9, t0.noindex AS noindex_10, t0.redirections AS redirections_11, t0.banniere_accueil AS banniere_accueil_12, t0.banniere_interieur AS banniere_interieur_13, t0.stripe_secrete_dev AS stripe_secrete_dev_14, t0.stripe_live_dev AS stripe_live_dev_15, t0.stripe_secrete_prod AS stripe_secrete_prod_16, t0.stripe_live_prod AS stripe_live_prod_17, t0.paypal_client_id AS paypal_client_id_18, t0.paypal_secret_key AS paypal_secret_key_19, t0.paypal_test_mod AS paypal_test_mod_20, t0.paiement AS paiement_21, t0.paypal AS paypal_22, t0.stripe AS stripe_23, t0.aliexpress_enabled AS aliexpress_enabled_24, t0.aliexpress_api_base_url AS aliexpress_api_base_url_25, t0.aliexpress_app_key AS aliexpress_app_key_26, t0.aliexpress_app_secret AS aliexpress_app_secret_27, t0.aliexpress_access_token AS aliexpress_access_token_28, t0.aliexpress_tracking_id AS aliexpress_tracking_id_29 FROM config t0 LIMIT 1
Parameters:
[] |
|
0.73 ms (4.96%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.prix AS prix_3, p0_.description AS description_4, p0_.equipements AS equipements_5, p0_.modele AS modele_6, p0_.finition AS finition_7, p0_.carburant AS carburant_8, p0_.boite AS boite_9, p0_.kilometrage AS kilometrage_10, p0_.millesime AS millesime_11, p0_.circulation AS circulation_12, p0_.couleur AS couleur_13, p0_.garantie AS garantie_14, p0_.etat_vehicule AS etat_vehicule_15, p0_.emission AS emission_16, p0_.puissance AS puissance_17, p0_.fiscale AS fiscale_18, p0_.carroserie AS carroserie_19, p0_.portes AS portes_20, p0_.places AS places_21, p0_.nouveaute AS nouveaute_22, p0_.promotion AS promotion_23, p0_.actif AS actif_24, p0_.vendu AS vendu_25, p0_.meta_titre AS meta_titre_26, p0_.meta_description AS meta_description_27, p0_.updated_at AS updated_at_28, p0_.created_at AS created_at_29, c1_.id AS id_30, c1_.name AS name_31, c1_.lft AS lft_32, c1_.lvl AS lvl_33, c1_.rgt AS rgt_34, c1_.ordre AS ordre_35, c1_.afficher AS afficher_36, c1_.meta_titre AS meta_titre_37, c1_.meta_description AS meta_description_38, c1_.url AS url_39, c1_.slug AS slug_40, c1_.menu AS menu_41, c1_.updated_at AS updated_at_42, c1_.created_at AS created_at_43, i2_.id AS id_44, i2_.name AS name_45, i2_.created_at AS created_at_46, i2_.updated_at AS updated_at_47, p0_.marque_id AS marque_id_48, c1_.tree_root AS tree_root_49, c1_.parent_id AS parent_id_50, i2_.produit_vehicule_id AS produit_vehicule_id_51 FROM produit_vehicule p0_ LEFT JOIN produit_vehicule_categorie p3_ ON p0_.id = p3_.produit_vehicule_id LEFT JOIN categorie c1_ ON c1_.id = p3_.categorie_id LEFT JOIN image_vehicule i2_ ON p0_.id = i2_.produit_vehicule_id WHERE c1_.url = ? AND p0_.actif = 1
Parameters:
[
"app_index"
]
|
|
0.72 ms (4.90%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.lft AS lft_2, c0_.lvl AS lvl_3, c0_.rgt AS rgt_4, c0_.ordre AS ordre_5, c0_.afficher AS afficher_6, c0_.meta_titre AS meta_titre_7, c0_.meta_description AS meta_description_8, c0_.url AS url_9, c0_.slug AS slug_10, c0_.menu AS menu_11, c0_.updated_at AS updated_at_12, c0_.created_at AS created_at_13, c1_.id AS id_14, c1_.name AS name_15, c1_.meta_titre AS meta_titre_16, c1_.meta_description AS meta_description_17, c1_.url AS url_18, c1_.locale AS locale_19 FROM categorie c0_ LEFT JOIN categorie_translation c1_ ON c0_.id = c1_.translatable_id WHERE c0_.afficher = 1 AND c1_.locale = ? ORDER BY c0_.tree_root ASC, c0_.lft ASC
Parameters:
[
"fr"
]
|
|
0.70 ms (4.75%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 WHERE t0.url = ?
Parameters:
[
"app_index"
]
|
|
0.61 ms (4.14%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.afficher AS afficher_2, m0_.icon AS icon_3, m0_.section AS section_4, m0_.module_name AS module_name_5, m0_.see AS see_6, m0_.new AS new_7, m0_.edit AS edit_8, m0_.remove AS remove_9, m0_.parent AS parent_10 FROM module m0_ ORDER BY m0_.section ASC
Parameters:
[] |
|
0.58 ms (3.94%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.actif AS actif_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.categorie_id AS categorie_id_7 FROM article t0 WHERE t0.categorie_id = ? AND t0.actif = ?
Parameters:
[ 1 1 ] |
|
0.49 ms (3.34%) |
1 |
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.button_contact AS button_contact_4, t0.ville_opti AS ville_opti_5, t0.meta_titre_produit AS meta_titre_produit_6, t0.meta_desc_produit AS meta_desc_produit_7, t0.meta_titre_vehicule AS meta_titre_vehicule_8, t0.meta_desc_vehicule AS meta_desc_vehicule_9, t0.noindex AS noindex_10, t0.redirections AS redirections_11, t0.banniere_accueil AS banniere_accueil_12, t0.banniere_interieur AS banniere_interieur_13, t0.stripe_secrete_dev AS stripe_secrete_dev_14, t0.stripe_live_dev AS stripe_live_dev_15, t0.stripe_secrete_prod AS stripe_secrete_prod_16, t0.stripe_live_prod AS stripe_live_prod_17, t0.paypal_client_id AS paypal_client_id_18, t0.paypal_secret_key AS paypal_secret_key_19, t0.paypal_test_mod AS paypal_test_mod_20, t0.paiement AS paiement_21, t0.paypal AS paypal_22, t0.stripe AS stripe_23, t0.aliexpress_enabled AS aliexpress_enabled_24, t0.aliexpress_api_base_url AS aliexpress_api_base_url_25, t0.aliexpress_app_key AS aliexpress_app_key_26, t0.aliexpress_app_secret AS aliexpress_app_secret_27, t0.aliexpress_access_token AS aliexpress_access_token_28, t0.aliexpress_tracking_id AS aliexpress_tracking_id_29 FROM config t0
Parameters:
[] |
|
0.48 ms (3.29%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.prix AS prix_3, t0.description AS description_4, t0.nouveaute AS nouveaute_5, t0.promotion AS promotion_6, t0.actif AS actif_7, t0.banniere AS banniere_8, t0.slug AS slug_9, t0.meta_titre AS meta_titre_10, t0.meta_description AS meta_description_11, t0.prix_ttc AS prix_ttc_12, t0.cout_fournisseur AS cout_fournisseur_13, t0.quantite AS quantite_14, t0.reference AS reference_15, t0.resume AS resume_16, t0.caracteristiques AS caracteristiques_17, t0.aliexpress_product_id AS aliexpress_product_id_18, t0.aliexpress_product_url AS aliexpress_product_url_19, t0.aliexpress_imported_at AS aliexpress_imported_at_20, t0.updated_at AS updated_at_21, t0.created_at AS created_at_22, t0.marque_id AS marque_id_23, t0.fournisseur_id AS fournisseur_id_24 FROM produit t0 WHERE t0.id IN (?, ?)
Parameters:
[ 4 2 ] |
|
0.48 ms (3.26%) |
1 |
SELECT t0.id AS id_1, t0.name_company AS name_company_2, t0.tel1 AS tel1_3, t0.tel2 AS tel2_4, t0.fax AS fax_5, t0.email AS email_6, t0.adresse AS adresse_7, t0.comp_adresse AS comp_adresse_8, t0.cp AS cp_9, t0.ville AS ville_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.twitter AS twitter_13, t0.linkedin AS linkedin_14, t0.youtube AS youtube_15, t0.snapchat AS snapchat_16, t0.map_url AS map_url_17, t0.iframe AS iframe_18, t0.horaires AS horaires_19, t0.afficher AS afficher_20, t0.image_name AS image_name_21, t0.updated_at AS updated_at_22, t0.created_at AS created_at_23 FROM coordonnees t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.43 ms (2.91%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.actif AS actif_3 FROM lang t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
|
0.40 ms (2.75%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.prix AS prix_3, t0.description AS description_4, t0.nouveaute AS nouveaute_5, t0.promotion AS promotion_6, t0.actif AS actif_7, t0.banniere AS banniere_8, t0.slug AS slug_9, t0.meta_titre AS meta_titre_10, t0.meta_description AS meta_description_11, t0.prix_ttc AS prix_ttc_12, t0.cout_fournisseur AS cout_fournisseur_13, t0.quantite AS quantite_14, t0.reference AS reference_15, t0.resume AS resume_16, t0.caracteristiques AS caracteristiques_17, t0.aliexpress_product_id AS aliexpress_product_id_18, t0.aliexpress_product_url AS aliexpress_product_url_19, t0.aliexpress_imported_at AS aliexpress_imported_at_20, t0.updated_at AS updated_at_21, t0.created_at AS created_at_22, t0.marque_id AS marque_id_23, t0.fournisseur_id AS fournisseur_id_24 FROM produit t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
|
0.38 ms (2.61%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 WHERE t0.afficher = ?
Parameters:
[
1
]
|
|
0.38 ms (2.55%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.actif AS actif_4, t0.ordre AS ordre_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8 FROM galerie_photo t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
|
0.36 ms (2.45%) |
1 |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.content AS content_3, t0.valid AS valid_4 FROM maintenance t0 LIMIT 1
Parameters:
[] |
|
0.35 ms (2.38%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_titre AS meta_titre_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM categorie_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.27 ms (1.85%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5 FROM marque t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| customer | doctrine.dbal.customer_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| customer | doctrine.orm.customer_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Module | 48 |
| App\Entity\Image | 11 |
| App\Entity\Produit | 3 |
| App\Entity\Categorie | 2 |
| App\Entity\SectionImage | 2 |
| App\Entity\Marque | 1 |
| App\Entity\Fournisseur | 1 |
| App\Entity\Config | 1 |
| App\Entity\Translation\CategorieTranslation | 1 |
| App\Entity\Coordonnees | 1 |
| App\Entity\Lang | 1 |
customer entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
customer entity manager
No loaded entities.