Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.89 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.90 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass in jeans"
]
3 17.05 ms
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
  464089
  480889
  507451
  562203
  699520
  652633
  505867
  423651
  800311
  755141
  823452
  452808
  627442
  745622
  617730
  465891
  525814
  387850
  467049
  535611
  601738
  461927
  529769
  610777
  134210
  444651
  442957
  576995
  558624
  567116
  582362
  638870
  755921
  761474
  772700
  485856
  525785
  452334
  480363
  790338
  741805
  591747
  765743
  436588
  465109
  511506
  555574
  468188
  524956
  453426
  526436
  539170
  561754
  605727
  727668
  427958
  447919
  432589
  459539
  468685
  604225
  387033
  423321
  423351
  463584
  475489
  584200
  584942
  640427
  477198
  463036
  525817
  528009
  577980
  618293
  503429
  558897
  559986
  422273
  467118
  447551
  486363
  545729
  746510
  518104
  514373
  460126
  507245
  501960
  541465
  576128
  514408
  519017
  525521
  551820
  388856
  592645
  480393
  525462
  524370
  517673
  526917
  605864
  458923
  548304
  605774
  569357
  521624
  512339
  615429
  607363
]
4 3.07 ms
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
  134210
  387033
  387850
  388856
  422273
  423321
  423351
  423651
  427958
  432589
  436588
  442957
  444651
  447551
  447919
  452334
  452808
  453426
  458923
  459539
  460126
  461927
  463036
  463584
  464089
  465109
  465891
  467049
  467118
  468188
  468685
  475489
  477198
  480363
  480393
  480889
  485856
  486363
  501960
  503429
  505867
  507245
  507451
  511506
  512339
  514373
  514408
  517673
  518104
  519017
  521624
  524370
  524956
  525462
  525521
  525785
  525814
  525817
  526436
  526917
  528009
  529769
  535611
  539170
  541465
  545729
  548304
  551820
  555574
  558624
  558897
  559986
  561754
  562203
  567116
  569357
  576128
  576995
  577980
  582362
  584200
  584942
  591747
  592645
  601738
  604225
  605727
  605774
  605864
  607363
  610777
  615429
  617730
  618293
  627442
  638870
  640427
  652633
  699520
  727668
  741805
  745622
  746510
  755141
  755921
  761474
  765743
  772700
  790338
  800311
  823452
]
5 157.50 ms
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
  134210
  387033
  387850
  388856
  422273
  423321
  423351
  423651
  427958
  432589
  436588
  442957
  444651
  447551
  447919
  452334
  452808
  453426
  458923
  459539
  460126
  461927
  463036
  463584
  464089
  465109
  465891
  467049
  467118
  468188
  468685
  475489
  477198
  480363
  480393
  480889
  485856
  486363
  501960
  503429
  505867
  507245
  507451
  511506
  512339
  514373
  514408
  517673
  518104
  519017
  521624
  524370
  524956
  525462
  525521
  525785
  525814
  525817
  526436
  526917
  528009
  529769
  535611
  539170
  541465
  545729
  548304
  551820
  555574
  558624
  558897
  559986
  561754
  562203
  567116
  569357
  576128
  576995
  577980
  582362
  584200
  584942
  591747
  592645
  601738
  604225
  605727
  605774
  605864
  607363
  610777
  615429
  617730
  618293
  627442
  638870
  640427
  652633
  699520
  727668
  741805
  745622
  746510
  755141
  755921
  761474
  765743
  772700
  790338
  800311
  823452
]
6 1.82 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп jeans"
]
7 1.86 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп jeans"
]

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.