Query Metrics
38
Database Queries
2
Different statements
62.09 ms
Query time
4
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 45.40 ms |
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
]
|
| 2 | 1.15 ms |
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"
]
|
| 3 | 0.49 ms |
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:
[
"6f095b12-7726-452e-a4ee-7d8f608e2532"
]
|
| 4 | 0.40 ms |
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:
[
"843a5280-ab97-41de-9870-5182e15f7e16"
]
|
| 5 | 0.42 ms |
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:
[
"28bad3f6-de13-411d-befd-da03b61572e9"
]
|
| 6 | 0.72 ms |
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:
[
"485c703f-d81f-4ebf-8bad-d5bdcd0abbcc"
]
|
| 7 | 0.46 ms |
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:
[
"07de17ef-cdf2-4317-a77f-d92748a543d9"
]
|
| 8 | 0.38 ms |
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:
[
"16a95f3d-283e-4461-975c-fce86a07ba6f"
]
|
| 9 | 0.50 ms |
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:
[
"fdaddc69-0a5a-4156-86d1-2c1f8b1f7a95"
]
|
| 10 | 0.40 ms |
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:
[
"de43386d-6dbe-41f4-91c3-55753019e7e7"
]
|
| 11 | 0.41 ms |
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:
[
"f8184c52-2beb-45fa-9f8d-939fd77f1bd5"
]
|
| 12 | 0.40 ms |
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:
[
"4f724506-7d75-42e1-ba25-2726145a11b8"
]
|
| 13 | 0.39 ms |
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:
[
"c308f70c-eddd-4e7d-928d-3a86261b7ae5"
]
|
| 14 | 0.43 ms |
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:
[
"169a861c-7830-46b2-84e1-a429eab87f59"
]
|
| 15 | 0.41 ms |
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:
[
"a131c1be-3860-417d-a17d-7d8a7c5fa113"
]
|
| 16 | 0.40 ms |
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:
[
"9fa4979f-565f-44e6-9c6c-a0907fd871fe"
]
|
| 17 | 0.42 ms |
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:
[
"ed64e583-4c8a-4843-b854-87c0d3d5fcf7"
]
|
| 18 | 0.46 ms |
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:
[
"e6563aa5-5342-4658-99fc-781ec47f360f"
]
|
| 19 | 0.41 ms |
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:
[
"c5306fb1-2550-4834-9def-db7e5b2c9b2a"
]
|
| 20 | 0.42 ms |
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:
[
"63d953e2-6c15-43ae-b420-a37b3874ce83"
]
|
| 21 | 0.41 ms |
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:
[
"ab8e8e89-2b3d-491d-9636-cca7a4c25693"
]
|
| 22 | 0.42 ms |
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:
[
"67da0abd-4153-448b-8a35-553175631f9d"
]
|
| 23 | 0.40 ms |
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:
[
"c6aed30a-d7bf-4192-a0f1-23b59340ef47"
]
|
| 24 | 0.41 ms |
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:
[
"fc408dbc-3509-414c-b364-6217452c9a81"
]
|
| 25 | 0.44 ms |
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:
[
"3ffb9760-d41d-46b3-a6e0-e6956f1bc606"
]
|
| 26 | 0.40 ms |
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:
[
"b4aad80f-6c82-49de-aeac-f7763041cba8"
]
|
| 27 | 0.41 ms |
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:
[
"688e6c59-b2a5-452e-9a25-390b818f78bc"
]
|
| 28 | 0.51 ms |
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:
[
"9404ad88-2694-49e3-8999-203f74ba423d"
]
|
| 29 | 0.40 ms |
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:
[
"05bde426-33e6-439d-96b1-c3e96768e133"
]
|
| 30 | 0.41 ms |
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:
[
"b455983d-c6e0-412d-8797-6bda5b5a1cc9"
]
|
| 31 | 0.44 ms |
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:
[
"124fd665-18f5-47ff-828b-5d7d842141da"
]
|
| 32 | 0.40 ms |
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:
[
"2ae6bdcd-c81d-41df-b539-0f5f21faa01e"
]
|
| 33 | 0.45 ms |
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:
[
"4c4617d5-e557-4e9f-96c3-58a2aabb47fd"
]
|
| 34 | 0.44 ms |
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:
[
"d3cfa873-6b1f-42af-a8f0-1144e0febfbf"
]
|
| 35 | 0.40 ms |
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:
[
"ec3eba26-b8d7-46a4-8d05-88c53648696a"
]
|
| 36 | 0.39 ms |
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:
[
"0db6a35d-5850-4d30-b30c-ff8b82c67d60"
]
|
| 37 | 0.40 ms |
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:
[
"493bb208-8ff8-45b0-b1d1-c783d660ea4c"
]
|
| 38 | 0.48 ms |
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:
[
"45f52a60-a6e9-40c1-85de-d89121e0abb5"
]
|
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. |