Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.00 ms
(51.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade old young"
]
172.96 ms
(42.37%)
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
  392903
  396734
  418649
  458025
  463166
  466247
  467320
  470926
  473913
  486821
  492649
  503870
  503922
  509054
  510758
  517273
  517867
  522443
  527513
  539423
  542934
  544749
  545420
  546695
  547656
  565286
  566505
  567942
  569427
  569665
  569675
  574589
  578465
  593847
  602390
  605022
  606260
  615612
  617358
  618030
  623943
  624334
  624664
  630155
  635247
  640922
  641006
  644989
  652988
  665221
  667242
  669606
  677569
  677604
  691205
  692641
  693381
  693410
  693433
  694585
  695849
  701195
  702137
  702522
  702672
  704010
  705462
  707786
  708082
  708399
  708405
  712674
  722443
  724752
  726082
  730367
  730404
  739934
  741998
  743800
  744637
  746993
  748684
  749896
  749940
  754450
  757200
  757846
  759581
  761007
  761171
  763629
  767565
  771344
  780628
  783138
  787948
  789829
  789879
  794990
  795089
  804376
  810316
  810587
  810711
  810894
  816747
  817861
  818083
  820079
  821861
  821862
  823910
  825078
  825492
  825502
  825682
  826734
  826911
  827465
]
14.68 ms
(3.60%)
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
  693433
  606260
  617358
  724752
  739934
  754450
  635247
  787948
  810587
  418649
  542934
  593847
  624664
  470926
  473913
  503922
  708082
  708399
  695849
  780628
  744637
  746993
  810316
  730404
  702672
  667242
  669606
  692641
  702137
  630155
  615612
  641006
  517867
  623943
  794990
  458025
  704010
  463166
  503870
  486821
  759581
  574589
  693410
  730367
  566505
  569675
  569665
  527513
  509054
  818083
  825078
  644989
  826734
  820079
  821861
  823910
  825682
  827465
  545420
  547656
  722443
  544749
  810711
  810894
  749940
  757846
  743800
  763629
  771344
  702522
  783138
  789829
  804376
  510758
  705462
  741998
  605022
  826911
  677569
  567942
  624334
  795089
  757200
  767565
  789879
  761171
  749896
  396734
  539423
  701195
  677604
  565286
  640922
  618030
  726082
  761007
  712674
  392903
  694585
  467320
  578465
  517273
  546695
  652988
  691205
  693381
  708405
  707786
  602390
  492649
  569427
  748684
  466247
  522443
  665221
  825492
  825502
  816747
  817861
  821862
]
2.98 ms
(0.73%)
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
  392903
  396734
  418649
  458025
  463166
  466247
  467320
  470926
  473913
  486821
  492649
  503870
  503922
  509054
  510758
  517273
  517867
  522443
  527513
  539423
  542934
  544749
  545420
  546695
  547656
  565286
  566505
  567942
  569427
  569665
  569675
  574589
  578465
  593847
  602390
  605022
  606260
  615612
  617358
  618030
  623943
  624334
  624664
  630155
  635247
  640922
  641006
  644989
  652988
  665221
  667242
  669606
  677569
  677604
  691205
  692641
  693381
  693410
  693433
  694585
  695849
  701195
  702137
  702522
  702672
  704010
  705462
  707786
  708082
  708399
  708405
  712674
  722443
  724752
  726082
  730367
  730404
  739934
  741998
  743800
  744637
  746993
  748684
  749896
  749940
  754450
  757200
  757846
  759581
  761007
  761171
  763629
  767565
  771344
  780628
  783138
  787948
  789829
  789879
  794990
  795089
  804376
  810316
  810587
  810711
  810894
  816747
  817861
  818083
  820079
  821861
  821862
  823910
  825078
  825492
  825502
  825682
  826734
  826911
  827465
]
2.10 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск old young"
]
1.79 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск old young"
]
1.66 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.