GET https://search.jues.net/search/embeds/4?q=%D0%BD%D0%B5%20%D0%B2%D1%81%D1%82%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.20 ms
(85.22%)
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
  390624
  396168
  402683
  422550
  433572
  448537
  451523
  467428
  467973
  468091
  476079
  478771
  483328
  484554
  487262
  487872
  489237
  490851
  491319
  494693
  497953
  499852
  500455
  502680
  506264
  507834
  508538
  509135
  510070
  512099
  516780
  517000
  519993
  520310
  521043
  521871
  522585
  524492
  525391
  525878
  530064
  535094
  535306
  535937
  538007
  538290
  545725
  549823
  551989
  552294
  557034
  558127
  558468
  558524
  558640
  561275
  562995
  565572
  569562
  573074
  573603
  573981
  579527
  580706
  582258
  586533
  587933
  591247
  591249
  594400
  598161
  598724
  598838
  599216
  601846
  601867
  601906
  601995
  602010
  603812
  604021
  604364
  608407
  608553
  611616
  613210
  613359
  613396
  613401
  614649
  614717
  616905
  617641
  618334
  618335
  619519
  619794
  619965
  620048
  621112
  621239
  621454
  621489
  622407
  622838
  623235
  624131
  624776
  625437
  625441
  625533
  626302
  626485
  636248
  636250
  651937
  655410
  659216
  662445
  663347
]
19.86 ms
(9.77%)
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
  591247
  591249
  601995
  604021
  613210
  614649
  619794
  622838
  599216
  601867
  601906
  626485
  625441
  402683
  467428
  467973
  476079
  509135
  520310
  502680
  535937
  535094
  558127
  651937
  624131
  489237
  522585
  662445
  613396
  497953
  491319
  510070
  549823
  552294
  558468
  569562
  573074
  573603
  573981
  545725
  558640
  579527
  580706
  557034
  586533
  433572
  390624
  468091
  451523
  500455
  516780
  494693
  507834
  521871
  525391
  525878
  490851
  506264
  535306
  487872
  512099
  538007
  562995
  582258
  551989
  655410
  659216
  663347
  558524
  565572
  611616
  621454
  622407
  623235
  625437
  625533
  636250
  594400
  598724
  598838
  601846
  603812
  614717
  616905
  621112
  621239
  621489
  587933
  598161
  613401
  618335
  619965
  620048
  626302
  608407
  608553
  613359
  617641
  618334
  624776
  602010
  604364
  619519
  636248
  396168
  478771
  521043
  538290
  483328
  519993
  484554
  508538
  524492
  530064
  499852
  517000
  422550
  448537
  487262
  561275
]
3.10 ms
(1.53%)
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
  390624
  396168
  402683
  422550
  433572
  448537
  451523
  467428
  467973
  468091
  476079
  478771
  483328
  484554
  487262
  487872
  489237
  490851
  491319
  494693
  497953
  499852
  500455
  502680
  506264
  507834
  508538
  509135
  510070
  512099
  516780
  517000
  519993
  520310
  521043
  521871
  522585
  524492
  525391
  525878
  530064
  535094
  535306
  535937
  538007
  538290
  545725
  549823
  551989
  552294
  557034
  558127
  558468
  558524
  558640
  561275
  562995
  565572
  569562
  573074
  573603
  573981
  579527
  580706
  582258
  586533
  587933
  591247
  591249
  594400
  598161
  598724
  598838
  599216
  601846
  601867
  601906
  601995
  602010
  603812
  604021
  604364
  608407
  608553
  611616
  613210
  613359
  613396
  613401
  614649
  614717
  616905
  617641
  618334
  618335
  619519
  619794
  619965
  620048
  621112
  621239
  621454
  621489
  622407
  622838
  623235
  624131
  624776
  625437
  625441
  625533
  626302
  626485
  636248
  636250
  651937
  655410
  659216
  662445
  663347
]
1.98 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "не встал"
]
1.90 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "не встал"
]
1.81 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "не встал"
]
1.38 ms
(0.68%)
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.