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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.72 ms
(53.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs hot"
]
165.34 ms
(40.63%)
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
  6813
  30515
  54088
  91512
  122661
  132984
  205011
  308096
  384315
  386558
  422464
  454989
  456072
  457594
  457631
  457946
  458506
  466484
  476662
  496709
  520708
  542333
  554919
  556592
  559171
  561488
  566728
  581456
  593021
  597158
  600469
  600831
  608439
  615700
  617115
  625907
  628597
  639801
  647991
  650317
  651066
  663362
  665184
  667617
  668978
  670946
  672885
  679708
  680541
  680573
  683278
  687616
  694147
  699409
  702094
  708149
  710368
  713580
  718079
  721734
  724921
  726609
  728643
  728649
  730469
  731807
  734109
  743640
  750454
  752834
  757447
  759489
  760595
  767621
  769217
  772096
  772547
  772552
  772631
  775631
  778182
  784611
  785433
  786794
  794025
  796514
  798826
  798829
  798833
  798845
  801425
  801757
  802316
  804414
  805730
  807854
  807861
  808307
  811094
  814458
  814723
  816459
  816659
  816806
  818047
  818434
  819404
  819437
  820787
  821524
  822313
  823737
  824160
  825401
  825412
  826017
  827241
  828381
  828588
  828847
]
15.96 ms
(3.92%)
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
  804414
  811094
  728649
  767621
  794025
  808307
  772631
  730469
  759489
  769217
  734109
  757447
  726609
  728643
  743640
  608439
  775631
  778182
  784611
  786794
  801425
  91512
  386558
  6813
  308096
  556592
  687616
  702094
  667617
  651066
  680541
  798845
  802316
  796514
  772096
  805730
  807854
  785433
  798826
  807861
  458506
  456072
  520708
  561488
  699409
  593021
  617115
  597158
  724921
  457946
  422464
  205011
  814723
  457594
  454989
  566728
  713580
  680573
  710368
  581456
  639801
  615700
  772547
  731807
  750454
  752834
  772552
  760595
  798829
  798833
  801757
  457631
  384315
  122661
  132984
  30515
  54088
  814458
  818434
  825401
  826017
  816659
  819404
  821524
  823737
  827241
  816459
  818047
  820787
  822313
  816806
  819437
  824160
  825412
  828381
  828847
  828588
  476662
  466484
  496709
  559171
  542333
  554919
  679708
  683278
  708149
  647991
  665184
  668978
  670946
  694147
  718079
  650317
  663362
  672885
  721734
  628597
  600831
  600469
  625907
]
3.57 ms
(0.88%)
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
  6813
  30515
  54088
  91512
  122661
  132984
  205011
  308096
  384315
  386558
  422464
  454989
  456072
  457594
  457631
  457946
  458506
  466484
  476662
  496709
  520708
  542333
  554919
  556592
  559171
  561488
  566728
  581456
  593021
  597158
  600469
  600831
  608439
  615700
  617115
  625907
  628597
  639801
  647991
  650317
  651066
  663362
  665184
  667617
  668978
  670946
  672885
  679708
  680541
  680573
  683278
  687616
  694147
  699409
  702094
  708149
  710368
  713580
  718079
  721734
  724921
  726609
  728643
  728649
  730469
  731807
  734109
  743640
  750454
  752834
  757447
  759489
  760595
  767621
  769217
  772096
  772547
  772552
  772631
  775631
  778182
  784611
  785433
  786794
  794025
  796514
  798826
  798829
  798833
  798845
  801425
  801757
  802316
  804414
  805730
  807854
  807861
  808307
  811094
  814458
  814723
  816459
  816659
  816806
  818047
  818434
  819404
  819437
  820787
  821524
  822313
  823737
  824160
  825401
  825412
  826017
  827241
  828381
  828588
  828847
]
2.38 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs hot"
]
2.03 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs hot"
]
1.91 ms
(0.47%)
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.