Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.62 ms
(81.88%)
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
  186151
  205011
  409919
  411150
  420130
  439425
  448905
  456312
  458499
  478990
  522102
  525629
  529362
  529813
  538543
  538950
  539364
  541136
  552437
  575025
  580224
  588973
  593340
  603231
  604881
  614504
  616625
  620047
  631620
  632929
  640908
  641924
  645388
  649363
  650150
  652052
  652169
  666180
  666604
  668536
  672723
  678421
  680578
  684749
  686383
  689872
  701677
  709276
  709651
  709726
  715420
  719535
  724821
  725444
  731691
  733437
  738202
  742659
  744060
  744772
  744797
  749414
  749574
  750376
  750454
  751425
  751625
  752188
  753698
  753744
  753745
  753747
  754653
  755354
  758944
  759131
  760154
  760460
  761933
  772503
  772547
  772552
  774056
  774142
  774730
  777595
  778621
  778883
  781790
  784143
  787687
  797345
  798311
  798824
  798832
  802318
  803530
  803827
  805295
  806405
  808025
  809054
  811283
  812480
  812765
  813069
  813331
  813753
  814199
  814379
  816702
  816858
  818205
  819226
  822767
  822889
  824735
  826600
  827700
  828585
]
17.32 ms
(11.02%)
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
  778883
  744772
  725444
  774142
  753698
  755354
  772503
  753747
  750376
  186151
  813753
  529362
  603231
  604881
  641924
  812480
  724821
  751625
  761933
  448905
  803530
  772547
  772552
  774056
  798824
  689872
  774730
  749574
  781790
  672723
  809054
  753744
  749414
  819226
  818205
  828585
  411150
  588973
  733437
  420130
  616625
  797345
  826600
  827700
  738202
  816858
  822889
  814199
  822767
  538950
  666604
  758944
  478990
  439425
  456312
  458499
  645388
  760460
  752188
  798311
  541136
  652052
  666180
  631620
  593340
  806405
  802318
  803827
  811283
  751425
  709651
  784143
  808025
  812765
  538543
  409919
  816702
  205011
  824735
  814379
  580224
  668536
  715420
  620047
  614504
  805295
  742659
  750454
  575025
  552437
  652169
  649363
  813069
  813331
  778621
  787687
  760154
  744060
  632929
  709726
  525629
  529813
  539364
  522102
  650150
  684749
  680578
  686383
  678421
  701677
  709276
  719535
  640908
  777595
  798832
  744797
  759131
  753745
  754653
  731691
]
4.01 ms
(2.55%)
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
  186151
  205011
  409919
  411150
  420130
  439425
  448905
  456312
  458499
  478990
  522102
  525629
  529362
  529813
  538543
  538950
  539364
  541136
  552437
  575025
  580224
  588973
  593340
  603231
  604881
  614504
  616625
  620047
  631620
  632929
  640908
  641924
  645388
  649363
  650150
  652052
  652169
  666180
  666604
  668536
  672723
  678421
  680578
  684749
  686383
  689872
  701677
  709276
  709651
  709726
  715420
  719535
  724821
  725444
  731691
  733437
  738202
  742659
  744060
  744772
  744797
  749414
  749574
  750376
  750454
  751425
  751625
  752188
  753698
  753744
  753745
  753747
  754653
  755354
  758944
  759131
  760154
  760460
  761933
  772503
  772547
  772552
  774056
  774142
  774730
  777595
  778621
  778883
  781790
  784143
  787687
  797345
  798311
  798824
  798832
  802318
  803530
  803827
  805295
  806405
  808025
  809054
  811283
  812480
  812765
  813069
  813331
  813753
  814199
  814379
  816702
  816858
  818205
  819226
  822767
  822889
  824735
  826600
  827700
  828585
]
2.09 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big boobs masturbation"
]
1.86 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие boobs мастурбац"
]
1.64 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие boobs мастурбац"
]

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.