GET https://search.jues.net/search/embeds/3?q=young%20first%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.51 ms
(86.92%)
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
  385225
  389089
  395648
  395661
  395751
  396316
  398545
  398769
  399595
  401108
  401137
  401305
  409027
  415200
  415627
  418350
  418954
  423767
  427716
  432735
  435355
  436437
  436820
  437829
  450771
  450881
  459131
  463815
  464324
  465011
  465368
  473739
  478184
  479759
  480439
  480896
  483331
  494622
  497368
  499718
  500795
  514805
  516615
  520723
  521763
  521928
  525043
  526906
  529854
  533517
  533747
  539938
  541076
  543837
  545604
  552742
  557434
  558119
  564648
  565249
  575063
  580282
  580996
  586648
  590731
  592034
  596323
  597227
  597260
  597266
  599826
  600503
  603536
  621339
  622401
  623198
  624122
  624175
  628117
  628380
  628396
  630632
  631965
  632979
  633718
  633732
  633798
  637089
  640772
  642043
  642691
  645019
  646838
  646851
  647343
  647850
  647906
  649525
  657128
  666546
  668083
  677125
  678798
  680112
  680120
  680126
  680142
  680186
  696126
  702166
  720056
  722056
  726847
  727812
  740077
  770853
  774176
  800588
  810773
  812354
]
18.80 ms
(8.27%)
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
  516615
  647850
  680112
  680126
  622401
  774176
  459131
  597266
  478184
  525043
  385225
  401305
  533517
  565249
  633798
  480439
  401108
  580996
  677125
  590731
  597227
  646851
  450771
  552742
  668083
  696126
  678798
  722056
  621339
  740077
  389089
  529854
  539938
  596323
  437829
  415627
  580282
  646838
  600503
  640772
  812354
  558119
  642691
  395751
  720056
  631965
  800588
  415200
  497368
  520723
  702166
  666546
  632979
  623198
  624175
  642043
  395648
  500795
  514805
  499718
  599826
  463815
  680186
  680142
  770853
  398769
  494622
  464324
  630632
  418954
  628380
  680120
  423767
  483331
  432735
  726847
  521763
  575063
  597260
  586648
  480896
  418350
  465011
  427716
  435355
  479759
  603536
  647906
  526906
  541076
  647343
  628396
  628117
  473739
  649525
  727812
  545604
  645019
  592034
  633718
  533747
  633732
  399595
  450881
  657128
  436820
  436437
  398545
  401137
  521928
  564648
  637089
  395661
  624122
  396316
  543837
  810773
  409027
  465368
  557434
]
4.47 ms
(1.97%)
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
  385225
  389089
  395648
  395661
  395751
  396316
  398545
  398769
  399595
  401108
  401137
  401305
  409027
  415200
  415627
  418350
  418954
  423767
  427716
  432735
  435355
  436437
  436820
  437829
  450771
  450881
  459131
  463815
  464324
  465011
  465368
  473739
  478184
  479759
  480439
  480896
  483331
  494622
  497368
  499718
  500795
  514805
  516615
  520723
  521763
  521928
  525043
  526906
  529854
  533517
  533747
  539938
  541076
  543837
  545604
  552742
  557434
  558119
  564648
  565249
  575063
  580282
  580996
  586648
  590731
  592034
  596323
  597227
  597260
  597266
  599826
  600503
  603536
  621339
  622401
  623198
  624122
  624175
  628117
  628380
  628396
  630632
  631965
  632979
  633718
  633732
  633798
  637089
  640772
  642043
  642691
  645019
  646838
  646851
  647343
  647850
  647906
  649525
  657128
  666546
  668083
  677125
  678798
  680112
  680120
  680126
  680142
  680186
  696126
  702166
  720056
  722056
  726847
  727812
  740077
  770853
  774176
  800588
  810773
  812354
]
1.72 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young first sex"
]
1.70 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young first секс"
]
1.40 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young first секс"
]

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.