GET https://sn-topauto.com/en/annuaires/pro/Auto%20Ecole

Response
200 OK
IP
216.73.216.162
Profiled on
Token
bc3c12

Query Metrics

21 Database Queries
4 Different statements
3.60 ms Query time
3 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.49 ms 
SELECT a0_.id AS id_0, t1_.content AS categorie_1, t2_.content AS nom_an_2, t3_.content AS description_3, t4_.content 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, t5_.content 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, u6_.id AS id_15, u6_.email AS email_16, u6_.roles AS roles_17, u6_.password AS password_18, t7_.content AS type_compte_19, u6_.is_verified AS is_verified_20, t8_.content AS tel_21, u6_.approve AS approve_22, u6_.facebook_id AS facebook_id_23, u6_.is_super_admin AS is_super_admin_24, u6_.facebook AS facebook_25, u6_.twitter AS twitter_26, u6_.instagram AS instagram_27, u6_.linkedin AS linkedin_28, u6_.youtube AS youtube_29, u6_.whatsapp AS whatsapp_30, u6_.pinterest AS pinterest_31, u6_.facebook_access_token AS facebook_access_token_32, u6_.twitter_id AS twitter_id_33, u6_.twitter_access_token AS twitter_access_token_34, u6_.google_id AS google_id_35, u6_.google_access_token AS google_access_token_36, p36_.logo AS logo_37, p36_.nom_professionel AS nom_professionel_38, p36_.addresse AS addresse_39, p36_.marques AS marques_40, p36_.website AS website_41, p36_.image_size AS image_size_42, p36_.updated_at AS updated_at_43, p36_.description AS description_44, a9_.id AS id_45, t10_.content AS category_46, t11_.content AS marques_47, t12_.content AS modeles_48, t13_.content AS etats_49, t14_.content AS carosseries_50, a9_.year AS year_51, t15_.content AS kilometrage_52, t16_.content AS carburants_53, t17_.content AS transmission_54, t18_.content AS moteur_55, t19_.content AS entrainement_56, t20_.content AS couleur_ext_57, t21_.content AS couleur_int_58, a9_.numero_chassis AS numero_chassis_59, t22_.content AS consommationville_60, t23_.content AS consommation_route_61, t24_.content AS carosserie_equip_62, t25_.content AS transmission_equip_63, t26_.content AS interieur_equip_64, t27_.content AS exterieur_equip_65, t28_.content AS electronique_equip_66, a9_.dispo_securite AS dispo_securite_67, a9_.videos AS videos_68, t29_.content AS price_69, t30_.content AS description_70, t31_.content AS descriptionadd_71, t32_.content AS specificationtechniques_72, t33_.content AS infosgenerales_73, a9_.brochure_filename AS brochure_filename_74, a9_.brochure_size AS brochure_size_75, t34_.content AS created_at_76, t35_.content AS updated_at_77, a9_.device AS device_78, a9_.regions AS regions_79, a9_.villes AS villes_80, a9_.communes AS communes_81, a9_.address AS address_82, a9_.type AS type_83, a9_.urgent AS urgent_84, a9_.nbrcylindre AS nbrcylindre_85, a9_.numero_enregistrement AS numero_enregistrement_86, a9_.is_favoris AS is_favoris_87, a9_.has_co2 AS has_co2_88, a9_.export_price AS export_price_89, a9_.bargan_price AS bargan_price_90, a9_.is_active AS is_active_91, a9_.int_moto AS int_moto_92, a9_.electro_moto AS electro_moto_93, a9_.disposec_moto AS disposec_moto_94, a9_.dispconf_moto AS dispconf_moto_95, a9_.lon AS lon_96, a9_.lat AS lat_97, a9_.duration AS duration_98, a9_.comments AS comments_99, a9_.note AS note_100, a9_.is_compared AS is_compared_101, a0_.user_an_id AS user_an_id_102, u6_.compte AS compte_103, a9_.user_id AS user_id_104 FROM annuaire a0_ LEFT JOIN professionel p36_ ON a0_.user_an_id = p36_.id LEFT JOIN user u6_ ON p36_.id = u6_.id LEFT JOIN annonce a9_ ON u6_.id = a9_.user_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'categorie' AND t1_.object_class = 'App\\Entity\\Annuaire' AND t1_.foreign_key = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'nomAn' AND t2_.object_class = 'App\\Entity\\Annuaire' AND t2_.foreign_key = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'App\\Entity\\Annuaire' AND t3_.foreign_key = a0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'created_At' AND t4_.object_class = 'App\\Entity\\Annuaire' AND t4_.foreign_key = a0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'updated_At' AND t5_.object_class = 'App\\Entity\\Annuaire' AND t5_.foreign_key = a0_.id LEFT JOIN ext_translations t7_ ON t7_.locale = 'en' AND t7_.field = 'typeCompte' AND t7_.object_class = 'App\\Entity\\User' AND t7_.foreign_key = u6_.id LEFT JOIN ext_translations t8_ ON t8_.locale = 'en' AND t8_.field = 'tel' AND t8_.object_class = 'App\\Entity\\User' AND t8_.foreign_key = u6_.id LEFT JOIN ext_translations t10_ ON t10_.locale = 'en' AND t10_.field = 'category' AND t10_.object_class = 'App\\Entity\\Annonce' AND t10_.foreign_key = a9_.id LEFT JOIN ext_translations t11_ ON t11_.locale = 'en' AND t11_.field = 'marques' AND t11_.object_class = 'App\\Entity\\Annonce' AND t11_.foreign_key = a9_.id LEFT JOIN ext_translations t12_ ON t12_.locale = 'en' AND t12_.field = 'modeles' AND t12_.object_class = 'App\\Entity\\Annonce' AND t12_.foreign_key = a9_.id LEFT JOIN ext_translations t13_ ON t13_.locale = 'en' AND t13_.field = 'etats' AND t13_.object_class = 'App\\Entity\\Annonce' AND t13_.foreign_key = a9_.id LEFT JOIN ext_translations t14_ ON t14_.locale = 'en' AND t14_.field = 'carosseries' AND t14_.object_class = 'App\\Entity\\Annonce' AND t14_.foreign_key = a9_.id LEFT JOIN ext_translations t15_ ON t15_.locale = 'en' AND t15_.field = 'kilometrage' AND t15_.object_class = 'App\\Entity\\Annonce' AND t15_.foreign_key = a9_.id LEFT JOIN ext_translations t16_ ON t16_.locale = 'en' AND t16_.field = 'carburants' AND t16_.object_class = 'App\\Entity\\Annonce' AND t16_.foreign_key = a9_.id LEFT JOIN ext_translations t17_ ON t17_.locale = 'en' AND t17_.field = 'transmission' AND t17_.object_class = 'App\\Entity\\Annonce' AND t17_.foreign_key = a9_.id LEFT JOIN ext_translations t18_ ON t18_.locale = 'en' AND t18_.field = 'moteur' AND t18_.object_class = 'App\\Entity\\Annonce' AND t18_.foreign_key = a9_.id LEFT JOIN ext_translations t19_ ON t19_.locale = 'en' AND t19_.field = 'entrainement' AND t19_.object_class = 'App\\Entity\\Annonce' AND t19_.foreign_key = a9_.id LEFT JOIN ext_translations t20_ ON t20_.locale = 'en' AND t20_.field = 'couleurExt' AND t20_.object_class = 'App\\Entity\\Annonce' AND t20_.foreign_key = a9_.id LEFT JOIN ext_translations t21_ ON t21_.locale = 'en' AND t21_.field = 'couleurInt' AND t21_.object_class = 'App\\Entity\\Annonce' AND t21_.foreign_key = a9_.id LEFT JOIN ext_translations t22_ ON t22_.locale = 'en' AND t22_.field = 'consommationville' AND t22_.object_class = 'App\\Entity\\Annonce' AND t22_.foreign_key = a9_.id LEFT JOIN ext_translations t23_ ON t23_.locale = 'en' AND t23_.field = 'consommationRoute' AND t23_.object_class = 'App\\Entity\\Annonce' AND t23_.foreign_key = a9_.id LEFT JOIN ext_translations t24_ ON t24_.locale = 'en' AND t24_.field = 'carosserieEquip' AND t24_.object_class = 'App\\Entity\\Annonce' AND t24_.foreign_key = a9_.id LEFT JOIN ext_translations t25_ ON t25_.locale = 'en' AND t25_.field = 'transmissionEquip' AND t25_.object_class = 'App\\Entity\\Annonce' AND t25_.foreign_key = a9_.id LEFT JOIN ext_translations t26_ ON t26_.locale = 'en' AND t26_.field = 'InterieurEquip' AND t26_.object_class = 'App\\Entity\\Annonce' AND t26_.foreign_key = a9_.id LEFT JOIN ext_translations t27_ ON t27_.locale = 'en' AND t27_.field = 'exterieurEquip' AND t27_.object_class = 'App\\Entity\\Annonce' AND t27_.foreign_key = a9_.id LEFT JOIN ext_translations t28_ ON t28_.locale = 'en' AND t28_.field = 'electroniqueEquip' AND t28_.object_class = 'App\\Entity\\Annonce' AND t28_.foreign_key = a9_.id LEFT JOIN ext_translations t29_ ON t29_.locale = 'en' AND t29_.field = 'price' AND t29_.object_class = 'App\\Entity\\Annonce' AND t29_.foreign_key = a9_.id LEFT JOIN ext_translations t30_ ON t30_.locale = 'en' AND t30_.field = 'description' AND t30_.object_class = 'App\\Entity\\Annonce' AND t30_.foreign_key = a9_.id LEFT JOIN ext_translations t31_ ON t31_.locale = 'en' AND t31_.field = 'descriptionadd' AND t31_.object_class = 'App\\Entity\\Annonce' AND t31_.foreign_key = a9_.id LEFT JOIN ext_translations t32_ ON t32_.locale = 'en' AND t32_.field = 'specificationtechniques' AND t32_.object_class = 'App\\Entity\\Annonce' AND t32_.foreign_key = a9_.id LEFT JOIN ext_translations t33_ ON t33_.locale = 'en' AND t33_.field = 'infosgenerales' AND t33_.object_class = 'App\\Entity\\Annonce' AND t33_.foreign_key = a9_.id LEFT JOIN ext_translations t34_ ON t34_.locale = 'en' AND t34_.field = 'created_At' AND t34_.object_class = 'App\\Entity\\Annonce' AND t34_.foreign_key = a9_.id LEFT JOIN ext_translations t35_ ON t35_.locale = 'en' AND t35_.field = 'updated_At' AND t35_.object_class = 'App\\Entity\\Annonce' AND t35_.foreign_key = a9_.id WHERE t1_.content = ? ORDER BY a0_.id DESC
Parameters: 
[
  "Auto Ecole"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.18 ms 
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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.20 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "4"
  "en"
  "App\Entity\PubInfos"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.15 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "3"
  "en"
  "App\Entity\PubInfos"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.43 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "2"
  "en"
  "App\Entity\PubInfos"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.16 ms 
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"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.14 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "1"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "2"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.14 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "15"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "23"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "24"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "25"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.14 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "26"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "27"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "28"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "29"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "30"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "31"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.14 ms 
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: 
[
  "Bannière Annuaire Pro"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "18"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.13 ms 
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters: 
[
  "19"
  "en"
  "App\Entity\Pub"
]
View formatted query    View runnable query    Explain query    View query backtrace

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
  • The association App\Entity\User#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Professionel
  • The association App\Entity\Professionel#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
  • The mappings App\Entity\Professionel#artilces and App\Entity\Article#professionel are inconsistent with each other.
App\Entity\Annonce No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\PubInfos No errors.
App\Entity\Admin
  • The association App\Entity\Admin#boutiques refers to the owning side field App\Entity\Boutique#userId which does not exist.
App\Entity\Pub No errors.