GET https://search.jues.net/search/embeds/3?q=blonde%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.93 ms
(65.42%)
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
  312730
  392270
  393715
  399591
  400254
  401799
  405145
  405537
  407517
  408238
  413819
  414131
  417388
  418959
  422673
  428192
  428987
  430700
  431432
  434601
  443833
  444405
  445542
  445543
  445590
  446025
  451932
  452097
  452139
  458722
  464862
  477686
  478966
  485285
  487632
  487708
  502310
  504213
  527416
  535369
  544663
  564643
  565050
  589591
  607293
  724656
]
10.82 ms
(12.66%)
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
  417388
  445542
  405537
  451932
  487708
  312730
  724656
  418959
  422673
  400254
  443833
  544663
  428987
  445590
  452139
  405145
  487632
  485285
  399591
  502310
  535369
  564643
  589591
  607293
  478966
  392270
  393715
  445543
  407517
  464862
  431432
  414131
  477686
  430700
  527416
  408238
  458722
  444405
  413819
  446025
  428192
  434601
  401799
  504213
  452097
  565050
]
10.42 ms
(12.18%)
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:
[
  "blonde latina"
  "blonde latina"
  "blonde latina"
  20
]
2.06 ms
(2.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
  312730
  392270
  393715
  399591
  400254
  401799
  405145
  405537
  407517
  408238
  413819
  414131
  417388
  418959
  422673
  428192
  428987
  430700
  431432
  434601
  443833
  444405
  445542
  445543
  445590
  446025
  451932
  452097
  452139
  458722
  464862
  477686
  478966
  485285
  487632
  487708
  502310
  504213
  527416
  535369
  544663
  564643
  565050
  589591
  607293
  724656
]
1.63 ms
(1.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая латинская"
]
1.61 ms
(1.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde latina"
]
1.54 ms
(1.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.