Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.85 ms
(87.63%)
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
  400571
  414662
  420686
  423508
  438181
  438339
  438490
  452824
  455133
  455794
  455887
  459786
  469451
  473119
  476664
  493688
  523355
  527677
  528646
  529296
  529632
  529740
  531879
  535295
  535963
  546057
  547743
  551589
  553619
  568652
  575860
  576590
  578323
  587451
  588929
  594230
  602281
  602291
  617577
  626019
  630054
  631339
  642149
  650247
  653028
  656200
  657530
  658850
  660043
  662151
  663811
  674625
  691286
  697958
  704669
  711624
  713196
  722390
  726066
  730781
  735308
  738461
  738501
  738515
  739124
  739126
  739802
  739821
  740503
  745087
  747298
  748653
  749215
  751044
  751438
  751786
  752647
  753120
  753190
  753635
  758101
  758822
  760485
  760598
  766266
  767267
  772230
  772654
  773302
  774850
  777753
  777757
  777766
  778105
  778864
  779780
  780292
  780303
  782052
  784217
  791179
  791386
  791388
  791479
  798457
  799759
  799816
  804140
  804939
  806762
  806924
  808968
  810622
  810776
  811570
  812477
  813206
  814363
  827287
  827290
]
15.53 ms
(7.97%)
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
  438181
  827287
  814363
  455887
  528646
  529296
  529740
  535295
  527677
  529632
  535963
  531879
  546057
  551589
  547743
  650247
  653028
  657530
  658850
  711624
  713196
  656200
  662151
  674625
  691286
  660043
  663811
  697958
  722390
  553619
  568652
  575860
  576590
  626019
  631339
  642149
  587451
  602291
  588929
  630054
  594230
  617577
  777753
  777766
  778105
  779780
  784217
  791386
  799759
  799816
  804140
  806762
  777757
  791179
  798457
  806924
  808968
  810776
  738501
  748653
  749215
  751438
  752647
  753190
  760485
  760598
  791479
  804939
  812477
  813206
  726066
  739124
  751044
  758101
  772654
  730781
  739126
  740503
  753120
  758822
  766266
  738461
  738515
  739821
  745087
  747298
  751786
  767267
  772230
  735308
  739802
  753635
  773302
  602281
  704669
  774850
  778864
  780292
  780303
  782052
  791388
  810622
  811570
  473119
  459786
  578323
  523355
  400571
  438490
  414662
  423508
  438339
  420686
  827290
  455794
  469451
  476664
  493688
  455133
  452824
]
2.39 ms
(1.23%)
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
  400571
  414662
  420686
  423508
  438181
  438339
  438490
  452824
  455133
  455794
  455887
  459786
  469451
  473119
  476664
  493688
  523355
  527677
  528646
  529296
  529632
  529740
  531879
  535295
  535963
  546057
  547743
  551589
  553619
  568652
  575860
  576590
  578323
  587451
  588929
  594230
  602281
  602291
  617577
  626019
  630054
  631339
  642149
  650247
  653028
  656200
  657530
  658850
  660043
  662151
  663811
  674625
  691286
  697958
  704669
  711624
  713196
  722390
  726066
  730781
  735308
  738461
  738501
  738515
  739124
  739126
  739802
  739821
  740503
  745087
  747298
  748653
  749215
  751044
  751438
  751786
  752647
  753120
  753190
  753635
  758101
  758822
  760485
  760598
  766266
  767267
  772230
  772654
  773302
  774850
  777753
  777757
  777766
  778105
  778864
  779780
  780292
  780303
  782052
  784217
  791179
  791386
  791388
  791479
  798457
  799759
  799816
  804140
  804939
  806762
  806924
  808968
  810622
  810776
  811570
  812477
  813206
  814363
  827287
  827290
]
1.69 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "частное соло дилдо"
]
1.59 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск соло дилд"
]
1.52 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.72%)
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.