Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.59 ms
(84.99%)
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
  385600
  438665
  506238
  511013
  546563
  592127
  615471
  616344
  627218
  635812
  640879
  659424
  671915
  678647
  709284
  720845
  721803
  722094
  722117
  722151
  723216
  724874
  725053
  726316
  726356
  727510
  728711
  728936
  729304
  730165
  730269
  730482
  731125
  731183
  731212
  731218
  731407
  733196
  733447
  734355
  735769
  736145
  737973
  739634
  740864
  741184
  741765
  743006
  743821
  746219
  746301
  748917
  749827
  752273
  752933
  753641
  755830
  756296
  761282
  761401
  763232
  763502
  764313
  765145
  765369
  766092
  767519
  767521
  767721
  769074
  769599
  770026
  770693
  772256
  772307
  772376
  772443
  773375
  773378
  773502
  777489
  777521
  777542
  778929
  779410
  779511
  779550
  779822
  781036
  781531
  781553
  781612
  784084
  784685
  785889
  785987
  786067
  787147
  787229
  787230
  791608
  791630
  791825
  792210
  793245
  793473
  793929
  795028
  797319
  797363
  798503
  799758
  800951
  803418
  805111
  810361
  813297
  826345
  827407
]
11.41 ms
(7.98%)
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
  659424
  720845
  721803
  546563
  640879
  592127
  615471
  777542
  779822
  781612
  785987
  787229
  791630
  793245
  793473
  797363
  798503
  799758
  779511
  781036
  785889
  792210
  795028
  800951
  805111
  724874
  725053
  730165
  730482
  731183
  731407
  733447
  734355
  737973
  743006
  746219
  748917
  752273
  755830
  761282
  761401
  763232
  767521
  770693
  772256
  772307
  781553
  784084
  786067
  793929
  797319
  803418
  727510
  739634
  753641
  769074
  770026
  772376
  726316
  726356
  733196
  735769
  736145
  741765
  743821
  752933
  756296
  763502
  764313
  765145
  772443
  728711
  730269
  740864
  749827
  765369
  767519
  769599
  728936
  729304
  731125
  731212
  731218
  741184
  746301
  766092
  767721
  773375
  773378
  773502
  722094
  722117
  722151
  723216
  777489
  778929
  779550
  781531
  784685
  787147
  787230
  787316
  791608
  791825
  438665
  511013
  671915
  777521
  678647
  709284
  627218
  616344
  635812
  826345
  827407
  506238
  779410
  813297
  810361
  385600
]
3.31 ms
(2.31%)
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
  385600
  438665
  506238
  511013
  546563
  592127
  615471
  616344
  627218
  635812
  640879
  659424
  671915
  678647
  709284
  720845
  721803
  722094
  722117
  722151
  723216
  724874
  725053
  726316
  726356
  727510
  728711
  728936
  729304
  730165
  730269
  730482
  731125
  731183
  731212
  731218
  731407
  733196
  733447
  734355
  735769
  736145
  737973
  739634
  740864
  741184
  741765
  743006
  743821
  746219
  746301
  748917
  749827
  752273
  752933
  753641
  755830
  756296
  761282
  761401
  763232
  763502
  764313
  765145
  765369
  766092
  767519
  767521
  767721
  769074
  769599
  770026
  770693
  772256
  772307
  772376
  772443
  773375
  773378
  773502
  777489
  777521
  777542
  778929
  779410
  779511
  779550
  779822
  781036
  781531
  781553
  781612
  784084
  784685
  785889
  785987
  786067
  787147
  787229
  787230
  791608
  791630
  791825
  792210
  793245
  793473
  793929
  795028
  797319
  797363
  798503
  799758
  800951
  803418
  805111
  810361
  813297
  826345
  827407
]
2.06 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth любительск"
]
1.65 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth amateur"
]
1.42 ms
(0.99%)
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.