GET https://search.jues.net/search/embeds/4?q=homemade%20amateur%20s

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.89 ms
(60.45%)
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
  401126
  419524
  424424
  450847
  451263
  451508
  451520
  452180
  453547
  453710
  453725
  453959
  456482
  459588
  471046
  474129
  476332
  477048
  480354
  482570
  484499
  485634
  486870
  492319
  501193
  508419
  509377
  510596
  511308
  514653
  515893
  516222
  516310
  516876
  518231
  525142
  527868
  548067
  559934
  560547
  563692
  576267
  582062
  582249
  586594
  592817
  593875
  630771
  631603
  661300
  679004
  812795
]
20.45 ms
(19.66%)
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:
[
  "homemade amateur s"
  "homemade amateur s"
  "homemade amateur s"
  20
]
11.58 ms
(11.13%)
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
  474129
  563692
  576267
  459588
  476332
  452180
  509377
  508419
  516876
  451508
  453547
  456482
  661300
  501193
  518231
  484499
  631603
  527868
  516222
  559934
  592817
  453725
  451520
  453959
  515893
  453710
  480354
  482570
  525142
  560547
  582062
  516310
  586594
  424424
  451263
  511308
  492319
  401126
  477048
  630771
  514653
  593875
  471046
  679004
  450847
  486870
  582249
  812795
  510596
  419524
  485634
  548067
]
2.53 ms
(2.43%)
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
  401126
  419524
  424424
  450847
  451263
  451508
  451520
  452180
  453547
  453710
  453725
  453959
  456482
  459588
  471046
  474129
  476332
  477048
  480354
  482570
  484499
  485634
  486870
  492319
  501193
  508419
  509377
  510596
  511308
  514653
  515893
  516222
  516310
  516876
  518231
  525142
  527868
  548067
  559934
  560547
  563692
  576267
  582062
  582249
  586594
  592817
  593875
  630771
  631603
  661300
  679004
  812795
]
1.94 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade amateur s"
]
1.67 ms
(1.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск любительск s"
]
1.55 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск любительск s"
]
1.43 ms
(1.38%)
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.