Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.11 ms
(85.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
  401597
  408532
  424006
  432724
  452492
  479618
  486622
  498161
  501680
  503016
  503254
  505986
  506097
  506604
  510526
  511901
  513909
  516734
  522815
  523122
  525432
  525681
  528946
  528998
  529069
  530494
  533146
  534459
  534984
  534996
  541782
  552068
  552770
  559798
  560565
  562237
  566032
  568683
  569838
  571048
  574089
  574853
  579515
  583614
  590584
  594289
  596323
  598805
  600476
  601907
  603009
  605310
  605898
  606031
  612222
  613765
  619064
  621883
  624177
  624179
  629499
  631167
  631597
  633813
  633935
  637044
  639904
  641677
  643516
  657817
  657834
  661687
  662498
  663176
  663842
  666819
  671816
  672984
  679653
  679816
  680149
  680785
  684725
  703700
  706596
  709710
  711328
  716414
  722258
  722594
  722632
  727665
  727812
  729815
  731837
  731874
  732559
  735371
  744214
  745550
  747648
  747897
  751915
  754003
  757740
  757896
  762995
  766706
  777337
  777553
  779735
  784622
  788083
  798693
  799681
  800517
  803848
  807527
  808255
  809211
]
16.39 ms
(9.82%)
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
  600476
  747648
  727665
  486622
  631167
  612222
  523122
  525681
  528946
  528998
  529069
  534996
  571048
  583614
  679653
  566032
  605310
  513909
  530494
  679816
  596323
  534984
  603009
  637044
  631597
  525432
  727812
  722632
  729815
  666819
  663176
  808255
  731874
  722594
  598805
  809211
  552068
  516734
  722258
  807527
  671816
  732559
  684725
  657834
  606031
  639904
  629499
  541782
  661687
  803848
  735371
  747897
  703700
  779735
  590584
  633935
  754003
  680149
  663842
  621883
  784622
  762995
  788083
  751915
  624179
  711328
  643516
  777553
  777337
  799681
  757740
  424006
  401597
  579515
  534459
  662498
  706596
  408532
  716414
  560565
  568683
  522815
  479618
  680785
  641677
  624177
  798693
  709710
  605898
  506604
  506097
  533146
  562237
  613765
  800517
  745550
  731837
  498161
  601907
  569838
  574853
  574089
  559798
  672984
  619064
  766706
  432724
  510526
  501680
  511901
  657817
  633813
  594289
  503254
  503016
  505986
  552770
  757896
  452492
  744214
]
2.32 ms
(1.39%)
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
  401597
  408532
  424006
  432724
  452492
  479618
  486622
  498161
  501680
  503016
  503254
  505986
  506097
  506604
  510526
  511901
  513909
  516734
  522815
  523122
  525432
  525681
  528946
  528998
  529069
  530494
  533146
  534459
  534984
  534996
  541782
  552068
  552770
  559798
  560565
  562237
  566032
  568683
  569838
  571048
  574089
  574853
  579515
  583614
  590584
  594289
  596323
  598805
  600476
  601907
  603009
  605310
  605898
  606031
  612222
  613765
  619064
  621883
  624177
  624179
  629499
  631167
  631597
  633813
  633935
  637044
  639904
  641677
  643516
  657817
  657834
  661687
  662498
  663176
  663842
  666819
  671816
  672984
  679653
  679816
  680149
  680785
  684725
  703700
  706596
  709710
  711328
  716414
  722258
  722594
  722632
  727665
  727812
  729815
  731837
  731874
  732559
  735371
  744214
  745550
  747648
  747897
  751915
  754003
  757740
  757896
  762995
  766706
  777337
  777553
  779735
  784622
  788083
  798693
  799681
  800517
  803848
  807527
  808255
  809211
]
1.77 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "первая порно"
]
1.41 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "перв порн"
]
1.33 ms
(0.79%)
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.