Query Metrics
9
Database Queries
7
Different statements
5.04 ms
Query time
0
Invalid entities
38
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.82 ms (36.03%) |
3 |
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"
]
|
|
0.78 ms (15.43%) |
1 |
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_.facebook AS facebook_5, p0_.platform_x AS platform_x_6, p0_.instagram AS instagram_7, p0_.linked_in AS linked_in_8, p0_.position AS position_9, p0_.user_id AS user_id_10, p0_.supplier_id AS supplier_id_11, p0_.producer_id AS producer_id_12, p0_.photo_id AS photo_id_13 FROM person p0_ INNER JOIN user u1_ ON p0_.user_id = u1_.id WHERE u1_.is_employee = ?
Parameters:
[
1
]
|
|
0.72 ms (14.24%) |
1 |
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:
[] |
|
0.65 ms (12.96%) |
1 |
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
]
|
|
0.44 ms (8.64%) |
1 |
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
]
|
|
0.33 ms (6.49%) |
1 |
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:
[] |
|
0.31 ms (6.21%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.folder AS folder_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.size AS size_6, t0.date_created AS date_created_7 FROM `file` t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\File\File | 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 | No errors. |
| 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\File\File | No errors. |
| App\Entity\Job\Item\Service\ServiceSpecification | No errors. |
| App\Entity\User\PersonWorker | 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. |