GET https://search.jues.net/search/embeds/7?q=red%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.67 ms
(85.29%)
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
  35405
  315244
  386232
  387026
  391326
  395879
  396707
  400483
  400487
  400506
  400861
  401101
  404596
  411408
  411967
  414067
  414666
  415256
  421819
  421829
  421843
  421844
  421851
  421862
  421873
  421917
  421977
  422182
  422237
  422561
  422593
  423495
  424379
  439187
  440813
  444531
  444608
  446095
  448554
  449120
  452551
  454548
  455467
  457468
  459628
  460323
  463818
  464125
  465615
  468095
  469054
  469577
  470522
  472198
  472449
  472691
  474103
  474579
  478377
  478491
  480331
  481484
  482342
  482345
  483869
  484638
  494442
  496143
  497725
  504935
  511259
  515779
  517848
  518936
  521129
  534077
  534550
  536624
  547976
  550411
  565275
  565949
  566766
  597268
  607549
  618514
  623458
  628116
  646824
  668975
  669035
  669408
  678954
  683955
  686130
  696154
  712555
  717906
  719898
  720111
  722903
  747451
  751120
  761163
  761850
  765628
  792185
  793901
  796945
  798529
  799284
  803621
  805033
  807435
  809935
  810061
  812075
  813276
  814508
  827830
]
15.58 ms
(8.94%)
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
  712555
  720111
  387026
  386232
  391326
  400861
  404596
  422593
  444608
  411967
  414067
  424379
  439187
  814508
  469054
  482345
  455467
  459628
  460323
  472198
  474103
  474579
  481484
  446095
  463818
  465615
  470522
  472449
  517848
  511259
  536624
  497725
  515779
  464125
  469577
  547976
  566766
  550411
  678954
  686130
  719898
  669408
  696154
  646824
  668975
  669035
  683955
  722903
  565275
  565949
  623458
  597268
  607549
  618514
  796945
  803621
  805033
  807435
  792185
  793901
  812075
  813276
  765628
  798529
  799284
  747451
  761850
  751120
  761163
  717906
  809935
  810061
  421829
  421843
  422237
  452551
  457468
  472691
  478491
  400483
  400487
  401101
  421844
  421862
  440813
  482342
  411408
  415256
  421819
  421873
  395879
  421851
  421917
  422182
  478377
  480331
  423495
  448554
  468095
  484638
  496143
  521129
  483869
  494442
  504935
  534077
  35405
  827830
  628116
  315244
  396707
  400506
  421977
  422561
  414666
  444531
  454548
  449120
  518936
  534550
]
2.87 ms
(1.65%)
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
  35405
  315244
  386232
  387026
  391326
  395879
  396707
  400483
  400487
  400506
  400861
  401101
  404596
  411408
  411967
  414067
  414666
  415256
  421819
  421829
  421843
  421844
  421851
  421862
  421873
  421917
  421977
  422182
  422237
  422561
  422593
  423495
  424379
  439187
  440813
  444531
  444608
  446095
  448554
  449120
  452551
  454548
  455467
  457468
  459628
  460323
  463818
  464125
  465615
  468095
  469054
  469577
  470522
  472198
  472449
  472691
  474103
  474579
  478377
  478491
  480331
  481484
  482342
  482345
  483869
  484638
  494442
  496143
  497725
  504935
  511259
  515779
  517848
  518936
  521129
  534077
  534550
  536624
  547976
  550411
  565275
  565949
  566766
  597268
  607549
  618514
  623458
  628116
  646824
  668975
  669035
  669408
  678954
  683955
  686130
  696154
  712555
  717906
  719898
  720111
  722903
  747451
  751120
  761163
  761850
  765628
  792185
  793901
  796945
  798529
  799284
  803621
  805033
  807435
  809935
  810061
  812075
  813276
  814508
  827830
]
1.96 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red anal"
]
1.85 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red анал"
]
1.81 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red анал"
]

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.