Query Metrics
5
Database Queries
5
Different statements
12.67 ms
Query time
0
Invalid entities
11
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4.57 ms (36.04%) |
1 |
SELECT t0.id AS id_1, t0.registration AS registration_2, t0.registration_normalized AS registration_normalized_3, t0.vehicle_model AS vehicle_model_4, t0.insurance_name AS insurance_name_5, t0.appointment AS appointment_6, t0.appointment_end AS appointment_end_7, t0.status AS status_8, t0.windscreen AS windscreen_9, t0.insurance_card AS insurance_card_10, t0.vehicle_card AS vehicle_card_11, t0.created_at AS created_at_12, t0.professional AS professional_13, t0.tva_subject AS tva_subject_14, t0.sensor AS sensor_15, t0.athermal AS athermal_16, t0.camera AS camera_17, t0.glass AS glass_18, t0.sinister_date AS sinister_date_19, t0.declare_date AS declare_date_20, t0.sinister_reason AS sinister_reason_21, t0.sinister_circ AS sinister_circ_22, t0.sinister_location AS sinister_location_23, t0.travel_reason AS travel_reason_24, t0.invoice_due AS invoice_due_25, t0.deductible_amount AS deductible_amount_26, t0.verified_deductible AS verified_deductible_27, t0.insurance_number AS insurance_number_28, t0.cca AS cca_29, t0.procedure AS procedure_30, t0.signed AS signed_31, t0.signed_date AS signed_date_32, t0.file AS file_33, t0.known_by AS known_by_34, t0.gift AS gift_35, t0.adresse_pose AS adresse_pose_36, t0.task AS task_37, t0.updated_at AS updated_at_38, t0.relance_at AS relance_at_39, t0.is_paid AS is_paid_40, t0.sinister_number AS sinister_number_41, t0.is_assured AS is_assured_42, t0.is_send_folder AS is_send_folder_43, t0.is_send_invoice AS is_send_invoice_44, t0.cancellation_reason AS cancellation_reason_45, t0.cover AS cover_46, t0.status_command AS status_command_47, t0.ref AS ref_48, t0.ref_client AS ref_client_49, t0.km AS km_50, t0.member_client AS member_client_51, t0.member_garage AS member_garage_52, t0.is_gift_send AS is_gift_send_53, t0.status_updated AS status_updated_54, t0.pattern_cover AS pattern_cover_55, t0.judicial AS judicial_56, t0.relance_updated_at AS relance_updated_at_57, t0.relance_created_at AS relance_created_at_58, t0.relance_after_at AS relance_after_at_59, t0.sms_balance AS sms_balance_60, t0.brand AS brand_61, t0.mine_type AS mine_type_62, t0.serial_number AS serial_number_63, t0.wan_code AS wan_code_64, t0.audatex_code AS audatex_code_65, t0.euro_code AS euro_code_66, t0.vin_identified AS vin_identified_67, t0.sidexa_state AS sidexa_state_68, t0.sidexa_vehicle_model AS sidexa_vehicle_model_69, t0.data_updated AS data_updated_70, t0.category AS category_71, t0.department AS department_72, t0.complexity AS complexity_73, t0.repar AS repar_74, t0.marge AS marge_75, t0.appointment_update_reason AS appointment_update_reason_76, t0.closing_date AS closing_date_77, t0.planif_date AS planif_date_78, t0.gap AS gap_79, t0.offset_pose AS offset_pose_80, t0.duplicate AS duplicate_81, t0.couriers_parent_number AS couriers_parent_number_82, t0.state AS state_83, t0.quiz_sent_folder_submited AS quiz_sent_folder_submited_84, t0.prime_date AS prime_date_85, t0.insurance_card_added_at AS insurance_card_added_at_86, t0.vehicle_card_added_at AS vehicle_card_added_at_87, t0.windscreen_added_at AS windscreen_added_at_88, t0.last_agent_update_at AS last_agent_update_at_89, t0.openai_thread_id AS openai_thread_id_90, t0.vehicle_description AS vehicle_description_91, t0.has_partial_payment AS has_partial_payment_92, t0.paid_gap_amount AS paid_gap_amount_93, t0.gap_declarate_date AS gap_declarate_date_94, t0.hubspot_id AS hubspot_id_95, t0.ht_repair_order AS ht_repair_order_96, t0.task_verif_closed_date AS task_verif_closed_date_97, t0.first_signature_date AS first_signature_date_98, t0.companie_id AS companie_id_99, t0.customer_id AS customer_id_100, t0.gestionnaire_id AS gestionnaire_id_101, t0.created_by AS created_by_102, t0.updated_by AS updated_by_103, t0.technician_id AS technician_id_104, t0.service_client_id AS service_client_id_105, t0.agent_id AS agent_id_106, t0.relanceur_id AS relanceur_id_107, t0.recouvreur_id AS recouvreur_id_108, t0.status_folder_id AS status_folder_id_109, t0.insurance_name_new_id AS insurance_name_new_id_110, t0.recovery_id AS recovery_id_111, t0.known_id AS known_id_112 FROM folder t0 WHERE t0.id = ?
Parameters:
[
"20434"
]
|
||||||||||||||||||||||||||||||
|
4.12 ms (32.51%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"poseuradmin@reseauglass.fr"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (14.29%) |
1 |
SELECT SUM(j0_.consumption) AS sclr_0 FROM jeton j0_ INNER JOIN folder f1_ ON j0_.folder_id = f1_.id WHERE j0_.folder_id = ? AND j0_.option = 3 AND f1_.registration = ?
Parameters:
[ 20434 "Bd-666-qf" ]
|
||||||||||||||||||||||||||||||
|
1.12 ms (8.81%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.hubspot_id AS hubspot_id_4, t0.company_id AS company_id_5, t0.user_id AS user_id_6, t0.known_id AS known_id_7 FROM user_company t0 WHERE t0.user_id = ?
Parameters:
[
637
]
|
||||||||||||||||||||||||||||||
|
1.06 ms (8.35%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.number AS number_3, t0.consumption AS consumption_4, t0.option AS option_5, t0.refund AS refund_6, t0.registration AS registration_7, t0.hubspot_id AS hubspot_id_8, t0.created_by_id AS created_by_id_9, t0.companie_id AS companie_id_10, t0.folder_id AS folder_id_11, t0.quotation_id AS quotation_id_12, t0.payment_id AS payment_id_13 FROM jeton t0 WHERE t0.registration = ? AND t0.option = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "Bd-666-qf" 3 ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Admin | 3 |
| App\Entity\Folder | 1 |
| App\Entity\Company | 1 |
| App\Entity\Customer | 1 |
| App\Entity\Technician | 1 |
| App\Entity\Status | 1 |
| App\Entity\Known | 1 |
| App\Entity\UserCompany | 1 |
| App\Entity\Jeton | 1 |