Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.25 ms
(85.60%)
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
  382220
  549503
  567946
  584035
  584040
  589592
  589672
  591569
  595532
  595894
  596779
  601228
  603262
  603522
  605169
  607476
  607623
  607694
  610142
  612675
  617805
  617812
  618288
  618388
  618612
  620330
  620341
  620491
  625753
  626037
  626066
  626353
  627254
  628633
  628693
  629543
  630432
  635888
  637490
  644147
  649249
  650705
  660430
  666084
  666704
  710357
  710590
  710678
  715114
  718403
  725451
  725492
  726876
  729941
  731034
  732940
  732979
  732994
  734180
  735910
  738033
  739759
  741504
  742280
  743641
  744223
  745516
  746200
  749598
  749618
  749874
  750838
  750861
  751984
  753023
  753033
  757177
  758151
  759127
  759768
  760169
  765463
  765516
  766613
  766709
  766721
  766754
  766778
  769502
  778563
  782395
  782464
  782468
  787797
  797525
  802903
  803755
  803756
  803784
  807589
  807748
  807789
  807914
  811124
  811702
  812387
  814117
  823846
  824065
  824520
  824622
  824962
  824968
  825170
  825264
  825266
  825707
  826169
  827013
  827391
]
14.49 ms
(8.42%)
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
  617812
  759768
  749618
  629543
  814117
  718403
  778563
  812387
  782468
  753033
  766613
  766721
  782464
  715114
  710590
  607623
  627254
  603522
  591569
  601228
  807748
  729941
  759127
  750861
  726876
  742280
  750838
  743641
  757177
  710357
  782395
  741504
  607476
  589672
  811702
  807789
  734180
  746200
  766778
  766754
  618388
  612675
  617805
  610142
  738033
  635888
  649249
  596779
  626037
  620491
  637490
  595894
  803784
  807589
  802903
  753023
  765463
  787797
  735910
  765516
  749874
  769502
  803755
  803756
  811124
  725451
  797525
  739759
  766709
  625753
  618288
  618612
  725492
  825264
  628693
  626066
  628633
  666704
  626353
  731034
  760169
  732994
  826169
  620341
  751984
  824065
  382220
  807914
  827391
  620330
  584040
  589592
  825707
  745516
  758151
  660430
  630432
  607694
  825170
  732940
  666084
  595532
  584035
  567946
  650705
  710678
  603262
  605169
  644147
  744223
  827013
  824968
  549503
  824622
  824962
  823846
  732979
  749598
  824520
  825266
]
2.92 ms
(1.70%)
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
  382220
  549503
  567946
  584035
  584040
  589592
  589672
  591569
  595532
  595894
  596779
  601228
  603262
  603522
  605169
  607476
  607623
  607694
  610142
  612675
  617805
  617812
  618288
  618388
  618612
  620330
  620341
  620491
  625753
  626037
  626066
  626353
  627254
  628633
  628693
  629543
  630432
  635888
  637490
  644147
  649249
  650705
  660430
  666084
  666704
  710357
  710590
  710678
  715114
  718403
  725451
  725492
  726876
  729941
  731034
  732940
  732979
  732994
  734180
  735910
  738033
  739759
  741504
  742280
  743641
  744223
  745516
  746200
  749598
  749618
  749874
  750838
  750861
  751984
  753023
  753033
  757177
  758151
  759127
  759768
  760169
  765463
  765516
  766613
  766709
  766721
  766754
  766778
  769502
  778563
  782395
  782464
  782468
  787797
  797525
  802903
  803755
  803756
  803784
  807589
  807748
  807789
  807914
  811124
  811702
  812387
  814117
  823846
  824065
  824520
  824622
  824962
  824968
  825170
  825264
  825266
  825707
  826169
  827013
  827391
]
2.39 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade bbw"
]
1.90 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск bbw"
]
1.55 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск bbw"
]
1.53 ms
(0.89%)
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.