Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.74 ms
(83.91%)
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
  543208
  543988
  545786
  557455
  564797
  569213
  583919
  598600
  600465
  611893
  622922
  624467
  625754
  629846
  636386
  644069
  645841
  645881
  648987
  655648
  662060
  663407
  665313
  666324
  667289
  667796
  668182
  670967
  673785
  674277
  674374
  675512
  681461
  682099
  688450
  695373
  696708
  698936
  700635
  701038
  701156
  702176
  709671
  716143
  716191
  717961
  718111
  721477
  721679
  724771
  726580
  726736
  733321
  733351
  739514
  741472
  744172
  746192
  750874
  752167
  755418
  757309
  757447
  758655
  758700
  761026
  762259
  764026
  764107
  765998
  768974
  769978
  770893
  772881
  775569
  776382
  776652
  776733
  776775
  776867
  777500
  777824
  777945
  781027
  782425
  784553
  787300
  787561
  788437
  788725
  789162
  789505
  789720
  789965
  791428
  793511
  795534
  796080
  796268
  796615
  797122
  797243
  798047
  798733
  798746
  800775
  801583
  801660
  803003
  803021
  803100
  803169
  804577
  805299
  807603
  811066
  811986
  812080
  813486
]
12.14 ms
(8.73%)
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
  543988
  564797
  569213
  583919
  543208
  557455
  545786
  645881
  662060
  663407
  667289
  696708
  701038
  716143
  717961
  721477
  655648
  666324
  667796
  668182
  673785
  674277
  674374
  721679
  645841
  648987
  665313
  670967
  675512
  681461
  682099
  688450
  695373
  698936
  700635
  701156
  702176
  709671
  716191
  718111
  600465
  611893
  644069
  598600
  629846
  636386
  622922
  624467
  625754
  776382
  776775
  776867
  777945
  781027
  787561
  789162
  789965
  793511
  798733
  798746
  801583
  801660
  803003
  803021
  803100
  803169
  804577
  811986
  775569
  776652
  776733
  777500
  777824
  788725
  789505
  789720
  791428
  796268
  797243
  798047
  800775
  805299
  812080
  813486
  733321
  739514
  741472
  746192
  752167
  758655
  769978
  772881
  782425
  784553
  787300
  788437
  795534
  796080
  796615
  797122
  807603
  811066
  724771
  726580
  750874
  758700
  761026
  765998
  768974
  733351
  757309
  764454
  770893
  726736
  744172
  755418
  757447
  762259
  764026
  764107
]
2.87 ms
(2.06%)
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
  543208
  543988
  545786
  557455
  564797
  569213
  583919
  598600
  600465
  611893
  622922
  624467
  625754
  629846
  636386
  644069
  645841
  645881
  648987
  655648
  662060
  663407
  665313
  666324
  667289
  667796
  668182
  670967
  673785
  674277
  674374
  675512
  681461
  682099
  688450
  695373
  696708
  698936
  700635
  701038
  701156
  702176
  709671
  716143
  716191
  717961
  718111
  721477
  721679
  724771
  726580
  726736
  733321
  733351
  739514
  741472
  744172
  746192
  750874
  752167
  755418
  757309
  757447
  758655
  758700
  761026
  762259
  764026
  764107
  765998
  768974
  769978
  770893
  772881
  775569
  776382
  776652
  776733
  776775
  776867
  777500
  777824
  777945
  781027
  782425
  784553
  787300
  787561
  788437
  788725
  789162
  789505
  789720
  789965
  791428
  793511
  795534
  796080
  796268
  796615
  797122
  797243
  798047
  798733
  798746
  800775
  801583
  801660
  803003
  803021
  803100
  803169
  804577
  805299
  807603
  811066
  811986
  812080
  813486
]
2.25 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob ass"
]
1.86 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс жоп"
]
1.42 ms
(1.02%)
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.