GET https://search.jues.net/search/embeds/10?q=cumming

Query Metrics

8 Database Queries
8 Different statements
160.84 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
137.86 ms
(85.71%)
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
  400249
  403797
  415819
  417800
  417823
  422389
  430225
  432359
  435131
  435706
  436776
  437415
  448175
  448693
  450612
  451002
  453311
  456790
  463543
  463544
  463545
  463587
  463597
  463606
  464442
  468048
  471313
  475338
  476088
  481444
  484970
  489934
  491208
  495289
  495469
  496397
  501734
  502215
  504162
  506677
  507309
  508221
  508468
  508519
  508593
  508786
  510697
  514811
  515246
  515482
  517673
  517836
  518255
  520330
  521343
  521353
  521545
  523160
  523793
  524299
  525828
  527161
  528029
  529103
  533207
  540549
  544992
  545440
  552269
  562765
  565862
  571102
  571658
  573355
  579368
  584087
  584670
  591415
  593173
  596424
  600466
  602006
  602912
  614720
  615185
  624367
  679389
  693955
  797815
  801970
]
13.19 ms
(8.20%)
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
  797815
  476088
  417800
  481444
  435706
  450612
  437415
  430225
  502215
  521353
  495289
  489934
  515482
  495469
  417823
  463597
  451002
  471313
  453311
  456790
  515246
  496397
  529103
  508519
  508221
  508593
  475338
  562765
  584670
  565862
  693955
  679389
  593173
  600466
  602006
  801970
  435131
  436776
  463543
  463544
  463545
  508786
  510697
  506677
  514811
  521343
  521545
  527161
  403797
  432359
  468048
  448175
  523160
  524299
  540549
  501734
  508468
  545440
  571102
  552269
  573355
  579368
  448693
  517673
  518255
  504162
  528029
  533207
  544992
  615185
  400249
  422389
  464442
  484970
  507309
  525828
  596424
  614720
  463587
  415819
  523793
  571658
  584087
  624367
  463606
  491208
  520330
  517836
  591415
  602912
]
2.32 ms
(1.45%)
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
  400249
  403797
  415819
  417800
  417823
  422389
  430225
  432359
  435131
  435706
  436776
  437415
  448175
  448693
  450612
  451002
  453311
  456790
  463543
  463544
  463545
  463587
  463597
  463606
  464442
  468048
  471313
  475338
  476088
  481444
  484970
  489934
  491208
  495289
  495469
  496397
  501734
  502215
  504162
  506677
  507309
  508221
  508468
  508519
  508593
  508786
  510697
  514811
  515246
  515482
  517673
  517836
  518255
  520330
  521343
  521353
  521545
  523160
  523793
  524299
  525828
  527161
  528029
  529103
  533207
  540549
  544992
  545440
  552269
  562765
  565862
  571102
  571658
  573355
  579368
  584087
  584670
  591415
  593173
  596424
  600466
  602006
  602912
  614720
  615185
  624367
  679389
  693955
  797815
  801970
]
1.68 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumming"
]
1.60 ms
(1.00%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01“D…/½s4•\x19D¼Lƺq"
]
1.51 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumming"
]
1.22 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumming"
]

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.