Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.71 ms
(84.02%)
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
  417403
  417638
  424038
  424129
  424213
  427115
  429872
  432318
  433418
  435355
  435671
  437368
  438446
  438623
  438978
  439584
  440706
  444647
  445752
  445757
  447281
  449317
  455428
  457013
  462843
  475014
  476475
  478254
  479949
  479965
  483667
  493453
  495617
  505540
  510128
  519125
  520796
  522711
  524053
  536129
  543330
  551623
  552336
  552410
  552811
  553441
  555982
  556599
  556900
  558592
  561909
  563251
  563363
  564496
  565443
  565808
  565834
  571769
  573286
  575988
  579218
  580282
  581514
  582380
  584554
  590287
  590479
  592970
  596796
  599476
  601223
  601224
  601313
  605649
  608720
  611037
  615150
  616790
  618799
  619521
  621496
  628457
  648570
  650075
  672812
  682686
  682963
  685061
  692817
  696911
  704067
  704078
  707867
  713308
  721249
  740099
  741855
  744958
  751307
  764153
  766342
  777680
  779239
  780231
  780676
  781354
  781917
  782515
  784110
  784596
  787528
  787532
  788905
  791921
  792232
  799957
  803827
  816691
  816703
]
17.75 ms
(10.03%)
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
  682686
  692817
  713308
  682963
  581514
  601224
  608720
  590287
  592970
  601313
  621496
  601223
  618799
  605649
  478254
  524053
  556900
  558592
  563363
  582380
  552811
  561909
  563251
  590479
  424129
  427115
  438446
  435355
  437368
  417638
  429872
  439584
  417403
  455428
  479965
  449317
  493453
  495617
  424213
  816703
  707867
  648570
  784596
  779239
  780676
  787528
  787532
  784110
  803827
  764153
  766342
  696911
  475014
  447281
  476475
  479949
  445752
  483667
  505540
  552336
  580282
  616790
  599476
  799957
  628457
  444647
  438978
  510128
  519125
  522711
  433418
  435671
  816691
  520796
  536129
  543330
  553441
  555982
  565808
  565834
  551623
  564496
  573286
  552410
  565443
  584554
  685061
  721249
  650075
  704067
  704078
  672812
  556599
  571769
  575988
  579218
  611037
  615150
  619521
  596796
  624094
  777680
  780231
  781917
  792232
  781354
  740099
  782515
  741855
  751307
  744958
  788905
  791921
  424038
  432318
  440706
  445757
  438623
  457013
  462843
]
3.15 ms
(1.78%)
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
  417403
  417638
  424038
  424129
  424213
  427115
  429872
  432318
  433418
  435355
  435671
  437368
  438446
  438623
  438978
  439584
  440706
  444647
  445752
  445757
  447281
  449317
  455428
  457013
  462843
  475014
  476475
  478254
  479949
  479965
  483667
  493453
  495617
  505540
  510128
  519125
  520796
  522711
  524053
  536129
  543330
  551623
  552336
  552410
  552811
  553441
  555982
  556599
  556900
  558592
  561909
  563251
  563363
  564496
  565443
  565808
  565834
  571769
  573286
  575988
  579218
  580282
  581514
  582380
  584554
  590287
  590479
  592970
  596796
  599476
  601223
  601224
  601313
  605649
  608720
  611037
  615150
  616790
  618799
  619521
  621496
  628457
  648570
  650075
  672812
  682686
  682963
  685061
  692817
  696911
  704067
  704078
  707867
  713308
  721249
  740099
  741855
  744958
  751307
  764153
  766342
  777680
  779239
  780231
  780676
  781354
  781917
  782515
  784110
  784596
  787528
  787532
  788905
  791921
  792232
  799957
  803827
  816691
  816703
]
2.36 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian orgasm частное"
]
1.75 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск orgasm любительск"
]
1.67 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск orgasm любительск"
]

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.