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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.49 ms
(57.86%)
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
  396327
  405829
  408659
  412362
  412367
  412370
  412378
  412394
  412401
  421009
  421079
  431812
  432190
  432228
  432353
  451932
  451943
  452025
  512059
  519179
  527249
  527990
  527995
  529373
  535511
  551070
  562001
  565925
  567723
  592620
  599178
  608338
  623650
  788793
  789654
  789685
  789697
  789699
  789706
  789708
  789709
  789710
  789715
  789718
  789723
  789725
  789729
  789733
  789736
  789765
  789962
  789966
  790008
  790016
  813790
  820330
  824120
  824378
]
32.78 ms
(21.93%)
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:
[
  "mylf mom"
  "mylf mom"
  "mylf mom"
  20
]
20.60 ms
(13.78%)
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
  789723
  789685
  789706
  789718
  789725
  789765
  789729
  789962
  789966
  567723
  789710
  789736
  623650
  789654
  789715
  519179
  813790
  824378
  551070
  592620
  790016
  790008
  789699
  788793
  789733
  789709
  608338
  565925
  824120
  789708
  412394
  405829
  432190
  452025
  421009
  527249
  432228
  820330
  599178
  789697
  412401
  431812
  396327
  412378
  527995
  408659
  412370
  412362
  451932
  421079
  432353
  412367
  529373
  451943
  562001
  535511
  512059
  527990
]
2.96 ms
(1.98%)
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
  396327
  405829
  408659
  412362
  412367
  412370
  412378
  412394
  412401
  421009
  421079
  431812
  432190
  432228
  432353
  451932
  451943
  452025
  512059
  519179
  527249
  527990
  527995
  529373
  535511
  551070
  562001
  565925
  567723
  592620
  599178
  608338
  623650
  788793
  789654
  789685
  789697
  789699
  789706
  789708
  789709
  789710
  789715
  789718
  789723
  789725
  789729
  789733
  789736
  789765
  789962
  789966
  790008
  790016
  813790
  820330
  824120
  824378
]
1.86 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mylf mom"
]
1.63 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mylf mom"
]
1.36 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mylf 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.