GET https://dev.stga-digital.eu/

Query Metrics

9 Database Queries
7 Different statements
3.76 ms Query time
1 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 0.61 ms
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.type AS type_3, t0.date_created AS date_created_4, t0.position AS position_5, t0.user_id AS user_id_6 FROM reference t0 WHERE t0.type = ?
Parameters:
[
  "it-services"
]
2 0.35 ms
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.type AS type_3, t0.date_created AS date_created_4, t0.position AS position_5, t0.user_id AS user_id_6 FROM reference t0 WHERE t0.type = ?
Parameters:
[
  "print-services"
]
3 0.36 ms
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.type AS type_3, t0.date_created AS date_created_4, t0.position AS position_5, t0.user_id AS user_id_6 FROM reference t0 WHERE t0.type = ?
Parameters:
[
  "interior-decors"
]
4 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.job_position AS job_position_4, t0.score AS score_5, t0.content AS content_6, t0.date_created AS date_created_7, t0.position AS position_8, t0.user_id AS user_id_9 FROM testimonial t0
Parameters:
[]
5 0.49 ms
SELECT p0_.id AS id_0, p0_.date_created AS date_created_1, p0_.date_updated AS date_updated_2, p0_.first_name AS first_name_3, p0_.last_name AS last_name_4, p0_.photo AS photo_5, p0_.facebook AS facebook_6, p0_.platform_x AS platform_x_7, p0_.instagram AS instagram_8, p0_.linked_in AS linked_in_9, p0_.position AS position_10, p0_.user_id AS user_id_11, p0_.supplier_id AS supplier_id_12, p0_.producer_id AS producer_id_13 FROM person p0_ INNER JOIN user u1_ ON p0_.user_id = u1_.id WHERE u1_.is_employee = ?
Parameters:
[
  1
]
6 0.48 ms
SELECT t0.id AS id_1, t0.date_updated AS date_updated_2, t0.email AS email_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.person_id AS person_id_6, t0.supplier_id AS supplier_id_7, t0.producer_id AS producer_id_8, t0.company_id AS company_id_9 FROM email t0 WHERE t0.person_id = ?
Parameters:
[
  1
]
7 0.40 ms
SELECT t0.id AS id_1, t0.date_updated AS date_updated_2, t0.phone AS phone_3, t0.type AS type_4, t0.date_created AS date_created_5, t0.person_id AS person_id_6, t0.supplier_id AS supplier_id_7, t0.producer_id AS producer_id_8, t0.company_id AS company_id_9 FROM phone t0 WHERE t0.person_id = ?
Parameters:
[
  1
]
8 0.40 ms
SELECT t0.id AS id_1, t0.date_updated AS date_updated_2, t0.email AS email_3, t0.password AS password_4, t0.date_created AS date_created_5, t0.is_employee AS is_employee_6, t0.roles AS roles_7, t8.id AS id_9, t8.date_created AS date_created_10, t8.date_updated AS date_updated_11, t8.first_name AS first_name_12, t8.last_name AS last_name_13, t8.photo AS photo_14, t8.facebook AS facebook_15, t8.platform_x AS platform_x_16, t8.instagram AS instagram_17, t8.linked_in AS linked_in_18, t8.position AS position_19, t8.user_id AS user_id_20, t8.supplier_id AS supplier_id_21, t8.producer_id AS producer_id_22, t0.company_id AS company_id_23 FROM user t0 LEFT JOIN person t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
9 0.35 ms
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.position AS position_3, t0.user_id AS user_id_4 FROM faq t0
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Page\Reference 32
App\Entity\User\User 1
App\Entity\User\Person 1
App\Entity\Contact\Email 1
App\Entity\Contact\Phone 1
App\Entity\Page\Faq 1

Entities Mapping

Class Mapping errors
App\Entity\Page\Reference No errors.
App\Entity\User\User
  • The mappings App\Entity\User\User#testimonials and App\Entity\Page\Testimonial#user are inconsistent with each other.
  • The field App\Entity\User\User#changeLogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Log\ChangeLog#user does not contain the required 'inversedBy="changeLogs"' attribute.
App\Entity\Page\Testimonial No errors.
App\Entity\User\Person No errors.
App\Entity\Partner\Supplier No errors.
App\Entity\Partner\Producer No errors.
App\Entity\Contact\Email No errors.
App\Entity\Contact\Phone No errors.
App\Entity\User\Company No errors.
App\Entity\Page\Faq No errors.
App\Entity\Notification\UserNotification No errors.
App\Entity\Log\ChangeLog No errors.