Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.91 ms
(60.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск минет оральн секс"
]
120.37 ms
(34.21%)
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
  48445
  169281
  220788
  270415
  271329
  326944
  339108
  395939
  398468
  398746
  401893
  479065
  527208
  529608
  533683
  545310
  550656
  550687
  553695
  557070
  559967
  563693
  568183
  579474
  583351
  584852
  586188
  588007
  594571
  607481
  613387
  624192
  631271
  644184
  647751
  648002
  653096
  681734
  691046
  692662
  692707
  692731
  698247
  700876
  700885
  701274
  706018
  713463
  715866
  717101
  717226
  717939
  719086
  724745
  728922
  729136
  729902
  730045
  734467
  736541
  739632
  744664
  747197
  748074
  760394
  761315
  763583
  763611
  763695
  766394
  768403
  769200
  769206
  769389
  774255
  774641
  775122
  775165
  782631
  783662
  787247
  788343
  791230
  794959
  795496
  795799
  796046
  798259
  803400
  803728
  805249
  805628
  808193
  817072
  817773
  818996
  819925
  823270
  823768
  823875
  823896
  824118
  824163
  824431
  824976
  825179
  825222
  825347
  825379
  825390
  825424
  825434
  826123
  826559
  826792
]
11.39 ms
(3.24%)
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
  583351
  747197
  760394
  825379
  798259
  805628
  825222
  825390
  825932
  729902
  825347
  826559
  715866
  825655
  787247
  586188
  788343
  719086
  774641
  220788
  270415
  824976
  579474
  700876
  692662
  805249
  748074
  724745
  736541
  701274
  169281
  823896
  398746
  48445
  795799
  783662
  762279
  819925
  775122
  823768
  825424
  825434
  761714
  769206
  766394
  607481
  527208
  700885
  728922
  706018
  691046
  594571
  782631
  769200
  395939
  823875
  681734
  398468
  795496
  326944
  817072
  823270
  794959
  796046
  588007
  824431
  717226
  791230
  734467
  744664
  717939
  775165
  653096
  826123
  824118
  763611
  826792
  768403
  479065
  818996
  739632
  825179
  529608
  557070
  553695
  613387
  730045
  761315
  774255
  729136
  808193
  339108
  717101
  763583
  803728
  769389
  824163
  817773
  401893
  533683
  545310
  550656
  559967
  563693
  568183
  584852
  647751
  692707
  713463
  692731
  698247
  648002
  616860
  624192
  631271
  644184
  803400
  271329
  763695
  550687
]
2.61 ms
(0.74%)
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
  48445
  169281
  220788
  270415
  271329
  326944
  339108
  395939
  398468
  398746
  401893
  479065
  527208
  529608
  533683
  545310
  550656
  550687
  553695
  557070
  559967
  563693
  568183
  579474
  583351
  584852
  586188
  588007
  594571
  607481
  613387
  624192
  631271
  644184
  647751
  648002
  653096
  681734
  691046
  692662
  692707
  692731
  698247
  700876
  700885
  701274
  706018
  713463
  715866
  717101
  717226
  717939
  719086
  724745
  728922
  729136
  729902
  730045
  734467
  736541
  739632
  744664
  747197
  748074
  760394
  761315
  763583
  763611
  763695
  766394
  768403
  769200
  769206
  769389
  774255
  774641
  775122
  775165
  782631
  783662
  787247
  788343
  791230
  794959
  795496
  795799
  796046
  798259
  803400
  803728
  805249
  805628
  808193
  817072
  817773
  818996
  819925
  823270
  823768
  823875
  823896
  824118
  824163
  824431
  824976
  825179
  825222
  825347
  825379
  825390
  825424
  825434
  826123
  826559
  826792
]
2.20 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateurs blowjob"
]
1.93 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск минет оральн секс"
]
1.45 ms
(0.41%)
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.