Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.53 ms
(84.26%)
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
  382585
  386790
  396831
  401583
  402730
  411422
  418336
  420548
  423949
  433787
  437522
  438654
  438672
  441759
  443569
  443680
  457325
  458738
  459484
  461553
  462597
  465950
  466044
  466083
  466187
  466220
  466332
  466854
  469776
  474990
  477634
  481018
  485602
  488896
  489484
  497576
  500704
  502417
  502916
  505974
  508865
  523302
  526034
  526037
  533657
  534111
  538402
  549551
  552203
  552222
  552233
  552248
  559032
  559395
  561341
  562277
  564068
  565638
  568683
  570668
  571401
  572442
  573646
  573945
  574000
  574488
  575127
  577968
  596673
  623013
  633480
  644151
  657282
  672898
  690478
  691343
  705436
  721438
  722816
  722852
  729440
  739331
  743615
  743638
  743905
  744025
  762169
  762767
  766101
  766183
  766185
  766194
  769072
  773427
  777254
  778828
  778965
  779755
  780381
  781360
  782210
  782324
  783003
  785507
  785923
  786998
  787730
  788386
  789921
  793956
  793972
  799045
  807284
  807296
  811211
  814990
  816182
  818002
  825505
  825567
]
14.58 ms
(9.63%)
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
  814990
  722852
  564068
  781360
  766183
  743615
  466187
  825505
  561341
  691343
  779755
  789921
  778965
  785507
  807284
  811211
  782324
  807296
  743638
  705436
  386790
  559395
  420548
  433787
  633480
  402730
  722816
  773427
  552233
  443680
  552248
  461553
  466220
  538402
  571401
  382585
  488896
  533657
  825567
  816182
  672898
  623013
  769072
  777254
  466332
  502417
  568683
  785923
  744025
  766194
  552222
  401583
  396831
  466044
  466083
  786998
  721438
  787730
  489484
  441759
  458738
  526034
  762767
  466854
  485602
  783003
  743905
  778828
  574488
  438672
  423949
  474990
  552203
  690478
  644151
  766185
  729440
  799045
  477634
  565638
  481018
  534111
  782210
  523302
  577968
  818002
  502916
  572442
  657282
  574000
  780381
  739331
  559032
  459484
  438654
  793956
  788386
  762169
  766101
  575127
  457325
  508865
  437522
  562277
  596673
  411422
  469776
  526037
  505974
  793972
  549551
  570668
  573646
  573945
  462597
  465950
  418336
  443569
  500704
  497576
]
2.80 ms
(1.85%)
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
  382585
  386790
  396831
  401583
  402730
  411422
  418336
  420548
  423949
  433787
  437522
  438654
  438672
  441759
  443569
  443680
  457325
  458738
  459484
  461553
  462597
  465950
  466044
  466083
  466187
  466220
  466332
  466854
  469776
  474990
  477634
  481018
  485602
  488896
  489484
  497576
  500704
  502417
  502916
  505974
  508865
  523302
  526034
  526037
  533657
  534111
  538402
  549551
  552203
  552222
  552233
  552248
  559032
  559395
  561341
  562277
  564068
  565638
  568683
  570668
  571401
  572442
  573646
  573945
  574000
  574488
  575127
  577968
  596673
  623013
  633480
  644151
  657282
  672898
  690478
  691343
  705436
  721438
  722816
  722852
  729440
  739331
  743615
  743638
  743905
  744025
  762169
  762767
  766101
  766183
  766185
  766194
  769072
  773427
  777254
  778828
  778965
  779755
  780381
  781360
  782210
  782324
  783003
  785507
  785923
  786998
  787730
  788386
  789921
  793956
  793972
  799045
  807284
  807296
  811211
  814990
  816182
  818002
  825505
  825567
]
1.92 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с русской девушк%…"
]
1.58 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск девушк"
]
1.57 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.90%)
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.