GET https://search.jues.net/search/embeds/2?q=%D0%BF%D1%8B%D1%82%D0%B0%D1%8E%D1%82%D1%81%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.49 ms
(85.51%)
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
  80821
  288584
  381226
  383377
  383512
  385009
  385341
  392779
  396424
  397203
  397436
  402971
  412380
  420799
  428289
  429486
  442027
  444397
  445752
  449216
  450047
  450611
  461641
  467922
  475014
  477645
  480671
  483702
  484173
  486068
  489877
  490846
  491098
  491240
  497598
  497609
  497618
  498158
  499327
  505599
  509450
  509527
  513202
  516844
  518431
  520158
  522994
  523281
  523687
  524046
  524154
  526013
  526651
  526668
  529086
  537613
  552382
  556849
  560717
  567022
  572976
  577920
  578766
  584374
  584609
  591913
  596919
  611898
  617512
  618447
  619864
  636636
  644078
  645571
  662126
  664215
  665588
  676977
  684970
  685464
  697400
  700770
  701936
  706165
  706527
  708105
  709148
  724486
  725230
  725731
  727053
  729160
  731110
  741856
  745548
  748920
  749644
  753981
  757631
  759179
  761097
  763578
  766259
  767918
  775764
  775773
  776064
  782541
  783745
  784017
  787723
  789857
  791885
  794060
  796563
  796616
  798249
  808572
  810850
  812184
]
14.55 ms
(8.61%)
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
  444397
  397203
  428289
  526651
  483702
  484173
  526013
  497598
  381226
  442027
  450047
  491240
  516844
  584374
  662126
  701936
  645571
  664215
  619864
  591913
  784017
  808572
  775764
  776064
  812184
  724486
  789857
  741856
  767918
  727053
  729160
  761097
  763578
  611898
  636636
  80821
  402971
  450611
  461641
  392779
  518431
  523281
  396424
  497618
  537613
  560717
  584609
  578766
  676977
  684970
  697400
  708105
  709148
  556849
  577920
  618447
  782541
  796563
  796616
  810850
  749644
  759179
  725230
  748920
  757631
  753981
  706527
  794060
  397436
  449216
  467922
  524046
  526668
  489877
  524154
  513202
  529086
  498158
  505599
  509450
  509527
  383377
  288584
  412380
  522994
  552382
  567022
  572976
  665588
  685464
  700770
  596919
  617512
  644078
  791885
  787723
  731110
  745548
  725731
  766259
  706165
  775773
  783745
  798249
  429486
  475014
  480671
  477645
  420799
  445752
  523687
  499327
  497609
  520158
  486068
  490846
  491098
  385009
  385341
  383512
]
3.47 ms
(2.05%)
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
  80821
  288584
  381226
  383377
  383512
  385009
  385341
  392779
  396424
  397203
  397436
  402971
  412380
  420799
  428289
  429486
  442027
  444397
  445752
  449216
  450047
  450611
  461641
  467922
  475014
  477645
  480671
  483702
  484173
  486068
  489877
  490846
  491098
  491240
  497598
  497609
  497618
  498158
  499327
  505599
  509450
  509527
  513202
  516844
  518431
  520158
  522994
  523281
  523687
  524046
  524154
  526013
  526651
  526668
  529086
  537613
  552382
  556849
  560717
  567022
  572976
  577920
  578766
  584374
  584609
  591913
  596919
  611898
  617512
  618447
  619864
  636636
  644078
  645571
  662126
  664215
  665588
  676977
  684970
  685464
  697400
  700770
  701936
  706165
  706527
  708105
  709148
  724486
  725230
  725731
  727053
  729160
  731110
  741856
  745548
  748920
  749644
  753981
  757631
  759179
  761097
  763578
  766259
  767918
  775764
  775773
  776064
  782541
  783745
  784017
  787723
  789857
  791885
  794060
  796563
  796616
  798249
  808572
  810850
  812184
]
1.88 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пытаются"
]
1.65 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пыта"
]
1.56 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пыта"
]
1.37 ms
(0.81%)
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.