Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.54 ms
(85.18%)
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
  147369
  149622
  150261
  305824
  345303
  396944
  400409
  401875
  421597
  426781
  443591
  452702
  470915
  473298
  476377
  485497
  485848
  493080
  508256
  537389
  543925
  552793
  554576
  560254
  565607
  566193
  568788
  578933
  591440
  602818
  612513
  613288
  613338
  619936
  624989
  625298
  626894
  642130
  647259
  648658
  648715
  653006
  658457
  661425
  661449
  662585
  664649
  668698
  671501
  671824
  674257
  674549
  675503
  683649
  686148
  689177
  691807
  697199
  707865
  712380
  712639
  713766
  713989
  716311
  719491
  720953
  722352
  723087
  742097
  742808
  743892
  745954
  749900
  754401
  754935
  756470
  757835
  760517
  761611
  761633
  761642
  761812
  764616
  766059
  766220
  767973
  768705
  769119
  771919
  772537
  773910
  775429
  777618
  778245
  780080
  782035
  782036
  782125
  783815
  784322
  784777
  784886
  786072
  787587
  789622
  790294
  791720
  793039
  793198
  793632
  793787
  793816
  794409
  795217
  800128
  802000
  802073
  810083
  811828
  812848
]
13.36 ms
(8.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
  671824
  508256
  150261
  743892
  719491
  791720
  642130
  749900
  648658
  613288
  777618
  707865
  768705
  767973
  782035
  775429
  789622
  661425
  691807
  625298
  761812
  742097
  742808
  568788
  602818
  648715
  722352
  766059
  783815
  713989
  658457
  771919
  793198
  683649
  757835
  662585
  674257
  675503
  613338
  626894
  716311
  723087
  787587
  554576
  578933
  565607
  790294
  452702
  782036
  713766
  674549
  305824
  761633
  761642
  793039
  764616
  778245
  560254
  476377
  647259
  766220
  802000
  810083
  470915
  780080
  686148
  689177
  624989
  712380
  784886
  794409
  795217
  811828
  756470
  772537
  345303
  782125
  493080
  485497
  537389
  671501
  619936
  661449
  149622
  793632
  793816
  784322
  754401
  720953
  400409
  473298
  697199
  552793
  443591
  396944
  786072
  664649
  668698
  612513
  793787
  800128
  421597
  426781
  754935
  566193
  401875
  653006
  760517
  543925
  745954
  761611
  712639
  784777
  147369
  773910
  769119
  802073
  485848
  812848
  591440
]
2.69 ms
(1.75%)
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
  147369
  149622
  150261
  305824
  345303
  396944
  400409
  401875
  421597
  426781
  443591
  452702
  470915
  473298
  476377
  485497
  485848
  493080
  508256
  537389
  543925
  552793
  554576
  560254
  565607
  566193
  568788
  578933
  591440
  602818
  612513
  613288
  613338
  619936
  624989
  625298
  626894
  642130
  647259
  648658
  648715
  653006
  658457
  661425
  661449
  662585
  664649
  668698
  671501
  671824
  674257
  674549
  675503
  683649
  686148
  689177
  691807
  697199
  707865
  712380
  712639
  713766
  713989
  716311
  719491
  720953
  722352
  723087
  742097
  742808
  743892
  745954
  749900
  754401
  754935
  756470
  757835
  760517
  761611
  761633
  761642
  761812
  764616
  766059
  766220
  767973
  768705
  769119
  771919
  772537
  773910
  775429
  777618
  778245
  780080
  782035
  782036
  782125
  783815
  784322
  784777
  784886
  786072
  787587
  789622
  790294
  791720
  793039
  793198
  793632
  793787
  793816
  794409
  795217
  800128
  802000
  802073
  810083
  811828
  812848
]
2.01 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее жена с друго%…"
]
1.74 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск жен друг"
]
1.53 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.91%)
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.