GET https://search.jues.net/search/embeds/10?q=russian%20natural

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.82 ms
(80.08%)
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
  97390
  384810
  418459
  422395
  432491
  433584
  433926
  437459
  437786
  439078
  443124
  443195
  443743
  448682
  450345
  451542
  451587
  455375
  455890
  458510
  459046
  459717
  462003
  462724
  466255
  467295
  467445
  467502
  467543
  470624
  470773
  475172
  475175
  476478
  478332
  479558
  482024
  482906
  483517
  483618
  483856
  484854
  484858
  485355
  485385
  486330
  488190
  488732
  490191
  490197
  491316
  491559
  492116
  492628
  495478
  495847
  496795
  497249
  497250
  497798
  499419
  501963
  502976
  503630
  504136
  504321
  504552
  505038
  505225
  507763
  508093
  508116
  509491
  510523
  512607
  512692
  513225
  515919
  515936
  517881
  519340
  521116
  521499
  521956
  521961
  521990
  523155
  523450
  524729
  524771
  525395
  525717
  525996
  526841
  526929
  527682
  529494
  547617
  548633
  557944
  558001
  562418
  564431
  566089
  568608
  573330
  576104
  576313
  578081
  582521
  582526
  589619
  596864
  597063
  598481
  602165
  602705
  604120
  643456
  643986
]
20.94 ms
(13.77%)
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
  483517
  485385
  488190
  491559
  492628
  503630
  504321
  521956
  521961
  529494
  495847
  496795
  505038
  512692
  519340
  521116
  482906
  484858
  485355
  495478
  507763
  508093
  512607
  515936
  523450
  525996
  526841
  384810
  491316
  462003
  418459
  482024
  422395
  433584
  432491
  470624
  525717
  509491
  439078
  433926
  486330
  576104
  562418
  548633
  597063
  596864
  602165
  443124
  459046
  451587
  467502
  475172
  455375
  467445
  521990
  488732
  505225
  510523
  525395
  483618
  483856
  502976
  497249
  499419
  517881
  97390
  527682
  643986
  467543
  501963
  643456
  458510
  582526
  557944
  558001
  568608
  578081
  589619
  598481
  604120
  448682
  475175
  478332
  437459
  459717
  476478
  437786
  462724
  451542
  504136
  521499
  513225
  526929
  497250
  497798
  504552
  582521
  547617
  564431
  566089
  576313
  602705
  467295
  470773
  443195
  450345
  455890
  479558
  466255
  508116
  484854
  490191
  490197
  523155
  524729
  524771
  492116
  515919
  443743
  573330
]
2.81 ms
(1.85%)
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
  97390
  384810
  418459
  422395
  432491
  433584
  433926
  437459
  437786
  439078
  443124
  443195
  443743
  448682
  450345
  451542
  451587
  455375
  455890
  458510
  459046
  459717
  462003
  462724
  466255
  467295
  467445
  467502
  467543
  470624
  470773
  475172
  475175
  476478
  478332
  479558
  482024
  482906
  483517
  483618
  483856
  484854
  484858
  485355
  485385
  486330
  488190
  488732
  490191
  490197
  491316
  491559
  492116
  492628
  495478
  495847
  496795
  497249
  497250
  497798
  499419
  501963
  502976
  503630
  504136
  504321
  504552
  505038
  505225
  507763
  508093
  508116
  509491
  510523
  512607
  512692
  513225
  515919
  515936
  517881
  519340
  521116
  521499
  521956
  521961
  521990
  523155
  523450
  524729
  524771
  525395
  525717
  525996
  526841
  526929
  527682
  529494
  547617
  548633
  557944
  558001
  562418
  564431
  566089
  568608
  573330
  576104
  576313
  578081
  582521
  582526
  589619
  596864
  597063
  598481
  602165
  602705
  604120
  643456
  643986
]
2.15 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian natural"
]
1.54 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск натуральная натуральные"
]
1.44 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.94%)
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.