GET https://search.jues.net/search/embeds/7?q=%D1%81%D1%82%D0%BE%D0%BD%D0%B0%D0%BC%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.87 ms
(81.56%)
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
  58584
  401805
  406075
  429660
  434322
  438178
  466500
  474818
  475411
  476254
  481803
  482507
  507124
  507813
  508554
  513976
  518622
  520145
  520407
  526047
  526246
  528040
  532597
  538973
  541630
  541673
  546913
  552029
  555893
  556327
  560569
  561082
  561699
  561893
  565156
  565322
  567053
  567139
  568059
  568555
  570223
  570655
  571561
  571653
  573390
  573615
  575713
  581797
  582899
  583255
  584105
  584636
  584991
  585137
  585210
  587833
  587926
  589450
  589769
  590992
  591249
  591784
  591839
  593123
  594074
  594869
  596424
  596526
  597025
  597068
  598437
  599008
  599534
  599803
  600060
  601655
  601699
  602739
  604873
  605862
  606600
  610004
  610703
  611289
  613263
  613970
  614717
  615214
  617342
  618094
  618476
  618924
  619308
  619565
  620001
  620009
  621515
  622041
  622686
  624150
  625533
  626892
  627144
  628277
  641665
  649134
  653541
  653544
  654503
  655322
  655609
  655714
  656465
  657402
  658433
  662435
  663372
  663888
  682530
  684440
]
23.35 ms
(13.05%)
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
  584636
  590992
  601655
  619565
  601699
  476254
  58584
  434322
  508554
  518622
  513976
  520407
  584991
  507813
  570223
  573390
  582899
  684440
  656465
  561893
  568059
  570655
  597068
  613263
  622686
  585210
  599008
  606600
  610703
  593123
  618094
  587926
  596424
  602739
  619308
  627144
  475411
  401805
  429660
  481803
  507124
  526246
  532597
  538973
  585137
  482507
  583255
  584105
  571561
  575713
  653544
  655714
  658433
  649134
  662435
  653541
  573615
  589450
  591784
  594074
  596526
  597025
  615214
  621515
  594869
  618924
  622041
  591249
  613970
  587833
  599534
  600060
  604873
  618476
  641665
  466500
  406075
  438178
  474818
  520145
  526047
  528040
  546913
  555893
  565322
  567139
  541630
  541673
  556327
  561699
  565156
  552029
  560569
  561082
  567053
  568555
  654503
  655322
  663372
  655609
  657402
  663888
  682530
  571653
  581797
  605862
  611289
  617342
  620001
  625533
  626892
  589769
  591839
  598437
  599803
  610004
  614717
  620009
  624150
  628277
]
2.93 ms
(1.64%)
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
  58584
  401805
  406075
  429660
  434322
  438178
  466500
  474818
  475411
  476254
  481803
  482507
  507124
  507813
  508554
  513976
  518622
  520145
  520407
  526047
  526246
  528040
  532597
  538973
  541630
  541673
  546913
  552029
  555893
  556327
  560569
  561082
  561699
  561893
  565156
  565322
  567053
  567139
  568059
  568555
  570223
  570655
  571561
  571653
  573390
  573615
  575713
  581797
  582899
  583255
  584105
  584636
  584991
  585137
  585210
  587833
  587926
  589450
  589769
  590992
  591249
  591784
  591839
  593123
  594074
  594869
  596424
  596526
  597025
  597068
  598437
  599008
  599534
  599803
  600060
  601655
  601699
  602739
  604873
  605862
  606600
  610004
  610703
  611289
  613263
  613970
  614717
  615214
  617342
  618094
  618476
  618924
  619308
  619565
  620001
  620009
  621515
  622041
  622686
  624150
  625533
  626892
  627144
  628277
  641665
  649134
  653541
  653544
  654503
  655322
  655609
  655714
  656465
  657402
  658433
  662435
  663372
  663888
  682530
  684440
]
1.92 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "стон"
]
1.73 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "стонами"
]
1.67 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "стон"
]
1.39 ms
(0.78%)
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.