Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.88 ms
(82.90%)
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
  7178
  385381
  393081
  397910
  398800
  401666
  402375
  409682
  413183
  414643
  422147
  422298
  433375
  443166
  460704
  468581
  480432
  510132
  523843
  563263
  585989
  586456
  596204
  601544
  601553
  601843
  602293
  604313
  607371
  612816
  613122
  625887
  626292
  626965
  630487
  638991
  642371
  644296
  705710
  708462
  711417
  716165
  716750
  723643
  725570
  725581
  725626
  732248
  733645
  738528
  740792
  740919
  741291
  741541
  741607
  742315
  744654
  747310
  748975
  749668
  751510
  751611
  756216
  756241
  766707
  767175
  774691
  775751
  775810
  777544
  777727
  777750
  778055
  778379
  782400
  786129
  787857
  789521
  790572
  791486
  792135
  792633
  795538
  797443
  797504
  798344
  798509
  799413
  800288
  800492
  801205
  801483
  803415
  804504
  805222
  805424
  805431
  805586
  805777
  806077
  806104
  806686
  806794
  807353
  807539
  810975
  811029
  811325
  813014
  813105
  813516
  815095
  815508
  817860
  818283
  818903
  820641
  821688
  825304
  826910
]
15.62 ms
(10.05%)
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
  612816
  613122
  642371
  604313
  585989
  586456
  596204
  601544
  601553
  601843
  602293
  607371
  774691
  775751
  775810
  777750
  791486
  795538
  797504
  798344
  803415
  804504
  805222
  805431
  805586
  805777
  806104
  806794
  807353
  811325
  813105
  777727
  778055
  787857
  792135
  797443
  799413
  800288
  800492
  801205
  805424
  806686
  807539
  810975
  811029
  813516
  725626
  733645
  740792
  748975
  751611
  782400
  786129
  801483
  732248
  741607
  756216
  756241
  766707
  767175
  747310
  725581
  741291
  742315
  744654
  751510
  725570
  738528
  740919
  741541
  626292
  644296
  705710
  708462
  711417
  716165
  716750
  777544
  778379
  789521
  790572
  792633
  798509
  806077
  813014
  397910
  443166
  460704
  468581
  7178
  385381
  393081
  398800
  401666
  413183
  422147
  402375
  414643
  523843
  510132
  563263
  630487
  625887
  749668
  433375
  638991
  626965
  409682
  480432
  422298
  815095
  815508
  825304
  723643
  820641
  821688
  826910
  817860
  818283
  818903
]
3.13 ms
(2.02%)
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
  7178
  385381
  393081
  397910
  398800
  401666
  402375
  409682
  413183
  414643
  422147
  422298
  433375
  443166
  460704
  468581
  480432
  510132
  523843
  563263
  585989
  586456
  596204
  601544
  601553
  601843
  602293
  604313
  607371
  612816
  613122
  625887
  626292
  626965
  630487
  638991
  642371
  644296
  705710
  708462
  711417
  716165
  716750
  723643
  725570
  725581
  725626
  732248
  733645
  738528
  740792
  740919
  741291
  741541
  741607
  742315
  744654
  747310
  748975
  749668
  751510
  751611
  756216
  756241
  766707
  767175
  774691
  775751
  775810
  777544
  777727
  777750
  778055
  778379
  782400
  786129
  787857
  789521
  790572
  791486
  792135
  792633
  795538
  797443
  797504
  798344
  798509
  799413
  800288
  800492
  801205
  801483
  803415
  804504
  805222
  805424
  805431
  805586
  805777
  806077
  806104
  806686
  806794
  807353
  807539
  810975
  811029
  811325
  813014
  813105
  813516
  815095
  815508
  817860
  818283
  818903
  820641
  821688
  825304
  826910
]
2.52 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf mom anal"
]
1.88 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf mom анал"
]
1.80 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf mom анал"
]

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.