GET https://search.jues.net/search/embeds/3?q=%D0%B1%D0%BE%D1%81%D1%81%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.09 ms
(86.50%)
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
  279273
  401207
  420224
  453784
  471590
  490812
  494678
  505935
  510722
  542605
  545127
  551578
  551703
  553343
  558724
  558789
  565425
  573997
  576131
  578807
  582079
  588344
  596800
  596820
  596944
  599277
  600626
  600783
  600795
  600824
  600842
  600846
  600861
  600871
  600940
  613766
  622086
  637869
  663486
  665477
  667527
  671647
  673881
  683840
  701890
  702063
  704084
  705531
  707225
  712804
  712805
  714926
  716204
  718851
  719418
  723661
  723693
  723733
  723952
  724041
  724818
  727423
  730760
  734542
  740191
  741050
  742618
  743147
  743784
  744093
  748024
  748396
  748399
  749649
  750548
  752821
  755134
  755461
  758420
  759158
  759857
  759951
  760692
  760860
  761003
  761509
  761589
  762627
  763222
  765894
  767670
  768206
  772942
  777107
  777910
  778716
  779608
  783277
  783783
  787244
  791314
  791452
  792859
  793314
  794513
  795048
  795368
  796504
  796606
  796637
  798969
  801865
  802076
  802170
  805350
  805353
  805428
  805927
  808205
  810062
]
14.13 ms
(7.63%)
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
  600783
  600846
  600940
  777107
  792859
  795368
  805428
  778716
  779608
  796606
  802076
  805353
  805927
  723693
  723952
  724041
  750548
  761003
  740191
  748024
  759857
  765894
  727423
  752821
  759158
  767670
  734542
  744093
  755134
  760860
  743784
  758420
  760692
  761589
  762627
  768206
  705531
  707225
  718851
  796504
  796637
  801865
  808205
  810062
  453784
  471590
  279273
  420224
  494678
  505935
  401207
  723661
  490812
  510722
  551703
  558724
  542605
  553343
  558789
  573997
  545127
  673881
  712804
  719418
  663486
  667527
  701890
  712805
  716204
  665477
  671647
  683840
  702063
  704084
  714926
  551578
  565425
  576131
  578807
  582079
  600861
  613766
  622086
  637869
  599277
  600626
  600871
  588344
  596800
  596820
  596944
  600795
  600824
  600842
  791314
  777910
  793314
  794513
  802170
  743147
  749649
  755461
  759951
  763222
  772942
  783277
  783783
  787244
  791452
  795048
  798969
  805350
  724818
  741050
  748399
  761509
  723733
  730760
  742618
  748396
]
3.37 ms
(1.82%)
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
  279273
  401207
  420224
  453784
  471590
  490812
  494678
  505935
  510722
  542605
  545127
  551578
  551703
  553343
  558724
  558789
  565425
  573997
  576131
  578807
  582079
  588344
  596800
  596820
  596944
  599277
  600626
  600783
  600795
  600824
  600842
  600846
  600861
  600871
  600940
  613766
  622086
  637869
  663486
  665477
  667527
  671647
  673881
  683840
  701890
  702063
  704084
  705531
  707225
  712804
  712805
  714926
  716204
  718851
  719418
  723661
  723693
  723733
  723952
  724041
  724818
  727423
  730760
  734542
  740191
  741050
  742618
  743147
  743784
  744093
  748024
  748396
  748399
  749649
  750548
  752821
  755134
  755461
  758420
  759158
  759857
  759951
  760692
  760860
  761003
  761509
  761589
  762627
  763222
  765894
  767670
  768206
  772942
  777107
  777910
  778716
  779608
  783277
  783783
  787244
  791314
  791452
  792859
  793314
  794513
  795048
  795368
  796504
  796606
  796637
  798969
  801865
  802076
  802170
  805350
  805353
  805428
  805927
  808205
  810062
]
2.19 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "боссу"
]
1.80 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "босс"
]
1.71 ms
(0.92%)
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.