Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.64 ms
(80.54%)
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
  305824
  444893
  452702
  456484
  458148
  470915
  476377
  536950
  543381
  545069
  547951
  554576
  560130
  565607
  568171
  568788
  578933
  584054
  585091
  602818
  610999
  613288
  613338
  616688
  621780
  622179
  624012
  624818
  625298
  626894
  632568
  640587
  641490
  642130
  642517
  648658
  653347
  654212
  658457
  661425
  662585
  668135
  668136
  673924
  674257
  674549
  675503
  683649
  690002
  691807
  692464
  693010
  693420
  695373
  695777
  695856
  703935
  707865
  713454
  713766
  713989
  716311
  719491
  720564
  721677
  722352
  723087
  728502
  731504
  732733
  732867
  736499
  736612
  742097
  742685
  742808
  742986
  746930
  749632
  749900
  753505
  753581
  754173
  757835
  760188
  761812
  762132
  762689
  762803
  764845
  765296
  766059
  767819
  767973
  768705
  771919
  772010
  772336
  775429
  776528
  777618
  778231
  778245
  778292
  780376
  782035
  782036
  783612
  783815
  787587
  789622
  790131
  790290
  790294
  791720
  793198
  793654
  794308
  805339
  810034
]
18.22 ms
(11.50%)
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
  695373
  721677
  658457
  695856
  692464
  760188
  668135
  621780
  731504
  762803
  584054
  690002
  764845
  728502
  746930
  668136
  568171
  736612
  736499
  778292
  673924
  810034
  742986
  772010
  790131
  754173
  762689
  654212
  693010
  778231
  790290
  642517
  794308
  762132
  703935
  545069
  753581
  693420
  653347
  536950
  624012
  641490
  732867
  749632
  640587
  780376
  767819
  610999
  616688
  622179
  720564
  765296
  776528
  783612
  772336
  793654
  632568
  543381
  805339
  444893
  695777
  742685
  713454
  560130
  624818
  753505
  458148
  547951
  456484
  732733
  719491
  585091
  749900
  791720
  642130
  648658
  613288
  707865
  767973
  768705
  782035
  661425
  691807
  625298
  775429
  789622
  761812
  722352
  766059
  783815
  568788
  602818
  742097
  742808
  777618
  683649
  554576
  793198
  771919
  723087
  787587
  662585
  674257
  675503
  613338
  626894
  716311
  757835
  674549
  578933
  565607
  713766
  476377
  790294
  305824
  713989
  452702
  782036
  470915
  778245
]
4.56 ms
(2.88%)
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
  305824
  444893
  452702
  456484
  458148
  470915
  476377
  536950
  543381
  545069
  547951
  554576
  560130
  565607
  568171
  568788
  578933
  584054
  585091
  602818
  610999
  613288
  613338
  616688
  621780
  622179
  624012
  624818
  625298
  626894
  632568
  640587
  641490
  642130
  642517
  648658
  653347
  654212
  658457
  661425
  662585
  668135
  668136
  673924
  674257
  674549
  675503
  683649
  690002
  691807
  692464
  693010
  693420
  695373
  695777
  695856
  703935
  707865
  713454
  713766
  713989
  716311
  719491
  720564
  721677
  722352
  723087
  728502
  731504
  732733
  732867
  736499
  736612
  742097
  742685
  742808
  742986
  746930
  749632
  749900
  753505
  753581
  754173
  757835
  760188
  761812
  762132
  762689
  762803
  764845
  765296
  766059
  767819
  767973
  768705
  771919
  772010
  772336
  775429
  776528
  777618
  778231
  778245
  778292
  780376
  782035
  782036
  783612
  783815
  787587
  789622
  790131
  790290
  790294
  791720
  793198
  793654
  794308
  805339
  810034
]
2.88 ms
(1.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жену с другом частное…"
]
1.85 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен друг любительск"
]
1.57 ms
(0.99%)
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.