Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.95 ms
(48.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov cum mouth"
]
202.56 ms
(45.90%)
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
  393218
  403434
  412687
  413869
  414390
  417283
  424520
  424830
  425745
  428764
  434810
  434936
  435538
  436490
  437242
  442634
  444934
  445682
  450787
  451506
  453838
  455861
  456507
  457276
  459603
  460457
  461782
  463725
  463741
  469500
  469969
  475996
  476499
  477849
  491017
  493276
  497232
  504631
  505359
  505869
  510088
  515320
  517316
  521002
  522714
  523793
  527300
  546572
  546742
  548815
  552332
  552368
  554501
  557740
  558325
  560814
  561281
  561912
  563104
  563555
  563674
  564008
  565654
  567635
  571106
  571375
  573291
  584450
  588060
  591207
  592263
  592703
  595751
  596865
  599360
  604856
  609756
  613443
  616995
  618137
  623948
  627281
  634229
  635041
  650134
  678901
  680572
  682259
  683490
  693564
  696753
  707616
  709763
  717943
  718958
  726067
  736570
  742011
  760476
  761436
  764247
  764627
  764654
  766903
  771068
  777172
  777914
  778671
  780932
  788828
  790079
  790610
  790844
  794090
  795954
  797340
  798351
  798503
  802682
  802762
]
18.13 ms
(4.11%)
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
  552368
  554501
  563674
  567635
  571106
  584450
  546742
  548815
  561281
  563104
  564008
  571375
  682259
  693564
  650134
  678901
  680572
  718958
  683490
  707616
  546572
  573291
  591207
  609756
  618137
  599360
  616995
  623948
  634229
  635041
  588060
  592703
  777914
  790844
  794090
  780932
  764247
  790079
  760476
  764627
  726067
  771068
  764654
  766903
  613443
  696753
  777172
  788828
  797340
  798351
  802762
  434810
  444934
  451506
  460457
  475996
  424520
  435538
  437242
  461782
  417283
  434936
  445682
  459603
  469969
  504631
  527300
  505359
  505869
  515320
  517316
  522714
  798503
  717943
  790610
  736570
  742011
  393218
  403434
  424830
  477849
  552332
  558325
  557740
  561912
  563555
  565654
  778671
  412687
  414390
  476499
  463741
  413869
  463725
  497232
  493276
  510088
  455861
  560814
  592263
  595751
  596865
  604856
  709763
  802682
  761436
  627281
  795954
  523793
  521002
  425745
  442634
  428764
  436490
  457276
  469500
  491017
  450787
  453838
  456507
]
2.69 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.25 ms
(0.51%)
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
  393218
  403434
  412687
  413869
  414390
  417283
  424520
  424830
  425745
  428764
  434810
  434936
  435538
  436490
  437242
  442634
  444934
  445682
  450787
  451506
  453838
  455861
  456507
  457276
  459603
  460457
  461782
  463725
  463741
  469500
  469969
  475996
  476499
  477849
  491017
  493276
  497232
  504631
  505359
  505869
  510088
  515320
  517316
  521002
  522714
  523793
  527300
  546572
  546742
  548815
  552332
  552368
  554501
  557740
  558325
  560814
  561281
  561912
  563104
  563555
  563674
  564008
  565654
  567635
  571106
  571375
  573291
  584450
  588060
  591207
  592263
  592703
  595751
  596865
  599360
  604856
  609756
  613443
  616995
  618137
  623948
  627281
  634229
  635041
  650134
  678901
  680572
  682259
  683490
  693564
  696753
  707616
  709763
  717943
  718958
  726067
  736570
  742011
  760476
  761436
  764247
  764627
  764654
  766903
  771068
  777172
  777914
  778671
  780932
  788828
  790079
  790610
  790844
  794090
  795954
  797340
  798351
  798503
  802682
  802762
]
2.05 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов cum mouth"
]
1.64 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов cum mouth"
]

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.