GET https://search.jues.net/search/embeds/6?q=%D1%81%D0%BE%D1%81%D0%B5%D0%B4%D0%B8%20%D1%81%D0%B5%D0%BA%D1%81

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.08 ms
(84.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
  281801
  388767
  391815
  393408
  394610
  395235
  398522
  398544
  400342
  433704
  460298
  468952
  470693
  477285
  484623
  488563
  490125
  493107
  497782
  514208
  523499
  531564
  536974
  537636
  538165
  541722
  544639
  548604
  552141
  556648
  567477
  586312
  599681
  603906
  616070
  620085
  620363
  621786
  627773
  641367
  641920
  642274
  643934
  643988
  650088
  650294
  662559
  663301
  671223
  676213
  684876
  694417
  695735
  699156
  699946
  701763
  706211
  707174
  709677
  709834
  710097
  710356
  712646
  713585
  713587
  714777
  715498
  717578
  718863
  726999
  727450
  730645
  731703
  733161
  739910
  743496
  746949
  747540
  749994
  751974
  752173
  755857
  759680
  761593
  764056
  764691
  766056
  769205
  769535
  771488
  771531
  776216
  777184
  777995
  779889
  783993
  784382
  786168
  788062
  788400
  788445
  789578
  790325
  791124
  791819
  793655
  794816
  795236
  795445
  796679
  798043
  802860
  804037
  804941
  805697
  806088
  807328
  810201
  813446
  813845
]
17.34 ms
(9.61%)
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
  761593
  746949
  769535
  713585
  813446
  627773
  400342
  398544
  813845
  490125
  460298
  537636
  497782
  556648
  676213
  718863
  650088
  710356
  663301
  694417
  695735
  699946
  552141
  620363
  789578
  791124
  777184
  784382
  794816
  798043
  747540
  766056
  788062
  790325
  795236
  749994
  743496
  726999
  709677
  804037
  398522
  712646
  642274
  769205
  733161
  281801
  395235
  538165
  684876
  671223
  641367
  727450
  752173
  771531
  764691
  777995
  802860
  804941
  470693
  484623
  391815
  433704
  488563
  514208
  548604
  713587
  709834
  643934
  805697
  779889
  783993
  755857
  786168
  788445
  791819
  751974
  764056
  739910
  731703
  388767
  393408
  394610
  603906
  523499
  620085
  531564
  706211
  662559
  701763
  715498
  621786
  806088
  771488
  796679
  730645
  759680
  616070
  699156
  717578
  468952
  536974
  477285
  493107
  541722
  650294
  707174
  710097
  714777
  544639
  567477
  643988
  641920
  586312
  599681
  776216
  788400
  793655
  807328
  810201
  795445
]
3.25 ms
(1.80%)
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
  281801
  388767
  391815
  393408
  394610
  395235
  398522
  398544
  400342
  433704
  460298
  468952
  470693
  477285
  484623
  488563
  490125
  493107
  497782
  514208
  523499
  531564
  536974
  537636
  538165
  541722
  544639
  548604
  552141
  556648
  567477
  586312
  599681
  603906
  616070
  620085
  620363
  621786
  627773
  641367
  641920
  642274
  643934
  643988
  650088
  650294
  662559
  663301
  671223
  676213
  684876
  694417
  695735
  699156
  699946
  701763
  706211
  707174
  709677
  709834
  710097
  710356
  712646
  713585
  713587
  714777
  715498
  717578
  718863
  726999
  727450
  730645
  731703
  733161
  739910
  743496
  746949
  747540
  749994
  751974
  752173
  755857
  759680
  761593
  764056
  764691
  766056
  769205
  769535
  771488
  771531
  776216
  777184
  777995
  779889
  783993
  784382
  786168
  788062
  788400
  788445
  789578
  790325
  791124
  791819
  793655
  794816
  795236
  795445
  796679
  798043
  802860
  804037
  804941
  805697
  806088
  807328
  810201
  813446
  813845
]
1.93 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосед секс"
]
1.89 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соседи секс"
]
1.57 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сосед секс"
]
1.51 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.