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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
95.85 ms
(67.50%)
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
  420565
  423913
  432650
  439710
  440657
  442533
  448561
  459485
  464702
  467758
  469651
  476015
  479931
  480888
  481461
  482945
  483424
  486820
  487472
  488550
  488571
  488867
  492567
  493017
  493191
  496566
  497062
  504183
  504186
  506794
  507703
  511033
  512086
  516819
  517261
  517769
  521502
  521507
  523465
  524174
  524833
  527391
  528144
  554234
  555973
  555995
  556470
  557226
  557941
  596978
  602716
  605559
  615817
  621887
  625127
  649211
  713630
  756735
  783215
  806247
]
26.86 ms
(18.91%)
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:
[
  "home hidden amateur"
  "home hidden amateur"
  "home hidden amateur"
  20
]
9.60 ms
(6.76%)
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
  527391
  523465
  480888
  479931
  596978
  420565
  469651
  467758
  482945
  497062
  625127
  806247
  440657
  448561
  488550
  554234
  555995
  649211
  524833
  483424
  713630
  492567
  555973
  493191
  493017
  621887
  488571
  517261
  512086
  516819
  488867
  506794
  439710
  783215
  521502
  557226
  557941
  487472
  476015
  504186
  504183
  521507
  423913
  756735
  442533
  464702
  496566
  486820
  524174
  481461
  605559
  507703
  615817
  517769
  459485
  432650
  528144
  602716
  511033
  556470
]
2.40 ms
(1.69%)
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
  420565
  423913
  432650
  439710
  440657
  442533
  448561
  459485
  464702
  467758
  469651
  476015
  479931
  480888
  481461
  482945
  483424
  486820
  487472
  488550
  488571
  488867
  492567
  493017
  493191
  496566
  497062
  504183
  504186
  506794
  507703
  511033
  512086
  516819
  517261
  517769
  521502
  521507
  523465
  524174
  524833
  527391
  528144
  554234
  555973
  555995
  556470
  557226
  557941
  596978
  602716
  605559
  615817
  621887
  625127
  649211
  713630
  756735
  783215
  806247
]
1.99 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "home скрыт любительск"
]
1.85 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "home скрыт любительск"
]
1.81 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home hidden amateur"
]

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.