Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.28 ms
(84.70%)
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
  38313
  95742
  170215
  191048
  191330
  233193
  233862
  239112
  366296
  381951
  385245
  385606
  385971
  386326
  387556
  388604
  388792
  390545
  390624
  391344
  394190
  394191
  395515
  395910
  395929
  395930
  395934
  396517
  396560
  397224
  398459
  398568
  399058
  399192
  400097
  400243
  401879
  402592
  403054
  403276
  404240
  407191
  407771
  409380
  410995
  411590
  411688
  413484
  413703
  416931
  417456
  420363
  420478
  423301
  427181
  448557
  450313
  453106
  475873
  479938
  481466
  485287
  491485
  505823
  515225
  536809
  537822
  574089
  589655
  609647
  618030
  623943
  627111
  644682
  661709
  665438
  665440
  665873
  667012
  667484
  667578
  689291
  689758
  693421
  698289
  712900
  715698
  717761
  720980
  725914
  728799
  729160
  731379
  732538
  737169
  741029
  742786
  743765
  744256
  744508
  746060
  747609
  766043
  774316
  779352
  785941
  788473
  790995
  791555
  797634
  797662
  798971
  799193
  800557
  801868
  805298
  805650
  811863
  815621
  818812
]
16.11 ms
(9.87%)
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
  589655
  609647
  644682
  623943
  785941
  788473
  797662
  798971
  790995
  800557
  801868
  747609
  741029
  725914
  731379
  744508
  746060
  742786
  766043
  805650
  233862
  233193
  38313
  239112
  394191
  395910
  398459
  403276
  95742
  366296
  381951
  390545
  448557
  450313
  453106
  475873
  574089
  715698
  797634
  811863
  407771
  420478
  391344
  481466
  395929
  403054
  413703
  515225
  774316
  491485
  395515
  397224
  401879
  407191
  815621
  536809
  537822
  661709
  665438
  667012
  667578
  689291
  712900
  667484
  720980
  665440
  665873
  689758
  693421
  618030
  779352
  799193
  805298
  744256
  791555
  728799
  732538
  743765
  729160
  737169
  627111
  717761
  385971
  394190
  398568
  386326
  818812
  395930
  191330
  170215
  191048
  388604
  387556
  396517
  396560
  399058
  400243
  402592
  411688
  413484
  423301
  417456
  479938
  485287
  505823
  698289
  404240
  390624
  399192
  388792
  410995
  385606
  385245
  395934
  400097
  411590
  420363
  409380
  427181
  416931
]
2.59 ms
(1.59%)
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
  38313
  95742
  170215
  191048
  191330
  233193
  233862
  239112
  366296
  381951
  385245
  385606
  385971
  386326
  387556
  388604
  388792
  390545
  390624
  391344
  394190
  394191
  395515
  395910
  395929
  395930
  395934
  396517
  396560
  397224
  398459
  398568
  399058
  399192
  400097
  400243
  401879
  402592
  403054
  403276
  404240
  407191
  407771
  409380
  410995
  411590
  411688
  413484
  413703
  416931
  417456
  420363
  420478
  423301
  427181
  448557
  450313
  453106
  475873
  479938
  481466
  485287
  491485
  505823
  515225
  536809
  537822
  574089
  589655
  609647
  618030
  623943
  627111
  644682
  661709
  665438
  665440
  665873
  667012
  667484
  667578
  689291
  689758
  693421
  698289
  712900
  715698
  717761
  720980
  725914
  728799
  729160
  731379
  732538
  737169
  741029
  742786
  743765
  744256
  744508
  746060
  747609
  766043
  774316
  779352
  785941
  788473
  790995
  791555
  797634
  797662
  798971
  799193
  800557
  801868
  805298
  805650
  811863
  815621
  818812
]
1.60 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde old"
]
1.56 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая old"
]
1.53 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая old"
]

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.