GET https://search.jues.net/search/embeds/6?q=%D1%81%D0%B2%D0%BE%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.39 ms
(86.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
  4497
  48366
  89362
  233489
  359492
  393350
  401634
  401636
  412493
  416426
  443491
  457162
  462101
  467967
  468487
  472931
  474784
  476709
  490308
  495038
  501616
  504376
  515601
  516274
  516784
  519347
  537596
  544093
  554310
  562731
  564992
  575459
  576317
  578703
  592005
  593180
  593975
  594842
  599313
  602754
  603130
  618561
  618679
  626616
  636247
  638047
  656336
  656846
  658723
  673044
  673567
  684314
  696265
  698607
  700495
  705966
  706687
  713197
  713458
  715403
  720540
  726116
  727327
  728144
  732132
  735541
  735547
  736689
  737700
  738950
  739082
  739654
  742110
  742527
  742832
  743228
  743250
  743251
  748017
  749053
  749388
  750444
  751395
  753604
  753667
  753682
  754624
  755889
  757266
  758038
  758344
  759061
  759577
  760634
  763368
  766284
  769840
  773606
  776244
  780180
  780562
  780678
  783140
  786206
  787195
  790659
  790758
  792473
  793244
  795026
  796618
  797069
  800961
  801427
  803733
  804390
  806592
  810631
  812338
  814221
]
11.70 ms
(7.19%)
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
  603130
  790659
  793244
  797069
  803733
  812338
  727327
  737700
  739654
  743228
  748017
  749053
  758344
  759061
  800961
  726116
  728144
  739082
  743250
  753604
  769840
  735541
  749388
  751395
  700495
  713458
  780180
  780562
  787195
  790758
  801427
  476709
  575459
  576317
  578703
  562731
  564992
  592005
  602754
  593180
  636247
  593975
  599313
  618561
  626616
  416426
  443491
  467967
  474784
  462101
  472931
  457162
  468487
  515601
  516274
  495038
  504376
  516784
  537596
  490308
  519347
  89362
  814221
  544093
  554310
  656846
  684314
  658723
  673044
  673567
  698607
  656336
  696265
  705966
  713197
  715403
  720540
  594842
  618679
  638047
  776244
  796618
  804390
  780678
  786206
  735547
  742832
  757266
  759577
  783140
  806592
  742110
  754624
  736689
  742527
  743251
  753667
  766284
  732132
  753682
  755889
  738950
  750444
  758038
  760634
  763368
  773606
  706687
  792473
  795026
  810631
  401634
  401636
  233489
  393350
  359492
  48366
  4497
  412493
  501616
]
3.87 ms
(2.38%)
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
  4497
  48366
  89362
  233489
  359492
  393350
  401634
  401636
  412493
  416426
  443491
  457162
  462101
  467967
  468487
  472931
  474784
  476709
  490308
  495038
  501616
  504376
  515601
  516274
  516784
  519347
  537596
  544093
  554310
  562731
  564992
  575459
  576317
  578703
  592005
  593180
  593975
  594842
  599313
  602754
  603130
  618561
  618679
  626616
  636247
  638047
  656336
  656846
  658723
  673044
  673567
  684314
  696265
  698607
  700495
  705966
  706687
  713197
  713458
  715403
  720540
  726116
  727327
  728144
  732132
  735541
  735547
  736689
  737700
  738950
  739082
  739654
  742110
  742527
  742832
  743228
  743250
  743251
  748017
  749053
  749388
  750444
  751395
  753604
  753667
  753682
  754624
  755889
  757266
  758038
  758344
  759061
  759577
  760634
  763368
  766284
  769840
  773606
  776244
  780180
  780562
  780678
  783140
  786206
  787195
  790659
  790758
  792473
  793244
  795026
  796618
  797069
  800961
  801427
  803733
  804390
  806592
  810631
  812338
  814221
]
1.94 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "свое"
]
1.87 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сво"
]
1.63 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.89%)
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.