GET https://search.jues.net/search/embeds?q=bbc%20bull%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.61 ms
(59.67%)
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
  78390
  397988
  430380
  449933
  481672
  484054
  496527
  519105
  523114
  535071
  535082
  574460
  577108
  578757
  585752
  586253
  604545
  605557
  605562
  605696
  606725
  628590
  630696
  632386
  632924
  633992
  641481
  650882
  651001
  664151
  664436
  684293
  691717
  691724
  691729
  691731
  697608
  700819
  719827
  719862
  719901
  719985
  720163
  720187
  732623
  732857
  732868
  735860
  738854
  745548
  808298
]
21.70 ms
(23.29%)
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:
[
  "bbc bull wife"
  "bbc bull wife"
  "bbc bull wife"
  20
]
7.48 ms
(8.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
  700819
  745548
  641481
  632386
  735860
  719985
  684293
  628590
  535082
  535071
  651001
  732857
  697608
  664436
  78390
  738854
  691717
  605696
  691729
  732868
  630696
  808298
  397988
  719827
  691731
  732623
  664151
  720163
  719901
  484054
  586253
  720187
  430380
  719862
  606725
  633992
  578757
  650882
  691724
  585752
  574460
  523114
  605562
  632924
  604545
  496527
  519105
  481672
  605557
  449933
  577108
]
2.00 ms
(2.15%)
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
  78390
  397988
  430380
  449933
  481672
  484054
  496527
  519105
  523114
  535071
  535082
  574460
  577108
  578757
  585752
  586253
  604545
  605557
  605562
  605696
  606725
  628590
  630696
  632386
  632924
  633992
  641481
  650882
  651001
  664151
  664436
  684293
  691717
  691724
  691729
  691731
  697608
  700819
  719827
  719862
  719901
  719985
  720163
  720187
  732623
  732857
  732868
  735860
  738854
  745548
  808298
]
1.94 ms
(2.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc bull wife"
]
1.72 ms
(1.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc bull жен"
]
1.25 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc bull жен"
]

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.