Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.29 ms
(85.82%)
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
  161581
  382104
  385166
  385603
  385682
  386996
  392077
  395235
  398804
  399351
  399853
  405612
  408458
  408841
  414618
  417064
  418049
  418430
  420760
  423554
  424071
  426349
  429279
  431611
  434223
  437877
  442691
  442999
  443725
  445524
  452500
  457748
  462033
  464177
  465103
  466695
  472229
  472337
  472599
  475091
  480760
  482793
  483954
  484088
  487820
  489042
  489370
  505021
  505648
  505884
  508438
  510508
  511648
  512302
  514606
  516055
  516108
  517292
  524514
  527552
  534355
  550408
  553082
  555869
  559721
  560653
  561679
  561707
  566029
  571898
  572137
  572171
  573004
  573051
  573875
  573881
  573901
  574608
  588262
  591788
  606227
  607232
  611817
  634423
  642143
  658080
  668607
  675024
  682623
  683593
  683804
  701047
  713364
  714405
  716593
  720676
  736614
  736845
  738270
  744600
  756461
  758851
  758970
  779254
  780124
  784203
  784226
  792679
  792747
  796513
  816305
  818586
  819114
  819766
  820606
  821526
  822818
  827163
  827576
  828417
]
16.28 ms
(8.88%)
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
  429279
  472337
  405612
  443725
  464177
  472229
  505884
  510508
  516055
  489370
  487820
  489042
  505021
  505648
  517292
  524514
  483954
  484088
  516108
  560653
  559721
  573875
  573901
  574608
  683593
  161581
  392077
  642143
  611817
  796513
  756461
  758851
  738270
  634423
  792679
  423554
  417064
  442691
  465103
  414618
  452500
  508438
  821526
  822818
  827163
  827576
  607232
  466695
  511648
  588262
  457748
  514606
  779254
  386996
  434223
  571898
  550408
  553082
  561679
  561707
  555869
  566029
  385603
  385682
  382104
  820606
  818586
  819114
  816305
  819766
  828417
  527552
  472599
  658080
  675024
  758970
  736845
  385166
  572171
  573004
  573881
  668607
  713364
  572137
  573051
  606227
  462033
  591788
  534355
  683804
  720676
  682623
  701047
  716593
  784226
  792747
  784203
  744600
  714405
  780124
  395235
  418430
  736614
  398804
  408841
  424071
  431611
  512302
  420760
  399351
  399853
  418049
  426349
  437877
  442999
  408458
  482793
  475091
  480760
  445524
]
2.61 ms
(1.43%)
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
  161581
  382104
  385166
  385603
  385682
  386996
  392077
  395235
  398804
  399351
  399853
  405612
  408458
  408841
  414618
  417064
  418049
  418430
  420760
  423554
  424071
  426349
  429279
  431611
  434223
  437877
  442691
  442999
  443725
  445524
  452500
  457748
  462033
  464177
  465103
  466695
  472229
  472337
  472599
  475091
  480760
  482793
  483954
  484088
  487820
  489042
  489370
  505021
  505648
  505884
  508438
  510508
  511648
  512302
  514606
  516055
  516108
  517292
  524514
  527552
  534355
  550408
  553082
  555869
  559721
  560653
  561679
  561707
  566029
  571898
  572137
  572171
  573004
  573051
  573875
  573881
  573901
  574608
  588262
  591788
  606227
  607232
  611817
  634423
  642143
  658080
  668607
  675024
  682623
  683593
  683804
  701047
  713364
  714405
  716593
  720676
  736614
  736845
  738270
  744600
  756461
  758851
  758970
  779254
  780124
  784203
  784226
  792679
  792747
  796513
  816305
  818586
  819114
  819766
  820606
  821526
  822818
  827163
  827576
  828417
]
1.96 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"блондинка маленькие Ñ%…"
]
1.79 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая маленькая"
]
1.67 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.