Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.22 ms
(83.48%)
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
  399598
  427147
  435403
  435568
  437368
  444647
  457071
  459190
  460754
  461653
  462231
  463688
  468255
  475014
  480336
  480662
  483691
  484880
  487676
  489377
  490272
  491183
  494864
  497719
  498303
  498483
  499059
  502982
  505281
  505336
  509430
  510051
  510729
  513615
  528222
  538977
  541649
  543330
  546153
  547751
  547756
  547758
  549554
  551896
  555020
  555967
  556004
  556599
  560409
  561228
  563649
  564744
  564745
  567022
  568065
  568075
  570115
  571726
  575287
  578349
  579038
  579426
  581502
  581514
  583021
  584105
  584817
  584907
  588525
  589509
  589683
  590507
  590528
  591247
  591394
  591799
  592355
  594513
  595088
  595178
  595891
  596235
  597075
  597091
  598564
  598741
  598953
  599528
  599803
  600458
  601529
  603759
  604342
  605117
  605867
  606439
  607879
  614979
  617047
  618799
  623744
  624167
  626089
  627670
  639460
  652921
  665600
  672812
  672831
  703969
  704078
  709510
  741699
  770410
  780251
  784681
  803039
  807244
  814434
]
18.23 ms
(10.27%)
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
  463688
  578349
  459190
  427147
  498303
  595088
  555967
  549554
  437368
  487676
  497719
  505336
  543330
  570115
  581514
  627670
  468255
  489377
  528222
  703969
  665600
  579426
  551896
  462231
  499059
  491183
  510051
  599803
  556004
  592355
  560409
  741699
  814434
  567022
  709510
  591799
  599528
  475014
  399598
  494864
  538977
  547751
  563649
  568075
  617047
  784681
  461653
  490272
  704078
  672812
  556599
  614979
  618799
  780251
  807244
  435568
  444647
  435403
  510729
  502982
  505281
  590528
  607879
  547756
  601529
  509430
  598953
  460754
  498483
  483691
  547758
  564745
  546153
  564744
  568065
  581502
  770410
  480336
  480662
  513615
  594513
  605867
  591394
  604342
  598564
  600458
  598741
  588525
  579038
  571726
  590507
  595178
  603759
  555020
  541649
  561228
  672831
  584817
  626089
  803039
  796642
  457071
  652921
  623744
  589509
  595891
  606439
  597091
  596235
  591247
  605117
  624167
  597075
  484880
  639460
  589683
  584105
  584907
  575287
  583021
]
4.24 ms
(2.39%)
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
  399598
  427147
  435403
  435568
  437368
  444647
  457071
  459190
  460754
  461653
  462231
  463688
  468255
  475014
  480336
  480662
  483691
  484880
  487676
  489377
  490272
  491183
  494864
  497719
  498303
  498483
  499059
  502982
  505281
  505336
  509430
  510051
  510729
  513615
  528222
  538977
  541649
  543330
  546153
  547751
  547756
  547758
  549554
  551896
  555020
  555967
  556004
  556599
  560409
  561228
  563649
  564744
  564745
  567022
  568065
  568075
  570115
  571726
  575287
  578349
  579038
  579426
  581502
  581514
  583021
  584105
  584817
  584907
  588525
  589509
  589683
  590507
  590528
  591247
  591394
  591799
  592355
  594513
  595088
  595178
  595891
  596235
  597075
  597091
  598564
  598741
  598953
  599528
  599803
  600458
  601529
  603759
  604342
  605117
  605867
  606439
  607879
  614979
  617047
  618799
  623744
  624167
  626089
  627670
  639460
  652921
  665600
  672812
  672831
  703969
  704078
  709510
  741699
  770410
  780251
  784681
  803039
  807244
  814434
]
2.34 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло оргазм-на-русском%…"
]
1.70 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло оргазм на русск"
]
1.46 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.77%)
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.