GET https://search.jues.net/search/embeds/3?q=hairy%20sperm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.68 ms
(84.21%)
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
  385313
  386042
  415956
  424715
  425759
  485673
  486613
  505936
  506507
  512211
  529337
  530973
  538040
  538184
  539658
  550358
  555198
  555229
  555248
  555275
  555299
  555408
  557719
  563779
  576237
  576766
  589691
  593066
  607763
  612622
  617393
  623137
  624466
  624791
  626772
  627232
  629740
  635387
  637938
  639480
  647065
  648017
  648273
  650723
  658140
  664737
  676677
  677529
  689225
  694987
  695001
  696127
  696133
  696268
  701059
  703709
  703750
  703762
  703772
  703783
  705966
  707119
  707600
  708683
  709936
  710431
  710939
  713063
  714032
  714361
  714407
  714934
  715349
  718626
  721938
  722049
  722145
  722167
  728148
  728953
  728992
  729050
  729051
  730326
  732968
  733479
  733509
  739895
  740541
  740666
  742785
  742827
  745895
  747251
  752140
  760191
  761515
  771561
  771873
  775649
  790201
  794401
  795067
  795898
  798761
  800351
  809999
  815435
  817909
  819612
  822706
  823600
  823723
  824125
  824154
  824696
  824777
  824948
  826651
  826923
]
14.07 ms
(9.43%)
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
  386042
  485673
  714361
  385313
  425759
  823723
  826923
  824154
  512211
  555275
  555198
  703750
  708683
  696127
  629740
  637938
  607763
  794401
  733509
  728992
  742827
  745895
  539658
  538040
  576237
  557719
  576766
  650723
  715349
  648273
  648017
  703772
  589691
  627232
  639480
  795898
  728148
  729050
  739895
  747251
  728953
  771561
  771873
  703709
  714407
  721938
  790201
  817909
  822706
  823600
  824948
  824125
  824696
  815435
  819612
  824777
  529337
  555248
  694987
  696268
  714032
  658140
  705966
  714934
  555299
  593066
  623137
  626772
  798761
  795067
  730326
  809999
  732968
  760191
  742785
  722145
  775649
  415956
  486613
  424715
  826651
  563779
  701059
  713063
  676677
  707600
  710431
  722167
  612622
  624466
  624791
  729051
  740541
  752140
  733479
  740666
  617393
  703783
  506507
  710939
  664737
  689225
  635387
  761515
  800351
  505936
  538184
  530973
  555229
  555408
  550358
  677529
  647065
  695001
  707119
  722049
  696133
  703762
  709936
  718626
]
2.80 ms
(1.87%)
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
  385313
  386042
  415956
  424715
  425759
  485673
  486613
  505936
  506507
  512211
  529337
  530973
  538040
  538184
  539658
  550358
  555198
  555229
  555248
  555275
  555299
  555408
  557719
  563779
  576237
  576766
  589691
  593066
  607763
  612622
  617393
  623137
  624466
  624791
  626772
  627232
  629740
  635387
  637938
  639480
  647065
  648017
  648273
  650723
  658140
  664737
  676677
  677529
  689225
  694987
  695001
  696127
  696133
  696268
  701059
  703709
  703750
  703762
  703772
  703783
  705966
  707119
  707600
  708683
  709936
  710431
  710939
  713063
  714032
  714361
  714407
  714934
  715349
  718626
  721938
  722049
  722145
  722167
  728148
  728953
  728992
  729050
  729051
  730326
  732968
  733479
  733509
  739895
  740541
  740666
  742785
  742827
  745895
  747251
  752140
  760191
  761515
  771561
  771873
  775649
  790201
  794401
  795067
  795898
  798761
  800351
  809999
  815435
  817909
  819612
  822706
  823600
  823723
  824125
  824154
  824696
  824777
  824948
  826651
  826923
]
2.07 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy sperm"
]
1.72 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая сперм"
]
1.28 ms
(0.86%)
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.