GET https://search.jues.net/search/embeds/9?q=she%20is%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.02 ms
(86.44%)
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
  402792
  409841
  416880
  422051
  434953
  444296
  446449
  447008
  448107
  449722
  451014
  451304
  451788
  452825
  453738
  457339
  458471
  458788
  458957
  461793
  465295
  465863
  465889
  466373
  479387
  479960
  481598
  483784
  490758
  492054
  498857
  501509
  501916
  503794
  507702
  514076
  515225
  515635
  519054
  520450
  522793
  524914
  525085
  525754
  526489
  536067
  542921
  549729
  552345
  557810
  560747
  560814
  561360
  562079
  562793
  564575
  568875
  569546
  576510
  578302
  578733
  580414
  580659
  581754
  587937
  589174
  592561
  592824
  592921
  592958
  595097
  595275
  595630
  596359
  596740
  597581
  598466
  599491
  605194
  605200
  607206
  608785
  616957
  618612
  626321
  627641
  628037
  628564
  642389
  643489
  660002
  661394
  666983
  680267
  688376
  690745
  693649
  716927
  719837
  723164
  742930
  746101
  756803
  758823
  762159
  762569
  762575
  769487
  787120
  788252
  789046
  791641
  795757
  796184
  798666
  800535
  805331
  811123
  814699
  814701
]
15.53 ms
(8.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
  581754
  542921
  562079
  568875
  693649
  688376
  660002
  690745
  719837
  552345
  560747
  564575
  576510
  596359
  597581
  605200
  628037
  595630
  616957
  608785
  642389
  587937
  595275
  598466
  607206
  627641
  628564
  789046
  795757
  805331
  811123
  791641
  796184
  800535
  758823
  762575
  787120
  746101
  762569
  769487
  742930
  756803
  626321
  458788
  466373
  457339
  479387
  434953
  409841
  444296
  452825
  458957
  461793
  465889
  446449
  501509
  514076
  515225
  522793
  492054
  501916
  515635
  525754
  526489
  490758
  498857
  520450
  402792
  416880
  422051
  814701
  814699
  451014
  453738
  465295
  449722
  451788
  481598
  483784
  503794
  525085
  536067
  519054
  507702
  524914
  465863
  549729
  578302
  560814
  562793
  569546
  561360
  578733
  666983
  723164
  661394
  680267
  716927
  557810
  580414
  580659
  589174
  592561
  592824
  592921
  592958
  596740
  643489
  595097
  599491
  618612
  798666
  788252
  762159
  605194
  458471
  479960
  448107
  451304
  447008
]
2.33 ms
(1.28%)
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
  402792
  409841
  416880
  422051
  434953
  444296
  446449
  447008
  448107
  449722
  451014
  451304
  451788
  452825
  453738
  457339
  458471
  458788
  458957
  461793
  465295
  465863
  465889
  466373
  479387
  479960
  481598
  483784
  490758
  492054
  498857
  501509
  501916
  503794
  507702
  514076
  515225
  515635
  519054
  520450
  522793
  524914
  525085
  525754
  526489
  536067
  542921
  549729
  552345
  557810
  560747
  560814
  561360
  562079
  562793
  564575
  568875
  569546
  576510
  578302
  578733
  580414
  580659
  581754
  587937
  589174
  592561
  592824
  592921
  592958
  595097
  595275
  595630
  596359
  596740
  597581
  598466
  599491
  605194
  605200
  607206
  608785
  616957
  618612
  626321
  627641
  628037
  628564
  642389
  643489
  660002
  661394
  666983
  680267
  688376
  690745
  693649
  716927
  719837
  723164
  742930
  746101
  756803
  758823
  762159
  762569
  762575
  769487
  787120
  788252
  789046
  791641
  795757
  796184
  798666
  800535
  805331
  811123
  814699
  814701
]
1.97 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "she cum"
]
1.95 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "she is cum"
]
1.48 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "she cum"
]

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.