GET https://search.jues.net/search/embeds?q=russian%20mature%20sauna

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.08 ms
(58.47%)
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
  391944
  391959
  391980
  411697
  419545
  443365
  443378
  454279
  454567
  460741
  460768
  462155
  466080
  470590
  470629
  473317
  474206
  474494
  474495
  476244
  476251
  476261
  483425
  485478
  485960
  490514
  493145
  493411
  494568
  502002
  504414
  504464
  508375
  508736
  510750
  517549
  519141
  520350
  522079
  529999
  530310
  532765
  549572
  558288
  561333
  566584
  584810
  585655
  585671
  590421
  614701
  661915
  668821
  722221
  755757
  763724
  766315
]
32.90 ms
(26.33%)
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 mature sauna"
  "russian mature sauna"
  "russian mature sauna"
  20
]
8.91 ms
(7.13%)
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
  474494
  614701
  585655
  508375
  722221
  755757
  391980
  443365
  561333
  532765
  391959
  476251
  529999
  504464
  584810
  474206
  483425
  485478
  411697
  549572
  668821
  522079
  460741
  530310
  558288
  470629
  490514
  766315
  476261
  470590
  763724
  462155
  443378
  590421
  454279
  502002
  460768
  519141
  454567
  585671
  508736
  473317
  485960
  661915
  493145
  504414
  474495
  466080
  510750
  391944
  566584
  419545
  520350
  494568
  476244
  493411
  517549
]
2.97 ms
(2.37%)
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
  391944
  391959
  391980
  411697
  419545
  443365
  443378
  454279
  454567
  460741
  460768
  462155
  466080
  470590
  470629
  473317
  474206
  474494
  474495
  476244
  476251
  476261
  483425
  485478
  485960
  490514
  493145
  493411
  494568
  502002
  504414
  504464
  508375
  508736
  510750
  517549
  519141
  520350
  522079
  529999
  530310
  532765
  549572
  558288
  561333
  566584
  584810
  585655
  585671
  590421
  614701
  661915
  668821
  722221
  755757
  763724
  766315
]
2.14 ms
(1.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mature бан"
]
1.88 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mature sauna"
]
1.44 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск mature бан"
]

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.