GET https://search.jues.net/search/embeds/6?q=%D1%83%D0%BB%D0%B8%D1%86%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
200.23 ms
(88.47%)
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
  49767
  385608
  386671
  390397
  404101
  446139
  463644
  466670
  495761
  504101
  506444
  513057
  522561
  523044
  524648
  525734
  527665
  530397
  533711
  534619
  540101
  540705
  540708
  541194
  542460
  546164
  549781
  552283
  552497
  553707
  555677
  555826
  556093
  560164
  560166
  561203
  561387
  562032
  569024
  575663
  577679
  582461
  582514
  616457
  616839
  617789
  618662
  618955
  622283
  623352
  626411
  628623
  631136
  633408
  635519
  644850
  649905
  649913
  661357
  661577
  663836
  663893
  669857
  669899
  669905
  681546
  685523
  685525
  695674
  696004
  696052
  696685
  697934
  698709
  700906
  701628
  702350
  702372
  708090
  713145
  713951
  714042
  717600
  718600
  718703
  720474
  721918
  730499
  735838
  738950
  741078
  760856
  765796
  767437
  772500
  774084
  779614
  783656
  787485
  790395
  798922
  798938
  798959
  802927
  812228
  813338
  814096
  814715
  817620
  819240
  820920
  823038
  823155
  825633
  828021
  828114
  828139
  828140
  828263
]
15.50 ms
(6.85%)
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
  828140
  828139
  828114
  390397
  819240
  825633
  820920
  814096
  817620
  823038
  823155
  828021
  828263
  540101
  541194
  542460
  561203
  702350
  702372
  713951
  708090
  635519
  790395
  798922
  798938
  812228
  783656
  787485
  813338
  735838
  741078
  767437
  772500
  774084
  730499
  760856
  738950
  765796
  618662
  717600
  798959
  802927
  49767
  385608
  446139
  524648
  522561
  527665
  534619
  495761
  466670
  582514
  569024
  714042
  649905
  681546
  577679
  633408
  463644
  386671
  404101
  644850
  814715
  513057
  530397
  540705
  525734
  533711
  540708
  504101
  506444
  523044
  549781
  552283
  552497
  555826
  560166
  561387
  562032
  546559
  553707
  560164
  575663
  546164
  555677
  556093
  661357
  685523
  685525
  695674
  649913
  663836
  663893
  669857
  669899
  696004
  696052
  696685
  700906
  713145
  718703
  720474
  661577
  669905
  697934
  698709
  701628
  718600
  721918
  582461
  616457
  626411
  628623
  622283
  616839
  631136
  617789
  618955
  623352
  779614
]
2.84 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "улице"
]
2.75 ms
(1.22%)
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
  49767
  385608
  386671
  390397
  404101
  446139
  463644
  466670
  495761
  504101
  506444
  513057
  522561
  523044
  524648
  525734
  527665
  530397
  533711
  534619
  540101
  540705
  540708
  541194
  542460
  546164
  549781
  552283
  552497
  553707
  555677
  555826
  556093
  560164
  560166
  561203
  561387
  562032
  569024
  575663
  577679
  582461
  582514
  616457
  616839
  617789
  618662
  618955
  622283
  623352
  626411
  628623
  631136
  633408
  635519
  644850
  649905
  649913
  661357
  661577
  663836
  663893
  669857
  669899
  669905
  681546
  685523
  685525
  695674
  696004
  696052
  696685
  697934
  698709
  700906
  701628
  702350
  702372
  708090
  713145
  713951
  714042
  717600
  718600
  718703
  720474
  721918
  730499
  735838
  738950
  741078
  760856
  765796
  767437
  772500
  774084
  779614
  783656
  787485
  790395
  798922
  798938
  798959
  802927
  812228
  813338
  814096
  814715
  817620
  819240
  820920
  823038
  823155
  825633
  828021
  828114
  828139
  828140
  828263
]
1.97 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "улиц"
]
1.57 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.65%)
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.