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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.14 ms
(44.16%)
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
  382530
  382798
  387113
  401602
  402001
  404052
  419443
  424505
  426084
  430709
  437857
  438018
  445416
  445681
  446906
  447540
  450988
  452182
  453415
  477546
  478883
  490827
  491676
  497362
  499746
  505897
  509451
  517464
  521813
  521925
  526494
  532893
  538915
  546634
  548175
  551736
  570407
  576310
  576730
  577076
  598499
  605758
  623820
  644266
  649905
  704729
  721843
  744279
  747140
  750064
  811947
  821449
  827940
  827942
]
74.45 ms
(43.76%)
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 lesbians"
  "sex lesbians"
  "sex lesbians"
  20
]
10.75 ms
(6.32%)
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
  387113
  404052
  577076
  811947
  382798
  505897
  548175
  827940
  827942
  382530
  721843
  744279
  490827
  598499
  509451
  499746
  546634
  447540
  478883
  521925
  437857
  821449
  649905
  704729
  644266
  401602
  576730
  605758
  453415
  419443
  532893
  570407
  538915
  450988
  491676
  446906
  497362
  452182
  426084
  521813
  517464
  747140
  424505
  477546
  750064
  526494
  623820
  402001
  445681
  430709
  438018
  551736
  445416
  576310
]
2.52 ms
(1.48%)
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
  382530
  382798
  387113
  401602
  402001
  404052
  419443
  424505
  426084
  430709
  437857
  438018
  445416
  445681
  446906
  447540
  450988
  452182
  453415
  477546
  478883
  490827
  491676
  497362
  499746
  505897
  509451
  517464
  521813
  521925
  526494
  532893
  538915
  546634
  548175
  551736
  570407
  576310
  576730
  577076
  598499
  605758
  623820
  644266
  649905
  704729
  721843
  744279
  747140
  750064
  811947
  821449
  827940
  827942
]
1.95 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex lesbians"
]
1.80 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс lesbians"
]
1.61 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс lesbians"
]

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.