GET https://search.jues.net/search/embeds/10?q=beautiful%20sleep

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.05 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
  417121
  417692
  418331
  425023
  429289
  431521
  432663
  442021
  442400
  446988
  451172
  452696
  453668
  463225
  466721
  475033
  475116
  475309
  475508
  477327
  477441
  478326
  478645
  478762
  480654
  481435
  484249
  485784
  486675
  490031
  492330
  495694
  503752
  506127
  510341
  513596
  513897
  514771
  514789
  515135
  518212
  519179
  519850
  519976
  521056
  521907
  522443
  523395
  526087
  528592
  528803
  528855
  532820
  534025
  541728
  543907
  547834
  548782
  549354
  550630
  551162
  552650
  555608
  555740
  556817
  556840
  557196
  558164
  559951
  560513
  560584
  561639
  561828
  564056
  564161
  564423
  567003
  567316
  569972
  569980
  571203
  573742
  574035
  574503
  575103
  575482
  576387
  580166
  581825
  582390
  583367
  583819
  586594
  586789
  586919
  595361
  597067
  597284
  598532
  599297
  599734
  601355
  605412
  607193
  608036
  615438
  615495
  620983
  621308
  623797
  631632
  645011
  659398
  679365
  681445
  687185
  687270
  687271
  814335
  820126
]
21.31 ms
(8.49%)
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
  521907
  573742
  583819
  561828
  477327
  484249
  485784
  519179
  503752
  557196
  564161
  567003
  567316
  559951
  586594
  477441
  446988
  475033
  475508
  528592
  495694
  510341
  526087
  515135
  518212
  523395
  528803
  541728
  429289
  418331
  431521
  442021
  417692
  417121
  425023
  432663
  442400
  814335
  820126
  558164
  451172
  453668
  463225
  466721
  478762
  452696
  475116
  475309
  478326
  478645
  480654
  490031
  492330
  486675
  513897
  506127
  513596
  519850
  521056
  522443
  532820
  534025
  514771
  514789
  528855
  519976
  481435
  543907
  549354
  551162
  555608
  556817
  575482
  576387
  580166
  582390
  548782
  556840
  569972
  569980
  574035
  574503
  555740
  560584
  564056
  564423
  581825
  583367
  659398
  687270
  679365
  681445
  687185
  645011
  687271
  547834
  550630
  552650
  560513
  561639
  571203
  575103
  586789
  599734
  608036
  623797
  595361
  599297
  601355
  615495
  620983
  597067
  597284
  607193
  621308
  631632
  586919
  598532
  605412
  615438
]
5.64 ms
(2.25%)
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
  417121
  417692
  418331
  425023
  429289
  431521
  432663
  442021
  442400
  446988
  451172
  452696
  453668
  463225
  466721
  475033
  475116
  475309
  475508
  477327
  477441
  478326
  478645
  478762
  480654
  481435
  484249
  485784
  486675
  490031
  492330
  495694
  503752
  506127
  510341
  513596
  513897
  514771
  514789
  515135
  518212
  519179
  519850
  519976
  521056
  521907
  522443
  523395
  526087
  528592
  528803
  528855
  532820
  534025
  541728
  543907
  547834
  548782
  549354
  550630
  551162
  552650
  555608
  555740
  556817
  556840
  557196
  558164
  559951
  560513
  560584
  561639
  561828
  564056
  564161
  564423
  567003
  567316
  569972
  569980
  571203
  573742
  574035
  574503
  575103
  575482
  576387
  580166
  581825
  582390
  583367
  583819
  586594
  586789
  586919
  595361
  597067
  597284
  598532
  599297
  599734
  601355
  605412
  607193
  608036
  615438
  615495
  620983
  621308
  623797
  631632
  645011
  659398
  679365
  681445
  687185
  687270
  687271
  814335
  820126
]
1.92 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful sleep"
]
1.61 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая спящ"
]
1.48 ms
(0.59%)
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.