GET https://search.jues.net/search/embeds/7?q=beauty%20face

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.29 ms
(56.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty face"
]
130.82 ms
(35.35%)
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
  420206
  423893
  435800
  447890
  455195
  463134
  464365
  469193
  472531
  485059
  486102
  490496
  490508
  498817
  501641
  503617
  504895
  508438
  511231
  512538
  512851
  513098
  513573
  514640
  522985
  524301
  525058
  526203
  529229
  530757
  537207
  543659
  549569
  552458
  552940
  557039
  559155
  559725
  559989
  560195
  564647
  565243
  567066
  567757
  567837
  569929
  577699
  582277
  586554
  589107
  590493
  591176
  597028
  597491
  598190
  599545
  599967
  601322
  601485
  601886
  603124
  605845
  605865
  606036
  608771
  609604
  610046
  618424
  619110
  621520
  621643
  625729
  628277
  633312
  639258
  641983
  652236
  652931
  660306
  661565
  662020
  675588
  702927
  814903
]
19.19 ms
(5.18%)
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
  565243
  567066
  702927
  559989
  598190
  601322
  606036
  609604
  625729
  633312
  420206
  435800
  447890
  463134
  485059
  508438
  512851
  522985
  513098
  524301
  605845
  464365
  530757
  504895
  529229
  552940
  564647
  560195
  549569
  552458
  577699
  641983
  597028
  423893
  469193
  472531
  501641
  490496
  498817
  525058
  814903
  537207
  567757
  675588
  586554
  589107
  513573
  503617
  490508
  569929
  567837
  619110
  603124
  618424
  455195
  512538
  514640
  543659
  559155
  559725
  652236
  652931
  660306
  662020
  557039
  582277
  605865
  639258
  601485
  621643
  628277
  601886
  597491
  599545
  486102
  511231
  590493
  621520
  599967
  591176
  608771
  661565
  610046
  526203
]
2.60 ms
(0.70%)
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
  420206
  423893
  435800
  447890
  455195
  463134
  464365
  469193
  472531
  485059
  486102
  490496
  490508
  498817
  501641
  503617
  504895
  508438
  511231
  512538
  512851
  513098
  513573
  514640
  522985
  524301
  525058
  526203
  529229
  530757
  537207
  543659
  549569
  552458
  552940
  557039
  559155
  559725
  559989
  560195
  564647
  565243
  567066
  567757
  567837
  569929
  577699
  582277
  586554
  589107
  590493
  591176
  597028
  597491
  598190
  599545
  599967
  601322
  601485
  601886
  603124
  605845
  605865
  606036
  608771
  609604
  610046
  618424
  619110
  621520
  621643
  625729
  628277
  633312
  639258
  641983
  652236
  652931
  660306
  661565
  662020
  675588
  702927
  814903
]
2.01 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty face"
]
1.98 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.44%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01”?ï\x1C_p^‘a¬êåTï\"
]
1.61 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty face"
]

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.