Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.23 ms
(85.47%)
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
  96347
  390378
  411884
  419933
  424214
  424248
  429362
  439850
  440944
  445737
  451758
  452937
  452977
  454954
  462342
  462850
  469756
  470949
  471125
  471691
  477586
  483543
  488710
  489243
  493521
  493837
  495559
  498279
  510545
  510877
  511831
  516073
  516684
  518403
  519478
  519497
  528502
  530501
  530784
  531135
  532360
  532746
  532760
  532843
  532847
  532940
  532963
  533372
  533846
  533928
  535826
  536403
  536459
  537584
  540334
  541863
  544510
  544816
  544836
  544838
  545437
  554210
  555104
  556884
  565263
  582540
  601613
  610683
  612399
  622241
  623736
  625660
  628334
  631202
  631209
  632283
  633123
  634208
  634818
  635169
  637442
  639824
  640751
  641956
  642063
  644324
  644972
  647838
  647936
  649596
  650155
  651062
  651634
  651666
  662428
  668505
  673578
  674082
  674988
  676023
  677303
  678504
  686214
  692314
  695199
  696920
  697266
  716901
  717826
  720198
  720719
  721203
  724264
  730074
  740309
  748053
  765628
  791406
  795396
  808063
]
17.48 ms
(9.04%)
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
  516684
  419933
  454954
  489243
  498279
  532760
  532843
  532847
  533928
  536459
  518403
  532360
  530501
  531135
  532963
  533372
  533846
  536403
  530784
  537584
  471691
  541863
  544816
  544838
  647838
  647936
  677303
  678504
  716901
  649596
  651634
  674988
  651666
  668505
  676023
  582540
  628334
  637442
  642063
  612399
  639824
  631202
  633123
  601613
  641956
  631209
  632283
  640751
  445737
  483543
  519497
  650155
  545437
  634818
  622241
  634208
  488710
  411884
  439850
  470949
  477586
  462850
  516073
  519478
  528502
  471125
  493521
  554210
  623736
  452977
  462342
  424214
  440944
  452937
  469756
  493837
  495559
  511831
  510877
  96347
  390378
  429362
  424248
  644972
  451758
  532746
  532940
  535826
  540334
  510545
  544510
  555104
  565263
  651062
  662428
  674082
  686214
  695199
  673578
  697266
  720198
  720719
  721203
  692314
  717826
  544836
  556884
  610683
  635169
  625660
  808063
  724264
  730074
  765628
  791406
  748053
  740309
  644324
  696920
  795396
]
3.03 ms
(1.57%)
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
  96347
  390378
  411884
  419933
  424214
  424248
  429362
  439850
  440944
  445737
  451758
  452937
  452977
  454954
  462342
  462850
  469756
  470949
  471125
  471691
  477586
  483543
  488710
  489243
  493521
  493837
  495559
  498279
  510545
  510877
  511831
  516073
  516684
  518403
  519478
  519497
  528502
  530501
  530784
  531135
  532360
  532746
  532760
  532843
  532847
  532940
  532963
  533372
  533846
  533928
  535826
  536403
  536459
  537584
  540334
  541863
  544510
  544816
  544836
  544838
  545437
  554210
  555104
  556884
  565263
  582540
  601613
  610683
  612399
  622241
  623736
  625660
  628334
  631202
  631209
  632283
  633123
  634208
  634818
  635169
  637442
  639824
  640751
  641956
  642063
  644324
  644972
  647838
  647936
  649596
  650155
  651062
  651634
  651666
  662428
  668505
  673578
  674082
  674988
  676023
  677303
  678504
  686214
  692314
  695199
  696920
  697266
  716901
  717826
  720198
  720719
  721203
  724264
  730074
  740309
  748053
  765628
  791406
  795396
  808063
]
2.20 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"двойной фалоимитаторâ…"
]
1.89 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "двойн дилд"
]
1.75 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.89%)
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.