GET https://search.jues.net/search/embeds/3?q=real%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.22 ms
(56.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real большие"
]
145.92 ms
(38.28%)
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
  204124
  274100
  400883
  401811
  421116
  478642
  478767
  483792
  488631
  493052
  520856
  529224
  529993
  530431
  533395
  534054
  534885
  539133
  539613
  554353
  561571
  572662
  575025
  575591
  605730
  622850
  622891
  625539
  628594
  632545
  635822
  659241
  666659
  668127
  668585
  670389
  674494
  679533
  681745
  682841
  688384
  690931
  693950
  707488
  710175
  712573
  714213
  714602
  714799
  716742
  719227
  719321
  721102
  721762
  722434
  724681
  726939
  727486
  728551
  730478
  730815
  730858
  732721
  733089
  733167
  734624
  735118
  736158
  736608
  737284
  737969
  741004
  741563
  742032
  743630
  744362
  745601
  746453
  747426
  750978
  753246
  755246
  756746
  759066
  760515
  761277
  763057
  769715
  775813
  779410
  780902
  785652
  788948
  798809
  799879
  799968
  801785
  802044
  807417
  808237
  813787
  813836
  818404
  820203
  820709
  821122
  821414
  821490
  821600
  822305
  823580
  824546
  824881
  824997
  825188
  825213
  825714
  826434
  827266
  827480
]
10.28 ms
(2.70%)
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
  821600
  821490
  826434
  821414
  825188
  534054
  575591
  554353
  668127
  670389
  679533
  681745
  688384
  712573
  719321
  668585
  714602
  716742
  721762
  659241
  714213
  605730
  622850
  622891
  632545
  779410
  785652
  788948
  737284
  753246
  724681
  730815
  736608
  726939
  727486
  730478
  737969
  746453
  763057
  735118
  755246
  759066
  760515
  761277
  721102
  798809
  799879
  802044
  400883
  401811
  825213
  488631
  529993
  539133
  529224
  520856
  530431
  674494
  666659
  682841
  690931
  722434
  635822
  775813
  736158
  743630
  750978
  744362
  745601
  747426
  732721
  756746
  741563
  625539
  719227
  801785
  204124
  807417
  741004
  824881
  813836
  821122
  534885
  693950
  572662
  728551
  734624
  742032
  730858
  733089
  769715
  733167
  628594
  707488
  780902
  799968
  808237
  561571
  710175
  274100
  421116
  824997
  813787
  818404
  822305
  824546
  827480
  820203
  820709
  823580
  825714
  827266
  483792
  493052
  478642
  539613
  533395
  478767
  575025
  714799
]
2.60 ms
(0.68%)
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
  204124
  274100
  400883
  401811
  421116
  478642
  478767
  483792
  488631
  493052
  520856
  529224
  529993
  530431
  533395
  534054
  534885
  539133
  539613
  554353
  561571
  572662
  575025
  575591
  605730
  622850
  622891
  625539
  628594
  632545
  635822
  659241
  666659
  668127
  668585
  670389
  674494
  679533
  681745
  682841
  688384
  690931
  693950
  707488
  710175
  712573
  714213
  714602
  714799
  716742
  719227
  719321
  721102
  721762
  722434
  724681
  726939
  727486
  728551
  730478
  730815
  730858
  732721
  733089
  733167
  734624
  735118
  736158
  736608
  737284
  737969
  741004
  741563
  742032
  743630
  744362
  745601
  746453
  747426
  750978
  753246
  755246
  756746
  759066
  760515
  761277
  763057
  769715
  775813
  779410
  780902
  785652
  788948
  798809
  799879
  799968
  801785
  802044
  807417
  808237
  813787
  813836
  818404
  820203
  820709
  821122
  821414
  821490
  821600
  822305
  823580
  824546
  824881
  824997
  825188
  825213
  825714
  826434
  827266
  827480
]
2.26 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real big"
]
1.52 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real большие"
]
1.35 ms
(0.36%)
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.