Query Metrics
4
Database Queries
4
Different statements
9.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.37 ms (55.44%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.content AS content_4, t0.module AS module_5, t0.menu_title AS menu_title_6, t0.in_menu AS in_menu_7 FROM page_block t0
Parameters:
[] |
|
2.09 ms (21.57%) |
1 |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.image AS image_2, l0_.preview AS preview_3, l0_.ph1 AS ph1_4, l0_.ph2 AS ph2_5, l0_.amount_investment AS amount_investment_6, l0_.work_place AS work_place_7, l0_.enabled AS enabled_8, l0_.created AS created_9, l0_.updated AS updated_10, l0_.content AS content_11, l0_.implementation_period AS implementation_period_12, l0_.fact1_title AS fact1_title_13, l0_.fact1_value AS fact1_value_14, l0_.fact2_title AS fact2_title_15, l0_.fact2_value AS fact2_value_16, l0_.fact3_title AS fact3_title_17, l0_.fact3_value AS fact3_value_18, l0_.content2 AS content2_19, l0_.map_string AS map_string_20, l0_.location AS location_21, l0_.sort AS sort_22, l0_.loc_x AS loc_x_23, l0_.loc_y AS loc_y_24, l0_.seo_title AS seo_title_25, l0_.seo_description AS seo_description_26, l0_.seo_keywords AS seo_keywords_27, l0_.distict_id AS distict_id_28 FROM local_project l0_ WHERE l0_.enabled = 1 AND l0_.id <> ? ORDER BY l0_.sort ASC LIMIT 4
Parameters:
[
"27"
]
|
|
1.17 ms (12.04%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.preview AS preview_4, t0.ph1 AS ph1_5, t0.ph2 AS ph2_6, t0.amount_investment AS amount_investment_7, t0.work_place AS work_place_8, t0.enabled AS enabled_9, t0.created AS created_10, t0.updated AS updated_11, t0.content AS content_12, t0.implementation_period AS implementation_period_13, t0.fact1_title AS fact1_title_14, t0.fact1_value AS fact1_value_15, t0.fact2_title AS fact2_title_16, t0.fact2_value AS fact2_value_17, t0.fact3_title AS fact3_title_18, t0.fact3_value AS fact3_value_19, t0.content2 AS content2_20, t0.map_string AS map_string_21, t0.location AS location_22, t0.sort AS sort_23, t0.loc_x AS loc_x_24, t0.loc_y AS loc_y_25, t0.seo_title AS seo_title_26, t0.seo_description AS seo_description_27, t0.seo_keywords AS seo_keywords_28, t0.distict_id AS distict_id_29 FROM local_project t0 WHERE t0.enabled = ?
Parameters:
[
1
]
|
|
1.06 ms (10.95%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.preview AS preview_4, t0.ph1 AS ph1_5, t0.ph2 AS ph2_6, t0.amount_investment AS amount_investment_7, t0.work_place AS work_place_8, t0.enabled AS enabled_9, t0.created AS created_10, t0.updated AS updated_11, t0.content AS content_12, t0.implementation_period AS implementation_period_13, t0.fact1_title AS fact1_title_14, t0.fact1_value AS fact1_value_15, t0.fact2_title AS fact2_title_16, t0.fact2_value AS fact2_value_17, t0.fact3_title AS fact3_title_18, t0.fact3_value AS fact3_value_19, t0.content2 AS content2_20, t0.map_string AS map_string_21, t0.location AS location_22, t0.sort AS sort_23, t0.loc_x AS loc_x_24, t0.loc_y AS loc_y_25, t0.seo_title AS seo_title_26, t0.seo_description AS seo_description_27, t0.seo_keywords AS seo_keywords_28, t0.distict_id AS distict_id_29 FROM local_project t0 WHERE t0.id = ? AND t0.enabled = ? LIMIT 1
Parameters:
[ "27" 1 ] |
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\PageBlock | No errors. |
| App\Entity\PagePageBlock | No errors. |
| App\Entity\LocalProject | No errors. |
| App\Entity\ProjectDistict | No errors. |