Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.63 ms
(83.83%)
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
  439210
  452283
  456036
  462926
  467118
  498388
  498442
  539759
  554977
  557504
  562181
  575300
  575553
  576962
  590838
  593045
  596011
  596158
  604193
  604320
  610704
  631058
  644222
  652079
  656801
  660081
  670902
  686347
  701182
  701541
  703929
  706663
  707558
  709240
  710455
  710856
  711585
  712328
  715530
  715546
  718742
  720171
  726897
  728321
  728896
  729058
  730339
  730361
  732403
  732804
  733089
  734598
  736300
  738321
  738462
  738503
  739677
  739962
  740162
  741780
  742631
  744461
  745186
  746559
  747128
  752696
  755147
  756353
  758658
  758754
  760532
  761061
  761195
  761500
  762915
  765478
  765713
  765791
  766647
  766689
  766850
  767066
  767138
  768388
  771147
  774060
  776544
  776993
  780613
  780683
  784036
  784713
  789849
  790229
  791419
  791537
  791573
  793815
  793819
  797160
  798803
  800638
  800785
  803312
  803534
  803956
  805509
  805518
  810105
  810121
  810134
  812359
  816607
  819339
  823871
  824049
  825941
  826177
  827484
  827502
]
15.40 ms
(9.88%)
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
  800785
  810121
  744461
  730361
  747128
  740162
  575300
  738503
  539759
  456036
  631058
  498388
  498442
  827484
  823871
  715530
  670902
  701541
  660081
  596011
  610704
  734598
  761195
  767138
  733089
  742631
  758658
  745186
  765713
  797160
  780613
  776544
  467118
  452283
  439210
  462926
  710455
  819339
  562181
  701182
  707558
  711585
  710856
  596158
  604193
  590838
  793819
  784036
  784713
  728896
  729058
  765478
  791537
  803312
  805518
  810105
  728321
  732403
  738321
  756353
  738462
  752696
  762915
  767066
  730339
  736300
  739962
  746559
  755147
  761061
  766689
  720171
  791573
  803956
  812359
  554977
  593045
  803534
  741780
  766647
  709240
  826177
  827502
  816607
  824049
  825941
  557504
  706663
  718742
  652079
  656801
  712328
  715546
  686347
  703929
  575553
  576962
  604320
  644222
  798803
  776993
  780683
  790229
  732804
  761500
  789849
  791419
  793815
  800638
  805509
  810134
  739677
  768388
  726897
  758754
  766850
  760532
  765791
  771147
  774060
]
3.12 ms
(2.00%)
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
  439210
  452283
  456036
  462926
  467118
  498388
  498442
  539759
  554977
  557504
  562181
  575300
  575553
  576962
  590838
  593045
  596011
  596158
  604193
  604320
  610704
  631058
  644222
  652079
  656801
  660081
  670902
  686347
  701182
  701541
  703929
  706663
  707558
  709240
  710455
  710856
  711585
  712328
  715530
  715546
  718742
  720171
  726897
  728321
  728896
  729058
  730339
  730361
  732403
  732804
  733089
  734598
  736300
  738321
  738462
  738503
  739677
  739962
  740162
  741780
  742631
  744461
  745186
  746559
  747128
  752696
  755147
  756353
  758658
  758754
  760532
  761061
  761195
  761500
  762915
  765478
  765713
  765791
  766647
  766689
  766850
  767066
  767138
  768388
  771147
  774060
  776544
  776993
  780613
  780683
  784036
  784713
  789849
  790229
  791419
  791537
  791573
  793815
  793819
  797160
  798803
  800638
  800785
  803312
  803534
  803956
  805509
  805518
  810105
  810121
  810134
  812359
  816607
  819339
  823871
  824049
  825941
  826177
  827484
  827502
]
1.97 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature onlyfans"
]
1.73 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature онлифанс социальн сет"
]
1.53 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature онлифанс социальн сет"
]
1.45 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.