GET https://cmis.ge/_fragment?_path=_format%3Dhtml%26_locale%3Dka%26_controller%3DApp%255CController%255CPublicInformationDataController%253A%253Afilters

Response
200 OK
IP
3.149.232.40
Profiled on
Token
cc3dae

Query Metrics

10 Database Queries
9 Different statements
93.92 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
32.90 ms
(35.03%) 		1 
SELECT m0_.id AS id_0, m0_.title_ka AS title_ka_1 FROM media_type m0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
23.53 ms
(25.05%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.methodology AS methodology_4, t0.pub_date AS pub_date_5, t0.related_data_class AS related_data_class_6, t0.headline AS headline_7, t0.headline_ka AS headline_ka_8, t0.intro_ka AS intro_ka_9, t0.methodology_ka AS methodology_ka_10, t0.slug AS slug_11, t0.data_ctrl AS data_ctrl_12, t0.resume AS resume_13, t0.resume_ka AS resume_ka_14, t0.recommends AS recommends_15, t0.recommends_ka AS recommends_ka_16, t0.short AS short_17, t0.short_ka AS short_ka_18, t0.extract AS extract_19, t0.extract_ka AS extract_ka_20, t0.cover AS cover_21, t0.cover_ka AS cover_ka_22, t0.visible AS visible_23, t0.about AS about_24, t0.about_ka AS about_ka_25, t0.code AS code_26, t0.load_data AS load_data_27 FROM project t0 WHERE t0.slug = ? AND t0.visible = ? ORDER BY t0.pub_date DESC LIMIT 1
Parameters: 
[
  "pubinf"
  1
]
View formatted query    View runnable query    Explain query
10.85 ms
(11.55%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ka AS title_ka_3, t0.logo AS logo_4, t0.logo_ka AS logo_ka_5, t0.url AS url_6, t0.url_ka AS url_ka_7 FROM donor t0 INNER JOIN project_donor ON t0.id = project_donor.donor_id WHERE project_donor.project_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
8.67 ms
(9.23%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ka AS title_ka_3, t0.src AS src_4, t0.src_ka AS src_ka_5, t0.cover AS cover_6, t0.cover_ka AS cover_ka_7, t0.extract AS extract_8, t0.extract_ka AS extract_ka_9, t0.published AS published_10, t0.on_home AS on_home_11, t0.deleted AS deleted_12, t0.project_id AS project_id_13 FROM attachment t0 WHERE t0.project_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
8.66 ms
(9.22%) 		1 
SELECT g0_.id AS id_0, r1_.id AS id_1, g0_.branch AS branch_2, g0_.title_ka AS title_ka_3 FROM government_entity g0_ LEFT JOIN region r1_ ON g0_.region_id = r1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.57 ms
(3.80%) 		2 
SELECT t0_.id AS id_0, t0_.title_ka AS title_ka_1 FROM tag t0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.07 ms
(2.20%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ka AS title_ka_3, t0.visible AS visible_4, t0.url AS url_5, t0.menu_id AS menu_id_6 FROM menu_entry t0 WHERE t0.menu_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.99 ms
(2.12%) 		1 
SELECT r0_.id AS id_0, r0_.name_ka AS name_ka_1 FROM region r0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.70 ms
(1.81%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3 FROM menu t0 WHERE t0.name = ? AND t0.visible = ? LIMIT 1
Parameters: 
[
  "main"
  1
]
View formatted query    View runnable query    Explain query

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\Project No errors.
App\Entity\Attachment No errors.
App\Entity\Donor No errors.
App\Entity\User No errors.
App\Entity\Menu No errors.
App\Entity\MenuEntry No errors.
App\Entity\Region No errors.
App\Entity\MediaType No errors.
App\Entity\GovernmentEntity No errors.
App\Entity\Tag No errors.