Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.24 ms
(61.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал руское домашние"
]
116.54 ms
(33.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
  370332
  390904
  424296
  432580
  440715
  452791
  468386
  470076
  472323
  473783
  474263
  475499
  478421
  479054
  497648
  532765
  533653
  538005
  543572
  546057
  554956
  555086
  563405
  579210
  581467
  590621
  598036
  598797
  605966
  609289
  609669
  614881
  616852
  625745
  630451
  636238
  640153
  640776
  645031
  646661
  655281
  662194
  665831
  676797
  685460
  686578
  695319
  695745
  697545
  699987
  705640
  707181
  707461
  709505
  714429
  714660
  715009
  715494
  717913
  720087
  723178
  723236
  726164
  728247
  731595
  734973
  736959
  738121
  738296
  744386
  745448
  745457
  748701
  752647
  752735
  755727
  757784
  761302
  762449
  764161
  765717
  765951
  766355
  766505
  766679
  766717
  766742
  766868
  767073
  769075
  775895
  777083
  778896
  781002
  782349
  784743
  785813
  787554
  788425
  790488
  790520
  791045
  791365
  793991
  794782
  796196
  798799
  799911
  800793
  801800
  802139
  803255
  804320
  804871
  804930
  805650
  809356
  816611
  818760
  826153
]
10.31 ms
(3.00%)
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
  745457
  390904
  468386
  764161
  826153
  474263
  478421
  581467
  714660
  707461
  715009
  785813
  787554
  791045
  796196
  803255
  782349
  790520
  800793
  809356
  731595
  793991
  804930
  766742
  765951
  728247
  765717
  767073
  769075
  766717
  609289
  717913
  798799
  801800
  805650
  479054
  640776
  370332
  818760
  816611
  778896
  804320
  794782
  802139
  766355
  766505
  775895
  707181
  738121
  543572
  605966
  497648
  645031
  532765
  598797
  533653
  646661
  665831
  676797
  685460
  686578
  695319
  695745
  709505
  554956
  555086
  640153
  590621
  630451
  788425
  616852
  705640
  784743
  563405
  440715
  473783
  546057
  720087
  723236
  662194
  655281
  723178
  598036
  625745
  614881
  636238
  791365
  777083
  799911
  745448
  752647
  804871
  726164
  744386
  757784
  762449
  766868
  734973
  748701
  755727
  761302
  738296
  752735
  736959
  766679
  697545
  699987
  714429
  715494
  781002
  790488
  424296
  538005
  470076
  579210
  609669
  475499
  472323
  432580
  452791
]
2.29 ms
(0.67%)
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
  370332
  390904
  424296
  432580
  440715
  452791
  468386
  470076
  472323
  473783
  474263
  475499
  478421
  479054
  497648
  532765
  533653
  538005
  543572
  546057
  554956
  555086
  563405
  579210
  581467
  590621
  598036
  598797
  605966
  609289
  609669
  614881
  616852
  625745
  630451
  636238
  640153
  640776
  645031
  646661
  655281
  662194
  665831
  676797
  685460
  686578
  695319
  695745
  697545
  699987
  705640
  707181
  707461
  709505
  714429
  714660
  715009
  715494
  717913
  720087
  723178
  723236
  726164
  728247
  731595
  734973
  736959
  738121
  738296
  744386
  745448
  745457
  748701
  752647
  752735
  755727
  757784
  761302
  762449
  764161
  765717
  765951
  766355
  766505
  766679
  766717
  766742
  766868
  767073
  769075
  775895
  777083
  778896
  781002
  782349
  784743
  785813
  787554
  788425
  790488
  790520
  791045
  791365
  793991
  794782
  796196
  798799
  799911
  800793
  801800
  802139
  803255
  804320
  804871
  804930
  805650
  809356
  816611
  818760
  826153
]
1.71 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал русск домашн любительск"
]
1.40 ms
(0.41%)
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.