GET https://search.jues.net/search/embeds/3?q=doggystyle%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.30 ms
(82.46%)
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
  393298
  400450
  407780
  415829
  415836
  418112
  418714
  443492
  444732
  445747
  447941
  448398
  448504
  449270
  449511
  451094
  455824
  456153
  456834
  457805
  457915
  458473
  459261
  459959
  462422
  463460
  464642
  465770
  466799
  468806
  473349
  476441
  478220
  480331
  480350
  483188
  484544
  484792
  488013
  489322
  489756
  490515
  490707
  491680
  494725
  496687
  496822
  498086
  499514
  505061
  506876
  508711
  510729
  512487
  517565
  520641
  521591
  525215
  528879
  528897
  530103
  538773
  539483
  541807
  543254
  543828
  548153
  558075
  559897
  564928
  564984
  564988
  566331
  568915
  569139
  569993
  571809
  579648
  587049
  588760
  592263
  592904
  594557
  610322
  612121
  619009
  622294
  626471
  637247
  639666
  644056
  650518
  675104
  675107
  675127
  675431
  676423
  680443
  681237
  684695
  686977
  702040
  713701
  714487
  720424
  720459
  730359
  741805
  744329
  746093
  746171
  752609
  756165
  764761
  769013
  787214
  788952
  805332
  807392
  813242
]
17.45 ms
(10.72%)
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
  463460
  488013
  449511
  462422
  499514
  539483
  508711
  505061
  496687
  530103
  490707
  543828
  564928
  569993
  650518
  681237
  684695
  686977
  680443
  702040
  720459
  622294
  594557
  610322
  619009
  626471
  639666
  807392
  813242
  787214
  805332
  756165
  746093
  746171
  769013
  455824
  400450
  459959
  466799
  456153
  445747
  448398
  457805
  458473
  510729
  489756
  525215
  498086
  675431
  444732
  476441
  483188
  490515
  456834
  465770
  457915
  459261
  528897
  538773
  506876
  464642
  489322
  564984
  566331
  564988
  548153
  713701
  714487
  675127
  558075
  568915
  637247
  588760
  592904
  752609
  730359
  741805
  449270
  415829
  480331
  468806
  478220
  512487
  496822
  520641
  484792
  415836
  571809
  393298
  418112
  407780
  443492
  451094
  484544
  491680
  521591
  494725
  517565
  528879
  473349
  579648
  541807
  543254
  569139
  675107
  676423
  675104
  720424
  559897
  587049
  592263
  612121
  788952
  744329
  764761
  644056
  447941
  448504
  480350
  418714
]
3.52 ms
(2.16%)
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
  393298
  400450
  407780
  415829
  415836
  418112
  418714
  443492
  444732
  445747
  447941
  448398
  448504
  449270
  449511
  451094
  455824
  456153
  456834
  457805
  457915
  458473
  459261
  459959
  462422
  463460
  464642
  465770
  466799
  468806
  473349
  476441
  478220
  480331
  480350
  483188
  484544
  484792
  488013
  489322
  489756
  490515
  490707
  491680
  494725
  496687
  496822
  498086
  499514
  505061
  506876
  508711
  510729
  512487
  517565
  520641
  521591
  525215
  528879
  528897
  530103
  538773
  539483
  541807
  543254
  543828
  548153
  558075
  559897
  564928
  564984
  564988
  566331
  568915
  569139
  569993
  571809
  579648
  587049
  588760
  592263
  592904
  594557
  610322
  612121
  619009
  622294
  626471
  637247
  639666
  644056
  650518
  675104
  675107
  675127
  675431
  676423
  680443
  681237
  684695
  686977
  702040
  713701
  714487
  720424
  720459
  730359
  741805
  744329
  746093
  746171
  752609
  756165
  764761
  769013
  787214
  788952
  805332
  807392
  813242
]
2.07 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle pussy"
]
1.96 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle pussy"
]
1.84 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle pussy"
]

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.