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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.17 ms
(86.15%)
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
  69871
  125934
  132984
  172224
  191511
  197757
  233677
  365993
  386408
  387717
  388075
  390640
  396546
  398213
  402515
  406210
  412582
  458224
  466598
  470487
  487234
  510186
  512635
  515544
  515579
  520377
  521222
  525337
  526373
  527468
  530107
  533692
  533693
  535909
  536515
  540281
  540706
  541360
  542248
  545923
  551190
  553905
  557985
  558660
  559171
  560751
  564753
  565718
  567470
  568055
  570128
  576436
  577822
  579671
  584935
  587921
  589086
  589509
  598040
  598164
  599030
  599463
  607176
  610628
  613924
  617275
  620257
  622773
  624265
  645142
  647077
  650393
  652221
  657950
  658433
  671488
  698758
  704487
  705963
  709076
  720040
  728875
  730677
  732063
  734574
  736008
  738131
  738941
  739706
  742254
  743569
  743700
  744945
  746598
  751485
  754380
  754613
  754975
  755238
  755242
  764106
  764796
  767119
  768402
  768901
  771471
  772649
  774319
  776695
  781929
  786545
  788447
  789194
  797037
  797199
  803085
  803482
  813691
  813907
  814354
]
14.88 ms
(7.95%)
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
  771471
  774319
  732063
  738941
  744945
  754975
  764106
  767119
  728875
  730677
  738131
  739706
  742254
  751485
  755238
  755242
  764796
  768402
  768901
  734574
  736008
  743569
  743700
  746598
  754380
  754613
  772649
  624265
  698758
  704487
  705963
  709076
  720040
  776695
  781929
  786545
  788447
  789194
  797037
  797199
  803085
  803482
  69871
  233677
  365993
  412582
  197757
  172224
  388075
  466598
  398213
  521222
  526373
  551190
  557985
  565718
  577822
  658433
  568055
  589086
  598164
  613924
  617275
  599463
  607176
  610628
  620257
  587921
  589509
  598040
  599030
  622773
  458224
  406210
  470487
  515579
  525337
  527468
  510186
  515544
  386408
  132984
  125934
  191511
  390640
  387717
  396546
  402515
  813907
  814354
  813691
  487234
  512635
  530107
  533693
  536515
  520377
  540281
  533692
  535909
  540706
  541360
  542248
  553905
  576436
  559171
  564753
  570128
  584935
  545923
  558660
  560751
  567470
  579671
  645142
  647077
  650393
  652221
  657950
  671488
]
3.94 ms
(2.10%)
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
  69871
  125934
  132984
  172224
  191511
  197757
  233677
  365993
  386408
  387717
  388075
  390640
  396546
  398213
  402515
  406210
  412582
  458224
  466598
  470487
  487234
  510186
  512635
  515544
  515579
  520377
  521222
  525337
  526373
  527468
  530107
  533692
  533693
  535909
  536515
  540281
  540706
  541360
  542248
  545923
  551190
  553905
  557985
  558660
  559171
  560751
  564753
  565718
  567470
  568055
  570128
  576436
  577822
  579671
  584935
  587921
  589086
  589509
  598040
  598164
  599030
  599463
  607176
  610628
  613924
  617275
  620257
  622773
  624265
  645142
  647077
  650393
  652221
  657950
  658433
  671488
  698758
  704487
  705963
  709076
  720040
  728875
  730677
  732063
  734574
  736008
  738131
  738941
  739706
  742254
  743569
  743700
  744945
  746598
  751485
  754380
  754613
  754975
  755238
  755242
  764106
  764796
  767119
  768402
  768901
  771471
  772649
  774319
  776695
  781929
  786545
  788447
  789194
  797037
  797199
  803085
  803482
  813691
  813907
  814354
]
2.15 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "свое"
]
1.96 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сво"
]
1.51 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сво"
]
1.48 ms
(0.79%)
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.