Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
242.51 ms
(90.42%)
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
  337134
  423959
  448078
  456831
  460485
  506312
  506444
  514346
  531573
  536268
  541547
  552092
  555642
  567008
  568350
  572713
  582469
  606280
  607253
  612488
  614821
  616771
  619360
  627927
  634737
  636261
  638145
  638173
  652665
  658553
  662074
  671472
  673462
  678608
  680611
  701200
  701509
  704977
  709323
  713271
  714286
  716634
  719780
  721252
  722086
  723123
  724550
  724697
  727614
  728814
  732582
  734037
  734294
  734343
  734356
  734856
  735463
  740072
  744522
  744766
  745610
  748335
  752176
  756947
  761397
  762970
  763579
  763589
  768126
  768363
  769350
  771159
  772922
  773829
  775621
  777479
  778797
  778959
  779036
  779228
  779636
  779895
  780002
  782774
  785944
  786421
  786999
  787576
  788596
  788979
  789154
  790829
  790952
  791049
  791491
  791494
  793383
  793682
  794481
  795412
  795492
  800273
  800628
  801057
  801129
  801595
  802976
  805054
  805621
  807008
  814993
  816810
  817727
  817938
  818623
  819189
  819335
  820646
  823170
  826538
]
14.79 ms
(5.51%)
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
  740072
  790829
  801057
  734356
  756947
  735463
  745610
  732582
  634737
  775621
  801595
  724550
  823170
  423959
  816810
  820646
  826538
  817727
  817938
  818623
  819189
  819335
  456831
  448078
  552092
  568350
  572713
  555642
  582469
  673462
  680611
  713271
  721252
  671472
  678608
  714286
  719780
  614821
  616771
  619360
  636261
  638173
  607253
  627927
  612488
  606280
  786999
  795412
  795492
  805054
  780002
  791494
  794481
  807008
  734343
  752176
  761397
  785944
  787576
  789154
  748335
  724697
  734856
  768126
  768363
  728814
  762970
  769350
  772922
  773829
  701200
  709323
  777479
  778797
  779036
  782774
  788979
  790952
  791049
  791491
  800273
  802976
  460485
  514346
  506312
  337134
  779636
  779895
  771159
  788596
  744522
  536268
  506444
  652665
  658553
  662074
  716634
  779228
  793383
  793682
  805621
  727614
  734037
  801129
  744766
  734294
  763589
  763579
  638145
  778959
  786421
  814993
  531573
  567008
  541547
  701509
  704977
  723123
  722086
  800628
]
2.81 ms
(1.05%)
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
  337134
  423959
  448078
  456831
  460485
  506312
  506444
  514346
  531573
  536268
  541547
  552092
  555642
  567008
  568350
  572713
  582469
  606280
  607253
  612488
  614821
  616771
  619360
  627927
  634737
  636261
  638145
  638173
  652665
  658553
  662074
  671472
  673462
  678608
  680611
  701200
  701509
  704977
  709323
  713271
  714286
  716634
  719780
  721252
  722086
  723123
  724550
  724697
  727614
  728814
  732582
  734037
  734294
  734343
  734356
  734856
  735463
  740072
  744522
  744766
  745610
  748335
  752176
  756947
  761397
  762970
  763579
  763589
  768126
  768363
  769350
  771159
  772922
  773829
  775621
  777479
  778797
  778959
  779036
  779228
  779636
  779895
  780002
  782774
  785944
  786421
  786999
  787576
  788596
  788979
  789154
  790829
  790952
  791049
  791491
  791494
  793383
  793682
  794481
  795412
  795492
  800273
  800628
  801057
  801129
  801595
  802976
  805054
  805621
  807008
  814993
  816810
  817727
  817938
  818623
  819189
  819335
  820646
  823170
  826538
]
2.23 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс face"
]
2.17 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck face"
]
1.96 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс face"
]

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.