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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.04 ms
(88.18%)
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
  426006
  429544
  433558
  433610
  437878
  457119
  458163
  476562
  490125
  490675
  502810
  512869
  517439
  532971
  534255
  536062
  540256
  550019
  552019
  553436
  554712
  557228
  561731
  564650
  564794
  572172
  573224
  581401
  587108
  592391
  595690
  595964
  596041
  600373
  610115
  626889
  628561
  630767
  631137
  647030
  661901
  661969
  663339
  666719
  680934
  682134
  683524
  684233
  684251
  686093
  692331
  692744
  694193
  694925
  699383
  709577
  715472
  716401
  719139
  720333
  721775
  722142
  729038
  729118
  730272
  732093
  733227
  734753
  738278
  742803
  743119
  743641
  744311
  750061
  752914
  753212
  754954
  755045
  756000
  759153
  768072
  771698
  772124
  772882
  775464
  776412
  782322
  783350
  785817
  788640
  794937
  795059
  797795
  797847
  797927
  802433
  802824
  803083
  804101
  804269
  804391
  805385
  807024
  807336
  807705
  808250
  810369
  812235
  814036
  814378
  814404
  815398
  817789
  818464
  820019
  823946
  824403
  825308
  825468
  826597
]
10.11 ms
(6.23%)
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
  595964
  807024
  775464
  729118
  732093
  743119
  797847
  803083
  808250
  734753
  738278
  755045
  730272
  742803
  744311
  768072
  771698
  754954
  709577
  776412
  788640
  794937
  797795
  804391
  814378
  694925
  550019
  772124
  750061
  561731
  512869
  666719
  517439
  433610
  581401
  437878
  429544
  457119
  564650
  719139
  433558
  458163
  490675
  426006
  814404
  532971
  536062
  534255
  661969
  595690
  631137
  628561
  600373
  807336
  756000
  733227
  743641
  814036
  820019
  824403
  825468
  826597
  817789
  823946
  825308
  815398
  818464
  490125
  476562
  540256
  502810
  553436
  564794
  552019
  557228
  573224
  663339
  680934
  686093
  694193
  699383
  715472
  716401
  684233
  692744
  721775
  722142
  647030
  661901
  682134
  683524
  684251
  692331
  720333
  554712
  572172
  592391
  596041
  610115
  587108
  626889
  630767
  785817
  795059
  797927
  782322
  802824
  804269
  752914
  753212
  759153
  772882
  783350
  802433
  804101
  805385
  807705
  810369
  812235
  729038
]
2.50 ms
(1.54%)
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
  426006
  429544
  433558
  433610
  437878
  457119
  458163
  476562
  490125
  490675
  502810
  512869
  517439
  532971
  534255
  536062
  540256
  550019
  552019
  553436
  554712
  557228
  561731
  564650
  564794
  572172
  573224
  581401
  587108
  592391
  595690
  595964
  596041
  600373
  610115
  626889
  628561
  630767
  631137
  647030
  661901
  661969
  663339
  666719
  680934
  682134
  683524
  684233
  684251
  686093
  692331
  692744
  694193
  694925
  699383
  709577
  715472
  716401
  719139
  720333
  721775
  722142
  729038
  729118
  730272
  732093
  733227
  734753
  738278
  742803
  743119
  743641
  744311
  750061
  752914
  753212
  754954
  755045
  756000
  759153
  768072
  771698
  772124
  772882
  775464
  776412
  782322
  783350
  785817
  788640
  794937
  795059
  797795
  797847
  797927
  802433
  802824
  803083
  804101
  804269
  804391
  805385
  807024
  807336
  807705
  808250
  810369
  812235
  814036
  814378
  814404
  815398
  817789
  818464
  820019
  823946
  824403
  825308
  825468
  826597
]
1.77 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long hairy pussy"
]
1.70 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные волосатая pussy"
]
1.56 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные волосатая 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.