GET https://search.jues.net/search/embeds/3?q=%D0%B5%D0%B1%D0%B5%D1%82%20%D0%B4%D0%B2%D1%83%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.40 ms
(88.83%)
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
  5873
  7196
  92307
  104130
  114730
  122817
  130060
  187842
  202032
  282494
  346979
  378046
  385292
  387074
  387228
  387537
  388647
  389197
  395682
  395738
  396590
  400537
  400753
  401119
  401586
  403979
  404371
  406685
  410124
  414368
  415573
  416118
  421118
  421543
  423893
  424328
  425050
  427515
  428479
  428786
  445641
  445971
  447240
  447962
  448823
  454120
  454147
  454191
  458905
  462835
  464365
  464887
  465299
  468593
  471587
  472750
  473066
  473737
  474066
  475272
  483230
  484795
  487902
  494567
  503507
  504165
  506841
  512330
  514667
  514997
  519891
  522221
  525487
  525688
  525946
  533953
  536491
  537671
  538267
  541871
  548788
  551129
  556063
  557189
  564923
  567829
  569140
  570214
  574534
  576359
  585012
  585013
  604662
  609279
  611986
  613410
  619058
  634818
  644813
  649912
  653622
  675172
  716746
  725297
  744441
  750081
  750880
  757638
  761823
  770670
  773098
  776196
  776396
  781277
  782783
  784315
  797430
  797908
  809663
  811975
]
15.74 ms
(6.77%)
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
  609279
  401586
  797908
  130060
  744441
  770670
  750081
  346979
  761823
  776196
  388647
  811975
  282494
  202032
  428786
  585012
  483230
  809663
  725297
  750880
  773098
  187842
  653622
  675172
  797430
  716746
  92307
  551129
  385292
  448823
  404371
  427515
  387074
  421543
  644813
  403979
  503507
  387228
  389197
  556063
  514997
  414368
  585013
  447962
  548788
  415573
  613410
  569140
  757638
  471587
  104130
  410124
  557189
  401119
  512330
  484795
  537671
  406685
  538267
  536491
  781277
  395682
  475272
  519891
  525946
  454120
  421118
  506841
  465299
  395738
  468593
  387537
  445971
  396590
  474066
  454191
  423893
  447240
  464365
  649912
  564923
  522221
  567829
  424328
  473066
  504165
  425050
  525688
  445641
  634818
  611986
  472750
  541871
  619058
  782783
  400537
  776396
  114730
  576359
  462835
  570214
  574534
  604662
  514667
  400753
  428479
  7196
  378046
  473737
  784315
  416118
  487902
  5873
  533953
  458905
  454147
  122817
  494567
  525487
  464887
]
3.13 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебет двух"
]
2.83 ms
(1.22%)
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
  5873
  7196
  92307
  104130
  114730
  122817
  130060
  187842
  202032
  282494
  346979
  378046
  385292
  387074
  387228
  387537
  388647
  389197
  395682
  395738
  396590
  400537
  400753
  401119
  401586
  403979
  404371
  406685
  410124
  414368
  415573
  416118
  421118
  421543
  423893
  424328
  425050
  427515
  428479
  428786
  445641
  445971
  447240
  447962
  448823
  454120
  454147
  454191
  458905
  462835
  464365
  464887
  465299
  468593
  471587
  472750
  473066
  473737
  474066
  475272
  483230
  484795
  487902
  494567
  503507
  504165
  506841
  512330
  514667
  514997
  519891
  522221
  525487
  525688
  525946
  533953
  536491
  537671
  538267
  541871
  548788
  551129
  556063
  557189
  564923
  567829
  569140
  570214
  574534
  576359
  585012
  585013
  604662
  609279
  611986
  613410
  619058
  634818
  644813
  649912
  653622
  675172
  716746
  725297
  744441
  750081
  750880
  757638
  761823
  770670
  773098
  776196
  776396
  781277
  782783
  784315
  797430
  797908
  809663
  811975
]
1.70 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс двух"
]
1.39 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.17 ms
(0.50%)
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.