Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.64 ms
(91.26%)
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
  69956
  81214
  390827
  412136
  419253
  423384
  423606
  425641
  425916
  432641
  432702
  433925
  434848
  440390
  441845
  451074
  452450
  452812
  453268
  461757
  462180
  462868
  462899
  467022
  474442
  478111
  479656
  480829
  485818
  487443
  489894
  498340
  499964
  527321
  529136
  531100
  532985
  539213
  546582
  555253
  558865
  560275
  560288
  564999
  583456
  584112
  586268
  590402
  593557
  595314
  602862
  604144
  605283
  605871
  608037
  610163
  611006
  614842
  617953
  619650
  621433
  624194
  629585
  629593
  629665
  641318
  646270
  646942
  651344
  653047
  653245
  655159
  663754
  689028
  690250
  695319
  705729
  707175
  709672
  710941
  713580
  720443
  721854
  721885
  723716
  724102
  724103
  726052
  726232
  726960
  727972
  728369
  729337
  742072
  750247
  751252
  757576
  759747
  761680
  764280
  768078
  771332
  778288
  778931
  779558
  780125
  784220
  785789
  786778
  791101
  792050
  793830
  799164
  800611
  805259
  809898
  810352
  810787
  812596
  826181
]
12.02 ms
(4.84%)
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
  462899
  498340
  560288
  583456
  564999
  646270
  651344
  593557
  619650
  629665
  810787
  729337
  771332
  726960
  608037
  721854
  433925
  462868
  462180
  425641
  425916
  432641
  452450
  474442
  485818
  539213
  527321
  529136
  532985
  467022
  560275
  555253
  653047
  663754
  713580
  720443
  690250
  705729
  646942
  655159
  695319
  707175
  709672
  546582
  586268
  605871
  617953
  624194
  590402
  595314
  602862
  629593
  610163
  621433
  778288
  779558
  793830
  800611
  812596
  809898
  810352
  750247
  786778
  791101
  792050
  724103
  726052
  742072
  761680
  723716
  724102
  726232
  727972
  728369
  759747
  751252
  757576
  764280
  768078
  614842
  629585
  641318
  710941
  721885
  778931
  784220
  785789
  799164
  412136
  423606
  69956
  419253
  487443
  584112
  390827
  826181
  558865
  689028
  653245
  605283
  604144
  780125
  441845
  434848
  611006
  805259
  499964
  81214
  432702
  423384
  440390
  451074
  452812
  480829
  489894
  453268
  461757
  478111
  531100
  479656
]
2.86 ms
(1.15%)
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
  69956
  81214
  390827
  412136
  419253
  423384
  423606
  425641
  425916
  432641
  432702
  433925
  434848
  440390
  441845
  451074
  452450
  452812
  453268
  461757
  462180
  462868
  462899
  467022
  474442
  478111
  479656
  480829
  485818
  487443
  489894
  498340
  499964
  527321
  529136
  531100
  532985
  539213
  546582
  555253
  558865
  560275
  560288
  564999
  583456
  584112
  586268
  590402
  593557
  595314
  602862
  604144
  605283
  605871
  608037
  610163
  611006
  614842
  617953
  619650
  621433
  624194
  629585
  629593
  629665
  641318
  646270
  646942
  651344
  653047
  653245
  655159
  663754
  689028
  690250
  695319
  705729
  707175
  709672
  710941
  713580
  720443
  721854
  721885
  723716
  724102
  724103
  726052
  726232
  726960
  727972
  728369
  729337
  742072
  750247
  751252
  757576
  759747
  761680
  764280
  768078
  771332
  778288
  778931
  779558
  780125
  784220
  785789
  786778
  791101
  792050
  793830
  799164
  800611
  805259
  809898
  810352
  810787
  812596
  826181
]
1.96 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot ass"
]
1.73 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot жоп"
]
1.64 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot жоп"
]

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.