Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.18 ms
(83.20%)
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
  77381
  290304
  341622
  390571
  393308
  410239
  411808
  415946
  417053
  418876
  423663
  432622
  432692
  433204
  433230
  433343
  434443
  441207
  441430
  445802
  446645
  448340
  452862
  462777
  465125
  466731
  467947
  468373
  482059
  483791
  493186
  495008
  497264
  497708
  500241
  511867
  512355
  513505
  514415
  517624
  524807
  528475
  538253
  540684
  543353
  543970
  544200
  545763
  547554
  548642
  548649
  549026
  549033
  550929
  551441
  553020
  554797
  555101
  555186
  555219
  555360
  555377
  555397
  555453
  555486
  555768
  556616
  556659
  557958
  558126
  558244
  560564
  561300
  562462
  563542
  563776
  564163
  568951
  571009
  571113
  574060
  578796
  580340
  591782
  594280
  595421
  597987
  603074
  614858
  615214
  615660
  620585
  626944
  627349
  637054
  637111
  651954
  666892
  666895
  669258
  684489
  685063
  690784
  710535
  712073
  712318
  728620
  730813
  740115
  752147
  757054
  762241
  775202
  785921
  794382
  795313
  796351
  800990
  802202
  804386
]
13.66 ms
(9.62%)
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
  637111
  594280
  595421
  465125
  441207
  448340
  483791
  524807
  417053
  445802
  497708
  558126
  390571
  433343
  462777
  512355
  514415
  497264
  545763
  666895
  553020
  684489
  467947
  468373
  540684
  511867
  517624
  528475
  555219
  543970
  544200
  555397
  571009
  554797
  556616
  563542
  563776
  669258
  690784
  561300
  615660
  591782
  620585
  796351
  740115
  441430
  452862
  493186
  555486
  555186
  555377
  578796
  555360
  562462
  411808
  410239
  466731
  551441
  543353
  548649
  290304
  513505
  558244
  666892
  614858
  547554
  557958
  549026
  482059
  615214
  626944
  685063
  804386
  794382
  651954
  500241
  580340
  341622
  432622
  538253
  495008
  550929
  555453
  555768
  564163
  568951
  571113
  555101
  574060
  710535
  712073
  712318
  549033
  556659
  597987
  603074
  775202
  802202
  785921
  795313
  800990
  757054
  728620
  730813
  752147
  762241
  627349
  637054
  560564
  548642
  434443
  393308
  77381
  418876
  423663
  432692
  433204
  433230
  415946
  446645
]
2.91 ms
(2.05%)
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
  77381
  290304
  341622
  390571
  393308
  410239
  411808
  415946
  417053
  418876
  423663
  432622
  432692
  433204
  433230
  433343
  434443
  441207
  441430
  445802
  446645
  448340
  452862
  462777
  465125
  466731
  467947
  468373
  482059
  483791
  493186
  495008
  497264
  497708
  500241
  511867
  512355
  513505
  514415
  517624
  524807
  528475
  538253
  540684
  543353
  543970
  544200
  545763
  547554
  548642
  548649
  549026
  549033
  550929
  551441
  553020
  554797
  555101
  555186
  555219
  555360
  555377
  555397
  555453
  555486
  555768
  556616
  556659
  557958
  558126
  558244
  560564
  561300
  562462
  563542
  563776
  564163
  568951
  571009
  571113
  574060
  578796
  580340
  591782
  594280
  595421
  597987
  603074
  614858
  615214
  615660
  620585
  626944
  627349
  637054
  637111
  651954
  666892
  666895
  669258
  684489
  685063
  690784
  710535
  712073
  712318
  728620
  730813
  740115
  752147
  757054
  762241
  775202
  785921
  794382
  795313
  796351
  800990
  802202
  804386
]
2.11 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма в дырку"
]
1.87 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в дырк"
]
1.66 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в дырк"
]
1.65 ms
(1.16%)
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.