Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
192.61 ms
(85.52%)
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
  12203
  72802
  74434
  199188
  295200
  382434
  391380
  391614
  393135
  394200
  395930
  397217
  397883
  397942
  400479
  403588
  406593
  407768
  408188
  408245
  409349
  409702
  411349
  411409
  411844
  411946
  412988
  413467
  413471
  419146
  422199
  429504
  440868
  443165
  443925
  444528
  448246
  453096
  453145
  453650
  454222
  456194
  457283
  458011
  462607
  464297
  464327
  466844
  467240
  468876
  469283
  470657
  472142
  472286
  472675
  474137
  474399
  474491
  475868
  475884
  476272
  476346
  479044
  479090
  481929
  482321
  483328
  483362
  484618
  484630
  484634
  484763
  486350
  490195
  506888
  513194
  514565
  514688
  515917
  518846
  519585
  524952
  526701
  526711
  535433
  535446
  536414
  544425
  544478
  546687
  546913
  546946
  558292
  563094
  563096
  563226
  563227
  563436
  571806
  576723
  583729
  589662
  589671
  592805
  597866
  601846
  601956
  604003
  618856
  619065
  665235
  665410
  665466
  686383
  746737
  755966
  796149
  802870
  803009
  811488
]
22.06 ms
(9.80%)
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
  393135
  295200
  397942
  408188
  429504
  409702
  409349
  456194
  506888
  665235
  686383
  665410
  803009
  755966
  199188
  74434
  395930
  475868
  546913
  571806
  576723
  618856
  619065
  589671
  604003
  597866
  601956
  482321
  483328
  524952
  12203
  448246
  457283
  592805
  796149
  811488
  802870
  746737
  444528
  544478
  583729
  601846
  464327
  472286
  514565
  544425
  665466
  403588
  422199
  453650
  400479
  472142
  470657
  411946
  535433
  535446
  536414
  484630
  484618
  453096
  486350
  382434
  412988
  397217
  406593
  413471
  411844
  408245
  413467
  419146
  453145
  474137
  484763
  462607
  458011
  468876
  526701
  464297
  466844
  546946
  558292
  563436
  563096
  563226
  546687
  563094
  563227
  589662
  397883
  467240
  479090
  391380
  391614
  394200
  407768
  411409
  469283
  476346
  411349
  440868
  443925
  454222
  472675
  474399
  474491
  476272
  479044
  481929
  443165
  475884
  513194
  514688
  519585
  526711
  483362
  515917
  484634
  490195
  518846
  72802
]
3.18 ms
(1.41%)
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
  12203
  72802
  74434
  199188
  295200
  382434
  391380
  391614
  393135
  394200
  395930
  397217
  397883
  397942
  400479
  403588
  406593
  407768
  408188
  408245
  409349
  409702
  411349
  411409
  411844
  411946
  412988
  413467
  413471
  419146
  422199
  429504
  440868
  443165
  443925
  444528
  448246
  453096
  453145
  453650
  454222
  456194
  457283
  458011
  462607
  464297
  464327
  466844
  467240
  468876
  469283
  470657
  472142
  472286
  472675
  474137
  474399
  474491
  475868
  475884
  476272
  476346
  479044
  479090
  481929
  482321
  483328
  483362
  484618
  484630
  484634
  484763
  486350
  490195
  506888
  513194
  514565
  514688
  515917
  518846
  519585
  524952
  526701
  526711
  535433
  535446
  536414
  544425
  544478
  546687
  546913
  546946
  558292
  563094
  563096
  563226
  563227
  563436
  571806
  576723
  583729
  589662
  589671
  592805
  597866
  601846
  601956
  604003
  618856
  619065
  665235
  665410
  665466
  686383
  746737
  755966
  796149
  802870
  803009
  811488
]
2.31 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bitch mature"
]
1.65 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женскийрод mature"
]
1.60 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женскийрод mature"
]

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.