Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.05 ms
(83.77%)
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
  389711
  398812
  408316
  420614
  425275
  431682
  508861
  523946
  532086
  536974
  539544
  545127
  547220
  547898
  553671
  555911
  557005
  557269
  558613
  564820
  572243
  574562
  578748
  578807
  579570
  579642
  584218
  586216
  588487
  588906
  594552
  594561
  601182
  606991
  611866
  616661
  622845
  623943
  632727
  632930
  638097
  638544
  641197
  644133
  651040
  651301
  654286
  664808
  666076
  666100
  667562
  684876
  687121
  687605
  689477
  693420
  695008
  696198
  700902
  702382
  710686
  713710
  716824
  717372
  720086
  721275
  721729
  730670
  730924
  732189
  732853
  733900
  734124
  734690
  737138
  743030
  744093
  744261
  745314
  745520
  745601
  747956
  749394
  752056
  752196
  755780
  757630
  757640
  758860
  759586
  766762
  768241
  768468
  773853
  783139
  784292
  789141
  789598
  790009
  790318
  790931
  791722
  794005
  794536
  798245
  805649
  810295
  811921
  815497
  816683
  817342
  818753
  818832
  821800
  823052
  823285
  824733
  825512
]
13.07 ms
(9.04%)
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
  601182
  594552
  644133
  790009
  811921
  790931
  734690
  759586
  783139
  798245
  758860
  745314
  745601
  749394
  737138
  768241
  632930
  641197
  716824
  794536
  805649
  664808
  555911
  744261
  389711
  818832
  821800
  817342
  825512
  579570
  721275
  547220
  579642
  584218
  588906
  588487
  611866
  638544
  789598
  791722
  734124
  732853
  745520
  730924
  744093
  752196
  768468
  773853
  532086
  523946
  702382
  666100
  818753
  654286
  616661
  606991
  623943
  789141
  790318
  794005
  755780
  730670
  398812
  667562
  747956
  632727
  431682
  824733
  539544
  557269
  545127
  557005
  564820
  574562
  651040
  696198
  687121
  700902
  710686
  695008
  720086
  558613
  572243
  578807
  586216
  594561
  638097
  622845
  784292
  810295
  733900
  732189
  743030
  752056
  757837
  757630
  757640
  766762
  773636
  425275
  408316
  508861
  420614
  823052
  823285
  815497
  816683
  536974
  547898
  578748
  651301
  684876
  689477
  713710
  687605
  693420
  717372
  721729
  666076
  553671
]
3.53 ms
(2.44%)
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
  389711
  398812
  408316
  420614
  425275
  431682
  508861
  523946
  532086
  536974
  539544
  545127
  547220
  547898
  553671
  555911
  557005
  557269
  558613
  564820
  572243
  574562
  578748
  578807
  579570
  579642
  584218
  586216
  588487
  588906
  594552
  594561
  601182
  606991
  611866
  616661
  622845
  623943
  632727
  632930
  638097
  638544
  641197
  644133
  651040
  651301
  654286
  664808
  666076
  666100
  667562
  684876
  687121
  687605
  689477
  693420
  695008
  696198
  700902
  702382
  710686
  713710
  716824
  717372
  720086
  721275
  721729
  730670
  730924
  732189
  732853
  733900
  734124
  734690
  737138
  743030
  744093
  744261
  745314
  745520
  745601
  747956
  749394
  752056
  752196
  755780
  757630
  757640
  758860
  759586
  766762
  768241
  768468
  773853
  783139
  784292
  789141
  789598
  790009
  790318
  790931
  791722
  794005
  794536
  798245
  805649
  810295
  811921
  815497
  816683
  817342
  818753
  818832
  821800
  823052
  823285
  824733
  825512
]
1.82 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cheating девушк"
]
1.76 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cheating girl"
]
1.65 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cheating девушк"
]

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.