Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
354.71 ms
(93.99%)
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
  397435
  414295
  421459
  426871
  432706
  455553
  464213
  464885
  472694
  518182
  531756
  536949
  544124
  550921
  555260
  555272
  556292
  563291
  578684
  583525
  584839
  585283
  587250
  590275
  590465
  591803
  595052
  597180
  610513
  617803
  617880
  628571
  629618
  647132
  647765
  653031
  657748
  658976
  660466
  666402
  667371
  689951
  694388
  700230
  715366
  716986
  719879
  722268
  734005
  734273
  734566
  736581
  748835
  758710
  762360
  766966
  773718
  777034
  777196
  777549
  777620
  778678
  778697
  779328
  779668
  779807
  779893
  780234
  780751
  781031
  782493
  782716
  783636
  783696
  783802
  786158
  786673
  787273
  789162
  790194
  792194
  792425
  792525
  792918
  793511
  794874
  794891
  795879
  795971
  796735
  800514
  804917
  814063
  816193
  817380
  817972
  819040
  819715
  819930
  821811
  823371
  823728
  823733
  824092
  824237
  824332
  824852
  824944
  825035
  825090
  825350
  825671
  825743
  825850
  826042
  826897
  827010
  827492
]
12.00 ms
(3.18%)
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
  653031
  658976
  597180
  397435
  824944
  531756
  544124
  590465
  786158
  804917
  736581
  432706
  800514
  455553
  421459
  464885
  518182
  536949
  555272
  556292
  550921
  584839
  563291
  583525
  689951
  666402
  700230
  647132
  657748
  715366
  578684
  585283
  590275
  595052
  629618
  610513
  591803
  617880
  587250
  617803
  628571
  787273
  795879
  795971
  734005
  734273
  773718
  796735
  766966
  748835
  758710
  762360
  734566
  777549
  790194
  792918
  414295
  426871
  816193
  819040
  819715
  821811
  823733
  824092
  824237
  825850
  814063
  819930
  823371
  823728
  824852
  825090
  825350
  826897
  827010
  827492
  817972
  824332
  825671
  825743
  817380
  825035
  826042
  464213
  472694
  694388
  719879
  722268
  660466
  667371
  647765
  716986
  555260
  777196
  778678
  778697
  779807
  779893
  782493
  783802
  786673
  789162
  792194
  792425
  792525
  793511
  794874
  794891
  776744
  777034
  777101
  777620
  779328
  779668
  780234
  780751
  781031
  782716
  783636
  783696
]
2.69 ms
(0.71%)
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
  397435
  414295
  421459
  426871
  432706
  455553
  464213
  464885
  472694
  518182
  531756
  536949
  544124
  550921
  555260
  555272
  556292
  563291
  578684
  583525
  584839
  585283
  587250
  590275
  590465
  591803
  595052
  597180
  610513
  617803
  617880
  628571
  629618
  647132
  647765
  653031
  657748
  658976
  660466
  666402
  667371
  689951
  694388
  700230
  715366
  716986
  719879
  722268
  734005
  734273
  734566
  736581
  748835
  758710
  762360
  766966
  773718
  777034
  777196
  777549
  777620
  778678
  778697
  779328
  779668
  779807
  779893
  780234
  780751
  781031
  782493
  782716
  783636
  783696
  783802
  786158
  786673
  787273
  789162
  790194
  792194
  792425
  792525
  792918
  793511
  794874
  794891
  795879
  795971
  796735
  800514
  804917
  814063
  816193
  817380
  817972
  819040
  819715
  819930
  821811
  823371
  823728
  823733
  824092
  824237
  824332
  824852
  824944
  825035
  825090
  825350
  825671
  825743
  825850
  826042
  826897
  827010
  827492
]
2.20 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm amateur"
]
2.01 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм любительск"
]
1.88 ms
(0.50%)
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.