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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
340.83 ms
(93.28%)
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
  20617
  98711
  197511
  213205
  233618
  387186
  388022
  390839
  428710
  429825
  505454
  520524
  524604
  546674
  558726
  562232
  564576
  568651
  572112
  582321
  593196
  593261
  594871
  597725
  600822
  601115
  604461
  623633
  624067
  624703
  627212
  629552
  630777
  641319
  650968
  655241
  658121
  668174
  674245
  689908
  689943
  693454
  698814
  699642
  704222
  706433
  713085
  723848
  724168
  724991
  728877
  729789
  730078
  730855
  731094
  739959
  741764
  744791
  745991
  749845
  750671
  751780
  752852
  755367
  755495
  756223
  758310
  758511
  759711
  760358
  762879
  765308
  765997
  768392
  768834
  771166
  773151
  774215
  775617
  780906
  780968
  782710
  783210
  783265
  783297
  783375
  786431
  787182
  789474
  791678
  792547
  793894
  795743
  797477
  797824
  798956
  801309
  801407
  802613
  803018
  804257
  806139
  807134
  808249
  809295
  812801
  813026
  813856
  813895
  815569
  817039
  818723
  819181
  819803
  821374
  823475
  825526
  826125
  826678
  826680
]
15.00 ms
(4.11%)
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
  213205
  755367
  826678
  817039
  629552
  821374
  826680
  825526
  826125
  752852
  819803
  813856
  524604
  693454
  674245
  572112
  793894
  745991
  724991
  786431
  815569
  505454
  546674
  689908
  750671
  731094
  751780
  773151
  803018
  233618
  741764
  582321
  600822
  601115
  630777
  197511
  98711
  819181
  813895
  564576
  658121
  597725
  593261
  623633
  780906
  791678
  812801
  730855
  765997
  768834
  723848
  762879
  749845
  604461
  713085
  787182
  802613
  806139
  818723
  558726
  562232
  698814
  594871
  593196
  797824
  809295
  783265
  783375
  789474
  801309
  804257
  758310
  758511
  760358
  783210
  797477
  755495
  765308
  771166
  706433
  428710
  780968
  823475
  689943
  650968
  668174
  699642
  655241
  641319
  624067
  624703
  627212
  795743
  807134
  808249
  813026
  724168
  729789
  730078
  782710
  792547
  798956
  801407
  744791
  756223
  774215
  728877
  759711
  768392
  739959
  775617
  783297
  387186
  20617
  429825
  388022
  704222
  390839
  520524
  568651
]
2.67 ms
(0.73%)
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
  20617
  98711
  197511
  213205
  233618
  387186
  388022
  390839
  428710
  429825
  505454
  520524
  524604
  546674
  558726
  562232
  564576
  568651
  572112
  582321
  593196
  593261
  594871
  597725
  600822
  601115
  604461
  623633
  624067
  624703
  627212
  629552
  630777
  641319
  650968
  655241
  658121
  668174
  674245
  689908
  689943
  693454
  698814
  699642
  704222
  706433
  713085
  723848
  724168
  724991
  728877
  729789
  730078
  730855
  731094
  739959
  741764
  744791
  745991
  749845
  750671
  751780
  752852
  755367
  755495
  756223
  758310
  758511
  759711
  760358
  762879
  765308
  765997
  768392
  768834
  771166
  773151
  774215
  775617
  780906
  780968
  782710
  783210
  783265
  783297
  783375
  786431
  787182
  789474
  791678
  792547
  793894
  795743
  797477
  797824
  798956
  801309
  801407
  802613
  803018
  804257
  806139
  807134
  808249
  809295
  812801
  813026
  813856
  813895
  815569
  817039
  818723
  819181
  819803
  821374
  823475
  825526
  826125
  826678
  826680
]
1.94 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot and sexy"
]
1.81 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot sexy"
]
1.71 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot sexy"
]

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.