Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.11 ms
(82.86%)
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
  48153
  86510
  88945
  90091
  237886
  364775
  383792
  393863
  491301
  494903
  529347
  538035
  549305
  555198
  558428
  568999
  569213
  569535
  571202
  574765
  619569
  619686
  628803
  629780
  630377
  654198
  661957
  663356
  680049
  680936
  683282
  689801
  698936
  701311
  705977
  707581
  709337
  709714
  710378
  712667
  720333
  720841
  721751
  723635
  724661
  726128
  727262
  732028
  732940
  736297
  738543
  741456
  745867
  745882
  745887
  745903
  746306
  747251
  748838
  750743
  755242
  756878
  757382
  759847
  761938
  761957
  762981
  764716
  764874
  765387
  765718
  765936
  766142
  770204
  771101
  773667
  778500
  780877
  783440
  783909
  784165
  786961
  795786
  799067
  799167
  799856
  800439
  801197
  803209
  805939
  811192
  815145
  815244
  815403
  815407
  815551
  815701
  815780
  816202
  816927
  817738
  817741
  818542
  818584
  818935
  819998
  820400
  820994
  821304
  821682
  821729
  823505
  823916
  824042
  824135
  825216
  825314
  827972
  828193
  828335
]
11.06 ms
(7.69%)
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
  619569
  823916
  828193
  86510
  821729
  803209
  745903
  654198
  750743
  705977
  820994
  709337
  771101
  745882
  818542
  824135
  799167
  568999
  90091
  821682
  569535
  701311
  707581
  773667
  745867
  799067
  529347
  816202
  815780
  819998
  815407
  558428
  569213
  571202
  698936
  709714
  619686
  805939
  748838
  745887
  761938
  732028
  755242
  628803
  88945
  555198
  732940
  766142
  817738
  815701
  723635
  815145
  815551
  663356
  783440
  746306
  811192
  818584
  828335
  494903
  726128
  712667
  364775
  821304
  816927
  538035
  661957
  780877
  765387
  765936
  237886
  815244
  823505
  818935
  824042
  680049
  689801
  680936
  721751
  630377
  784165
  741456
  764716
  799856
  724661
  736297
  770204
  747251
  738543
  756878
  778500
  48153
  574765
  383792
  393863
  820400
  825216
  815403
  825314
  491301
  710378
  720333
  786961
  757382
  727262
  827972
  683282
  629780
  783909
  800439
  801197
  764874
  795786
  762981
  761957
  765718
  817741
  549305
  720841
  759847
]
5.16 ms
(3.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty секс"
]
3.18 ms
(2.21%)
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
  48153
  86510
  88945
  90091
  237886
  364775
  383792
  393863
  491301
  494903
  529347
  538035
  549305
  555198
  558428
  568999
  569213
  569535
  571202
  574765
  619569
  619686
  628803
  629780
  630377
  654198
  661957
  663356
  680049
  680936
  683282
  689801
  698936
  701311
  705977
  707581
  709337
  709714
  710378
  712667
  720333
  720841
  721751
  723635
  724661
  726128
  727262
  732028
  732940
  736297
  738543
  741456
  745867
  745882
  745887
  745903
  746306
  747251
  748838
  750743
  755242
  756878
  757382
  759847
  761938
  761957
  762981
  764716
  764874
  765387
  765718
  765936
  766142
  770204
  771101
  773667
  778500
  780877
  783440
  783909
  784165
  786961
  795786
  799067
  799167
  799856
  800439
  801197
  803209
  805939
  811192
  815145
  815244
  815403
  815407
  815551
  815701
  815780
  816202
  816927
  817738
  817741
  818542
  818584
  818935
  819998
  820400
  820994
  821304
  821682
  821729
  823505
  823916
  824042
  824135
  825216
  825314
  827972
  828193
  828335
]
1.80 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty sex"
]
1.78 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty секс"
]

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.