GET https://search.jues.net/search/embeds/8?q=%D0%BF%D0%B8%D0%BA%D0%B0%D0%BF%D0%B5%20%D0%B2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
334.47 ms
(92.22%)
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
  58516
  91578
  220769
  263788
  330764
  365381
  381822
  382381
  388124
  398515
  409134
  417758
  425638
  428382
  428784
  435060
  443655
  444412
  451602
  453680
  453916
  457150
  457169
  461221
  465177
  465745
  466425
  466664
  466675
  467133
  469159
  471593
  476387
  476744
  477582
  480066
  483231
  486425
  486485
  487095
  487144
  488212
  488286
  488565
  490119
  490462
  491379
  491641
  491719
  491721
  496800
  497661
  499968
  501306
  504597
  505236
  505986
  508828
  508836
  509765
  510617
  511704
  512665
  513290
  513292
  513302
  513541
  516379
  518263
  518397
  521912
  521928
  522535
  523510
  524178
  525640
  527503
  527511
  527549
  527620
  533157
  540482
  544683
  546015
  551640
  565361
  565372
  565414
  565551
  565561
  566810
  570030
  570620
  570639
  570644
  570661
  571884
  572499
  572520
  575117
  575499
  578059
  578068
  605318
  611820
  611900
  638647
  669609
  669643
  671409
  672402
  691607
  723878
  725563
  729441
  741175
  748200
  753907
  769139
  820677
]
18.07 ms
(4.98%)
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
  382381
  466675
  417758
  453680
  466425
  435060
  465177
  504597
  516379
  527503
  487095
  490119
  491379
  491721
  509765
  511704
  513292
  483231
  486425
  508828
  513302
  525640
  501306
  523510
  611820
  443655
  444412
  486485
  476744
  499968
  513541
  466664
  469159
  565361
  570030
  575499
  578068
  565551
  571884
  551640
  570620
  578059
  565372
  565414
  565561
  570644
  575117
  451602
  457169
  480066
  428784
  457150
  471593
  476387
  425638
  428382
  512665
  513290
  527620
  488286
  491641
  491719
  505986
  518397
  521928
  518263
  521912
  524178
  540482
  488212
  505236
  508836
  510617
  527549
  611900
  570661
  546015
  572520
  453916
  465745
  490462
  487144
  605318
  58516
  533157
  729441
  522535
  91578
  398515
  409134
  820677
  488565
  669609
  723878
  725563
  753907
  769139
  741175
  748200
  381822
  263788
  527511
  544683
  467133
  497661
  477582
  570639
  671409
  672402
  691607
  638647
  388124
  365381
  572499
  669643
  496800
  461221
  566810
  220769
  330764
]
2.64 ms
(0.73%)
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
  58516
  91578
  220769
  263788
  330764
  365381
  381822
  382381
  388124
  398515
  409134
  417758
  425638
  428382
  428784
  435060
  443655
  444412
  451602
  453680
  453916
  457150
  457169
  461221
  465177
  465745
  466425
  466664
  466675
  467133
  469159
  471593
  476387
  476744
  477582
  480066
  483231
  486425
  486485
  487095
  487144
  488212
  488286
  488565
  490119
  490462
  491379
  491641
  491719
  491721
  496800
  497661
  499968
  501306
  504597
  505236
  505986
  508828
  508836
  509765
  510617
  511704
  512665
  513290
  513292
  513302
  513541
  516379
  518263
  518397
  521912
  521928
  522535
  523510
  524178
  525640
  527503
  527511
  527549
  527620
  533157
  540482
  544683
  546015
  551640
  565361
  565372
  565414
  565551
  565561
  566810
  570030
  570620
  570639
  570644
  570661
  571884
  572499
  572520
  575117
  575499
  578059
  578068
  605318
  611820
  611900
  638647
  669609
  669643
  671409
  672402
  691607
  723878
  725563
  729441
  741175
  748200
  753907
  769139
  820677
]
2.18 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пикапе в"
]
1.85 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап в"
]
1.76 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.48%)
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.