Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.41 ms
(80.19%)
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
  51972
  365871
  391468
  391959
  397397
  417293
  420877
  421618
  422185
  424096
  427091
  427186
  427204
  427207
  429960
  432738
  433614
  435376
  439012
  439727
  441527
  441535
  441562
  441587
  443902
  443905
  444338
  444932
  448080
  450684
  454163
  456558
  457137
  458083
  458138
  459659
  460773
  461619
  462019
  462352
  462985
  463328
  465522
  468338
  468363
  470683
  471643
  472075
  473932
  475968
  481824
  483901
  486209
  486365
  487682
  490846
  493681
  496733
  498638
  503292
  503499
  503756
  505252
  506470
  526465
  530289
  533673
  533734
  543540
  544161
  569573
  579210
  580242
  588916
  589608
  598088
  605829
  643590
  655150
  660466
  663166
  685466
  685524
  688939
  728247
  733661
  734330
  735330
  745716
  766670
  766885
  767973
  768042
  777575
  779005
  782294
  782991
  784162
  786093
  786493
  789099
  790488
  792455
  793064
  794070
  794360
  794368
  794896
  796526
  798688
  799914
  803242
  804814
  809885
  826127
  827432
  828555
]
17.19 ms
(11.95%)
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
  487682
  439727
  828555
  493681
  643590
  799914
  804814
  793064
  391468
  483901
  391959
  463328
  803242
  472075
  397397
  503292
  503499
  794309
  744999
  827432
  735330
  429960
  543540
  365871
  468363
  544161
  688939
  660466
  605829
  792455
  777575
  779005
  784162
  798688
  782991
  766885
  782294
  794070
  461619
  470683
  471643
  481824
  533734
  663166
  443902
  526465
  490846
  794896
  498638
  450684
  433614
  444338
  794368
  441562
  673919
  685466
  685524
  796526
  786093
  733661
  768042
  417293
  766670
  786493
  427186
  51972
  530289
  789099
  794360
  460773
  458083
  465522
  589608
  598088
  468338
  456558
  505252
  435376
  441527
  588916
  444932
  432738
  443905
  826127
  486209
  427204
  728247
  421618
  441535
  441587
  454163
  462985
  569573
  448080
  457137
  458138
  506470
  767973
  439012
  580242
  503756
  424096
  473932
  475968
  462019
  579210
  462352
  496733
  734330
  422185
  486365
  790488
  420877
  533673
  655150
  745716
  809885
  427207
  427091
  459659
]
3.04 ms
(2.11%)
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
  51972
  365871
  391468
  391959
  397397
  417293
  420877
  421618
  422185
  424096
  427091
  427186
  427204
  427207
  429960
  432738
  433614
  435376
  439012
  439727
  441527
  441535
  441562
  441587
  443902
  443905
  444338
  444932
  448080
  450684
  454163
  456558
  457137
  458083
  458138
  459659
  460773
  461619
  462019
  462352
  462985
  463328
  465522
  468338
  468363
  470683
  471643
  472075
  473932
  475968
  481824
  483901
  486209
  486365
  487682
  490846
  493681
  496733
  498638
  503292
  503499
  503756
  505252
  506470
  526465
  530289
  533673
  533734
  543540
  544161
  569573
  579210
  580242
  588916
  589608
  598088
  605829
  643590
  655150
  660466
  663166
  685466
  685524
  688939
  728247
  733661
  734330
  735330
  745716
  766670
  766885
  767973
  768042
  777575
  779005
  782294
  782991
  784162
  786093
  786493
  789099
  790488
  792455
  793064
  794070
  794360
  794368
  794896
  796526
  798688
  799914
  803242
  804814
  809885
  826127
  827432
  828555
]
2.22 ms
(1.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.19 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал русской жены"
]
2.01 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал русск жен"
]
1.86 ms
(1.29%)
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.