GET https://search.jues.net/search/embeds/4?q=%D0%BC%D0%BE%D0%B5%20%D0%B5%D0%B1%D0%BB%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.34 ms
(89.35%)
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
  501513
  540760
  555747
  557005
  558460
  559478
  559739
  563882
  565205
  603782
  603841
  611491
  618306
  622323
  623319
  623479
  630329
  633241
  637504
  642259
  647316
  661894
  662857
  680730
  680806
  680808
  683496
  684419
  685448
  685460
  685478
  687107
  687680
  693153
  703245
  703625
  707927
  708749
  709872
  712380
  712655
  712943
  713151
  715596
  717378
  719792
  729413
  730103
  732906
  733221
  733516
  734051
  734397
  734404
  734789
  736745
  739582
  740533
  741788
  742334
  742618
  742632
  745985
  747625
  747799
  749676
  754644
  757740
  757870
  758389
  758426
  758853
  759518
  761300
  761662
  761872
  762004
  763431
  766150
  766631
  767611
  768141
  770500
  773059
  773786
  773910
  777028
  778754
  779485
  782931
  783063
  787619
  788054
  788586
  790084
  790542
  791811
  793314
  796144
  797550
  797565
  797645
  798055
  798788
  799681
  800396
  800582
  800794
  800801
  801611
  802022
  802144
  806590
  809683
  812155
  812335
  812437
  813413
  814663
]
14.25 ms
(6.17%)
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
  758853
  799681
  757740
  603782
  773910
  684419
  557005
  662857
  703625
  680806
  713151
  623319
  788586
  800582
  742334
  729413
  742618
  758389
  709872
  796144
  800801
  802144
  687680
  637504
  791811
  797565
  801611
  730103
  733221
  747625
  734051
  734404
  747799
  687107
  693153
  812335
  788054
  739582
  680730
  680808
  812437
  777028
  734789
  763431
  770500
  745985
  754644
  800794
  798055
  779485
  712380
  501513
  540760
  647316
  708749
  568067
  642259
  611491
  758426
  790084
  740533
  736745
  759518
  806590
  809683
  559739
  712943
  719792
  555747
  559478
  778754
  800396
  741788
  797645
  761872
  742632
  761300
  761662
  773786
  683496
  707927
  685478
  717378
  793314
  797550
  757870
  623479
  715596
  787619
  712655
  814663
  565205
  685448
  661894
  685460
  633241
  802022
  766150
  768141
  783063
  558460
  782931
  812155
  767611
  603841
  622323
  618306
  630329
  798788
  790542
  813413
  773059
  732906
  733516
  766631
  762004
  703245
  563882
  734397
  749676
]
3.19 ms
(1.38%)
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
  501513
  540760
  555747
  557005
  558460
  559478
  559739
  563882
  565205
  603782
  603841
  611491
  618306
  622323
  623319
  623479
  630329
  633241
  637504
  642259
  647316
  661894
  662857
  680730
  680806
  680808
  683496
  684419
  685448
  685460
  685478
  687107
  687680
  693153
  703245
  703625
  707927
  708749
  709872
  712380
  712655
  712943
  713151
  715596
  717378
  719792
  729413
  730103
  732906
  733221
  733516
  734051
  734397
  734404
  734789
  736745
  739582
  740533
  741788
  742334
  742618
  742632
  745985
  747625
  747799
  749676
  754644
  757740
  757870
  758389
  758426
  758853
  759518
  761300
  761662
  761872
  762004
  763431
  766150
  766631
  767611
  768141
  770500
  773059
  773786
  773910
  777028
  778754
  779485
  782931
  783063
  787619
  788054
  788586
  790084
  790542
  791811
  793314
  796144
  797550
  797565
  797645
  798055
  798788
  799681
  800396
  800582
  800794
  800801
  801611
  802022
  802144
  806590
  809683
  812155
  812335
  812437
  813413
  814663
]
1.95 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мое ебля"
]
1.88 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мо секс"
]
1.47 ms
(0.64%)
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.