GET https://search.jues.net/search/embeds/5?q=sperm%20in%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.27 ms
(89.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
  392952
  417471
  434767
  449541
  459629
  465720
  480889
  481216
  485723
  487934
  489305
  493779
  495572
  497752
  499536
  500959
  503504
  507092
  509167
  514041
  514304
  517083
  520115
  520274
  520301
  521940
  522300
  522721
  526959
  532318
  534341
  537452
  539473
  540587
  543080
  543171
  543764
  544047
  545189
  545211
  546054
  546335
  546552
  546905
  547813
  554403
  556199
  557772
  559015
  559621
  561300
  561580
  561864
  562974
  563274
  563301
  565784
  566948
  567646
  567947
  570838
  570975
  571338
  571727
  574975
  576134
  576654
  577514
  578108
  578551
  578569
  579223
  579443
  580126
  580662
  582031
  585719
  587118
  587523
  588024
  588381
  588679
  588941
  590673
  590937
  591185
  592429
  592686
  594442
  596409
  596416
  599710
  600747
  601300
  602457
  602714
  604924
  606514
  608415
  614381
  616551
  619762
  619865
  622453
  624659
  629580
  636230
  638894
  651876
  662449
  663740
  668622
  670088
  672343
  684122
  684447
  690928
  716364
  730758
  788837
]
15.76 ms
(6.65%)
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
  547813
  670088
  668622
  561300
  570975
  578108
  590937
  592686
  601300
  608415
  596409
  663740
  520301
  565784
  588024
  588679
  590673
  499536
  522300
  434767
  534341
  546054
  480889
  509167
  522721
  526959
  545211
  546552
  571338
  582031
  546335
  561580
  579443
  672343
  624659
  730758
  449541
  514041
  417471
  559015
  544047
  716364
  571727
  587523
  592429
  636230
  578551
  465720
  514304
  517083
  539473
  537452
  495572
  567947
  576654
  577514
  545189
  580662
  557772
  570838
  599710
  602714
  614381
  616551
  788837
  459629
  651876
  690928
  585719
  591185
  619762
  596416
  563274
  489305
  500959
  520115
  520274
  503504
  507092
  532318
  543171
  546905
  559621
  562974
  566948
  574975
  576134
  580126
  554403
  556199
  561864
  579223
  662449
  684122
  588381
  588941
  594442
  602457
  604924
  587118
  600747
  638894
  606514
  619865
  622453
  497752
  629580
  684447
  392952
  487934
  481216
  493779
  485723
  540587
  521940
  563301
  567646
  578569
  543080
  543764
]
2.39 ms
(1.01%)
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
  392952
  417471
  434767
  449541
  459629
  465720
  480889
  481216
  485723
  487934
  489305
  493779
  495572
  497752
  499536
  500959
  503504
  507092
  509167
  514041
  514304
  517083
  520115
  520274
  520301
  521940
  522300
  522721
  526959
  532318
  534341
  537452
  539473
  540587
  543080
  543171
  543764
  544047
  545189
  545211
  546054
  546335
  546552
  546905
  547813
  554403
  556199
  557772
  559015
  559621
  561300
  561580
  561864
  562974
  563274
  563301
  565784
  566948
  567646
  567947
  570838
  570975
  571338
  571727
  574975
  576134
  576654
  577514
  578108
  578551
  578569
  579223
  579443
  580126
  580662
  582031
  585719
  587118
  587523
  588024
  588381
  588679
  588941
  590673
  590937
  591185
  592429
  592686
  594442
  596409
  596416
  599710
  600747
  601300
  602457
  602714
  604924
  606514
  608415
  614381
  616551
  619762
  619865
  622453
  624659
  629580
  636230
  638894
  651876
  662449
  663740
  668622
  670088
  672343
  684122
  684447
  690928
  716364
  730758
  788837
]
2.08 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm in ass"
]
1.99 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм жоп"
]
1.71 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм жоп"
]
1.66 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.