GET https://search.jues.net/search/embeds?q=3%20%D0%B1%D0%B0%D0%B1%D1%8B%20%D0%B8%20%D0%BC%D1%83%D0%B6%D0%B8%D0%BA

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.48 ms
(76.00%)
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
  44968
  58237
  188453
  391941
  395845
  397891
  405913
  409405
  411436
  417349
  419625
  420877
  422996
  423658
  428769
  432779
  443979
  444231
  445880
  446330
  453162
  453858
  456174
  457170
  458523
  458786
  459026
  459263
  470551
  472286
  477467
  479866
  479978
  483368
  484564
  485149
  486751
  492455
  495064
  495154
  495818
  500348
  504165
  510675
  514809
  519434
  521418
  521453
  548606
  559061
  565300
  580775
  580869
  604051
]
19.34 ms
(11.44%)
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:
[
  "3 бабы и мужик"
  "3 бабы и мужик"
  "3 бабы и мужик"
  20
]
11.36 ms
(6.72%)
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
  432779
  500348
  58237
  44968
  443979
  397891
  428769
  486751
  409405
  188453
  456174
  459263
  565300
  470551
  495154
  604051
  485149
  411436
  420877
  477467
  519434
  504165
  453858
  405913
  459026
  445880
  395845
  423658
  444231
  458786
  472286
  580869
  458523
  446330
  457170
  495818
  419625
  391941
  510675
  521418
  484564
  479978
  479866
  580775
  495064
  483368
  548606
  559061
  514809
  422996
  453162
  492455
  417349
  521453
]
2.92 ms
(1.73%)
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
  44968
  58237
  188453
  391941
  395845
  397891
  405913
  409405
  411436
  417349
  419625
  420877
  422996
  423658
  428769
  432779
  443979
  444231
  445880
  446330
  453162
  453858
  456174
  457170
  458523
  458786
  459026
  459263
  470551
  472286
  477467
  479866
  479978
  483368
  484564
  485149
  486751
  492455
  495064
  495154
  495818
  500348
  504165
  510675
  514809
  519434
  521418
  521453
  548606
  559061
  565300
  580775
  580869
  604051
]
1.99 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "3 бабы и мужик"
]
1.69 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "3 женскийрод мужчин"
]
1.64 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "3 женскийрод мужчин"
]
1.63 ms
(0.97%)
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.