Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.82 ms
(85.33%)
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
  312264
  381930
  383065
  384128
  388716
  392019
  395628
  395878
  396629
  397019
  398038
  401903
  401954
  405860
  407727
  408709
  408978
  409251
  410633
  411626
  411628
  411710
  411737
  411794
  412776
  413454
  413472
  413476
  419839
  421257
  422426
  425984
  429267
  430293
  450147
  451436
  451474
  453108
  453114
  453122
  453541
  454408
  458364
  459472
  460273
  460682
  467062
  469360
  471078
  474111
  474115
  474123
  474124
  474849
  476310
  481467
  483358
  485758
  485763
  485765
  485772
  487349
  493472
  502061
  506349
  515059
  515074
  515083
  516137
  519135
  520894
  523076
  523382
  523595
  525495
  525507
  526404
  543119
  554446
  561992
  563065
  565918
  577178
  578163
  578183
  585111
  587298
  592998
  594283
  607692
  649527
  651886
  665101
  665197
  665206
  665229
  665294
  665357
  665372
  665864
  665871
  666796
  667833
  668699
  668901
  669418
  669753
  702158
  710127
  714203
  714698
  726859
  744232
  744985
  748467
  751511
  753050
  784669
  804421
  824833
]
16.00 ms
(8.76%)
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
  401903
  396629
  419839
  422426
  450147
  502061
  665372
  665197
  607692
  744985
  384128
  421257
  397019
  408978
  413476
  483358
  515083
  554446
  668901
  669753
  665206
  702158
  649527
  744232
  748467
  471078
  413454
  824833
  410633
  388716
  411626
  408709
  453122
  474124
  460273
  474111
  561992
  587298
  395628
  392019
  401954
  459472
  469360
  453108
  668699
  665294
  714203
  726859
  451436
  395878
  381930
  409251
  487349
  458364
  474115
  525495
  578183
  565918
  665101
  667833
  669418
  714698
  710127
  592998
  594283
  804421
  753050
  784669
  751511
  411737
  451474
  520894
  407727
  474849
  453541
  412776
  383065
  398038
  405860
  411628
  460682
  516137
  493472
  429267
  467062
  481467
  425984
  312264
  411794
  430293
  413472
  411710
  585111
  485765
  453114
  485758
  485763
  454408
  474123
  485772
  519135
  506349
  523595
  523076
  523382
  515059
  515074
  525507
  526404
  476310
  577178
  578163
  543119
  563065
  665229
  665871
  666796
  651886
  665357
  665864
]
3.58 ms
(1.96%)
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
  312264
  381930
  383065
  384128
  388716
  392019
  395628
  395878
  396629
  397019
  398038
  401903
  401954
  405860
  407727
  408709
  408978
  409251
  410633
  411626
  411628
  411710
  411737
  411794
  412776
  413454
  413472
  413476
  419839
  421257
  422426
  425984
  429267
  430293
  450147
  451436
  451474
  453108
  453114
  453122
  453541
  454408
  458364
  459472
  460273
  460682
  467062
  469360
  471078
  474111
  474115
  474123
  474124
  474849
  476310
  481467
  483358
  485758
  485763
  485765
  485772
  487349
  493472
  502061
  506349
  515059
  515074
  515083
  516137
  519135
  520894
  523076
  523382
  523595
  525495
  525507
  526404
  543119
  554446
  561992
  563065
  565918
  577178
  578163
  578183
  585111
  587298
  592998
  594283
  607692
  649527
  651886
  665101
  665197
  665206
  665229
  665294
  665357
  665372
  665864
  665871
  666796
  667833
  668699
  668901
  669418
  669753
  702158
  710127
  714203
  714698
  726859
  744232
  744985
  748467
  751511
  753050
  784669
  804421
  824833
]
2.21 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "полненькие волосатые%…"
]
1.82 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная волосатая"
]
1.67 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.82%)
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.