Query Metrics
4
Database Queries
3
Different statements
0.92 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.40 ms (42.94%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.validity AS validity_3, t0.location AS location_4, t0.category AS category_5, t0.link AS link_6, t0.file_pub AS file_pub_7, t0.file_size AS file_size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expireted_at AS expireted_at_11, t0.back_link AS back_link_12 FROM pub t0 WHERE t0.location = ?
Parameters:
[
"Entéte du site"
]
|
||||||||||||||||||||||||||||||
|
0.34 ms (36.66%) |
1 |
SELECT a0_.id AS id_0, a0_.categorie AS categorie_1, a0_.nom_an AS nom_an_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.logo AS logo_5, a0_.image_size AS image_size_6, a0_.email AS email_7, a0_.address AS address_8, a0_.website AS website_9, a0_.updated_at AS updated_at_10, a0_.statut AS statut_11, a0_.date_abonnement AS date_abonnement_12, a0_.date_expiration AS date_expiration_13, a0_.validity AS validity_14, u1_.id AS id_15, u1_.email AS email_16, u1_.roles AS roles_17, u1_.password AS password_18, u1_.type_compte AS type_compte_19, u1_.is_verified AS is_verified_20, u1_.tel AS tel_21, u1_.approve AS approve_22, u1_.facebook_id AS facebook_id_23, u1_.is_super_admin AS is_super_admin_24, u1_.facebook AS facebook_25, u1_.twitter AS twitter_26, u1_.instagram AS instagram_27, u1_.linkedin AS linkedin_28, u1_.youtube AS youtube_29, u1_.whatsapp AS whatsapp_30, u1_.pinterest AS pinterest_31, u1_.facebook_access_token AS facebook_access_token_32, u1_.twitter_id AS twitter_id_33, u1_.twitter_access_token AS twitter_access_token_34, u1_.google_id AS google_id_35, u1_.google_access_token AS google_access_token_36, p2_.logo AS logo_37, p2_.nom_professionel AS nom_professionel_38, p2_.addresse AS addresse_39, p2_.marques AS marques_40, p2_.website AS website_41, p2_.image_size AS image_size_42, p2_.updated_at AS updated_at_43, p2_.description AS description_44, a3_.id AS id_45, a3_.category AS category_46, a3_.marques AS marques_47, a3_.modeles AS modeles_48, a3_.etats AS etats_49, a3_.carosseries AS carosseries_50, a3_.year AS year_51, a3_.kilometrage AS kilometrage_52, a3_.carburants AS carburants_53, a3_.transmission AS transmission_54, a3_.moteur AS moteur_55, a3_.entrainement AS entrainement_56, a3_.couleur_ext AS couleur_ext_57, a3_.couleur_int AS couleur_int_58, a3_.numero_chassis AS numero_chassis_59, a3_.consommationville AS consommationville_60, a3_.consommation_route AS consommation_route_61, a3_.carosserie_equip AS carosserie_equip_62, a3_.transmission_equip AS transmission_equip_63, a3_.interieur_equip AS interieur_equip_64, a3_.exterieur_equip AS exterieur_equip_65, a3_.electronique_equip AS electronique_equip_66, a3_.dispo_securite AS dispo_securite_67, a3_.videos AS videos_68, a3_.price AS price_69, a3_.description AS description_70, a3_.descriptionadd AS descriptionadd_71, a3_.specificationtechniques AS specificationtechniques_72, a3_.infosgenerales AS infosgenerales_73, a3_.brochure_filename AS brochure_filename_74, a3_.brochure_size AS brochure_size_75, a3_.created_at AS created_at_76, a3_.updated_at AS updated_at_77, a3_.device AS device_78, a3_.regions AS regions_79, a3_.villes AS villes_80, a3_.communes AS communes_81, a3_.address AS address_82, a3_.type AS type_83, a3_.urgent AS urgent_84, a3_.nbrcylindre AS nbrcylindre_85, a3_.numero_enregistrement AS numero_enregistrement_86, a3_.is_favoris AS is_favoris_87, a3_.has_co2 AS has_co2_88, a3_.export_price AS export_price_89, a3_.bargan_price AS bargan_price_90, a3_.is_active AS is_active_91, a3_.int_moto AS int_moto_92, a3_.electro_moto AS electro_moto_93, a3_.disposec_moto AS disposec_moto_94, a3_.dispconf_moto AS dispconf_moto_95, a3_.lon AS lon_96, a3_.lat AS lat_97, a3_.duration AS duration_98, a3_.comments AS comments_99, a3_.note AS note_100, a3_.is_compared AS is_compared_101, a0_.user_an_id AS user_an_id_102, u1_.compte AS compte_103, a3_.user_id AS user_id_104 FROM annuaire a0_ LEFT JOIN professionel p2_ ON a0_.user_an_id = p2_.id LEFT JOIN user u1_ ON p2_.id = u1_.id LEFT JOIN annonce a3_ ON u1_.id = a3_.user_id WHERE a0_.categorie = ? ORDER BY a0_.id DESC
Parameters:
[
"Crédit Automobile"
]
|
||||||||||||||||||||||||||||||
|
0.19 ms (20.40%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.image_pub AS image_pub_2, p0_.created_at AS created_at_3, p0_.image_size AS image_size_4, p0_.updated_at AS updated_at_5, p0_.description AS description_6, p0_.admin_id AS admin_id_7 FROM pub_infos p0_ ORDER BY p0_.id DESC LIMIT 3
Parameters:
[]
|
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\Annuaire | No errors. |
| App\Entity\User |
|
| App\Entity\Professionel |
|
| App\Entity\Annonce | No errors. |
| App\Entity\PubInfos | No errors. |
| App\Entity\Admin |
|
| App\Entity\Pub | No errors. |