Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.51 ms
(85.32%)
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
  416901
  417707
  417749
  429809
  435016
  435740
  437295
  444205
  445766
  448076
  448625
  451590
  454459
  456261
  465444
  469172
  474828
  475516
  478554
  480697
  487821
  500013
  502045
  504282
  512936
  514341
  526011
  527435
  532055
  537820
  537975
  541105
  551567
  555215
  556087
  562200
  562434
  571221
  572846
  590495
  599758
  614646
  617345
  617755
  621983
  629260
  636430
  650088
  652482
  659371
  661004
  663550
  667469
  675570
  690406
  693624
  695985
  696016
  696063
  708513
  719928
  721909
  739263
  740768
  743647
  744900
  750330
  761150
  761880
  763840
  765577
  765776
  766006
  766814
  771647
  772445
  778597
  780580
  780654
  783539
  785029
  785543
  788795
  788844
  789052
  789911
  791101
  791833
  792412
  793904
  796248
  797272
  800385
  803199
  811449
  813509
  817763
  817775
  817812
  817919
  818968
  818991
  819004
  819086
  819344
  819446
  820671
  821009
  821161
  821412
  821471
  821482
  821499
  822136
  822249
  822769
  824366
  825825
  827833
  827994
]
14.67 ms
(8.26%)
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
  739263
  527435
  555215
  456261
  448625
  465444
  761150
  526011
  614646
  435016
  429809
  817919
  818968
  818991
  822769
  819004
  821471
  821499
  822136
  824366
  817763
  817775
  819344
  821412
  817812
  821009
  821161
  821482
  822249
  825825
  827833
  827994
  532055
  556087
  562434
  708513
  719928
  650088
  659371
  636430
  621983
  785543
  811449
  813509
  772445
  788844
  789911
  793904
  800385
  803199
  766814
  765776
  740768
  744900
  778597
  780654
  820671
  514341
  572846
  695985
  696063
  696016
  617345
  788795
  797272
  789052
  791101
  771647
  445766
  551567
  796248
  675570
  763840
  537820
  629260
  537975
  541105
  693624
  663550
  617755
  785029
  743647
  783539
  791833
  765577
  435740
  500013
  590495
  792412
  417707
  512936
  487821
  448076
  416901
  504282
  667469
  652482
  750330
  469172
  417749
  766006
  761880
  780580
  451590
  571221
  599758
  444205
  474828
  437295
  562200
  721909
  475516
  502045
  690406
  480697
  478554
  454459
  661004
  819086
  819446
]
3.35 ms
(1.88%)
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
  416901
  417707
  417749
  429809
  435016
  435740
  437295
  444205
  445766
  448076
  448625
  451590
  454459
  456261
  465444
  469172
  474828
  475516
  478554
  480697
  487821
  500013
  502045
  504282
  512936
  514341
  526011
  527435
  532055
  537820
  537975
  541105
  551567
  555215
  556087
  562200
  562434
  571221
  572846
  590495
  599758
  614646
  617345
  617755
  621983
  629260
  636430
  650088
  652482
  659371
  661004
  663550
  667469
  675570
  690406
  693624
  695985
  696016
  696063
  708513
  719928
  721909
  739263
  740768
  743647
  744900
  750330
  761150
  761880
  763840
  765577
  765776
  766006
  766814
  771647
  772445
  778597
  780580
  780654
  783539
  785029
  785543
  788795
  788844
  789052
  789911
  791101
  791833
  792412
  793904
  796248
  797272
  800385
  803199
  811449
  813509
  817763
  817775
  817812
  817919
  818968
  818991
  819004
  819086
  819344
  819446
  820671
  821009
  821161
  821412
  821471
  821482
  821499
  822136
  822249
  822769
  824366
  825825
  827833
  827994
]
2.12 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov ass public"
]
2.07 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов жоп на улиц"
]
1.93 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов жоп на улиц"
]
1.93 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.