GET https://search.jues.net/search/embeds/7?q=sperm%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.49 ms
(86.19%)
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
  396522
  398508
  398869
  401976
  402244
  408509
  412984
  418623
  419179
  419277
  423414
  423444
  424281
  424715
  428608
  429406
  429698
  430392
  432618
  435376
  435657
  436231
  441476
  441566
  450640
  454380
  460894
  461316
  462823
  463752
  465164
  465240
  465910
  466816
  468778
  469302
  472509
  476900
  478073
  478205
  478431
  478637
  480338
  491056
  495235
  499261
  499735
  502369
  504103
  508707
  512892
  520286
  522428
  523211
  526083
  526106
  528118
  528884
  539913
  541772
  549497
  555400
  562706
  564422
  566858
  577565
  577805
  581750
  582057
  592536
  594995
  596855
  597144
  602553
  604254
  605987
  609827
  611033
  614875
  617575
  653532
  662454
  682270
  684564
  694953
  696138
  715768
  734167
  744067
  745475
  761717
  765733
  765907
  769311
  770277
  772777
  777678
  781006
  782400
  787950
  788030
  791495
  791592
  791604
  792135
  793877
  794736
  794760
  795686
  798075
  800658
  800962
  801299
  802161
  802504
  807481
  807699
  808097
  810392
  817729
]
12.98 ms
(8.02%)
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
  798075
  810392
  396522
  696138
  800962
  808097
  744067
  430392
  429698
  468778
  526083
  684564
  793877
  807699
  777678
  792135
  807481
  782400
  469302
  480338
  398508
  817729
  564422
  769311
  794760
  460894
  402244
  461316
  478205
  512892
  566858
  611033
  802504
  734167
  526106
  522428
  539913
  549497
  614875
  541772
  401976
  418623
  419179
  466816
  592536
  594995
  791495
  795686
  787950
  435376
  435657
  436231
  398869
  478637
  478073
  504103
  577805
  423414
  802161
  412984
  441566
  424281
  429406
  454380
  476900
  715768
  617575
  781006
  800658
  788030
  791592
  794736
  772777
  765907
  770277
  801299
  478431
  502369
  495235
  597144
  582057
  428608
  653532
  596855
  424715
  528118
  508707
  520286
  662454
  682270
  609827
  602553
  745475
  528884
  605987
  408509
  463752
  604254
  791604
  765733
  465240
  462823
  465164
  491056
  465910
  577565
  694953
  562706
  761717
  432618
  450640
  419277
  423444
  441476
  472509
  523211
  499735
  499261
  555400
  581750
]
2.92 ms
(1.80%)
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
  396522
  398508
  398869
  401976
  402244
  408509
  412984
  418623
  419179
  419277
  423414
  423444
  424281
  424715
  428608
  429406
  429698
  430392
  432618
  435376
  435657
  436231
  441476
  441566
  450640
  454380
  460894
  461316
  462823
  463752
  465164
  465240
  465910
  466816
  468778
  469302
  472509
  476900
  478073
  478205
  478431
  478637
  480338
  491056
  495235
  499261
  499735
  502369
  504103
  508707
  512892
  520286
  522428
  523211
  526083
  526106
  528118
  528884
  539913
  541772
  549497
  555400
  562706
  564422
  566858
  577565
  577805
  581750
  582057
  592536
  594995
  596855
  597144
  602553
  604254
  605987
  609827
  611033
  614875
  617575
  653532
  662454
  682270
  684564
  694953
  696138
  715768
  734167
  744067
  745475
  761717
  765733
  765907
  769311
  770277
  772777
  777678
  781006
  782400
  787950
  788030
  791495
  791592
  791604
  792135
  793877
  794736
  794760
  795686
  798075
  800658
  800962
  801299
  802161
  802504
  807481
  807699
  808097
  810392
  817729
]
1.71 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm sex"
]
1.70 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм секс"
]
1.54 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.92%)
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.