GET https://search.jues.net/search/embeds?q=arab%20woman

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.42 ms
(71.44%)
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
  458826
  477565
  538590
  539299
  542826
  542850
  542855
  543102
  543166
  543175
  543179
  543200
  543203
  543213
  543273
  543453
  543781
  543786
  544677
  544706
  556942
  556970
  567138
  567583
  569968
  577096
  577115
  585569
  591859
  603302
  618764
  622915
  622928
  622929
  622932
  623415
  626348
  678017
  705121
  705263
  710026
  714421
  714424
  718141
  726624
  750248
  826444
  828337
]
11.67 ms
(11.68%)
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:
[
  "arab woman"
  "arab woman"
  "arab woman"
  20
]
7.48 ms
(7.48%)
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
  542850
  623415
  556942
  567138
  538590
  542855
  458826
  567583
  622932
  542826
  539299
  603302
  750248
  726624
  826444
  622929
  543786
  577115
  718141
  569968
  626348
  828337
  714421
  591859
  544677
  705121
  622928
  543200
  543273
  544706
  543102
  543453
  678017
  618764
  622915
  543203
  714424
  710026
  543213
  543175
  705263
  477565
  543166
  543179
  543781
  585569
  556970
  577096
]
2.19 ms
(2.19%)
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
  458826
  477565
  538590
  539299
  542826
  542850
  542855
  543102
  543166
  543175
  543179
  543200
  543203
  543213
  543273
  543453
  543781
  543786
  544677
  544706
  556942
  556970
  567138
  567583
  569968
  577096
  577115
  585569
  591859
  603302
  618764
  622915
  622928
  622929
  622932
  623415
  626348
  678017
  705121
  705263
  710026
  714421
  714424
  718141
  726624
  750248
  826444
  828337
]
2.08 ms
(2.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "arab woman"
]
1.88 ms
(1.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "араб woman"
]
1.64 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "араб woman"
]
1.62 ms
(1.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.