Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.73 ms
(83.84%)
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
  389630
  401807
  402730
  404193
  424083
  424155
  424197
  428039
  429961
  432552
  435378
  439729
  441420
  441499
  441503
  441584
  441595
  443877
  443920
  443939
  444859
  447095
  448392
  451299
  451514
  451529
  453640
  456701
  459636
  460411
  464895
  465781
  465934
  474266
  479178
  482193
  483903
  484057
  484318
  486046
  488959
  490952
  493145
  494818
  499868
  512458
  516478
  522021
  533745
  534506
  535627
  535993
  536422
  537980
  548969
  557971
  571401
  588902
  592425
  594554
  595513
  619339
  620907
  625580
  628257
  639924
  641792
  648400
  648674
  656291
  680291
  684400
  685434
  685810
  686558
  687810
  688722
  689933
  694660
  695766
  709528
  710854
  712603
  730383
  731313
  734970
  742742
  743507
  743961
  748801
  761787
  762085
  762969
  765939
  767804
  768000
  776048
  777633
  778095
  778643
  779665
  780849
  781101
  781107
  791246
  791518
  793957
  794116
  794773
  794932
  795528
  796252
  810354
  813181
  818051
  819749
]
13.37 ms
(9.44%)
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
  818051
  819749
  685810
  656291
  592425
  794932
  734970
  721975
  779665
  794773
  424155
  432552
  429961
  499868
  533745
  451514
  536422
  424083
  443920
  490952
  465781
  594554
  484057
  401807
  451529
  465934
  424197
  516478
  493145
  537980
  441595
  443877
  479178
  484318
  486046
  571401
  441420
  441584
  402730
  428039
  435378
  451299
  456701
  459636
  439729
  441503
  453640
  512458
  483903
  781101
  488959
  404193
  482193
  557971
  494818
  768000
  460411
  464895
  743507
  765939
  731313
  761787
  748801
  778643
  648400
  765549
  810354
  447095
  444859
  441499
  641792
  791246
  743961
  730383
  742742
  827870
  767804
  813181
  791816
  762085
  694660
  762969
  389630
  448392
  639924
  522021
  443939
  474266
  535993
  534506
  535627
  686558
  712603
  684400
  687810
  688722
  689933
  695766
  709528
  710854
  648674
  680291
  685434
  548969
  628257
  588902
  620907
  595513
  619339
  625580
  778095
  780849
  793957
  794116
  776048
  777633
  781107
  791518
  795528
  796252
]
2.36 ms
(1.67%)
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
  389630
  401807
  402730
  404193
  424083
  424155
  424197
  428039
  429961
  432552
  435378
  439729
  441420
  441499
  441503
  441584
  441595
  443877
  443920
  443939
  444859
  447095
  448392
  451299
  451514
  451529
  453640
  456701
  459636
  460411
  464895
  465781
  465934
  474266
  479178
  482193
  483903
  484057
  484318
  486046
  488959
  490952
  493145
  494818
  499868
  512458
  516478
  522021
  533745
  534506
  535627
  535993
  536422
  537980
  548969
  557971
  571401
  588902
  592425
  594554
  595513
  619339
  620907
  625580
  628257
  639924
  641792
  648400
  648674
  656291
  680291
  684400
  685434
  685810
  686558
  687810
  688722
  689933
  694660
  695766
  709528
  710854
  712603
  730383
  731313
  734970
  742742
  743507
  743961
  748801
  761787
  762085
  762969
  765939
  767804
  768000
  776048
  777633
  778095
  778643
  779665
  780849
  781101
  781107
  791246
  791518
  793957
  794116
  794773
  794932
  795528
  796252
  810354
  813181
  818051
  819749
]
2.29 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian anal wife"
]
1.94 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал жен"
]
1.35 ms
(0.95%)
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.