Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
113.85 ms
(84.46%)
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
  60096
  392508
  404440
  479446
  525444
  535972
  541350
  548913
  550539
  554114
  554236
  556285
  569365
  574289
  575636
  577836
  577905
  577989
  583531
  590328
  592326
  593919
  594051
  594067
  594604
  603374
  614665
  622303
  622477
  622512
  628219
  628851
  629727
  630473
  630478
  631828
  637898
  643879
  644600
  645728
  652424
  655841
  657158
  660789
  660799
  675715
  677074
  691676
  707741
  709459
  720104
  720328
  721125
  721223
  721756
  725336
  728759
  729705
  730432
  730676
  730780
  730944
  731123
  734813
  735379
  735743
  737971
  741553
  742075
  742193
  744882
  746650
  746753
  748369
  748649
  755130
  755553
  760288
  761861
  762015
  764193
  764808
  766517
  769128
  778510
  778518
  778722
  779926
  780808
  782499
  785171
  786204
  786491
  787941
  791325
  791748
  795577
  795611
  796857
  797573
  798527
  800283
  800317
  801624
  802522
  802632
  804197
  804853
  805649
  807924
  813279
  814490
  818937
  819102
  819442
  821800
  825537
  827041
  827569
]
11.53 ms
(8.56%)
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
  819102
  525444
  550539
  721223
  725336
  577836
  655841
  707741
  721125
  592326
  630473
  631828
  637898
  644600
  594051
  622512
  778722
  782499
  786204
  786491
  800317
  731123
  734813
  798527
  730944
  741553
  769128
  735379
  764808
  748369
  764193
  746753
  627511
  800283
  805649
  813279
  660799
  603374
  594067
  795577
  796857
  801624
  730780
  746650
  554114
  802632
  60096
  535972
  554236
  575636
  577905
  556285
  541350
  569365
  645728
  657158
  709459
  720104
  652424
  574289
  577989
  590328
  593919
  630478
  622303
  629727
  614665
  778510
  778518
  779926
  785171
  791325
  797573
  787941
  802522
  807924
  729705
  730676
  742075
  744882
  766517
  791748
  735743
  761861
  762015
  748649
  755553
  760288
  742193
  728759
  730432
  755130
  643879
  721756
  780808
  795611
  804197
  804853
  392508
  814490
  821800
  825537
  818937
  827041
  827569
  819442
  720328
  737971
  404440
  479446
  548913
  583531
  660789
  691676
  675715
  677074
  594604
  622477
  628219
  628851
]
2.63 ms
(1.95%)
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
  60096
  392508
  404440
  479446
  525444
  535972
  541350
  548913
  550539
  554114
  554236
  556285
  569365
  574289
  575636
  577836
  577905
  577989
  583531
  590328
  592326
  593919
  594051
  594067
  594604
  603374
  614665
  622303
  622477
  622512
  628219
  628851
  629727
  630473
  630478
  631828
  637898
  643879
  644600
  645728
  652424
  655841
  657158
  660789
  660799
  675715
  677074
  691676
  707741
  709459
  720104
  720328
  721125
  721223
  721756
  725336
  728759
  729705
  730432
  730676
  730780
  730944
  731123
  734813
  735379
  735743
  737971
  741553
  742075
  742193
  744882
  746650
  746753
  748369
  748649
  755130
  755553
  760288
  761861
  762015
  764193
  764808
  766517
  769128
  778510
  778518
  778722
  779926
  780808
  782499
  785171
  786204
  786491
  787941
  791325
  791748
  795577
  795611
  796857
  797573
  798527
  800283
  800317
  801624
  802522
  802632
  804197
  804853
  805649
  807924
  813279
  814490
  818937
  819102
  819442
  821800
  825537
  827041
  827569
]
1.89 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 year"
]
1.78 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 year"
]
1.40 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 year"
]

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.