Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.09 ms
(88.06%)
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
  186948
  233187
  266977
  384128
  386042
  388722
  389616
  390542
  390567
  391025
  391967
  395878
  395897
  396344
  398803
  404503
  405830
  405859
  406062
  407783
  407819
  411690
  411702
  411704
  411718
  411722
  413081
  424429
  432350
  442634
  443177
  443408
  443756
  443761
  447745
  451491
  454177
  454247
  454560
  458000
  458014
  458929
  460757
  460923
  462705
  465347
  465397
  465399
  466051
  466350
  468097
  470289
  470768
  470977
  470980
  471710
  474478
  474479
  474480
  474490
  474674
  474680
  476262
  476284
  477961
  479053
  479073
  479078
  479079
  479106
  479148
  479765
  484586
  484625
  484626
  486341
  486345
  486542
  488377
  490013
  505652
  513201
  523164
  526733
  526832
  529338
  539658
  544478
  555745
  557932
  563148
  563779
  589691
  590303
  591197
  609071
  612922
  618513
  624466
  624791
  640724
  646807
  697302
  707441
  719121
  730361
  738327
  742574
  744203
  746095
  746686
  748254
  759011
  762186
  780661
  803510
  808125
  810056
  823916
  825243
]
15.62 ms
(7.72%)
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
  759011
  810056
  738327
  748254
  730361
  744203
  746095
  612922
  640724
  391967
  462705
  384128
  233187
  390542
  390567
  407783
  442634
  411690
  411702
  443177
  458014
  470980
  458929
  471710
  488377
  505652
  490013
  563148
  557932
  590303
  609071
  424429
  443756
  447745
  396344
  404503
  443408
  454560
  465397
  470289
  479148
  395878
  432350
  466350
  470977
  479106
  411722
  186948
  391025
  405859
  406062
  413081
  407819
  460923
  474479
  476262
  479053
  486542
  523164
  746686
  465347
  466051
  470768
  474490
  454247
  465399
  474480
  476284
  479079
  460757
  477961
  479078
  388722
  405830
  411704
  454177
  458000
  479073
  443761
  451491
  468097
  474478
  474674
  479765
  484625
  526832
  484586
  484626
  486345
  513201
  386042
  266977
  539658
  563779
  624466
  589691
  624791
  742574
  808125
  762186
  719121
  803510
  823916
  529338
  526733
  618513
  780661
  544478
  591197
  707441
  411718
  474680
  486341
  646807
  697302
  825243
  555745
  395897
  389616
  398803
]
2.17 ms
(1.07%)
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
  186948
  233187
  266977
  384128
  386042
  388722
  389616
  390542
  390567
  391025
  391967
  395878
  395897
  396344
  398803
  404503
  405830
  405859
  406062
  407783
  407819
  411690
  411702
  411704
  411718
  411722
  413081
  424429
  432350
  442634
  443177
  443408
  443756
  443761
  447745
  451491
  454177
  454247
  454560
  458000
  458014
  458929
  460757
  460923
  462705
  465347
  465397
  465399
  466051
  466350
  468097
  470289
  470768
  470977
  470980
  471710
  474478
  474479
  474480
  474490
  474674
  474680
  476262
  476284
  477961
  479053
  479073
  479078
  479079
  479106
  479148
  479765
  484586
  484625
  484626
  486341
  486345
  486542
  488377
  490013
  505652
  513201
  523164
  526733
  526832
  529338
  539658
  544478
  555745
  557932
  563148
  563779
  589691
  590303
  591197
  609071
  612922
  618513
  624466
  624791
  640724
  646807
  697302
  707441
  719121
  730361
  738327
  742574
  744203
  746095
  746686
  748254
  759011
  762186
  780661
  803510
  808125
  810056
  823916
  825243
]
1.95 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature mature hairy"
]
1.68 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature mature волосатая"
]
1.52 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature mature волосатая"
]

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.