Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.66 ms
(85.89%)
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
  232978
  330449
  338258
  386781
  387883
  390771
  391034
  391693
  393145
  395310
  395887
  396378
  396636
  397456
  397523
  398010
  398281
  398360
  398883
  400181
  401003
  403142
  404120
  404175
  408709
  409224
  409613
  410518
  410615
  411552
  412984
  415358
  418252
  419034
  420410
  422131
  423548
  425314
  426673
  426995
  432049
  432688
  433701
  434887
  436830
  437772
  438744
  439769
  439817
  439823
  441406
  441584
  441758
  447052
  447253
  447453
  449029
  449320
  449556
  450588
  452599
  454928
  455610
  455871
  457130
  457152
  458102
  458789
  461035
  461160
  461758
  462651
  463728
  464630
  469755
  469857
  470524
  471299
  471719
  474801
  476544
  478067
  482690
  484806
  490641
  490650
  498703
  499950
  504093
  505085
  506010
  507341
  508104
  508155
  509324
  510393
  511509
  513017
  513193
  513839
  524164
  525298
  525455
  526738
  526972
  528028
  528561
  555989
  588591
  592194
  746235
  748209
  753204
  753962
  761326
  779534
  792351
  795316
  802138
  804551
]
17.51 ms
(8.81%)
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
  792351
  802138
  804551
  748209
  753962
  753204
  746235
  761326
  779534
  795316
  390771
  398010
  403142
  404120
  426673
  432049
  434887
  436830
  441584
  455871
  462651
  232978
  397523
  409613
  461160
  398883
  401003
  426995
  432688
  450588
  461758
  338258
  409224
  415358
  423548
  433701
  452599
  469857
  474801
  438744
  464630
  478067
  511509
  526972
  498703
  505085
  508104
  508155
  513017
  525455
  484806
  524164
  528561
  490641
  499950
  506010
  507341
  528028
  457152
  391034
  404175
  419034
  410518
  482690
  458102
  458789
  461035
  463728
  471299
  449029
  449556
  454928
  476544
  513839
  471719
  555989
  588591
  592194
  410615
  447453
  439817
  455610
  400181
  418252
  420410
  437772
  439769
  439823
  447052
  447253
  425314
  449320
  457130
  469755
  470524
  525298
  504093
  513193
  490650
  509324
  510393
  526738
  386781
  393145
  395310
  391693
  395887
  330449
  387883
  396378
  397456
  398360
  396636
  398281
  411552
  412984
  422131
  441406
  441758
  408709
]
3.62 ms
(1.82%)
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
  232978
  330449
  338258
  386781
  387883
  390771
  391034
  391693
  393145
  395310
  395887
  396378
  396636
  397456
  397523
  398010
  398281
  398360
  398883
  400181
  401003
  403142
  404120
  404175
  408709
  409224
  409613
  410518
  410615
  411552
  412984
  415358
  418252
  419034
  420410
  422131
  423548
  425314
  426673
  426995
  432049
  432688
  433701
  434887
  436830
  437772
  438744
  439769
  439817
  439823
  441406
  441584
  441758
  447052
  447253
  447453
  449029
  449320
  449556
  450588
  452599
  454928
  455610
  455871
  457130
  457152
  458102
  458789
  461035
  461160
  461758
  462651
  463728
  464630
  469755
  469857
  470524
  471299
  471719
  474801
  476544
  478067
  482690
  484806
  490641
  490650
  498703
  499950
  504093
  505085
  506010
  507341
  508104
  508155
  509324
  510393
  511509
  513017
  513193
  513839
  524164
  525298
  525455
  526738
  526972
  528028
  528561
  555989
  588591
  592194
  746235
  748209
  753204
  753962
  761326
  779534
  792351
  795316
  802138
  804551
]
2.14 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен creampie"
]
1.79 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy creampie"
]
1.51 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен creampie"
]
1.47 ms
(0.74%)
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.