Query Metrics
11
Database Queries
5
Different statements
14.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.69 ms (52.16%) |
7 |
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.grid_position AS grid_position_8, t0.grid_name AS grid_name_9, t0.grid_name_en AS grid_name_en_10, t0.name AS name_11, t0.abstract AS abstract_12, t0.description AS description_13, t0.hero_image AS hero_image_14, t0.hero_video AS hero_video_15, t0.catch_phrase AS catch_phrase_16, t0.catch_phrase_en AS catch_phrase_en_17, t0.template AS template_18, t0.meta_title AS meta_title_19, t0.meta_title_en AS meta_title_en_20, t0.meta_description AS meta_description_21, t0.meta_description_en AS meta_description_en_22, t0.keywords AS keywords_23, t0.keywords_en AS keywords_en_24, t0.faq AS faq_25, t0.faq_en AS faq_en_26, t0.parent_category_id AS parent_category_id_27 FROM product_category t0 WHERE t0.parent_category_id = ?
Parameters:
[
44
]
|
||||||||||||||||||||||||||||
|
2.66 ms (18.03%) |
1 |
SELECT p0_.id AS id_0, p0_.thumbnail AS thumbnail_1, p0_.description_en AS description_en_2, p0_.abstract_en AS abstract_en_3, p0_.name_en AS name_en_4, p0_.slug AS slug_5, p0_.grid_view AS grid_view_6, p0_.grid_position AS grid_position_7, p0_.grid_name AS grid_name_8, p0_.grid_name_en AS grid_name_en_9, p0_.name AS name_10, p0_.abstract AS abstract_11, p0_.description AS description_12, p0_.hero_image AS hero_image_13, p0_.hero_video AS hero_video_14, p0_.catch_phrase AS catch_phrase_15, p0_.catch_phrase_en AS catch_phrase_en_16, p0_.template AS template_17, p0_.meta_title AS meta_title_18, p0_.meta_title_en AS meta_title_en_19, p0_.meta_description AS meta_description_20, p0_.meta_description_en AS meta_description_en_21, p0_.keywords AS keywords_22, p0_.keywords_en AS keywords_en_23, p0_.faq AS faq_24, p0_.faq_en AS faq_en_25, p0_.parent_category_id AS parent_category_id_26 FROM product_category p0_ WHERE p0_.grid_position IS NOT NULL ORDER BY p0_.grid_position ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.79 ms (12.13%) |
1 |
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.title AS title_2, b0_.title_en AS title_en_3, b0_.excerpt AS excerpt_4, b0_.excerpt_en AS excerpt_en_5, b0_.content AS content_6, b0_.content_en AS content_en_7, b0_.catch_phrase AS catch_phrase_8, b0_.catch_phrase_en AS catch_phrase_en_9, b0_.featured_image AS featured_image_10, b0_.status AS status_11, b0_.created_at AS created_at_12, b0_.updated_at AS updated_at_13, b0_.published_at AS published_at_14, b0_.view_count AS view_count_15, b0_.meta_title AS meta_title_16, b0_.meta_title_en AS meta_title_en_17, b0_.meta_description AS meta_description_18, b0_.meta_description_en AS meta_description_en_19, b0_.keywords AS keywords_20, b0_.keywords_en AS keywords_en_21, b0_.author_id AS author_id_22, b0_.category_id AS category_id_23 FROM blog_post b0_ WHERE b0_.status = ? AND b0_.published_at IS NOT NULL AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 1
Parameters:
[ "published" "2026-04-16 15:48:13" ]
|
||||||||||||||||||||||||||||
|
1.41 ms (9.53%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.is_verified AS is_verified_5, u0_.active AS active_6, u0_.has_default_password AS has_default_password_7, u0_.personal_number AS personal_number_8, u0_.given_name AS given_name_9, u0_.family_name AS family_name_10, u0_.hero_image AS hero_image_11, u0_.headshot AS headshot_12, u0_.title AS title_13, u0_.title_en AS title_en_14, u0_.gender AS gender_15, u0_.meal_location AS meal_location_16, u0_.type AS type_17, u0_.department_id AS department_id_18, u0_.meal_billing_company_id AS meal_billing_company_id_19 FROM "user" u0_ WHERE (u0_.hero_image IS NOT NULL AND u0_.active = true) AND u0_.type IN ('employee')
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.20 ms (8.15%) |
1 |
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.description_en AS description_en_3, t0.abstract_en AS abstract_en_4, t0.name_en AS name_en_5, t0.slug AS slug_6, t0.grid_view AS grid_view_7, t0.grid_position AS grid_position_8, t0.grid_name AS grid_name_9, t0.grid_name_en AS grid_name_en_10, t0.name AS name_11, t0.abstract AS abstract_12, t0.description AS description_13, t0.hero_image AS hero_image_14, t0.hero_video AS hero_video_15, t0.catch_phrase AS catch_phrase_16, t0.catch_phrase_en AS catch_phrase_en_17, t0.template AS template_18, t0.meta_title AS meta_title_19, t0.meta_title_en AS meta_title_en_20, t0.meta_description AS meta_description_21, t0.meta_description_en AS meta_description_en_22, t0.keywords AS keywords_23, t0.keywords_en AS keywords_en_24, t0.faq AS faq_25, t0.faq_en AS faq_en_26, t0.parent_category_id AS parent_category_id_27 FROM product_category t0 WHERE t0.parent_category_id IS NULL
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\ProductCategory | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Blog\BlogPost | No errors. |
| App\Entity\Blog\BlogCategory | No errors. |
| App\Entity\Blog\BlogTag | No errors. |
| App\Entity\Department | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\StretchfilmCalculator\Calculation | No errors. |
| App\Entity\Meal\MealOrder | No errors. |
| App\Entity\Item | No errors. |
| App\Entity\StretchfilmCalculator\Stretchfilm | No errors. |
| App\Entity\StretchfilmCalculator\CuttingMachine | No errors. |
| App\Entity\Meal\MealItem | No errors. |
| App\Entity\Meal\MealDeliveryDate | No errors. |
| App\Entity\Meal\MealSettlement | No errors. |