GET https://search.jues.net/search/embeds/7?q=%D0%BF%D1%8B%D1%88%D0%BD%D1%8B

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.21 ms
(86.77%)
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
  4252
  8164
  28453
  44998
  78479
  88549
  188621
  218669
  250422
  308282
  358259
  381952
  382815
  383098
  383820
  384445
  384478
  384871
  385581
  386395
  387365
  389616
  389819
  394439
  395659
  396001
  397812
  399421
  400337
  400375
  401352
  402042
  402195
  403984
  407359
  411118
  411186
  415907
  416102
  417218
  417870
  423765
  425592
  426770
  442473
  444237
  444289
  450216
  452946
  455129
  457359
  457956
  459024
  459741
  465232
  467819
  468516
  471052
  472812
  473827
  480908
  481353
  483477
  490590
  494932
  495814
  502592
  502805
  511316
  511890
  512814
  514114
  515615
  526715
  607650
  609376
  614733
  699802
  714528
  716164
  725576
  727785
  728429
  730970
  732433
  734390
  735845
  735956
  738209
  738297
  739948
  743748
  743839
  744220
  747355
  748523
  749930
  753783
  754191
  756347
  758923
  760406
  766120
  773226
  773438
  773579
  776402
  781369
  788230
  791099
  792618
  796548
  797103
  799568
  799872
  800005
  805730
  808699
  810221
]
15.47 ms
(7.62%)
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
  754191
  766120
  773579
  792618
  800005
  805730
  810221
  730970
  732433
  748523
  758923
  760406
  773226
  728429
  739948
  743839
  773438
  725576
  734390
  735845
  735956
  738209
  738297
  743748
  744220
  727785
  728648
  747355
  749930
  753783
  756347
  607650
  609376
  614733
  699802
  714528
  716164
  776402
  781369
  788230
  791099
  796548
  797103
  799568
  799872
  808699
  88549
  308282
  396001
  400337
  407359
  455129
  457359
  457956
  467819
  480908
  358259
  384445
  387365
  395659
  400375
  403984
  426770
  442473
  452946
  459024
  472812
  473827
  8164
  78479
  425592
  444237
  459741
  465232
  468516
  471052
  250422
  382815
  401352
  444289
  450216
  411118
  481353
  502805
  511316
  483477
  490590
  495814
  502592
  526715
  494932
  511890
  512814
  514114
  515615
  386395
  385581
  384478
  384871
  383098
  383820
  218669
  188621
  394439
  381952
  44998
  28453
  4252
  389616
  389819
  397812
  399421
  402195
  402042
  411186
  416102
  417870
  415907
  417218
  423765
]
4.00 ms
(1.97%)
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
  4252
  8164
  28453
  44998
  78479
  88549
  188621
  218669
  250422
  308282
  358259
  381952
  382815
  383098
  383820
  384445
  384478
  384871
  385581
  386395
  387365
  389616
  389819
  394439
  395659
  396001
  397812
  399421
  400337
  400375
  401352
  402042
  402195
  403984
  407359
  411118
  411186
  415907
  416102
  417218
  417870
  423765
  425592
  426770
  442473
  444237
  444289
  450216
  452946
  455129
  457359
  457956
  459024
  459741
  465232
  467819
  468516
  471052
  472812
  473827
  480908
  481353
  483477
  490590
  494932
  495814
  502592
  502805
  511316
  511890
  512814
  514114
  515615
  526715
  607650
  609376
  614733
  699802
  714528
  716164
  725576
  727785
  728429
  730970
  732433
  734390
  735845
  735956
  738209
  738297
  739948
  743748
  743839
  744220
  747355
  748523
  749930
  753783
  754191
  756347
  758923
  760406
  766120
  773226
  773438
  773579
  776402
  781369
  788230
  791099
  792618
  796548
  797103
  799568
  799872
  800005
  805730
  808699
  810221
]
2.33 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пышны"
]
2.08 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пышн"
]
1.63 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.