Query Metrics
7
Database Queries
6
Different statements
14.93 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.37 ms |
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 | 2.09 ms |
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"
]
|
| 3 | 1.17 ms |
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
]
|
| 4 | 1.06 ms |
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 ] |
| 5 | 0.96 ms |
SELECT DATABASE()
Parameters:
[] |
| 6 | 3.51 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"mos_portal"
]
|
| 7 | 0.78 ms |
SELECT DATABASE()
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\PageBlock | No errors. |
| App\Entity\PagePageBlock | No errors. |
| App\Entity\LocalProject | No errors. |
| App\Entity\ProjectDistict | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\LocalProjectImage | No errors. |
| App\Entity\Publication | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\PublicationCategory | No errors. |
| App\Entity\PublicationImage | No errors. |
| App\Entity\ProjectRezident | No errors. |
| App\Entity\ProjectItem | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\ProjectContentGroup | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\ServiceCompany | No errors. |
| App\Entity\JukService | No errors. |
| App\Entity\Smi | No errors. |
| App\Entity\Chart | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\DocumentGroup | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Itog | No errors. |
| App\Entity\Subscribtion | No errors. |
| App\Entity\JukIcon | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\Map | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\ProjectItemImage | No errors. |
| App\Entity\UserOrder | No errors. |
| App\Entity\PersonCategory | No errors. |
| App\Entity\JukSmi | No errors. |
| App\Entity\PriceIndex | No errors. |
| App\Entity\GalleryItem | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\ChartValue | No errors. |
| App\Entity\PriceIndexItem | No errors. |
| App\Entity\Partner | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |