Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.36 ms
(82.12%)
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
  373897
  387648
  391428
  398634
  414301
  417830
  420358
  420587
  420664
  421077
  421093
  421162
  421654
  423708
  425549
  427174
  427997
  428124
  428315
  433212
  433319
  433339
  437537
  443112
  445538
  445666
  452404
  453078
  455847
  461714
  464366
  468154
  468355
  469520
  477587
  478074
  478927
  480758
  486333
  486432
  494231
  496090
  496729
  502903
  505215
  510676
  512608
  512951
  515633
  520216
  522851
  533855
  541635
  541725
  541831
  542190
  542562
  543615
  543918
  545790
  545791
  545800
  545802
  545836
  548046
  548067
  551941
  552058
  554399
  555391
  556525
  556922
  560086
  567041
  569059
  569098
  569147
  574727
  575302
  582012
  586654
  586688
  590879
  592570
  595121
  597149
  601710
  603213
  603258
  604478
  604558
  613576
  615440
  616338
  629886
  630916
  632034
  632134
  632655
  635249
  636545
  643122
  651601
  667139
  678502
  700989
  718661
  719144
  730216
  758097
  788119
  788260
  788608
  791550
  792550
  792554
  792557
  801292
  815002
  819701
]
15.87 ms
(10.74%)
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
  575302
  542562
  545790
  632134
  629886
  788119
  788608
  791550
  792550
  730216
  601710
  421077
  520216
  387648
  427997
  510676
  815002
  556525
  556922
  801292
  464366
  414301
  433212
  443112
  469520
  615440
  420358
  543918
  651601
  595121
  478074
  496090
  543615
  700989
  445666
  468355
  496729
  421654
  819701
  477587
  486432
  512608
  533855
  560086
  667139
  718661
  678502
  554399
  567041
  569059
  569147
  616338
  586688
  604558
  590879
  632034
  592570
  792557
  636545
  391428
  421162
  478927
  486333
  512951
  428315
  494231
  545791
  421093
  635249
  574727
  515633
  452404
  427174
  373897
  719144
  502903
  398634
  555391
  613576
  453078
  604478
  548067
  603213
  758097
  433319
  420587
  541831
  545802
  603258
  433339
  541635
  437537
  423708
  480758
  468154
  586654
  455847
  461714
  417830
  420664
  522851
  425549
  428124
  445538
  505215
  541725
  542190
  545800
  551941
  569098
  582012
  545836
  548046
  552058
  643122
  597149
  792554
  788260
  630916
  632655
]
3.44 ms
(2.32%)
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
  373897
  387648
  391428
  398634
  414301
  417830
  420358
  420587
  420664
  421077
  421093
  421162
  421654
  423708
  425549
  427174
  427997
  428124
  428315
  433212
  433319
  433339
  437537
  443112
  445538
  445666
  452404
  453078
  455847
  461714
  464366
  468154
  468355
  469520
  477587
  478074
  478927
  480758
  486333
  486432
  494231
  496090
  496729
  502903
  505215
  510676
  512608
  512951
  515633
  520216
  522851
  533855
  541635
  541725
  541831
  542190
  542562
  543615
  543918
  545790
  545791
  545800
  545802
  545836
  548046
  548067
  551941
  552058
  554399
  555391
  556525
  556922
  560086
  567041
  569059
  569098
  569147
  574727
  575302
  582012
  586654
  586688
  590879
  592570
  595121
  597149
  601710
  603213
  603258
  604478
  604558
  613576
  615440
  616338
  629886
  630916
  632034
  632134
  632655
  635249
  636545
  643122
  651601
  667139
  678502
  700989
  718661
  719144
  730216
  758097
  788119
  788260
  788608
  791550
  792550
  792554
  792557
  801292
  815002
  819701
]
2.05 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дырки в сперме нарезк%…"
]
1.79 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дырк сперм подборк"
]
1.73 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.