Query Metrics
7
Database Queries
7
Different statements
5.37 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.13 ms (21.01%) |
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.96 ms (17.87%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.nationality AS nationality_4 FROM country t0 ORDER BY t0.name ASC
Parameters:
[] |
|
0.72 ms (13.34%) |
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:
[
"mvic-manila"
]
|
|
0.72 ms (13.31%) |
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Üü¥1ù#¸\\t\x14µ¯k"
]
|
|
0.69 ms (12.86%) |
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.id = ?
Parameters:
[
b"\x01ærU\x14\x0FÃ■ÌØ÷═å\x03ó\x08"
]
|
|
0.59 ms (10.98%) |
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.57 ms (10.63%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.nationality AS nationality_4 FROM country t0 WHERE t0.id = ?
Parameters:
[
b"\x01‘\t9ž\x7Fs\x03Ú\x05óPÝÜ5œ"
]
|
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\VehicleCategory | No errors. |
| App\Entity\PackageItem | No errors. |
| App\Entity\InsuranceProvider | No errors. |
| App\Entity\CtplPackage | No errors. |
| App\Entity\Country | No errors. |