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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.66 ms
(84.44%)
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
  382263
  462182
  482335
  494849
  537401
  537666
  541573
  542091
  549195
  555411
  569517
  574382
  582469
  593250
  627567
  629637
  629780
  632754
  636438
  648655
  650095
  655602
  671472
  674101
  701451
  703814
  710478
  710817
  715530
  716611
  718349
  726097
  726408
  727327
  727562
  728457
  729863
  730686
  732598
  740072
  744221
  744720
  745610
  747946
  752176
  753428
  754161
  755166
  756947
  758029
  759812
  760340
  760426
  761400
  761438
  761681
  763036
  763558
  763704
  765036
  766483
  766493
  766518
  772168
  772357
  772836
  775518
  777521
  779048
  779829
  780245
  781408
  781555
  782326
  782838
  783090
  783294
  785085
  786030
  787150
  787216
  787796
  788091
  791017
  791049
  791474
  791494
  791965
  792519
  794976
  797745
  800534
  802069
  802608
  802638
  803435
  804517
  804910
  806731
  807302
  808071
  808256
  809235
  811443
  813897
  814283
  817175
  817757
  817758
  818029
  819300
  819714
  819966
  823255
  823256
  825977
  826006
]
11.99 ms
(8.19%)
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
  817757
  818029
  823255
  823256
  825977
  817175
  826006
  817758
  819300
  819714
  819966
  549195
  674101
  710478
  716611
  718349
  629780
  787796
  753428
  760340
  792519
  758029
  763704
  732598
  761400
  794976
  807302
  710817
  593250
  811443
  772836
  783090
  788091
  791474
  772357
  727327
  744720
  791494
  814283
  752176
  759812
  791049
  813897
  482335
  462182
  537401
  494849
  574382
  541573
  542091
  555411
  569517
  650095
  715530
  703814
  648655
  632754
  636438
  629637
  627567
  779829
  802069
  804517
  808071
  780245
  786030
  791017
  791965
  800534
  802608
  803435
  804910
  740072
  744221
  754161
  755166
  763036
  766493
  766518
  773517
  781324
  781408
  782326
  782838
  786930
  787150
  797745
  806731
  726097
  756947
  766483
  726408
  727562
  745610
  730686
  747946
  760426
  763558
  728457
  761438
  761681
  765036
  772168
  701451
  775518
  777521
  779048
  781555
  783294
  785085
  787216
  802638
  809235
  382263
  537666
  582469
  671472
  655602
  808256
  729863
]
2.55 ms
(1.74%)
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
  382263
  462182
  482335
  494849
  537401
  537666
  541573
  542091
  549195
  555411
  569517
  574382
  582469
  593250
  627567
  629637
  629780
  632754
  636438
  648655
  650095
  655602
  671472
  674101
  701451
  703814
  710478
  710817
  715530
  716611
  718349
  726097
  726408
  727327
  727562
  728457
  729863
  730686
  732598
  740072
  744221
  744720
  745610
  747946
  752176
  753428
  754161
  755166
  756947
  758029
  759812
  760340
  760426
  761400
  761438
  761681
  763036
  763558
  763704
  765036
  766483
  766493
  766518
  772168
  772357
  772836
  775518
  777521
  779048
  779829
  780245
  781408
  781555
  782326
  782838
  783090
  783294
  785085
  786030
  787150
  787216
  787796
  788091
  791017
  791049
  791474
  791494
  791965
  792519
  794976
  797745
  800534
  802069
  802608
  802638
  803435
  804517
  804910
  806731
  807302
  808071
  808256
  809235
  811443
  813897
  814283
  817175
  817757
  817758
  818029
  819300
  819714
  819966
  823255
  823256
  825977
  826006
]
2.54 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm of face"
]
2.31 ms
(1.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм face"
]
1.73 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм face"
]

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.