Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.11 ms
(84.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
  384233
  386024
  399223
  400689
  400854
  400989
  401216
  416606
  420416
  423314
  430057
  432685
  432802
  435468
  439650
  444121
  444579
  446456
  453714
  454250
  456215
  460459
  460723
  460923
  462253
  463169
  464307
  465823
  466966
  470735
  470802
  472912
  475453
  477926
  477965
  479044
  484439
  487067
  492794
  495035
  501139
  502864
  503922
  503928
  503955
  509933
  520748
  522699
  523167
  523171
  526998
  534833
  542934
  545914
  548684
  549582
  551257
  553197
  557608
  566267
  569665
  571210
  576380
  586015
  588331
  597869
  601853
  603294
  605326
  605856
  606102
  607772
  608800
  624366
  626726
  627893
  648042
  665381
  675182
  692913
  693240
  693457
  695831
  701339
  708390
  712684
  714490
  715509
  716777
  718553
  718614
  722672
  723927
  725368
  726503
  727513
  727950
  729118
  729230
  730806
  735564
  738893
  740101
  745484
  753222
  756567
  758723
  759581
  764352
  768086
  788339
  789144
  795470
  802392
  814265
  819748
  821839
  825654
  827942
  828430
]
18.63 ms
(10.43%)
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
  828430
  802392
  571210
  665381
  569665
  608800
  551257
  789144
  727950
  738893
  399223
  718553
  522699
  430057
  487067
  400854
  526998
  549582
  553197
  714490
  716777
  588331
  758723
  768086
  708390
  400689
  444579
  470735
  479044
  722672
  693457
  725368
  756567
  727513
  624366
  523167
  825654
  819748
  795470
  729230
  648042
  701339
  745484
  502864
  821839
  446456
  460723
  462253
  460459
  695831
  586015
  607772
  605856
  764352
  453714
  477926
  432802
  435468
  454250
  475453
  484439
  509933
  603294
  501139
  601853
  386024
  827942
  605326
  735564
  759581
  715509
  740101
  788339
  729118
  753222
  444121
  503928
  523171
  718614
  384233
  576380
  465823
  472912
  495035
  420416
  726503
  730806
  401216
  416606
  814265
  470802
  456215
  460923
  534833
  545914
  542934
  712684
  548684
  557608
  606102
  626726
  627893
  597869
  723927
  400989
  477965
  439650
  463169
  466966
  432685
  464307
  492794
  503955
  503922
  520748
  423314
  566267
  692913
  693240
  675182
]
2.69 ms
(1.51%)
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
  384233
  386024
  399223
  400689
  400854
  400989
  401216
  416606
  420416
  423314
  430057
  432685
  432802
  435468
  439650
  444121
  444579
  446456
  453714
  454250
  456215
  460459
  460723
  460923
  462253
  463169
  464307
  465823
  466966
  470735
  470802
  472912
  475453
  477926
  477965
  479044
  484439
  487067
  492794
  495035
  501139
  502864
  503922
  503928
  503955
  509933
  520748
  522699
  523167
  523171
  526998
  534833
  542934
  545914
  548684
  549582
  551257
  553197
  557608
  566267
  569665
  571210
  576380
  586015
  588331
  597869
  601853
  603294
  605326
  605856
  606102
  607772
  608800
  624366
  626726
  627893
  648042
  665381
  675182
  692913
  693240
  693457
  695831
  701339
  708390
  712684
  714490
  715509
  716777
  718553
  718614
  722672
  723927
  725368
  726503
  727513
  727950
  729118
  729230
  730806
  735564
  738893
  740101
  745484
  753222
  756567
  758723
  759581
  764352
  768086
  788339
  789144
  795470
  802392
  814265
  819748
  821839
  825654
  827942
  828430
]
1.85 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy young amateur"
]
1.56 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy young любительск"
]
1.53 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy young любительск"
]

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.