GET https://search.jues.net/search/embeds/6?q=%D0%BC%D1%83%D0%B6%20%D0%BF%D0%BE%D0%B4%D1%80%D1%83%D0%B3%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.73 ms
(85.99%)
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
  12148
  48068
  150899
  260590
  263331
  387436
  392165
  395367
  398023
  400301
  400585
  403100
  404083
  409189
  411404
  411564
  424809
  425033
  427502
  460259
  465103
  469546
  479922
  484398
  484583
  496805
  500504
  504281
  509910
  513474
  518835
  519240
  520130
  524638
  531642
  535771
  536203
  538135
  538978
  542211
  546091
  547132
  549114
  549503
  549786
  550809
  558696
  559967
  574182
  575672
  578631
  584137
  586315
  590465
  600426
  602114
  602392
  602431
  606097
  606356
  607486
  607651
  615586
  616206
  616589
  619622
  622076
  622289
  624550
  628101
  631031
  631219
  635366
  635521
  635605
  646424
  647765
  648316
  648987
  651799
  664659
  681756
  683669
  689927
  689971
  690923
  691535
  693740
  695334
  702926
  705208
  710678
  716235
  724005
  731357
  734186
  736237
  737429
  740734
  741081
  741129
  742919
  746345
  753067
  755110
  775654
  779893
  780511
  794465
  794476
  795676
  796322
  796774
  797159
  797378
  800436
  800652
  801672
  803647
  813875
]
13.64 ms
(7.58%)
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
  635366
  607486
  622289
  606356
  780511
  797378
  775654
  801672
  736237
  746345
  753067
  724005
  737429
  731357
  716235
  794465
  797159
  404083
  409189
  12148
  387436
  425033
  664659
  500504
  519240
  465103
  469546
  549786
  624550
  509910
  518835
  484583
  520130
  484398
  513474
  578631
  460259
  427502
  403100
  424809
  524638
  504281
  150899
  395367
  392165
  263331
  260590
  48068
  398023
  400301
  400585
  411564
  411404
  813875
  479922
  531642
  538135
  538978
  536203
  496805
  535771
  542211
  550809
  574182
  575672
  546091
  547132
  549503
  584137
  559967
  648316
  689927
  690923
  646424
  681756
  683669
  689971
  691535
  705208
  710678
  647765
  648987
  651799
  693740
  695334
  702926
  549114
  558696
  586315
  602114
  602392
  607651
  616206
  616589
  619622
  635521
  590465
  602431
  622076
  635605
  600426
  631031
  631219
  606097
  615586
  628101
  779893
  794476
  795676
  796322
  800436
  800652
  803647
  796774
  734186
  740734
  741081
  741129
  742919
  755110
]
3.27 ms
(1.82%)
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
  12148
  48068
  150899
  260590
  263331
  387436
  392165
  395367
  398023
  400301
  400585
  403100
  404083
  409189
  411404
  411564
  424809
  425033
  427502
  460259
  465103
  469546
  479922
  484398
  484583
  496805
  500504
  504281
  509910
  513474
  518835
  519240
  520130
  524638
  531642
  535771
  536203
  538135
  538978
  542211
  546091
  547132
  549114
  549503
  549786
  550809
  558696
  559967
  574182
  575672
  578631
  584137
  586315
  590465
  600426
  602114
  602392
  602431
  606097
  606356
  607486
  607651
  615586
  616206
  616589
  619622
  622076
  622289
  624550
  628101
  631031
  631219
  635366
  635521
  635605
  646424
  647765
  648316
  648987
  651799
  664659
  681756
  683669
  689927
  689971
  690923
  691535
  693740
  695334
  702926
  705208
  710678
  716235
  724005
  731357
  734186
  736237
  737429
  740734
  741081
  741129
  742919
  746345
  753067
  755110
  775654
  779893
  780511
  794465
  794476
  795676
  796322
  796774
  797159
  797378
  800436
  800652
  801672
  803647
  813875
]
2.21 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "муж подруги"
]
2.10 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен подружк"
]
2.09 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен подружк"
]
1.89 ms
(1.05%)
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.