GET https://search.jues.net/search/embeds?q=teens%20sex%20russia

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.95 ms
(51.63%)
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
  185820
  386989
  398042
  398997
  416863
  420347
  441537
  443648
  447520
  454115
  454269
  457231
  459577
  459588
  460561
  462349
  462700
  464270
  466423
  467783
  467793
  471534
  471992
  475897
  476515
  480672
  490071
  490771
  501011
  510324
  512921
  513723
  523221
  524664
  533782
  543549
  544177
  551259
  563405
  568601
  588257
  623716
  644203
  651148
  670742
  672890
  696164
  717722
  722803
  727854
  736846
  739297
  740501
  742818
  742904
  761655
  773520
  804533
  818067
]
65.63 ms
(37.67%)
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:
[
  "teens sex russia"
  "teens sex russia"
  "teens sex russia"
  20
]
9.54 ms
(5.48%)
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
  398042
  185820
  804533
  398997
  773520
  727854
  717722
  644203
  722803
  672890
  386989
  696164
  739297
  761655
  476515
  464270
  742904
  563405
  533782
  742818
  459577
  818067
  416863
  543549
  471992
  736846
  740501
  471534
  447520
  544177
  467783
  454269
  460561
  588257
  457231
  480672
  513723
  512921
  510324
  501011
  454115
  466423
  568601
  459588
  670742
  490771
  462349
  467793
  420347
  443648
  441537
  475897
  524664
  523221
  490071
  651148
  462700
  551259
  623716
]
2.83 ms
(1.63%)
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
  185820
  386989
  398042
  398997
  416863
  420347
  441537
  443648
  447520
  454115
  454269
  457231
  459577
  459588
  460561
  462349
  462700
  464270
  466423
  467783
  467793
  471534
  471992
  475897
  476515
  480672
  490071
  490771
  501011
  510324
  512921
  513723
  523221
  524664
  533782
  543549
  544177
  551259
  563405
  568601
  588257
  623716
  644203
  651148
  670742
  672890
  696164
  717722
  722803
  727854
  736846
  739297
  740501
  742818
  742904
  761655
  773520
  804533
  818067
]
1.76 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens sex russia"
]
1.54 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens секс russia"
]
1.49 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens секс russia"
]
1.47 ms
(0.84%)
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.