GET https://search.jues.net/search/embeds?q=while%20sleeping%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.25 ms
(61.58%)
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
  384282
  395320
  396772
  398164
  404078
  412618
  413934
  435745
  437343
  442410
  445709
  446269
  446311
  447550
  454869
  455788
  460177
  464442
  512843
  512952
  516102
  516782
  517240
  521759
  526894
  556991
  567855
  575241
  583457
  585323
  618982
  619107
  680854
  691819
  730934
  743738
  745751
  760193
  771741
  775767
  788866
  800934
  803562
  808060
  810062
  813552
  817737
  824316
  824810
]
66.04 ms
(19.07%)
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
  384282
  395320
  396772
  398164
  404078
  412618
  413934
  435745
  437343
  442410
  445709
  446269
  446311
  447550
  454869
  455788
  460177
  464442
  512843
  512952
  516102
  516782
  517240
  521759
  526894
  556991
  567855
  575241
  583457
  585323
  618982
  619107
  680854
  691819
  730934
  743738
  745751
  760193
  771741
  775767
  788866
  800934
  803562
  808060
  810062
  813552
  817737
  824316
  824810
]
47.01 ms
(13.58%)
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:
[
  "while sleeping mom"
  "while sleeping mom"
  "while sleeping mom"
  20
]
12.99 ms
(3.75%)
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
  771741
  775767
  404078
  817737
  691819
  384282
  743738
  810062
  395320
  396772
  447550
  445709
  803562
  800934
  442410
  813552
  454869
  680854
  760193
  730934
  446311
  745751
  455788
  556991
  398164
  437343
  824316
  460177
  446269
  585323
  512843
  435745
  618982
  788866
  521759
  808060
  517240
  824810
  583457
  526894
  516782
  567855
  516102
  575241
  412618
  464442
  413934
  619107
  512952
]
1.98 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "while sleeping mom"
]
1.91 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "while спящ mom"
]
1.30 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "while спящ mom"
]

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.