GET https://search.jues.net/search/embeds/7?q=sport%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.18 ms
(85.73%)
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
  415197
  416522
  417258
  418714
  418966
  426384
  435027
  455778
  461894
  463688
  463897
  464014
  465645
  465651
  469351
  469575
  471764
  477274
  490513
  490866
  493807
  497225
  497401
  499477
  500289
  503670
  506677
  508353
  508757
  509448
  510304
  512781
  512961
  513472
  514955
  514984
  515416
  515440
  515482
  515551
  515862
  516933
  517727
  517745
  518482
  520654
  520694
  521556
  521910
  521924
  522260
  524096
  528567
  529043
  531196
  532263
  533998
  534301
  535010
  542084
  542993
  543399
  547462
  550672
  556041
  556747
  563703
  564856
  565496
  569559
  574036
  574721
  576036
  577351
  579031
  579394
  580359
  580855
  582377
  584351
  585959
  586676
  588592
  595016
  600009
  600339
  601141
  601358
  601996
  602194
  604803
  616094
  619792
  621055
  624739
  625673
  626911
  629287
  632970
  633892
  635920
  636108
  636987
  637689
  641395
  644569
  646429
  647944
  675275
  679785
  691030
  718788
  760649
  786178
  787121
  801280
  805120
  810299
  813391
  814810
]
16.26 ms
(8.99%)
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
  644569
  600009
  625673
  641395
  515862
  520654
  522260
  521910
  535010
  415197
  508757
  531196
  534301
  469575
  647944
  675275
  580855
  786178
  477274
  417258
  814810
  465645
  577351
  646429
  679785
  718788
  691030
  588592
  636108
  586676
  632970
  636987
  787121
  521924
  517727
  426384
  469351
  503670
  510304
  532263
  542084
  542993
  576036
  595016
  600339
  619792
  801280
  813391
  465651
  463897
  455778
  516933
  490513
  490866
  515416
  515482
  464014
  524096
  497225
  520694
  506677
  418966
  512781
  514984
  543399
  579031
  556041
  582377
  556747
  574721
  629287
  635920
  637689
  810299
  509448
  497401
  529043
  518482
  533998
  461894
  579394
  563703
  601141
  604803
  626911
  805120
  760649
  624739
  463688
  521556
  528567
  517745
  493807
  514955
  574036
  435027
  515440
  416522
  471764
  512961
  515551
  499477
  580359
  584351
  547462
  550672
  565496
  569559
  564856
  601358
  633892
  585959
  602194
  621055
  601996
  616094
  418714
  513472
  508353
  500289
]
2.84 ms
(1.57%)
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
  415197
  416522
  417258
  418714
  418966
  426384
  435027
  455778
  461894
  463688
  463897
  464014
  465645
  465651
  469351
  469575
  471764
  477274
  490513
  490866
  493807
  497225
  497401
  499477
  500289
  503670
  506677
  508353
  508757
  509448
  510304
  512781
  512961
  513472
  514955
  514984
  515416
  515440
  515482
  515551
  515862
  516933
  517727
  517745
  518482
  520654
  520694
  521556
  521910
  521924
  522260
  524096
  528567
  529043
  531196
  532263
  533998
  534301
  535010
  542084
  542993
  543399
  547462
  550672
  556041
  556747
  563703
  564856
  565496
  569559
  574036
  574721
  576036
  577351
  579031
  579394
  580359
  580855
  582377
  584351
  585959
  586676
  588592
  595016
  600009
  600339
  601141
  601358
  601996
  602194
  604803
  616094
  619792
  621055
  624739
  625673
  626911
  629287
  632970
  633892
  635920
  636108
  636987
  637689
  641395
  644569
  646429
  647944
  675275
  679785
  691030
  718788
  760649
  786178
  787121
  801280
  805120
  810299
  813391
  814810
]
1.89 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sport sex"
]
1.78 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спортивная секс"
]
1.36 ms
(0.75%)
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.