Query Metrics
14
Database Queries
6
Different statements
7.84 ms
Query time
0
Invalid entities
8
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.90 ms (49.76%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.99 ms (25.40%) |
6 |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 143852 "Two tone special - Burgundy with blade silver roof" 954.17 ] |
|
0.95 ms (12.06%) |
4 |
INSERT INTO vehicle_vehicle_extra (vehicle_id, vehicle_extra_id) VALUES (?, ?)
Parameters:
[ 388 "2085" ] |
|
0.43 ms (5.53%) |
1 |
INSERT INTO application (uuid, application_type, declined_at, approved_at, created_at, submitted_at, enquiry_source, callback_url, final_declaration, error, submitter_ip_address, initial_disclosure_document_url, brand_phone, brand_email, brand_open_hours, rci_proposal_id, rci_proposal_status, contact_consents_sms, contact_consents_email, contact_consents_post, contact_consents_telephone, eula_consents_initial_disclosure_document, eula_consents_information_notice, eula_consents_terms_and_conditions, eula_consents_privacy_policy, private_individual_id, company_id, partnership_id, sole_trader_id, vehicle_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x1F\x16ZŽu¯o¸…LÃÀ™\x1Fp@" 0 null null "2026-06-11 15:18:46" null 1 null 0 null null "https://rcidemo.mydvs.co.uk/initial-disclosure-document" null null null null null null null null null null null null null null null null null 388 ] |
|
0.34 ms (4.29%) |
1 |
INSERT INTO vehicle (cap_id, cap_code, type, manufacturer_name, model_name, model_short_name, model_year, deal_type, vehicle_name, contract_length, monthly_rate, maintenance_monthly_rate, initial_payment, includes_vat, annual_mileage, processing_fee, dealership_code, product_code, dealer_discount, gross_yearly_road_tax, government_adjustment, color_id, trim_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 100129 "R1CL10EVN5HPTM 7" "car" "Renault" "A3 Saloon" "A3" 2023 "PER" "1.0 DiG-T 114 Tekna 5dr" 48 254.19 null 2287.71 0 6000 165.83 "1895" "C55NJ" null null null "2083" "2084" ] |
|
0.23 ms (2.96%) |
1 |
"START TRANSACTION"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\VehicleExtra | 6 |
| App\Entity\Vehicle | 1 |
| App\Entity\Application | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Vehicle | No errors. |
| App\Entity\VehicleExtra | No errors. |
| App\Entity\External\Rci\Proposal | No errors. |
| App\Entity\ContactConsents | No errors. |
| App\Entity\EulaConsents | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\ApplicationLog | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\PrivateIndividual | No errors. |
| App\Entity\Fleet | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Partnership | No errors. |
| App\Entity\SoleTrader | No errors. |