GET https://search.jues.net/search/embeds/8?q=double%20anal%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.49 ms
(85.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
  384809
  391400
  411751
  414315
  414621
  418363
  452638
  452977
  472910
  475414
  475833
  476676
  476905
  481904
  487938
  488724
  491446
  508699
  510815
  511812
  518493
  519497
  522606
  522870
  522889
  522895
  522906
  523859
  526470
  530384
  530796
  531202
  531235
  532343
  532913
  532995
  533372
  533373
  535054
  535456
  537114
  537203
  537595
  537672
  537773
  541698
  541806
  543652
  550831
  559162
  561119
  562823
  562836
  569154
  571028
  576691
  576711
  583700
  584063
  586673
  588286
  593877
  596082
  596851
  599833
  599862
  599863
  599914
  599955
  599965
  599976
  600019
  600171
  600296
  600342
  601613
  602018
  604902
  617416
  622979
  632659
  632663
  634543
  634774
  634782
  636295
  636320
  637036
  639027
  640531
  641141
  641455
  641690
  642063
  643376
  643933
  644918
  646025
  646841
  648235
  648853
  651631
  662000
  666892
  668534
  671746
  677674
  688108
  702061
  704531
  708447
  711283
  718695
  756413
  778359
  788262
  792576
  801960
  807175
  809520
]
18.15 ms
(9.24%)
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
  586673
  596082
  600342
  634782
  639027
  641141
  641455
  643376
  801960
  792576
  756413
  617416
  640531
  643933
  702061
  718695
  778359
  788262
  809520
  414621
  452977
  411751
  391400
  475833
  508699
  518493
  522895
  523859
  510815
  571028
  584063
  600296
  599863
  599965
  600019
  418363
  519497
  588286
  644918
  475414
  476905
  487938
  488724
  452638
  526470
  535054
  522606
  522889
  541806
  559162
  562823
  562836
  576691
  569154
  646025
  662000
  668534
  677674
  671746
  708447
  550831
  576711
  622979
  593877
  599914
  602018
  632659
  641690
  384809
  472910
  511812
  491446
  535456
  522906
  522870
  561119
  532995
  533372
  533373
  537114
  537773
  476676
  541698
  648235
  688108
  651631
  711283
  646841
  648853
  666892
  596851
  599976
  600171
  642063
  599955
  599862
  634543
  636295
  601613
  632663
  704531
  414315
  637036
  543652
  583700
  634774
  604902
  636320
  599833
  807175
  481904
  530384
  530796
  537672
  531202
  532343
  532913
  537203
  537595
  531235
]
2.87 ms
(1.46%)
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
  384809
  391400
  411751
  414315
  414621
  418363
  452638
  452977
  472910
  475414
  475833
  476676
  476905
  481904
  487938
  488724
  491446
  508699
  510815
  511812
  518493
  519497
  522606
  522870
  522889
  522895
  522906
  523859
  526470
  530384
  530796
  531202
  531235
  532343
  532913
  532995
  533372
  533373
  535054
  535456
  537114
  537203
  537595
  537672
  537773
  541698
  541806
  543652
  550831
  559162
  561119
  562823
  562836
  569154
  571028
  576691
  576711
  583700
  584063
  586673
  588286
  593877
  596082
  596851
  599833
  599862
  599863
  599914
  599955
  599965
  599976
  600019
  600171
  600296
  600342
  601613
  602018
  604902
  617416
  622979
  632659
  632663
  634543
  634774
  634782
  636295
  636320
  637036
  639027
  640531
  641141
  641455
  641690
  642063
  643376
  643933
  644918
  646025
  646841
  648235
  648853
  651631
  662000
  666892
  668534
  671746
  677674
  688108
  702061
  704531
  708447
  711283
  718695
  756413
  778359
  788262
  792576
  801960
  807175
  809520
]
1.99 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal mom"
]
1.66 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал mom"
]
1.65 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал mom"
]

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.