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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.77 ms
(82.05%)
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
  31134
  181096
  233941
  275759
  370905
  383354
  388555
  389657
  397510
  398965
  401201
  411009
  423809
  425510
  428362
  434306
  443402
  443690
  446792
  450184
  456030
  456867
  457097
  457119
  460161
  460404
  464410
  465076
  465349
  466350
  466492
  467085
  471058
  471060
  472698
  473400
  475023
  475656
  477548
  478516
  478897
  489924
  490514
  490595
  491436
  499842
  499919
  500689
  502062
  504005
  506835
  507616
  512223
  512513
  519753
  528540
  535345
  538861
  538908
  541479
  549877
  554459
  556782
  559408
  559430
  564480
  568752
  573250
  578010
  587961
  599354
  599566
  607345
  609071
  610209
  612237
  615145
  618228
  634758
  693987
  694192
  710063
  712026
  719139
  724514
  726848
  728980
  742276
  753738
  756487
  756494
  759731
  760175
  768121
  770038
  771409
  780262
  793516
  793535
  793670
  794400
  794427
  801750
  803055
  804265
  808671
  810014
  810594
  811917
  813575
  818502
  818822
  820749
  823862
  824735
  825063
  825892
  826393
  826602
]
16.74 ms
(11.10%)
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
  693987
  712026
  519753
  506835
  587961
  425510
  500689
  512223
  275759
  772079
  465349
  491436
  490595
  398965
  578010
  472698
  554459
  599354
  759731
  490514
  825063
  538908
  634758
  726848
  793516
  810014
  770038
  724514
  753738
  760175
  756494
  389657
  825892
  823862
  818822
  818502
  801750
  768121
  401201
  457119
  478897
  467085
  471060
  478516
  370905
  233941
  181096
  813575
  820749
  826393
  538861
  573250
  811917
  810594
  794427
  771409
  794400
  824735
  489924
  456867
  475023
  397510
  464410
  793670
  808671
  443690
  383354
  460161
  446792
  528540
  499919
  694192
  610209
  756487
  742276
  804265
  460404
  443402
  559430
  473400
  388555
  793535
  618228
  780262
  477548
  535345
  541479
  612237
  456030
  507616
  31134
  499842
  559408
  710063
  728980
  502062
  568752
  556782
  607345
  434306
  423809
  411009
  471058
  465076
  504005
  719139
  457097
  428362
  475656
  549877
  803055
  615145
  450184
  512513
  609071
  466350
  466492
  564480
  826602
  599566
]
2.59 ms
(1.72%)
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
  31134
  181096
  233941
  275759
  370905
  383354
  388555
  389657
  397510
  398965
  401201
  411009
  423809
  425510
  428362
  434306
  443402
  443690
  446792
  450184
  456030
  456867
  457097
  457119
  460161
  460404
  464410
  465076
  465349
  466350
  466492
  467085
  471058
  471060
  472698
  473400
  475023
  475656
  477548
  478516
  478897
  489924
  490514
  490595
  491436
  499842
  499919
  500689
  502062
  504005
  506835
  507616
  512223
  512513
  519753
  528540
  535345
  538861
  538908
  541479
  549877
  554459
  556782
  559408
  559430
  564480
  568752
  573250
  578010
  587961
  599354
  599566
  607345
  609071
  610209
  612237
  615145
  618228
  634758
  693987
  694192
  710063
  712026
  719139
  724514
  726848
  728980
  742276
  753738
  756487
  756494
  759731
  760175
  768121
  770038
  771409
  780262
  793516
  793535
  793670
  794400
  794427
  801750
  803055
  804265
  808671
  810014
  810594
  811917
  813575
  818502
  818822
  820749
  823862
  824735
  825063
  825892
  826393
  826602
]
2.29 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy milf tits"
]
2.09 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая milf сиськ"
]
1.72 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая milf сиськ"
]

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.