Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.59 ms
(87.01%)
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
  65811
  298293
  398225
  398496
  404117
  448044
  454332
  462070
  463115
  468985
  488833
  495382
  506978
  507009
  516064
  529731
  534668
  534677
  540679
  541459
  541805
  542179
  549279
  552277
  555076
  555436
  555619
  565801
  567130
  568663
  572050
  581041
  584269
  584400
  584800
  592424
  602222
  604641
  612471
  613579
  618967
  625819
  627835
  634745
  636172
  638958
  641924
  648045
  648352
  649082
  649905
  651725
  658469
  665077
  666131
  667325
  684574
  686076
  690410
  692122
  698375
  701204
  712123
  715166
  715668
  718015
  721178
  721938
  722192
  723206
  727527
  727537
  732827
  734120
  734397
  736074
  736327
  736489
  736535
  738604
  740806
  743260
  745867
  745991
  751743
  754214
  757345
  764864
  768471
  768503
  770633
  772342
  780702
  783770
  784258
  785136
  787163
  791310
  792372
  792456
  795952
  798541
  799524
  804391
  804424
  809481
  809945
  812522
  817554
  819027
  819076
  819118
  819424
  819507
  822480
  824886
  825919
  826736
  827351
  828215
]
12.33 ms
(7.32%)
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
  555619
  584400
  804424
  812522
  743260
  649905
  721938
  463115
  613579
  618967
  809945
  462070
  684574
  404117
  581041
  658469
  398225
  495382
  534677
  718015
  565801
  634745
  627835
  780702
  792372
  754214
  736535
  738604
  768503
  772342
  736074
  625819
  785136
  65811
  817554
  819076
  826736
  819027
  827351
  822480
  819118
  819424
  819507
  824886
  828215
  825919
  540679
  555436
  552277
  541459
  666131
  692122
  572050
  584269
  636172
  592424
  795952
  784258
  791310
  745991
  732827
  736327
  745867
  751743
  740806
  715166
  721178
  783770
  298293
  516064
  529731
  534668
  549279
  648045
  665077
  715668
  612471
  641924
  787163
  798541
  768471
  727527
  727537
  804391
  506978
  667325
  723206
  448044
  507009
  568663
  701204
  736489
  468985
  454332
  555076
  712123
  722192
  398496
  734120
  686076
  649082
  698375
  638958
  770633
  734397
  757345
  799524
  809481
  690410
  567130
  488833
  541805
  542179
  584800
  651725
  648352
  602222
  604641
  764864
  792456
]
3.35 ms
(1.99%)
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
  65811
  298293
  398225
  398496
  404117
  448044
  454332
  462070
  463115
  468985
  488833
  495382
  506978
  507009
  516064
  529731
  534668
  534677
  540679
  541459
  541805
  542179
  549279
  552277
  555076
  555436
  555619
  565801
  567130
  568663
  572050
  581041
  584269
  584400
  584800
  592424
  602222
  604641
  612471
  613579
  618967
  625819
  627835
  634745
  636172
  638958
  641924
  648045
  648352
  649082
  649905
  651725
  658469
  665077
  666131
  667325
  684574
  686076
  690410
  692122
  698375
  701204
  712123
  715166
  715668
  718015
  721178
  721938
  722192
  723206
  727527
  727537
  732827
  734120
  734397
  736074
  736327
  736489
  736535
  738604
  740806
  743260
  745867
  745991
  751743
  754214
  757345
  764864
  768471
  768503
  770633
  772342
  780702
  783770
  784258
  785136
  787163
  791310
  792372
  792456
  795952
  798541
  799524
  804391
  804424
  809481
  809945
  812522
  817554
  819027
  819076
  819118
  819424
  819507
  822480
  824886
  825919
  826736
  827351
  828215
]
1.84 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy public"
]
1.60 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy на улиц"
]
1.55 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.23 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy на улиц"
]

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.