Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.45 ms
(86.69%)
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
  421989
  426726
  448965
  460428
  461631
  462471
  463621
  468982
  490047
  508300
  515736
  517835
  519131
  520683
  521176
  523777
  526995
  529842
  531979
  532131
  534666
  540660
  541870
  542744
  547993
  549644
  555958
  559709
  560866
  562466
  569189
  580133
  586043
  587314
  587927
  588691
  591049
  592700
  598541
  601319
  605099
  606500
  606554
  606842
  610275
  611588
  617002
  623015
  624869
  662370
  674249
  674825
  676436
  693806
  702309
  709319
  710329
  710389
  718456
  721046
  721757
  726432
  730710
  733195
  734259
  734294
  736379
  744681
  746846
  751564
  753496
  754457
  754965
  755132
  755695
  758668
  763060
  763077
  766385
  767375
  767459
  769344
  777217
  777861
  778034
  778741
  778804
  778847
  779563
  779902
  783683
  786195
  786831
  787244
  787465
  787726
  788979
  789180
  790708
  791953
  794567
  796023
  798600
  799028
  801385
  805361
  806538
  807515
  809277
  811241
  811779
  812446
  814028
  817711
  823561
  824637
  824640
  827511
]
13.67 ms
(7.53%)
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
  754965
  736379
  744681
  710329
  778847
  580133
  779563
  801385
  758668
  521176
  490047
  702309
  559709
  811779
  812446
  794567
  805361
  787244
  789180
  778741
  783683
  788979
  799028
  562466
  461631
  463621
  674825
  617002
  531979
  547993
  721046
  809277
  693806
  520683
  767459
  519131
  719429
  796023
  662370
  674249
  676436
  598541
  605099
  606554
  710389
  610275
  811241
  733195
  734294
  751564
  718456
  468982
  462471
  763077
  586043
  508300
  754457
  769344
  746846
  755695
  726432
  753496
  515736
  526995
  534666
  601319
  611588
  460428
  523777
  824637
  709319
  606500
  587927
  721757
  588691
  624869
  448965
  529842
  549644
  817711
  827511
  814028
  824640
  786195
  791953
  777217
  790708
  807515
  755132
  766385
  767375
  777861
  778034
  779902
  785027
  787726
  806538
  426726
  540660
  421989
  569189
  532131
  823561
  541870
  587314
  591049
  606842
  623015
  786831
  798600
  730710
  734259
  763060
  787465
  517835
  542744
  555958
  560866
  778804
  592700
]
3.36 ms
(1.85%)
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
  421989
  426726
  448965
  460428
  461631
  462471
  463621
  468982
  490047
  508300
  515736
  517835
  519131
  520683
  521176
  523777
  526995
  529842
  531979
  532131
  534666
  540660
  541870
  542744
  547993
  549644
  555958
  559709
  560866
  562466
  569189
  580133
  586043
  587314
  587927
  588691
  591049
  592700
  598541
  601319
  605099
  606500
  606554
  606842
  610275
  611588
  617002
  623015
  624869
  662370
  674249
  674825
  676436
  693806
  702309
  709319
  710329
  710389
  718456
  721046
  721757
  726432
  730710
  733195
  734259
  734294
  736379
  744681
  746846
  751564
  753496
  754457
  754965
  755132
  755695
  758668
  763060
  763077
  766385
  767375
  767459
  769344
  777217
  777861
  778034
  778741
  778804
  778847
  779563
  779902
  783683
  786195
  786831
  787244
  787465
  787726
  788979
  789180
  790708
  791953
  794567
  796023
  798600
  799028
  801385
  805361
  806538
  807515
  809277
  811241
  811779
  812446
  814028
  817711
  823561
  824637
  824640
  827511
]
2.03 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom handjob homemade"
]
1.88 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom дрочк член домашн любительск"
]
1.71 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom дрочк член домашн любительск"
]
1.54 ms
(0.85%)
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.