Query Metrics

5 Database Queries
5 Different statements
3.79 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.60 ms
SELECT t0.id AS id_1, t0.civility AS civility_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.status AS status_8, t0.latest_login AS latest_login_9, t0.avatar AS avatar_10, t0.credit_balance AS credit_balance_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t14.id AS id_15, t14.siret AS siret_16, t14.entreprise_name AS entreprise_name_17, t14.about_me AS about_me_18, t14.birthday AS birthday_19, t14.birthplace AS birthplace_20, t14.mobile_phone AS mobile_phone_21, t14.landline_phone AS landline_phone_22, t14.address AS address_23, t14.address1 AS address1_24, t14.postal_code AS postal_code_25, t14.city AS city_26, t14.longitude AS longitude_27, t14.latitude AS latitude_28, t14.facebook AS facebook_29, t14.twitter AS twitter_30, t14.instagram AS instagram_31, t14.linkedin AS linkedin_32, t14.agree_terms AS agree_terms_33, t14.user_id AS user_id_34, t35.id AS id_36, t35.about_us AS about_us_37, t35.siret AS siret_38, t35.social_denomination AS social_denomination_39, t35.tva AS tva_40, t35.type_personne AS type_personne_41, t35.other_function AS other_function_42, t35.birthday AS birthday_43, t35.birthplace AS birthplace_44, t35.mobile_phone AS mobile_phone_45, t35.landline_phone AS landline_phone_46, t35.address AS address_47, t35.address1 AS address1_48, t35.postal_code AS postal_code_49, t35.city AS city_50, t35.longitude AS longitude_51, t35.latitude AS latitude_52, t35.cover AS cover_53, t35.confirmation_token AS confirmation_token_54, t35.confirmation_token_created_at AS confirmation_token_created_at_55, t35.expiration_token AS expiration_token_56, t35.agree_terms AS agree_terms_57, t35.user_id AS user_id_58, t35.country_id AS country_id_59, t35.piece_justificative_id AS piece_justificative_id_60, t35.department_id AS department_id_61, t62.id AS id_63, t62.carte_id AS carte_id_64, t62.registration_number AS registration_number_65, t62.carte_vitale AS carte_vitale_66, t62.nationality AS nationality_67, t62.family_situation AS family_situation_68, t62.function_type AS function_type_69, t62.service AS service_70, t62.salaire_brute AS salaire_brute_71, t62.horaires AS horaires_72, t62.hourly_rate AS hourly_rate_73, t62.contract_type AS contract_type_74, t62.employement_start AS employement_start_75, t62.language AS language_76, t62.cover AS cover_77, t62.token AS token_78, t62.confirmation_token AS confirmation_token_79, t62.expiration_token AS expiration_token_80, t62.agree_terms AS agree_terms_81, t62.code AS code_82, t62.user_id AS user_id_83, t62.client_id AS client_id_84, t62.park_id AS park_id_85, t62.fonction_id AS fonction_id_86 FROM user t0 LEFT JOIN client t14 ON t14.user_id = t0.id LEFT JOIN transporteur t35 ON t35.user_id = t0.id LEFT JOIN collaborateur t62 ON t62.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
2 1.02 ms
SELECT t0.id AS id_1, t0.carte_id AS carte_id_2, t0.registration_number AS registration_number_3, t0.carte_vitale AS carte_vitale_4, t0.nationality AS nationality_5, t0.family_situation AS family_situation_6, t0.function_type AS function_type_7, t0.service AS service_8, t0.salaire_brute AS salaire_brute_9, t0.horaires AS horaires_10, t0.hourly_rate AS hourly_rate_11, t0.contract_type AS contract_type_12, t0.employement_start AS employement_start_13, t0.language AS language_14, t0.cover AS cover_15, t0.token AS token_16, t0.confirmation_token AS confirmation_token_17, t0.expiration_token AS expiration_token_18, t0.agree_terms AS agree_terms_19, t0.code AS code_20, t0.user_id AS user_id_21, t0.client_id AS client_id_22, t0.park_id AS park_id_23, t0.fonction_id AS fonction_id_24 FROM collaborateur t0 WHERE t0.client_id = ?
Parameters:
[
  2
]
3 0.39 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.status AS status_3, t0.description AS description_4, t0.payment_intent_id AS payment_intent_id_5, t0.card_type AS card_type_6, t0.card_number AS card_number_7, t0.created_at AS created_at_8, t0.transaction_type AS transaction_type_9, t0.transaction_number AS transaction_number_10, t0.card_holder AS card_holder_11, t0.card_expiration AS card_expiration_12, t0.user_id AS user_id_13, t14.id AS id_15, t14.invoice_number AS invoice_number_16, t14.status AS status_17, t14.created_at AS created_at_18, t14.credit_transaction_id AS credit_transaction_id_19 FROM credit_transaction t0 LEFT JOIN invoice t14 ON t14.credit_transaction_id = t0.id WHERE t0.user_id = ? ORDER BY t0.id DESC
Parameters:
[
  3
]
4 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.src AS src_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM partner t0 ORDER BY t0.id ASC
Parameters:
[]
5 0.43 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.phone AS phone_5, t0.mail AS mail_6, t0.website AS website_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.youtube AS youtube_11, t0.instagram AS instagram_12, t0.office AS office_13, t0.description AS description_14, t0.working_hours AS working_hours_15, t0.days_open AS days_open_16, t0.hours_open AS hours_open_17, t0.days_close AS days_close_18, t0.hours_close AS hours_close_19, t0.building AS building_20 FROM contact_page t0 ORDER BY t0.id DESC LIMIT 1
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\User
  • The association App\Entity\User#invoices refers to the owning side field App\Entity\Invoice#user which does not exist.
