GET https://search.jues.net/search/embeds/2?q=milf%20night

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.42 ms
(52.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf night"
]
172.71 ms
(41.78%)
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
  66907
  154374
  384470
  398830
  400747
  401190
  402137
  420007
  433448
  437361
  441838
  448685
  451013
  453084
  454288
  460471
  460553
  468516
  479357
  479391
  482249
  489287
  496279
  507910
  519271
  520192
  527778
  528349
  528779
  531397
  533715
  534232
  534304
  537494
  539051
  545516
  561581
  562192
  562844
  566971
  574466
  579555
  579870
  582457
  584267
  586309
  587721
  587745
  588208
  599243
  602892
  603522
  604343
  605107
  605157
  606070
  606156
  606886
  615946
  616002
  617330
  618201
  621788
  622323
  626067
  628609
  635788
  639686
  641212
  644664
  651155
  659078
  669391
  677823
  678862
  680959
  697199
  705724
  707457
  708905
  710303
  711997
  712122
  712639
  714309
  717115
  719776
  725062
  726160
  727205
  728558
  729751
  729903
  730543
  734609
  737449
  746569
  748710
  751581
  762437
  765701
  786309
  790012
  791742
  793350
  793528
  794921
  795015
  795743
  795782
  798636
  799602
  803686
  806383
  812055
  812944
  813541
  815207
  815450
  817948
]
15.23 ms
(3.68%)
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
  795743
  812944
  730543
  734609
  746569
  737449
  705724
  507910
  712122
  639686
  794921
  482249
  528349
  815450
  817948
  496279
  537494
  460553
  566971
  584267
  697199
  707457
  719776
  617330
  605157
  586309
  628609
  635788
  793350
  795782
  813541
  728558
  791742
  726160
  727205
  710303
  717115
  790012
  793528
  398830
  420007
  479357
  468516
  460471
  519271
  400747
  815207
  531397
  534232
  520192
  527778
  562192
  712639
  606070
  618201
  622323
  748710
  762437
  765701
  795015
  799602
  725062
  729903
  751581
  786309
  806383
  479391
  454288
  605107
  714309
  401190
  433448
  489287
  448685
  533715
  545516
  582457
  561581
  680959
  711997
  659078
  587721
  606886
  587745
  602892
  641212
  798636
  812055
  729751
  803686
  621788
  644664
  708905
  384470
  154374
  66907
  402137
  441838
  437361
  451013
  453084
  539051
  534304
  528779
  579555
  574466
  579870
  669391
  677823
  678862
  651155
  562844
  588208
  604343
  603522
  616002
  626067
  615946
  599243
  606156
]
3.57 ms
(0.86%)
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
  66907
  154374
  384470
  398830
  400747
  401190
  402137
  420007
  433448
  437361
  441838
  448685
  451013
  453084
  454288
  460471
  460553
  468516
  479357
  479391
  482249
  489287
  496279
  507910
  519271
  520192
  527778
  528349
  528779
  531397
  533715
  534232
  534304
  537494
  539051
  545516
  561581
  562192
  562844
  566971
  574466
  579555
  579870
  582457
  584267
  586309
  587721
  587745
  588208
  599243
  602892
  603522
  604343
  605107
  605157
  606070
  606156
  606886
  615946
  616002
  617330
  618201
  621788
  622323
  626067
  628609
  635788
  639686
  641212
  644664
  651155
  659078
  669391
  677823
  678862
  680959
  697199
  705724
  707457
  708905
  710303
  711997
  712122
  712639
  714309
  717115
  719776
  725062
  726160
  727205
  728558
  729751
  729903
  730543
  734609
  737449
  746569
  748710
  751581
  762437
  765701
  786309
  790012
  791742
  793350
  793528
  794921
  795015
  795743
  795782
  798636
  799602
  803686
  806383
  812055
  812944
  813541
  815207
  815450
  817948
]
2.06 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf night"
]
1.77 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf night"
]

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.