GET https://search.jues.net/search/embeds/2?q=sex%20american

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.47 ms
(51.55%)
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
  263335
  418648
  420525
  425321
  443171
  449362
  454663
  456613
  459130
  461211
  464634
  466481
  469182
  481789
  484795
  510358
  511393
  512071
  513042
  519727
  522380
  522395
  522397
  522405
  522414
  525962
  527598
  527999
  529468
  530500
  531489
  534774
  534999
  535012
  536868
  542597
  542861
  543440
  543508
  545814
  560190
  561140
  565924
  566079
  566308
  576722
  578028
  592974
  603047
  607509
  617422
  633540
  808865
]
40.13 ms
(31.60%)
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:
[
  "sex american"
  "sex american"
  "sex american"
  20
]
10.87 ms
(8.56%)
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
  527999
  525962
  529468
  522397
  542597
  578028
  633540
  418648
  510358
  607509
  535012
  263335
  536868
  454663
  522405
  522395
  565924
  511393
  534999
  459130
  464634
  484795
  456613
  545814
  566308
  592974
  443171
  420525
  530500
  542861
  469182
  522380
  531489
  576722
  461211
  425321
  513042
  466481
  808865
  481789
  561140
  543440
  512071
  534774
  449362
  527598
  519727
  560190
  522414
  617422
  543508
  566079
  603047
]
2.90 ms
(2.29%)
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
  263335
  418648
  420525
  425321
  443171
  449362
  454663
  456613
  459130
  461211
  464634
  466481
  469182
  481789
  484795
  510358
  511393
  512071
  513042
  519727
  522380
  522395
  522397
  522405
  522414
  525962
  527598
  527999
  529468
  530500
  531489
  534774
  534999
  535012
  536868
  542597
  542861
  543440
  543508
  545814
  560190
  561140
  565924
  566079
  566308
  576722
  578028
  592974
  603047
  607509
  617422
  633540
  808865
]
2.11 ms
(1.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex american"
]
1.92 ms
(1.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс american"
]
1.82 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс american"
]

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.