GET https://search.jues.net/search/embeds/8?q=son%20long

Query Metrics

7 Database Queries
7 Different statements
177.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
145.11 ms
(81.64%)
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
  418958
  421821
  421822
  421824
  421825
  421845
  421847
  421858
  421875
  421913
  421918
  421931
  422141
  422146
  422165
  422183
  422187
  422196
  422207
  426701
  427113
  427536
  428853
  428869
  428890
  428892
  430433
  430486
  433977
  435676
  438219
  439635
  439648
  439652
  439660
  439698
  439704
  439707
  439763
  439774
  439802
  440979
  442237
  443832
  443946
  444044
  448955
  452772
  455282
  456057
  460601
  460659
  460728
  463624
  466762
  468091
  475174
  480982
  489384
  490929
  493166
  493189
  495007
  505956
  506131
  506134
  506824
  512895
  513495
  514441
  516886
  519426
  519480
  519735
  520204
  522168
  523323
  523827
  523837
  523848
  524486
  524781
  525469
  525878
  525964
  529157
  529170
  529376
  537020
  538002
  538970
  541535
  543773
  549823
  549842
  549849
  550220
  557551
  557554
  563432
  575704
  588755
  591155
  591258
  609203
  619717
  622667
  623499
  659986
  716927
  720258
  729635
  731063
  748210
  756209
  756714
  769547
  806084
  808675
  809271
]
21.87 ms
(12.30%)
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
  541535
  543773
  549823
  549849
  557551
  575704
  659986
  720258
  716927
  549842
  550220
  557554
  563432
  588755
  591258
  609203
  623499
  591155
  622667
  806084
  808675
  731063
  748210
  729635
  769547
  756209
  756714
  619717
  809271
  422165
  422183
  422207
  426701
  428853
  428869
  428890
  438219
  439652
  439774
  443832
  456057
  460728
  463624
  475174
  480982
  421821
  421822
  421824
  421875
  421931
  433977
  439635
  439648
  439698
  439707
  439802
  440979
  442237
  443946
  448955
  460659
  468091
  421847
  421858
  421913
  421918
  422141
  422146
  422196
  427536
  428892
  444044
  452772
  466762
  439660
  439704
  439763
  460601
  418958
  421825
  421845
  422187
  427113
  430433
  430486
  435676
  455282
  519480
  529157
  538970
  506131
  514441
  519426
  519735
  520204
  524781
  525878
  529170
  538002
  489384
  493166
  493189
  495007
  505956
  506134
  512895
  513495
  516886
  523323
  523848
  525964
  529376
  537020
  490929
  506824
  522168
  523827
  523837
  524486
  525469
]
2.36 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son long"
]
2.36 ms
(1.33%)
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
  418958
  421821
  421822
  421824
  421825
  421845
  421847
  421858
  421875
  421913
  421918
  421931
  422141
  422146
  422165
  422183
  422187
  422196
  422207
  426701
  427113
  427536
  428853
  428869
  428890
  428892
  430433
  430486
  433977
  435676
  438219
  439635
  439648
  439652
  439660
  439698
  439704
  439707
  439763
  439774
  439802
  440979
  442237
  443832
  443946
  444044
  448955
  452772
  455282
  456057
  460601
  460659
  460728
  463624
  466762
  468091
  475174
  480982
  489384
  490929
  493166
  493189
  495007
  505956
  506131
  506134
  506824
  512895
  513495
  514441
  516886
  519426
  519480
  519735
  520204
  522168
  523323
  523827
  523837
  523848
  524486
  524781
  525469
  525878
  525964
  529157
  529170
  529376
  537020
  538002
  538970
  541535
  543773
  549823
  549842
  549849
  550220
  557551
  557554
  563432
  575704
  588755
  591155
  591258
  609203
  619717
  622667
  623499
  659986
  716927
  720258
  729635
  731063
  748210
  756209
  756714
  769547
  806084
  808675
  809271
]
2.08 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son длинные"
]
1.93 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son длинные"
]

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.