Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.88 ms
(86.55%)
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
  32678
  46580
  97688
  122425
  143010
  396094
  404384
  409909
  414069
  420185
  425027
  443497
  445431
  449360
  450822
  458614
  460606
  463798
  464651
  467639
  497557
  497568
  511378
  516060
  517864
  523536
  525091
  529120
  529411
  529430
  530017
  530497
  531196
  532182
  532500
  532798
  533241
  533337
  534804
  534825
  534848
  535072
  537113
  539170
  540238
  541089
  541854
  543872
  543874
  543905
  544409
  550316
  550742
  554016
  556030
  556421
  557605
  564767
  565101
  572021
  575335
  575435
  583996
  586248
  593092
  593879
  597142
  597242
  597670
  601237
  606538
  606868
  608395
  609991
  615627
  616561
  617130
  619177
  619199
  630280
  630533
  630955
  631572
  633855
  634195
  635227
  636290
  646246
  647626
  650506
  651577
  651578
  651991
  654297
  658124
  662197
  665930
  675934
  697369
  711820
  726665
  732423
  738854
  746942
  747966
  760025
  771827
  786461
  801880
  804462
  807692
  809459
  812800
  815330
  815784
  816260
  820340
  820590
  820767
  820900
]
17.82 ms
(8.25%)
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
  543874
  443497
  143010
  820590
  820900
  511378
  523536
  529411
  535072
  575335
  651578
  658124
  711820
  597670
  634195
  615627
  616561
  760025
  738854
  771827
  537113
  550742
  619199
  420185
  450822
  529430
  530017
  556030
  404384
  414069
  815784
  445431
  532798
  534848
  539170
  533241
  525091
  467639
  541089
  665930
  675934
  646246
  650506
  697369
  586248
  606538
  617130
  807692
  726665
  732423
  630955
  32678
  464651
  396094
  449360
  543872
  633855
  608395
  820340
  636290
  97688
  409909
  534804
  544409
  564767
  654297
  662197
  635227
  597242
  631572
  606868
  593092
  609991
  809459
  747966
  801880
  460606
  497568
  517864
  497557
  554016
  630533
  458614
  122425
  46580
  820767
  816260
  530497
  532500
  534825
  531196
  533337
  572021
  543905
  557605
  583996
  647626
  619177
  593879
  601237
  812800
  786461
  804462
  651991
  630280
  425027
  651577
  746942
  541854
  815330
  463798
  529120
  532182
  516060
  540238
  556421
  565101
  550316
  575435
  597142
]
3.99 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
  32678
  46580
  97688
  122425
  143010
  396094
  404384
  409909
  414069
  420185
  425027
  443497
  445431
  449360
  450822
  458614
  460606
  463798
  464651
  467639
  497557
  497568
  511378
  516060
  517864
  523536
  525091
  529120
  529411
  529430
  530017
  530497
  531196
  532182
  532500
  532798
  533241
  533337
  534804
  534825
  534848
  535072
  537113
  539170
  540238
  541089
  541854
  543872
  543874
  543905
  544409
  550316
  550742
  554016
  556030
  556421
  557605
  564767
  565101
  572021
  575335
  575435
  583996
  586248
  593092
  593879
  597142
  597242
  597670
  601237
  606538
  606868
  608395
  609991
  615627
  616561
  617130
  619177
  619199
  630280
  630533
  630955
  631572
  633855
  634195
  635227
  636290
  646246
  647626
  650506
  651577
  651578
  651991
  654297
  658124
  662197
  665930
  675934
  697369
  711820
  726665
  732423
  738854
  746942
  747966
  760025
  771827
  786461
  801880
  804462
  807692
  809459
  812800
  815330
  815784
  816260
  820340
  820590
  820767
  820900
]
2.19 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian interracial"
]
2.07 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк межрасов"
]
1.41 ms
(0.65%)
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.