GET https://search.jues.net/search/embeds/3?q=my%20wife%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.25 ms
(86.55%)
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
  396418
  407115
  420565
  427498
  450377
  451669
  495808
  497813
  500878
  503989
  504725
  506218
  509717
  511808
  517258
  517599
  517796
  520520
  526722
  528741
  529141
  531919
  532215
  535300
  537216
  539316
  540171
  542442
  542742
  547411
  548415
  553699
  554686
  557226
  570984
  571351
  573441
  574172
  579726
  580082
  580418
  585537
  593741
  600725
  606967
  611496
  614536
  629671
  629780
  630105
  636607
  637328
  665965
  666472
  684449
  689893
  692819
  694420
  695835
  696960
  700830
  709304
  717443
  719461
  719895
  726527
  728832
  734569
  735008
  735429
  737598
  740567
  740823
  744778
  746050
  749063
  749801
  750371
  751260
  754894
  761676
  764260
  769137
  771730
  779263
  782444
  786730
  788563
  788586
  791154
  793457
  795898
  796075
  797142
  801451
  801569
  801794
  801842
  801912
  802085
  802305
  805096
  806359
  806710
  809486
  809824
  810530
  811873
  813592
  818295
  818879
  820124
  820372
  821807
  824743
  824989
  825935
  828592
  828810
]
15.52 ms
(8.08%)
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
  694420
  427498
  517258
  692819
  719461
  593741
  751260
  553699
  796075
  746050
  824743
  539316
  497813
  540171
  570984
  719895
  629780
  585537
  788563
  791154
  793457
  801794
  782444
  795898
  750371
  754894
  761676
  805096
  717443
  801451
  542742
  526722
  579726
  517599
  495808
  825935
  818879
  537216
  779276
  806710
  606967
  407115
  529141
  532215
  528741
  695835
  630105
  600725
  801569
  797142
  726527
  749063
  809486
  504725
  788586
  557226
  396418
  571351
  666472
  420565
  786730
  509717
  573441
  700830
  769137
  749801
  450377
  451669
  500878
  503989
  520520
  511808
  506218
  580418
  821807
  813592
  820124
  824989
  818295
  820372
  828810
  517796
  535300
  542442
  547411
  574172
  548415
  689893
  684449
  696960
  665965
  554686
  580082
  611496
  637328
  614536
  629671
  636607
  801912
  735008
  740823
  802085
  806359
  809824
  810530
  811873
  744778
  734569
  735429
  740567
  764260
  728832
  771730
  709304
  779263
  801842
  802305
  828592
  737598
  531919
]
3.04 ms
(1.58%)
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
  396418
  407115
  420565
  427498
  450377
  451669
  495808
  497813
  500878
  503989
  504725
  506218
  509717
  511808
  517258
  517599
  517796
  520520
  526722
  528741
  529141
  531919
  532215
  535300
  537216
  539316
  540171
  542442
  542742
  547411
  548415
  553699
  554686
  557226
  570984
  571351
  573441
  574172
  579726
  580082
  580418
  585537
  593741
  600725
  606967
  611496
  614536
  629671
  629780
  630105
  636607
  637328
  665965
  666472
  684449
  689893
  692819
  694420
  695835
  696960
  700830
  709304
  717443
  719461
  719895
  726527
  728832
  734569
  735008
  735429
  737598
  740567
  740823
  744778
  746050
  749063
  749801
  750371
  751260
  754894
  761676
  764260
  769137
  771730
  779263
  782444
  786730
  788563
  788586
  791154
  793457
  795898
  796075
  797142
  801451
  801569
  801794
  801842
  801912
  802085
  802305
  805096
  806359
  806710
  809486
  809824
  810530
  811873
  813592
  818295
  818879
  820124
  820372
  821807
  824743
  824989
  825935
  828592
  828810
]
2.19 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "my wife shower"
]
1.81 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "my жен shower"
]
1.73 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "my жен shower"
]

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.