Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.56 ms
(83.90%)
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
  156877
  266134
  405423
  405820
  479224
  508231
  534661
  544131
  554802
  562069
  565981
  571110
  574399
  578789
  584688
  613484
  618194
  618214
  622930
  632514
  635789
  635850
  636400
  638433
  638560
  640231
  644227
  645697
  647097
  650967
  650993
  653347
  660057
  671454
  675885
  682413
  685600
  695392
  697933
  698106
  702995
  703282
  704622
  705772
  707938
  713085
  716586
  718025
  718713
  719524
  724078
  725614
  725643
  727708
  727767
  728938
  728998
  732883
  733278
  733556
  737277
  743714
  745553
  750158
  750625
  757470
  758860
  760515
  766395
  768755
  769205
  773402
  773960
  781444
  781747
  782310
  783055
  784757
  785612
  787054
  790325
  791668
  792444
  792653
  792673
  793234
  793302
  794584
  794817
  795066
  795901
  796335
  797638
  798781
  799738
  799829
  800182
  800618
  801362
  801533
  803590
  803696
  807844
  809991
  811533
  817649
  817951
  818907
  819166
  819654
  819839
  820156
  823212
  824489
  824914
  825277
  826618
  826998
  827372
]
21.50 ms
(11.16%)
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
  534661
  554802
  650993
  660057
  695392
  638433
  613484
  636400
  793234
  800182
  792673
  793302
  728938
  766395
  728998
  745553
  773402
  750625
  760515
  618194
  618214
  632514
  718713
  782310
  266134
  817649
  826618
  817951
  818907
  819654
  827372
  819166
  824489
  820156
  823212
  479224
  544131
  562069
  647097
  650967
  675885
  682413
  685600
  698106
  704622
  707938
  718025
  571110
  640231
  644227
  638560
  792444
  795901
  799829
  811533
  781747
  791668
  792653
  796335
  801362
  725643
  773960
  784757
  790325
  795066
  799738
  800618
  803696
  809991
  724078
  743714
  758860
  768755
  727708
  733556
  725614
  733278
  750158
  635850
  697933
  703282
  705772
  713085
  716586
  783055
  794584
  405423
  727767
  405820
  798781
  801533
  824131
  565981
  653347
  622930
  807844
  826998
  824914
  574399
  803590
  769205
  732883
  781444
  584688
  156877
  819839
  825277
  508231
  719524
  645697
  671454
  702995
  578789
  635789
  785612
  787054
  797638
  737277
  757470
  794817
]
2.65 ms
(1.38%)
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
  156877
  266134
  405423
  405820
  479224
  508231
  534661
  544131
  554802
  562069
  565981
  571110
  574399
  578789
  584688
  613484
  618194
  618214
  622930
  632514
  635789
  635850
  636400
  638433
  638560
  640231
  644227
  645697
  647097
  650967
  650993
  653347
  660057
  671454
  675885
  682413
  685600
  695392
  697933
  698106
  702995
  703282
  704622
  705772
  707938
  713085
  716586
  718025
  718713
  719524
  724078
  725614
  725643
  727708
  727767
  728938
  728998
  732883
  733278
  733556
  737277
  743714
  745553
  750158
  750625
  757470
  758860
  760515
  766395
  768755
  769205
  773402
  773960
  781444
  781747
  782310
  783055
  784757
  785612
  787054
  790325
  791668
  792444
  792653
  792673
  793234
  793302
  794584
  794817
  795066
  795901
  796335
  797638
  798781
  799738
  799829
  800182
  800618
  801362
  801533
  803590
  803696
  807844
  809991
  811533
  817649
  817951
  818907
  819166
  819654
  819839
  820156
  823212
  824489
  824914
  825277
  826618
  826998
  827372
]
1.89 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband секс"
]
1.82 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband fuck"
]
1.62 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband секс"
]
1.53 ms
(0.80%)
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.