GET https://search.jues.net/search/embeds/2?q=hijab%20teen%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.39 ms
(51.70%)
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
  424942
  435731
  441961
  445499
  445548
  473218
  482173
  512785
  512797
  512799
  512805
  521551
  521580
  522398
  522412
  532248
  543036
  543195
  543201
  543228
  543281
  543435
  543456
  543508
  550347
  550689
  556976
  565922
  567604
  574986
  575009
  577062
  581089
  586518
  590727
  590750
  591870
  592372
  614781
  630084
  671344
  681211
  684250
  687585
  709350
  771462
]
37.05 ms
(33.97%)
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:
[
  "hijab teen girl"
  "hijab teen girl"
  "hijab teen girl"
  20
]
6.57 ms
(6.02%)
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
  543281
  614781
  445548
  671344
  684250
  687585
  591870
  592372
  709350
  771462
  565922
  441961
  512797
  482173
  543036
  681211
  522412
  630084
  575009
  556976
  521580
  581089
  543228
  445499
  512805
  532248
  543201
  512799
  567604
  473218
  543456
  574986
  521551
  512785
  586518
  577062
  543435
  550347
  590727
  543195
  424942
  435731
  550689
  590750
  522398
  543508
]
2.04 ms
(1.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hijab teen girl"
]
2.03 ms
(1.86%)
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
  424942
  435731
  441961
  445499
  445548
  473218
  482173
  512785
  512797
  512799
  512805
  521551
  521580
  522398
  522412
  532248
  543036
  543195
  543201
  543228
  543281
  543435
  543456
  543508
  550347
  550689
  556976
  565922
  567604
  574986
  575009
  577062
  581089
  586518
  590727
  590750
  591870
  592372
  614781
  630084
  671344
  681211
  684250
  687585
  709350
  771462
]
1.70 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hijab молодая девушк"
]
1.59 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hijab молодая девушк"
]

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.