GET https://search.jues.net/search/embeds/7?q=%D1%80%D0%BE%D1%82%20%D0%B2%D1%8B%D0%B5%D0%B1%D0%B0%D0%BB%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.48 ms
(89.31%)
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
  4510
  47079
  78760
  79683
  224590
  271093
  383477
  386389
  386940
  390521
  397502
  398331
  401157
  402756
  407159
  434465
  461061
  489260
  490519
  491804
  493250
  496231
  497372
  501998
  511943
  516214
  518477
  519251
  519727
  524984
  526338
  526807
  530762
  534507
  536703
  540253
  540745
  541157
  541379
  544969
  547950
  548067
  553663
  554581
  554835
  555809
  558954
  558988
  559155
  559497
  571408
  571461
  573496
  575238
  579029
  584059
  590582
  593691
  600768
  601437
  610880
  610893
  614617
  624960
  625283
  628213
  632882
  634588
  639911
  646980
  651746
  651795
  654472
  657800
  661618
  666819
  667168
  676767
  678159
  683477
  683649
  689216
  689266
  695454
  697549
  701894
  708326
  711052
  711071
  715844
  717118
  726313
  726373
  736643
  738222
  738341
  754700
  754742
  754821
  762737
  762740
  777808
  778136
  779735
  781084
  782325
  786576
  787598
  790269
  790272
  790299
  791168
  791456
  792255
  792349
  793174
  799813
  799851
  802341
  804875
]
16.19 ms
(6.84%)
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
  461061
  536703
  678159
  519251
  654472
  584059
  519727
  541379
  666819
  559155
  491804
  530762
  548067
  790269
  553663
  402756
  790272
  524984
  683477
  496231
  571408
  571461
  540253
  554835
  555809
  632882
  434465
  676767
  526807
  490519
  79683
  554581
  501998
  489260
  541157
  4510
  625283
  791456
  386389
  736643
  762737
  782325
  540745
  600768
  792255
  754742
  779735
  657800
  526338
  593691
  544969
  516214
  386940
  534507
  661618
  701894
  695454
  575238
  610880
  792349
  738341
  610893
  78760
  579029
  781084
  518477
  497372
  646980
  493250
  689216
  401157
  651746
  804875
  799813
  754821
  407159
  558988
  624960
  639911
  590582
  802341
  790299
  726313
  711052
  711071
  777808
  383477
  547950
  778136
  786576
  793174
  738222
  791168
  754700
  762740
  224590
  634588
  683649
  573496
  651795
  787598
  726373
  390521
  47079
  601437
  397502
  511943
  717118
  715844
  708326
  628213
  614617
  799851
  271093
  398331
  559497
  558954
  689266
  667168
  697549
]
2.95 ms
(1.25%)
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
  4510
  47079
  78760
  79683
  224590
  271093
  383477
  386389
  386940
  390521
  397502
  398331
  401157
  402756
  407159
  434465
  461061
  489260
  490519
  491804
  493250
  496231
  497372
  501998
  511943
  516214
  518477
  519251
  519727
  524984
  526338
  526807
  530762
  534507
  536703
  540253
  540745
  541157
  541379
  544969
  547950
  548067
  553663
  554581
  554835
  555809
  558954
  558988
  559155
  559497
  571408
  571461
  573496
  575238
  579029
  584059
  590582
  593691
  600768
  601437
  610880
  610893
  614617
  624960
  625283
  628213
  632882
  634588
  639911
  646980
  651746
  651795
  654472
  657800
  661618
  666819
  667168
  676767
  678159
  683477
  683649
  689216
  689266
  695454
  697549
  701894
  708326
  711052
  711071
  715844
  717118
  726313
  726373
  736643
  738222
  738341
  754700
  754742
  754821
  762737
  762740
  777808
  778136
  779735
  781084
  782325
  786576
  787598
  790269
  790272
  790299
  791168
  791456
  792255
  792349
  793174
  799813
  799851
  802341
  804875
]
1.87 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рот секс"
]
1.51 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рот выебали"
]
1.27 ms
(0.54%)
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.