Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.79 ms
(57.00%)
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
  119927
  381972
  382810
  387293
  388537
  391944
  392004
  406012
  412855
  415885
  421838
  428729
  429886
  439071
  439593
  444537
  448791
  451022
  451042
  452800
  452964
  455915
  459170
  465460
  465618
  466427
  468110
  468146
  468148
  468219
  468946
  470215
  471107
  474126
  475431
  476168
  476191
  477055
  478542
  482293
  483735
  483736
  493763
  493835
  495566
  501258
  502465
  506149
  511274
  511869
  512079
  514868
  519352
  519374
  523358
  523882
  525468
  526504
  530425
  530451
  534574
  534636
  541832
  544848
  545438
  545449
  545989
  547467
  550337
  550916
  555769
  559377
  566775
  571726
  574388
  576479
  576590
  579673
  580265
  590803
  590831
  593044
  597663
  604298
  605483
  609887
  614766
  660382
  663969
  672894
  675589
  678757
  705360
  705451
  705452
  708465
  711591
  713501
  713503
  713506
  713507
  715797
  720289
  725400
  741687
  744806
  748504
  748653
  749084
  749264
  751609
  752613
  752661
  758803
  770120
  790009
  796646
  802899
  826784
]
134.96 ms
(36.84%)
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
  119927
  381972
  382810
  387293
  388537
  391944
  392004
  406012
  412855
  415885
  421838
  428729
  429886
  439071
  439593
  444537
  448791
  451022
  451042
  452800
  452964
  455915
  459170
  465460
  465618
  466427
  468110
  468146
  468148
  468219
  468946
  470215
  471107
  474126
  475431
  476168
  476191
  477055
  478542
  482293
  483735
  483736
  493763
  493835
  495566
  501258
  502465
  506149
  511274
  511869
  512079
  514868
  519352
  519374
  523358
  523882
  525468
  526504
  530425
  530451
  534574
  534636
  541832
  544848
  545438
  545449
  545989
  547467
  550337
  550916
  555769
  559377
  566775
  571726
  574388
  576479
  576590
  579673
  580265
  590803
  590831
  593044
  597663
  604298
  605483
  609887
  614766
  660382
  663969
  672894
  675589
  678757
  705360
  705451
  705452
  708465
  711591
  713501
  713503
  713506
  713507
  715797
  720289
  725400
  741687
  744806
  748504
  748653
  749084
  749264
  751609
  752613
  752661
  758803
  770120
  790009
  796646
  802899
  826784
]
15.73 ms
(4.29%)
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
  725400
  751609
  576479
  748504
  391944
  387293
  519374
  550337
  545449
  580265
  593044
  382810
  439071
  451022
  483736
  660382
  459170
  576590
  614766
  748653
  465460
  381972
  466427
  550916
  713501
  713507
  493763
  511869
  477055
  544848
  415885
  455915
  476168
  119927
  421838
  519352
  530425
  530451
  566775
  713503
  678757
  705360
  713506
  672894
  597663
  590831
  428729
  502465
  534636
  559377
  720289
  708465
  545989
  605483
  758803
  802899
  741687
  482293
  439593
  468148
  796646
  506149
  388537
  468110
  471107
  495566
  474126
  452964
  406012
  478542
  555769
  705452
  790009
  744806
  770120
  609887
  752661
  541832
  451042
  545438
  749264
  493835
  675589
  523358
  523882
  826784
  512079
  663969
  604298
  465618
  468946
  511274
  526504
  514868
  468219
  590803
  429886
  392004
  705451
  579673
  749084
  715797
  475431
  711591
  752613
  547467
  574388
  501258
  476191
  412855
  571726
  468146
  483735
  444537
  452800
  448791
  534574
  525468
  470215
  564310
]
2.02 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass dildo mature"
]
1.88 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп дилд mature"
]
1.26 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп дилд mature"
]

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.