Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.60 ms
(55.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русский молодой анал"
]
138.54 ms
(37.41%)
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
  7011
  391042
  391156
  393330
  411257
  422330
  423676
  424011
  426702
  427192
  441427
  441577
  455715
  458156
  461443
  462108
  463331
  474263
  481409
  487973
  489329
  497641
  505072
  519778
  542937
  547405
  570260
  578325
  580343
  581467
  581470
  588843
  595467
  599350
  607136
  619934
  621161
  623379
  624761
  626878
  629711
  643516
  647108
  652605
  652906
  652929
  653491
  653556
  656484
  656906
  661607
  663715
  664491
  668331
  670988
  671829
  673456
  677347
  685531
  685789
  699587
  707461
  713301
  714660
  715009
  715620
  718676
  718700
  721453
  722646
  722694
  722867
  724027
  725132
  727877
  731595
  734472
  739237
  740604
  746157
  746979
  747092
  747375
  747450
  751213
  753438
  753484
  754192
  757915
  762976
  764868
  766742
  769047
  769069
  769075
  769749
  770434
  771572
  773662
  774251
  779737
  782349
  783104
  785813
  786496
  787554
  789753
  790520
  792706
  793893
  793991
  796196
  796886
  800793
  801282
  811634
  811657
  812996
  826153
]
19.90 ms
(5.37%)
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
  769749
  786496
  792706
  505072
  487973
  391156
  422330
  424011
  441427
  441577
  427192
  481409
  542937
  570260
  7011
  393330
  458156
  463331
  391042
  423676
  426702
  461443
  462108
  411257
  497641
  489329
  519778
  826153
  474263
  455715
  581467
  581470
  578325
  652605
  653556
  673456
  677347
  685531
  713301
  714660
  715620
  718700
  721453
  722646
  652929
  656484
  656906
  661607
  663715
  664491
  668331
  670988
  685789
  722867
  647108
  652906
  653491
  671829
  699587
  707461
  715009
  718676
  722694
  547405
  580343
  599350
  607136
  619934
  643516
  624761
  626878
  629711
  588843
  595467
  621161
  623379
  779737
  783104
  785813
  787554
  793893
  796196
  782349
  789753
  790520
  796886
  800793
  801282
  811657
  812996
  724027
  727877
  731595
  734472
  734988
  746157
  747092
  747450
  754192
  793991
  811634
  725132
  746979
  753438
  753484
  766742
  770434
  739237
  764868
  769047
  769069
  773662
  774251
  740604
  747375
  751213
  757915
  762976
  769075
  771572
]
2.44 ms
(0.66%)
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
  7011
  391042
  391156
  393330
  411257
  422330
  423676
  424011
  426702
  427192
  441427
  441577
  455715
  458156
  461443
  462108
  463331
  474263
  481409
  487973
  489329
  497641
  505072
  519778
  542937
  547405
  570260
  578325
  580343
  581467
  581470
  588843
  595467
  599350
  607136
  619934
  621161
  623379
  624761
  626878
  629711
  643516
  647108
  652605
  652906
  652929
  653491
  653556
  656484
  656906
  661607
  663715
  664491
  668331
  670988
  671829
  673456
  677347
  685531
  685789
  699587
  707461
  713301
  714660
  715009
  715620
  718676
  718700
  721453
  722646
  722694
  722867
  724027
  725132
  727877
  731595
  734472
  739237
  740604
  746157
  746979
  747092
  747375
  747450
  751213
  753438
  753484
  754192
  757915
  762976
  764868
  766742
  769047
  769069
  769075
  769749
  770434
  771572
  773662
  774251
  779737
  782349
  783104
  785813
  786496
  787554
  789753
  790520
  792706
  793893
  793991
  796196
  796886
  800793
  801282
  811634
  811657
  812996
  826153
]
1.72 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск молодой анал"
]
1.44 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.