GET https://search.jues.net/search/embeds/2?q=vintage%20long

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.37 ms
(52.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "vintage длинные"
]
168.53 ms
(41.10%)
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
  492442
  538862
  538931
  540446
  541309
  541361
  542487
  544257
  544264
  544272
  544312
  546625
  550036
  550328
  551681
  560087
  563452
  565123
  566293
  566299
  567995
  568018
  571837
  573321
  573919
  574227
  574282
  576122
  581279
  581339
  583858
  592391
  592470
  592539
  592543
  594186
  608040
  614321
  614354
  614741
  614989
  620175
  625757
  625796
  626556
  628319
  629286
  629324
  629902
  643033
  644287
  644953
  646337
  648209
  648912
  649933
  651205
  651603
  651681
  652252
  652269
  653577
  668160
  670067
  671705
  672717
  673493
  673531
  674131
  677738
  685220
  687192
  690774
  690823
  690850
  691509
  691521
  691527
  692214
  692222
  692418
  693060
  693863
  693991
  694110
  694127
  694214
  695204
  695242
  695921
  695950
  696248
  696358
  696554
  698513
  698579
  699383
  699540
  699698
  699708
  708785
  709720
  716786
  718489
  718518
  722142
  725176
  730225
  730272
  730524
  733299
  733539
  740296
  742138
  742803
  744443
  744566
  746581
  752728
  790407
]
15.72 ms
(3.83%)
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
  746581
  730272
  742803
  744566
  629286
  629902
  718489
  581339
  668160
  592470
  628319
  709720
  541309
  644953
  538862
  538931
  565123
  567995
  573321
  581279
  542487
  544257
  544312
  550036
  574282
  653577
  695242
  695950
  699383
  699698
  651603
  651681
  677738
  691509
  692222
  694110
  695204
  695921
  716786
  722142
  648209
  649933
  651205
  670067
  672717
  674131
  687192
  690823
  690850
  691521
  692214
  693060
  576122
  592539
  592391
  614321
  614989
  620175
  626556
  643033
  614354
  644287
  740296
  742138
  544264
  573919
  583858
  685220
  540446
  544272
  560087
  571837
  566299
  546625
  566293
  568018
  646337
  652252
  690774
  693863
  696554
  648912
  673493
  673531
  693991
  694127
  694214
  696358
  698513
  698579
  699540
  652269
  671705
  691527
  692418
  696248
  708785
  550328
  551681
  563452
  574227
  592543
  594186
  614741
  625796
  790407
  730225
  725176
  730524
  733299
  744443
  733539
  752728
  608040
  625757
  629324
  699708
  718518
  492442
  541361
]
4.28 ms
(1.04%)
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
  492442
  538862
  538931
  540446
  541309
  541361
  542487
  544257
  544264
  544272
  544312
  546625
  550036
  550328
  551681
  560087
  563452
  565123
  566293
  566299
  567995
  568018
  571837
  573321
  573919
  574227
  574282
  576122
  581279
  581339
  583858
  592391
  592470
  592539
  592543
  594186
  608040
  614321
  614354
  614741
  614989
  620175
  625757
  625796
  626556
  628319
  629286
  629324
  629902
  643033
  644287
  644953
  646337
  648209
  648912
  649933
  651205
  651603
  651681
  652252
  652269
  653577
  668160
  670067
  671705
  672717
  673493
  673531
  674131
  677738
  685220
  687192
  690774
  690823
  690850
  691509
  691521
  691527
  692214
  692222
  692418
  693060
  693863
  693991
  694110
  694127
  694214
  695204
  695242
  695921
  695950
  696248
  696358
  696554
  698513
  698579
  699383
  699540
  699698
  699708
  708785
  709720
  716786
  718489
  718518
  722142
  725176
  730225
  730272
  730524
  733299
  733539
  740296
  742138
  742803
  744443
  744566
  746581
  752728
  790407
]
2.14 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.07 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vintage long"
]
1.94 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "vintage длинные"
]

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.