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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.47 ms
(81.23%)
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
  384297
  396421
  398679
  434517
  437151
  450448
  452756
  454036
  455112
  459735
  488299
  489257
  492050
  509747
  509963
  512413
  516489
  516496
  518173
  522626
  522645
  526819
  541061
  550921
  553269
  555798
  557833
  560274
  565013
  565071
  591901
  600718
  603280
  604704
  605495
  608318
  614597
  628942
  635387
  643804
  656590
  674603
  689779
  692710
  695693
  702310
  707581
  708050
  710687
  710822
  715012
  715161
  718107
  718818
  720345
  720964
  725617
  727673
  728492
  728865
  730157
  736113
  737330
  743422
  746391
  746745
  748003
  748712
  750711
  750902
  755165
  761480
  761874
  763866
  768634
  771229
  777452
  777482
  779533
  779683
  779783
  779859
  781130
  781143
  786550
  787436
  787594
  790869
  791218
  791250
  791805
  791835
  792390
  793338
  794435
  795860
  796137
  796480
  797931
  800820
  801150
  805256
  805258
  805259
  805733
  810073
  817328
  817736
  819024
  819332
  819798
  823842
  824036
  825472
  825576
  826635
  827552
  828346
  828726
]
23.14 ms
(13.38%)
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
  437151
  526819
  555798
  492050
  553269
  771229
  786550
  720964
  796480
  791835
  805256
  455112
  826635
  628942
  605495
  452756
  805258
  708050
  794435
  522645
  710687
  824036
  761480
  565013
  557833
  560274
  656590
  702310
  674603
  710822
  797931
  750711
  488299
  727673
  796137
  805259
  516489
  522626
  516496
  541061
  720345
  715161
  725617
  805733
  398679
  823842
  643804
  779859
  781130
  512413
  454036
  396421
  450448
  715012
  608318
  791250
  790869
  743422
  819798
  827552
  819024
  825576
  828346
  828726
  459735
  509963
  707581
  635387
  591901
  603280
  779783
  793338
  795860
  801150
  746745
  800820
  750902
  761874
  728492
  736113
  748003
  763866
  434517
  692710
  604704
  755165
  614597
  777482
  791218
  792390
  518173
  489257
  509747
  384297
  817736
  825472
  817328
  819332
  550921
  565071
  718818
  689779
  695693
  718107
  600718
  777452
  778252
  779683
  791805
  779533
  781143
  787594
  810073
  737330
  787436
  746391
  768634
  728865
  730157
  748712
]
2.35 ms
(1.36%)
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
  384297
  396421
  398679
  434517
  437151
  450448
  452756
  454036
  455112
  459735
  488299
  489257
  492050
  509747
  509963
  512413
  516489
  516496
  518173
  522626
  522645
  526819
  541061
  550921
  553269
  555798
  557833
  560274
  565013
  565071
  591901
  600718
  603280
  604704
  605495
  608318
  614597
  628942
  635387
  643804
  656590
  674603
  689779
  692710
  695693
  702310
  707581
  708050
  710687
  710822
  715012
  715161
  718107
  718818
  720345
  720964
  725617
  727673
  728492
  728865
  730157
  736113
  737330
  743422
  746391
  746745
  748003
  748712
  750711
  750902
  755165
  761480
  761874
  763866
  768634
  771229
  777452
  777482
  779533
  779683
  779783
  779859
  781130
  781143
  786550
  787436
  787594
  790869
  791218
  791250
  791805
  791835
  792390
  793338
  794435
  795860
  796137
  796480
  797931
  800820
  801150
  805256
  805258
  805259
  805733
  810073
  817328
  817736
  819024
  819332
  819798
  823842
  824036
  825472
  825576
  826635
  827552
  828346
  828726
]
2.02 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum creampie"
]
1.77 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum creampie"
]
1.43 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum creampie"
]

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.