GET https://search.jues.net/search/embeds/6?q=gymnast%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.28 ms
(82.96%)
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
  198001
  383616
  389440
  401159
  401351
  407222
  409881
  414198
  415005
  415172
  415655
  416867
  426409
  435054
  442201
  444652
  445514
  446618
  447601
  447677
  447867
  448042
  448792
  451877
  452987
  453379
  454778
  457597
  457863
  461466
  461543
  462070
  462910
  463385
  465875
  468238
  476029
  480365
  483543
  486288
  487134
  495292
  501507
  503577
  504340
  504584
  504840
  504997
  505326
  507596
  515450
  515554
  518254
  519561
  519592
  527920
  528034
  530373
  543218
  545545
  558217
  558861
  561720
  567763
  572237
  576087
  581967
  583622
  586931
  592330
  595956
  599964
  599969
  600002
  601150
  601584
  606560
  621794
  621798
  624367
  637726
  647666
  650158
  651080
  652934
  659432
  667760
  675034
  678876
  681215
  699505
  713320
  719022
  725609
  725640
  731485
  731893
  732878
  735778
  742188
  743433
  745384
  756206
  776025
  785092
  787488
  787544
  793558
  795899
  805925
  811500
  812271
  821184
  821625
  822005
  822079
  822719
  823173
  825812
]
16.59 ms
(10.25%)
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
  675034
  558217
  545545
  389440
  414198
  415005
  600002
  732878
  825812
  435054
  426409
  416867
  601150
  415655
  599964
  601584
  448792
  650158
  599969
  583622
  451877
  745384
  530373
  483543
  383616
  519592
  822005
  447677
  519561
  681215
  504840
  624367
  735778
  793558
  776019
  637726
  821625
  795899
  621798
  822079
  678876
  713320
  507596
  699505
  457863
  731485
  743433
  719022
  812271
  652934
  725609
  776025
  731893
  659432
  592330
  742188
  756206
  543218
  576087
  785092
  822719
  567763
  821184
  805925
  823173
  561720
  505326
  407222
  504584
  462070
  461543
  606560
  446618
  476029
  528034
  787488
  401351
  725640
  462910
  457597
  621794
  558861
  572237
  442201
  409881
  495292
  647666
  448042
  486288
  501507
  811500
  198001
  787544
  454778
  595956
  468238
  651080
  586931
  401159
  453379
  465875
  515450
  480365
  503577
  415172
  447867
  452987
  527920
  445514
  504997
  487134
  461466
  667760
  463385
  444652
  515554
  504340
  518254
  581967
  447601
]
3.34 ms
(2.06%)
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
  198001
  383616
  389440
  401159
  401351
  407222
  409881
  414198
  415005
  415172
  415655
  416867
  426409
  435054
  442201
  444652
  445514
  446618
  447601
  447677
  447867
  448042
  448792
  451877
  452987
  453379
  454778
  457597
  457863
  461466
  461543
  462070
  462910
  463385
  465875
  468238
  476029
  480365
  483543
  486288
  487134
  495292
  501507
  503577
  504340
  504584
  504840
  504997
  505326
  507596
  515450
  515554
  518254
  519561
  519592
  527920
  528034
  530373
  543218
  545545
  558217
  558861
  561720
  567763
  572237
  576087
  581967
  583622
  586931
  592330
  595956
  599964
  599969
  600002
  601150
  601584
  606560
  621794
  621798
  624367
  637726
  647666
  650158
  651080
  652934
  659432
  667760
  675034
  678876
  681215
  699505
  713320
  719022
  725609
  725640
  731485
  731893
  732878
  735778
  742188
  743433
  745384
  756206
  776025
  785092
  787488
  787544
  793558
  795899
  805925
  811500
  812271
  821184
  821625
  822005
  822079
  822719
  823173
  825812
]
2.18 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gymnast sex"
]
1.94 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "гимнастк девушк секс"
]
1.85 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "гимнастк девушк секс"
]
1.70 ms
(1.05%)
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.