Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.96 ms
(84.97%)
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
  390144
  411688
  418559
  424801
  427935
  429912
  447785
  449011
  457267
  460138
  465951
  472445
  475220
  482798
  501892
  515213
  550640
  551627
  559195
  562331
  563842
  568384
  575905
  600316
  603436
  610179
  611346
  618568
  620768
  624241
  640698
  647595
  650665
  651190
  653794
  660273
  660963
  665208
  665681
  671381
  671400
  671626
  672175
  673595
  682047
  683870
  685718
  686047
  688010
  688024
  693077
  694028
  694029
  699023
  699611
  699617
  699804
  699808
  700426
  702453
  703089
  704560
  704726
  704735
  705739
  706269
  706290
  710318
  712826
  713532
  714508
  718160
  720823
  721109
  723175
  723580
  724181
  724934
  727898
  729618
  730299
  732040
  738772
  741275
  742449
  744265
  748349
  749266
  750876
  751457
  752162
  761073
  767859
  775788
  781990
  788315
  790888
  790957
  792614
  794656
  796970
  800331
  805023
  805045
  805279
  805601
  807506
  808176
  810701
  811930
  811938
  814506
  815170
  815594
  818172
  820971
  821859
  822693
  822932
  825598
]
16.94 ms
(9.41%)
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
  515213
  559195
  660963
  665681
  671400
  688010
  720823
  651190
  682047
  683870
  713532
  568384
  610179
  805023
  805601
  796970
  742449
  790957
  808176
  744265
  761073
  738772
  741275
  603436
  620768
  700426
  721109
  807506
  390144
  427935
  814506
  822693
  723580
  825598
  818172
  822932
  821859
  460138
  447785
  482798
  575905
  650665
  665208
  672175
  694029
  699023
  704560
  705739
  706269
  706290
  660273
  694028
  699611
  685718
  693077
  699804
  704726
  704735
  563842
  624241
  810701
  811938
  727898
  724934
  730299
  748349
  750876
  729618
  751457
  611346
  699617
  699808
  702453
  703089
  781990
  788315
  501892
  411688
  418559
  424801
  429912
  820971
  815170
  815594
  472445
  465951
  449011
  457267
  475220
  562331
  550640
  551627
  671626
  718160
  723175
  671381
  673595
  686047
  714508
  647595
  653794
  688024
  600316
  775788
  794656
  805045
  805279
  790888
  792614
  811930
  800331
  752162
  749266
  767859
  724181
  732040
  618568
  640698
  710318
  712826
]
2.29 ms
(1.27%)
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
  390144
  411688
  418559
  424801
  427935
  429912
  447785
  449011
  457267
  460138
  465951
  472445
  475220
  482798
  501892
  515213
  550640
  551627
  559195
  562331
  563842
  568384
  575905
  600316
  603436
  610179
  611346
  618568
  620768
  624241
  640698
  647595
  650665
  651190
  653794
  660273
  660963
  665208
  665681
  671381
  671400
  671626
  672175
  673595
  682047
  683870
  685718
  686047
  688010
  688024
  693077
  694028
  694029
  699023
  699611
  699617
  699804
  699808
  700426
  702453
  703089
  704560
  704726
  704735
  705739
  706269
  706290
  710318
  712826
  713532
  714508
  718160
  720823
  721109
  723175
  723580
  724181
  724934
  727898
  729618
  730299
  732040
  738772
  741275
  742449
  744265
  748349
  749266
  750876
  751457
  752162
  761073
  767859
  775788
  781990
  788315
  790888
  790957
  792614
  794656
  796970
  800331
  805023
  805045
  805279
  805601
  807506
  808176
  810701
  811930
  811938
  814506
  815170
  815594
  818172
  820971
  821859
  822693
  822932
  825598
]
2.13 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old man threesome"
]
1.85 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old мужчин секс втро"
]
1.72 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old мужчин секс втро"
]

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.