Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.92 ms
(81.32%)
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
  429592
  456037
  456875
  462567
  465597
  465990
  466384
  466918
  474847
  476306
  487937
  488989
  490598
  490825
  499568
  502062
  502751
  506510
  510948
  511061
  514250
  517545
  523058
  528560
  528816
  539774
  542918
  549230
  549240
  550514
  552036
  556782
  557706
  558174
  558315
  558318
  560828
  563729
  568752
  569661
  577692
  578762
  580824
  586271
  586950
  591013
  591288
  591536
  592438
  592690
  592945
  593510
  596792
  603814
  603930
  605687
  607345
  611280
  612313
  634758
  646044
  660807
  665187
  666021
  668628
  674741
  675541
  685526
  688339
  696133
  707470
  712234
  714487
  718408
  719144
  720264
  724467
  724514
  725391
  725433
  726348
  726814
  726848
  729074
  729192
  730793
  731398
  732165
  733018
  735452
  737687
  739788
  746002
  753738
  756252
  756494
  760175
  766451
  768787
  770038
  773840
  780588
  781792
  781971
  784262
  787756
  788231
  790236
  793516
  801243
  801940
  803128
  803738
  803754
  810014
  810020
  810063
  811125
  811622
  814374
]
17.18 ms
(11.65%)
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
  712234
  646044
  674741
  688339
  696133
  634758
  586271
  801243
  801940
  780588
  784262
  790236
  726848
  729192
  737687
  766451
  793516
  810014
  725433
  726814
  730793
  733018
  729074
  731398
  735452
  739788
  746002
  770038
  724514
  753738
  760175
  768787
  725391
  756494
  773840
  781971
  788231
  803128
  803738
  803754
  810020
  810063
  811622
  429592
  814374
  476306
  456875
  462567
  465990
  456037
  466918
  474847
  487937
  490598
  490825
  510948
  528560
  502062
  502751
  514250
  528816
  499568
  506510
  539774
  511061
  517545
  523058
  465597
  466384
  488989
  542918
  549230
  558174
  568752
  557706
  558315
  558318
  569661
  549240
  550514
  552036
  563729
  660807
  707470
  714487
  718408
  719144
  666021
  665187
  668628
  675541
  685526
  720264
  556782
  560828
  577692
  578762
  580824
  591013
  611280
  586950
  591288
  592690
  603930
  607345
  612313
  591536
  592438
  603814
  592945
  593510
  596792
  605687
  781792
  787756
  811125
  724467
  726348
  732165
  756252
]
2.82 ms
(1.91%)
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
  429592
  456037
  456875
  462567
  465597
  465990
  466384
  466918
  474847
  476306
  487937
  488989
  490598
  490825
  499568
  502062
  502751
  506510
  510948
  511061
  514250
  517545
  523058
  528560
  528816
  539774
  542918
  549230
  549240
  550514
  552036
  556782
  557706
  558174
  558315
  558318
  560828
  563729
  568752
  569661
  577692
  578762
  580824
  586271
  586950
  591013
  591288
  591536
  592438
  592690
  592945
  593510
  596792
  603814
  603930
  605687
  607345
  611280
  612313
  634758
  646044
  660807
  665187
  666021
  668628
  674741
  675541
  685526
  688339
  696133
  707470
  712234
  714487
  718408
  719144
  720264
  724467
  724514
  725391
  725433
  726348
  726814
  726848
  729074
  729192
  730793
  731398
  732165
  733018
  735452
  737687
  739788
  746002
  753738
  756252
  756494
  760175
  766451
  768787
  770038
  773840
  780588
  781792
  781971
  784262
  787756
  788231
  790236
  793516
  801243
  801940
  803128
  803738
  803754
  810014
  810020
  810063
  811125
  811622
  814374
]
2.25 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy hairy"
]
1.94 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy волосатая"
]
1.67 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy волосатая"
]

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.