GET https://search.jues.net/search/embeds?q=public%20anal%20videos

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
100.45 ms
(47.96%)
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:
[
  "public anal videos"
  "public anal videos"
  "public anal videos"
  20
]
88.72 ms
(42.36%)
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
  387510
  389391
  389895
  424556
  427174
  427517
  440632
  446976
  452228
  452283
  452612
  453569
  453572
  453666
  454274
  455237
  455798
  455804
  455847
  457041
  457230
  457735
  457789
  457792
  466061
  478098
  489809
  491382
  501649
  505174
  521367
  522163
  525440
  532641
  535116
  538318
  541118
  551940
  554852
  568399
  571639
  573105
  573212
  573597
  573880
  576639
  585161
  592004
  602519
  616205
  676621
  683567
  690803
  690932
  724816
  749234
  802412
  818571
]
10.62 ms
(5.07%)
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
  818571
  538318
  592004
  676621
  505174
  427517
  802412
  522163
  457230
  389391
  387510
  576639
  551940
  466061
  554852
  724816
  573880
  455237
  683567
  571639
  457792
  455798
  453572
  478098
  501649
  749234
  453666
  573105
  491382
  535116
  521367
  690932
  489809
  452612
  541118
  424556
  455804
  457735
  453569
  457041
  532641
  455847
  452228
  440632
  454274
  452283
  585161
  389895
  690803
  446976
  457789
  568399
  573212
  602519
  525440
  573597
  616205
  427174
]
2.58 ms
(1.23%)
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
  387510
  389391
  389895
  424556
  427174
  427517
  440632
  446976
  452228
  452283
  452612
  453569
  453572
  453666
  454274
  455237
  455798
  455804
  455847
  457041
  457230
  457735
  457789
  457792
  466061
  478098
  489809
  491382
  501649
  505174
  521367
  522163
  525440
  532641
  535116
  538318
  541118
  551940
  554852
  568399
  571639
  573105
  573212
  573597
  573880
  576639
  585161
  592004
  602519
  616205
  676621
  683567
  690803
  690932
  724816
  749234
  802412
  818571
]
1.85 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц анал videos"
]
1.76 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public anal videos"
]
1.66 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц анал videos"
]

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.