Query Metrics
4
Database Queries
4
Different statements
5.54 ms
Query time
0
Invalid entities
10
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.84 ms (33.32%) |
1 |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.subtitle AS subtitle_2, f0_.slug AS slug_3, f0_.description AS description_4, f0_.full_description AS full_description_5, f0_.image AS image_6, f0_.icon AS icon_7, f0_.duration AS duration_8, f0_.duration_unit AS duration_unit_9, f0_.price AS price_10, f0_.is_active AS is_active_11, f0_.is_featured AS is_featured_12, f0_.sort_order AS sort_order_13, f0_.objectives AS objectives_14, f0_.prerequisites AS prerequisites_15, f0_.program AS program_16, f0_.certification AS certification_17, f0_.program_filename AS program_filename_18, f0_.created_at AS created_at_19, f0_.updated_at AS updated_at_20, f0_.category_id AS category_id_21 FROM formation f0_ WHERE f0_.is_active = 1 AND f0_.is_featured = 1 ORDER BY f0_.sort_order ASC LIMIT 6
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.60 ms (28.97%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.logo AS logo_2, p0_.website AS website_3, p0_.is_active AS is_active_4, p0_.sort_order AS sort_order_5 FROM partner p0_ WHERE p0_.is_active = 1 ORDER BY p0_.sort_order ASC, p0_.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.33 ms (23.95%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.image AS image_5, b0_.tag AS tag_6, b0_.tag_color AS tag_color_7, b0_.is_published AS is_published_8, b0_.published_at AS published_at_9, b0_.created_at AS created_at_10 FROM blog_post b0_ WHERE b0_.is_published = 1 ORDER BY b0_.published_at DESC LIMIT 4
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.76 ms (13.76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.icon AS icon_5 FROM category 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\Formation | 6 |
| App\Entity\Category | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Formation | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\FormationSession | No errors. |
| App\Entity\BlogPost | No errors. |
| App\Entity\Partner | No errors. |