GET https://search.jues.net/search/embeds/3?q=%D0%BC%D0%B8%D0%BB%D1%84%D1%8B%20%D0%BE%D1%80%D0%B3%D0%B0%D0%B7%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.49 ms
(85.28%)
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
  263039
  346141
  400735
  401799
  405528
  409334
  411896
  413687
  415873
  443168
  455598
  460622
  476088
  476666
  499089
  510595
  515874
  527085
  530479
  530700
  531223
  532816
  536538
  541669
  543652
  550379
  557873
  559368
  561107
  569922
  575705
  587536
  593316
  599833
  599961
  600004
  600417
  605909
  624810
  629965
  632650
  634472
  636315
  638298
  638742
  639274
  639818
  639823
  640400
  648235
  652766
  666736
  669893
  669912
  678836
  681081
  681131
  688546
  707389
  713329
  718678
  718768
  718784
  720950
  721168
  721750
  736905
  736944
  737473
  739820
  744598
  751587
  751600
  751611
  752759
  756614
  757883
  758952
  761570
  765683
  765836
  772884
  774575
  776548
  784750
  787408
  787479
  787488
  788818
  789954
  791489
  792652
  797771
  800706
  801416
  801949
  802832
  804451
  805490
  805564
  806973
  808450
  810132
  810896
  812626
  813002
  813003
  814491
  814852
  815031
  815396
  815801
  816057
  816292
  818442
  819594
  820070
  825864
  826715
  827080
]
12.91 ms
(8.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
  669912
  605909
  812626
  805564
  787479
  801416
  810896
  756614
  739820
  765683
  632650
  721750
  813003
  814491
  559368
  515874
  652766
  455598
  263039
  678836
  813002
  530479
  648235
  569922
  634472
  599961
  405528
  825864
  530700
  575705
  718678
  784750
  801949
  791489
  346141
  826715
  819594
  827080
  816057
  557873
  681131
  707389
  587536
  789954
  800706
  806973
  787408
  808450
  761570
  765836
  629965
  718768
  774575
  805490
  411896
  409334
  600004
  792652
  443168
  460622
  476088
  541669
  758952
  636315
  413687
  532816
  536538
  543652
  638298
  639818
  599833
  400735
  816292
  814852
  815031
  815801
  820070
  815396
  818442
  550379
  666736
  681081
  718784
  688546
  669893
  721168
  593316
  624810
  640400
  639274
  600417
  638742
  776548
  787488
  804451
  802832
  737473
  751611
  797771
  810132
  736944
  751600
  757883
  736905
  751587
  752759
  772884
  744598
  713329
  720950
  788818
  415873
  476666
  510595
  531223
  561107
  639823
  401799
  499089
  527085
]
3.04 ms
(1.93%)
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
  263039
  346141
  400735
  401799
  405528
  409334
  411896
  413687
  415873
  443168
  455598
  460622
  476088
  476666
  499089
  510595
  515874
  527085
  530479
  530700
  531223
  532816
  536538
  541669
  543652
  550379
  557873
  559368
  561107
  569922
  575705
  587536
  593316
  599833
  599961
  600004
  600417
  605909
  624810
  629965
  632650
  634472
  636315
  638298
  638742
  639274
  639818
  639823
  640400
  648235
  652766
  666736
  669893
  669912
  678836
  681081
  681131
  688546
  707389
  713329
  718678
  718768
  718784
  720950
  721168
  721750
  736905
  736944
  737473
  739820
  744598
  751587
  751600
  751611
  752759
  756614
  757883
  758952
  761570
  765683
  765836
  772884
  774575
  776548
  784750
  787408
  787479
  787488
  788818
  789954
  791489
  792652
  797771
  800706
  801416
  801949
  802832
  804451
  805490
  805564
  806973
  808450
  810132
  810896
  812626
  813002
  813003
  814491
  814852
  815031
  815396
  815801
  816057
  816292
  818442
  819594
  820070
  825864
  826715
  827080
]
2.02 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милф оргазм"
]
2.01 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "милфы оргазм"
]
1.63 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.02%)
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.