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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.12 ms
(38.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf любительск gaping"
]
204.77 ms
(36.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
87.35 ms
(15.74%)
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
  389966
  391911
  391945
  392023
  395970
  404028
  413058
  414125
  418148
  420129
  423350
  424397
  424765
  429880
  429889
  429890
  429899
  429900
  433038
  445409
  448464
  454274
  458281
  476981
  491436
  494231
  494233
  497675
  507284
  510425
  510803
  513209
  517724
  524389
  525468
  542127
  560666
  571809
  575601
  580597
  586219
  586688
  602793
  603612
  604426
  604545
  605219
  605725
  605746
  622693
  634108
  772535
]
29.02 ms
(5.23%)
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 amateur gaping"
  "milf amateur gaping"
  "milf amateur gaping"
  20
]
13.08 ms
(2.36%)
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
  575601
  580597
  604545
  413058
  424765
  605219
  634108
  458281
  513209
  542127
  772535
  602793
  392023
  391945
  404028
  476981
  525468
  420129
  424397
  418148
  429880
  510425
  491436
  391911
  433038
  448464
  510803
  517724
  429890
  414125
  429889
  497675
  586688
  423350
  454274
  494233
  507284
  571809
  560666
  604426
  605725
  445409
  429899
  389966
  429900
  395970
  524389
  494231
  603612
  586219
  605746
  622693
]
2.97 ms
(0.54%)
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
  389966
  391911
  391945
  392023
  395970
  404028
  413058
  414125
  418148
  420129
  423350
  424397
  424765
  429880
  429889
  429890
  429899
  429900
  433038
  445409
  448464
  454274
  458281
  476981
  491436
  494231
  494233
  497675
  507284
  510425
  510803
  513209
  517724
  524389
  525468
  542127
  560666
  571809
  575601
  580597
  586219
  586688
  602793
  603612
  604426
  604545
  605219
  605725
  605746
  622693
  634108
  772535
]
2.01 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf amateur gaping"
]
1.76 ms
(0.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf любительск gaping"
]

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.