GET https://search.jues.net/search/embeds/3?q=russian%20wife%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.32 ms
(56.47%)
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
  424660
  437811
  442841
  455912
  457783
  460734
  462700
  464327
  466094
  466103
  469764
  474678
  474702
  476251
  477705
  484463
  484653
  484661
  484665
  484696
  485703
  495741
  504165
  504183
  506047
  510742
  511023
  550230
  550232
  550233
  550484
  557985
  562358
  562368
  568315
  569413
  574762
  575173
  579620
  583500
  587864
  598024
  609196
  615696
  621612
  627652
  655705
  671863
  730798
]
34.10 ms
(25.56%)
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:
[
  "russian wife group"
  "russian wife group"
  "russian wife group"
  20
]
13.32 ms
(9.99%)
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
  460734
  424660
  477705
  466103
  484653
  484661
  455912
  511023
  484696
  550233
  671863
  615696
  557985
  464327
  457783
  462700
  466094
  484665
  495741
  510742
  621612
  484463
  579620
  550484
  575173
  550232
  574762
  568315
  562368
  437811
  474678
  550230
  730798
  485703
  598024
  476251
  469764
  504183
  504165
  506047
  569413
  442841
  655705
  583500
  474702
  627652
  609196
  562358
  587864
]
3.08 ms
(2.31%)
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
  424660
  437811
  442841
  455912
  457783
  460734
  462700
  464327
  466094
  466103
  469764
  474678
  474702
  476251
  477705
  484463
  484653
  484661
  484665
  484696
  485703
  495741
  504165
  504183
  506047
  510742
  511023
  550230
  550232
  550233
  550484
  557985
  562358
  562368
  568315
  569413
  574762
  575173
  579620
  583500
  587864
  598024
  609196
  615696
  621612
  627652
  655705
  671863
  730798
]
2.24 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife group"
]
1.90 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен group"
]
1.61 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск жен group"
]

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.