Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.21 ms
(80.22%)
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
  129640
  191356
  385970
  388764
  400185
  404582
  406303
  409774
  429775
  443748
  444238
  444736
  450849
  456618
  457783
  460731
  464664
  466074
  467712
  468071
  468611
  469434
  469766
  470585
  470917
  476128
  482512
  482938
  484017
  484090
  484387
  484557
  484690
  487729
  494289
  496101
  501248
  506051
  510396
  510750
  512057
  521418
  524858
  526133
  526553
  528435
  531155
  532839
  532975
  533014
  534631
  535016
  536287
  536289
  536291
  540483
  541379
  541588
  541698
  541721
  541833
  541863
  542187
  556046
  569922
  576726
  582540
  583989
  586419
  598024
  599880
  599913
  599955
  599961
  600006
  600014
  600019
  600296
  603163
  603205
  603693
  604569
  604890
  609953
  611558
  617427
  619407
  619830
  628332
  628336
  630552
  631194
  632258
  632585
  632642
  633491
  634218
  635800
  636033
  637036
  637092
  637148
  637438
  639719
  639774
  639818
  641698
  641700
  642039
  645012
  662137
  675020
  676428
  678117
  679019
  686843
  687461
  716870
  725598
  803459
]
20.62 ms
(13.11%)
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
  460731
  632258
  540483
  541698
  645012
  457783
  641698
  598024
  604569
  532839
  583989
  582540
  603205
  631194
  456618
  444736
  512057
  429775
  541863
  678117
  569922
  600296
  641700
  599913
  599961
  633491
  600019
  619830
  494289
  482938
  637438
  599955
  468071
  400185
  482512
  510750
  526133
  496101
  662137
  637092
  501248
  603693
  191356
  385970
  609953
  611558
  628336
  487729
  536291
  628332
  716870
  803459
  443748
  521418
  484090
  603163
  725598
  467712
  635800
  542187
  484690
  541379
  470585
  637036
  510396
  639818
  556046
  636033
  679019
  535016
  528435
  409774
  533014
  632585
  388764
  526553
  464664
  470917
  406303
  476128
  469766
  524858
  466074
  450849
  484017
  484557
  536289
  687461
  444238
  469434
  536287
  129640
  534631
  576726
  675020
  404582
  604890
  468611
  541721
  541833
  642039
  617427
  541588
  506051
  484387
  532975
  676428
  639719
  586419
  637148
  531155
  686843
  599880
  600014
  600006
  632642
  630552
  634218
  639774
  619407
]
3.45 ms
(2.19%)
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
  129640
  191356
  385970
  388764
  400185
  404582
  406303
  409774
  429775
  443748
  444238
  444736
  450849
  456618
  457783
  460731
  464664
  466074
  467712
  468071
  468611
  469434
  469766
  470585
  470917
  476128
  482512
  482938
  484017
  484090
  484387
  484557
  484690
  487729
  494289
  496101
  501248
  506051
  510396
  510750
  512057
  521418
  524858
  526133
  526553
  528435
  531155
  532839
  532975
  533014
  534631
  535016
  536287
  536289
  536291
  540483
  541379
  541588
  541698
  541721
  541833
  541863
  542187
  556046
  569922
  576726
  582540
  583989
  586419
  598024
  599880
  599913
  599955
  599961
  600006
  600014
  600019
  600296
  603163
  603205
  603693
  604569
  604890
  609953
  611558
  617427
  619407
  619830
  628332
  628336
  630552
  631194
  632258
  632585
  632642
  633491
  634218
  635800
  636033
  637036
  637092
  637148
  637438
  639719
  639774
  639818
  641698
  641700
  642039
  645012
  662137
  675020
  676428
  678117
  679019
  686843
  687461
  716870
  725598
  803459
]
1.97 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"милфы в групповухе и Ñ%…"
]
1.76 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "милф в группов секс"
]
1.75 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милф в группов секс"
]
1.56 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.