GET https://search.jues.net/search/embeds/3?q=retro%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.86 ms
(85.85%)
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
  95986
  388110
  504252
  511391
  519227
  519241
  519252
  526873
  540679
  544257
  544304
  544343
  544355
  544589
  546625
  547840
  549282
  550039
  557108
  558428
  560801
  561552
  561594
  563203
  566485
  566680
  567381
  567961
  568272
  574203
  576127
  576718
  581374
  583835
  586850
  592441
  592457
  592458
  592461
  595311
  599566
  606841
  608040
  613521
  622352
  622894
  624467
  624754
  626563
  628300
  628302
  629286
  629311
  632868
  637519
  641478
  644003
  644368
  648485
  649933
  650317
  650363
  650371
  651603
  651617
  651902
  652173
  652566
  652958
  652991
  653572
  653577
  661902
  664243
  670067
  671098
  671237
  672693
  672717
  672852
  673517
  677735
  677738
  678419
  685305
  687114
  687127
  692123
  692472
  692788
  693046
  693298
  693859
  693918
  694110
  694112
  694147
  694195
  695921
  696270
  697282
  697301
  701297
  701427
  701489
  706907
  711894
  717992
  724814
  730202
  738753
  740557
  744443
  746581
  749166
  776726
  780666
  789454
  790395
]
11.94 ms
(7.13%)
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
  622894
  790395
  771167
  637519
  701489
  652958
  671237
  672852
  644368
  544343
  568272
  574203
  576127
  650371
  664243
  687114
  692472
  692788
  693046
  694147
  650317
  652566
  653572
  557108
  599566
  629311
  592441
  592458
  586850
  776726
  740557
  746581
  629286
  789454
  526873
  540679
  544589
  549282
  558428
  566485
  550039
  561552
  650363
  673517
  677735
  678419
  685305
  687127
  696270
  648485
  651617
  693918
  694195
  706907
  672693
  697282
  717992
  560801
  566680
  606841
  644003
  632868
  626563
  628302
  641478
  595311
  624467
  780666
  724814
  749166
  738753
  730202
  567961
  697301
  628300
  95986
  511391
  519241
  561594
  563203
  567381
  583835
  592457
  592461
  519227
  544304
  547840
  695921
  701297
  711894
  649933
  651902
  652991
  670067
  672717
  624754
  622352
  613521
  701427
  504252
  576718
  388110
  519252
  546625
  671098
  744443
  608040
  544257
  581374
  544355
  652173
  653577
  693859
  694112
  651603
  661902
  677738
  692123
  693298
  694110
]
3.41 ms
(2.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
  95986
  388110
  504252
  511391
  519227
  519241
  519252
  526873
  540679
  544257
  544304
  544343
  544355
  544589
  546625
  547840
  549282
  550039
  557108
  558428
  560801
  561552
  561594
  563203
  566485
  566680
  567381
  567961
  568272
  574203
  576127
  576718
  581374
  583835
  586850
  592441
  592457
  592458
  592461
  595311
  599566
  606841
  608040
  613521
  622352
  622894
  624467
  624754
  626563
  628300
  628302
  629286
  629311
  632868
  637519
  641478
  644003
  644368
  648485
  649933
  650317
  650363
  650371
  651603
  651617
  651902
  652173
  652566
  652958
  652991
  653572
  653577
  661902
  664243
  670067
  671098
  671237
  672693
  672717
  672852
  673517
  677735
  677738
  678419
  685305
  687114
  687127
  692123
  692472
  692788
  693046
  693298
  693859
  693918
  694110
  694112
  694147
  694195
  695921
  696270
  697282
  697301
  701297
  701427
  701489
  706907
  711894
  717992
  724814
  730202
  738753
  740557
  744443
  746581
  749166
  776726
  780666
  789454
  790395
]
2.34 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro girls"
]
2.14 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр девушк"
]
1.99 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр девушк"
]
1.89 ms
(1.13%)
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.