Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.61 ms
(55.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stepsister sex"
]
135.73 ms
(36.11%)
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
  386808
  414156
  416072
  424929
  427575
  431500
  431507
  432327
  441940
  450014
  450503
  450896
  451815
  453879
  466320
  467809
  477603
  482453
  489641
  489656
  490268
  500162
  501965
  502195
  504055
  510116
  510391
  510701
  512128
  513016
  513027
  513459
  515046
  515894
  516241
  517699
  518943
  521378
  521699
  524669
  528379
  537022
  537391
  543306
  546054
  549475
  549630
  554112
  555672
  556865
  557226
  562097
  564358
  567722
  571124
  578025
  583257
  584688
  587370
  591389
  591502
  592651
  596919
  599373
  599542
  603807
  610429
  612687
  620419
  621222
  621351
  621537
  621582
  623715
  624314
  628037
  628497
  646719
  667813
  670180
  678807
  682235
  684511
  696345
  697159
  700727
  704029
  709965
  714975
  717367
  720200
  721512
  722194
  724198
  724491
  744961
  747597
  756408
  757649
  758264
  767184
  771289
  780330
  784992
  785849
  788482
  793883
  796767
  799374
  803807
  810138
  812422
  813593
  821598
  825093
  825706
  825812
  827362
  827410
  828434
]
24.04 ms
(6.40%)
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
  788482
  799374
  714975
  466320
  515894
  554112
  562097
  709965
  724491
  555672
  646719
  682235
  477603
  467809
  793883
  813593
  717367
  621537
  546054
  667813
  610429
  796767
  757649
  803807
  427575
  450014
  720200
  771289
  780330
  584688
  678807
  812422
  571124
  628497
  724198
  414156
  564358
  684511
  515046
  521378
  621582
  501965
  784992
  517699
  596919
  504055
  696345
  821598
  722194
  521699
  549630
  744961
  670180
  704029
  785849
  453879
  537022
  567722
  591502
  747597
  510701
  697159
  386808
  721512
  513027
  500162
  528379
  591389
  441940
  450896
  513459
  612687
  628037
  599542
  432327
  537391
  587370
  557226
  599373
  543306
  490268
  424929
  513016
  451815
  524669
  549475
  623715
  431500
  512128
  583257
  450503
  516241
  482453
  502195
  489641
  431507
  620419
  489656
  518943
  621222
  416072
  510116
  603807
  624314
  756408
  827410
  825706
  556865
  510391
  758264
  810138
  578025
  700727
  621351
  767184
  592651
  825812
  827362
  825093
  828434
]
2.93 ms
(0.78%)
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
  386808
  414156
  416072
  424929
  427575
  431500
  431507
  432327
  441940
  450014
  450503
  450896
  451815
  453879
  466320
  467809
  477603
  482453
  489641
  489656
  490268
  500162
  501965
  502195
  504055
  510116
  510391
  510701
  512128
  513016
  513027
  513459
  515046
  515894
  516241
  517699
  518943
  521378
  521699
  524669
  528379
  537022
  537391
  543306
  546054
  549475
  549630
  554112
  555672
  556865
  557226
  562097
  564358
  567722
  571124
  578025
  583257
  584688
  587370
  591389
  591502
  592651
  596919
  599373
  599542
  603807
  610429
  612687
  620419
  621222
  621351
  621537
  621582
  623715
  624314
  628037
  628497
  646719
  667813
  670180
  678807
  682235
  684511
  696345
  697159
  700727
  704029
  709965
  714975
  717367
  720200
  721512
  722194
  724198
  724491
  744961
  747597
  756408
  757649
  758264
  767184
  771289
  780330
  784992
  785849
  788482
  793883
  796767
  799374
  803807
  810138
  812422
  813593
  821598
  825093
  825706
  825812
  827362
  827410
  828434
]
1.84 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stepsister секс"
]
1.30 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stepsister секс"
]

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.