Query Metrics
2
Database Queries
2
Different statements
1.23 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.82 ms (67.29%) |
1 |
SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id WHERE p0_.visible = ? AND c2_.slug = ? AND s6_.day = ? AND s6_.open <= ? AND ? <= s6_.close GROUP BY p0_.id ORDER BY COUNT(l5_.id) DESC, COUNT(v4_.id) DESC
Parameters:
[ 1 "hightech-web" "Saturday" "2026-04-18 09:41:34" "2026-04-18 09:41:34" ]
|
||||||||||||||||||||||||||||
|
0.40 ms (32.71%) |
1 |
SELECT c0_.updated AS updated_0, c0_.created AS created_1, c0_.entities AS entities_2, c0_.id AS id_3, c0_.major AS major_4, c0_.slug AS slug_5, c0_.title AS title_6 FROM category c0_ WHERE c0_.entities LIKE ? ORDER BY c0_.title ASC
Parameters:
[
"%partner%"
]
|
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\Category | 26 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Partner | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\View | No errors. |
| App\Entity\Like | No errors. |
| App\Entity\Schedule | No errors. |
| App\Entity\File | No errors. |