Query Metrics
9
Database Queries
7
Different statements
5.04 ms
Query time
0
Invalid entities
38
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.72 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.46 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.64 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.72 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.78 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_.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
]
|
| 6 | 0.65 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.44 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.31 ms |
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
]
|
| 9 | 0.33 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\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. |