GET https://search.jues.net/search/embeds/2?q=%D0%B4%D0%B0%D0%BB%20%D0%B2%20%D1%80%D0%BE%D1%82%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.12 ms
(86.40%)
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
  236359
  311176
  351650
  365839
  365881
  385890
  387081
  389597
  392678
  398105
  398602
  398714
  401522
  409952
  412517
  417544
  418433
  436372
  437986
  444201
  445349
  457255
  460785
  462160
  465076
  472995
  476470
  484175
  485872
  490130
  493250
  494518
  501351
  503466
  511686
  518819
  520206
  522936
  527318
  529136
  529515
  533056
  535801
  536122
  541865
  546558
  546793
  547772
  551090
  552562
  553659
  559247
  559312
  561843
  563632
  564068
  566866
  568892
  571419
  571745
  575440
  576751
  588814
  590577
  591039
  605729
  614000
  616486
  618796
  624648
  625005
  628451
  629520
  631285
  631316
  636636
  642084
  655457
  655465
  659381
  664562
  673230
  679233
  680786
  685431
  685525
  690744
  691751
  695318
  717222
  719310
  723238
  726373
  733797
  735029
  739608
  742987
  749882
  752505
  757740
  758483
  763865
  764601
  764667
  766041
  766385
  766463
  777806
  780140
  781081
  782133
  782514
  782680
  784700
  788101
  791161
  799850
  800091
  809979
  810548
]
15.57 ms
(8.35%)
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
  735029
  726373
  739608
  749882
  757740
  764667
  642084
  546558
  236359
  398105
  476470
  564068
  685525
  493250
  351650
  398602
  462160
  551090
  445349
  518819
  533056
  576751
  568892
  655457
  680786
  719310
  723238
  629520
  810548
  781081
  766385
  733797
  624648
  636636
  782133
  782514
  392678
  559247
  631285
  385890
  444201
  566866
  552562
  547772
  742987
  412517
  311176
  365839
  503466
  490130
  401522
  501351
  494518
  529136
  571745
  571419
  655465
  685431
  695318
  553659
  625005
  614000
  631316
  777806
  791161
  799850
  809979
  717222
  529515
  398714
  457255
  472995
  664562
  679233
  763865
  436372
  409952
  484175
  522936
  511686
  563632
  628451
  591039
  616486
  766041
  389597
  417544
  437986
  618796
  485872
  465076
  536122
  535801
  520206
  460785
  559312
  541865
  546793
  561843
  691751
  659381
  673230
  575440
  590577
  605729
  782680
  752505
  764601
  784700
  800091
  766463
  758483
  780140
  788101
  387081
  418433
  365881
  527318
  690744
  588814
]
2.38 ms
(1.28%)
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
  236359
  311176
  351650
  365839
  365881
  385890
  387081
  389597
  392678
  398105
  398602
  398714
  401522
  409952
  412517
  417544
  418433
  436372
  437986
  444201
  445349
  457255
  460785
  462160
  465076
  472995
  476470
  484175
  485872
  490130
  493250
  494518
  501351
  503466
  511686
  518819
  520206
  522936
  527318
  529136
  529515
  533056
  535801
  536122
  541865
  546558
  546793
  547772
  551090
  552562
  553659
  559247
  559312
  561843
  563632
  564068
  566866
  568892
  571419
  571745
  575440
  576751
  588814
  590577
  591039
  605729
  614000
  616486
  618796
  624648
  625005
  628451
  629520
  631285
  631316
  636636
  642084
  655457
  655465
  659381
  664562
  673230
  679233
  680786
  685431
  685525
  690744
  691751
  695318
  717222
  719310
  723238
  726373
  733797
  735029
  739608
  742987
  749882
  752505
  757740
  758483
  763865
  764601
  764667
  766041
  766385
  766463
  777806
  780140
  781081
  782133
  782514
  782680
  784700
  788101
  791161
  799850
  800091
  809979
  810548
]
2.21 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дал в рота"
]
1.99 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в рот"
]
1.59 ms
(0.85%)
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.