Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.37 ms
(87.47%)
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
  400516
  401657
  418884
  420794
  426999
  427186
  438027
  443920
  444198
  444840
  451494
  453505
  455505
  461233
  464484
  465907
  468883
  475560
  477860
  477904
  478385
  478421
  480013
  482723
  489444
  491433
  491462
  492234
  492460
  495446
  500230
  501633
  503079
  503442
  505472
  505845
  508801
  509163
  514066
  528633
  535638
  542444
  548410
  553968
  555067
  560335
  561275
  572358
  579467
  590555
  592548
  593485
  597514
  612404
  616554
  616783
  619898
  623966
  626866
  664649
  672795
  680673
  691395
  694614
  695780
  702280
  702316
  745482
  749891
  751007
  755013
  757120
  758409
  764036
  765717
  765842
  767073
  767078
  768423
  768446
  768450
  768760
  769275
  777749
  778293
  779748
  779846
  783754
  784225
  784776
  786269
  786403
  786952
  789180
  789631
  791968
  792545
  792932
  793206
  793942
  794728
  795360
  796196
  796208
  801537
  801800
  804823
  804930
  805352
  809307
  810026
  812452
  812709
  813576
  816744
  818678
  824994
  825556
  825611
  825710
]
13.48 ms
(6.92%)
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
  477904
  443920
  451494
  461233
  444198
  477860
  500230
  505472
  514066
  491433
  508801
  528633
  495446
  503442
  501633
  749891
  812452
  420794
  813576
  825556
  818678
  824994
  825611
  816744
  825710
  480013
  478421
  509163
  535638
  555067
  542444
  672795
  695780
  664649
  680673
  694614
  702280
  691395
  619898
  590555
  616554
  616783
  623966
  597514
  779846
  786403
  789631
  794728
  795360
  796196
  796208
  809307
  777749
  779748
  784225
  793206
  801537
  812709
  745482
  755013
  768446
  786269
  786952
  789180
  791968
  792545
  804930
  810026
  765842
  768423
  768450
  757120
  758409
  764036
  751007
  765717
  767073
  768760
  769275
  767078
  702316
  778293
  783754
  793942
  801800
  804823
  805352
  427186
  444840
  438027
  426999
  475560
  505845
  491462
  400516
  418884
  478385
  503079
  792932
  561275
  572358
  455505
  464484
  492234
  489444
  593485
  482723
  492460
  548410
  560335
  579467
  553968
  626866
  612404
  592548
  784776
  453505
  465907
  401657
  468883
]
3.18 ms
(1.63%)
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
  400516
  401657
  418884
  420794
  426999
  427186
  438027
  443920
  444198
  444840
  451494
  453505
  455505
  461233
  464484
  465907
  468883
  475560
  477860
  477904
  478385
  478421
  480013
  482723
  489444
  491433
  491462
  492234
  492460
  495446
  500230
  501633
  503079
  503442
  505472
  505845
  508801
  509163
  514066
  528633
  535638
  542444
  548410
  553968
  555067
  560335
  561275
  572358
  579467
  590555
  592548
  593485
  597514
  612404
  616554
  616783
  619898
  623966
  626866
  664649
  672795
  680673
  691395
  694614
  695780
  702280
  702316
  745482
  749891
  751007
  755013
  757120
  758409
  764036
  765717
  765842
  767073
  767078
  768423
  768446
  768450
  768760
  769275
  777749
  778293
  779748
  779846
  783754
  784225
  784776
  786269
  786403
  786952
  789180
  789631
  791968
  792545
  792932
  793206
  793942
  794728
  795360
  796196
  796208
  801537
  801800
  804823
  804930
  805352
  809307
  810026
  812452
  812709
  813576
  816744
  818678
  824994
  825556
  825611
  825710
]
2.25 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf pov russian"
]
1.85 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf пов русск"
]
1.85 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf пов русск"
]

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.