Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.46 ms
(87.87%)
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
  5537
  50436
  387315
  411768
  464192
  468622
  514316
  516470
  528279
  531025
  532822
  534526
  537542
  537568
  537728
  539175
  547325
  549929
  549940
  552760
  563348
  565811
  570787
  572899
  574210
  581330
  584883
  591525
  600277
  603322
  605021
  605035
  611905
  613832
  613990
  626627
  628030
  644338
  652248
  652262
  654712
  654818
  656022
  657972
  658092
  658415
  658562
  658736
  659666
  659721
  659814
  661906
  664137
  667100
  667681
  669578
  670777
  672743
  686491
  693043
  693934
  698477
  701050
  706864
  708662
  712214
  712806
  713060
  715095
  720540
  721892
  723100
  731754
  732845
  735340
  736772
  741914
  743141
  743164
  743251
  744350
  744805
  745296
  745559
  749025
  750338
  752908
  753371
  753630
  753848
  754482
  756108
  757060
  757791
  768529
  770040
  775230
  776466
  776944
  784895
  785888
  789327
  804574
  808483
  809528
  814450
  823137
  823399
  823810
  823924
  824359
  824529
  826247
  827453
  827458
  827504
  828283
]
12.08 ms
(6.54%)
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
  669578
  776466
  745559
  611905
  387315
  828283
  659666
  743251
  468622
  565811
  605035
  784895
  613832
  823137
  658736
  667100
  658562
  659814
  644338
  757060
  753371
  741914
  743141
  814450
  823924
  537728
  661906
  537542
  732845
  824359
  532822
  547325
  581330
  664137
  693043
  693934
  600277
  628030
  808483
  752908
  563348
  753630
  701050
  411768
  516470
  698477
  591525
  776019
  50436
  823399
  534526
  539175
  514316
  552760
  584883
  654712
  656022
  658415
  672743
  686491
  654818
  657972
  658092
  659721
  670777
  708662
  574210
  613990
  775230
  744805
  757791
  745296
  749025
  756108
  712214
  712806
  786797
  823810
  824529
  827504
  531025
  549929
  667681
  715095
  652248
  652262
  720540
  605021
  626627
  603322
  785888
  754482
  770040
  744350
  768529
  736772
  750338
  735340
  706864
  809528
  5537
  827453
  827458
  826247
  828081
  570787
  713060
  804574
  776944
  753848
  731754
  721892
  723100
  789327
  572899
  528279
  537568
  549940
  743164
  464192
]
3.46 ms
(1.87%)
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
  5537
  50436
  387315
  411768
  464192
  468622
  514316
  516470
  528279
  531025
  532822
  534526
  537542
  537568
  537728
  539175
  547325
  549929
  549940
  552760
  563348
  565811
  570787
  572899
  574210
  581330
  584883
  591525
  600277
  603322
  605021
  605035
  611905
  613832
  613990
  626627
  628030
  644338
  652248
  652262
  654712
  654818
  656022
  657972
  658092
  658415
  658562
  658736
  659666
  659721
  659814
  661906
  664137
  667100
  667681
  669578
  670777
  672743
  686491
  693043
  693934
  698477
  701050
  706864
  708662
  712214
  712806
  713060
  715095
  720540
  721892
  723100
  731754
  732845
  735340
  736772
  741914
  743141
  743164
  743251
  744350
  744805
  745296
  745559
  749025
  750338
  752908
  753371
  753630
  753848
  754482
  756108
  757060
  757791
  768529
  770040
  775230
  776466
  776944
  784895
  785888
  789327
  804574
  808483
  809528
  814450
  823137
  823399
  823810
  823924
  824359
  824529
  826247
  827453
  827458
  827504
  828283
]
2.15 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short hair girl"
]
1.82 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short hair девушк"
]
1.57 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short hair девушк"
]

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.