Query Metrics
14
Database Queries
6
Different statements
7.84 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
| 2 | 0.74 ms |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 143852 "Two tone special - Burgundy with blade silver roof" 954.17 ] |
| 3 | 0.26 ms |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 134938 "Synthetic leather - Black" 0.0 ] |
| 4 | 0.34 ms |
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" ] |
| 5 | 0.26 ms |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 143715 "Blade silver door mirrors" 0.0 ] |
| 6 | 0.24 ms |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 143718 "Shark fin roof antenna in Fuji sunset red" 0.0 ] |
| 7 | 0.23 ms |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 85414 "17" Two tone alloy wheels" 0.0 ] |
| 8 | 0.26 ms |
INSERT INTO vehicle_extra (option_id, option_name, option_price) VALUES (?, ?, ?)
Parameters:
[ 4421 "Space saver spare wheel" 108.33 ] |
| 9 | 0.43 ms |
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 ] |
| 10 | 0.27 ms |
INSERT INTO vehicle_vehicle_extra (vehicle_id, vehicle_extra_id) VALUES (?, ?)
Parameters:
[ 388 "2085" ] |
| 11 | 0.25 ms |
INSERT INTO vehicle_vehicle_extra (vehicle_id, vehicle_extra_id) VALUES (?, ?)
Parameters:
[ 388 "2086" ] |
| 12 | 0.22 ms |
INSERT INTO vehicle_vehicle_extra (vehicle_id, vehicle_extra_id) VALUES (?, ?)
Parameters:
[ 388 "2087" ] |
| 13 | 0.21 ms |
INSERT INTO vehicle_vehicle_extra (vehicle_id, vehicle_extra_id) VALUES (?, ?)
Parameters:
[ 388 "2088" ] |
| 14 | 3.90 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.
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. |