GET https://search.jues.net/search/embeds/8?q=%D0%BF%D0%B8%D0%B7%D0%B4%D0%B0%20%D0%B5%D0%B1%D1%83%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.07 ms
(86.11%)
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
  338338
  410664
  414739
  420108
  457388
  474093
  481606
  485751
  494280
  494732
  494975
  496296
  499188
  501518
  503786
  508272
  517635
  519207
  522602
  523198
  526103
  526353
  530250
  533274
  534488
  534964
  536458
  536503
  537380
  539546
  544580
  546335
  547581
  552044
  552299
  553237
  554751
  555460
  555546
  555578
  555667
  556645
  557912
  559674
  560467
  560560
  563831
  564667
  565029
  565370
  565380
  567009
  567618
  568081
  570094
  571836
  573062
  575557
  577166
  577849
  579775
  581041
  584774
  587529
  588216
  588398
  589106
  590185
  590740
  590852
  591134
  591946
  595985
  598294
  599461
  601463
  604917
  606424
  607353
  610252
  612302
  613663
  613937
  615944
  619322
  620349
  622625
  623105
  623304
  626773
  628678
  628719
  631401
  639958
  643624
  644037
  646186
  646233
  650691
  654228
  655667
  658489
  660545
  663038
  680102
  681443
  681507
  689084
  691151
  691699
  725201
  737657
  744233
  753238
  755138
  773870
  786008
  792165
]
16.00 ms
(8.35%)
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
  691151
  591946
  628719
  494280
  533274
  534488
  503786
  571836
  546335
  547581
  655667
  570094
  643624
  601463
  623304
  474093
  536458
  523198
  499188
  555578
  567009
  590740
  573062
  567618
  575557
  606424
  615944
  481606
  544580
  565029
  650691
  654228
  623105
  755138
  631401
  660545
  568081
  485751
  536503
  556645
  646233
  588398
  587529
  526353
  604917
  681443
  526103
  508272
  501518
  584774
  557912
  689084
  620349
  619322
  579775
  628678
  639958
  773870
  338338
  494975
  581041
  646186
  613663
  658489
  663038
  691699
  588216
  610252
  778252
  786008
  725201
  792165
  737657
  744233
  753238
  410664
  530250
  577166
  595985
  457388
  519207
  555667
  599461
  494732
  522602
  517635
  534964
  564667
  552299
  554751
  559674
  563831
  680102
  560467
  565370
  565380
  598294
  626773
  613937
  607353
  612302
  622625
  420108
  537380
  555460
  644037
  414739
  496296
  539546
  555546
  577849
  560560
  555656
  681507
  552044
  553237
  589106
  591134
  590852
  590185
]
3.28 ms
(1.71%)
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
  338338
  410664
  414739
  420108
  457388
  474093
  481606
  485751
  494280
  494732
  494975
  496296
  499188
  501518
  503786
  508272
  517635
  519207
  522602
  523198
  526103
  526353
  530250
  533274
  534488
  534964
  536458
  536503
  537380
  539546
  544580
  546335
  547581
  552044
  552299
  553237
  554751
  555460
  555546
  555578
  555667
  556645
  557912
  559674
  560467
  560560
  563831
  564667
  565029
  565370
  565380
  567009
  567618
  568081
  570094
  571836
  573062
  575557
  577166
  577849
  579775
  581041
  584774
  587529
  588216
  588398
  589106
  590185
  590740
  590852
  591134
  591946
  595985
  598294
  599461
  601463
  604917
  606424
  607353
  610252
  612302
  613663
  613937
  615944
  619322
  620349
  622625
  623105
  623304
  626773
  628678
  628719
  631401
  639958
  643624
  644037
  646186
  646233
  650691
  654228
  655667
  658489
  660545
  663038
  680102
  681443
  681507
  689084
  691151
  691699
  725201
  737657
  744233
  753238
  755138
  773870
  786008
  792165
]
2.18 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пизда ебут"
]
1.84 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин секс"
]
1.66 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.86%)
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.