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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.20 ms
(85.76%)
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
  389787
  391101
  465246
  476564
  482884
  494682
  501280
  506544
  514718
  522772
  527339
  530641
  533756
  539962
  543559
  546341
  546814
  550107
  550936
  553610
  553674
  553932
  554209
  562054
  562631
  570931
  581038
  588596
  589771
  592159
  595086
  608666
  608679
  610023
  618005
  618056
  622020
  628669
  632679
  633916
  643699
  649837
  652283
  653820
  655545
  661342
  661576
  665326
  666014
  666978
  671098
  672422
  677916
  692721
  692763
  695667
  696628
  696673
  696675
  696699
  696716
  697085
  701708
  702347
  707562
  709512
  709932
  714042
  718593
  724303
  728242
  729564
  732919
  733511
  734030
  734846
  738427
  739337
  739339
  742767
  751240
  751381
  751419
  755662
  757603
  759106
  762061
  769508
  772836
  778934
  779767
  779797
  779829
  779843
  780666
  780827
  780902
  783525
  783731
  783761
  788988
  790380
  791317
  791496
  797813
  798667
  798709
  805072
  809700
  812060
  812246
  818752
  819314
  821181
  823841
  826903
  828032
  828137
  828508
]
15.31 ms
(8.57%)
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
  672422
  695667
  709932
  652283
  661342
  696628
  696673
  696699
  707562
  546814
  554209
  632679
  592159
  739337
  805072
  751240
  757603
  762061
  732919
  553610
  506544
  821181
  546341
  550936
  562631
  692763
  692721
  618056
  779767
  783761
  778565
  779843
  797813
  809700
  728242
  738427
  755662
  769508
  742767
  783731
  788988
  812060
  628669
  780666
  828137
  790380
  828032
  633916
  588596
  826903
  581038
  553674
  476564
  514718
  649837
  661576
  798667
  759106
  389787
  714042
  734030
  729564
  562054
  653820
  570931
  783525
  791317
  550107
  608679
  671098
  677916
  739339
  527339
  543559
  724303
  818752
  465246
  702347
  553932
  610023
  778934
  779829
  780827
  772836
  779797
  798709
  494682
  655545
  608666
  589771
  733511
  697085
  780902
  819314
  823841
  828508
  522772
  665326
  643699
  812246
  734846
  751381
  791496
  501280
  666014
  595086
  391101
  482884
  533756
  530641
  666978
  709512
  696716
  696675
  701708
  622020
  751419
  718593
  618005
  539962
]
2.71 ms
(1.52%)
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
  389787
  391101
  465246
  476564
  482884
  494682
  501280
  506544
  514718
  522772
  527339
  530641
  533756
  539962
  543559
  546341
  546814
  550107
  550936
  553610
  553674
  553932
  554209
  562054
  562631
  570931
  581038
  588596
  589771
  592159
  595086
  608666
  608679
  610023
  618005
  618056
  622020
  628669
  632679
  633916
  643699
  649837
  652283
  653820
  655545
  661342
  661576
  665326
  666014
  666978
  671098
  672422
  677916
  692721
  692763
  695667
  696628
  696673
  696675
  696699
  696716
  697085
  701708
  702347
  707562
  709512
  709932
  714042
  718593
  724303
  728242
  729564
  732919
  733511
  734030
  734846
  738427
  739337
  739339
  742767
  751240
  751381
  751419
  755662
  757603
  759106
  762061
  769508
  772836
  778934
  779767
  779797
  779829
  779843
  780666
  780827
  780902
  783525
  783731
  783761
  788988
  790380
  791317
  791496
  797813
  798667
  798709
  805072
  809700
  812060
  812246
  818752
  819314
  821181
  823841
  826903
  828032
  828137
  828508
]
2.19 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц большие"
]
1.87 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public big"
]
1.68 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.93%)
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.