GET https://search.jues.net/search/embeds/4?q=hungry%20for%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.95 ms
(84.40%)
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
  383272
  385318
  386378
  404451
  411926
  413084
  414368
  415112
  416675
  438417
  444806
  445327
  446125
  451469
  452895
  455502
  456226
  457422
  459357
  467364
  474139
  474509
  474875
  475080
  475174
  479003
  480731
  482454
  486516
  488032
  489168
  490795
  491418
  494037
  494778
  495700
  498038
  499712
  502740
  502778
  503051
  503304
  503845
  506454
  509879
  510839
  512369
  513550
  515678
  515846
  516787
  517868
  519819
  520005
  520817
  521310
  523108
  523128
  523323
  526288
  527040
  527267
  527732
  527742
  529243
  531230
  534579
  536918
  546005
  546124
  552977
  553927
  554292
  554880
  555582
  555866
  563431
  564407
  565506
  567304
  568038
  568596
  569070
  570137
  570759
  576352
  577356
  582480
  582722
  584006
  584516
  587921
  596630
  597208
  599598
  601347
  603835
  609794
  610035
  612698
  612964
  614966
  619199
  620203
  621340
  622067
  622714
  623364
  633892
  636535
  637689
  641732
  643125
  672361
  676016
  676101
  748210
  770897
  791048
  820482
]
21.38 ms
(10.49%)
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
  489168
  527732
  411926
  499712
  519819
  536918
  552977
  672361
  770897
  444806
  490795
  582722
  570137
  637689
  467364
  480731
  526288
  517868
  488032
  385318
  576352
  599598
  623364
  475174
  446125
  502778
  513550
  515846
  515678
  523128
  527267
  555582
  633892
  748210
  416675
  459357
  451469
  503845
  523323
  404451
  534579
  563431
  506454
  486516
  503304
  614966
  456226
  820482
  474875
  569070
  619199
  568038
  475080
  555866
  438417
  554292
  596630
  791048
  516787
  520817
  457422
  512369
  510839
  546005
  570759
  612964
  609794
  527040
  643125
  529243
  531230
  413084
  479003
  414368
  445327
  553927
  676101
  567304
  503051
  455502
  527742
  622714
  386378
  482454
  603835
  491418
  383272
  521310
  474509
  498038
  546124
  495700
  584516
  415112
  502740
  509879
  452895
  554880
  582480
  584006
  641732
  523108
  564407
  601347
  577356
  494778
  620203
  587921
  520005
  612698
  676016
  636535
  568596
  565506
  494037
  597208
  610035
  474139
  622067
  621340
]
2.89 ms
(1.42%)
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
  383272
  385318
  386378
  404451
  411926
  413084
  414368
  415112
  416675
  438417
  444806
  445327
  446125
  451469
  452895
  455502
  456226
  457422
  459357
  467364
  474139
  474509
  474875
  475080
  475174
  479003
  480731
  482454
  486516
  488032
  489168
  490795
  491418
  494037
  494778
  495700
  498038
  499712
  502740
  502778
  503051
  503304
  503845
  506454
  509879
  510839
  512369
  513550
  515678
  515846
  516787
  517868
  519819
  520005
  520817
  521310
  523108
  523128
  523323
  526288
  527040
  527267
  527732
  527742
  529243
  531230
  534579
  536918
  546005
  546124
  552977
  553927
  554292
  554880
  555582
  555866
  563431
  564407
  565506
  567304
  568038
  568596
  569070
  570137
  570759
  576352
  577356
  582480
  582722
  584006
  584516
  587921
  596630
  597208
  599598
  601347
  603835
  609794
  610035
  612698
  612964
  614966
  619199
  620203
  621340
  622067
  622714
  623364
  633892
  636535
  637689
  641732
  643125
  672361
  676016
  676101
  748210
  770897
  791048
  820482
]
2.15 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hungry for sex"
]
2.01 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hungry секс"
]
1.43 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hungry секс"
]

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.