https://resoh.fr/client/reload-credit

Query Metrics

2 Database Queries
2 Different statements
2.00 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.49 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 0.51 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
]

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.