Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.60 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
  54149
  168297
  381859
  392544
  400102
  431724
  451631
  453284
  476652
  490778
  490787
  491131
  501333
  506568
  510354
  513451
  515315
  523349
  524847
  529260
  530170
  534509
  535189
  538044
  540357
  541642
  541780
  541962
  542331
  547127
  549420
  549550
  557009
  559830
  566299
  566818
  569365
  569774
  575408
  577838
  580115
  580600
  582518
  584196
  585357
  585490
  588217
  598270
  601421
  602775
  607802
  607903
  608085
  608466
  609895
  615256
  617994
  622477
  626571
  627981
  632496
  642175
  646111
  647229
  648736
  654228
  660970
  662481
  662803
  675037
  675630
  681538
  687126
  687366
  691614
  692548
  693267
  700223
  700268
  700377
  703019
  706799
  714209
  714933
  716126
  717442
  718284
  720182
  722296
  724590
  731123
  731503
  735064
  740633
  741273
  742319
  744102
  746286
  749786
  753543
  754276
  754476
  758589
  759809
  760922
  761271
  764087
  765995
  767003
  771903
  775652
  778096
  779027
  779055
  784416
  787482
  787816
  794688
  795443
  805213
]
16.08 ms
(8.93%)
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
  642175
  588217
  779055
  744102
  758589
  761271
  787482
  754276
  759809
  541642
  381859
  490787
  534509
  523349
  547127
  575408
  541962
  582518
  675630
  714933
  718284
  654228
  662803
  681538
  692548
  675037
  687366
  700223
  703019
  549550
  627981
  608085
  632496
  805213
  779027
  731123
  731503
  765995
  735064
  741273
  724590
  760922
  754476
  749786
  767003
  771903
  615256
  431724
  168297
  510354
  513451
  662481
  541780
  54149
  476652
  453284
  491131
  524847
  530170
  540357
  529260
  501333
  506568
  538044
  549420
  557009
  542331
  566299
  569774
  577838
  580115
  580600
  559830
  569365
  691614
  693267
  706799
  647229
  648736
  660970
  700268
  720182
  722296
  646111
  687126
  714209
  716126
  566818
  584196
  607903
  609895
  622477
  585357
  585490
  598270
  601421
  617994
  607802
  775652
  787816
  778096
  742319
  746286
  784416
  753543
  764087
  740633
  602775
  608466
  700377
  717442
  795443
  392544
  626571
  794688
  400102
  451631
  490778
  515315
  535189
]
2.56 ms
(1.42%)
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
  54149
  168297
  381859
  392544
  400102
  431724
  451631
  453284
  476652
  490778
  490787
  491131
  501333
  506568
  510354
  513451
  515315
  523349
  524847
  529260
  530170
  534509
  535189
  538044
  540357
  541642
  541780
  541962
  542331
  547127
  549420
  549550
  557009
  559830
  566299
  566818
  569365
  569774
  575408
  577838
  580115
  580600
  582518
  584196
  585357
  585490
  588217
  598270
  601421
  602775
  607802
  607903
  608085
  608466
  609895
  615256
  617994
  622477
  626571
  627981
  632496
  642175
  646111
  647229
  648736
  654228
  660970
  662481
  662803
  675037
  675630
  681538
  687126
  687366
  691614
  692548
  693267
  700223
  700268
  700377
  703019
  706799
  714209
  714933
  716126
  717442
  718284
  720182
  722296
  724590
  731123
  731503
  735064
  740633
  741273
  742319
  744102
  746286
  749786
  753543
  754276
  754476
  758589
  759809
  760922
  761271
  764087
  765995
  767003
  771903
  775652
  778096
  779027
  779055
  784416
  787482
  787816
  794688
  795443
  805213
]
2.36 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "стонет молодые"
]
1.92 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "стонет молодые"
]
1.89 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "стонет молодые"
]
1.69 ms
(0.94%)
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.