http://smartfactor-system.test.aspello.pl/api/v1/services?pagination=false

Query Metrics

38 Database Queries
2 Different statements
62.09 ms Query time
4 Invalid entities

Queries

Group similar statements

# 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
  • The field App\Entity\DocumentTemplateAttachment#documentTemplate is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\DocumentTemplate#attachment does not contain the required 'mappedBy="documentTemplate"' attribute.
App\Entity\TemplateAttachment No errors.
App\Entity\User
  • The field App\Entity\User#participations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserCaseParticipation#user does not contain the required 'inversedBy="participations"' attribute.
App\Entity\Group No errors.
App\Entity\UserCaseParticipation No errors.
App\Entity\CaseEntity
  • The field App\Entity\CaseEntity#participations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserCaseParticipation#case does not contain the required 'inversedBy="participations"' attribute.
App\Entity\Shipment
  • The field App\Entity\Shipment#payments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Payment#decision does not contain the required 'inversedBy="payments"' attribute.
  • The field App\Entity\Shipment#ezdDocuments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ezd\EzdDocument#shipment does not contain the required 'inversedBy="ezdDocuments"' attribute.
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.