GET https://search.jues.net/search/embeds/3?q=passionate%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.95 ms
(64.61%)
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
  421593
  439718
  442754
  456455
  467993
  480695
  480702
  481995
  485985
  486882
  488538
  492336
  496754
  498056
  503116
  503632
  507706
  516241
  517326
  517369
  517559
  517779
  520232
  520437
  522209
  525651
  526544
  527665
  556552
  561086
  565859
  566958
  569836
  580149
  580982
  593154
  598999
  600411
  605278
  605442
  609540
  611310
  613819
  616758
  616810
  620216
  620232
  668782
  714503
  806086
]
13.40 ms
(13.13%)
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:
[
  "passionate mother"
  "passionate mother"
  "passionate mother"
  20
]
12.39 ms
(12.14%)
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
  517559
  480695
  456455
  486882
  503632
  520437
  527665
  526544
  566958
  668782
  565859
  616810
  605278
  806086
  442754
  522209
  611310
  485985
  525651
  714503
  561086
  605442
  488538
  503116
  439718
  517779
  496754
  580982
  556552
  616758
  481995
  516241
  600411
  492336
  507706
  517369
  613819
  569836
  609540
  598999
  421593
  580149
  620232
  593154
  498056
  467993
  480702
  620216
  517326
  520232
]
2.62 ms
(2.56%)
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
  421593
  439718
  442754
  456455
  467993
  480695
  480702
  481995
  485985
  486882
  488538
  492336
  496754
  498056
  503116
  503632
  507706
  516241
  517326
  517369
  517559
  517779
  520232
  520437
  522209
  525651
  526544
  527665
  556552
  561086
  565859
  566958
  569836
  580149
  580982
  593154
  598999
  600411
  605278
  605442
  609540
  611310
  613819
  616758
  616810
  620216
  620232
  668782
  714503
  806086
]
2.14 ms
(2.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "passionate мам женщин"
]
2.05 ms
(2.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "passionate mother"
]
2.04 ms
(2.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "passionate мам женщин"
]
1.48 ms
(1.45%)
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.