GET https://search.jues.net/search/embeds/7?q=milf%20tattoo%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.77 ms
(60.53%)
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
  488410
  502695
  504411
  517414
  524324
  527222
  528360
  529794
  532812
  533746
  545460
  545605
  552664
  588318
  599880
  599927
  600021
  600252
  601578
  610806
  625172
  628336
  630531
  632261
  632678
  633502
  635275
  635975
  636300
  636306
  636315
  637413
  639745
  639751
  639796
  641953
  641978
  641996
  642660
  642774
  646901
  647860
  647893
  647948
  666850
  676428
]
24.39 ms
(20.02%)
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:
[
  "milf tattoo creampie"
  "milf tattoo creampie"
  "milf tattoo creampie"
  20
]
13.60 ms
(11.16%)
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
  632261
  639796
  632678
  524324
  517414
  637413
  528360
  552664
  532812
  545605
  646901
  647948
  676428
  599880
  599927
  600252
  628336
  636306
  641953
  642660
  600021
  635975
  625172
  636300
  639745
  601578
  641996
  488410
  529794
  527222
  647893
  533746
  545460
  647860
  666850
  642774
  630531
  633502
  639751
  641978
  502695
  504411
  588318
  610806
  635275
  636315
]
3.18 ms
(2.61%)
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
  488410
  502695
  504411
  517414
  524324
  527222
  528360
  529794
  532812
  533746
  545460
  545605
  552664
  588318
  599880
  599927
  600021
  600252
  601578
  610806
  625172
  628336
  630531
  632261
  632678
  633502
  635275
  635975
  636300
  636306
  636315
  637413
  639745
  639751
  639796
  641953
  641978
  641996
  642660
  642774
  646901
  647860
  647893
  647948
  666850
  676428
]
1.98 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf tattoo creampie"
]
1.86 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf татуированные creampie"
]
1.47 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf татуированные creampie"
]

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.