GET https://search.jues.net/search/embeds/3?q=anus%20hairy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.24 ms
(83.98%)
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
  202134
  388411
  391984
  395682
  396670
  400043
  400956
  401262
  403229
  404777
  405485
  407878
  410230
  411045
  413233
  419320
  419835
  420219
  421249
  424414
  424614
  427115
  428775
  436719
  443199
  443333
  443894
  443953
  444306
  445433
  445825
  447257
  448871
  450371
  451832
  454813
  456219
  457701
  459997
  460631
  461322
  462799
  462868
  465302
  467885
  468061
  469084
  470565
  471149
  472216
  473774
  474496
  475056
  475760
  476932
  478437
  485715
  486192
  488370
  492192
  493754
  497691
  498226
  499904
  500580
  500915
  501317
  502089
  503836
  505804
  505805
  509821
  511345
  511387
  511819
  512882
  518587
  518763
  526077
  526089
  526504
  528275
  531804
  533594
  533922
  535384
  541248
  542502
  543496
  547241
  549228
  552687
  555054
  555329
  555372
  555407
  555413
  555752
  556791
  562825
  565308
  576214
  579341
  583501
  583541
  583866
  591091
  596321
  597160
  613004
  618619
  648056
  658773
  661915
  668385
  671650
  687838
  715368
  789691
  791550
]
18.51 ms
(9.95%)
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
  460631
  472216
  473774
  474496
  476932
  493754
  500580
  505805
  518763
  533594
  533922
  512882
  535384
  526089
  552687
  555407
  556791
  555372
  648056
  658773
  715368
  671650
  687838
  613004
  591091
  789691
  403229
  467885
  388411
  400956
  419835
  424414
  443894
  462868
  457701
  475760
  509821
  503836
  528275
  486192
  501317
  562825
  405485
  419320
  459997
  488370
  475056
  565308
  443953
  395682
  396670
  579341
  543496
  547241
  555054
  451832
  511345
  498226
  444306
  202134
  400043
  401262
  404777
  410230
  421249
  424614
  428775
  407878
  420219
  443199
  411045
  413233
  436719
  443333
  445825
  447257
  450371
  454813
  461322
  469084
  492192
  456219
  478437
  448871
  462799
  470565
  485715
  499904
  511387
  511819
  518587
  526077
  502089
  505804
  526504
  497691
  500915
  531804
  465302
  468061
  549228
  555413
  541248
  542502
  583501
  583866
  555329
  555752
  583541
  661915
  668385
  576214
  597160
  596321
  618619
  791550
  391984
  427115
  445433
  471149
]
3.52 ms
(1.89%)
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
  202134
  388411
  391984
  395682
  396670
  400043
  400956
  401262
  403229
  404777
  405485
  407878
  410230
  411045
  413233
  419320
  419835
  420219
  421249
  424414
  424614
  427115
  428775
  436719
  443199
  443333
  443894
  443953
  444306
  445433
  445825
  447257
  448871
  450371
  451832
  454813
  456219
  457701
  459997
  460631
  461322
  462799
  462868
  465302
  467885
  468061
  469084
  470565
  471149
  472216
  473774
  474496
  475056
  475760
  476932
  478437
  485715
  486192
  488370
  492192
  493754
  497691
  498226
  499904
  500580
  500915
  501317
  502089
  503836
  505804
  505805
  509821
  511345
  511387
  511819
  512882
  518587
  518763
  526077
  526089
  526504
  528275
  531804
  533594
  533922
  535384
  541248
  542502
  543496
  547241
  549228
  552687
  555054
  555329
  555372
  555407
  555413
  555752
  556791
  562825
  565308
  576214
  579341
  583501
  583541
  583866
  591091
  596321
  597160
  613004
  618619
  648056
  658773
  661915
  668385
  671650
  687838
  715368
  789691
  791550
]
2.02 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anus hairy"
]
1.89 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анус волосатая"
]
1.88 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.