Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.19 ms
(85.62%)
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
  422408
  432975
  436953
  449384
  451005
  462347
  464418
  476153
  481701
  494039
  494815
  500583
  502480
  507422
  518510
  523554
  524240
  527165
  527207
  527690
  543734
  546101
  552762
  555734
  559022
  561343
  564873
  569595
  574469
  578445
  579528
  584339
  586320
  587769
  588885
  589467
  591186
  591771
  592263
  594419
  595037
  599002
  600814
  606253
  607202
  616137
  616438
  619084
  628588
  628590
  630259
  632128
  633558
  634279
  635001
  644199
  647084
  649268
  656147
  666890
  667003
  672779
  695690
  698910
  707530
  708901
  716229
  717288
  735001
  752000
  761343
  761847
  764763
  767479
  768200
  768380
  768441
  768611
  769137
  778032
  781272
  782916
  783617
  785468
  786176
  787356
  787400
  788213
  790171
  791196
  791509
  791818
  792172
  792437
  793237
  794001
  794893
  795555
  795902
  796490
  797565
  799103
  800788
  803943
  805179
  806175
  809765
  812108
  813789
  815001
  818961
  819371
  819901
  820784
  821162
  821186
  821395
  821691
  822057
  823295
]
14.48 ms
(7.99%)
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
  812108
  436953
  481701
  500583
  578445
  502480
  767479
  819371
  819901
  821162
  823295
  820784
  574469
  695690
  579528
  628588
  792172
  786176
  794001
  768380
  632128
  634279
  787356
  462347
  476153
  422408
  432975
  451005
  523554
  546101
  543734
  647084
  667003
  708901
  649268
  656147
  672779
  666890
  589467
  616137
  635001
  588885
  644199
  594419
  616438
  586320
  619084
  628590
  787400
  788213
  792437
  797565
  800788
  752000
  769137
  791509
  794893
  795902
  796490
  803943
  764763
  768611
  768441
  761847
  630259
  633558
  791818
  592263
  805179
  494039
  449384
  494815
  716229
  591771
  527207
  599002
  595037
  821186
  821691
  518510
  809765
  782916
  761343
  607202
  813789
  818961
  815001
  821395
  822057
  464418
  507422
  524240
  527690
  527165
  552762
  561343
  569595
  555734
  559022
  564873
  584339
  698910
  717288
  707530
  587769
  606253
  591186
  600814
  791196
  795555
  799103
  806175
  778032
  793237
  735001
  768200
  781272
  783617
  785468
  790171
]
4.37 ms
(2.41%)
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
  422408
  432975
  436953
  449384
  451005
  462347
  464418
  476153
  481701
  494039
  494815
  500583
  502480
  507422
  518510
  523554
  524240
  527165
  527207
  527690
  543734
  546101
  552762
  555734
  559022
  561343
  564873
  569595
  574469
  578445
  579528
  584339
  586320
  587769
  588885
  589467
  591186
  591771
  592263
  594419
  595037
  599002
  600814
  606253
  607202
  616137
  616438
  619084
  628588
  628590
  630259
  632128
  633558
  634279
  635001
  644199
  647084
  649268
  656147
  666890
  667003
  672779
  695690
  698910
  707530
  708901
  716229
  717288
  735001
  752000
  761343
  761847
  764763
  767479
  768200
  768380
  768441
  768611
  769137
  778032
  781272
  782916
  783617
  785468
  786176
  787356
  787400
  788213
  790171
  791196
  791509
  791818
  792172
  792437
  793237
  794001
  794893
  795555
  795902
  796490
  797565
  799103
  800788
  803943
  805179
  806175
  809765
  812108
  813789
  815001
  818961
  819371
  819901
  820784
  821162
  821186
  821395
  821691
  822057
  823295
]
2.24 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy fuck pov"
]
1.75 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy секс пов"
]
1.64 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy секс пов"
]

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.