GET https://search.jues.net/search/embeds/3?q=sexy%20white

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.40 ms
(85.55%)
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
  75762
  100642
  122425
  185123
  187186
  359089
  386865
  387151
  390407
  390775
  391676
  397409
  402659
  403487
  406387
  413982
  414714
  415640
  418994
  423472
  426352
  426868
  427621
  429045
  430789
  441466
  443042
  446274
  447097
  449342
  449937
  450127
  450129
  450130
  450149
  450151
  450156
  450166
  450198
  451714
  452422
  452991
  453270
  453276
  453984
  454062
  454696
  454791
  455348
  455419
  455524
  455633
  456340
  456560
  457024
  457200
  458835
  459511
  460163
  460558
  460641
  460905
  461651
  461776
  461811
  462877
  462887
  462951
  463302
  464022
  465174
  466672
  467069
  468421
  470224
  470878
  472479
  472922
  472957
  473865
  475819
  476818
  477032
  477423
  479613
  479713
  479750
  479822
  481652
  482695
  485211
  486692
  489902
  490142
  496218
  499257
  499742
  502417
  503966
  509010
  518778
  519079
  521151
  521976
  522812
  522824
  525814
  530736
  534143
  534476
  538423
  539016
  557910
  724241
  735604
  763896
  790076
  816423
  818591
  820991
]
17.79 ms
(9.55%)
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
  503966
  509010
  530736
  534143
  534476
  539016
  460558
  467069
  468421
  557910
  790076
  735604
  763896
  724241
  391676
  455524
  463302
  479613
  387151
  397409
  459511
  460905
  472957
  185123
  447097
  461776
  470878
  429045
  475819
  414714
  430789
  461811
  518778
  522812
  525814
  489902
  496218
  499257
  521976
  538423
  499742
  502417
  519079
  522824
  441466
  454696
  521151
  461651
  386865
  100642
  122425
  187186
  359089
  75762
  390407
  390775
  402659
  403487
  406387
  423472
  426868
  415640
  418994
  443042
  413982
  426352
  427621
  816423
  818591
  820991
  482695
  446274
  450129
  450166
  450198
  453276
  453984
  454062
  457200
  458835
  465174
  473865
  477032
  479822
  481652
  486692
  449342
  450151
  450156
  451714
  452422
  452991
  453270
  454791
  455633
  456340
  456560
  457024
  460163
  462887
  466672
  470224
  472922
  477423
  485211
  490142
  449937
  450127
  450130
  450149
  455348
  455419
  460641
  462877
  462951
  464022
  472479
  476818
  479713
  479750
]
2.60 ms
(1.40%)
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
  75762
  100642
  122425
  185123
  187186
  359089
  386865
  387151
  390407
  390775
  391676
  397409
  402659
  403487
  406387
  413982
  414714
  415640
  418994
  423472
  426352
  426868
  427621
  429045
  430789
  441466
  443042
  446274
  447097
  449342
  449937
  450127
  450129
  450130
  450149
  450151
  450156
  450166
  450198
  451714
  452422
  452991
  453270
  453276
  453984
  454062
  454696
  454791
  455348
  455419
  455524
  455633
  456340
  456560
  457024
  457200
  458835
  459511
  460163
  460558
  460641
  460905
  461651
  461776
  461811
  462877
  462887
  462951
  463302
  464022
  465174
  466672
  467069
  468421
  470224
  470878
  472479
  472922
  472957
  473865
  475819
  476818
  477032
  477423
  479613
  479713
  479750
  479822
  481652
  482695
  485211
  486692
  489902
  490142
  496218
  499257
  499742
  502417
  503966
  509010
  518778
  519079
  521151
  521976
  522812
  522824
  525814
  530736
  534143
  534476
  538423
  539016
  557910
  724241
  735604
  763896
  790076
  816423
  818591
  820991
]
2.11 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy white"
]
1.60 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy white"
]
1.27 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy white"
]

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.