Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.02 ms
(81.02%)
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
  387937
  390835
  420769
  422732
  428603
  429523
  432568
  432574
  432683
  433040
  433047
  434971
  435462
  443112
  443573
  443637
  443991
  446976
  452228
  452282
  452283
  458916
  460079
  460327
  465698
  467019
  467581
  467583
  470412
  472488
  475921
  477072
  478608
  482644
  484547
  486214
  486312
  487747
  490132
  499332
  499336
  501255
  503274
  503453
  505460
  506529
  508424
  508883
  512528
  512533
  513215
  514797
  516924
  517049
  518766
  521505
  521507
  524865
  528363
  529404
  539786
  553282
  555798
  555857
  557676
  558185
  558416
  559154
  561980
  565700
  566758
  568371
  571751
  574410
  578596
  578898
  579360
  582935
  583428
  586912
  587751
  591094
  595070
  595101
  597117
  602617
  603612
  604011
  604338
  604352
  605374
  605453
  605557
  606294
  607021
  617214
  619692
  621348
  624511
  632055
  632333
  633937
  643113
  647090
  659025
  667826
  714003
  724921
  732553
  733579
  737198
  738047
  752961
  785635
  790034
  802067
  805811
  806722
  809272
  809520
]
17.67 ms
(11.83%)
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
  602617
  595101
  604011
  604338
  586912
  607021
  633937
  790034
  806722
  785635
  805811
  737198
  752961
  732553
  733579
  738047
  428603
  486312
  508424
  557676
  387937
  432568
  432574
  443573
  443637
  422732
  429523
  467583
  490132
  465698
  452283
  460079
  499336
  501255
  528363
  521505
  539786
  506529
  516924
  484547
  487747
  553282
  558416
  565700
  566758
  578596
  582935
  578898
  667826
  587751
  597117
  604352
  605453
  605557
  802067
  724921
  632333
  714003
  458916
  486214
  514797
  518766
  435462
  443991
  452228
  452282
  460327
  470412
  478608
  477072
  482644
  499332
  503274
  512528
  467019
  475921
  555857
  568371
  574410
  647090
  571751
  595070
  606294
  619692
  809272
  617214
  624511
  632055
  809520
  433047
  433040
  472488
  420769
  390835
  443112
  434971
  505460
  512533
  508883
  521507
  555798
  559154
  561980
  583428
  659025
  605374
  643113
  503453
  513215
  517049
  524865
  529404
  603612
  621348
  591094
  446976
  579360
  558185
  467581
  432683
]
3.72 ms
(2.49%)
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
  387937
  390835
  420769
  422732
  428603
  429523
  432568
  432574
  432683
  433040
  433047
  434971
  435462
  443112
  443573
  443637
  443991
  446976
  452228
  452282
  452283
  458916
  460079
  460327
  465698
  467019
  467581
  467583
  470412
  472488
  475921
  477072
  478608
  482644
  484547
  486214
  486312
  487747
  490132
  499332
  499336
  501255
  503274
  503453
  505460
  506529
  508424
  508883
  512528
  512533
  513215
  514797
  516924
  517049
  518766
  521505
  521507
  524865
  528363
  529404
  539786
  553282
  555798
  555857
  557676
  558185
  558416
  559154
  561980
  565700
  566758
  568371
  571751
  574410
  578596
  578898
  579360
  582935
  583428
  586912
  587751
  591094
  595070
  595101
  597117
  602617
  603612
  604011
  604338
  604352
  605374
  605453
  605557
  606294
  607021
  617214
  619692
  621348
  624511
  632055
  632333
  633937
  643113
  647090
  659025
  667826
  714003
  724921
  732553
  733579
  737198
  738047
  752961
  785635
  790034
  802067
  805811
  806722
  809272
  809520
]
1.89 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam interracial"
]
1.68 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер межрасов"
]
1.57 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.