GET https://search.jues.net/search/embeds/4?q=swallow%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
81.29 ms
(67.97%)
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
  419912
  434470
  436933
  444838
  449954
  450851
  452324
  452699
  455837
  456695
  457629
  457884
  461635
  464661
  466376
  466557
  466757
  484283
  486870
  486876
  486911
  489323
  498670
  500210
  510855
  512846
  521785
  523154
  525682
  525941
  528263
  528882
  529144
  553992
  562763
  566295
  572337
  573800
  584752
  586615
  586658
  591176
  602618
  611299
  616089
  626405
  809413
  813084
]
17.25 ms
(14.43%)
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:
[
  "swallow pov"
  "swallow pov"
  "swallow pov"
  20
]
10.09 ms
(8.43%)
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
  813084
  452699
  525682
  466557
  489323
  486876
  626405
  809413
  466757
  528263
  500210
  510855
  521785
  444838
  566295
  611299
  436933
  456695
  457629
  464661
  455837
  512846
  528882
  584752
  586615
  461635
  452324
  419912
  484283
  457884
  466376
  450851
  486870
  434470
  498670
  486911
  523154
  529144
  449954
  602618
  573800
  572337
  586658
  562763
  616089
  553992
  591176
  525941
]
2.68 ms
(2.24%)
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
  419912
  434470
  436933
  444838
  449954
  450851
  452324
  452699
  455837
  456695
  457629
  457884
  461635
  464661
  466376
  466557
  466757
  484283
  486870
  486876
  486911
  489323
  498670
  500210
  510855
  512846
  521785
  523154
  525682
  525941
  528263
  528882
  529144
  553992
  562763
  566295
  572337
  573800
  584752
  586615
  586658
  591176
  602618
  611299
  616089
  626405
  809413
  813084
]
2.32 ms
(1.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swallow pov"
]
2.15 ms
(1.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глота пов"
]
2.05 ms
(1.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.48%)
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.