GET https://search.jues.net/search/embeds/4?q=new%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.52 ms
(85.10%)
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
  388350
  407658
  409324
  411914
  418894
  440933
  443627
  446993
  451013
  452397
  460182
  465865
  466796
  475466
  476316
  479837
  486197
  488171
  489842
  499861
  500542
  503472
  505979
  508535
  510923
  510995
  512816
  517026
  520152
  522721
  523419
  527230
  529674
  532980
  537100
  537587
  537927
  541394
  543433
  544893
  545052
  547659
  549691
  550379
  551070
  552336
  555647
  558368
  560248
  566403
  567411
  569539
  576657
  576662
  577250
  580275
  580500
  582396
  583821
  584872
  586397
  588065
  588323
  590376
  590615
  591058
  591383
  591667
  594570
  595323
  601023
  606757
  618291
  622665
  623642
  626434
  634826
  637673
  647372
  648762
  663258
  664166
  669200
  675125
  688083
  697004
  698214
  714089
  714623
  714900
  715455
  723444
  726001
  726975
  737070
  739529
  759133
  767458
  768024
  768586
  771832
  778471
  785148
  785711
  786312
  787636
  789636
  796986
  802318
  807855
  808223
  808242
  808484
  810798
  811729
  814887
  815440
  815466
  818815
  827918
]
16.41 ms
(8.81%)
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
  499861
  510995
  537587
  510923
  522721
  576657
  714089
  723444
  663258
  697004
  648762
  715455
  551070
  566403
  590376
  606757
  623642
  594570
  591058
  601023
  591383
  595323
  789636
  810798
  808223
  811729
  739529
  759133
  785711
  787636
  796986
  802318
  808242
  768586
  726975
  767458
  726001
  737070
  768024
  771832
  698214
  807855
  808484
  409324
  388350
  503472
  488171
  407658
  443627
  411914
  418894
  440933
  814887
  815466
  815440
  818815
  827918
  452397
  475466
  479837
  489842
  446993
  451013
  460182
  476316
  505979
  512816
  520152
  529674
  517026
  527230
  532980
  500542
  508535
  537100
  523419
  537927
  465865
  466796
  486197
  541394
  543433
  545052
  577250
  549691
  550379
  558368
  560248
  576662
  582396
  584872
  544893
  547659
  552336
  669200
  675125
  714623
  714900
  647372
  664166
  688083
  555647
  567411
  569539
  580275
  580500
  583821
  588065
  588323
  626434
  590615
  586397
  622665
  637673
  591667
  618291
  634826
  778471
  785148
  786312
]
3.97 ms
(2.13%)
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
  388350
  407658
  409324
  411914
  418894
  440933
  443627
  446993
  451013
  452397
  460182
  465865
  466796
  475466
  476316
  479837
  486197
  488171
  489842
  499861
  500542
  503472
  505979
  508535
  510923
  510995
  512816
  517026
  520152
  522721
  523419
  527230
  529674
  532980
  537100
  537587
  537927
  541394
  543433
  544893
  545052
  547659
  549691
  550379
  551070
  552336
  555647
  558368
  560248
  566403
  567411
  569539
  576657
  576662
  577250
  580275
  580500
  582396
  583821
  584872
  586397
  588065
  588323
  590376
  590615
  591058
  591383
  591667
  594570
  595323
  601023
  606757
  618291
  622665
  623642
  626434
  634826
  637673
  647372
  648762
  663258
  664166
  669200
  675125
  688083
  697004
  698214
  714089
  714623
  714900
  715455
  723444
  726001
  726975
  737070
  739529
  759133
  767458
  768024
  768586
  771832
  778471
  785148
  785711
  786312
  787636
  789636
  796986
  802318
  807855
  808223
  808242
  808484
  810798
  811729
  814887
  815440
  815466
  818815
  827918
]
2.19 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "new milf"
]
1.83 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "new milf"
]
1.76 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "new milf"
]

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.