GET https://search.jues.net/search/embeds/5?q=%D1%81%D0%B2%D0%BE%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.72 ms
(86.84%)
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
  81603
  147313
  147403
  163310
  203480
  336860
  401570
  407369
  411228
  414175
  415273
  416000
  417338
  424293
  425025
  446682
  452950
  454931
  457152
  458031
  468282
  472105
  473609
  482536
  483212
  484418
  484622
  490192
  490606
  496647
  500034
  500482
  503546
  504141
  504227
  506433
  506820
  506966
  508489
  508856
  509256
  511567
  511946
  512851
  513103
  513492
  516673
  517325
  520262
  520598
  521199
  523748
  523829
  525061
  527666
  543251
  543492
  545329
  557172
  565584
  566122
  570535
  572199
  574833
  576112
  577556
  584054
  591428
  593108
  593114
  596839
  598698
  599441
  599962
  600458
  601511
  602594
  605544
  606806
  617212
  617621
  618008
  621020
  621607
  628324
  633257
  633498
  640987
  656841
  662445
  664221
  668818
  670424
  702756
  704913
  705609
  707295
  718158
  725449
  739009
  740176
  740705
  741165
  750219
  752908
  752992
  753538
  753734
  754631
  770637
  773603
  776686
  777943
  778371
  778674
  790027
  790043
  798684
  802427
]
15.15 ms
(8.29%)
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
  506433
  508489
  511567
  513103
  513492
  525061
  500034
  504227
  508856
  523829
  662445
  617212
  147313
  336860
  753734
  416000
  414175
  458031
  484418
  527666
  500482
  516673
  570535
  572199
  574833
  565584
  598698
  593114
  599441
  600458
  617621
  605544
  628324
  798684
  468282
  417338
  425025
  472105
  473609
  452950
  503546
  520262
  504141
  506820
  512851
  520598
  483212
  490192
  496647
  509256
  147403
  163310
  656841
  778674
  754631
  790043
  81603
  401570
  596839
  523748
  718158
  790027
  773672
  740705
  752908
  739009
  770637
  750219
  752992
  484622
  482536
  577556
  566122
  576112
  545329
  601511
  606806
  602594
  621020
  621607
  599962
  618008
  633498
  591428
  415273
  457152
  446682
  454931
  511946
  517325
  490606
  506966
  411228
  543251
  702756
  670424
  704913
  776686
  778371
  773603
  802427
  740176
  753538
  725449
  741165
  640987
  705609
  777943
  203480
  407369
  424293
  521199
  584054
  543492
  707295
  668818
  664221
  557172
  633257
  593108
]
2.26 ms
(1.24%)
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
  81603
  147313
  147403
  163310
  203480
  336860
  401570
  407369
  411228
  414175
  415273
  416000
  417338
  424293
  425025
  446682
  452950
  454931
  457152
  458031
  468282
  472105
  473609
  482536
  483212
  484418
  484622
  490192
  490606
  496647
  500034
  500482
  503546
  504141
  504227
  506433
  506820
  506966
  508489
  508856
  509256
  511567
  511946
  512851
  513103
  513492
  516673
  517325
  520262
  520598
  521199
  523748
  523829
  525061
  527666
  543251
  543492
  545329
  557172
  565584
  566122
  570535
  572199
  574833
  576112
  577556
  584054
  591428
  593108
  593114
  596839
  598698
  599441
  599962
  600458
  601511
  602594
  605544
  606806
  617212
  617621
  618008
  621020
  621607
  628324
  633257
  633498
  640987
  656841
  662445
  664221
  668818
  670424
  702756
  704913
  705609
  707295
  718158
  725449
  739009
  740176
  740705
  741165
  750219
  752908
  752992
  753538
  753734
  754631
  770637
  773603
  776686
  777943
  778371
  778674
  790027
  790043
  798684
  802427
]
2.06 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сво"
]
1.80 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "свое"
]
1.44 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.73%)
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.