Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.91 ms
(86.35%)
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
  228737
  389912
  397953
  400368
  402022
  421518
  432235
  437121
  439683
  471610
  486933
  498856
  504008
  512483
  513809
  520287
  527035
  535775
  538879
  545294
  548425
  554140
  554151
  555878
  555940
  555945
  555947
  555952
  557206
  557870
  564243
  588105
  593619
  594553
  599515
  599639
  607017
  609423
  611284
  622412
  630904
  630913
  632918
  634730
  637613
  647390
  650490
  650498
  654494
  654602
  655733
  658769
  666477
  672258
  680675
  683303
  685051
  687324
  691170
  691514
  698488
  698583
  699678
  707506
  708674
  712409
  717614
  718305
  719131
  720595
  725401
  729055
  729553
  731511
  742739
  750581
  750852
  759303
  759667
  761822
  762059
  762414
  762449
  765384
  765898
  767991
  768085
  768586
  768790
  769125
  773945
  779312
  782054
  784288
  788376
  791208
  793589
  796523
  796730
  798960
  801094
  803471
  804721
  805283
  806403
  809050
  810838
  812288
  813072
  813489
  814910
  815325
  816710
  818010
  820061
  823177
  823403
  824123
  824158
  825102
]
17.11 ms
(8.65%)
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
  788376
  810838
  803471
  784288
  813489
  762449
  767991
  698583
  818010
  816710
  513809
  548425
  654602
  699678
  687324
  720595
  658769
  691514
  718305
  557206
  557870
  564243
  622412
  588105
  599515
  805283
  796730
  765898
  527035
  815325
  824123
  554151
  593619
  779312
  402022
  820061
  654494
  599639
  793589
  729553
  825102
  650490
  708674
  712409
  750581
  761822
  698488
  471610
  535775
  683303
  717614
  609423
  782054
  798960
  762059
  634730
  228737
  437121
  520287
  545294
  691170
  555952
  607017
  809050
  729055
  731511
  725401
  759303
  611284
  796523
  400368
  498856
  555940
  666477
  672258
  650498
  555878
  555945
  637613
  632918
  791208
  804721
  762414
  439683
  823177
  432235
  801094
  814910
  680675
  655733
  806403
  773945
  389912
  486933
  555947
  630904
  813072
  768790
  768085
  759667
  765384
  719131
  824158
  504008
  538879
  685051
  554140
  594553
  630913
  768586
  742739
  397953
  421518
  647390
  707506
  812288
  769125
  750852
  823403
  512483
]
3.11 ms
(1.57%)
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
  228737
  389912
  397953
  400368
  402022
  421518
  432235
  437121
  439683
  471610
  486933
  498856
  504008
  512483
  513809
  520287
  527035
  535775
  538879
  545294
  548425
  554140
  554151
  555878
  555940
  555945
  555947
  555952
  557206
  557870
  564243
  588105
  593619
  594553
  599515
  599639
  607017
  609423
  611284
  622412
  630904
  630913
  632918
  634730
  637613
  647390
  650490
  650498
  654494
  654602
  655733
  658769
  666477
  672258
  680675
  683303
  685051
  687324
  691170
  691514
  698488
  698583
  699678
  707506
  708674
  712409
  717614
  718305
  719131
  720595
  725401
  729055
  729553
  731511
  742739
  750581
  750852
  759303
  759667
  761822
  762059
  762414
  762449
  765384
  765898
  767991
  768085
  768586
  768790
  769125
  773945
  779312
  782054
  784288
  788376
  791208
  793589
  796523
  796730
  798960
  801094
  803471
  804721
  805283
  806403
  809050
  810838
  812288
  813072
  813489
  814910
  815325
  816710
  818010
  820061
  823177
  823403
  824123
  824158
  825102
]
2.01 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "watch sex"
]
1.69 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "watch секс"
]
1.59 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "watch секс"
]

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.