Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.90 ms
(86.55%)
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
  197736
  233029
  381757
  382692
  385999
  386648
  387510
  388200
  390455
  390573
  392563
  393507
  394208
  397883
  397887
  398562
  400820
  400858
  401204
  411897
  416236
  424658
  425321
  439778
  440868
  443292
  448996
  452308
  458011
  459638
  462607
  465376
  466228
  467114
  468341
  469579
  469609
  477589
  477983
  477986
  478362
  479043
  479134
  483374
  484638
  484735
  484763
  485271
  490430
  493185
  495223
  497506
  499359
  506076
  512100
  513641
  514353
  531970
  535436
  537109
  537985
  556341
  557971
  560430
  561042
  563096
  565625
  569149
  571144
  578427
  584073
  589608
  591971
  593842
  604302
  612872
  619531
  620113
  638585
  660061
  665461
  682811
  693325
  704264
  709528
  712215
  716296
  717664
  719898
  720264
  721983
  725197
  727499
  727863
  729819
  729891
  731259
  740844
  759904
  761188
  763914
  770127
  772740
  774384
  774766
  781995
  794897
  796252
  801259
  802147
  802157
  807335
  815819
  816609
  816876
  817308
  818438
  824584
  825114
]
12.89 ms
(7.60%)
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
  490430
  824584
  557971
  589608
  411897
  479043
  477986
  390455
  394208
  233029
  386648
  387510
  381757
  816876
  815819
  818438
  612872
  774384
  385999
  499359
  560430
  382692
  816609
  827870
  459638
  497506
  537109
  537985
  578427
  660061
  682811
  717664
  709528
  716296
  620113
  638585
  591971
  604302
  796252
  772740
  727863
  731259
  759904
  729891
  740844
  761188
  763914
  704264
  794897
  197736
  425321
  443292
  466228
  400820
  477983
  439778
  493185
  484735
  485271
  535436
  393507
  561042
  388200
  398562
  817308
  802147
  774766
  584073
  468341
  424658
  477589
  469579
  556341
  397887
  452308
  495223
  512100
  513641
  469609
  390573
  416236
  401204
  825114
  484763
  462607
  467114
  458011
  483374
  531970
  506076
  514353
  563096
  569149
  571144
  719898
  693325
  721983
  665461
  720264
  565625
  593842
  781995
  801259
  807335
  725197
  802157
  729819
  727499
  770127
  619531
  712215
  397883
  478362
  400858
  479134
  448996
  392563
  440868
  465376
  484638
]
3.33 ms
(1.96%)
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
  197736
  233029
  381757
  382692
  385999
  386648
  387510
  388200
  390455
  390573
  392563
  393507
  394208
  397883
  397887
  398562
  400820
  400858
  401204
  411897
  416236
  424658
  425321
  439778
  440868
  443292
  448996
  452308
  458011
  459638
  462607
  465376
  466228
  467114
  468341
  469579
  469609
  477589
  477983
  477986
  478362
  479043
  479134
  483374
  484638
  484735
  484763
  485271
  490430
  493185
  495223
  497506
  499359
  506076
  512100
  513641
  514353
  531970
  535436
  537109
  537985
  556341
  557971
  560430
  561042
  563096
  565625
  569149
  571144
  578427
  584073
  589608
  591971
  593842
  604302
  612872
  619531
  620113
  638585
  660061
  665461
  682811
  693325
  704264
  709528
  712215
  716296
  717664
  719898
  720264
  721983
  725197
  727499
  727863
  729819
  729891
  731259
  740844
  759904
  761188
  763914
  770127
  772740
  774384
  774766
  781995
  794897
  796252
  801259
  802147
  802157
  807335
  815819
  816609
  816876
  817308
  818438
  824584
  825114
]
1.78 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature mother"
]
1.70 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature мам женщин"
]
1.57 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature мам женщин"
]
1.55 ms
(0.92%)
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.