GET https://search.jues.net/search/embeds/4?q=wife%20with%20friend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
113.59 ms
(84.29%)
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
  233489
  396356
  428675
  464213
  480973
  502323
  504759
  538135
  539251
  542211
  543359
  546087
  547085
  547172
  558696
  559967
  566440
  567953
  578722
  578781
  582001
  582840
  583319
  594547
  602392
  602667
  607000
  612037
  616640
  630035
  631994
  632026
  637543
  650491
  652532
  656834
  656846
  662522
  663446
  670830
  674606
  675694
  681509
  681756
  686850
  689068
  689958
  690923
  691373
  693420
  695359
  697007
  697190
  702155
  702926
  705208
  710839
  713975
  715117
  723087
  723824
  728918
  730157
  731126
  731157
  732650
  732842
  735917
  736239
  739939
  741081
  742592
  746345
  748350
  754863
  760949
  762779
  764429
  766344
  767690
  771802
  773960
  778127
  783815
  795049
  795756
  795955
  797033
  800916
  801983
  802600
  803742
  810304
  813715
  814127
  814716
  819408
  819747
  819909
  820001
  820132
  820197
  823258
  823725
  824088
  824136
  824417
  824774
  824823
  825532
  825838
  825881
  826328
  826484
  826581
  826929
  827470
  827704
  828627
]
11.24 ms
(8.34%)
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
  650491
  713975
  686850
  578781
  616640
  795955
  607000
  826484
  823725
  823258
  826328
  567953
  656846
  675694
  731126
  728918
  746345
  663446
  504759
  689068
  691373
  702155
  602667
  732842
  760949
  783815
  810304
  233489
  396356
  428675
  819408
  820132
  824823
  825881
  826581
  813715
  819909
  824774
  826929
  825838
  828627
  464213
  538135
  542211
  582840
  547085
  582001
  559967
  674606
  690923
  681756
  705208
  656834
  702926
  546087
  558696
  602392
  612037
  637543
  741081
  767690
  797033
  800916
  723824
  764429
  754863
  762779
  630035
  778127
  795756
  578722
  543359
  814127
  827470
  820197
  480973
  502323
  583319
  710839
  695359
  697190
  689958
  801983
  748350
  730157
  735917
  771802
  697007
  802600
  547172
  594547
  776489
  731157
  773960
  736239
  539251
  652532
  662522
  723087
  670830
  681509
  566440
  632026
  803742
  732650
  742592
  766344
  631994
  715117
  795049
  739939
  693420
  819747
  824088
  814716
  824136
  824417
  827704
  820001
  825532
]
2.71 ms
(2.01%)
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
  233489
  396356
  428675
  464213
  480973
  502323
  504759
  538135
  539251
  542211
  543359
  546087
  547085
  547172
  558696
  559967
  566440
  567953
  578722
  578781
  582001
  582840
  583319
  594547
  602392
  602667
  607000
  612037
  616640
  630035
  631994
  632026
  637543
  650491
  652532
  656834
  656846
  662522
  663446
  670830
  674606
  675694
  681509
  681756
  686850
  689068
  689958
  690923
  691373
  693420
  695359
  697007
  697190
  702155
  702926
  705208
  710839
  713975
  715117
  723087
  723824
  728918
  730157
  731126
  731157
  732650
  732842
  735917
  736239
  739939
  741081
  742592
  746345
  748350
  754863
  760949
  762779
  764429
  766344
  767690
  771802
  773960
  778127
  783815
  795049
  795756
  795955
  797033
  800916
  801983
  802600
  803742
  810304
  813715
  814127
  814716
  819408
  819747
  819909
  820001
  820132
  820197
  823258
  823725
  824088
  824136
  824417
  824774
  824823
  825532
  825838
  825881
  826328
  826484
  826581
  826929
  827470
  827704
  828627
]
2.16 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife with friend"
]
1.81 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен friend"
]
1.72 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен friend"
]
1.52 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.