Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.72 ms
(87.77%)
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
  38261
  80916
  187349
  233186
  381979
  384480
  384988
  390815
  391884
  393435
  396322
  397907
  422197
  432871
  437361
  439721
  440836
  440951
  442257
  445063
  448183
  452358
  453273
  453706
  455122
  455989
  456787
  459379
  460974
  462471
  468883
  470652
  471645
  474441
  479094
  480522
  482618
  482843
  482881
  483482
  486357
  499694
  501378
  501618
  504458
  507266
  509287
  510771
  510776
  512145
  516473
  516808
  517245
  517374
  517589
  521867
  523777
  527893
  531955
  537848
  540207
  544452
  544495
  545922
  555600
  562540
  568337
  590961
  603678
  604874
  610094
  617019
  658440
  676408
  695759
  705549
  709396
  710249
  714424
  725511
  730991
  731915
  734005
  738334
  739555
  739686
  739762
  744394
  744439
  744764
  744791
  746114
  746453
  746600
  746603
  753511
  755056
  755065
  756920
  758110
  758149
  758274
  760775
  769566
  772525
  774964
  775950
  784946
  787571
  795327
  800432
  800704
  803062
  805644
  806241
  808866
  808870
  809791
  811314
  817004
]
12.88 ms
(6.43%)
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
  512145
  486357
  603678
  187349
  439721
  455122
  516808
  517374
  800432
  808866
  393435
  384480
  445063
  455989
  482843
  456787
  517589
  537848
  474441
  482618
  544452
  705549
  775950
  390815
  397907
  462471
  479094
  233186
  422197
  468883
  504458
  510771
  523777
  507266
  509287
  510776
  516473
  604874
  744764
  499694
  562540
  545922
  734005
  772525
  795327
  730991
  746600
  753511
  755056
  739555
  746453
  755065
  769566
  758149
  817004
  540207
  590961
  803062
  808870
  396322
  744791
  760775
  384988
  381979
  432871
  453273
  501618
  531955
  470652
  568337
  658440
  676408
  710249
  714424
  695759
  610094
  784946
  806241
  738334
  746114
  756920
  787571
  800704
  805644
  811314
  758110
  744394
  758274
  725511
  731915
  739686
  739762
  744439
  746603
  709396
  774964
  809791
  453706
  80916
  460974
  527893
  517245
  544495
  555600
  617019
  501378
  521867
  483482
  442257
  391884
  38261
  440836
  437361
  440951
  448183
  482881
  452358
  459379
  471645
  480522
]
4.29 ms
(2.14%)
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
  38261
  80916
  187349
  233186
  381979
  384480
  384988
  390815
  391884
  393435
  396322
  397907
  422197
  432871
  437361
  439721
  440836
  440951
  442257
  445063
  448183
  452358
  453273
  453706
  455122
  455989
  456787
  459379
  460974
  462471
  468883
  470652
  471645
  474441
  479094
  480522
  482618
  482843
  482881
  483482
  486357
  499694
  501378
  501618
  504458
  507266
  509287
  510771
  510776
  512145
  516473
  516808
  517245
  517374
  517589
  521867
  523777
  527893
  531955
  537848
  540207
  544452
  544495
  545922
  555600
  562540
  568337
  590961
  603678
  604874
  610094
  617019
  658440
  676408
  695759
  705549
  709396
  710249
  714424
  725511
  730991
  731915
  734005
  738334
  739555
  739686
  739762
  744394
  744439
  744764
  744791
  746114
  746453
  746600
  746603
  753511
  755056
  755065
  756920
  758110
  758149
  758274
  760775
  769566
  772525
  774964
  775950
  784946
  787571
  795327
  800432
  800704
  803062
  805644
  806241
  808866
  808870
  809791
  811314
  817004
]
1.90 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин дрочк"
]
1.88 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщины дрочка"
]
1.81 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.87%)
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.