Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.62 ms
(86.26%)
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
  361286
  383162
  385040
  391208
  395237
  396278
  396780
  401724
  405990
  408047
  410132
  411880
  416128
  417660
  418528
  419764
  419906
  419914
  420206
  420216
  420499
  420613
  421198
  422832
  423202
  428458
  428518
  429541
  430273
  432136
  438765
  445054
  445879
  446217
  446266
  446355
  446882
  450399
  451961
  452054
  454685
  456633
  456929
  458101
  458369
  458382
  460022
  464714
  467744
  468553
  469536
  473756
  473766
  492815
  497453
  497459
  507258
  507670
  512172
  512218
  513087
  513193
  517685
  519291
  521048
  527610
  529833
  531222
  540175
  543919
  550721
  556428
  559162
  559943
  565475
  566845
  574467
  574940
  575344
  590280
  596514
  602491
  605848
  610201
  622201
  623822
  624831
  628916
  637757
  649870
  651979
  653843
  655882
  688319
  691050
  718677
  718994
  720872
  724590
  727633
  727853
  730872
  731576
  733885
  733905
  733913
  743069
  747952
  748670
  749812
  753216
  761468
  762110
  785005
  792337
  807970
  808775
  822075
  827831
  827832
]
13.99 ms
(7.91%)
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
  385040
  575344
  628916
  762110
  418528
  456633
  420206
  827831
  512172
  391208
  419906
  417660
  452054
  464714
  473766
  512218
  513193
  521048
  419914
  438765
  822075
  623822
  383162
  411880
  430273
  423202
  446355
  456929
  497453
  531222
  540175
  507258
  473756
  624831
  610201
  733885
  733905
  727633
  432136
  446882
  408047
  460022
  517685
  519291
  543919
  748670
  559943
  556428
  720872
  429541
  550721
  428518
  458101
  651979
  574940
  605848
  792337
  808775
  420499
  565475
  566845
  649870
  653843
  785005
  747952
  458369
  691050
  622201
  733913
  727853
  655882
  688319
  718677
  718994
  637757
  743069
  753216
  724590
  731576
  749812
  807970
  445879
  596514
  574467
  467744
  419764
  420216
  468553
  422832
  602491
  361286
  416128
  445054
  446217
  451961
  454685
  492815
  513087
  529833
  761468
  458382
  450399
  497459
  405990
  396278
  420613
  428458
  469536
  446266
  590280
  410132
  507670
  730872
  827832
  527610
  559162
  395237
  396780
  401724
  421198
]
3.28 ms
(1.85%)
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
  361286
  383162
  385040
  391208
  395237
  396278
  396780
  401724
  405990
  408047
  410132
  411880
  416128
  417660
  418528
  419764
  419906
  419914
  420206
  420216
  420499
  420613
  421198
  422832
  423202
  428458
  428518
  429541
  430273
  432136
  438765
  445054
  445879
  446217
  446266
  446355
  446882
  450399
  451961
  452054
  454685
  456633
  456929
  458101
  458369
  458382
  460022
  464714
  467744
  468553
  469536
  473756
  473766
  492815
  497453
  497459
  507258
  507670
  512172
  512218
  513087
  513193
  517685
  519291
  521048
  527610
  529833
  531222
  540175
  543919
  550721
  556428
  559162
  559943
  565475
  566845
  574467
  574940
  575344
  590280
  596514
  602491
  605848
  610201
  622201
  623822
  624831
  628916
  637757
  649870
  651979
  653843
  655882
  688319
  691050
  718677
  718994
  720872
  724590
  727633
  727853
  730872
  731576
  733885
  733905
  733913
  743069
  747952
  748670
  749812
  753216
  761468
  762110
  785005
  792337
  807970
  808775
  822075
  827831
  827832
]
2.07 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dick asian"
]
1.89 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член азиатк"
]
1.52 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член азиатк"
]

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.