Query Metrics
15
Database Queries
9
Different statements
11.70 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.85 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.39 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.42 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 0.72 ms |
INSERT INTO credit_transaction (amount, STATUS, description, payment_intent_id, card_type, card_number, created_at, transaction_type, transaction_number, card_holder, card_expiration, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1.0 "succeeded" "Recharge crédit" "pi_3QYwUVFTNbOaE03x1G86eDXE" "visa" "**** **** **** 3155" "2024-12-22 22:15:34" "credit" null "Antonio RABEMANANTSAINA" "12/2034" 3 ] |
| 5 | 2.40 ms |
"COMMIT"
Parameters:
[] |
| 6 | 0.27 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.56 ms |
UPDATE user SET credit_balance = ? WHERE id = ?
Parameters:
[ 38.0004646 3 ] |
| 8 | 0.35 ms |
UPDATE credit_transaction SET transaction_number = ? WHERE id = ?
Parameters:
[ "CB00047" 47 ] |
| 9 | 1.11 ms |
"COMMIT"
Parameters:
[] |
| 10 | 0.28 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 0.61 ms |
INSERT INTO invoice (invoice_number, STATUS, created_at, credit_transaction_id) VALUES (?, ?, ?, ?)
Parameters:
[ null "Paid" "2024-12-22 22:15:34" 47 ] |
| 12 | 1.06 ms |
"COMMIT"
Parameters:
[] |
| 13 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
| 14 | 0.40 ms |
UPDATE invoice SET invoice_number = ? WHERE id = ?
Parameters:
[ "F00043" 43 ] |
| 15 | 1.04 ms |
"COMMIT"
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 |
|
| App\Entity\Client | No errors. |
| App\Entity\Transporteur | No errors. |
| App\Entity\Country |
|
| 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. |