GET https://search.jues.net/search/embeds/3?q=russian%20saggy%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.94 ms
(85.02%)
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
  422354
  439709
  443292
  443413
  443761
  443772
  448708
  451495
  454177
  454558
  454567
  458000
  460753
  460912
  465399
  466025
  466085
  466095
  470017
  470018
  474113
  474478
  474479
  474482
  474493
  474674
  474790
  475874
  476284
  477983
  478387
  479027
  479047
  479059
  479102
  479110
  479126
  483405
  484379
  484405
  484598
  484625
  486345
  487321
  491099
  491153
  491431
  493185
  497205
  506210
  511518
  511529
  519140
  519739
  520897
  520899
  526745
  526747
  526832
  535439
  544859
  544957
  545535
  548042
  548182
  549758
  557999
  561333
  563125
  563180
  579613
  580640
  591977
  599354
  599558
  601885
  605914
  609268
  609274
  614701
  615477
  617440
  619223
  624821
  625036
  668824
  675589
  714640
  715458
  721074
  721427
  721464
  721467
  722281
  738313
  741690
  754227
  781665
  781669
  781682
  781707
  781733
  781741
  781755
  781761
  782148
  785940
  788680
  794667
  794697
  794830
  803522
  807336
  817532
  818054
  820284
  824408
  824584
  825585
  825869
]
18.80 ms
(9.63%)
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
  722281
  601885
  781755
  788680
  794697
  781707
  785940
  794667
  781682
  741690
  617440
  721074
  781669
  782148
  824584
  825585
  544859
  715458
  721427
  721467
  609274
  619223
  609268
  781733
  794830
  807336
  781761
  803522
  754227
  781665
  781741
  625036
  478387
  474790
  439709
  519739
  563125
  599354
  479110
  549758
  580640
  563180
  451495
  526747
  483405
  544957
  668824
  484405
  675589
  443292
  479059
  466095
  475874
  479027
  454567
  474493
  477983
  454558
  466025
  466085
  519140
  493185
  506210
  511518
  487321
  520897
  422354
  479126
  545535
  443413
  474479
  548182
  557999
  579613
  591977
  614701
  624821
  448708
  460753
  470018
  479102
  465399
  474482
  476284
  479047
  460912
  474113
  454177
  458000
  470017
  443761
  443772
  474478
  474674
  520899
  484625
  511529
  526745
  526832
  497205
  484379
  484598
  486345
  491153
  535439
  491431
  824408
  817532
  548042
  738313
  825869
  818054
  820284
  491099
  721464
  714640
  561333
  605914
  615477
  599558
]
2.66 ms
(1.36%)
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
  422354
  439709
  443292
  443413
  443761
  443772
  448708
  451495
  454177
  454558
  454567
  458000
  460753
  460912
  465399
  466025
  466085
  466095
  470017
  470018
  474113
  474478
  474479
  474482
  474493
  474674
  474790
  475874
  476284
  477983
  478387
  479027
  479047
  479059
  479102
  479110
  479126
  483405
  484379
  484405
  484598
  484625
  486345
  487321
  491099
  491153
  491431
  493185
  497205
  506210
  511518
  511529
  519140
  519739
  520897
  520899
  526745
  526747
  526832
  535439
  544859
  544957
  545535
  548042
  548182
  549758
  557999
  561333
  563125
  563180
  579613
  580640
  591977
  599354
  599558
  601885
  605914
  609268
  609274
  614701
  615477
  617440
  619223
  624821
  625036
  668824
  675589
  714640
  715458
  721074
  721427
  721464
  721467
  722281
  738313
  741690
  754227
  781665
  781669
  781682
  781707
  781733
  781741
  781755
  781761
  782148
  785940
  788680
  794667
  794697
  794830
  803522
  807336
  817532
  818054
  820284
  824408
  824584
  825585
  825869
]
2.22 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian saggy mature"
]
2.08 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск saggy mature"
]
1.76 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск saggy mature"
]

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.