GET https://search.jues.net/search/embeds/3?q=naughty%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.65 ms
(46.54%)
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
  390533
  401200
  413033
  437855
  444838
  447470
  448797
  460012
  461613
  463694
  476216
  482320
  482790
  486270
  486456
  487362
  490577
  501538
  502247
  504779
  505278
  511602
  514805
  515357
  522889
  524343
  524613
  528923
  529345
  529365
  532943
  539286
  540434
  543475
  543841
  549990
  556029
  558100
  567909
  582540
  591187
  597919
  599772
  601917
  604375
  606806
  607537
  616800
  622407
  632252
  644047
  666853
  668668
  767601
  776217
  788136
  811497
]
66.80 ms
(40.56%)
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:
[
  "naughty anal"
  "naughty anal"
  "naughty anal"
  20
]
11.22 ms
(6.82%)
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
  515357
  482790
  529365
  543841
  668668
  413033
  390533
  460012
  444838
  811497
  401200
  540434
  543475
  767601
  447470
  504779
  437855
  514805
  522889
  482320
  556029
  606806
  788136
  529345
  549990
  597919
  505278
  486270
  448797
  666853
  539286
  591187
  558100
  776217
  604375
  582540
  486456
  532943
  632252
  487362
  476216
  502247
  567909
  601917
  607537
  599772
  524343
  490577
  644047
  511602
  501538
  616800
  463694
  461613
  524613
  622407
  528923
]
2.32 ms
(1.41%)
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
  390533
  401200
  413033
  437855
  444838
  447470
  448797
  460012
  461613
  463694
  476216
  482320
  482790
  486270
  486456
  487362
  490577
  501538
  502247
  504779
  505278
  511602
  514805
  515357
  522889
  524343
  524613
  528923
  529345
  529365
  532943
  539286
  540434
  543475
  543841
  549990
  556029
  558100
  567909
  582540
  591187
  597919
  599772
  601917
  604375
  606806
  607537
  616800
  622407
  632252
  644047
  666853
  668668
  767601
  776217
  788136
  811497
]
2.10 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "naughty anal"
]
2.01 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "naughty анал"
]
1.71 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "naughty анал"
]

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.