GET https://search.jues.net/search/embeds/10?q=neighbor%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.39 ms
(84.77%)
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
  436588
  444608
  446060
  451333
  452277
  452334
  455963
  457392
  460559
  460560
  461800
  462654
  464227
  467738
  492167
  495049
  497648
  499120
  500377
  505869
  505870
  508394
  511046
  517371
  524133
  525027
  526446
  533102
  542628
  552353
  553432
  560438
  563170
  566651
  567558
  573514
  575037
  579471
  579561
  585256
  586201
  586211
  586244
  586245
  586274
  588236
  590375
  595031
  599466
  601204
  602762
  605671
  613606
  617262
  617614
  620121
  623180
  623232
  625724
  626119
  626872
  627782
  630662
  643936
  644119
  644186
  650646
  661914
  662117
  664650
  666470
  667999
  674604
  678644
  681950
  682734
  691138
  695800
  698015
  700590
  708095
  710188
  710667
  711782
  711805
  713908
  718699
  719287
  724713
  743831
  744484
  752472
  755627
  757724
  758232
  763442
  765886
  767399
  772157
  772753
  782198
  782536
  785507
  793879
  795636
  798221
  798819
  799171
  799209
  799260
  799574
  802287
  802883
  804327
  804894
  805182
  807584
  813328
  814233
]
12.15 ms
(8.48%)
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
  500377
  505869
  814233
  700590
  710188
  713908
  650646
  664650
  695800
  698015
  711782
  719287
  585256
  588236
  643936
  782536
  799209
  813328
  799171
  772157
  782198
  793879
  743831
  765886
  766431
  763442
  617262
  711805
  452277
  460559
  495049
  511046
  573514
  566651
  678644
  661914
  599466
  586244
  757724
  755627
  772753
  630662
  497648
  617614
  524133
  455963
  436588
  452334
  457392
  460560
  526446
  505870
  517371
  525027
  560438
  542628
  579471
  666470
  674604
  691138
  563170
  601204
  590375
  626872
  644186
  586274
  623180
  626119
  586201
  602762
  605671
  798819
  758232
  613606
  446060
  461800
  467738
  451333
  499120
  492167
  579561
  620121
  508394
  533102
  662117
  681950
  718699
  667999
  682734
  708095
  567558
  586211
  644119
  595031
  623232
  627782
  799574
  805182
  785507
  795636
  802287
  807584
  799260
  744484
  724713
  752472
  767399
  710667
  798221
  802883
  804327
  464227
  552353
  575037
  553432
  462654
  586245
  625724
  804894
  444608
]
2.52 ms
(1.76%)
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
  436588
  444608
  446060
  451333
  452277
  452334
  455963
  457392
  460559
  460560
  461800
  462654
  464227
  467738
  492167
  495049
  497648
  499120
  500377
  505869
  505870
  508394
  511046
  517371
  524133
  525027
  526446
  533102
  542628
  552353
  553432
  560438
  563170
  566651
  567558
  573514
  575037
  579471
  579561
  585256
  586201
  586211
  586244
  586245
  586274
  588236
  590375
  595031
  599466
  601204
  602762
  605671
  613606
  617262
  617614
  620121
  623180
  623232
  625724
  626119
  626872
  627782
  630662
  643936
  644119
  644186
  650646
  661914
  662117
  664650
  666470
  667999
  674604
  678644
  681950
  682734
  691138
  695800
  698015
  700590
  708095
  710188
  710667
  711782
  711805
  713908
  718699
  719287
  724713
  743831
  744484
  752472
  755627
  757724
  758232
  763442
  765886
  767399
  772157
  772753
  782198
  782536
  785507
  793879
  795636
  798221
  798819
  799171
  799209
  799260
  799574
  802287
  802883
  804327
  804894
  805182
  807584
  813328
  814233
]
2.11 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "neighbor wife"
]
1.79 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "neighbor жен"
]
1.73 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "neighbor жен"
]

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.