Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.73 ms
(53.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde hot"
]
157.61 ms
(40.46%)
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
  38263
  96665
  365901
  386839
  386915
  388584
  390111
  390554
  391538
  391559
  392623
  396225
  396432
  397093
  397307
  399639
  401649
  401968
  403064
  411455
  412207
  413282
  413484
  417304
  428828
  461252
  473023
  473112
  480795
  494250
  507983
  523990
  566070
  581600
  583657
  585410
  590945
  591277
  592787
  595928
  595978
  602680
  618080
  622510
  625501
  625903
  627655
  629598
  633193
  639801
  644010
  644707
  663913
  667656
  675395
  676974
  677825
  679354
  680974
  682920
  689758
  707574
  710848
  712561
  717857
  721207
  734427
  735498
  736404
  737169
  738626
  749974
  755550
  756614
  764719
  765955
  766121
  767030
  768001
  769897
  770483
  770667
  772483
  773105
  774291
  775880
  778701
  779810
  779873
  782170
  783030
  783758
  784379
  785752
  786002
  786065
  786344
  786365
  786438
  786611
  788897
  790558
  790625
  790748
  791555
  794475
  797178
  798629
  799944
  801384
  801385
  801741
  804053
  807593
  810349
  810520
  810776
  815127
  826507
  828169
]
16.12 ms
(4.14%)
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
  682920
  689758
  592787
  625903
  618080
  644010
  622510
  775880
  779873
  783758
  798629
  801384
  786002
  786365
  790625
  810776
  736404
  755550
  769897
  790558
  791555
  794475
  799944
  801385
  807593
  810349
  810520
  734427
  774291
  767030
  735498
  768001
  737169
  770483
  633193
  707574
  721207
  784379
  786611
  790748
  801741
  390554
  396225
  413282
  396432
  397307
  461252
  417304
  828169
  96665
  391538
  388584
  397093
  412207
  815127
  473112
  480795
  566070
  583657
  581600
  667656
  676974
  712561
  717857
  663913
  675395
  677825
  710848
  679354
  680974
  625501
  629598
  639801
  644707
  590945
  595928
  585410
  788897
  778701
  785752
  786344
  786438
  766121
  772483
  783030
  797178
  738626
  773105
  749974
  756614
  764719
  770667
  602680
  779810
  782170
  786065
  804053
  392623
  401968
  386915
  473023
  428828
  494250
  365901
  401649
  826507
  627655
  391559
  399639
  403064
  413484
  523990
  591277
  595978
  390111
  411455
  765955
  507983
  386839
  38263
]
3.12 ms
(0.80%)
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
  38263
  96665
  365901
  386839
  386915
  388584
  390111
  390554
  391538
  391559
  392623
  396225
  396432
  397093
  397307
  399639
  401649
  401968
  403064
  411455
  412207
  413282
  413484
  417304
  428828
  461252
  473023
  473112
  480795
  494250
  507983
  523990
  566070
  581600
  583657
  585410
  590945
  591277
  592787
  595928
  595978
  602680
  618080
  622510
  625501
  625903
  627655
  629598
  633193
  639801
  644010
  644707
  663913
  667656
  675395
  676974
  677825
  679354
  680974
  682920
  689758
  707574
  710848
  712561
  717857
  721207
  734427
  735498
  736404
  737169
  738626
  749974
  755550
  756614
  764719
  765955
  766121
  767030
  768001
  769897
  770483
  770667
  772483
  773105
  774291
  775880
  778701
  779810
  779873
  782170
  783030
  783758
  784379
  785752
  786002
  786065
  786344
  786365
  786438
  786611
  788897
  790558
  790625
  790748
  791555
  794475
  797178
  798629
  799944
  801384
  801385
  801741
  804053
  807593
  810349
  810520
  810776
  815127
  826507
  828169
]
1.73 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая hot"
]
1.62 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая hot"
]
1.59 ms
(0.41%)
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.