GET https://search.jues.net/search/embeds/8?q=%D1%80%D0%B5%D0%B0%D0%BB%D1%8C%D0%BD%D0%B8%D0%B9%20%D1%81

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.72 ms
(86.88%)
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
  478767
  487205
  489644
  491131
  493677
  493945
  498162
  507853
  514444
  517758
  523464
  525299
  530174
  530236
  530314
  530396
  530964
  531555
  531672
  532828
  534043
  535152
  535355
  536367
  536950
  537815
  537973
  539230
  541900
  543534
  543930
  546434
  546653
  552732
  554464
  555725
  558783
  564607
  565291
  565297
  566738
  567772
  567943
  567953
  570687
  574964
  579071
  588075
  588189
  588214
  589264
  592104
  592864
  593505
  596930
  597702
  599356
  602549
  604112
  612661
  612895
  618345
  621433
  621642
  627684
  636576
  645749
  647081
  648201
  649780
  656508
  668604
  668815
  679628
  682714
  684293
  684533
  688842
  691182
  695014
  696149
  699433
  701266
  712092
  718611
  719748
  726296
  728163
  729121
  730532
  735192
  736704
  743790
  746656
  748110
  748847
  749648
  753235
  753432
  759111
  760233
  763448
  768079
  768572
  784612
  787384
  794537
  795340
  803978
  806718
  817582
  818547
  818762
  823629
  823853
  824333
  824619
  824698
  824933
  825895
]
7.98 ms
(5.99%)
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
  636576
  596930
  602549
  825895
  818762
  823853
  824619
  817582
  824933
  818547
  823629
  824333
  824698
  531555
  531672
  530174
  530314
  530964
  532828
  535355
  570687
  541900
  558783
  543930
  546653
  684293
  699433
  712092
  718611
  649780
  656508
  668815
  566738
  592104
  597702
  599356
  618345
  588189
  593505
  612895
  627684
  748110
  726296
  728163
  753235
  753432
  735192
  759111
  763448
  730532
  743790
  746656
  748847
  768079
  803978
  567953
  567943
  648201
  679628
  696149
  719748
  682714
  688842
  588214
  589264
  612661
  621642
  588075
  592864
  794537
  736704
  787384
  806718
  729121
  749648
  768572
  760233
  604112
  795340
  537815
  487205
  514444
  555725
  564607
  701266
  691182
  668604
  684533
  695014
  621433
  784612
  498162
  493677
  489644
  491131
  507853
  523464
  535152
  539230
  534043
  536367
  536950
  525299
  530236
  517758
  530396
  537973
  478767
  493945
  554464
  565297
  567772
  543534
  546434
  552732
  574964
  579071
  565291
  645749
  647081
]
2.35 ms
(1.76%)
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
  478767
  487205
  489644
  491131
  493677
  493945
  498162
  507853
  514444
  517758
  523464
  525299
  530174
  530236
  530314
  530396
  530964
  531555
  531672
  532828
  534043
  535152
  535355
  536367
  536950
  537815
  537973
  539230
  541900
  543534
  543930
  546434
  546653
  552732
  554464
  555725
  558783
  564607
  565291
  565297
  566738
  567772
  567943
  567953
  570687
  574964
  579071
  588075
  588189
  588214
  589264
  592104
  592864
  593505
  596930
  597702
  599356
  602549
  604112
  612661
  612895
  618345
  621433
  621642
  627684
  636576
  645749
  647081
  648201
  649780
  656508
  668604
  668815
  679628
  682714
  684293
  684533
  688842
  691182
  695014
  696149
  699433
  701266
  712092
  718611
  719748
  726296
  728163
  729121
  730532
  735192
  736704
  743790
  746656
  748110
  748847
  749648
  753235
  753432
  759111
  760233
  763448
  768079
  768572
  784612
  787384
  794537
  795340
  803978
  806718
  817582
  818547
  818762
  823629
  823853
  824333
  824619
  824698
  824933
  825895
]
2.26 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "реальний с"
]
1.70 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск"
]
1.68 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.12%)
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.