GET https://search.jues.net/search/embeds/8?q=homemade%20party

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.98 ms
(73.82%)
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
  421172
  428142
  439516
  439649
  444692
  445706
  452199
  456427
  462535
  465024
  468433
  469030
  469764
  472674
  472793
  473807
  474020
  476797
  482530
  485002
  486377
  486569
  497579
  497885
  500904
  501414
  510157
  513338
  516375
  518243
  520448
  520954
  526948
  527195
  532676
  539008
  540910
  542049
  542056
  542062
  543419
  543421
  551480
  568762
  574527
  578587
  583370
  586591
  587896
  590651
  591169
  597240
  599888
  605151
  605374
  611477
  611558
  614752
  621784
  622044
  775819
]
19.47 ms
(11.14%)
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:
[
  "homemade party"
  "homemade party"
  "homemade party"
  20
]
15.00 ms
(8.59%)
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
  469764
  497885
  439516
  444692
  456427
  472674
  510157
  540910
  542056
  542062
  568762
  543421
  551480
  445706
  473807
  485002
  501414
  486377
  462535
  518243
  578587
  586591
  465024
  539008
  542049
  439649
  469030
  520448
  482530
  583370
  622044
  421172
  497579
  516375
  605374
  468433
  621784
  611477
  614752
  532676
  452199
  526948
  775819
  428142
  599888
  513338
  590651
  591169
  472793
  520954
  500904
  476797
  474020
  527195
  605151
  486569
  574527
  587896
  543419
  597240
  611558
]
3.38 ms
(1.93%)
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
  421172
  428142
  439516
  439649
  444692
  445706
  452199
  456427
  462535
  465024
  468433
  469030
  469764
  472674
  472793
  473807
  474020
  476797
  482530
  485002
  486377
  486569
  497579
  497885
  500904
  501414
  510157
  513338
  516375
  518243
  520448
  520954
  526948
  527195
  532676
  539008
  540910
  542049
  542056
  542062
  543419
  543421
  551480
  568762
  574527
  578587
  583370
  586591
  587896
  590651
  591169
  597240
  599888
  605151
  605374
  611477
  611558
  614752
  621784
  622044
  775819
]
2.07 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade party"
]
1.97 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск party"
]
1.79 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск party"
]

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.