GET https://search.jues.net/search/embeds/5?q=vintage%20films

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.76 ms
(87.04%)
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
  476476
  516221
  538824
  538837
  538856
  538913
  539619
  539627
  541293
  541337
  541419
  541599
  541622
  541626
  541636
  541693
  541873
  541875
  542198
  542471
  543497
  544254
  544277
  544278
  544295
  544308
  544310
  544313
  544317
  544864
  547859
  547869
  548289
  549300
  549302
  549780
  556786
  556988
  560080
  560091
  560950
  561026
  562830
  562834
  562846
  562857
  563534
  563540
  566246
  566686
  566691
  566692
  566699
  572545
  573905
  573911
  574281
  576632
  576641
  576669
  576687
  577353
  577375
  581260
  581350
  581389
  583887
  587763
  587807
  598427
  601068
  603212
  618862
  620120
  620172
  622316
  628324
  644315
  644381
  648963
  649105
  650570
  650833
  670090
  670106
  670114
  671760
  671761
  672099
  672112
  672118
  681085
  681159
  687130
  690860
  692103
  692209
  694485
  699594
  703037
  703046
  703097
  703512
  703514
  703521
  705521
  705915
  715676
  716323
  719059
  719107
  722197
  730301
  740097
  744276
  744287
  750064
  800625
  813115
  823358
]
13.66 ms
(7.26%)
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
  715676
  541419
  581350
  750064
  476476
  538856
  539627
  544308
  572545
  581389
  549302
  549780
  692103
  719059
  719107
  672118
  648963
  670090
  672099
  681159
  694485
  547869
  562857
  603212
  622316
  587807
  730301
  740097
  722197
  542198
  541636
  541693
  628324
  823358
  538824
  544864
  560091
  574281
  544310
  547859
  576641
  649105
  690860
  692209
  705915
  670106
  670114
  699594
  703097
  703512
  671760
  672112
  681085
  687130
  705521
  556988
  618862
  644315
  598427
  644381
  620172
  800625
  813115
  744276
  744287
  703037
  703046
  703514
  703521
  541626
  539619
  516221
  538837
  538913
  541599
  543497
  544277
  544313
  544317
  548289
  562830
  576687
  577353
  581260
  583887
  541293
  541622
  541873
  544254
  560080
  562846
  563540
  566686
  566692
  573905
  573911
  577375
  541337
  541875
  542471
  544278
  544295
  549300
  562834
  563534
  566246
  566699
  576632
  576669
  650570
  671761
  716323
  650833
  556786
  560950
  561026
  566691
  587763
  601068
  620120
]
2.69 ms
(1.43%)
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
  476476
  516221
  538824
  538837
  538856
  538913
  539619
  539627
  541293
  541337
  541419
  541599
  541622
  541626
  541636
  541693
  541873
  541875
  542198
  542471
  543497
  544254
  544277
  544278
  544295
  544308
  544310
  544313
  544317
  544864
  547859
  547869
  548289
  549300
  549302
  549780
  556786
  556988
  560080
  560091
  560950
  561026
  562830
  562834
  562846
  562857
  563534
  563540
  566246
  566686
  566691
  566692
  566699
  572545
  573905
  573911
  574281
  576632
  576641
  576669
  576687
  577353
  577375
  581260
  581350
  581389
  583887
  587763
  587807
  598427
  601068
  603212
  618862
  620120
  620172
  622316
  628324
  644315
  644381
  648963
  649105
  650570
  650833
  670090
  670106
  670114
  671760
  671761
  672099
  672112
  672118
  681085
  681159
  687130
  690860
  692103
  692209
  694485
  699594
  703037
  703046
  703097
  703512
  703514
  703521
  705521
  705915
  715676
  716323
  719059
  719107
  722197
  730301
  740097
  744276
  744287
  750064
  800625
  813115
  823358
]
2.24 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vintage films"
]
2.02 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "vintage фильм"
]
1.92 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "vintage фильм"
]
1.85 ms
(0.98%)
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.