GET https://search.jues.net/search/embeds/5?q=sperm%20to%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.29 ms
(87.90%)
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
  398588
  456276
  510348
  529608
  548511
  575627
  629518
  633009
  634619
  636475
  649773
  675167
  689425
  692433
  697724
  697733
  701425
  705746
  707583
  709346
  710930
  714745
  718853
  719087
  721996
  722117
  722151
  722165
  723138
  723216
  724798
  726316
  726356
  728711
  728832
  728834
  728920
  728936
  729255
  731218
  731441
  733096
  733196
  733386
  735769
  738222
  739592
  741184
  741390
  743364
  743846
  744417
  747010
  749913
  753641
  755184
  756296
  761546
  763223
  763370
  763776
  765117
  765369
  767721
  768151
  770026
  772357
  772376
  773375
  773378
  773502
  777489
  777564
  777817
  778079
  778094
  778153
  778753
  779045
  779403
  779410
  781553
  783726
  784685
  787040
  787230
  787232
  787430
  787694
  789755
  790252
  793929
  795796
  795975
  796001
  796032
  796051
  797208
  798937
  800757
  800918
  803692
  805010
  814050
  817175
  819332
  819892
  823876
  824001
  825218
  825364
  825977
  826634
  826907
  827141
  827407
  827690
]
10.70 ms
(5.98%)
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
  781553
  793929
  795796
  795975
  796001
  797208
  800918
  803692
  741390
  747010
  753641
  765117
  770026
  772376
  726316
  726356
  728920
  733196
  733386
  735769
  743846
  756296
  728711
  729255
  739592
  743364
  765369
  724798
  728832
  728834
  728936
  731218
  731441
  733096
  741184
  749913
  763370
  763776
  767721
  768151
  773375
  773378
  773502
  633009
  697724
  697733
  709346
  710930
  714745
  719087
  721996
  722117
  722151
  723216
  777489
  777564
  777817
  784685
  787230
  787232
  787316
  787430
  790252
  796032
  798937
  800757
  456276
  575627
  689425
  705746
  649773
  636475
  779045
  778079
  778153
  789755
  796051
  805010
  738222
  744417
  766177
  763223
  772357
  761546
  778094
  783726
  787040
  510348
  814050
  529608
  675167
  755184
  398588
  819892
  825218
  825364
  825977
  826634
  824001
  823876
  817175
  826907
  827141
  816149
  819332
  827407
  827690
  548511
  692433
  722165
  701425
  707583
  718853
  723138
  629518
  634619
  778753
  779403
  779410
  787694
]
3.83 ms
(2.14%)
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
  398588
  456276
  510348
  529608
  548511
  575627
  629518
  633009
  634619
  636475
  649773
  675167
  689425
  692433
  697724
  697733
  701425
  705746
  707583
  709346
  710930
  714745
  718853
  719087
  721996
  722117
  722151
  722165
  723138
  723216
  724798
  726316
  726356
  728711
  728832
  728834
  728920
  728936
  729255
  731218
  731441
  733096
  733196
  733386
  735769
  738222
  739592
  741184
  741390
  743364
  743846
  744417
  747010
  749913
  753641
  755184
  756296
  761546
  763223
  763370
  763776
  765117
  765369
  767721
  768151
  770026
  772357
  772376
  773375
  773378
  773502
  777489
  777564
  777817
  778079
  778094
  778153
  778753
  779045
  779403
  779410
  781553
  783726
  784685
  787040
  787230
  787232
  787430
  787694
  789755
  790252
  793929
  795796
  795975
  796001
  796032
  796051
  797208
  798937
  800757
  800918
  803692
  805010
  814050
  817175
  819332
  819892
  823876
  824001
  825218
  825364
  825977
  826634
  826907
  827141
  827407
  827690
]
1.99 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm to mouth"
]
1.88 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм mouth"
]
1.69 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм mouth"
]

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.