GET https://search.jues.net/search/embeds/4?q=sperm%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.39 ms
(87.96%)
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
  438046
  466670
  476365
  476564
  501280
  506555
  513057
  522674
  525734
  526337
  527602
  532286
  539006
  539347
  539473
  549299
  550911
  551099
  551221
  551826
  551881
  552587
  556093
  559655
  560164
  571770
  577052
  586989
  589728
  590606
  601948
  606114
  606220
  611413
  611954
  615650
  618005
  618955
  622283
  622547
  626824
  635569
  639116
  644850
  645446
  650937
  661381
  663836
  665067
  666708
  670526
  682956
  685523
  689266
  692402
  692433
  692824
  695674
  696685
  696701
  701628
  704387
  709452
  718600
  718703
  718764
  720474
  725441
  730665
  732584
  733983
  734261
  739347
  746476
  748346
  749374
  757026
  758305
  759313
  759817
  760199
  765802
  769019
  769118
  771406
  774350
  777636
  779324
  782133
  783781
  785103
  785346
  785930
  787308
  789051
  792757
  793973
  795984
  798857
  798940
  798989
  802122
  814715
  818742
  819083
  819438
  819452
  819455
  820515
  821140
  821168
  821438
  821564
  821571
  822274
  822634
  822890
  823157
  823343
  828425
]
12.16 ms
(6.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
  821168
  821564
  819438
  819452
  823157
  821140
  798857
  734261
  733983
  526337
  539347
  551826
  622547
  559655
  552587
  551221
  689266
  692824
  606114
  635569
  606220
  590606
  611413
  779324
  732584
  611954
  692433
  783781
  759817
  506555
  532286
  725441
  513057
  560164
  556093
  696685
  718703
  622283
  757026
  793973
  769118
  785103
  792757
  550911
  661381
  539006
  645446
  476365
  539473
  551099
  709452
  670526
  615650
  771406
  774350
  798940
  577052
  501280
  618005
  571770
  759313
  601948
  626824
  527602
  551881
  746476
  438046
  785346
  789051
  665067
  650937
  589728
  639116
  586989
  795984
  758305
  476564
  760199
  466670
  644850
  814715
  525734
  685523
  695674
  663836
  720474
  701628
  718600
  618955
  785930
  748346
  769019
  739347
  696701
  782133
  818742
  819083
  823343
  819455
  820515
  821438
  821571
  822274
  822634
  822890
  828425
  549299
  666708
  704387
  718764
  682956
  692402
  798989
  765802
  730665
  777636
  787308
  522674
  802122
  749374
]
2.66 ms
(1.52%)
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
  438046
  466670
  476365
  476564
  501280
  506555
  513057
  522674
  525734
  526337
  527602
  532286
  539006
  539347
  539473
  549299
  550911
  551099
  551221
  551826
  551881
  552587
  556093
  559655
  560164
  571770
  577052
  586989
  589728
  590606
  601948
  606114
  606220
  611413
  611954
  615650
  618005
  618955
  622283
  622547
  626824
  635569
  639116
  644850
  645446
  650937
  661381
  663836
  665067
  666708
  670526
  682956
  685523
  689266
  692402
  692433
  692824
  695674
  696685
  696701
  701628
  704387
  709452
  718600
  718703
  718764
  720474
  725441
  730665
  732584
  733983
  734261
  739347
  746476
  748346
  749374
  757026
  758305
  759313
  759817
  760199
  765802
  769019
  769118
  771406
  774350
  777636
  779324
  782133
  783781
  785103
  785346
  785930
  787308
  789051
  792757
  793973
  795984
  798857
  798940
  798989
  802122
  814715
  818742
  819083
  819438
  819452
  819455
  820515
  821140
  821168
  821438
  821564
  821571
  822274
  822634
  822890
  823157
  823343
  828425
]
1.75 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм на улиц"
]
1.65 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm public"
]
1.42 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.78%)
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.