GET https://search.jues.net/search/embeds/5?q=mom%20shower%20bathroom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.67 ms
(85.60%)
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
  313187
  379559
  385086
  386936
  395513
  395533
  395750
  396758
  404279
  404464
  421989
  422147
  425640
  451711
  451795
  459783
  460167
  462574
  477950
  479493
  482328
  483654
  486539
  491934
  495582
  507003
  514394
  516712
  517328
  523848
  526515
  527230
  528215
  528627
  529518
  531482
  533562
  535490
  542742
  542938
  562887
  563142
  563233
  566684
  566686
  586636
  586826
  590291
  592526
  599209
  605973
  610271
  616188
  624497
  627728
  630494
  631988
  638147
  641082
  651186
  673963
  677949
  690623
  697381
  702966
  710078
  716898
  716915
  721167
  721910
  723731
  729612
  740435
  744912
  744982
  746107
  756285
  758171
  758804
  759116
  765185
  766385
  769417
  770874
  773255
  780930
  781907
  784520
  785479
  791501
  793370
  796730
  797639
  797846
  798643
  798763
  799399
  800926
  801353
  806071
  806201
  814851
  815751
  815758
  815823
  815840
  816392
  816951
  817278
  817878
  818354
  818854
  821902
  822637
  822657
  823278
  823292
  823358
  823473
  823563
]
15.26 ms
(8.50%)
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
  527230
  460167
  566684
  563142
  673963
  592526
  791501
  773255
  313187
  379559
  451711
  386936
  422147
  459783
  477950
  514394
  491934
  483654
  495582
  395750
  822657
  815758
  823292
  815751
  818354
  823473
  816951
  822637
  823563
  479493
  529518
  533562
  531482
  542938
  677949
  710078
  716898
  721910
  651186
  697381
  716915
  721167
  690623
  702966
  590291
  599209
  616188
  630494
  631988
  586826
  586636
  605973
  627728
  641082
  793370
  798643
  797846
  798763
  800926
  806071
  806201
  729612
  756285
  765185
  766385
  784520
  785479
  796730
  740435
  723731
  758804
  759116
  770874
  746107
  744982
  758171
  769417
  624497
  638147
  780930
  781907
  797639
  799399
  801353
  482328
  526515
  610271
  486539
  395513
  404464
  451795
  563233
  566686
  542742
  562887
  744912
  404279
  425640
  462574
  396758
  516712
  528627
  507003
  523848
  528215
  421989
  385086
  395533
  814851
  817878
  818854
  817278
  823358
  815823
  815840
  816392
  823278
  821902
  517328
  535490
]
3.28 ms
(1.83%)
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
  313187
  379559
  385086
  386936
  395513
  395533
  395750
  396758
  404279
  404464
  421989
  422147
  425640
  451711
  451795
  459783
  460167
  462574
  477950
  479493
  482328
  483654
  486539
  491934
  495582
  507003
  514394
  516712
  517328
  523848
  526515
  527230
  528215
  528627
  529518
  531482
  533562
  535490
  542742
  542938
  562887
  563142
  563233
  566684
  566686
  586636
  586826
  590291
  592526
  599209
  605973
  610271
  616188
  624497
  627728
  630494
  631988
  638147
  641082
  651186
  673963
  677949
  690623
  697381
  702966
  710078
  716898
  716915
  721167
  721910
  723731
  729612
  740435
  744912
  744982
  746107
  756285
  758171
  758804
  759116
  765185
  766385
  769417
  770874
  773255
  780930
  781907
  784520
  785479
  791501
  793370
  796730
  797639
  797846
  798643
  798763
  799399
  800926
  801353
  806071
  806201
  814851
  815751
  815758
  815823
  815840
  816392
  816951
  817278
  817878
  818354
  818854
  821902
  822637
  822657
  823278
  823292
  823358
  823473
  823563
]
2.13 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom shower bathroom"
]
1.83 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom shower ван"
]
1.78 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom shower ван"
]
1.58 ms
(0.88%)
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.