Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
415.43 ms
(72.56%)
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
  130289
  142493
  191356
  385970
  409783
  420427
  426403
  443066
  443748
  456137
  468071
  477230
  483547
  486799
  496100
  496101
  501248
  510396
  513949
  516612
  517794
  521418
  530479
  531182
  532645
  532667
  532751
  532816
  533014
  533373
  534647
  536291
  536582
  536633
  537863
  537932
  541379
  541661
  541863
  541886
  543652
  543771
  544800
  556046
  558431
  559111
  569922
  577368
  583981
  597739
  599160
  599863
  599867
  599913
  599955
  599961
  599976
  600019
  600022
  600029
  600218
  600296
  601613
  603255
  603258
  604517
  606577
  612412
  617422
  617424
  623261
  630678
  632571
  632595
  632641
  632663
  632671
  632693
  633123
  633491
  634472
  634774
  634784
  635215
  636033
  636320
  636991
  637036
  637092
  638298
  639818
  641700
  642063
  643103
  646176
  646899
  647859
  647932
  647960
  648235
  648820
  651634
  662137
  666906
  667748
  668505
  674983
  676638
  678117
  678153
  680130
  681637
  695122
  704531
  716870
  720923
  761073
  803455
  803459
  820762
]
129.13 ms
(22.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
  130289
  142493
  191356
  385970
  409783
  420427
  426403
  443066
  443748
  456137
  468071
  477230
  483547
  486799
  496100
  496101
  501248
  510396
  513949
  516612
  517794
  521418
  530479
  531182
  532645
  532667
  532751
  532816
  533014
  533373
  534647
  536291
  536582
  536633
  537863
  537932
  541379
  541661
  541863
  541886
  543652
  543771
  544800
  556046
  558431
  559111
  569922
  577368
  583981
  597739
  599160
  599863
  599867
  599913
  599955
  599961
  599976
  600019
  600022
  600029
  600218
  600296
  601613
  603255
  603258
  604517
  606577
  612412
  617422
  617424
  623261
  630678
  632571
  632595
  632641
  632663
  632671
  632693
  633123
  633491
  634472
  634774
  634784
  635215
  636033
  636320
  636991
  637036
  637092
  638298
  639818
  641700
  642063
  643103
  646176
  646899
  647859
  647932
  647960
  648235
  648820
  651634
  662137
  666906
  667748
  668505
  674983
  676638
  678117
  678153
  680130
  681637
  695122
  704531
  716870
  720923
  761073
  803455
  803459
  820762
]
21.09 ms
(3.68%)
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
  483547
  533373
  541863
  559111
  583981
  648235
  678117
  651634
  646899
  647859
  668505
  569922
  599867
  600029
  600296
  634472
  641700
  599863
  599913
  599961
  632671
  632693
  633491
  633123
  600019
  600022
  601613
  617424
  632571
  632663
  704531
  530479
  599955
  468071
  496100
  558431
  517794
  496101
  577368
  662137
  599976
  642063
  637092
  632641
  501248
  477230
  513949
  603255
  443066
  541886
  603258
  541379
  667748
  536633
  597739
  803455
  191356
  676638
  678153
  634774
  623261
  420427
  385970
  532816
  532645
  543652
  666906
  674983
  695122
  638298
  637036
  634784
  536291
  720923
  761073
  820762
  532667
  532751
  510396
  531182
  537863
  536582
  544800
  681637
  639818
  606577
  599160
  636320
  130289
  426403
  486799
  680130
  142493
  541661
  543771
  556046
  647932
  632595
  636033
  600218
  643103
  604517
  617422
  635215
  516612
  409783
  456137
  534647
  537932
  716870
  630678
  612412
  636991
  803459
  443748
  521418
  533014
  647960
  648820
  646176
]
1.93 ms
(0.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милф группов секс"
]
1.83 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "милфа групповуха"
]
1.62 ms
(0.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.26%)
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.