Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.30 ms
(86.66%)
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
  408590
  441814
  461132
  517671
  522166
  527332
  529753
  530932
  539672
  539954
  540285
  542039
  542673
  544965
  546836
  547592
  553680
  553807
  556583
  559790
  560890
  565116
  565117
  576193
  576426
  576483
  579288
  595963
  599776
  617541
  617688
  618278
  626174
  627200
  627941
  628686
  630961
  631265
  637608
  652958
  653304
  655620
  657561
  658719
  660577
  665048
  669920
  670318
  670448
  671239
  679701
  680278
  697223
  700081
  700237
  702988
  717437
  720482
  722952
  729315
  731572
  733363
  734360
  735798
  739734
  740253
  740506
  742225
  742745
  743164
  743234
  745059
  749045
  749561
  750351
  754153
  754423
  754568
  759039
  759697
  761473
  762889
  767929
  769093
  770931
  774567
  774751
  777877
  779649
  780414
  782998
  783168
  783787
  785221
  785994
  786069
  786336
  787113
  788506
  788658
  791350
  791568
  792918
  793477
  796638
  797232
  797305
  799822
  800957
  802924
  803791
  803798
  805065
  805394
  807242
  809920
  810163
  811901
  812730
]
12.54 ms
(7.33%)
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
  599776
  626174
  628686
  595963
  627941
  617541
  777877
  779649
  780414
  785994
  791568
  793477
  799822
  774567
  774751
  785221
  786069
  796638
  797232
  800957
  803791
  803798
  805394
  807242
  809920
  812730
  733363
  742225
  743164
  749045
  754153
  754568
  764302
  767929
  783787
  786336
  787113
  788658
  797305
  802924
  810163
  811901
  729315
  731572
  740506
  749561
  734360
  735798
  740253
  742745
  750351
  754423
  759039
  770931
  739734
  743234
  745059
  762889
  769093
  759697
  761473
  617688
  618278
  627200
  630961
  631265
  637608
  700081
  722952
  782998
  783168
  788506
  791350
  792918
  805065
  408590
  441814
  461132
  539672
  540285
  517671
  522166
  530932
  527332
  529753
  539954
  542039
  546836
  553680
  553807
  556583
  565116
  576426
  576483
  579288
  542673
  544965
  565117
  576193
  547592
  559790
  560890
  653304
  657561
  658719
  660577
  669920
  670318
  670448
  680278
  700237
  717437
  720482
  652958
  655620
  665048
  671239
  679701
  697223
  702988
]
2.93 ms
(1.71%)
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
  408590
  441814
  461132
  517671
  522166
  527332
  529753
  530932
  539672
  539954
  540285
  542039
  542673
  544965
  546836
  547592
  553680
  553807
  556583
  559790
  560890
  565116
  565117
  576193
  576426
  576483
  579288
  595963
  599776
  617541
  617688
  618278
  626174
  627200
  627941
  628686
  630961
  631265
  637608
  652958
  653304
  655620
  657561
  658719
  660577
  665048
  669920
  670318
  670448
  671239
  679701
  680278
  697223
  700081
  700237
  702988
  717437
  720482
  722952
  729315
  731572
  733363
  734360
  735798
  739734
  740253
  740506
  742225
  742745
  743164
  743234
  745059
  749045
  749561
  750351
  754153
  754423
  754568
  759039
  759697
  761473
  762889
  767929
  769093
  770931
  774567
  774751
  777877
  779649
  780414
  782998
  783168
  783787
  785221
  785994
  786069
  786336
  787113
  788506
  788658
  791350
  791568
  792918
  793477
  796638
  797232
  797305
  799822
  800957
  802924
  803791
  803798
  805065
  805394
  807242
  809920
  810163
  811901
  812730
]
2.12 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "играли"
]
1.90 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "игра"
]
1.80 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.90%)
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.