GET https://search.jues.net/search/embeds/4?q=%D1%81%D1%82%D1%83%D0%B4%D0%B5%D0%BD%D1%82%D0%BA%D0%BE%D0%B9

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.30 ms
(52.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
169.41 ms
(42.20%)
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
  205
  39142
  73571
  225633
  366012
  384271
  392558
  397974
  399019
  401784
  426903
  445077
  454359
  479924
  494835
  529610
  531067
  533266
  534814
  540701
  541003
  541944
  541954
  548902
  552218
  557724
  559434
  575351
  576983
  578937
  581481
  608242
  611500
  614930
  623349
  627004
  627638
  637614
  651801
  657105
  657206
  658102
  659182
  668127
  668435
  699457
  699662
  703163
  714430
  724705
  724830
  726391
  727179
  734795
  734811
  734955
  736675
  737710
  739116
  741637
  744024
  744841
  748409
  748574
  748605
  749006
  751392
  753607
  753910
  754025
  754171
  754197
  754855
  754982
  756147
  756197
  758924
  759244
  760334
  763965
  765574
  767304
  767337
  767340
  767560
  770325
  772771
  773886
  777620
  777824
  778127
  778545
  778715
  779166
  780647
  783132
  784124
  784541
  785734
  786483
  787288
  788724
  790712
  791190
  795109
  795730
  796777
  797196
  797421
  797805
  798911
  799144
  799167
  799780
  806599
  810419
  810934
  812260
  813691
  814030
]
14.38 ms
(3.58%)
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
  797196
  799144
  799780
  777620
  777824
  778715
  784541
  785734
  788724
  790712
  797421
  806599
  810419
  812260
  734795
  734955
  748574
  754025
  758924
  763965
  767304
  767340
  783132
  784124
  786483
  795109
  796777
  797805
  799167
  810934
  724705
  724830
  737710
  739116
  741637
  744841
  748605
  749006
  751392
  753910
  754171
  754855
  756147
  759244
  767337
  726391
  727179
  734811
  744024
  753607
  754197
  756197
  760334
  765574
  767560
  773886
  736675
  748409
  754982
  770325
  772771
  614930
  623349
  627004
  637614
  699457
  699662
  703163
  714430
  778127
  778545
  779166
  780647
  787288
  791190
  795730
  798911
  73571
  205
  454359
  366012
  659182
  581481
  608242
  611500
  627638
  426903
  445077
  531067
  384271
  225633
  392558
  39142
  397974
  399019
  401784
  813691
  814030
  479924
  494835
  533266
  540701
  534814
  529610
  541944
  557724
  541003
  548902
  552218
  559434
  575351
  541954
  576983
  578937
  651801
  657105
  657206
  658102
  668127
  668435
]
2.45 ms
(0.61%)
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
  205
  39142
  73571
  225633
  366012
  384271
  392558
  397974
  399019
  401784
  426903
  445077
  454359
  479924
  494835
  529610
  531067
  533266
  534814
  540701
  541003
  541944
  541954
  548902
  552218
  557724
  559434
  575351
  576983
  578937
  581481
  608242
  611500
  614930
  623349
  627004
  627638
  637614
  651801
  657105
  657206
  658102
  659182
  668127
  668435
  699457
  699662
  703163
  714430
  724705
  724830
  726391
  727179
  734795
  734811
  734955
  736675
  737710
  739116
  741637
  744024
  744841
  748409
  748574
  748605
  749006
  751392
  753607
  753910
  754025
  754171
  754197
  754855
  754982
  756147
  756197
  758924
  759244
  760334
  763965
  765574
  767304
  767337
  767340
  767560
  770325
  772771
  773886
  777620
  777824
  778127
  778545
  778715
  779166
  780647
  783132
  784124
  784541
  785734
  786483
  787288
  788724
  790712
  791190
  795109
  795730
  796777
  797196
  797421
  797805
  798911
  799144
  799167
  799780
  806599
  810419
  810934
  812260
  813691
  814030
]
1.80 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "студентк"
]
1.64 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "студенткой"
]
1.49 ms
(0.37%)
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.