Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
290.83 ms
(91.96%)
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
  31583
  118900
  199865
  210576
  309095
  388213
  410193
  413262
  425935
  429252
  464137
  472305
  490586
  491010
  492164
  497660
  512932
  521447
  525062
  525481
  527596
  530658
  531955
  535371
  535601
  539598
  542322
  544032
  546814
  552547
  554046
  556093
  556593
  556673
  559345
  560166
  560502
  563132
  570890
  579455
  580944
  580956
  581004
  581621
  584293
  584363
  588293
  588596
  594409
  594872
  605225
  607025
  615650
  616276
  618659
  619132
  622036
  627894
  641479
  642962
  644847
  644905
  661329
  661342
  661576
  665302
  666014
  677749
  685527
  687304
  689868
  695984
  696688
  701204
  701623
  701644
  712570
  725793
  732923
  733506
  736031
  737569
  738352
  753028
  761483
  768503
  768770
  771406
  778228
  782292
  784252
  785136
  788137
  789025
  789062
  790380
  790881
  792598
  792623
  792786
  798169
  798821
  804263
  804418
  804636
  808295
  810621
  812523
  817627
  819195
  823121
  824269
  828039
  828060
  828138
  828197
  828371
  828372
  828425
  828762
]
16.07 ms
(5.08%)
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
  812523
  792786
  580944
  789025
  732923
  560166
  556593
  824269
  828371
  792623
  733506
  828138
  792598
  810621
  531955
  771406
  425935
  472305
  491010
  525062
  527596
  199865
  695984
  828060
  588596
  790881
  619132
  594409
  539598
  737569
  642962
  701204
  685527
  661576
  701623
  701644
  118900
  580956
  556673
  788137
  490586
  388213
  828762
  644905
  823121
  581621
  627894
  804636
  661342
  546814
  666014
  804418
  736031
  696688
  615650
  535371
  725793
  309095
  559345
  828425
  828039
  689868
  544032
  665302
  782292
  521447
  790380
  738352
  641479
  761483
  828372
  828197
  210576
  31583
  429252
  588293
  661329
  677749
  497660
  753028
  819195
  584293
  616276
  413262
  784252
  552547
  556093
  768770
  622036
  817627
  525481
  512932
  712570
  804263
  579455
  594872
  798169
  798821
  808295
  605225
  410193
  644847
  560502
  570890
  581004
  584363
  542322
  554046
  563132
  687304
  607025
  789062
  768503
  785136
  492164
  535601
  530658
  778228
  464137
  618659
]
2.77 ms
(0.87%)
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
  31583
  118900
  199865
  210576
  309095
  388213
  410193
  413262
  425935
  429252
  464137
  472305
  490586
  491010
  492164
  497660
  512932
  521447
  525062
  525481
  527596
  530658
  531955
  535371
  535601
  539598
  542322
  544032
  546814
  552547
  554046
  556093
  556593
  556673
  559345
  560166
  560502
  563132
  570890
  579455
  580944
  580956
  581004
  581621
  584293
  584363
  588293
  588596
  594409
  594872
  605225
  607025
  615650
  616276
  618659
  619132
  622036
  627894
  641479
  642962
  644847
  644905
  661329
  661342
  661576
  665302
  666014
  677749
  685527
  687304
  689868
  695984
  696688
  701204
  701623
  701644
  712570
  725793
  732923
  733506
  736031
  737569
  738352
  753028
  761483
  768503
  768770
  771406
  778228
  782292
  784252
  785136
  788137
  789025
  789062
  790380
  790881
  792598
  792623
  792786
  798169
  798821
  804263
  804418
  804636
  808295
  810621
  812523
  817627
  819195
  823121
  824269
  828039
  828060
  828138
  828197
  828371
  828372
  828425
  828762
]
1.81 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits public"
]
1.70 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ на улиц"
]
1.67 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.44%)
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.