http://manager.insureapps.co.uk/form/199/1

Method
GET
HTTP Status
200
IP
172.31.13.181
Profiled on
Token
c58300

Query Metrics

1 Database Queries
1 Different statements
12.58 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 12.58 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.large_logo AS large_logo_4, t0.brand_colour AS brand_colour_5, t0.status AS status_6, t0.flag AS flag_7, t0.search_code AS search_code_8, t0.privacyPolicy AS privacyPolicy_9, t0.sender_id AS sender_id_10, t0.insure_app_provider AS insure_app_provider_11, t0.risk_management_provider AS risk_management_provider_12, t0.webform_provider AS webform_provider_13, t0.sub_provider_code AS sub_provider_code_14, t0.provider_api_key AS provider_api_key_15, t0.submission_handler AS submission_handler_16, t0.base64_return_images AS base64_return_images_17, t0.setting_id AS setting_id_18, t0.parent_provider_id AS parent_provider_id_19 FROM provider t0 WHERE t0.id = ?
Parameters: 
[
  "199"
]
View formatted query    View runnable query    Explain query

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\Provider
  • The association App\Entity\Provider#depots is ordered by a foreign field policyType that is not a field on the target entity App\Entity\RiskManagementDepot.
  • The association App\Entity\Provider#employees is ordered by a foreign field policyType that is not a field on the target entity App\Entity\RiskManagementEmployee.
  • The association App\Entity\Provider#trainingCourses is ordered by a foreign field policyType that is not a field on the target entity App\Entity\RiskManagementTrainingCourse.
  • The association App\Entity\Provider#vehicles is ordered by a foreign field policyType that is not a field on the target entity App\Entity\RiskManagementVehicles.
  • The association App\Entity\Provider#parentProvider refers to the inverse side field App\Entity\Provider#provider which does not exist.
  • The mappings App\Entity\Provider#webFormStaticData and App\Entity\WebFormStaticData#provider are inconsistent with each other.
App\Entity\Setting No errors.
App\Entity\Policy No errors.
App\Entity\User No errors.
App\Entity\AppUser No errors.
App\Entity\RiskManagementDepot No errors.
App\Entity\RiskManagementEmployee No errors.
App\Entity\RiskManagementTrainingCourse No errors.
App\Entity\RiskManagementVehicles No errors.
App\Entity\LoginLogs No errors.
App\Entity\ApiDataLogs No errors.
App\Entity\WebFormStaticData
  • The association App\Entity\WebFormStaticData#provider refers to the inverse side field App\Entity\Provider#web_form_static_data which does not exist.
App\Entity\AvailabilityModule No errors.
App\Entity\InsurerHandler No errors.
App\Entity\LocationInsurerRule No errors.