Query Metrics
26
Database Queries
13
Different statements
10.63 ms
Query time
1
Invalid entities
74
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.91 ms |
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, i1_.id AS id_22, i1_.name AS name_23, i1_.updated_at AS updated_at_24, i1_.created_at AS created_at_25, p2_.id AS id_26, p2_.couleur AS couleur_27, p2_.couleur_hex AS couleur_hex_28, p2_.taille AS taille_29, p2_.reference AS reference_30, p2_.prix AS prix_31, p2_.prix_ttc AS prix_ttc_32, p2_.promotion AS promotion_33, p2_.quantite AS quantite_34, p2_.actif AS actif_35, p2_.difference_prix AS difference_prix_36, p2_.sku AS sku_37, p2_.code_barre AS code_barre_38, p2_.poids AS poids_39, p2_.image_name AS image_name_40, p2_.updated_at AS updated_at_41, p2_.created_at AS created_at_42, p0_.marque_id AS marque_id_43, p0_.fournisseur_id AS fournisseur_id_44, i1_.produit_id AS produit_id_45, p2_.produit_id AS produit_id_46 FROM produit p0_ LEFT JOIN produit_categorie p4_ ON p0_.id = p4_.produit_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id LEFT JOIN image_produit i1_ ON p0_.id = i1_.produit_id LEFT JOIN produit_declinaison p2_ ON p0_.id = p2_.produit_id WHERE p0_.actif = 1 AND ((p0_.quantite >= 1 OR (p2_.actif = 1 AND p2_.quantite >= 1)))
Parameters:
[] |
| 2 | 0.70 ms |
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:
[
1
]
|
| 3 | 0.46 ms |
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:
[
2
]
|
| 4 | 0.47 ms |
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
]
|
| 5 | 0.56 ms |
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:
[] |
| 6 | 0.40 ms |
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:
[] |
| 7 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 8 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 9 | 0.30 ms |
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:
[] |
| 10 | 0.26 ms |
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:
[] |
| 11 | 0.27 ms |
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:
[] |
| 12 | 0.35 ms |
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_produits"
]
|
| 13 | 0.45 ms |
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
]
|
| 14 | 0.43 ms |
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:
[] |
| 15 | 0.34 ms |
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_produits"
]
|
| 16 | 0.34 ms |
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:
[] |
| 17 | 0.26 ms |
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:
[] |
| 18 | 0.31 ms |
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:
[] |
| 19 | 0.67 ms |
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"
]
|
| 20 | 0.37 ms |
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
]
|
| 21 | 0.32 ms |
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:
[] |
| 22 | 0.26 ms |
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:
[] |
| 23 | 0.25 ms |
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:
[] |
| 24 | 0.33 ms |
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:
[] |
| 25 | 0.60 ms |
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:
[] |
| 26 | 0.37 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.actif AS actif_3 FROM lang t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
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\ImageProduit | 3 |
| App\Entity\Categorie | 2 |
| App\Entity\SectionImage | 2 |
| App\Entity\Marque | 1 |
| App\Entity\Fournisseur | 1 |
| App\Entity\Config | 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.