Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.85 ms
(51.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
162.10 ms
(41.12%)
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
  12792
  396628
  401966
  407760
  408365
  408413
  411704
  453559
  453712
  464456
  469910
  472223
  510586
  519683
  529284
  546120
  558320
  566981
  588581
  595451
  596585
  600384
  606277
  608352
  609780
  610174
  611813
  614849
  620399
  620912
  621418
  622622
  623473
  626539
  630015
  631980
  635228
  644194
  644660
  644698
  645980
  646939
  648504
  649161
  662222
  663321
  663934
  664274
  664840
  665476
  666754
  666848
  667015
  667525
  668524
  669593
  671640
  673607
  674055
  675424
  678947
  686792
  693322
  694188
  694436
  705263
  709369
  712810
  714142
  715423
  717646
  718416
  721120
  721496
  726743
  726789
  727634
  728451
  729024
  731035
  732873
  733324
  733570
  735872
  743371
  746667
  746890
  748392
  758295
  759609
  760991
  761576
  763887
  765996
  766026
  774508
  775139
  779135
  781708
  788573
  788735
  789603
  790858
  794829
  796967
  800708
  802649
  802836
  803295
  806246
  807733
  808015
  815713
  815778
  816455
  816784
  820346
  821560
  823436
  825054
]
18.03 ms
(4.57%)
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
  566981
  665476
  705263
  718416
  646939
  663934
  666848
  669593
  673607
  678947
  694436
  712810
  714142
  715423
  721496
  645980
  648504
  664274
  666754
  667015
  674055
  686792
  693322
  694188
  717646
  721120
  546120
  588581
  606277
  609780
  620399
  623473
  644194
  635228
  644660
  608352
  621418
  630015
  614849
  620912
  774508
  775139
  779135
  788735
  794829
  789603
  796967
  800708
  802649
  806246
  808015
  726743
  727634
  729024
  733570
  746667
  746890
  758295
  765996
  766026
  781708
  802836
  761576
  731035
  726789
  728451
  759609
  732873
  733324
  735872
  748392
  760991
  763887
  709369
  790858
  803295
  807733
  401966
  469910
  453712
  396628
  788573
  743371
  411704
  12792
  408413
  407760
  408365
  815778
  821560
  825054
  816784
  820346
  815713
  816455
  823436
  453559
  464456
  519683
  529284
  510586
  472223
  558320
  649161
  663321
  667525
  662222
  664840
  671640
  675424
  668524
  610174
  611813
  596585
  626539
  631980
  644698
  595451
  600384
  622622
]
2.52 ms
(0.64%)
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
  12792
  396628
  401966
  407760
  408365
  408413
  411704
  453559
  453712
  464456
  469910
  472223
  510586
  519683
  529284
  546120
  558320
  566981
  588581
  595451
  596585
  600384
  606277
  608352
  609780
  610174
  611813
  614849
  620399
  620912
  621418
  622622
  623473
  626539
  630015
  631980
  635228
  644194
  644660
  644698
  645980
  646939
  648504
  649161
  662222
  663321
  663934
  664274
  664840
  665476
  666754
  666848
  667015
  667525
  668524
  669593
  671640
  673607
  674055
  675424
  678947
  686792
  693322
  694188
  694436
  705263
  709369
  712810
  714142
  715423
  717646
  718416
  721120
  721496
  726743
  726789
  727634
  728451
  729024
  731035
  732873
  733324
  733570
  735872
  743371
  746667
  746890
  748392
  758295
  759609
  760991
  761576
  763887
  765996
  766026
  774508
  775139
  779135
  781708
  788573
  788735
  789603
  790858
  794829
  796967
  800708
  802649
  802836
  803295
  806246
  807733
  808015
  815713
  815778
  816455
  816784
  820346
  821560
  823436
  825054
]
2.46 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп young"
]
2.16 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп young"
]
2.13 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass young"
]

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.