GET https://search.jues.net/search/embeds/3?q=%D0%B4%D0%B5%D0%B4%20%D0%B8%20%D0%B0%D0%BD%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.16 ms
(87.87%)
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
  233346
  385228
  386866
  389860
  395667
  395735
  396242
  396245
  400690
  401124
  401296
  401976
  402048
  402160
  402238
  446634
  450117
  466979
  537767
  544749
  556066
  563618
  566158
  570469
  574292
  576523
  605326
  605341
  605353
  610657
  617825
  628441
  630773
  636277
  642951
  646826
  657070
  664808
  665378
  665392
  666458
  671644
  671890
  703142
  706311
  707329
  712162
  712719
  713037
  714433
  717814
  718532
  718670
  719235
  720813
  721439
  722443
  722596
  727748
  732303
  733170
  735602
  738181
  738305
  740059
  740500
  741113
  741533
  741889
  744852
  745003
  752599
  752722
  753448
  755696
  758986
  760214
  760218
  760991
  761170
  761576
  761580
  761592
  765710
  766851
  767217
  769746
  769786
  770582
  770981
  771203
  778980
  779135
  779704
  786768
  789182
  790374
  790394
  790955
  790972
  790989
  791000
  797165
  798986
  800321
  800553
  800619
  800629
  801272
  804995
  805207
  809652
  810533
  810838
  817623
  817660
  818828
  819311
  819537
  827642
]
13.91 ms
(6.86%)
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
  636277
  779135
  800553
  786768
  744852
  770582
  797165
  752722
  761576
  735602
  753448
  741113
  760991
  713037
  720813
  401124
  401296
  628441
  800619
  809652
  718670
  790989
  233346
  395667
  386866
  738305
  817623
  817660
  664808
  657070
  666458
  706311
  722443
  544749
  630773
  642951
  791000
  800629
  771203
  741889
  738181
  712162
  718532
  396242
  450117
  570469
  566158
  665378
  665392
  714433
  717814
  671644
  703142
  719235
  721439
  722596
  605326
  605353
  610657
  790374
  778980
  733170
  752599
  758986
  760214
  761592
  765710
  766851
  798986
  805207
  741533
  761580
  727748
  760218
  732303
  761170
  617825
  707329
  789182
  402048
  402238
  385228
  389860
  396245
  401976
  574292
  671890
  804995
  810533
  790394
  769786
  769746
  395735
  712719
  400690
  402160
  819537
  576523
  800321
  801272
  767217
  779704
  646826
  466979
  819311
  818828
  827642
  537767
  556066
  563618
  605341
  790972
  810838
  790955
  740059
  740500
  755696
  745003
  770981
  446634
]
2.91 ms
(1.43%)
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
  233346
  385228
  386866
  389860
  395667
  395735
  396242
  396245
  400690
  401124
  401296
  401976
  402048
  402160
  402238
  446634
  450117
  466979
  537767
  544749
  556066
  563618
  566158
  570469
  574292
  576523
  605326
  605341
  605353
  610657
  617825
  628441
  630773
  636277
  642951
  646826
  657070
  664808
  665378
  665392
  666458
  671644
  671890
  703142
  706311
  707329
  712162
  712719
  713037
  714433
  717814
  718532
  718670
  719235
  720813
  721439
  722443
  722596
  727748
  732303
  733170
  735602
  738181
  738305
  740059
  740500
  741113
  741533
  741889
  744852
  745003
  752599
  752722
  753448
  755696
  758986
  760214
  760218
  760991
  761170
  761576
  761580
  761592
  765710
  766851
  767217
  769746
  769786
  770582
  770981
  771203
  778980
  779135
  779704
  786768
  789182
  790374
  790394
  790955
  790972
  790989
  791000
  797165
  798986
  800321
  800553
  800619
  800629
  801272
  804995
  805207
  809652
  810533
  810838
  817623
  817660
  818828
  819311
  819537
  827642
]
2.02 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дед и анал"
]
1.96 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "старый анал"
]
1.94 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый анал"
]
1.85 ms
(0.91%)
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.