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

Query Metrics

8 Database Queries
8 Different statements
108.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
62.14 ms
(57.16%)
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
  411854
  448713
  455977
  456393
  458905
  460734
  460738
  464326
  465378
  466073
  466074
  466097
  466107
  484653
  492111
  499104
  505132
  506211
  511517
  511595
  514576
  514715
  514717
  516938
  517654
  521239
  521586
  524696
  524943
  532343
  541846
  541849
  555805
  556046
  559577
  583981
  587542
  590579
  590893
  600401
  632693
  633126
  633521
  633819
  634131
  634140
  637148
  640755
  646176
  646451
  651599
  668534
  676088
  681310
  719336
  739532
  778307
]
26.79 ms
(24.65%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "milf and guys"
  "milf and guys"
  "milf and guys"
  20
]
9.82 ms
(9.03%)
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
  646451
  681310
  719336
  634131
  600401
  590579
  640755
  587542
  739532
  633521
  411854
  466074
  511517
  455977
  458905
  448713
  456393
  514715
  514576
  521586
  532343
  541846
  541849
  651599
  668534
  633819
  778307
  460734
  465378
  466073
  466107
  524943
  506211
  511595
  484653
  517654
  521239
  559577
  583981
  676088
  555805
  590893
  632693
  633126
  460738
  466097
  499104
  505132
  556046
  646176
  464326
  492111
  516938
  514717
  524696
  634140
  637148
]
2.93 ms
(2.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf and guys"
]
2.24 ms
(2.06%)
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
  411854
  448713
  455977
  456393
  458905
  460734
  460738
  464326
  465378
  466073
  466074
  466097
  466107
  484653
  492111
  499104
  505132
  506211
  511517
  511595
  514576
  514715
  514717
  516938
  517654
  521239
  521586
  524696
  524943
  532343
  541846
  541849
  555805
  556046
  559577
  583981
  587542
  590579
  590893
  600401
  632693
  633126
  633521
  633819
  634131
  634140
  637148
  640755
  646176
  646451
  651599
  668534
  676088
  681310
  719336
  739532
  778307
]
1.89 ms
(1.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf guys"
]
1.51 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf guys"
]
1.39 ms
(1.27%)
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.