GET https://search.jues.net/search/embeds/9?q=big%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.34 ms
(35.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие межрасов"
]
205.38 ms
(34.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big interracial"
]
160.18 ms
(26.72%)
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
  15317
  31975
  70186
  92397
  130641
  161996
  336938
  382422
  385229
  395185
  495407
  530319
  530819
  531699
  531811
  532186
  532278
  533251
  534211
  534649
  535839
  535908
  535930
  537836
  538106
  538241
  542328
  543904
  544312
  547076
  550654
  550656
  551552
  556176
  558782
  563730
  580572
  584213
  586933
  589629
  590137
  633940
  633962
  634191
  639334
  639775
  642412
  645453
  645972
  646124
  646290
  646606
  648906
  649119
  649919
  650012
  651262
  651485
  651657
  653722
  653846
  654662
  654701
  655055
  655979
  662039
  662060
  665004
  665361
  676116
  682232
  685657
  687192
  690760
  690761
  700674
  701038
  702332
  715251
  716494
  716895
  719969
  725488
  726193
  733556
  733586
  734689
  746470
  749043
  752512
  752809
  755549
  762250
  765462
  771582
  773870
  777031
  785660
  788488
  795482
  795562
  796416
  797383
  797385
  801511
  801515
  802470
  804671
  807970
  808081
  816071
  817110
  817852
  820405
  821619
  822712
  823289
  823537
  823538
  828756
]
12.43 ms
(2.07%)
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
  822712
  823537
  823538
  828756
  532278
  538241
  531699
  534649
  544312
  558782
  551552
  682232
  719969
  646290
  648906
  649919
  650012
  651262
  653722
  662039
  665004
  687192
  716494
  716895
  590137
  642412
  633940
  639775
  589629
  633962
  777031
  797383
  802470
  804671
  785660
  795562
  801515
  725488
  796416
  801511
  808081
  726193
  734689
  762250
  765462
  733556
  749043
  752512
  752809
  773870
  771582
  634191
  702332
  788488
  795482
  807970
  385229
  586933
  639334
  665361
  676116
  797385
  733586
  746470
  755549
  130641
  161996
  395185
  336938
  382422
  70186
  92397
  31975
  15317
  816071
  820405
  817110
  823289
  817852
  821619
  531811
  535839
  535930
  538106
  532186
  495407
  530319
  530819
  534211
  537836
  533251
  535908
  580572
  584213
  542328
  543904
  550654
  556176
  563730
  547076
  550656
  645453
  646124
  646606
  651485
  654662
  654701
  655055
  655979
  662060
  685657
  690760
  690761
  700674
  701038
  715251
  645972
  649119
  651657
  653846
]
2.90 ms
(0.48%)
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
  15317
  31975
  70186
  92397
  130641
  161996
  336938
  382422
  385229
  395185
  495407
  530319
  530819
  531699
  531811
  532186
  532278
  533251
  534211
  534649
  535839
  535908
  535930
  537836
  538106
  538241
  542328
  543904
  544312
  547076
  550654
  550656
  551552
  556176
  558782
  563730
  580572
  584213
  586933
  589629
  590137
  633940
  633962
  634191
  639334
  639775
  642412
  645453
  645972
  646124
  646290
  646606
  648906
  649119
  649919
  650012
  651262
  651485
  651657
  653722
  653846
  654662
  654701
  655055
  655979
  662039
  662060
  665004
  665361
  676116
  682232
  685657
  687192
  690760
  690761
  700674
  701038
  702332
  715251
  716494
  716895
  719969
  725488
  726193
  733556
  733586
  734689
  746470
  749043
  752512
  752809
  755549
  762250
  765462
  771582
  773870
  777031
  785660
  788488
  795482
  795562
  796416
  797383
  797385
  801511
  801515
  802470
  804671
  807970
  808081
  816071
  817110
  817852
  820405
  821619
  822712
  823289
  823537
  823538
  828756
]
1.71 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.