GET https://search.jues.net/search/embeds/8?q=anal%20old%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.70 ms
(87.62%)
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
  187843
  391170
  391472
  400812
  400826
  401200
  401916
  411332
  411344
  411371
  421890
  422199
  422205
  422342
  424421
  424428
  424433
  424455
  428837
  439521
  439550
  439574
  439607
  439696
  440598
  440993
  443764
  443791
  444000
  446894
  448409
  449428
  451473
  454175
  464327
  465075
  465952
  465955
  466011
  466242
  466251
  466272
  466599
  466872
  467034
  468076
  470196
  470202
  470290
  470527
  470968
  473139
  473253
  474652
  474654
  474686
  474696
  484558
  484585
  484651
  484668
  484678
  484681
  484692
  484705
  484730
  484737
  484748
  484750
  487362
  489379
  490202
  490904
  491463
  491644
  494516
  497368
  506056
  509810
  515969
  519157
  523019
  526775
  534208
  536676
  539010
  539951
  545755
  546947
  555912
  560441
  564542
  567337
  570708
  590503
  595458
  597227
  598505
  598890
  604018
  612799
  619513
  636273
  636274
  646838
  659409
  662423
  701498
  710524
  717708
  733870
  733879
  739535
  742143
  762669
  775819
  796507
  807340
  821829
  821851
]
15.73 ms
(7.89%)
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
  187843
  598505
  391472
  509810
  411332
  560441
  612799
  474686
  411371
  439696
  473139
  484748
  484750
  484730
  539010
  539951
  564542
  546947
  567337
  597227
  598890
  604018
  733879
  422199
  439521
  424428
  465955
  466599
  474652
  424421
  466872
  470196
  440598
  465075
  428837
  470527
  489379
  490202
  515969
  484558
  484705
  491644
  494516
  470290
  523019
  484692
  796507
  717708
  821851
  534208
  701498
  590503
  636274
  636273
  807340
  742143
  775819
  400826
  473253
  400812
  444000
  391170
  451473
  465952
  466242
  466272
  490904
  491463
  484678
  619513
  443764
  468076
  401916
  448409
  466011
  470202
  422342
  424433
  474696
  484651
  484737
  484668
  662423
  659409
  646838
  710524
  733870
  443791
  401200
  467034
  470968
  424455
  439574
  439607
  449428
  422205
  497368
  484585
  519157
  526775
  545755
  421890
  821829
  570708
  739535
  411344
  762669
  484681
  555912
  595458
  536676
  440993
  464327
  439550
  466251
  474654
  446894
  454175
  506056
  487362
]
2.46 ms
(1.23%)
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
  187843
  391170
  391472
  400812
  400826
  401200
  401916
  411332
  411344
  411371
  421890
  422199
  422205
  422342
  424421
  424428
  424433
  424455
  428837
  439521
  439550
  439574
  439607
  439696
  440598
  440993
  443764
  443791
  444000
  446894
  448409
  449428
  451473
  454175
  464327
  465075
  465952
  465955
  466011
  466242
  466251
  466272
  466599
  466872
  467034
  468076
  470196
  470202
  470290
  470527
  470968
  473139
  473253
  474652
  474654
  474686
  474696
  484558
  484585
  484651
  484668
  484678
  484681
  484692
  484705
  484730
  484737
  484748
  484750
  487362
  489379
  490202
  490904
  491463
  491644
  494516
  497368
  506056
  509810
  515969
  519157
  523019
  526775
  534208
  536676
  539010
  539951
  545755
  546947
  555912
  560441
  564542
  567337
  570708
  590503
  595458
  597227
  598505
  598890
  604018
  612799
  619513
  636273
  636274
  646838
  659409
  662423
  701498
  710524
  717708
  733870
  733879
  739535
  742143
  762669
  775819
  796507
  807340
  821829
  821851
]
1.80 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal old russian"
]
1.76 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал old русск"
]
1.34 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал old русск"
]

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.