Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.35 ms
(79.92%)
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
  8497
  11175
  219957
  398387
  401559
  402601
  413706
  416320
  416901
  418337
  419277
  419846
  420912
  422635
  424265
  425054
  428794
  429016
  429384
  432189
  433996
  434014
  435023
  435365
  448796
  449031
  453339
  454534
  456469
  458511
  460709
  462900
  463474
  464821
  464939
  466661
  470571
  472192
  472214
  472804
  475831
  476062
  481000
  485853
  487621
  487737
  487823
  492723
  500781
  504595
  508262
  510847
  511931
  512311
  513722
  515354
  515662
  516301
  519554
  519937
  520301
  522127
  523728
  523891
  524757
  526770
  528205
  528471
  532770
  534011
  556818
  556933
  557486
  571497
  572887
  578422
  584320
  584466
  584473
  586421
  588024
  590551
  591898
  592585
  604466
  614843
  620852
  625826
  626852
  628067
  632108
  634806
  670748
  677028
  688680
  704215
  711600
  727474
  732808
  733450
  735935
  748997
  755203
  757667
  771384
  772053
  774415
  780810
  782543
  783154
  789408
  791827
  795163
  795293
  803884
  809053
  810048
  812065
  814105
]
19.68 ms
(11.71%)
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
  791827
  795293
  812065
  413706
  219957
  803884
  592585
  11175
  688680
  732808
  460709
  528205
  432189
  433996
  814105
  487737
  670748
  677028
  556933
  626852
  810048
  748997
  757667
  771384
  783154
  428794
  466661
  402601
  418337
  519937
  522127
  508262
  515662
  532770
  809053
  458511
  557486
  628067
  625826
  472192
  510847
  500781
  524757
  774415
  590551
  735935
  398387
  416901
  419846
  711600
  634806
  780810
  727474
  733450
  782543
  755203
  772053
  632108
  487621
  8497
  434014
  462900
  476062
  584320
  620852
  449031
  475831
  416320
  464939
  401559
  424265
  425054
  464821
  516301
  487823
  534011
  520301
  588024
  515354
  513722
  614843
  789408
  454534
  578422
  435023
  429384
  453339
  463474
  511931
  572887
  584473
  704215
  556818
  571497
  584466
  586421
  604466
  591898
  795163
  429016
  420912
  422635
  435365
  448796
  456469
  419277
  472214
  481000
  470571
  472804
  519554
  523728
  523891
  526770
  528471
  485853
  504595
  512311
  527557
  492723
]
6.27 ms
(3.73%)
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
  8497
  11175
  219957
  398387
  401559
  402601
  413706
  416320
  416901
  418337
  419277
  419846
  420912
  422635
  424265
  425054
  428794
  429016
  429384
  432189
  433996
  434014
  435023
  435365
  448796
  449031
  453339
  454534
  456469
  458511
  460709
  462900
  463474
  464821
  464939
  466661
  470571
  472192
  472214
  472804
  475831
  476062
  481000
  485853
  487621
  487737
  487823
  492723
  500781
  504595
  508262
  510847
  511931
  512311
  513722
  515354
  515662
  516301
  519554
  519937
  520301
  522127
  523728
  523891
  524757
  526770
  528205
  528471
  532770
  534011
  556818
  556933
  557486
  571497
  572887
  578422
  584320
  584466
  584473
  586421
  588024
  590551
  591898
  592585
  604466
  614843
  620852
  625826
  626852
  628067
  632108
  634806
  670748
  677028
  688680
  704215
  711600
  727474
  732808
  733450
  735935
  748997
  755203
  757667
  771384
  772053
  774415
  780810
  782543
  783154
  789408
  791827
  795163
  795293
  803884
  809053
  810048
  812065
  814105
]
2.41 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass beautiful"
]
1.88 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп красивая"
]
1.80 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп красивая"
]
1.73 ms
(1.03%)
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.