GET https://search.jues.net/search/embeds/8?q=babe%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
327.60 ms
(93.09%)
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
  8164
  30208
  84535
  186037
  284922
  377241
  384092
  385908
  386227
  391437
  397997
  398374
  398697
  401265
  401810
  402206
  402384
  403603
  406425
  414277
  414421
  422397
  423311
  425641
  426029
  428428
  428759
  434422
  435507
  435520
  445930
  446704
  451638
  464254
  466642
  467348
  468257
  468818
  471646
  479784
  480620
  481327
  482007
  483780
  489897
  493427
  494409
  502368
  507451
  510017
  511229
  511696
  519106
  528569
  538034
  542268
  545821
  547524
  551588
  553774
  559054
  560127
  560457
  563596
  564999
  569543
  570241
  570889
  578285
  588464
  595609
  598153
  599419
  607520
  645317
  649507
  656361
  658257
  658359
  659759
  670338
  671945
  676915
  677397
  696601
  698994
  716118
  720441
  720955
  721118
  721317
  722126
  722914
  730637
  733856
  736814
  737552
  739685
  742727
  758498
  770514
  778427
  784703
  785419
  786041
  786470
  787283
  798584
  800228
  804758
  805431
  807987
  810245
  810347
  811311
  812865
  814041
  817260
  817637
  823320
]
13.97 ms
(3.97%)
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
  807987
  811311
  398697
  422397
  8164
  386227
  426029
  435520
  489897
  519106
  569543
  547524
  578285
  716118
  645317
  595609
  446704
  483780
  186037
  823320
  817637
  551588
  658257
  658359
  676915
  659759
  656361
  563596
  598153
  786041
  812865
  785419
  736814
  739685
  721317
  784703
  402384
  84535
  402206
  403603
  434422
  428428
  817260
  464254
  467348
  507451
  510017
  528569
  559054
  570241
  677397
  722914
  671945
  560127
  588464
  599419
  607520
  778427
  810347
  770514
  722126
  787283
  800228
  804758
  377241
  398374
  406425
  423311
  428759
  814041
  466642
  493427
  445930
  451638
  479784
  481327
  482007
  511229
  538034
  553774
  570889
  545821
  560457
  542268
  564999
  721118
  649507
  696601
  670338
  698994
  720441
  720955
  805431
  786470
  798584
  810245
  730637
  733856
  737552
  742727
  758498
  391437
  414277
  414421
  435507
  471646
  480620
  468818
  468257
  511696
  502368
  494409
  385908
  384092
  284922
  30208
  397997
  401810
  401265
  425641
]
3.15 ms
(0.90%)
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
  8164
  30208
  84535
  186037
  284922
  377241
  384092
  385908
  386227
  391437
  397997
  398374
  398697
  401265
  401810
  402206
  402384
  403603
  406425
  414277
  414421
  422397
  423311
  425641
  426029
  428428
  428759
  434422
  435507
  435520
  445930
  446704
  451638
  464254
  466642
  467348
  468257
  468818
  471646
  479784
  480620
  481327
  482007
  483780
  489897
  493427
  494409
  502368
  507451
  510017
  511229
  511696
  519106
  528569
  538034
  542268
  545821
  547524
  551588
  553774
  559054
  560127
  560457
  563596
  564999
  569543
  570241
  570889
  578285
  588464
  595609
  598153
  599419
  607520
  645317
  649507
  656361
  658257
  658359
  659759
  670338
  671945
  676915
  677397
  696601
  698994
  716118
  720441
  720955
  721118
  721317
  722126
  722914
  730637
  733856
  736814
  737552
  739685
  742727
  758498
  770514
  778427
  784703
  785419
  786041
  786470
  787283
  798584
  800228
  804758
  805431
  807987
  810245
  810347
  811311
  812865
  814041
  817260
  817637
  823320
]
2.07 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "babe ass"
]
1.81 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "babe жоп"
]
1.70 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "babe жоп"
]

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.