GET https://search.jues.net/search/embeds/4?q=creampie%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.83 ms
(85.43%)
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
  391762
  398009
  419248
  420825
  421762
  421763
  424651
  437391
  441301
  449472
  454030
  458127
  463497
  469768
  481701
  488475
  501322
  503338
  509163
  512547
  516226
  516488
  538619
  540805
  554121
  556075
  562984
  563684
  564184
  577287
  584469
  588531
  592066
  607253
  616509
  616569
  644276
  647249
  650728
  655132
  655279
  656518
  661950
  675494
  687463
  696104
  696167
  698918
  699519
  699543
  700379
  700689
  700819
  703226
  706454
  706895
  714953
  715378
  719109
  720192
  722928
  728151
  728373
  734268
  734326
  734620
  734809
  736727
  738911
  740166
  741318
  746052
  750129
  755119
  756972
  757914
  759874
  760278
  761546
  763922
  764963
  769201
  770774
  773639
  773691
  778079
  779889
  781136
  783379
  786089
  786101
  787040
  787280
  787282
  788918
  791247
  794109
  794439
  794724
  795669
  795826
  796022
  796051
  796117
  796199
  797174
  797228
  797473
  797665
  802067
  802520
  802882
  809985
  810114
  813537
  814116
  819334
  824972
]
12.24 ms
(7.81%)
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
  795826
  802520
  778079
  779889
  786089
  794109
  796051
  734809
  755119
  770774
  773639
  786101
  797473
  809985
  810114
  734268
  756972
  764963
  728373
  738911
  750129
  773691
  769201
  741318
  761546
  700689
  787040
  794724
  796117
  398009
  419248
  540805
  516488
  503338
  644276
  391762
  420825
  421762
  824972
  458127
  509163
  538619
  584469
  562984
  698918
  699519
  715378
  647249
  650728
  656518
  687463
  696104
  700379
  675494
  699543
  706895
  714953
  607253
  616509
  588531
  616569
  781136
  787280
  791247
  796022
  797174
  788918
  794439
  796199
  813537
  734988
  760278
  783379
  787282
  795669
  802882
  734620
  728151
  736727
  757914
  763922
  734326
  759874
  740166
  746052
  703226
  722928
  797228
  797665
  424651
  481701
  516226
  802067
  421763
  441301
  437391
  814116
  819334
  826156
  449472
  454030
  463497
  469768
  501322
  512547
  488475
  563684
  564184
  554121
  577287
  661950
  719109
  655279
  720192
  655132
  696167
  700819
  706454
  556075
  592066
]
2.73 ms
(1.74%)
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
  391762
  398009
  419248
  420825
  421762
  421763
  424651
  437391
  441301
  449472
  454030
  458127
  463497
  469768
  481701
  488475
  501322
  503338
  509163
  512547
  516226
  516488
  538619
  540805
  554121
  556075
  562984
  563684
  564184
  577287
  584469
  588531
  592066
  607253
  616509
  616569
  644276
  647249
  650728
  655132
  655279
  656518
  661950
  675494
  687463
  696104
  696167
  698918
  699519
  699543
  700379
  700689
  700819
  703226
  706454
  706895
  714953
  715378
  719109
  720192
  722928
  728151
  728373
  734268
  734326
  734620
  734809
  736727
  738911
  740166
  741318
  746052
  750129
  755119
  756972
  757914
  759874
  760278
  761546
  763922
  764963
  769201
  770774
  773639
  773691
  778079
  779889
  781136
  783379
  786089
  786101
  787040
  787280
  787282
  788918
  791247
  794109
  794439
  794724
  795669
  795826
  796022
  796051
  796117
  796199
  797174
  797228
  797473
  797665
  802067
  802520
  802882
  809985
  810114
  813537
  814116
  819334
  824972
]
2.15 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie cum"
]
2.14 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie cum"
]
1.86 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie cum"
]
1.71 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.