Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.20 ms
(84.19%)
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
  99145
  100449
  381963
  382368
  384945
  393339
  450763
  462060
  465485
  477383
  490312
  506819
  510168
  517280
  518729
  530451
  534873
  548927
  549626
  563416
  581645
  586422
  591489
  600223
  600881
  601219
  602831
  607997
  611342
  617835
  621424
  622071
  624488
  635057
  639841
  644190
  644682
  650021
  652424
  656875
  663390
  668122
  671647
  672708
  679044
  684400
  687753
  689545
  692703
  701605
  701690
  703269
  710858
  711617
  714586
  715710
  718339
  718823
  720304
  722181
  722563
  726661
  727850
  731767
  738944
  740842
  741079
  743147
  744321
  749022
  750129
  750620
  750768
  755552
  757754
  758991
  762956
  763852
  767853
  769287
  774759
  777718
  779804
  780264
  782022
  782381
  783630
  783653
  785436
  787720
  788145
  791091
  791235
  792116
  792170
  793332
  797238
  797735
  798793
  799011
  800426
  800557
  801349
  801595
  802727
  803196
  805719
  805941
  807710
  809645
  810722
  812611
  820947
  822167
  824273
  826162
  827179
  827204
  827533
  828686
]
11.20 ms
(7.78%)
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
  827204
  827533
  822167
  824273
  490312
  506819
  517280
  518729
  530451
  510168
  549626
  581645
  563416
  679044
  715710
  722563
  701605
  714586
  718339
  718823
  663390
  671647
  672708
  711617
  720304
  722181
  548927
  586422
  621424
  602831
  600881
  611342
  644190
  644682
  601219
  779804
  783653
  792116
  798793
  801349
  803196
  810722
  812611
  777718
  782022
  788145
  800557
  805941
  743147
  750768
  762956
  783630
  785436
  799011
  800426
  758991
  726661
  740842
  757754
  769287
  731767
  763852
  635057
  701690
  791091
  791235
  807710
  382368
  727850
  381963
  384945
  99145
  820947
  827179
  826162
  828686
  450763
  477383
  462060
  534873
  650021
  684400
  692703
  652424
  656875
  668122
  687753
  689545
  703269
  710858
  622071
  624488
  600223
  591489
  607997
  617835
  639841
  774759
  782381
  787720
  792170
  793332
  805719
  741079
  749022
  750620
  755552
  797238
  797735
  802727
  809645
  767853
  744321
  750129
  738944
  780264
  801595
  465485
  100449
  393339
]
4.15 ms
(2.89%)
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
  99145
  100449
  381963
  382368
  384945
  393339
  450763
  462060
  465485
  477383
  490312
  506819
  510168
  517280
  518729
  530451
  534873
  548927
  549626
  563416
  581645
  586422
  591489
  600223
  600881
  601219
  602831
  607997
  611342
  617835
  621424
  622071
  624488
  635057
  639841
  644190
  644682
  650021
  652424
  656875
  663390
  668122
  671647
  672708
  679044
  684400
  687753
  689545
  692703
  701605
  701690
  703269
  710858
  711617
  714586
  715710
  718339
  718823
  720304
  722181
  722563
  726661
  727850
  731767
  738944
  740842
  741079
  743147
  744321
  749022
  750129
  750620
  750768
  755552
  757754
  758991
  762956
  763852
  767853
  769287
  774759
  777718
  779804
  780264
  782022
  782381
  783630
  783653
  785436
  787720
  788145
  791091
  791235
  792116
  792170
  793332
  797238
  797735
  798793
  799011
  800426
  800557
  801349
  801595
  802727
  803196
  805719
  805941
  807710
  809645
  810722
  812611
  820947
  822167
  824273
  826162
  827179
  827204
  827533
  828686
]
2.18 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "horny fuck"
]
1.82 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "horny секс"
]
1.62 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "horny секс"
]

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.