GET https://search.jues.net/search/embeds/3?q=compilation%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.04 ms
(83.66%)
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
  73280
  73421
  389499
  396406
  407491
  417849
  420212
  423571
  425360
  438208
  442647
  442985
  443669
  443941
  446134
  449611
  450995
  451703
  451711
  457661
  459783
  460679
  460724
  466685
  467078
  467638
  479114
  480833
  481047
  486234
  486961
  487101
  496066
  497473
  497478
  498077
  499870
  502300
  503852
  506014
  510132
  510953
  516490
  518877
  519190
  520711
  521355
  523142
  527434
  533187
  539133
  539137
  540222
  540232
  541118
  541316
  542600
  543446
  544362
  547303
  548592
  549400
  550498
  551090
  554528
  558197
  559158
  568410
  575692
  583817
  587202
  589462
  589629
  592489
  592839
  595068
  596149
  601026
  605028
  605119
  605149
  605163
  606583
  606611
  610235
  612959
  619501
  634481
  644448
  648466
  650011
  650408
  681313
  692222
  698981
  705740
  742246
  746578
  756212
  759240
  772600
  775739
  788178
  788576
  789016
  789725
  789962
  790024
  791589
  799663
  802700
  803129
  804171
  804943
  805356
  805374
  808655
  809477
  819238
  825296
]
14.60 ms
(9.54%)
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
  634481
  605119
  605149
  789016
  804943
  73280
  73421
  417849
  539137
  396406
  442985
  467638
  498077
  527434
  466685
  423571
  540222
  583817
  541118
  559158
  558197
  606583
  592839
  595068
  619501
  808655
  791589
  803129
  772600
  788576
  756212
  389499
  497478
  520711
  521355
  497473
  523142
  496066
  610235
  438208
  425360
  825296
  446134
  460724
  539133
  533187
  575692
  543446
  544362
  705740
  692222
  650408
  601026
  605028
  605163
  596149
  589629
  789725
  799663
  805356
  802700
  742246
  746578
  775739
  789962
  790024
  443941
  819238
  460679
  450995
  487101
  540232
  554528
  542600
  547303
  549400
  550498
  568410
  650011
  587202
  612959
  804171
  788178
  805374
  759240
  644448
  442647
  451711
  467078
  407491
  451703
  459783
  443669
  449611
  457661
  480833
  503852
  486234
  506014
  510132
  502300
  486961
  499870
  510953
  551090
  518877
  519190
  541316
  548592
  648466
  681313
  589462
  592489
  606611
  809477
  698981
  420212
  481047
  479114
  516490
]
2.99 ms
(1.95%)
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
  73280
  73421
  389499
  396406
  407491
  417849
  420212
  423571
  425360
  438208
  442647
  442985
  443669
  443941
  446134
  449611
  450995
  451703
  451711
  457661
  459783
  460679
  460724
  466685
  467078
  467638
  479114
  480833
  481047
  486234
  486961
  487101
  496066
  497473
  497478
  498077
  499870
  502300
  503852
  506014
  510132
  510953
  516490
  518877
  519190
  520711
  521355
  523142
  527434
  533187
  539133
  539137
  540222
  540232
  541118
  541316
  542600
  543446
  544362
  547303
  548592
  549400
  550498
  551090
  554528
  558197
  559158
  568410
  575692
  583817
  587202
  589462
  589629
  592489
  592839
  595068
  596149
  601026
  605028
  605119
  605149
  605163
  606583
  606611
  610235
  612959
  619501
  634481
  644448
  648466
  650011
  650408
  681313
  692222
  698981
  705740
  742246
  746578
  756212
  759240
  772600
  775739
  788178
  788576
  789016
  789725
  789962
  790024
  791589
  799663
  802700
  803129
  804171
  804943
  805356
  805374
  808655
  809477
  819238
  825296
]
1.92 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation mom"
]
1.87 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк mom"
]
1.84 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк mom"
]
1.78 ms
(1.17%)
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.