Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.40 ms
(85.29%)
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
  382158
  384117
  392004
  398025
  398073
  414090
  414103
  414114
  414137
  414292
  416536
  416613
  416624
  416742
  417348
  421369
  429608
  429886
  443247
  446949
  447575
  452791
  452815
  452914
  453223
  455640
  460351
  465454
  466476
  466639
  468146
  469741
  470428
  471101
  473453
  475336
  482283
  487418
  487425
  493700
  505800
  507956
  510541
  511014
  519698
  519699
  519712
  529034
  530451
  530688
  531844
  532749
  532803
  542709
  544829
  547476
  548834
  548854
  550925
  553130
  559294
  561034
  564289
  564501
  573183
  574664
  576932
  581064
  587260
  589856
  590837
  594340
  595588
  597111
  598272
  602283
  614967
  624191
  636183
  642158
  656942
  663181
  664189
  669075
  670368
  673257
  695868
  697473
  702336
  713185
  726292
  730329
  740931
  743208
  744266
  745101
  749271
  750145
  751424
  751692
  752603
  752650
  752677
  752712
  761116
  763739
  766945
  770383
  776527
  777847
  782836
  783743
  792721
  799696
  799938
  814418
  814459
  814470
  819218
]
15.79 ms
(9.08%)
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
  468146
  455640
  465454
  531844
  511014
  475336
  544829
  452815
  382158
  702336
  642158
  783743
  766945
  743208
  745101
  750145
  799938
  453223
  466476
  414114
  519699
  530451
  530688
  493700
  751424
  819218
  573183
  398073
  414292
  542709
  414103
  561034
  695868
  669075
  670368
  763739
  564501
  782836
  752603
  752712
  414090
  416613
  470428
  574664
  576932
  466639
  519712
  594340
  814459
  452914
  469741
  663181
  673257
  776527
  782849
  726292
  751692
  505800
  510541
  507956
  429886
  392004
  446949
  416624
  487418
  595588
  740931
  548834
  664189
  697473
  553130
  799696
  744266
  749271
  761116
  547476
  581064
  550925
  602283
  597111
  730329
  471101
  443247
  564289
  417348
  792721
  398025
  770383
  416742
  416536
  529034
  590837
  752650
  752677
  587260
  460351
  452791
  429608
  624191
  482283
  421369
  447575
  473453
  414137
  384117
  519698
  814418
  814470
  532803
  532749
  487425
  548854
  559294
  656942
  713185
  636183
  589856
  614967
  598272
  777847
]
2.76 ms
(1.59%)
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
  382158
  384117
  392004
  398025
  398073
  414090
  414103
  414114
  414137
  414292
  416536
  416613
  416624
  416742
  417348
  421369
  429608
  429886
  443247
  446949
  447575
  452791
  452815
  452914
  453223
  455640
  460351
  465454
  466476
  466639
  468146
  469741
  470428
  471101
  473453
  475336
  482283
  487418
  487425
  493700
  505800
  507956
  510541
  511014
  519698
  519699
  519712
  529034
  530451
  530688
  531844
  532749
  532803
  542709
  544829
  547476
  548834
  548854
  550925
  553130
  559294
  561034
  564289
  564501
  573183
  574664
  576932
  581064
  587260
  589856
  590837
  594340
  595588
  597111
  598272
  602283
  614967
  624191
  636183
  642158
  656942
  663181
  664189
  669075
  670368
  673257
  695868
  697473
  702336
  713185
  726292
  730329
  740931
  743208
  744266
  745101
  749271
  750145
  751424
  751692
  752603
  752650
  752677
  752712
  761116
  763739
  766945
  770383
  776527
  777847
  782836
  783743
  792721
  799696
  799938
  814418
  814459
  814470
  819218
]
2.20 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal dildo girl"
]
1.89 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал дилд девушк"
]
1.48 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дилд девушк"
]
1.47 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.