Query Metrics
29
Database Queries
16
Different statements
15.09 ms
Query time
1
Invalid entities
67
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.61 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.id = ?
Parameters:
[
"2"
]
|
| 2 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.actif AS actif_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.image_name AS image_name_6, t0.categorie_id AS categorie_id_7 FROM categorie_album t0 WHERE t0.categorie_id = ? AND t0.actif = ?
Parameters:
[ "2" 1 ] |
| 3 | 0.85 ms |
SELECT g0_.id AS id_0, g0_.titre AS titre_1, g0_.description AS description_2, g0_.actif AS actif_3, g0_.ordre AS ordre_4, g0_.image_name AS image_name_5, g0_.updated_at AS updated_at_6, g0_.created_at AS created_at_7, g1_.id AS id_8, g1_.name AS name_9, g1_.description AS description_10, g1_.locale AS locale_11, g1_.translatable_id AS translatable_id_12 FROM galerie_photo g0_ LEFT JOIN galerie_photo_categorie g3_ ON g0_.id = g3_.galerie_photo_id LEFT JOIN categorie c2_ ON c2_.id = g3_.categorie_id LEFT JOIN galerie_photo_translation g1_ ON g0_.id = g1_.translatable_id WHERE c2_.id = ? AND g0_.actif = 1 AND g1_.locale = ?
Parameters:
[ "2" "fr" ] |
| 4 | 0.68 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.job AS job_2, e0_.facebook AS facebook_3, e0_.instagram AS instagram_4, e0_.linkedin AS linkedin_5, e0_.youtube AS youtube_6, e0_.email AS email_7, e0_.tel AS tel_8, e0_.ordre AS ordre_9, e0_.updated_at AS updated_at_10, e0_.created_at AS created_at_11, e0_.image_name AS image_name_12 FROM equipe e0_ LEFT JOIN equipe_categorie e2_ ON e0_.id = e2_.equipe_id LEFT JOIN categorie c1_ ON c1_.id = e2_.categorie_id WHERE c1_.id = ? ORDER BY e0_.ordre ASC
Parameters:
[
"2"
]
|
| 5 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.label01 AS label01_4, t0.label02 AS label02_5, t0.label03 AS label03_6, t0.label04 AS label04_7, t0.label05 AS label05_8, t0.valid AS valid_9, t0.ordre AS ordre_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.image_name AS image_name_13, t0.categorie_id AS categorie_id_14 FROM carte t0 WHERE t0.categorie_id = ? AND t0.valid = ? ORDER BY t0.ordre ASC
Parameters:
[ "2" 1 ] |
| 6 | 0.69 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:
[] |
| 7 | 0.52 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:
[] |
| 8 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 9 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 10 | 0.39 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.36 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.37 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:
[] |
| 13 | 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 WHERE t0.id = ?
Parameters:
[
"2"
]
|
| 14 | 0.48 ms |
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:
[
2
]
|
| 15 | 0.62 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
]
|
| 16 | 0.54 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.44 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.id = ?
Parameters:
[
"2"
]
|
| 18 | 0.49 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:
[] |
| 19 | 0.46 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:
[] |
| 20 | 0.38 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:
[] |
| 21 | 0.44 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:
[] |
| 22 | 0.85 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"
]
|
| 23 | 0.45 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
]
|
| 24 | 0.39 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.39 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:
[] |
| 26 | 0.34 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:
[] |
| 27 | 0.41 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:
[] |
| 28 | 0.93 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:
[] |
| 29 | 0.49 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\Categorie | 2 |
| App\Entity\SectionImage | 2 |
| 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
| Class | Mapping errors |
|---|---|
| App\Entity\Categorie | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Sommaires | No errors. |
| App\Entity\Sommaire | No errors. |
| App\Entity\GaleriePhoto | No errors. |
| App\Entity\CategorieAlbum | No errors. |
| App\Entity\ProduitVehicule | No errors. |
| App\Entity\VilleRef | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\Banniere |
|
| App\Entity\Equipe | No errors. |
| App\Entity\Carte | No errors. |
| App\Entity\Translation\CategorieTranslation | No errors. |
| App\Entity\Translation\GaleriePhotoTranslation | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\SectionImage | No errors. |
| App\Entity\Coordonnees | No errors. |
| App\Entity\Maintenance | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\Lang | No errors. |
customer entity manager
No loaded entities.