Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
380.61 ms
(93.03%)
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
  88591
  154463
  182285
  290847
  352189
  359918
  382404
  387749
  389794
  396784
  398741
  402628
  407423
  410702
  411211
  415324
  415965
  416175
  416539
  416613
  416634
  416707
  427364
  429596
  432680
  438880
  440045
  441042
  441049
  441050
  443255
  446778
  448873
  449173
  451774
  455078
  455901
  467568
  467585
  470403
  470405
  471148
  473745
  476184
  478489
  479818
  482190
  482293
  482775
  486773
  497474
  502242
  506105
  514240
  516676
  518550
  523355
  525431
  525446
  525468
  529738
  529741
  530053
  530110
  530438
  530679
  530790
  530941
  531347
  531891
  534777
  536378
  537141
  539319
  542146
  542707
  547478
  547556
  548854
  564227
  604781
  605133
  619802
  628097
  628105
  629339
  630096
  630420
  631203
  634108
  642004
  642029
  653602
  654988
  658784
  661008
  669017
  669022
  669067
  670356
  670360
  671008
  672315
  696591
  713500
  722394
  742224
  752704
  752705
  756749
  759335
  760319
  782836
  788185
  796681
  802899
  805289
  811690
  821033
  821964
]
16.27 ms
(3.98%)
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
  402628
  416175
  410702
  670356
  670360
  671008
  628097
  628105
  742224
  415324
  352189
  389794
  396784
  470405
  446778
  470403
  473745
  449173
  486773
  467585
  497474
  564227
  669067
  634108
  630420
  811690
  752704
  441042
  455078
  427364
  518550
  547556
  514240
  530053
  530941
  479818
  539319
  669022
  782836
  529738
  756749
  542707
  530679
  531891
  805289
  548854
  387749
  441049
  530110
  525431
  619802
  407423
  451774
  506105
  523355
  796681
  525446
  154463
  290847
  416634
  429596
  438880
  411211
  415965
  467568
  482190
  536378
  531347
  530790
  547478
  661008
  605133
  631203
  802899
  760319
  482293
  432680
  525468
  629339
  530438
  658784
  672315
  359918
  382404
  88591
  416707
  416613
  534777
  516676
  542146
  669017
  478489
  440045
  441050
  398741
  821964
  821033
  529741
  537141
  653602
  654988
  696591
  713500
  722394
  642004
  752705
  759335
  471148
  443255
  482775
  476184
  604781
  416539
  455901
  502242
  630096
  788185
  182285
  448873
  642029
]
3.12 ms
(0.76%)
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
  88591
  154463
  182285
  290847
  352189
  359918
  382404
  387749
  389794
  396784
  398741
  402628
  407423
  410702
  411211
  415324
  415965
  416175
  416539
  416613
  416634
  416707
  427364
  429596
  432680
  438880
  440045
  441042
  441049
  441050
  443255
  446778
  448873
  449173
  451774
  455078
  455901
  467568
  467585
  470403
  470405
  471148
  473745
  476184
  478489
  479818
  482190
  482293
  482775
  486773
  497474
  502242
  506105
  514240
  516676
  518550
  523355
  525431
  525446
  525468
  529738
  529741
  530053
  530110
  530438
  530679
  530790
  530941
  531347
  531891
  534777
  536378
  537141
  539319
  542146
  542707
  547478
  547556
  548854
  564227
  604781
  605133
  619802
  628097
  628105
  629339
  630096
  630420
  631203
  634108
  642004
  642029
  653602
  654988
  658784
  661008
  669017
  669022
  669067
  670356
  670360
  671008
  672315
  696591
  713500
  722394
  742224
  752704
  752705
  756749
  759335
  760319
  782836
  788185
  796681
  802899
  805289
  811690
  821033
  821964
]
2.38 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "огромные жопы жёсткое…"
]
2.32 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.27 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные жоп хардкор"
]
2.16 ms
(0.53%)
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.