Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.21 ms
(86.18%)
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
  393462
  483669
  531273
  543538
  544158
  544321
  544534
  547862
  549252
  553702
  555332
  555342
  555464
  555649
  555781
  559260
  560122
  576579
  583643
  589633
  589644
  604303
  624419
  628658
  629612
  630212
  646664
  672824
  680619
  682612
  709368
  709945
  712665
  713181
  714330
  719916
  725431
  727259
  727565
  728261
  729917
  730084
  734380
  734965
  735944
  738602
  740289
  741514
  742565
  742797
  747104
  756070
  758304
  758701
  759299
  759933
  760921
  761038
  761072
  762774
  764180
  765376
  765686
  766220
  766601
  766635
  767095
  769838
  769935
  772997
  773912
  774511
  775701
  783369
  788603
  789400
  789595
  792539
  794351
  794359
  794363
  794710
  794765
  794855
  794873
  794908
  795706
  795927
  795947
  795964
  796001
  796050
  796285
  797057
  797073
  797097
  797208
  797521
  798730
  798814
  799701
  800388
  800612
  800636
  800800
  801294
  801306
  801436
  803709
  804705
  805214
  805651
  808175
  811555
  811948
  812905
  825688
]
11.10 ms
(6.72%)
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
  646664
  709945
  713181
  547862
  560122
  604303
  630212
  624419
  788603
  796050
  798730
  799701
  800636
  800800
  801294
  774511
  775701
  794873
  795706
  795947
  796285
  797521
  801306
  804705
  811948
  729917
  730084
  734380
  735944
  743671
  762774
  789595
  792539
  794363
  794765
  794855
  795927
  795964
  800612
  812905
  766220
  766601
  766635
  769935
  727259
  728261
  734965
  740289
  758701
  741514
  742797
  758304
  759933
  760921
  765376
  765549
  767095
  773912
  727565
  738602
  747104
  759299
  761038
  761072
  764180
  765686
  769838
  719916
  783369
  794351
  794359
  794908
  797097
  798814
  800388
  805651
  811555
  393462
  483669
  531273
  725431
  825688
  544158
  549252
  555342
  555464
  544321
  555332
  555649
  559260
  543538
  544534
  553702
  576579
  672824
  712665
  680619
  682612
  709368
  714330
  555781
  583643
  583788
  589633
  629612
  628658
  589644
  797057
  797073
  803709
  805214
  789400
  801436
  742565
  756070
  794710
  796001
  797208
  808175
  772997
]
4.42 ms
(2.68%)
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
  393462
  483669
  531273
  543538
  544158
  544321
  544534
  547862
  549252
  553702
  555332
  555342
  555464
  555649
  555781
  559260
  560122
  576579
  583643
  589633
  589644
  604303
  624419
  628658
  629612
  630212
  646664
  672824
  680619
  682612
  709368
  709945
  712665
  713181
  714330
  719916
  725431
  727259
  727565
  728261
  729917
  730084
  734380
  734965
  735944
  738602
  740289
  741514
  742565
  742797
  747104
  756070
  758304
  758701
  759299
  759933
  760921
  761038
  761072
  762774
  764180
  765376
  765686
  766220
  766601
  766635
  767095
  769838
  769935
  772997
  773912
  774511
  775701
  783369
  788603
  789400
  789595
  792539
  794351
  794359
  794363
  794710
  794765
  794855
  794873
  794908
  795706
  795927
  795947
  795964
  796001
  796050
  796285
  797057
  797073
  797097
  797208
  797521
  798730
  798814
  799701
  800388
  800612
  800636
  800800
  801294
  801306
  801436
  803709
  804705
  805214
  805651
  808175
  811555
  811948
  812905
  825688
]
2.25 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.15 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "как женщина кончает"
]
1.49 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин сперм"
]
1.41 ms
(0.86%)
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.