Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.33 ms
(82.80%)
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
  373875
  396083
  399922
  401325
  401426
  416056
  420761
  421154
  423615
  426323
  431514
  431694
  437166
  443213
  447516
  447625
  448195
  451591
  454842
  456069
  458017
  461423
  463945
  464584
  465613
  465781
  466124
  468527
  470137
  470278
  473148
  473324
  473529
  473925
  478652
  480008
  481253
  485135
  487370
  489524
  491908
  497881
  498655
  502118
  503725
  512073
  512659
  513307
  513500
  521596
  521809
  522096
  524027
  524188
  524754
  524934
  527629
  531194
  546970
  552508
  555955
  561832
  565272
  569567
  574292
  574511
  595412
  598695
  603725
  611301
  618365
  619582
  621270
  624484
  625745
  626295
  626297
  628090
  651873
  652927
  654346
  670190
  677053
  680313
  685425
  695093
  698012
  701486
  704241
  711328
  717890
  722583
  723167
  724185
  727796
  730457
  733450
  742234
  742846
  747709
  750222
  750753
  761147
  764843
  765540
  766797
  769829
  771429
  772809
  774693
  784956
  786372
  794366
  798823
  805110
  806046
  812077
  813566
  826154
  827221
]
14.94 ms
(10.28%)
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
  805110
  761147
  401325
  512659
  448195
  487370
  531194
  628090
  423615
  465613
  431514
  470278
  512073
  401426
  447516
  546970
  561832
  680313
  595412
  618365
  598695
  603725
  451591
  470137
  473925
  461423
  464584
  399922
  420761
  431694
  463945
  473148
  478652
  416056
  443213
  502118
  503725
  513307
  524027
  485135
  489524
  491908
  497881
  723167
  750222
  695093
  626295
  806046
  786372
  742846
  764843
  730457
  765540
  771429
  750753
  724185
  619582
  812077
  727796
  456069
  426323
  521596
  527629
  565272
  677053
  701486
  711328
  698012
  552508
  626297
  513500
  468527
  569567
  555955
  670190
  447625
  473324
  454842
  521809
  522096
  826154
  827221
  652927
  784956
  794366
  747709
  766797
  742234
  437166
  611301
  481253
  458017
  733450
  704241
  798823
  651873
  722583
  772809
  769829
  524934
  574511
  621270
  473529
  480008
  465781
  524188
  524754
  574292
  498655
  421154
  717890
  654346
  625745
  774693
  373875
  396083
  466124
  624484
  813566
  685425
]
2.51 ms
(1.73%)
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
  373875
  396083
  399922
  401325
  401426
  416056
  420761
  421154
  423615
  426323
  431514
  431694
  437166
  443213
  447516
  447625
  448195
  451591
  454842
  456069
  458017
  461423
  463945
  464584
  465613
  465781
  466124
  468527
  470137
  470278
  473148
  473324
  473529
  473925
  478652
  480008
  481253
  485135
  487370
  489524
  491908
  497881
  498655
  502118
  503725
  512073
  512659
  513307
  513500
  521596
  521809
  522096
  524027
  524188
  524754
  524934
  527629
  531194
  546970
  552508
  555955
  561832
  565272
  569567
  574292
  574511
  595412
  598695
  603725
  611301
  618365
  619582
  621270
  624484
  625745
  626295
  626297
  628090
  651873
  652927
  654346
  670190
  677053
  680313
  685425
  695093
  698012
  701486
  704241
  711328
  717890
  722583
  723167
  724185
  727796
  730457
  733450
  742234
  742846
  747709
  750222
  750753
  761147
  764843
  765540
  766797
  769829
  771429
  772809
  774693
  784956
  786372
  794366
  798823
  805110
  806046
  812077
  813566
  826154
  827221
]
2.13 ms
(1.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм анал красивая"
]
2.03 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм анал красивая"
]
1.79 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил в попку красотке"
]
1.61 ms
(1.11%)
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.