App\Entity\Client No errors.
App\Entity\Transporteur No errors.
App\Entity\Country
  • The association App\Entity\Country#parks refers to the owning side field App\Entity\Park#country which is not defined as association, but as field.
  • The association App\Entity\Country#parks refers to the owning side field App\Entity\Park#country which does not exist.
App\Entity\PieceJustificative No errors.
App\Entity\Department No errors.
App\Entity\Collaborateur No errors.
App\Entity\Park No errors.
App\Entity\Fonction No errors.
App\Entity\Devis No errors.
App\Entity\CreditTransaction No errors.
App\Entity\Invoice No errors.
App\Entity\Partner No errors.
App\Entity\Brand No errors.
App\Entity\VehicleType No errors.
App\Entity\VehicleGroup No errors.
App\Entity\Vehicle No errors.
App\Entity\Acquisition No errors.
App\Entity\Assurance No errors.
App\Entity\ControleTechnique No errors.
App\Entity\ControleTachygraphe No errors.
App\Entity\ControleLimiteurVitesse No errors.
App\Entity\DocumentDriver No errors.
App\Entity\Carburant No errors.
App\Entity\ProfessionalType No errors.
App\Entity\City No errors.
App\Entity\Cin No errors.
App\Entity\Justification No errors.
App\Entity\Service No errors.
App\Entity\DevisLuggage No errors.
App\Entity\DevisTravelReason No errors.
App\Entity\DevisBudget No errors.
App\Entity\DevisEquipment No errors.
App\Entity\DevisVehicleDetails No errors.
App\Entity\DevisAttachment No errors.
App\Entity\Attachment No errors.
App\Entity\LegalNotice No errors.
App\Entity\Homepage No errors.
App\Entity\AboutUs No errors.
App\Entity\ArticleCategory No errors.
App\Entity\Faq No errors.
App\Entity\WhyChooseUs No errors.
App\Entity\Contact No errors.
App\Entity\Team No errors.
App\Entity\Admin No errors.
App\Entity\Subscriber No errors.
App\Entity\Newsletter No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\FaqCategory No errors.
App\Entity\PrivacyPolicy No errors.
App\Entity\SubscriberGroup No errors.
App\Entity\Module No errors.
App\Entity\Article No errors.
App\Entity\ContactPage No errors.
App\Entity\Help No errors.
App\Entity\TermsConditions No errors.
Vich\UploaderBundle\Entity\File No errors.