Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.65 ms
(85.57%)
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
  8518
  479074
  497586
  523797
  533527
  533679
  534074
  534132
  535402
  536959
  540306
  542494
  542992
  543405
  553245
  566418
  584018
  585269
  593552
  600359
  600955
  603668
  604572
  610972
  618236
  618862
  619489
  623346
  623609
  626814
  631101
  631150
  632851
  634216
  635794
  636821
  637662
  640523
  640727
  641303
  641718
  641755
  644057
  645046
  650542
  651906
  653343
  653384
  653758
  653912
  654678
  654695
  656023
  658273
  663328
  665342
  665507
  666754
  667639
  667669
  667849
  669783
  673359
  673361
  673533
  674515
  675809
  679360
  681093
  681106
  681129
  686615
  686860
  691991
  692250
  694322
  694564
  695278
  695280
  696009
  703523
  705934
  712651
  717607
  717805
  720877
  720966
  722648
  727903
  728327
  728424
  733024
  739012
  740764
  742165
  744744
  748711
  754644
  761358
  767874
  768194
  770788
  775979
  781996
  782017
  788177
  788783
  790615
  803399
  805842
  807154
  808047
  808065
  809470
  815138
  816216
  819767
  820106
  824421
  825629
]
13.18 ms
(7.85%)
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
  695280
  712651
  667639
  673361
  675809
  679360
  681093
  686615
  686860
  717607
  720877
  720966
  722648
  651906
  663328
  666754
  667669
  691991
  694564
  695278
  703523
  584018
  600359
  641718
  641755
  585269
  635794
  603668
  636821
  641303
  619489
  626814
  788177
  788783
  807154
  808065
  775979
  790615
  805842
  809470
  740764
  761358
  770788
  728327
  728424
  742165
  733024
  744744
  767874
  748711
  754644
  727903
  739012
  768194
  632851
  640523
  640727
  717805
  781996
  782017
  808047
  8518
  497586
  523797
  825629
  816216
  820106
  819767
  815138
  824421
  533679
  534132
  535402
  540306
  534074
  533527
  536959
  479074
  553245
  542494
  542992
  543405
  566418
  650542
  653343
  653384
  654678
  658273
  669783
  681106
  681129
  692250
  694322
  696009
  705934
  653758
  653912
  654695
  665342
  665507
  673359
  674515
  645046
  656023
  667849
  673533
  593552
  618862
  637662
  604572
  618236
  634216
  600955
  610972
  631101
  631150
  644057
  623346
  623609
  803399
]
3.71 ms
(2.21%)
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
  8518
  479074
  497586
  523797
  533527
  533679
  534074
  534132
  535402
  536959
  540306
  542494
  542992
  543405
  553245
  566418
  584018
  585269
  593552
  600359
  600955
  603668
  604572
  610972
  618236
  618862
  619489
  623346
  623609
  626814
  631101
  631150
  632851
  634216
  635794
  636821
  637662
  640523
  640727
  641303
  641718
  641755
  644057
  645046
  650542
  651906
  653343
  653384
  653758
  653912
  654678
  654695
  656023
  658273
  663328
  665342
  665507
  666754
  667639
  667669
  667849
  669783
  673359
  673361
  673533
  674515
  675809
  679360
  681093
  681106
  681129
  686615
  686860
  691991
  692250
  694322
  694564
  695278
  695280
  696009
  703523
  705934
  712651
  717607
  717805
  720877
  720966
  722648
  727903
  728327
  728424
  733024
  739012
  740764
  742165
  744744
  748711
  754644
  761358
  767874
  768194
  770788
  775979
  781996
  782017
  788177
  788783
  790615
  803399
  805842
  807154
  808047
  808065
  809470
  815138
  816216
  819767
  820106
  824421
  825629
]
1.99 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро мжм секс втро"
]
1.87 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мжм мжм"
]
1.82 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.98%)
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.