Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.13 ms
(85.30%)
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
  405705
  428695
  432716
  441788
  445145
  450104
  452961
  456046
  467936
  477543
  485995
  493761
  508962
  529909
  535637
  540844
  540983
  541678
  542573
  548992
  548996
  553045
  558592
  564344
  576241
  577625
  579412
  581061
  581403
  590736
  597632
  604362
  604658
  607928
  619974
  632155
  636238
  647105
  655186
  655281
  656242
  656522
  658837
  695908
  696128
  697545
  700031
  704178
  705348
  707181
  717885
  719454
  719916
  723236
  725018
  725237
  730361
  733952
  736218
  756884
  760454
  761126
  761766
  763503
  763510
  764820
  765388
  765449
  765584
  767043
  767069
  767071
  767086
  767102
  767599
  768353
  768735
  769043
  769883
  771338
  773417
  773903
  773916
  775547
  775575
  775701
  777652
  782032
  783364
  784756
  787611
  788857
  790939
  791534
  791729
  791848
  792183
  792678
  793396
  794922
  795122
  796897
  800761
  802754
  802769
  807099
  812902
  812985
  817181
  817279
  821807
  823745
  824083
  824782
  824848
  825636
  826728
  827357
]
14.57 ms
(8.62%)
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
  733952
  717885
  535637
  508962
  696128
  581403
  564344
  705348
  707181
  485995
  736218
  764820
  783364
  477543
  432716
  493761
  548992
  792183
  769883
  450104
  821807
  823745
  826728
  827357
  824083
  824782
  825636
  540983
  775547
  775701
  790939
  791729
  756884
  767599
  773916
  791848
  793396
  794922
  800761
  768353
  725237
  768735
  767069
  719916
  775575
  782032
  428695
  452961
  784756
  541678
  581061
  647105
  656242
  655186
  607928
  619974
  632155
  590736
  604362
  700031
  824848
  445145
  817181
  817279
  542573
  802754
  761766
  795122
  802769
  763503
  771338
  807099
  812902
  812985
  695908
  704178
  604658
  597632
  441788
  540844
  548996
  576241
  719454
  723236
  658837
  655281
  636238
  788857
  796897
  787611
  791534
  792678
  766050
  725018
  761126
  763510
  730361
  765449
  765584
  767043
  767071
  767102
  769043
  767086
  773417
  773903
  771893
  697545
  777652
  456046
  467936
  553045
  558592
  405705
  529909
  577625
  656522
  579412
  760454
  765388
]
3.12 ms
(1.84%)
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
  405705
  428695
  432716
  441788
  445145
  450104
  452961
  456046
  467936
  477543
  485995
  493761
  508962
  529909
  535637
  540844
  540983
  541678
  542573
  548992
  548996
  553045
  558592
  564344
  576241
  577625
  579412
  581061
  581403
  590736
  597632
  604362
  604658
  607928
  619974
  632155
  636238
  647105
  655186
  655281
  656242
  656522
  658837
  695908
  696128
  697545
  700031
  704178
  705348
  707181
  717885
  719454
  719916
  723236
  725018
  725237
  730361
  733952
  736218
  756884
  760454
  761126
  761766
  763503
  763510
  764820
  765388
  765449
  765584
  767043
  767069
  767071
  767086
  767102
  767599
  768353
  768735
  769043
  769883
  771338
  773417
  773903
  773916
  775547
  775575
  775701
  777652
  782032
  783364
  784756
  787611
  788857
  790939
  791534
  791729
  791848
  792183
  792678
  793396
  794922
  795122
  796897
  800761
  802754
  802769
  807099
  812902
  812985
  817181
  817279
  821807
  823745
  824083
  824782
  824848
  825636
  826728
  827357
]
1.97 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade anal pov"
]
1.79 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск анал пов"
]
1.58 ms
(0.94%)
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.