Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.22 ms
(85.54%)
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
  95873
  188621
  391255
  391596
  392109
  396424
  407298
  411507
  423518
  429508
  443903
  458346
  468717
  476838
  478541
  479067
  479087
  492689
  501178
  508720
  516646
  525691
  530289
  531860
  537005
  537104
  539018
  542513
  543688
  545077
  545090
  545106
  547939
  547980
  551319
  559889
  561628
  562588
  562591
  589739
  591170
  592708
  593075
  596404
  604985
  613885
  614220
  630754
  635514
  638542
  641052
  646240
  647606
  650667
  650786
  650815
  651259
  651310
  651423
  653628
  653634
  653807
  654225
  654256
  654291
  659391
  661889
  681002
  681022
  681117
  681159
  688100
  690885
  694555
  696167
  707306
  709640
  710263
  719852
  721072
  721113
  731032
  732597
  732652
  733020
  733071
  734375
  734844
  740124
  742452
  748436
  749639
  761504
  770840
  773947
  776528
  782783
  789708
  789961
  790386
  794837
  799262
  799977
  800007
  800915
  801899
  803348
  805304
  805565
  808074
  811795
  814946
  815799
  815961
  817190
  817341
  820765
  824228
  828758
  828865
]
14.61 ms
(8.67%)
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
  543688
  650667
  545106
  559889
  800007
  805304
  773947
  748436
  591170
  817341
  814946
  539018
  562588
  646240
  650815
  653634
  653628
  694555
  789708
  749639
  732597
  733020
  770840
  776528
  789961
  476838
  824228
  828865
  530289
  537005
  537104
  516646
  479067
  547980
  562591
  651423
  681117
  653807
  681022
  688100
  654256
  681002
  681159
  696167
  551319
  561628
  613885
  638542
  592708
  593075
  630754
  589739
  604985
  782783
  803348
  811795
  731032
  734375
  734844
  732652
  740124
  800915
  468717
  478541
  458346
  411507
  654291
  614220
  742452
  407298
  391255
  391596
  542513
  690885
  641052
  799977
  801899
  733071
  820765
  654225
  710263
  545077
  790386
  808074
  794837
  828758
  531860
  635514
  761504
  501178
  508720
  423518
  479087
  492689
  525691
  443903
  707306
  799262
  659391
  188621
  709640
  721072
  429508
  817190
  547939
  596404
  805565
  392109
  95873
  396424
  815799
  815961
  545090
  647606
  650786
  661889
  721113
  651259
  651310
  719852
]
2.87 ms
(1.70%)
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
  95873
  188621
  391255
  391596
  392109
  396424
  407298
  411507
  423518
  429508
  443903
  458346
  468717
  476838
  478541
  479067
  479087
  492689
  501178
  508720
  516646
  525691
  530289
  531860
  537005
  537104
  539018
  542513
  543688
  545077
  545090
  545106
  547939
  547980
  551319
  559889
  561628
  562588
  562591
  589739
  591170
  592708
  593075
  596404
  604985
  613885
  614220
  630754
  635514
  638542
  641052
  646240
  647606
  650667
  650786
  650815
  651259
  651310
  651423
  653628
  653634
  653807
  654225
  654256
  654291
  659391
  661889
  681002
  681022
  681117
  681159
  688100
  690885
  694555
  696167
  707306
  709640
  710263
  719852
  721072
  721113
  731032
  732597
  732652
  733020
  733071
  734375
  734844
  740124
  742452
  748436
  749639
  761504
  770840
  773947
  776528
  782783
  789708
  789961
  790386
  794837
  799262
  799977
  800007
  800915
  801899
  803348
  805304
  805565
  808074
  811795
  814946
  815799
  815961
  817190
  817341
  820765
  824228
  828758
  828865
]
2.02 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mmf milf"
]
1.72 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро milf"
]
1.59 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мжм секс втро milf"
]
1.57 ms
(0.93%)
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.