Query Metrics
9
Database Queries
7
Different statements
3.63 ms
Query time
1
Invalid entities
37
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.60 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.39 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.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:
[
"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.47 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.43 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.36 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.44 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.28 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 |
|
| 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. |