Query Metrics
3
Database Queries
2
Different statements
13.35 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 7.98 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.profile_filename AS profile_filename_3, f0_.departement AS departement_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.secteur AS secteur_7, f0_.mail AS mail_8, f0_.phone AS phone_9, f0_.fiche_google AS fiche_google_10, f0_.services AS services_11, f0_.siret AS siret_12, f0_.seo_title AS seo_title_13, f0_.seo_content AS seo_content_14, f0_.is_ads_word AS is_ads_word_15, f0_.title_home_site AS title_home_site_16, f0_.subdomain AS subdomain_17, f0_.presentation AS presentation_18, f0_.title_service AS title_service_19, f0_.description_service AS description_service_20, f0_.title_service_2 AS title_service_2_21, f0_.description_service_2 AS description_service_2_22, f0_.home_filename AS home_filename_23 FROM franchise f0_ LEFT JOIN franchise_cities f2_ ON f0_.id = f2_.franchise_id LEFT JOIN cities c1_ ON c1_.id = f2_.cities_id WHERE f0_.mail <> ? ORDER BY f0_.created_at DESC
Parameters:
[
"t.belorgeot@beescom.fr"
]
|
||||||||||||||||||||||||||||
| 2 | 4.77 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.profile_filename AS profile_filename_3, f0_.departement AS departement_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.secteur AS secteur_7, f0_.mail AS mail_8, f0_.phone AS phone_9, f0_.fiche_google AS fiche_google_10, f0_.services AS services_11, f0_.siret AS siret_12, f0_.seo_title AS seo_title_13, f0_.seo_content AS seo_content_14, f0_.is_ads_word AS is_ads_word_15, f0_.title_home_site AS title_home_site_16, f0_.subdomain AS subdomain_17, f0_.presentation AS presentation_18, f0_.title_service AS title_service_19, f0_.description_service AS description_service_20, f0_.title_service_2 AS title_service_2_21, f0_.description_service_2 AS description_service_2_22, f0_.home_filename AS home_filename_23 FROM franchise f0_ LEFT JOIN franchise_cities f2_ ON f0_.id = f2_.franchise_id LEFT JOIN cities c1_ ON c1_.id = f2_.cities_id WHERE f0_.mail <> ? ORDER BY f0_.created_at DESC
Parameters:
[
"t.belorgeot@beescom.fr"
]
|
||||||||||||||||||||||||||||
| 3 | 0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.profile_filename AS profile_filename_4, t0.departement AS departement_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.secteur AS secteur_8, t0.mail AS mail_9, t0.phone AS phone_10, t0.fiche_google AS fiche_google_11, t0.services AS services_12, t0.siret AS siret_13, t0.seo_title AS seo_title_14, t0.seo_content AS seo_content_15, t0.is_ads_word AS is_ads_word_16, t0.title_home_site AS title_home_site_17, t0.subdomain AS subdomain_18, t0.presentation AS presentation_19, t0.title_service AS title_service_20, t0.description_service AS description_service_21, t0.title_service_2 AS title_service_2_22, t0.description_service_2 AS description_service_2_23, t0.home_filename AS home_filename_24 FROM franchise t0 WHERE t0.mail = ? LIMIT 1
Parameters:
[
"francis.moreau@abeille-verte.fr"
]
|
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\Cities | No errors. |
| App\Entity\Franchise | No errors. |
| App\Entity\Avis | No errors. |
| App\Entity\Realisation | No errors. |
| App\Entity\ContactWebsitePro | No errors. |
| App\Entity\Actuality | No errors. |
| App\Entity\DevisWebsite | No errors. |