GET https://search.jues.net/search/embeds?q=russian%20wife%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.09 ms
(58.89%)
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
  14534
  422089
  429950
  434885
  436042
  439993
  443858
  444064
  451560
  455611
  457847
  472393
  478057
  493963
  497568
  508866
  511713
  512092
  516924
  517447
  524732
  525942
  525948
  533779
  534114
  536877
  550187
  555003
  558437
  561247
  574855
  578898
  579033
  579034
  579049
  601527
  606694
  617754
  621612
  627634
  629510
  632851
  643851
  655358
  655431
  656708
  657296
  657361
  658082
  658405
  689886
  705630
  715068
  765853
  769448
  811100
  825789
]
34.15 ms
(27.51%)
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 wife bbc"
  "russian wife bbc"
  "russian wife bbc"
  20
]
8.16 ms
(6.57%)
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
  689886
  517447
  769448
  533779
  715068
  601527
  579049
  579033
  627634
  617754
  643851
  555003
  444064
  536877
  629510
  558437
  579034
  457847
  561247
  811100
  443858
  512092
  472393
  705630
  534114
  550187
  765853
  422089
  434885
  525948
  429950
  14534
  825789
  508866
  455611
  632851
  578898
  478057
  493963
  606694
  511713
  524732
  525942
  516924
  574855
  497568
  439993
  436042
  451560
  657296
  621612
  655358
  655431
  657361
  658082
  656708
  658405
]
2.18 ms
(1.76%)
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
  14534
  422089
  429950
  434885
  436042
  439993
  443858
  444064
  451560
  455611
  457847
  472393
  478057
  493963
  497568
  508866
  511713
  512092
  516924
  517447
  524732
  525942
  525948
  533779
  534114
  536877
  550187
  555003
  558437
  561247
  574855
  578898
  579033
  579034
  579049
  601527
  606694
  617754
  621612
  627634
  629510
  632851
  643851
  655358
  655431
  656708
  657296
  657361
  658082
  658405
  689886
  705630
  715068
  765853
  769448
  811100
  825789
]
2.02 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife bbc"
]
1.73 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен bbc"
]
1.35 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск жен bbc"
]

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.