Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.76 ms
(85.02%)
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
  182238
  383464
  387279
  398651
  407633
  419303
  420788
  427753
  427843
  435503
  436765
  440486
  440805
  440836
  440895
  441603
  444370
  444939
  449523
  449545
  449998
  452754
  457871
  458371
  459986
  463471
  465501
  467119
  468996
  480508
  494096
  506741
  513975
  516537
  517121
  517519
  521030
  521170
  522196
  524358
  524678
  525301
  525911
  528561
  529233
  529455
  529976
  531216
  538172
  539790
  555905
  557567
  557797
  565676
  577272
  577865
  584768
  586121
  587134
  587342
  589931
  592203
  595244
  626245
  629569
  636046
  647547
  651373
  652784
  656636
  662823
  673670
  683066
  694142
  697196
  699447
  703603
  703960
  712185
  722934
  726194
  726815
  738631
  741700
  741702
  742642
  744360
  745605
  751898
  753633
  761650
  762756
  762817
  762843
  763896
  764044
  765269
  767236
  768387
  768880
  769291
  772035
  786632
  788827
  792587
  794071
  795244
  796919
  797349
  798361
  800799
  802842
  803371
  808186
  808531
  811960
  812290
  824501
]
16.18 ms
(9.31%)
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
  557797
  699447
  703960
  662823
  647547
  652784
  673670
  712185
  577272
  587134
  589931
  795244
  797349
  812290
  761650
  764044
  786632
  792587
  794071
  802842
  808531
  741700
  738631
  751898
  753633
  762756
  762843
  803371
  182238
  517519
  525911
  538172
  587342
  440805
  441603
  436765
  449545
  626899
  726815
  480508
  697196
  629569
  796919
  383464
  387279
  444370
  427753
  459986
  457871
  539790
  522196
  584768
  577865
  651373
  694142
  683066
  703603
  586121
  811960
  788827
  772035
  798361
  808186
  741702
  726194
  763896
  768387
  768880
  762817
  742642
  744360
  398651
  420788
  528561
  440486
  468996
  525301
  557567
  656636
  592203
  626245
  636046
  745605
  765269
  767236
  769291
  419303
  444939
  440895
  524358
  529233
  565676
  449998
  506741
  516537
  796642
  513975
  722934
  435503
  463471
  465501
  524678
  595244
  800799
  427843
  521170
  407633
  440836
  824501
  452754
  449523
  458371
  467119
  531216
  529976
  517121
  494096
  521030
  529455
  555905
]
2.60 ms
(1.50%)
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
  182238
  383464
  387279
  398651
  407633
  419303
  420788
  427753
  427843
  435503
  436765
  440486
  440805
  440836
  440895
  441603
  444370
  444939
  449523
  449545
  449998
  452754
  457871
  458371
  459986
  463471
  465501
  467119
  468996
  480508
  494096
  506741
  513975
  516537
  517121
  517519
  521030
  521170
  522196
  524358
  524678
  525301
  525911
  528561
  529233
  529455
  529976
  531216
  538172
  539790
  555905
  557567
  557797
  565676
  577272
  577865
  584768
  586121
  587134
  587342
  589931
  592203
  595244
  626245
  629569
  636046
  647547
  651373
  652784
  656636
  662823
  673670
  683066
  694142
  697196
  699447
  703603
  703960
  712185
  722934
  726194
  726815
  738631
  741700
  741702
  742642
  744360
  745605
  751898
  753633
  761650
  762756
  762817
  762843
  763896
  764044
  765269
  767236
  768387
  768880
  769291
  772035
  786632
  788827
  792587
  794071
  795244
  796919
  797349
  798361
  800799
  802842
  803371
  808186
  808531
  811960
  812290
  824501
]
2.27 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cowgirl big ass"
]
1.81 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cowgirl большая большие жоп"
]
1.65 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cowgirl большая большие жоп"
]

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.