GET https://search.jues.net/search/embeds/2?q=russian%20mother%20masturbates

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.36 ms
(59.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mother masturbates"
]
86.53 ms
(25.12%)
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
  398979
  419619
  419628
  429862
  438052
  440548
  453400
  456045
  459718
  461840
  466992
  479107
  490223
  493411
  504787
  504791
  507638
  507640
  507643
  518611
  518614
  520398
  520911
  522448
  523869
  525468
  527829
  528452
  547746
  550456
  555040
  556001
  571707
  584197
  584806
  593525
  599239
  599247
  599803
  602666
  613903
  619636
  619888
  624910
  641414
  658797
  671219
  672831
  678716
  690625
  705890
  731340
  741011
  742369
  742636
]
31.13 ms
(9.04%)
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:
[
  "russian mother masturbates"
  "russian mother masturbates"
  "russian mother masturbates"
  20
]
12.48 ms
(3.62%)
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
  547746
  522448
  440548
  479107
  705890
  690625
  613903
  619636
  741011
  731340
  459718
  527829
  584197
  584806
  438052
  525468
  504791
  490223
  550456
  742369
  398979
  599247
  593525
  624910
  520398
  429862
  461840
  504787
  493411
  742636
  466992
  678716
  658797
  523869
  507640
  571707
  599239
  419619
  556001
  456045
  602666
  619888
  518614
  555040
  507638
  507643
  672831
  671219
  641414
  599803
  520911
  453400
  419628
  518611
  528452
]
3.07 ms
(0.89%)
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
  398979
  419619
  419628
  429862
  438052
  440548
  453400
  456045
  459718
  461840
  466992
  479107
  490223
  493411
  504787
  504791
  507638
  507640
  507643
  518611
  518614
  520398
  520911
  522448
  523869
  525468
  527829
  528452
  547746
  550456
  555040
  556001
  571707
  584197
  584806
  593525
  599239
  599247
  599803
  602666
  613903
  619636
  619888
  624910
  641414
  658797
  671219
  672831
  678716
  690625
  705890
  731340
  741011
  742369
  742636
]
1.68 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск мам женщин masturbates"
]
1.64 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск мам женщин masturbates"
]
1.53 ms
(0.44%)
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.