Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.26 ms
(85.63%)
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
  14216
  14578
  39719
  73280
  319314
  323045
  382429
  383512
  383916
  384139
  385241
  386959
  387455
  391672
  393457
  396067
  396921
  398281
  398504
  398632
  398985
  402733
  402887
  405707
  407182
  411943
  418152
  421116
  422483
  424932
  427129
  429750
  434470
  444666
  446625
  452710
  453693
  456121
  458056
  458425
  461233
  461323
  469289
  477369
  485337
  503512
  508919
  529535
  531694
  540451
  542687
  547950
  557899
  574468
  577887
  583643
  584233
  593151
  601763
  602563
  624192
  625743
  634503
  647955
  652529
  670449
  671166
  674485
  682923
  689160
  701280
  701380
  703673
  708876
  716648
  716671
  717227
  723151
  726326
  726356
  727511
  729255
  729664
  730281
  741013
  744903
  761435
  763292
  763335
  767525
  770026
  775478
  779586
  779958
  780003
  783162
  786576
  786646
  789246
  793349
  793456
  793476
  795030
  798144
  804500
  806325
  814281
  814318
  815575
  816110
  818222
  819699
  820632
  821276
  822259
  823392
  823504
  823927
  825223
  825244
]
13.29 ms
(8.06%)
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
  789246
  819699
  821276
  820632
  815575
  825244
  816110
  818222
  822259
  823392
  825223
  529535
  531694
  542687
  716671
  674485
  701280
  717227
  574468
  624192
  775478
  780003
  726326
  786646
  798144
  730281
  767525
  703673
  319314
  383512
  387455
  398281
  407182
  429750
  422483
  814318
  456121
  458425
  446625
  469289
  485337
  682923
  593151
  602563
  783162
  396921
  427129
  453693
  458056
  323045
  434470
  477369
  503512
  508919
  402887
  393457
  398985
  670449
  793456
  727511
  726356
  763292
  405707
  39719
  14216
  396067
  398632
  647955
  795030
  741013
  385241
  421116
  547950
  786576
  411943
  384139
  806325
  716648
  744903
  601763
  73280
  383916
  391672
  14578
  418152
  823504
  823927
  540451
  557899
  577887
  729664
  708876
  386959
  444666
  382429
  461233
  402733
  452710
  424932
  461323
  398504
  814281
  584233
  689160
  652529
  701380
  671166
  723151
  583643
  634503
  625743
  779586
  779958
  793476
  804500
  761435
  793349
  770026
  729255
  763335
]
3.02 ms
(1.83%)
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
  14216
  14578
  39719
  73280
  319314
  323045
  382429
  383512
  383916
  384139
  385241
  386959
  387455
  391672
  393457
  396067
  396921
  398281
  398504
  398632
  398985
  402733
  402887
  405707
  407182
  411943
  418152
  421116
  422483
  424932
  427129
  429750
  434470
  444666
  446625
  452710
  453693
  456121
  458056
  458425
  461233
  461323
  469289
  477369
  485337
  503512
  508919
  529535
  531694
  540451
  542687
  547950
  557899
  574468
  577887
  583643
  584233
  593151
  601763
  602563
  624192
  625743
  634503
  647955
  652529
  670449
  671166
  674485
  682923
  689160
  701280
  701380
  703673
  708876
  716648
  716671
  717227
  723151
  726326
  726356
  727511
  729255
  729664
  730281
  741013
  744903
  761435
  763292
  763335
  767525
  770026
  775478
  779586
  779958
  780003
  783162
  786576
  786646
  789246
  793349
  793456
  793476
  795030
  798144
  804500
  806325
  814281
  814318
  815575
  816110
  818222
  819699
  820632
  821276
  822259
  823392
  823504
  823927
  825223
  825244
]
2.18 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "глубокая глотка конча…"
]
1.94 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубокийминет минет оральн секс сперм"
]
1.69 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.95%)
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.