Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.05 ms
(83.67%)
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
  383933
  385894
  398475
  401406
  401986
  406378
  412810
  414587
  445993
  446649
  446800
  449657
  452716
  455626
  456860
  458364
  459340
  461830
  461922
  463469
  465891
  468991
  474324
  477317
  479928
  482145
  484312
  497816
  498287
  500277
  501564
  503072
  503359
  512174
  513092
  520303
  521514
  525413
  525855
  530029
  536256
  538515
  552303
  552336
  563990
  569007
  569035
  575111
  581742
  585285
  587995
  589185
  590286
  590577
  594983
  601183
  601408
  603363
  604905
  605675
  609711
  612960
  618770
  625544
  626919
  627528
  629104
  633897
  639157
  644224
  650726
  650983
  676942
  692856
  703564
  707698
  708015
  711542
  715866
  716653
  728268
  729190
  729751
  731216
  734146
  737587
  752719
  753171
  756171
  757277
  758380
  758584
  758868
  762252
  766537
  769746
  770813
  771002
  775345
  777708
  778593
  782594
  785488
  793265
  793636
  794288
  802568
  804081
  806881
  809313
  809565
  809910
  810016
  810900
  813537
  820537
  822419
  823134
  823682
]
17.75 ms
(10.91%)
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
  456860
  398475
  463469
  477317
  446800
  500277
  603363
  521514
  605675
  590286
  612960
  383933
  412810
  446649
  459340
  482145
  484312
  538515
  497816
  503359
  513092
  468991
  563990
  569007
  552303
  552336
  581742
  707698
  711542
  650983
  715866
  650726
  708015
  604905
  629104
  589185
  594983
  601183
  639157
  644224
  778593
  757277
  769746
  385894
  461830
  461922
  449657
  501564
  530029
  692856
  633897
  585285
  775345
  813537
  756171
  771002
  810016
  753171
  627528
  601408
  455626
  525855
  664464
  587995
  401986
  401406
  822419
  820537
  823134
  823682
  474324
  452716
  458364
  525413
  536256
  498287
  520303
  512174
  569035
  575111
  676942
  625544
  590577
  609711
  618770
  626919
  777708
  782594
  793265
  806881
  809565
  809910
  729751
  734146
  758380
  785488
  802568
  804081
  810900
  737587
  752719
  758868
  729190
  762252
  766537
  728268
  731216
  758584
  770813
  703564
  716653
  793636
  794288
  809313
  465891
  479928
  414587
  406378
  445993
  503072
]
2.17 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm out"
]
2.14 ms
(1.32%)
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
  383933
  385894
  398475
  401406
  401986
  406378
  412810
  414587
  445993
  446649
  446800
  449657
  452716
  455626
  456860
  458364
  459340
  461830
  461922
  463469
  465891
  468991
  474324
  477317
  479928
  482145
  484312
  497816
  498287
  500277
  501564
  503072
  503359
  512174
  513092
  520303
  521514
  525413
  525855
  530029
  536256
  538515
  552303
  552336
  563990
  569007
  569035
  575111
  581742
  585285
  587995
  589185
  590286
  590577
  594983
  601183
  601408
  603363
  604905
  605675
  609711
  612960
  618770
  625544
  626919
  627528
  629104
  633897
  639157
  644224
  650726
  650983
  676942
  692856
  703564
  707698
  708015
  711542
  715866
  716653
  728268
  729190
  729751
  731216
  734146
  737587
  752719
  753171
  756171
  757277
  758380
  758584
  758868
  762252
  766537
  769746
  770813
  771002
  775345
  777708
  778593
  782594
  785488
  793265
  793636
  794288
  802568
  804081
  806881
  809313
  809565
  809910
  810016
  810900
  813537
  820537
  822419
  823134
  823682
]
1.64 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм out"
]
1.35 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм out"
]

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.