Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.63 ms
(87.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
  460895
  494643
  509185
  529990
  533401
  541210
  546281
  558309
  567542
  568700
  584946
  586295
  587689
  590211
  593837
  604367
  605185
  605899
  606497
  610699
  610743
  618260
  619814
  625462
  626840
  629711
  632928
  634646
  635624
  636071
  636981
  639597
  642430
  645052
  646012
  654236
  657735
  660573
  664665
  668006
  668959
  669692
  674202
  680581
  682728
  689180
  690222
  690630
  693392
  695078
  701533
  704447
  709468
  710862
  714037
  714071
  714121
  714126
  715043
  715061
  715065
  717417
  721900
  721966
  730116
  730702
  732191
  732757
  732953
  733505
  735197
  735805
  736401
  736544
  738616
  738888
  739487
  740727
  745502
  748328
  751403
  753772
  757572
  758337
  759158
  760520
  760932
  761138
  764367
  773971
  777907
  780318
  780601
  782521
  785158
  785174
  786403
  787779
  789487
  791308
  791995
  792438
  793914
  796512
  796811
  797075
  800689
  800726
  801494
  805319
  806298
  807019
  809879
  811915
  815908
  816807
  824122
  824325
  827735
  828453
]
16.05 ms
(7.84%)
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
  815908
  827735
  567542
  660573
  714121
  664665
  701533
  645052
  690222
  715043
  721966
  635624
  791308
  797075
  805319
  807019
  785174
  800726
  806298
  740727
  757572
  753772
  733505
  738616
  751403
  777907
  669692
  587689
  730116
  732191
  780601
  689180
  773971
  786403
  730702
  735197
  738888
  816807
  824122
  668006
  680581
  693392
  695078
  710862
  717417
  546281
  604367
  625462
  642430
  610699
  636071
  586295
  610743
  636981
  605899
  634646
  785158
  800689
  789487
  748328
  761138
  732757
  759158
  760932
  764367
  758337
  619814
  639597
  714037
  715065
  721900
  793914
  460895
  796512
  618260
  828453
  558309
  593837
  606497
  796811
  732953
  715061
  809879
  533401
  646012
  654236
  657735
  632928
  735805
  494643
  709468
  801494
  811915
  824325
  509185
  529990
  541210
  568700
  584946
  674202
  714071
  704447
  714126
  668959
  682728
  690630
  590211
  626840
  629711
  605185
  780318
  787779
  791995
  792438
  736401
  739487
  745502
  760520
  782521
  736544
]
2.30 ms
(1.12%)
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
  460895
  494643
  509185
  529990
  533401
  541210
  546281
  558309
  567542
  568700
  584946
  586295
  587689
  590211
  593837
  604367
  605185
  605899
  606497
  610699
  610743
  618260
  619814
  625462
  626840
  629711
  632928
  634646
  635624
  636071
  636981
  639597
  642430
  645052
  646012
  654236
  657735
  660573
  664665
  668006
  668959
  669692
  674202
  680581
  682728
  689180
  690222
  690630
  693392
  695078
  701533
  704447
  709468
  710862
  714037
  714071
  714121
  714126
  715043
  715061
  715065
  717417
  721900
  721966
  730116
  730702
  732191
  732757
  732953
  733505
  735197
  735805
  736401
  736544
  738616
  738888
  739487
  740727
  745502
  748328
  751403
  753772
  757572
  758337
  759158
  760520
  760932
  761138
  764367
  773971
  777907
  780318
  780601
  782521
  785158
  785174
  786403
  787779
  789487
  791308
  791995
  792438
  793914
  796512
  796811
  797075
  800689
  800726
  801494
  805319
  806298
  807019
  809879
  811915
  815908
  816807
  824122
  824325
  827735
  828453
]
1.83 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife front of"
]
1.81 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен front"
]
1.54 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен front"
]

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.