Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.54 ms
(90.10%)
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
  3381
  34016
  80314
  118141
  120432
  232978
  382200
  385832
  386240
  386403
  386734
  387012
  387850
  388078
  392930
  394361
  396088
  396110
  396369
  397381
  401014
  405907
  407871
  408219
  409938
  417952
  418622
  420289
  420335
  420384
  420513
  421054
  422162
  424038
  425679
  426374
  432323
  432776
  434425
  435378
  441269
  442571
  443906
  444074
  445236
  445279
  447999
  448245
  449094
  450385
  450791
  452652
  452982
  453047
  453361
  456564
  456701
  459650
  461396
  463376
  464118
  465245
  465511
  466752
  468338
  468359
  469266
  470180
  470434
  474267
  477754
  478492
  486076
  489953
  490689
  491584
  493657
  494448
  509580
  511988
  512922
  512964
  525028
  537662
  549177
  554817
  564830
  566901
  571846
  574101
  586294
  590167
  594581
  598700
  626917
  636816
  641560
  643233
  661912
  672321
  674522
  685401
  686502
  690947
  704916
  715680
  725612
  742338
  752105
  757831
  758495
  765657
  765721
  766691
  767236
  770376
  784219
  789540
  801008
]
14.46 ms
(6.13%)
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
  486076
  120432
  80314
  232978
  490689
  382200
  426374
  459650
  789540
  765657
  3381
  386403
  396110
  463376
  491584
  468359
  407871
  453047
  468338
  461396
  447999
  452652
  432323
  564830
  674522
  685401
  566901
  775033
  549177
  465511
  450791
  511988
  537662
  477754
  489953
  387012
  465245
  470434
  509580
  474267
  672321
  690947
  626917
  388078
  444074
  512922
  493657
  422162
  452982
  661912
  641560
  34016
  405907
  464118
  586294
  590167
  636816
  386734
  118141
  686502
  715680
  598700
  767236
  396369
  386240
  470180
  434425
  396088
  448245
  442571
  766691
  435378
  456701
  594581
  387850
  425679
  420384
  469266
  758495
  784219
  757831
  770376
  424038
  401014
  392930
  643233
  385832
  725612
  742338
  445279
  421054
  441269
  494448
  418622
  449094
  443906
  394361
  408219
  409938
  765721
  752105
  704916
  554817
  432776
  450385
  512964
  456564
  466752
  397381
  420513
  445236
  571846
  801008
  420289
  420335
  574101
  478492
  453361
  525028
  417952
]
2.52 ms
(1.07%)
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
  3381
  34016
  80314
  118141
  120432
  232978
  382200
  385832
  386240
  386403
  386734
  387012
  387850
  388078
  392930
  394361
  396088
  396110
  396369
  397381
  401014
  405907
  407871
  408219
  409938
  417952
  418622
  420289
  420335
  420384
  420513
  421054
  422162
  424038
  425679
  426374
  432323
  432776
  434425
  435378
  441269
  442571
  443906
  444074
  445236
  445279
  447999
  448245
  449094
  450385
  450791
  452652
  452982
  453047
  453361
  456564
  456701
  459650
  461396
  463376
  464118
  465245
  465511
  466752
  468338
  468359
  469266
  470180
  470434
  474267
  477754
  478492
  486076
  489953
  490689
  491584
  493657
  494448
  509580
  511988
  512922
  512964
  525028
  537662
  549177
  554817
  564830
  566901
  571846
  574101
  586294
  590167
  594581
  598700
  626917
  636816
  641560
  643233
  661912
  672321
  674522
  685401
  686502
  690947
  704916
  715680
  725612
  742338
  752105
  757831
  758495
  765657
  765721
  766691
  767236
  770376
  784219
  789540
  801008
]
1.70 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal dick"
]
1.67 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал член"
]
1.55 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.61%)
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.