GET https://search.jues.net/search/embeds/5?q=%D1%8D%D1%80%D0%BE%D1%82%D0%B8%D0%BA%20%D0%B0%D0%BD%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.88 ms
(85.22%)
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
  192760
  339845
  358507
  388537
  391384
  422107
  424009
  430783
  430814
  432663
  440580
  441994
  443890
  452791
  452860
  457040
  459735
  465817
  468302
  468925
  470087
  470434
  470782
  473475
  478901
  487833
  490862
  492298
  496729
  505881
  508968
  511027
  516373
  520769
  524548
  524939
  526555
  526577
  528080
  528413
  529437
  530948
  533513
  535116
  540958
  548836
  552543
  553556
  555014
  555016
  560029
  564258
  568483
  574446
  575983
  576536
  577007
  577031
  581254
  582016
  587435
  588186
  592005
  597902
  598651
  602025
  604243
  604775
  604779
  604785
  604821
  604849
  605708
  606177
  615602
  618060
  627685
  629374
  631609
  636633
  643084
  643706
  645750
  650510
  656124
  656515
  660024
  660370
  679377
  692716
  700932
  709855
  721699
  732087
  738645
  742896
  750545
  751593
  752148
  752772
  752915
  755930
  756491
  757502
  769335
  769908
  770529
  780896
  780900
  785412
  787489
  788112
  796910
  807599
  809077
  810036
  814352
  816644
  827157
]
15.25 ms
(9.36%)
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
  814352
  452860
  468302
  660370
  700932
  656515
  604243
  587435
  810036
  742896
  526555
  339845
  627685
  796910
  555016
  592005
  597902
  459735
  645750
  598651
  755930
  769908
  709855
  629374
  468925
  535116
  555014
  575983
  577007
  548836
  552543
  553556
  660024
  574446
  582016
  604775
  605708
  631609
  602025
  604785
  604821
  732087
  752148
  757502
  473475
  478901
  529437
  526577
  441994
  787489
  440580
  358507
  422107
  424009
  577031
  568483
  604779
  769335
  770529
  780896
  505881
  470434
  721699
  528080
  487833
  750545
  560029
  508968
  528413
  581254
  564258
  588186
  604849
  615602
  643084
  604755
  807599
  756491
  511027
  430814
  470087
  452791
  530948
  391384
  816644
  656124
  576536
  606177
  643706
  780900
  785412
  516373
  636633
  679377
  192760
  432663
  465817
  490862
  470782
  388537
  430783
  443890
  520769
  496729
  524939
  827157
  457040
  492298
  533513
  524548
  540958
  650510
  692716
  809077
  752915
  788112
  738645
  751593
  752772
  618060
]
2.54 ms
(1.56%)
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
  192760
  339845
  358507
  388537
  391384
  422107
  424009
  430783
  430814
  432663
  440580
  441994
  443890
  452791
  452860
  457040
  459735
  465817
  468302
  468925
  470087
  470434
  470782
  473475
  478901
  487833
  490862
  492298
  496729
  505881
  508968
  511027
  516373
  520769
  524548
  524939
  526555
  526577
  528080
  528413
  529437
  530948
  533513
  535116
  540958
  548836
  552543
  553556
  555014
  555016
  560029
  564258
  568483
  574446
  575983
  576536
  577007
  577031
  581254
  582016
  587435
  588186
  592005
  597902
  598651
  602025
  604243
  604775
  604779
  604785
  604821
  604849
  605708
  606177
  615602
  618060
  627685
  629374
  631609
  636633
  643084
  643706
  645750
  650510
  656124
  656515
  660024
  660370
  679377
  692716
  700932
  709855
  721699
  732087
  738645
  742896
  750545
  751593
  752148
  752772
  752915
  755930
  756491
  757502
  769335
  769908
  770529
  780896
  780900
  785412
  787489
  788112
  796910
  807599
  809077
  810036
  814352
  816644
  827157
]
1.84 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "эротик анал"
]
1.69 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик анал"
]
1.41 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "эротик анал"
]
1.36 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.