Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.84 ms
(87.36%)
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
  391491
  391669
  392066
  392599
  397894
  400998
  401807
  423772
  424265
  424276
  433281
  437258
  439727
  444144
  446975
  452215
  454555
  454868
  455331
  459024
  460143
  460748
  462117
  462708
  466274
  472804
  474797
  475871
  477711
  477794
  477950
  477996
  479124
  483654
  486846
  486933
  488887
  505747
  508367
  508784
  512485
  513501
  516923
  523528
  525310
  535332
  542370
  542925
  543332
  543708
  545726
  547743
  547778
  558117
  560866
  562192
  562743
  565898
  568698
  577598
  590441
  598483
  598541
  599535
  602806
  603767
  612977
  659986
  667774
  669857
  677862
  695707
  697865
  702312
  709540
  713384
  716738
  716915
  736130
  738525
  742303
  745462
  746267
  751536
  751803
  752134
  753507
  755132
  758171
  758804
  760875
  760881
  765834
  765837
  766385
  767459
  768553
  771375
  777217
  777739
  777759
  777861
  778383
  778748
  778749
  779902
  780088
  789188
  792522
  793997
  795521
  796214
  796583
  800934
  803562
  804836
  805145
  811919
  814028
  820107
]
15.88 ms
(8.03%)
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
  454868
  477950
  466274
  392599
  793997
  820107
  814028
  525310
  547743
  697865
  716738
  669857
  716915
  667774
  562743
  778383
  789188
  805145
  777217
  777759
  778749
  780088
  792522
  803562
  804836
  811919
  736130
  755132
  766385
  795521
  796214
  760881
  765837
  771375
  746267
  752134
  758804
  760875
  745462
  751803
  768553
  751536
  753507
  758171
  602806
  777739
  777861
  778748
  779902
  800934
  459024
  565898
  391491
  433281
  460748
  391669
  424265
  454555
  462708
  523528
  513501
  401807
  543708
  659986
  560866
  577598
  562192
  713384
  677862
  695707
  702312
  590441
  598541
  612977
  599535
  603767
  765834
  709540
  516923
  598483
  452215
  477711
  488887
  460143
  543332
  547778
  558117
  568698
  423772
  462117
  477794
  397894
  439727
  446975
  479124
  424276
  437258
  477996
  474797
  444144
  472804
  475871
  505747
  508367
  512485
  486846
  508784
  483654
  400998
  535332
  542370
  796583
  767459
  742303
  738525
  455331
  392066
  486933
  545726
  542925
]
2.65 ms
(1.34%)
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
  391491
  391669
  392066
  392599
  397894
  400998
  401807
  423772
  424265
  424276
  433281
  437258
  439727
  444144
  446975
  452215
  454555
  454868
  455331
  459024
  460143
  460748
  462117
  462708
  466274
  472804
  474797
  475871
  477711
  477794
  477950
  477996
  479124
  483654
  486846
  486933
  488887
  505747
  508367
  508784
  512485
  513501
  516923
  523528
  525310
  535332
  542370
  542925
  543332
  543708
  545726
  547743
  547778
  558117
  560866
  562192
  562743
  565898
  568698
  577598
  590441
  598483
  598541
  599535
  602806
  603767
  612977
  659986
  667774
  669857
  677862
  695707
  697865
  702312
  709540
  713384
  716738
  716915
  736130
  738525
  742303
  745462
  746267
  751536
  751803
  752134
  753507
  755132
  758171
  758804
  760875
  760881
  765834
  765837
  766385
  767459
  768553
  771375
  777217
  777739
  777759
  777861
  778383
  778748
  778749
  779902
  780088
  789188
  792522
  793997
  795521
  796214
  796583
  800934
  803562
  804836
  805145
  811919
  814028
  820107
]
1.91 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mom amateur"
]
1.81 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mom любительск"
]
1.42 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск mom любительск"
]

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.