GET https://preprod.reseauglass.fr/api/folder/20804/sidexa-status

Query Metrics

5 Database Queries
5 Different statements
13.22 ms Query time
1 Invalid entities
10 Managed entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 4.08 ms
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.rf_access_token AS rf_access_token_18, t0.rf_refresh_token AS rf_refresh_token_19, t0.service_id AS service_id_20, t0.notif_configuration_id AS notif_configuration_id_21, t0.mail_configuration_id AS mail_configuration_id_22 FROM admin t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "poseuradmin@reseauglass.fr"
]
2 5.15 ms
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:
[
  "20804"
]
3 1.16 ms
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
]
4 2.15 ms
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:
[
  20804
  "BX-815-DT"
]
5 0.69 ms
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.folder_id = ?
Parameters:
[
  20804
]

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 2
App\Entity\Company 2
App\Entity\Folder 1
App\Entity\Customer 1
App\Entity\Technician 1
App\Entity\Status 1
App\Entity\UserCompany 1
App\Entity\Jeton 1

Entities Mapping

Class Mapping errors
App\Entity\Admin No errors.
App\Entity\AgentService No errors.
App\Entity\Configuration No errors.
App\Entity\Folder No errors.
App\Entity\Jeton No errors.
App\Entity\Task No errors.
App\Entity\Stock No errors.
App\Entity\Recovery No errors.
App\Entity\Company
  • The field App\Entity\Company#subscription is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Subscription#company does not contain the required 'inversedBy: "subscription"' attribute.
App\Entity\HistoryActionAgent No errors.
App\Entity\Message No errors.
App\Entity\ContactAccessLog No errors.
App\Entity\Technician No errors.
App\Entity\UserCompany No errors.
App\Entity\InfoGlobalRead No errors.
App\Entity\InfoGLobalHistory No errors.
App\Entity\Customer No errors.
App\Entity\Status No errors.
App\Entity\Known No errors.
App\Entity\Comment No errors.
App\Entity\Relance No errors.
App\Entity\Document No errors.
App\Entity\Invoice No errors.
App\Entity\Quotation No errors.
App\Entity\PurchaseOrder No errors.
App\Entity\Expense No errors.
App\Entity\FolderUploadLink No errors.
App\Entity\RepairOrderProduct No errors.
App\Entity\MissedDocument No errors.
App\Entity\Payment No errors.