Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
219.13 ms
(88.68%)
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
  388732
  392665
  419269
  419982
  422278
  423913
  425562
  426483
  427213
  428044
  431761
  432991
  435938
  437788
  438712
  442533
  444384
  453424
  454466
  457409
  457872
  460881
  462704
  463343
  464022
  465965
  468409
  470720
  472566
  475542
  475579
  482013
  489937
  495623
  496497
  498854
  499476
  500265
  502230
  503819
  507427
  509465
  520812
  521603
  526852
  527061
  528201
  534389
  537424
  539820
  539825
  543829
  551639
  552136
  553156
  555184
  563423
  563969
  567059
  569476
  579513
  589550
  592856
  595470
  599876
  601880
  607030
  609185
  615945
  617376
  626122
  626193
  631603
  635259
  637437
  640776
  662140
  673836
  677222
  679685
  685547
  697479
  703357
  703948
  707843
  707894
  708031
  715024
  715622
  717336
  719112
  727038
  727707
  738442
  739134
  742214
  749878
  756689
  756735
  760700
  761519
  761899
  764589
  776112
  776824
  777456
  777750
  791095
  795123
  799459
  799791
  799828
  801068
  801260
  802091
  804894
  807740
  811963
  822825
]
14.14 ms
(5.72%)
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
  555184
  592856
  635259
  776112
  776824
  799828
  807740
  801260
  739134
  749878
  422278
  438712
  419269
  428044
  435938
  444384
  426483
  437788
  822825
  454466
  468409
  470720
  472566
  463343
  464022
  495623
  498854
  509465
  539820
  539825
  496497
  500265
  502230
  520812
  534389
  528201
  537424
  499476
  503819
  507427
  521603
  526852
  527061
  475542
  489937
  543829
  579513
  551639
  553156
  552136
  563969
  685547
  703948
  662140
  673836
  677222
  679685
  697479
  703357
  703562
  707843
  708031
  715024
  563423
  567059
  569476
  589550
  601880
  626193
  595470
  609185
  617376
  626122
  637437
  599876
  615945
  640776
  607030
  631603
  777750
  791095
  799459
  799791
  811963
  802091
  804894
  760700
  761519
  727707
  738442
  756689
  742214
  761899
  727038
  756735
  764589
  707894
  715622
  717336
  719112
  777456
  795123
  801068
  388732
  392665
  423913
  431761
  432991
  453424
  457409
  460881
  462704
  475579
  482013
  419982
  427213
  442533
  465965
  425562
  457872
]
6.46 ms
(2.61%)
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
  388732
  392665
  419269
  419982
  422278
  423913
  425562
  426483
  427213
  428044
  431761
  432991
  435938
  437788
  438712
  442533
  444384
  453424
  454466
  457409
  457872
  460881
  462704
  463343
  464022
  465965
  468409
  470720
  472566
  475542
  475579
  482013
  489937
  495623
  496497
  498854
  499476
  500265
  502230
  503819
  507427
  509465
  520812
  521603
  526852
  527061
  528201
  534389
  537424
  539820
  539825
  543829
  551639
  552136
  553156
  555184
  563423
  563969
  567059
  569476
  579513
  589550
  592856
  595470
  599876
  601880
  607030
  609185
  615945
  617376
  626122
  626193
  631603
  635259
  637437
  640776
  662140
  673836
  677222
  679685
  685547
  697479
  703357
  703948
  707843
  707894
  708031
  715024
  715622
  717336
  719112
  727038
  727707
  738442
  739134
  742214
  749878
  756689
  756735
  760700
  761519
  761899
  764589
  776112
  776824
  777456
  777750
  791095
  795123
  799459
  799791
  799828
  801068
  801260
  802091
  804894
  807740
  811963
  822825
]
2.02 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм home"
]
1.88 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm home"
]
1.71 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм home"
]

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.