GET https://search.jues.net/search/embeds/3?q=%D0%B3%D0%BE%D1%80%D0%BB%D0%BE%20%D1%82%D1%80%D0%B0%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
272.81 ms
(93.92%)
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
  500971
  507514
  529649
  531363
  549215
  590780
  595695
  609809
  615460
  618088
  620969
  632496
  633561
  636918
  639065
  652434
  658481
  660275
  671166
  683252
  687105
  688121
  695074
  700869
  704487
  709406
  710393
  716601
  716626
  716630
  716645
  716727
  716736
  716820
  716831
  717211
  719408
  722135
  722148
  725073
  726215
  727494
  727511
  728875
  729919
  730281
  731388
  731699
  734608
  742944
  743850
  744400
  745887
  747403
  753078
  754278
  758894
  760477
  761327
  763250
  763263
  763321
  763325
  763329
  763335
  763380
  763634
  767397
  767520
  767521
  767525
  767544
  768187
  768220
  768237
  768550
  770035
  774623
  775480
  776179
  776508
  776512
  778031
  778511
  779546
  779759
  783217
  783298
  783787
  784690
  785442
  785486
  787037
  787213
  787493
  792157
  792264
  792338
  792363
  793349
  793389
  793439
  793455
  793476
  793746
  793747
  793759
  793764
  793767
  794725
  797547
  799381
  799703
  799748
  805623
  806862
  809188
  810264
  810615
  814310
]
7.05 ms
(2.43%)
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
  730281
  767525
  763250
  704487
  778031
  660275
  636918
  794725
  799703
  507514
  793767
  753078
  745887
  728875
  763634
  710393
  793389
  793747
  683252
  716736
  615460
  620969
  776179
  793439
  806862
  784690
  747403
  783787
  742944
  763329
  758894
  763263
  775480
  783217
  783298
  810615
  549215
  716630
  709406
  688121
  785486
  787213
  726215
  734608
  763325
  768187
  774623
  793759
  500971
  799748
  767397
  768220
  763380
  763321
  725073
  719408
  779759
  792157
  792264
  768550
  754278
  761327
  731699
  716601
  595695
  793746
  814310
  529649
  700869
  590780
  779546
  792363
  793455
  760477
  743850
  687105
  716831
  716626
  716645
  633561
  809188
  727511
  767521
  792338
  716727
  717211
  805623
  770035
  652434
  658481
  695074
  671166
  632496
  776508
  787493
  799381
  776512
  793476
  729919
  767544
  793349
  767520
  727494
  744400
  763335
  609809
  722135
  793764
  531363
  618088
  785442
  787037
  778511
  797547
  810264
  731388
  768237
  716820
  722148
  639065
]
2.93 ms
(1.01%)
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
  500971
  507514
  529649
  531363
  549215
  590780
  595695
  609809
  615460
  618088
  620969
  632496
  633561
  636918
  639065
  652434
  658481
  660275
  671166
  683252
  687105
  688121
  695074
  700869
  704487
  709406
  710393
  716601
  716626
  716630
  716645
  716727
  716736
  716820
  716831
  717211
  719408
  722135
  722148
  725073
  726215
  727494
  727511
  728875
  729919
  730281
  731388
  731699
  734608
  742944
  743850
  744400
  745887
  747403
  753078
  754278
  758894
  760477
  761327
  763250
  763263
  763321
  763325
  763329
  763335
  763380
  763634
  767397
  767520
  767521
  767525
  767544
  768187
  768220
  768237
  768550
  770035
  774623
  775480
  776179
  776508
  776512
  778031
  778511
  779546
  779759
  783217
  783298
  783787
  784690
  785442
  785486
  787037
  787213
  787493
  792157
  792264
  792338
  792363
  793349
  793389
  793439
  793455
  793476
  793746
  793747
  793759
  793764
  793767
  794725
  797547
  799381
  799703
  799748
  805623
  806862
  809188
  810264
  810615
  814310
]
2.20 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "горло трах"
]
2.08 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "горл секс"
]
1.56 ms
(0.54%)
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.