Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.46 ms
(87.41%)
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
  479130
  566879
  582489
  588715
  599090
  601477
  604352
  606875
  609565
  613576
  615861
  620728
  620979
  621290
  621348
  622558
  630314
  635712
  637543
  638421
  638743
  638889
  641648
  647688
  656246
  656846
  657222
  661638
  666079
  668786
  668791
  676740
  678399
  684752
  684792
  688723
  689431
  692682
  693731
  693740
  701211
  703729
  705871
  707515
  710118
  712641
  715117
  716651
  718659
  719392
  720841
  720991
  723805
  724144
  724680
  726181
  726714
  729897
  731039
  732941
  733018
  734328
  735473
  737001
  738148
  739544
  741563
  745910
  746133
  746576
  747035
  748350
  751268
  751799
  754845
  754863
  754866
  755243
  759453
  761515
  761525
  762189
  762779
  764581
  765723
  765811
  767762
  767845
  768930
  770067
  771802
  771808
  772429
  773454
  773465
  779394
  780379
  784229
  785799
  786639
  787225
  787266
  788399
  791428
  792455
  793321
  793713
  794059
  794597
  795006
  795375
  795467
  796257
  796319
  796756
  804545
  805106
  807872
  808776
  812727
]
11.79 ms
(6.46%)
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
  762779
  621348
  701211
  692682
  621290
  731039
  746133
  746576
  770067
  707515
  582489
  604352
  719392
  676740
  606875
  805106
  787225
  804545
  705871
  693731
  768930
  638421
  599090
  780379
  786639
  751268
  726714
  666079
  637543
  784229
  737001
  761525
  668791
  668786
  724680
  723805
  771808
  479130
  566879
  656246
  684752
  620728
  601477
  794597
  724144
  733018
  732941
  793321
  689431
  684792
  710118
  647688
  678399
  693740
  720991
  615861
  588715
  620979
  635712
  622558
  638743
  792455
  812727
  779394
  791428
  794059
  796319
  726181
  761515
  787266
  795375
  795467
  745910
  755243
  767762
  767845
  729897
  738148
  739544
  754863
  762189
  764581
  703729
  716651
  796257
  807872
  613576
  688723
  712641
  638889
  734328
  759453
  772429
  796756
  754845
  754866
  748350
  735473
  771802
  656846
  661638
  657222
  641648
  630314
  788399
  785799
  795006
  751799
  765723
  773454
  773465
  747035
  765811
  718659
  720841
  609565
  793713
  741563
  715117
  808776
]
2.56 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мою жену трахает"
]
2.43 ms
(1.33%)
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
  479130
  566879
  582489
  588715
  599090
  601477
  604352
  606875
  609565
  613576
  615861
  620728
  620979
  621290
  621348
  622558
  630314
  635712
  637543
  638421
  638743
  638889
  641648
  647688
  656246
  656846
  657222
  661638
  666079
  668786
  668791
  676740
  678399
  684752
  684792
  688723
  689431
  692682
  693731
  693740
  701211
  703729
  705871
  707515
  710118
  712641
  715117
  716651
  718659
  719392
  720841
  720991
  723805
  724144
  724680
  726181
  726714
  729897
  731039
  732941
  733018
  734328
  735473
  737001
  738148
  739544
  741563
  745910
  746133
  746576
  747035
  748350
  751268
  751799
  754845
  754863
  754866
  755243
  759453
  761515
  761525
  762189
  762779
  764581
  765723
  765811
  767762
  767845
  768930
  770067
  771802
  771808
  772429
  773454
  773465
  779394
  780379
  784229
  785799
  786639
  787225
  787266
  788399
  791428
  792455
  793321
  793713
  794059
  794597
  795006
  795375
  795467
  796257
  796319
  796756
  804545
  805106
  807872
  808776
  812727
]
2.33 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.09 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мо жен секс"
]
1.77 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.