GET https://search.jues.net/search/embeds?q=hidden%20camera%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.20 ms
(65.71%)
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
  430713
  432631
  432675
  432699
  432727
  432728
  432735
  432736
  433067
  454533
  454536
  454537
  470411
  490162
  504696
  529898
  529905
  536852
  623957
  679467
  687306
  738042
  738564
  738675
  750515
  751170
  751384
  759138
  811848
  811852
  811862
  811869
  811891
  811896
  811897
  811905
  812285
  812286
  814706
  820860
  823277
]
14.91 ms
(15.50%)
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:
[
  "hidden camera latina"
  "hidden camera latina"
  "hidden camera latina"
  20
]
8.40 ms
(8.73%)
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
  811852
  490162
  811869
  823277
  811897
  432735
  623957
  750515
  759138
  812286
  454533
  811905
  812285
  751384
  811896
  687306
  536852
  738042
  738675
  811848
  432727
  470411
  814706
  811891
  751170
  811862
  432675
  433067
  454537
  820860
  679467
  432736
  738564
  430713
  432728
  504696
  432699
  432631
  529898
  529905
  454536
]
2.30 ms
(2.40%)
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
  430713
  432631
  432675
  432699
  432727
  432728
  432735
  432736
  433067
  454533
  454536
  454537
  470411
  490162
  504696
  529898
  529905
  536852
  623957
  679467
  687306
  738042
  738564
  738675
  750515
  751170
  751384
  759138
  811848
  811852
  811862
  811869
  811891
  811896
  811897
  811905
  812285
  812286
  814706
  820860
  823277
]
2.03 ms
(2.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden camera latina"
]
1.85 ms
(1.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт camera латинская"
]
1.71 ms
(1.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт camera латинская"
]

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.