https://mosregco.ru/localproject/27

Query Metrics

7 Database Queries
6 Different statements
14.93 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.37 ms
(35.96%)
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:
[]
3.51 ms
(23.48%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "mos_portal"
]
2.09 ms
(13.99%)
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.74 ms
(11.65%)
2
SELECT DATABASE()
Parameters:
[]
1.17 ms
(7.81%)
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
(7.10%)
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.
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.