Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.23 ms
(88.09%)
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
  388690
  390831
  420182
  428382
  428392
  428891
  429950
  436030
  436037
  445426
  451560
  451562
  451582
  457795
  461554
  464195
  464650
  465652
  478930
  483560
  489166
  490843
  490868
  491378
  491385
  493963
  497550
  497554
  497557
  508857
  508874
  512329
  512830
  521928
  521966
  521970
  523948
  525966
  528921
  533743
  533833
  533911
  534032
  534041
  535582
  539420
  548733
  552253
  554366
  556051
  558983
  558990
  559986
  560446
  560488
  560610
  560622
  562263
  562266
  562281
  562311
  564075
  564078
  564082
  565349
  565354
  565355
  565359
  565373
  565377
  565390
  565391
  565405
  565411
  565413
  565414
  565426
  565436
  565462
  568307
  568309
  570673
  571534
  571855
  571857
  572042
  572389
  572397
  573026
  573776
  573814
  574512
  574855
  575104
  575217
  575748
  575762
  576344
  578376
  578898
  580263
  586595
  596160
  596991
  597005
  597112
  597113
  597997
  598014
  598138
  598498
  600016
  632851
  644971
  645010
  718675
  765848
  808075
  810698
  820662
]
18.97 ms
(7.73%)
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
  573026
  560622
  808075
  436030
  461554
  490843
  491385
  558990
  565436
  554366
  574855
  598014
  597005
  597113
  765848
  451582
  508874
  497557
  560488
  570673
  571855
  571857
  508857
  445426
  388690
  451560
  483560
  533743
  533833
  565426
  810698
  390831
  565349
  565462
  457795
  521928
  491378
  512830
  497554
  565391
  572389
  596160
  428382
  525966
  575217
  596991
  451562
  436037
  497550
  820662
  632851
  552253
  534032
  575762
  573776
  578376
  560446
  575104
  573814
  600016
  521966
  598498
  493963
  429950
  572397
  574512
  565377
  598138
  490868
  521970
  464650
  645010
  559986
  564082
  565414
  718675
  512329
  597112
  575748
  528921
  580263
  548733
  534041
  533911
  478930
  562281
  565390
  564078
  523948
  565405
  560610
  562263
  565373
  568307
  428392
  535582
  568309
  562266
  565355
  586595
  428891
  420182
  644971
  464195
  572042
  597997
  489166
  539420
  564075
  565354
  578898
  558983
  565411
  565413
  571534
  562311
  465652
  576344
  556051
  565359
]
3.37 ms
(1.37%)
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
  388690
  390831
  420182
  428382
  428392
  428891
  429950
  436030
  436037
  445426
  451560
  451562
  451582
  457795
  461554
  464195
  464650
  465652
  478930
  483560
  489166
  490843
  490868
  491378
  491385
  493963
  497550
  497554
  497557
  508857
  508874
  512329
  512830
  521928
  521966
  521970
  523948
  525966
  528921
  533743
  533833
  533911
  534032
  534041
  535582
  539420
  548733
  552253
  554366
  556051
  558983
  558990
  559986
  560446
  560488
  560610
  560622
  562263
  562266
  562281
  562311
  564075
  564078
  564082
  565349
  565354
  565355
  565359
  565373
  565377
  565390
  565391
  565405
  565411
  565413
  565414
  565426
  565436
  565462
  568307
  568309
  570673
  571534
  571855
  571857
  572042
  572389
  572397
  573026
  573776
  573814
  574512
  574855
  575104
  575217
  575748
  575762
  576344
  578376
  578898
  580263
  586595
  596160
  596991
  597005
  597112
  597113
  597997
  598014
  598138
  598498
  600016
  632851
  644971
  645010
  718675
  765848
  808075
  810698
  820662
]
2.05 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian interracial sex"
]
1.84 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск межрасов секс"
]
1.52 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.60%)
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.