GET https://search.jues.net/search/embeds/6?q=old%20mother%20son

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.79 ms
(57.95%)
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
  395721
  397530
  400181
  400249
  407379
  407414
  422254
  425347
  428202
  428533
  428895
  439534
  439544
  439564
  439696
  439718
  455206
  461016
  461018
  463215
  464438
  464564
  466003
  466133
  474800
  477890
  484554
  485265
  485462
  486198
  486540
  489330
  504927
  512516
  512539
  512541
  518858
  518960
  519023
  519037
  519931
  520870
  520878
  520881
  523356
  524637
  532682
  543579
  547612
  550960
  557537
  563218
  563446
  565983
  584739
  591314
  601851
  630475
]
27.90 ms
(22.84%)
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:
[
  "old mother son"
  "old mother son"
  "old mother son"
  20
]
11.21 ms
(9.18%)
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
  518858
  466003
  512516
  520870
  425347
  519931
  489330
  407414
  474800
  464438
  407379
  400181
  422254
  524637
  439534
  455206
  461018
  512539
  439696
  512541
  520878
  565983
  428895
  464564
  395721
  485462
  400249
  439718
  519037
  466133
  523356
  584739
  486540
  461016
  547612
  563446
  484554
  428533
  532682
  630475
  439544
  397530
  563218
  486198
  485265
  428202
  463215
  518960
  543579
  504927
  550960
  439564
  477890
  520881
  601851
  557537
  591314
  519023
]
4.87 ms
(3.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.68 ms
(2.19%)
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
  395721
  397530
  400181
  400249
  407379
  407414
  422254
  425347
  428202
  428533
  428895
  439534
  439544
  439564
  439696
  439718
  455206
  461016
  461018
  463215
  464438
  464564
  466003
  466133
  474800
  477890
  484554
  485265
  485462
  486198
  486540
  489330
  504927
  512516
  512539
  512541
  518858
  518960
  519023
  519037
  519931
  520870
  520878
  520881
  523356
  524637
  532682
  543579
  547612
  550960
  557537
  563218
  563446
  565983
  584739
  591314
  601851
  630475
]
1.69 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old мам женщин son"
]
1.61 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old mother son"
]
1.41 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old мам женщин son"
]

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.