Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.43 ms
(84.75%)
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
  384364
  407182
  417068
  422495
  432384
  435388
  437994
  438109
  440533
  441762
  447224
  450118
  457324
  457580
  461180
  489715
  499128
  521002
  526590
  552363
  552594
  552802
  552853
  558336
  558484
  562053
  565328
  575167
  580559
  587655
  601897
  603740
  605002
  612942
  613347
  614755
  616946
  627886
  641919
  655476
  666417
  682943
  683478
  694617
  695690
  695779
  696235
  696721
  707530
  707574
  710041
  713753
  729165
  733386
  734129
  740139
  747555
  748895
  749565
  755048
  756718
  759767
  762470
  762480
  763733
  765100
  767399
  767519
  772353
  772793
  777827
  777846
  778028
  778034
  778286
  778748
  779008
  779075
  779902
  782332
  783052
  786080
  786577
  786928
  788013
  789726
  789924
  790235
  790701
  791102
  794001
  794264
  795575
  795985
  796103
  796726
  796973
  797821
  798874
  802012
  802685
  803518
  804566
  805141
  805152
  806574
  807284
  807360
  810373
  810531
  813326
  813957
  818247
  819863
  820369
  821717
  823655
  824647
  825385
  826650
]
14.48 ms
(9.41%)
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
  786577
  788013
  794264
  796103
  802012
  802685
  440533
  438109
  450118
  489715
  558336
  565328
  666417
  605002
  790235
  805141
  807360
  777846
  805152
  734129
  733386
  767519
  457580
  461180
  432384
  435388
  441762
  813957
  820369
  824647
  825385
  826650
  821717
  823655
  818247
  819863
  457324
  499128
  526590
  580559
  562053
  552594
  552853
  558484
  655476
  682943
  683478
  695690
  696721
  694617
  695779
  707530
  696235
  710041
  575167
  627886
  641919
  613347
  601897
  603740
  616946
  612942
  614755
  777827
  779008
  779075
  789726
  789924
  790701
  791102
  798874
  804566
  813326
  778286
  783052
  786080
  795985
  796726
  803518
  807284
  755048
  763733
  772793
  782332
  786928
  794001
  795575
  748895
  749565
  765100
  762480
  729165
  740139
  756718
  762470
  767399
  772353
  747555
  759767
  707574
  713753
  778028
  778034
  778748
  779902
  796973
  797821
  806574
  810373
  437994
  447224
  521002
  384364
  407182
  552802
  552363
  587655
  810531
  417068
  422495
]
2.65 ms
(1.72%)
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
  384364
  407182
  417068
  422495
  432384
  435388
  437994
  438109
  440533
  441762
  447224
  450118
  457324
  457580
  461180
  489715
  499128
  521002
  526590
  552363
  552594
  552802
  552853
  558336
  558484
  562053
  565328
  575167
  580559
  587655
  601897
  603740
  605002
  612942
  613347
  614755
  616946
  627886
  641919
  655476
  666417
  682943
  683478
  694617
  695690
  695779
  696235
  696721
  707530
  707574
  710041
  713753
  729165
  733386
  734129
  740139
  747555
  748895
  749565
  755048
  756718
  759767
  762470
  762480
  763733
  765100
  767399
  767519
  772353
  772793
  777827
  777846
  778028
  778034
  778286
  778748
  779008
  779075
  779902
  782332
  783052
  786080
  786577
  786928
  788013
  789726
  789924
  790235
  790701
  791102
  794001
  794264
  795575
  795985
  796103
  796726
  796973
  797821
  798874
  802012
  802685
  803518
  804566
  805141
  805152
  806574
  807284
  807360
  810373
  810531
  813326
  813957
  818247
  819863
  820369
  821717
  823655
  824647
  825385
  826650
]
1.87 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth pov"
]
1.58 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth пов"
]
1.54 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mouth пов"
]

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.