GET https://search.jues.net/search/embeds/6?q=amateur%20scream

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.79 ms
(89.89%)
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
  384119
  391951
  397325
  426728
  427709
  432749
  441424
  455888
  461935
  478651
  484440
  506192
  517834
  533276
  537504
  539244
  542348
  546284
  555215
  557018
  564344
  566919
  570930
  571421
  583151
  583909
  585357
  589325
  593562
  596905
  607802
  610156
  611047
  620499
  622477
  638898
  644720
  654974
  663738
  664755
  675856
  680229
  686459
  706531
  707662
  713301
  714949
  715700
  717664
  717673
  717712
  721811
  721936
  724030
  726932
  728410
  729666
  730473
  731280
  731311
  733339
  734331
  734411
  734928
  734929
  734961
  735708
  736222
  736231
  736293
  736618
  740935
  742647
  742852
  744755
  757870
  758096
  758929
  760338
  760892
  761053
  761462
  761497
  765248
  766681
  766883
  767417
  768465
  769864
  770469
  771737
  773409
  775330
  778627
  779681
  785317
  785684
  786940
  788224
  788552
  788858
  791097
  791252
  794171
  799516
  801253
  802328
  802668
  802825
  806864
  807082
  812845
  812853
  812858
  812859
  813824
  820011
  824167
  826206
  826834
]
12.83 ms
(5.42%)
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
  761053
  802668
  397325
  607802
  566919
  571421
  654974
  680229
  664755
  622477
  610156
  638898
  785317
  461935
  583909
  484440
  826834
  517834
  717664
  714949
  715700
  585357
  589325
  775330
  785684
  812858
  788858
  734411
  736231
  744755
  771737
  731280
  730473
  731311
  734961
  758929
  773409
  729666
  736618
  734928
  717712
  779681
  620499
  384119
  813824
  820011
  824167
  555215
  788552
  794171
  799516
  802825
  742852
  761497
  786940
  802328
  806864
  726932
  728410
  760338
  778627
  788224
  812859
  432749
  427709
  706531
  533276
  570930
  557018
  675856
  713301
  707662
  721811
  663738
  686459
  583151
  644720
  611047
  596905
  812845
  426728
  537504
  564344
  593562
  742647
  391951
  455888
  441424
  539244
  542348
  546284
  721936
  724030
  736222
  740935
  761462
  768465
  734331
  766883
  734929
  735708
  736293
  760892
  769864
  733339
  758096
  791097
  478651
  826206
  506192
  717673
  812853
  791252
  801253
  765248
  770469
  807082
  757870
  766681
  767417
]
3.60 ms
(1.52%)
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
  384119
  391951
  397325
  426728
  427709
  432749
  441424
  455888
  461935
  478651
  484440
  506192
  517834
  533276
  537504
  539244
  542348
  546284
  555215
  557018
  564344
  566919
  570930
  571421
  583151
  583909
  585357
  589325
  593562
  596905
  607802
  610156
  611047
  620499
  622477
  638898
  644720
  654974
  663738
  664755
  675856
  680229
  686459
  706531
  707662
  713301
  714949
  715700
  717664
  717673
  717712
  721811
  721936
  724030
  726932
  728410
  729666
  730473
  731280
  731311
  733339
  734331
  734411
  734928
  734929
  734961
  735708
  736222
  736231
  736293
  736618
  740935
  742647
  742852
  744755
  757870
  758096
  758929
  760338
  760892
  761053
  761462
  761497
  765248
  766681
  766883
  767417
  768465
  769864
  770469
  771737
  773409
  775330
  778627
  779681
  785317
  785684
  786940
  788224
  788552
  788858
  791097
  791252
  794171
  799516
  801253
  802328
  802668
  802825
  806864
  807082
  812845
  812853
  812858
  812859
  813824
  820011
  824167
  826206
  826834
]
2.19 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur scream"
]
1.99 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск крича вперв"
]
1.74 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.