GET https://search.jues.net/search/embeds/5?q=%D0%BD%D0%B0%20%D0%B4%D0%BE%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.52 ms
(85.51%)
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
  197
  194661
  316153
  400727
  401620
  401636
  410676
  428679
  461729
  465372
  489474
  497547
  528623
  530987
  533887
  533919
  535907
  544431
  551245
  553322
  558925
  563460
  566887
  571145
  587282
  587945
  591543
  620430
  620954
  623906
  630102
  631520
  634412
  634910
  634980
  635382
  644896
  661420
  670930
  674387
  687864
  695353
  697754
  701418
  704345
  711438
  713295
  714934
  716002
  723973
  724864
  725268
  727322
  730166
  731048
  734647
  735233
  736111
  738142
  738881
  740140
  745292
  747076
  747422
  747629
  750992
  752489
  754655
  755886
  759519
  760427
  761797
  761909
  762119
  763477
  763752
  764620
  764983
  766190
  766365
  766985
  766995
  768920
  769040
  771304
  771607
  776171
  778697
  780083
  781121
  781550
  782669
  783166
  783570
  783812
  784390
  785262
  785996
  786673
  786681
  787963
  789418
  790352
  791642
  794074
  794286
  794595
  795338
  795787
  797848
  801456
  802058
  804032
  810115
  810393
  811155
  811424
  812968
  813679
  816165
]
11.58 ms
(7.10%)
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
  778697
  786673
  750992
  738881
  761797
  754655
  783166
  465372
  497547
  316153
  786681
  785262
  811424
  755886
  725268
  731048
  735233
  760427
  766190
  768920
  769040
  761909
  771607
  730166
  785996
  194661
  794074
  763477
  551245
  401620
  816165
  811155
  771304
  794286
  766365
  781121
  795787
  801456
  783812
  661420
  544431
  528623
  533887
  530987
  553322
  563460
  670930
  674387
  713295
  704345
  687864
  695353
  571145
  587282
  620954
  635382
  591543
  620430
  634412
  587945
  623906
  752489
  724864
  764983
  630102
  631520
  634980
  697754
  701418
  461729
  533919
  634910
  428679
  401636
  738142
  197
  410676
  711438
  780083
  776171
  787963
  734647
  747629
  759519
  781550
  790352
  797848
  810393
  747422
  762119
  723973
  727322
  766985
  740140
  784390
  789418
  400727
  745292
  489474
  813679
  566887
  714934
  716002
  782669
  810115
  794595
  766995
  783570
  791642
  795338
  747076
  736111
  763752
  764620
  802058
  804032
  812968
  644896
  535907
  558925
]
3.98 ms
(2.44%)
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
  197
  194661
  316153
  400727
  401620
  401636
  410676
  428679
  461729
  465372
  489474
  497547
  528623
  530987
  533887
  533919
  535907
  544431
  551245
  553322
  558925
  563460
  566887
  571145
  587282
  587945
  591543
  620430
  620954
  623906
  630102
  631520
  634412
  634910
  634980
  635382
  644896
  661420
  670930
  674387
  687864
  695353
  697754
  701418
  704345
  711438
  713295
  714934
  716002
  723973
  724864
  725268
  727322
  730166
  731048
  734647
  735233
  736111
  738142
  738881
  740140
  745292
  747076
  747422
  747629
  750992
  752489
  754655
  755886
  759519
  760427
  761797
  761909
  762119
  763477
  763752
  764620
  764983
  766190
  766365
  766985
  766995
  768920
  769040
  771304
  771607
  776171
  778697
  780083
  781121
  781550
  782669
  783166
  783570
  783812
  784390
  785262
  785996
  786673
  786681
  787963
  789418
  790352
  791642
  794074
  794286
  794595
  795338
  795787
  797848
  801456
  802058
  804032
  810115
  810393
  811155
  811424
  812968
  813679
  816165
]
2.85 ms
(1.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на дом"
]
1.70 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на домашн любительск"
]
1.64 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.