Query Metrics
4
Database Queries
4
Different statements
5.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.86 ms (32.46%) |
1 |
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.id = ?
Parameters:
[
"10"
]
|
||||||||||||||||||||||||||||
|
1.69 ms (29.44%) |
1 |
SELECT a0_.id AS id_0, a0_.actuality_filename AS actuality_filename_1, a0_.title AS title_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.text AS text_5, a0_.owned_by_id AS owned_by_id_6 FROM actuality a0_ LEFT JOIN actuality_franchise a2_ ON a0_.id = a2_.actuality_id LEFT JOIN franchise f1_ ON f1_.id = a2_.franchise_id WHERE f1_.id IN (?) ORDER BY a0_.id DESC
Parameters:
[
10
]
|
||||||||||||||||||||||||||||
|
1.22 ms (21.34%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.text AS text_2, a0_.rate AS rate_3, a0_.online AS online_4, a0_.is_legal AS is_legal_5, a0_.franchise_id AS franchise_id_6 FROM avis a0_ WHERE a0_.franchise_id = ? AND a0_.online = 1 ORDER BY a0_.id DESC LIMIT 10
Parameters:
[
10
]
|
||||||||||||||||||||||||||||
|
0.96 ms (16.76%) |
1 |
SELECT r0_.id AS id_0, r0_.ville AS ville_1, r0_.realisation_filename AS realisation_filename_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r0_.list AS list_5, r0_.description AS description_6, r0_.title AS title_7, r0_.franchise_id AS franchise_id_8 FROM realisation r0_ WHERE r0_.franchise_id = ? ORDER BY r0_.id DESC
Parameters:
[
10
]
|
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\Franchise | No errors. |
| App\Entity\Avis | No errors. |
| App\Entity\Realisation | No errors. |
| App\Entity\Cities | No errors. |
| App\Entity\ContactWebsitePro | No errors. |
| App\Entity\Actuality | No errors. |
| App\Entity\DevisWebsite | No errors. |
| App\Entity\User | No errors. |
| App\Entity\PicturesRealisation | No errors. |