GET https://search.jues.net/search/embeds/6?q=love%20sperm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.59 ms
(83.41%)
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
  79570
  260297
  358603
  382227
  387052
  400337
  410029
  427783
  433826
  437233
  437842
  438004
  438044
  438049
  450148
  454541
  460627
  469802
  469813
  471997
  474620
  488637
  493776
  496586
  503757
  538677
  553006
  563626
  565111
  584386
  588381
  589989
  601341
  603129
  606842
  607846
  609285
  614832
  614847
  615243
  625540
  626345
  626401
  631316
  633435
  637174
  642430
  644363
  661636
  668105
  670836
  679231
  680492
  681256
  681636
  685546
  689526
  689989
  696785
  698725
  702959
  710323
  710913
  716996
  718416
  718545
  722408
  725688
  726232
  727965
  728478
  728937
  730758
  732130
  732805
  733276
  733594
  734731
  734986
  741832
  742239
  742751
  742970
  742987
  745498
  746232
  752067
  752498
  755424
  756256
  763933
  764271
  764638
  765947
  767962
  769393
  770069
  772005
  774829
  777171
  778281
  782346
  783100
  783256
  784357
  787605
  791766
  792618
  794269
  795306
  801979
  807887
  813625
  817070
  817526
  817753
  819401
  821562
  823361
]
16.44 ms
(9.97%)
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
  746232
  752498
  769261
  787605
  792618
  772005
  742239
  767962
  756256
  733276
  734986
  765947
  769393
  609285
  698725
  710323
  718545
  777171
  783100
  400337
  469813
  433826
  469802
  387052
  488637
  438049
  668105
  696785
  642430
  778281
  784357
  807887
  770069
  722408
  813625
  493776
  496586
  681256
  670836
  679231
  680492
  689526
  745498
  752067
  742751
  730758
  728937
  732805
  763933
  783256
  437233
  382227
  438004
  437842
  454541
  474620
  538677
  553006
  565111
  661636
  588381
  614847
  626401
  637174
  589989
  603129
  626345
  733594
  614832
  260297
  438044
  633435
  358603
  79570
  410029
  817070
  817753
  819401
  821562
  823361
  817526
  471997
  450148
  460627
  503757
  563626
  584386
  718416
  681636
  685546
  689989
  710913
  702959
  615243
  606842
  625540
  631316
  601341
  607846
  795306
  774829
  794269
  734731
  801979
  727965
  732130
  742987
  726232
  755424
  764638
  725688
  741832
  728478
  742970
  764271
  644363
  716996
  782346
  791766
  427783
]
3.19 ms
(1.93%)
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
  79570
  260297
  358603
  382227
  387052
  400337
  410029
  427783
  433826
  437233
  437842
  438004
  438044
  438049
  450148
  454541
  460627
  469802
  469813
  471997
  474620
  488637
  493776
  496586
  503757
  538677
  553006
  563626
  565111
  584386
  588381
  589989
  601341
  603129
  606842
  607846
  609285
  614832
  614847
  615243
  625540
  626345
  626401
  631316
  633435
  637174
  642430
  644363
  661636
  668105
  670836
  679231
  680492
  681256
  681636
  685546
  689526
  689989
  696785
  698725
  702959
  710323
  710913
  716996
  718416
  718545
  722408
  725688
  726232
  727965
  728478
  728937
  730758
  732130
  732805
  733276
  733594
  734731
  734986
  741832
  742239
  742751
  742970
  742987
  745498
  746232
  752067
  752498
  755424
  756256
  763933
  764271
  764638
  765947
  767962
  769393
  770069
  772005
  774829
  777171
  778281
  782346
  783100
  783256
  784357
  787605
  791766
  792618
  794269
  795306
  801979
  807887
  813625
  817070
  817526
  817753
  819401
  821562
  823361
]
2.25 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love sperm"
]
2.00 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love сперм"
]
1.84 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love сперм"
]

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.