GET https://search.jues.net/search/embeds/7?q=doggy%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.69 ms
(87.23%)
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
  472888
  500310
  511424
  530128
  531605
  533602
  535136
  537630
  538042
  538749
  538919
  542278
  544462
  544638
  545043
  546296
  547077
  548116
  556091
  556146
  556952
  561265
  572671
  577654
  577734
  581845
  584697
  584966
  588063
  596574
  606212
  606521
  606524
  606539
  606843
  615291
  616178
  616534
  616571
  616671
  617492
  618074
  623183
  632418
  633427
  633929
  633945
  633974
  634039
  636605
  636995
  637028
  639078
  641488
  642596
  645213
  647915
  648279
  648393
  651243
  651355
  653737
  654221
  654973
  654974
  658245
  658638
  665939
  674136
  675636
  683932
  685933
  694861
  696248
  696407
  703428
  704114
  705306
  708125
  711268
  717219
  717955
  719915
  719941
  720780
  720826
  725757
  726264
  728718
  728750
  733571
  734996
  738241
  738391
  739720
  741064
  741682
  746470
  747058
  748118
  748395
  750133
  750277
  750303
  750884
  751857
  752956
  758321
  764448
  771071
  773857
  785710
  792804
  795967
  797385
  798279
  808298
  811658
  811996
  812877
]
11.52 ms
(6.76%)
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
  511424
  531605
  530128
  533602
  535136
  537630
  538042
  538749
  538919
  500310
  472888
  542278
  544462
  548116
  561265
  581845
  584966
  544638
  546296
  547077
  556091
  577734
  556146
  556952
  584697
  648279
  648393
  651243
  653737
  654974
  658638
  675636
  694861
  703428
  704114
  711268
  717955
  719915
  720780
  645213
  647915
  651355
  654221
  665939
  674136
  696407
  705306
  654973
  658245
  683932
  685933
  696248
  708125
  717219
  719941
  720826
  545043
  572671
  577654
  588063
  596574
  606212
  616178
  639078
  633929
  642596
  606521
  606539
  616571
  616671
  618074
  623183
  632418
  633427
  633974
  634039
  636995
  641488
  616534
  617492
  633945
  636605
  637028
  808298
  812877
  792804
  798279
  738241
  750277
  752956
  758321
  785710
  795967
  797385
  811658
  811996
  738391
  741682
  750884
  726264
  734996
  750133
  764448
  771071
  725757
  728718
  728750
  733571
  741064
  746470
  748118
  750303
  751857
  773857
  739720
  747058
  748395
  606524
  606843
  615291
]
3.01 ms
(1.77%)
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
  472888
  500310
  511424
  530128
  531605
  533602
  535136
  537630
  538042
  538749
  538919
  542278
  544462
  544638
  545043
  546296
  547077
  548116
  556091
  556146
  556952
  561265
  572671
  577654
  577734
  581845
  584697
  584966
  588063
  596574
  606212
  606521
  606524
  606539
  606843
  615291
  616178
  616534
  616571
  616671
  617492
  618074
  623183
  632418
  633427
  633929
  633945
  633974
  634039
  636605
  636995
  637028
  639078
  641488
  642596
  645213
  647915
  648279
  648393
  651243
  651355
  653737
  654221
  654973
  654974
  658245
  658638
  665939
  674136
  675636
  683932
  685933
  694861
  696248
  696407
  703428
  704114
  705306
  708125
  711268
  717219
  717955
  719915
  719941
  720780
  720826
  725757
  726264
  728718
  728750
  733571
  734996
  738241
  738391
  739720
  741064
  741682
  746470
  747058
  748118
  748395
  750133
  750277
  750303
  750884
  751857
  752956
  758321
  764448
  771071
  773857
  785710
  792804
  795967
  797385
  798279
  808298
  811658
  811996
  812877
]
2.22 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак межрасов"
]
1.87 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy interracial"
]
1.75 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак межрасов"
]
1.39 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.