Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.15 ms
(86.91%)
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
  384140
  392169
  397886
  413235
  417174
  418727
  420277
  420847
  422032
  422834
  422933
  426979
  427971
  428249
  429366
  431062
  432128
  435047
  439428
  443029
  446656
  447513
  447534
  449073
  450321
  450563
  450573
  451462
  452783
  454886
  455047
  459010
  460815
  461437
  466646
  467908
  473083
  478462
  482937
  483527
  483867
  496395
  500746
  504787
  505793
  508457
  509796
  510938
  510944
  511983
  513689
  514249
  515275
  517391
  523157
  524809
  525830
  526367
  529096
  530756
  532900
  532976
  532978
  533005
  556593
  558194
  559293
  561748
  564170
  568115
  570743
  571809
  578234
  579693
  583209
  585373
  586465
  588620
  590597
  596470
  597899
  598180
  599644
  602168
  604999
  608534
  610120
  610552
  613489
  615318
  615921
  622394
  626960
  630078
  639897
  640280
  659344
  696435
  709786
  714725
  715289
  717174
  718785
  721560
  724361
  743610
  751435
  757416
  765668
  771180
  777284
  789638
  796877
  803594
  805134
  805149
  806640
  806910
  807360
  820768
]
15.25 ms
(7.44%)
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
  532978
  532976
  743610
  417174
  450321
  454886
  610120
  820768
  455047
  514249
  659344
  709786
  564170
  597899
  789638
  805134
  807360
  803594
  724361
  757416
  806640
  384140
  435047
  422032
  446656
  482937
  578234
  559293
  721560
  615318
  777284
  765668
  428249
  483527
  427971
  450573
  568115
  751435
  796877
  450563
  483867
  467908
  510938
  714725
  583209
  596470
  478462
  461437
  579693
  556593
  504787
  524809
  422933
  429366
  532900
  510944
  533005
  561748
  715289
  598180
  622394
  426979
  459010
  397886
  413235
  439428
  500746
  513689
  508457
  529096
  452783
  466646
  523157
  496395
  515275
  696435
  585373
  604999
  639897
  805149
  806910
  771180
  626960
  717174
  451462
  420847
  447534
  509796
  526367
  571809
  420277
  422834
  460815
  530756
  517391
  586465
  588620
  602168
  447513
  473083
  558194
  392169
  432128
  718785
  590597
  615921
  630078
  443029
  511983
  505793
  525830
  613489
  431062
  570743
  418727
  449073
  610552
  640280
  599644
  608534
]
4.11 ms
(2.00%)
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
  384140
  392169
  397886
  413235
  417174
  418727
  420277
  420847
  422032
  422834
  422933
  426979
  427971
  428249
  429366
  431062
  432128
  435047
  439428
  443029
  446656
  447513
  447534
  449073
  450321
  450563
  450573
  451462
  452783
  454886
  455047
  459010
  460815
  461437
  466646
  467908
  473083
  478462
  482937
  483527
  483867
  496395
  500746
  504787
  505793
  508457
  509796
  510938
  510944
  511983
  513689
  514249
  515275
  517391
  523157
  524809
  525830
  526367
  529096
  530756
  532900
  532976
  532978
  533005
  556593
  558194
  559293
  561748
  564170
  568115
  570743
  571809
  578234
  579693
  583209
  585373
  586465
  588620
  590597
  596470
  597899
  598180
  599644
  602168
  604999
  608534
  610120
  610552
  613489
  615318
  615921
  622394
  626960
  630078
  639897
  640280
  659344
  696435
  709786
  714725
  715289
  717174
  718785
  721560
  724361
  743610
  751435
  757416
  765668
  771180
  777284
  789638
  796877
  803594
  805134
  805149
  806640
  806910
  807360
  820768
]
2.39 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pink tits"
]
1.75 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pink сиськ"
]
1.64 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pink сиськ"
]

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.