Query Metrics
75
Database Queries
3
Different statements
36.48 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
16.23 ms (44.49%) |
37 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.valid_from AS valid_from_4, t0.valid_to AS valid_to_5, t0.purpose_id AS purpose_id_6, t0.service_id AS service_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.service_id AS service_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM dict_road_occupation_purpose t0 WHERE t0.service_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"6ae089dd-9388-41c1-ab8a-f6ce132140aa"
]
|
|
15.67 ms (42.94%) |
37 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.is_required AS is_required_4, t0.tag AS tag_5, t0.is_multiple AS is_multiple_6, t0.is_for_proxy_only AS is_for_proxy_only_7, t0.fee_id AS fee_id_8, t0.service_id AS service_id_9 FROM service_attachment_position t0 WHERE t0.service_id = ?
Parameters:
[
"6ae089dd-9388-41c1-ab8a-f6ce132140aa"
]
|
|
4.59 ms (12.57%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.icon AS icon_2, s0_.url AS url_3, s0_.code AS code_4, s0_.position AS position_5, s0_.description AS description_6, s0_.content AS content_7, s0_.is_active AS is_active_8, s0_.is_case_related AS is_case_related_9, s0_.gdpr AS gdpr_10, s0_.editor_footer_content AS editor_footer_content_11, s0_.document_template_id AS document_template_id_12 FROM service s0_ WHERE s0_.is_active = ? ORDER BY s0_.position ASC
Parameters:
[
1
]
|
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\Application | No errors. |
| App\Entity\Service |
|
| App\Entity\DocumentTemplate | No errors. |
| App\Entity\DocumentTemplateAttachment |
|
| App\Entity\TemplateAttachment | No errors. |
| App\Entity\User |
|
| App\Entity\Group | No errors. |
| App\Entity\UserCaseParticipation | No errors. |
| App\Entity\CaseEntity |
|
| App\Entity\Shipment |
|
| App\Entity\ShipmentAttachment | No errors. |
| App\Entity\Attachment | No errors. |
| App\Entity\Dictionary\ApplicationStatus | No errors. |
| App\Entity\ApplicationAttachment | No errors. |
| App\Entity\ServiceAttachmentPosition | No errors. |
| App\Entity\Fee | No errors. |
| App\Entity\FeeCategory | No errors. |
| App\Entity\Dictionary\BankAccount | No errors. |
| App\Entity\Applicant | No errors. |
| App\Entity\Dictionary\EntityType | No errors. |
| App\Entity\Contractor | No errors. |
| App\Entity\Forest | No errors. |
| App\Entity\Dictionary\DocumentReceiptMethod | No errors. |
| App\Entity\RoadOccupation | No errors. |
| App\Entity\RoadOccupationStage | No errors. |
| App\Entity\Parcel | No errors. |
| App\Entity\RoadOccupationStagePurposeFee | No errors. |
| App\Entity\Dictionary\RoadOccupationPurposeFee | No errors. |
| App\Entity\LocationDecision | No errors. |
| App\Entity\Dictionary\RoadOccupationType | No errors. |
| App\Entity\Vehicle | No errors. |
| App\Entity\Dictionary\PropertyLegalTitle | No errors. |
| App\Entity\TreeToRemove | No errors. |
| App\Entity\Dictionary\TreeRemovalReason | No errors. |
| App\Entity\ApplicationDecision | No errors. |
| App\Entity\InvestorRepresentative | No errors. |
| App\Entity\DrainageSurfaceCharacteristic | No errors. |
| App\Entity\BusStop | No errors. |
| App\Entity\Dictionary\RoadOccupationPurpose | No errors. |
| Abap\PaymentBundle\Model\Payment | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\PaymentPosition | No errors. |
| App\Entity\Ezd\EzdDocument | No errors. |
| App\Entity\ShipmentConfirmation | No errors. |
| App\Entity\CaseAttachment | No errors. |
| App\Entity\Dictionary\CaseStatus | No errors. |
| App\Entity\Dictionary\DocumentTemplateType | No errors. |