Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.26 ms
(84.59%)
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
  392937
  419435
  420021
  423935
  425312
  427372
  429692
  429859
  429869
  429875
  435485
  437970
  439688
  464550
  469104
  470064
  480501
  480671
  490400
  490731
  492758
  494667
  499525
  499681
  507643
  510763
  511388
  513010
  513490
  519362
  519366
  528793
  537237
  538603
  542215
  543993
  544527
  544788
  544874
  547741
  547768
  547787
  549655
  552382
  552805
  555020
  555048
  555062
  561377
  563688
  564755
  568673
  572190
  575897
  584830
  599879
  605734
  605737
  605739
  618316
  619903
  623983
  647111
  652878
  662526
  663286
  667011
  669856
  669858
  669860
  669890
  672829
  687312
  696776
  700462
  700830
  702864
  706889
  710862
  714316
  714350
  718771
  739556
  741368
  741716
  741770
  742331
  744209
  750739
  751531
  763738
  763744
  765830
  765854
  765870
  774575
  778130
  778563
  794030
  800727
  800753
  800754
  803142
  804422
  805129
  805136
  806973
  807009
  807594
  808468
  812180
  816168
  818173
  824000
  825432
  825795
  826706
  826832
  827539
  827722
]
14.54 ms
(9.09%)
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
  480501
  490400
  510763
  511388
  513490
  499525
  492758
  528793
  555020
  555048
  555062
  429869
  464550
  490731
  507643
  423935
  439688
  429859
  816168
  538603
  519366
  544527
  549655
  552382
  542215
  547741
  561377
  563688
  543993
  547787
  564755
  572190
  706889
  714316
  718771
  667011
  687312
  696776
  663286
  547768
  605734
  605737
  623983
  599879
  605739
  618316
  778563
  794030
  800727
  805129
  805136
  807009
  800753
  806973
  808468
  741368
  741716
  741770
  800754
  807594
  742331
  744209
  750739
  765854
  765870
  739556
  751531
  763744
  765830
  763738
  619903
  700462
  774575
  778130
  803142
  804422
  812180
  419435
  420021
  427372
  429875
  469104
  480671
  437970
  429692
  425312
  435485
  519362
  513010
  544788
  662526
  470064
  392937
  826706
  818173
  825795
  826832
  827722
  827539
  824000
  825432
  494667
  499681
  537237
  575897
  584830
  552805
  544874
  568673
  652878
  669860
  672829
  710862
  647111
  669856
  669858
  669890
  700830
  702864
  714350
]
3.00 ms
(1.87%)
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
  392937
  419435
  420021
  423935
  425312
  427372
  429692
  429859
  429869
  429875
  435485
  437970
  439688
  464550
  469104
  470064
  480501
  480671
  490400
  490731
  492758
  494667
  499525
  499681
  507643
  510763
  511388
  513010
  513490
  519362
  519366
  528793
  537237
  538603
  542215
  543993
  544527
  544788
  544874
  547741
  547768
  547787
  549655
  552382
  552805
  555020
  555048
  555062
  561377
  563688
  564755
  568673
  572190
  575897
  584830
  599879
  605734
  605737
  605739
  618316
  619903
  623983
  647111
  652878
  662526
  663286
  667011
  669856
  669858
  669860
  669890
  672829
  687312
  696776
  700462
  700830
  702864
  706889
  710862
  714316
  714350
  718771
  739556
  741368
  741716
  741770
  742331
  744209
  750739
  751531
  763738
  763744
  765830
  765854
  765870
  774575
  778130
  778563
  794030
  800727
  800753
  800754
  803142
  804422
  805129
  805136
  806973
  807009
  807594
  808468
  812180
  816168
  818173
  824000
  825432
  825795
  826706
  826832
  827539
  827722
]
1.96 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло русских женщин"
]
1.74 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло русск женщин"
]
1.49 ms
(0.93%)
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.