Query Metrics
38
Database Queries
2
Different statements
62.09 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
45.40 ms (73.13%) |
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
]
|
|
16.68 ms (26.87%) |
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"
]
|
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\Service | No errors. |
| 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\Application | 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. |