Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.61 ms
(90.62%)
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
  337061
  382792
  397765
  615894
  629549
  636500
  639871
  648741
  693795
  697733
  698723
  698917
  699392
  699538
  706597
  707583
  714745
  718853
  719087
  722167
  724842
  728116
  728868
  728870
  730318
  730510
  730679
  731186
  732692
  733448
  734491
  734604
  734657
  735664
  735780
  736720
  740541
  741319
  743070
  743708
  744923
  746132
  746853
  747056
  747061
  748002
  749615
  749791
  753988
  755107
  756979
  757605
  757712
  757930
  762655
  763603
  763843
  764570
  764662
  765369
  765802
  766162
  766934
  766964
  767294
  767884
  767892
  768117
  768542
  768719
  768720
  772797
  772997
  773375
  773378
  777565
  777621
  777629
  778477
  780094
  780112
  782084
  782897
  784426
  787153
  787588
  790662
  791364
  791814
  792327
  792435
  792439
  792679
  794584
  795929
  797744
  798961
  800039
  800173
  802088
  802272
  803884
  812140
  817032
  818736
  819133
  819300
  819313
  819382
  819414
  819451
  819728
  823255
  823862
  823876
  825892
  826006
  826224
  826583
  826677
]
11.61 ms
(5.14%)
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
  767884
  767892
  772997
  736720
  744923
  746132
  747056
  747061
  756979
  757712
  757930
  764662
  766162
  728116
  728868
  728870
  730510
  730679
  735664
  735780
  753988
  764570
  765369
  767294
  768542
  768719
  768720
  724842
  730318
  733448
  734604
  741319
  746853
  748002
  749791
  757605
  763843
  768117
  772797
  773375
  773378
  629549
  697733
  706597
  714745
  719087
  777565
  777621
  777629
  780112
  787153
  787588
  791364
  792679
  794584
  795929
  797744
  798961
  802088
  802272
  803884
  812140
  397765
  337061
  382792
  819728
  823255
  826224
  826677
  826583
  823876
  817032
  819414
  826006
  819300
  819313
  819382
  819451
  825892
  818736
  819133
  823862
  699392
  693795
  698917
  707583
  718853
  648741
  698723
  699538
  722167
  615894
  636500
  639871
  778477
  782084
  782897
  791814
  792439
  780094
  784426
  792435
  734657
  740541
  749615
  755107
  766964
  790662
  792327
  800039
  800173
  732692
  734491
  763603
  731186
  743070
  765802
  743708
  762655
  766934
]
2.51 ms
(1.11%)
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
  337061
  382792
  397765
  615894
  629549
  636500
  639871
  648741
  693795
  697733
  698723
  698917
  699392
  699538
  706597
  707583
  714745
  718853
  719087
  722167
  724842
  728116
  728868
  728870
  730318
  730510
  730679
  731186
  732692
  733448
  734491
  734604
  734657
  735664
  735780
  736720
  740541
  741319
  743070
  743708
  744923
  746132
  746853
  747056
  747061
  748002
  749615
  749791
  753988
  755107
  756979
  757605
  757712
  757930
  762655
  763603
  763843
  764570
  764662
  765369
  765802
  766162
  766934
  766964
  767294
  767884
  767892
  768117
  768542
  768719
  768720
  772797
  772997
  773375
  773378
  777565
  777621
  777629
  778477
  780094
  780112
  782084
  782897
  784426
  787153
  787588
  790662
  791364
  791814
  792327
  792435
  792439
  792679
  794584
  795929
  797744
  798961
  800039
  800173
  802088
  802272
  803884
  812140
  817032
  818736
  819133
  819300
  819313
  819382
  819414
  819451
  819728
  823255
  823862
  823876
  825892
  826006
  826224
  826583
  826677
]
2.07 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot sperm"
]
1.87 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot сперм"
]
1.59 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot сперм"
]
1.53 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.