Query Metrics
5
Database Queries
5
Different statements
3.95 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.95 ms (24.03%) |
1 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.price AS price_3, t0.date_created AS date_created_4, t0.basic_premium AS basic_premium_5, t0.documentary_stamp_tax AS documentary_stamp_tax_6, t0.expanded_value_added_tax AS expanded_value_added_tax_7, t0.local_government_tax AS local_government_tax_8, t0.coc_verification_facility_fee AS coc_verification_facility_fee_9, t0.bayad_center_fee AS bayad_center_fee_10, t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11, t0.insurance_provider_id AS insurance_provider_id_12, t0.vehicle_category_id AS vehicle_category_id_13 FROM ctpl_package t0 WHERE t0.is_active = ? AND t0.vehicle_category_id = ? AND t0.insurance_provider_id = ? LIMIT 1
Parameters:
[ 1 b"\x01æ\t9ó░¿æı{ø\x1Cfì24" b"\x01‘\t9¢í;L¨úõÔ/\x1A.*" ] |
|
0.85 ms (21.42%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.type AS type_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.status AS status_8, t0.date_created AS date_created_9, t0.logo_filename AS logo_filename_10, t0.inspection_duration AS inspection_duration_11, t0.with_onsite_lto AS with_onsite_lto_12, t0.max_booking_per_time_slot AS max_booking_per_time_slot_13, t0.max_booking_per_day AS max_booking_per_day_14, t0.is_activated AS is_activated_15, t0.city_id AS city_id_16 FROM inspection_center t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"pmvic-test"
]
|
|
0.82 ms (20.79%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.is_primary AS is_primary_4, t0.is_active AS is_active_5, t0.logo_filename AS logo_filename_6 FROM insurance_provider t0 WHERE t0.is_active = ? AND t0.is_primary = ? LIMIT 1
Parameters:
[ 1 1 ] |
|
0.69 ms (17.45%) |
1 |
SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.am_opening_time AS am_opening_time_3, t0.am_closing_time AS am_closing_time_4, t0.pm_opening_time AS pm_opening_time_5, t0.pm_closing_time AS pm_closing_time_6, t0.inspection_center_id AS inspection_center_id_7 FROM inspection_center_schedule t0 WHERE t0.inspection_center_id = ?
Parameters:
[
b"\x01‘o†Xa\x1C±‡p\x046µ\x7F#¢"
]
|
|
0.64 ms (16.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.status AS status_4, t0.price AS price_5, t0.description AS description_6, t0.inspection_center_id AS inspection_center_id_7, t0.vehicle_category_id AS vehicle_category_id_8 FROM package t0 WHERE t0.inspection_center_id = ?
Parameters:
[
b"\x01‘o†Xa\x1C±‡p\x046µ\x7F#¢"
]
|
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\InspectionCenter | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Package | No errors. |
| App\Entity\InspectionCenterSchedule | No errors. |
| App\Entity\Amenity | No errors. |
| App\Entity\InspectionCenterImage | No errors. |
| App\Entity\InspectionCenterPerk | No errors. |
| App\Entity\InspectionBooking | No errors. |
| App\Entity\UserRole |
|
| App\Entity\UserRoleAccount | No errors. |
| App\Entity\InspectionCenterAccount | No errors. |
| App\Entity\AuditLog | No errors. |
| App\Entity\InsuranceProvider | No errors. |
| App\Entity\CtplPackage | No errors. |
| App\Entity\VehicleCategory | No errors. |
| App\Entity\PackageItem | No errors. |