GET https://search.jues.net/search/embeds/6?q=hairy%20cock

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.16 ms
(81.88%)
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
  6643
  33236
  109043
  383547
  385538
  387241
  390082
  390493
  390702
  391134
  393077
  395527
  398166
  398212
  401881
  403109
  406521
  407586
  408578
  411630
  411769
  411910
  411951
  423177
  426250
  427264
  429592
  429936
  430244
  444739
  445730
  448403
  449097
  451797
  456875
  458301
  462233
  466918
  468484
  474078
  474691
  475864
  476155
  476306
  483792
  490825
  493228
  496458
  500698
  502033
  508705
  510894
  512227
  516076
  516125
  517439
  524901
  525742
  549247
  552898
  559405
  563776
  565931
  578174
  584921
  588900
  596523
  596967
  599737
  612160
  612298
  614847
  615964
  617575
  619573
  642126
  646807
  649952
  650977
  660769
  665224
  665294
  665416
  666080
  667222
  670952
  677360
  677371
  691607
  694192
  697302
  701416
  707605
  714032
  714934
  718558
  719102
  719205
  724520
  724696
  724762
  729972
  732169
  733342
  734278
  739060
  739955
  740512
  742269
  743769
  746632
  750072
  759015
  789269
  795812
  802382
  818134
  819396
  819988
  825140
]
15.58 ms
(10.89%)
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
  584921
  563776
  665416
  707605
  719102
  649952
  665224
  666080
  670952
  677360
  677371
  694192
  665294
  718558
  559405
  578174
  614847
  588900
  596523
  599737
  612160
  619573
  596967
  617575
  642126
  802382
  789269
  724696
  729972
  732169
  733342
  739060
  724520
  724762
  740512
  739955
  750072
  759015
  615964
  795812
  109043
  474078
  391134
  398212
  408578
  429936
  458301
  387241
  390493
  411769
  406521
  476155
  508705
  516125
  510894
  500698
  516076
  660769
  719205
  734278
  650977
  525742
  667222
  411630
  517439
  493228
  502033
  549247
  565931
  393077
  395527
  818134
  383547
  444739
  445730
  449097
  33236
  398166
  411951
  819396
  825140
  483792
  691607
  612298
  6643
  427264
  646807
  697302
  742269
  743769
  819988
  701416
  714032
  714934
  746632
  385538
  390702
  390082
  401881
  403109
  411910
  423177
  426250
  407586
  429592
  430244
  552898
  448403
  468484
  476306
  451797
  456875
  474691
  462233
  466918
  475864
  490825
  512227
  496458
  524901
]
3.15 ms
(2.20%)
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
  6643
  33236
  109043
  383547
  385538
  387241
  390082
  390493
  390702
  391134
  393077
  395527
  398166
  398212
  401881
  403109
  406521
  407586
  408578
  411630
  411769
  411910
  411951
  423177
  426250
  427264
  429592
  429936
  430244
  444739
  445730
  448403
  449097
  451797
  456875
  458301
  462233
  466918
  468484
  474078
  474691
  475864
  476155
  476306
  483792
  490825
  493228
  496458
  500698
  502033
  508705
  510894
  512227
  516076
  516125
  517439
  524901
  525742
  549247
  552898
  559405
  563776
  565931
  578174
  584921
  588900
  596523
  596967
  599737
  612160
  612298
  614847
  615964
  617575
  619573
  642126
  646807
  649952
  650977
  660769
  665224
  665294
  665416
  666080
  667222
  670952
  677360
  677371
  691607
  694192
  697302
  701416
  707605
  714032
  714934
  718558
  719102
  719205
  724520
  724696
  724762
  729972
  732169
  733342
  734278
  739060
  739955
  740512
  742269
  743769
  746632
  750072
  759015
  789269
  795812
  802382
  818134
  819396
  819988
  825140
]
2.06 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая cock"
]
1.81 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy cock"
]
1.79 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая cock"
]

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.