GET https://search.jues.net/search/embeds?q=%D1%82%D1%80%D0%BE%D0%B5%20%D0%BC%D0%B6%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
72.33 ms
(58.94%)
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
  429774
  571201
  588745
  590437
  605616
  612066
  614344
  619439
  631329
  636510
  645273
  645493
  648943
  648952
  648984
  649112
  649127
  661354
  661567
  667486
  669408
  677081
  703096
  716017
  718376
  718421
  726799
  727717
  727850
  728169
  730409
  730797
  731058
  734385
  737099
  741280
  742663
  742675
  742677
  742683
  742684
  742691
  742874
  743906
  749266
  749488
  755011
  755170
  775054
  790955
  790971
  794247
  801886
  802651
]
33.93 ms
(27.65%)
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:
[
  "трое мжм"
  "трое мжм"
  "трое мжм"
  20
]
7.51 ms
(6.12%)
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
  648943
  648952
  802651
  742874
  790971
  730797
  649112
  645493
  648984
  649127
  716017
  775054
  790955
  727850
  731058
  636510
  742691
  737099
  677081
  429774
  718421
  631329
  742684
  728169
  669408
  726799
  741280
  730409
  661354
  718376
  742675
  755011
  794247
  742677
  703096
  727717
  645273
  612066
  755170
  743906
  749488
  661567
  742683
  734385
  742663
  605616
  749266
  801886
  667486
  588745
  614344
  590437
  571201
  619439
]
2.29 ms
(1.87%)
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
  429774
  571201
  588745
  590437
  605616
  612066
  614344
  619439
  631329
  636510
  645273
  645493
  648943
  648952
  648984
  649112
  649127
  661354
  661567
  667486
  669408
  677081
  703096
  716017
  718376
  718421
  726799
  727717
  727850
  728169
  730409
  730797
  731058
  734385
  737099
  741280
  742663
  742675
  742677
  742683
  742684
  742691
  742874
  743906
  749266
  749488
  755011
  755170
  775054
  790955
  790971
  794247
  801886
  802651
]
2.14 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трое мжм"
]
1.63 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тро мжм секс втро"
]
1.48 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.