Query Metrics

7 Database Queries
7 Different statements
170.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
148.58 ms
(87.23%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  20948
  252068
  382251
  382354
  384871
  386065
  386227
  391328
  392645
  393157
  409454
  420012
  420594
  436392
  436476
  443650
  444580
  448763
  457321
  462276
  463488
  469106
  470347
  470817
  472094
  474040
  474283
  484253
  487650
  493141
  497600
  504676
  507897
  510497
  516163
  518211
  519657
  522293
  522766
  527352
  527665
  529277
  532276
  534475
  535214
  541091
  543405
  543598
  544032
  545882
  546572
  550125
  552716
  553761
  559741
  560099
  560802
  561606
  563969
  568961
  576746
  581910
  586363
  589837
  596512
  599357
  602215
  605408
  606640
  606933
  608681
  618061
  618201
  618952
  620051
  626143
  627871
  652779
  656197
  657817
  658542
  661331
  667919
  691578
  698001
  710253
  714050
  715002
  719277
  719315
  719644
  719935
  721953
  724424
  725512
  729458
  730418
  730720
  735820
  744099
  745980
  746159
  746468
  763141
  765959
  769013
  772296
  774793
  779867
  784205
  785451
  787317
  789080
  789230
  801370
  802641
  803214
  804309
  806929
  814297
]
12.84 ms
(7.54%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  789230
  725512
  730418
  730720
  746468
  729458
  484253
  544032
  661331
  606933
  560802
  448763
  470817
  493141
  552716
  576746
  802641
  386065
  382354
  436392
  462276
  721953
  606640
  774793
  487650
  719277
  532276
  581910
  698001
  714050
  618061
  784205
  785451
  744099
  386227
  599357
  596512
  789080
  608681
  602215
  522293
  657817
  715002
  384871
  746159
  545882
  529277
  527665
  652779
  546572
  765959
  814297
  527352
  534475
  543405
  691578
  656197
  605408
  618201
  589837
  803214
  801370
  772296
  787317
  420012
  472094
  561606
  550125
  510497
  553761
  626143
  393157
  719315
  763141
  469106
  497600
  543598
  568961
  391328
  518211
  719644
  658542
  719935
  586363
  620051
  627871
  392645
  535214
  667919
  444580
  618952
  560099
  409454
  779867
  507897
  504676
  463488
  710253
  724424
  382251
  474283
  252068
  436476
  522766
  559741
  457321
  519657
  20948
  443650
  541091
  563969
  745980
  804309
  735820
  769013
  806929
  474040
  470347
  420594
  516163
]
2.74 ms
(1.61%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  20948
  252068
  382251
  382354
  384871
  386065
  386227
  391328
  392645
  393157
  409454
  420012
  420594
  436392
  436476
  443650
  444580
  448763
  457321
  462276
  463488
  469106
  470347
  470817
  472094
  474040
  474283
  484253
  487650
  493141
  497600
  504676
  507897
  510497
  516163
  518211
  519657
  522293
  522766
  527352
  527665
  529277
  532276
  534475
  535214
  541091
  543405
  543598
  544032
  545882
  546572
  550125
  552716
  553761
  559741
  560099
  560802
  561606
  563969
  568961
  576746
  581910
  586363
  589837
  596512
  599357
  602215
  605408
  606640
  606933
  608681
  618061
  618201
  618952
  620051
  626143
  627871
  652779
  656197
  657817
  658542
  661331
  667919
  691578
  698001
  710253
  714050
  715002
  719277
  719315
  719644
  719935
  721953
  724424
  725512
  729458
  730418
  730720
  735820
  744099
  745980
  746159
  746468
  763141
  765959
  769013
  772296
  774793
  779867
  784205
  785451
  787317
  789080
  789230
  801370
  802641
  803214
  804309
  806929
  814297
]
1.73 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public park"
]
1.58 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц парк природ"
]
1.35 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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

No loaded entities.