Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.72 ms
(86.43%)
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
  83083
  403850
  438682
  441118
  445716
  448497
  486144
  498554
  500533
  544033
  544935
  546273
  574090
  576471
  577558
  586657
  589545
  590328
  592283
  594287
  607375
  617393
  617803
  618071
  621468
  629643
  631298
  631591
  638014
  642144
  646074
  648221
  648931
  658931
  659429
  666685
  669320
  670819
  677366
  679351
  684583
  692703
  692914
  693267
  694637
  697668
  702914
  703022
  704629
  705117
  706643
  706679
  708399
  709870
  710092
  712573
  712962
  713750
  714392
  719422
  720570
  721227
  721649
  723701
  723852
  725661
  727013
  728888
  729241
  730498
  730654
  744146
  746480
  748408
  748502
  750179
  751237
  758769
  758839
  765383
  766329
  767363
  773120
  777875
  777877
  778621
  780448
  781122
  783602
  784414
  784476
  784883
  785113
  785366
  786877
  786884
  786905
  786909
  787382
  787707
  792019
  792339
  793150
  794482
  794773
  796034
  796156
  796768
  797727
  797730
  798483
  798674
  800168
  802331
  806821
  812120
  813643
  820020
  826103
  828026
]
12.19 ms
(7.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
  828026
  826103
  445716
  500533
  486144
  544935
  577558
  574090
  670819
  712573
  721649
  648221
  666685
  709870
  720570
  721227
  594287
  631591
  592283
  621468
  607375
  638014
  617803
  777877
  786905
  787707
  792339
  796768
  786884
  792019
  794482
  796034
  797730
  798483
  812120
  723701
  723852
  744146
  758769
  786877
  787382
  793150
  796156
  797727
  802331
  728888
  730654
  748502
  758839
  746480
  765383
  766329
  773120
  725661
  729241
  730498
  750179
  751237
  727013
  748408
  767363
  617393
  705117
  706643
  714392
  780448
  794773
  800168
  83083
  403850
  438682
  441118
  813643
  820020
  448497
  498554
  544033
  576471
  693267
  703022
  708399
  712962
  713750
  646074
  669320
  679351
  684583
  692703
  692914
  702914
  704629
  706679
  710092
  648931
  658931
  659429
  677366
  694637
  697668
  719422
  546273
  590328
  589545
  618071
  586657
  629643
  642144
  631298
  777875
  781122
  783602
  784414
  784476
  784883
  785113
  785366
  786909
  798674
  806821
  778621
]
2.27 ms
(1.43%)
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
  83083
  403850
  438682
  441118
  445716
  448497
  486144
  498554
  500533
  544033
  544935
  546273
  574090
  576471
  577558
  586657
  589545
  590328
  592283
  594287
  607375
  617393
  617803
  618071
  621468
  629643
  631298
  631591
  638014
  642144
  646074
  648221
  648931
  658931
  659429
  666685
  669320
  670819
  677366
  679351
  684583
  692703
  692914
  693267
  694637
  697668
  702914
  703022
  704629
  705117
  706643
  706679
  708399
  709870
  710092
  712573
  712962
  713750
  714392
  719422
  720570
  721227
  721649
  723701
  723852
  725661
  727013
  728888
  729241
  730498
  730654
  744146
  746480
  748408
  748502
  750179
  751237
  758769
  758839
  765383
  766329
  767363
  773120
  777875
  777877
  778621
  780448
  781122
  783602
  784414
  784476
  784883
  785113
  785366
  786877
  786884
  786905
  786909
  787382
  787707
  792019
  792339
  793150
  794482
  794773
  796034
  796156
  796768
  797727
  797730
  798483
  798674
  800168
  802331
  806821
  812120
  813643
  820020
  826103
  828026
]
2.19 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls orgasm"
]
1.78 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк orgasm"
]
1.55 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк orgasm"
]

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.