Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.14 ms
(54.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian young"
]
149.23 ms
(39.16%)
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
  53992
  385913
  386211
  391002
  401120
  401344
  402266
  416191
  418332
  420613
  422511
  422513
  422514
  422543
  422550
  422572
  422591
  422592
  422610
  422625
  422630
  422654
  422657
  422661
  422705
  422709
  422711
  422834
  422847
  422862
  422901
  422908
  422923
  422934
  422958
  422959
  422969
  422985
  422993
  422997
  423006
  423007
  423009
  423021
  423022
  423023
  423025
  423243
  423263
  423266
  423270
  423271
  423280
  423283
  423412
  424946
  429565
  433610
  435727
  443225
  446258
  446266
  452434
  453331
  456627
  456633
  456634
  456642
  477216
  491354
  501865
  517997
  525605
  529182
  534776
  537568
  537732
  539519
  547642
  550523
  550642
  550644
  551017
  551066
  551947
  554426
  556397
  559909
  562872
  564066
  565996
  566009
  581393
  583397
  585398
  594960
  595765
  595945
  595952
  600559
  602044
  619451
  623499
  630192
  691221
  714119
  720829
  737151
  741109
  744704
  745764
  747984
  748684
  748686
  759782
  792722
  805279
  808754
  808756
  821625
]
15.35 ms
(4.03%)
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
  422630
  422709
  422901
  420613
  422511
  422657
  446266
  456633
  556397
  422705
  456627
  491354
  418332
  423007
  423021
  423270
  422625
  422847
  422514
  422572
  429565
  423025
  452434
  537732
  583397
  554426
  562872
  720829
  564066
  585398
  623499
  595952
  595945
  805279
  748686
  808756
  423009
  423263
  422862
  423271
  402266
  422543
  422610
  477216
  422923
  501865
  581393
  550642
  737151
  792722
  550523
  565996
  537568
  566009
  745764
  391002
  550644
  422958
  422592
  619451
  422513
  435727
  385913
  401120
  422969
  423243
  443225
  422934
  525605
  517997
  551017
  551066
  551947
  559909
  630192
  595765
  600559
  808754
  747984
  759782
  602044
  53992
  422959
  401344
  416191
  422993
  423006
  423023
  422661
  422997
  422550
  422654
  422834
  424946
  422591
  422908
  423283
  456634
  453331
  534776
  529182
  691221
  714119
  594960
  741109
  748684
  744704
  423022
  446258
  386211
  423412
  433610
  456642
  423280
  422711
  422985
  423266
  821625
  539519
  547642
]
2.40 ms
(0.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
  53992
  385913
  386211
  391002
  401120
  401344
  402266
  416191
  418332
  420613
  422511
  422513
  422514
  422543
  422550
  422572
  422591
  422592
  422610
  422625
  422630
  422654
  422657
  422661
  422705
  422709
  422711
  422834
  422847
  422862
  422901
  422908
  422923
  422934
  422958
  422959
  422969
  422985
  422993
  422997
  423006
  423007
  423009
  423021
  423022
  423023
  423025
  423243
  423263
  423266
  423270
  423271
  423280
  423283
  423412
  424946
  429565
  433610
  435727
  443225
  446258
  446266
  452434
  453331
  456627
  456633
  456634
  456642
  477216
  491354
  501865
  517997
  525605
  529182
  534776
  537568
  537732
  539519
  547642
  550523
  550642
  550644
  551017
  551066
  551947
  554426
  556397
  559909
  562872
  564066
  565996
  566009
  581393
  583397
  585398
  594960
  595765
  595945
  595952
  600559
  602044
  619451
  623499
  630192
  691221
  714119
  720829
  737151
  741109
  744704
  745764
  747984
  748684
  748686
  759782
  792722
  805279
  808754
  808756
  821625
]
1.88 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк young"
]
1.53 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк young"
]

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.