Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.41 ms
(83.71%)
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
  398588
  402892
  422129
  422350
  425733
  441815
  452694
  467859
  479200
  512413
  535806
  546560
  552385
  557922
  559616
  560791
  575238
  584956
  585905
  586978
  593810
  597829
  623407
  624028
  628702
  634597
  634614
  634619
  653952
  663223
  666402
  674616
  675410
  689970
  692710
  695693
  697731
  703327
  704361
  710784
  712526
  717958
  722121
  722124
  722165
  723156
  724688
  725331
  726939
  728865
  731140
  731277
  731429
  733138
  733297
  734007
  734140
  735009
  735322
  735446
  736497
  739253
  740005
  741760
  743422
  749417
  749592
  752082
  755615
  763108
  763573
  763634
  764581
  764749
  766966
  767805
  768803
  772371
  772826
  774265
  777452
  777508
  777928
  778753
  779047
  779533
  779781
  780233
  781465
  782691
  783831
  784056
  784196
  784686
  786821
  787116
  787273
  787409
  787421
  787470
  790705
  791250
  792208
  793759
  799991
  803416
  803421
  808840
  810216
  813323
  814675
  816156
  819332
  820091
  825364
  825399
  825977
  827031
  827141
]
13.94 ms
(8.31%)
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
  723156
  779781
  787470
  783831
  739253
  763573
  782691
  787421
  790705
  731277
  763108
  763634
  731429
  764581
  779047
  781465
  784056
  803421
  810216
  402892
  559616
  634614
  743422
  808840
  735446
  441815
  552385
  634597
  725331
  726939
  722124
  512413
  689970
  791250
  422129
  535806
  546560
  663223
  703327
  666402
  674616
  695693
  697731
  704361
  710784
  624028
  623407
  634619
  597829
  787273
  749592
  784686
  724688
  766966
  728865
  717958
  820091
  452694
  653952
  675410
  712526
  628702
  593810
  586978
  803416
  784196
  479200
  692710
  585905
  560791
  467859
  398588
  825364
  825399
  827031
  827141
  816156
  819332
  722165
  575238
  584956
  777452
  777508
  778753
  787116
  799991
  777928
  779533
  792208
  813323
  749417
  755615
  767805
  772371
  772826
  787409
  734007
  764749
  774265
  731140
  735322
  736497
  752082
  765378
  733297
  740005
  768803
  735009
  722121
  780233
  786821
  793759
  422350
  814675
  557922
  734140
  741760
  733138
  425733
  825977
]
6.37 ms
(3.80%)
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
  398588
  402892
  422129
  422350
  425733
  441815
  452694
  467859
  479200
  512413
  535806
  546560
  552385
  557922
  559616
  560791
  575238
  584956
  585905
  586978
  593810
  597829
  623407
  624028
  628702
  634597
  634614
  634619
  653952
  663223
  666402
  674616
  675410
  689970
  692710
  695693
  697731
  703327
  704361
  710784
  712526
  717958
  722121
  722124
  722165
  723156
  724688
  725331
  726939
  728865
  731140
  731277
  731429
  733138
  733297
  734007
  734140
  735009
  735322
  735446
  736497
  739253
  740005
  741760
  743422
  749417
  749592
  752082
  755615
  763108
  763573
  763634
  764581
  764749
  766966
  767805
  768803
  772371
  772826
  774265
  777452
  777508
  777928
  778753
  779047
  779533
  779781
  780233
  781465
  782691
  783831
  784056
  784196
  784686
  786821
  787116
  787273
  787409
  787421
  787470
  790705
  791250
  792208
  793759
  799991
  803416
  803421
  808840
  810216
  813323
  814675
  816156
  819332
  820091
  825364
  825399
  825977
  827031
  827141
]
2.03 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск cum mouth"
]
1.95 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur cum mouth"
]
1.58 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск cum mouth"
]

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.