Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.61 ms
(85.14%)
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
  80747
  385754
  393253
  397660
  416472
  418389
  420513
  420565
  424995
  425654
  435244
  437330
  437634
  437914
  438906
  441366
  444349
  445511
  446220
  449602
  452216
  452650
  453568
  458356
  459533
  462892
  463218
  464243
  464516
  464694
  475320
  482247
  496616
  504711
  504751
  504752
  511650
  514357
  524327
  527592
  527909
  544422
  554718
  559658
  561165
  568097
  581191
  595816
  595832
  606902
  608620
  613983
  615265
  620856
  621721
  624494
  625088
  625127
  629667
  632418
  644115
  646135
  650886
  656830
  662911
  674068
  678238
  682647
  689492
  709320
  710858
  711620
  715158
  716929
  718050
  722084
  723742
  729072
  732727
  734350
  734610
  735094
  738218
  738780
  739409
  739422
  745626
  757068
  757587
  757914
  759745
  761895
  763841
  766484
  766494
  779255
  779330
  779535
  779890
  780015
  785708
  787821
  787965
  788080
  790208
  791531
  791878
  793775
  794432
  797103
  803555
  804896
  808042
  809964
  813098
  814011
  814499
  819159
  825630
  827271
]
14.80 ms
(7.75%)
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
  437634
  595832
  819159
  779255
  766494
  791878
  722084
  809964
  827271
  482247
  581191
  656830
  711620
  716929
  629667
  644115
  803555
  813098
  738218
  757587
  621721
  514357
  595816
  449602
  559658
  561165
  475320
  759745
  420565
  723742
  463218
  420513
  425654
  814499
  710858
  632418
  793775
  808042
  785708
  787821
  418389
  615265
  738780
  80747
  650886
  766484
  745626
  734350
  780015
  452216
  504751
  496616
  568097
  464516
  385754
  437330
  458356
  674068
  715158
  682647
  709320
  718050
  779890
  739422
  804896
  757068
  757914
  739409
  788080
  791531
  464243
  452650
  504752
  397660
  504711
  620856
  613983
  797103
  554718
  689492
  646135
  662911
  794432
  787965
  732727
  729072
  734610
  393253
  511650
  544422
  678238
  624494
  606902
  790208
  735094
  424995
  435244
  446220
  437914
  464694
  453568
  524327
  625127
  416472
  445511
  779330
  761895
  763841
  779535
  444349
  462892
  441366
  459533
  527592
  608620
  625088
  438906
  527909
  814011
  825630
]
5.40 ms
(2.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс my sister"
]
2.92 ms
(1.53%)
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
  80747
  385754
  393253
  397660
  416472
  418389
  420513
  420565
  424995
  425654
  435244
  437330
  437634
  437914
  438906
  441366
  444349
  445511
  446220
  449602
  452216
  452650
  453568
  458356
  459533
  462892
  463218
  464243
  464516
  464694
  475320
  482247
  496616
  504711
  504751
  504752
  511650
  514357
  524327
  527592
  527909
  544422
  554718
  559658
  561165
  568097
  581191
  595816
  595832
  606902
  608620
  613983
  615265
  620856
  621721
  624494
  625088
  625127
  629667
  632418
  644115
  646135
  650886
  656830
  662911
  674068
  678238
  682647
  689492
  709320
  710858
  711620
  715158
  716929
  718050
  722084
  723742
  729072
  732727
  734350
  734610
  735094
  738218
  738780
  739409
  739422
  745626
  757068
  757587
  757914
  759745
  761895
  763841
  766484
  766494
  779255
  779330
  779535
  779890
  780015
  785708
  787821
  787965
  788080
  790208
  791531
  791878
  793775
  794432
  797103
  803555
  804896
  808042
  809964
  813098
  814011
  814499
  819159
  825630
  827271
]
1.81 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс my sister"
]
1.77 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex my sister"
]
1.67 ms
(0.87%)
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.