GET https://search.jues.net/search/embeds/9?q=amateur%20friend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.21 ms
(86.93%)
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
  385662
  415036
  422106
  441892
  482884
  502788
  505480
  526423
  534133
  534183
  536392
  537215
  546089
  549472
  551608
  556685
  557030
  557051
  560305
  563721
  577084
  592379
  592708
  592987
  593967
  600518
  603621
  604958
  605684
  618821
  621718
  622179
  626528
  631311
  631851
  632251
  638430
  648672
  651333
  651370
  653863
  653880
  657825
  663777
  664616
  665969
  665978
  667057
  675193
  677511
  678607
  679549
  692735
  692845
  693273
  695700
  695773
  695805
  696577
  697199
  697633
  697685
  700831
  701188
  702302
  704673
  704685
  705111
  709468
  711938
  712952
  713641
  714254
  728686
  729170
  731358
  732592
  732781
  733963
  735207
  736023
  739724
  740016
  740095
  742101
  748073
  749816
  749940
  750553
  750618
  753534
  754343
  756680
  758035
  758901
  762954
  764378
  764699
  766702
  767318
  769304
  781319
  783664
  788199
  788592
  789563
  791968
  792754
  793650
  794354
  795748
  795752
  796621
  798862
  804854
  812812
  813565
  813901
  818942
  827854
]
12.52 ms
(6.67%)
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
  788592
  793650
  795748
  796621
  804854
  812812
  729170
  733963
  735207
  740016
  750618
  758901
  767318
  769304
  781319
  789563
  791968
  792754
  732781
  736023
  739724
  742101
  748073
  749940
  753534
  766702
  728686
  754343
  756680
  762954
  764378
  731358
  732592
  740095
  749816
  750553
  758035
  604958
  631311
  783664
  788199
  794354
  795752
  526423
  813565
  704673
  705111
  592379
  593967
  534183
  551608
  557051
  697199
  712952
  385662
  415036
  813901
  818942
  482884
  764699
  798862
  422106
  441892
  827854
  505480
  502788
  534133
  537215
  536392
  563721
  546089
  549472
  560305
  577084
  648672
  651333
  653863
  665969
  675193
  677511
  679549
  692735
  693273
  695700
  695773
  701188
  702302
  704685
  657825
  665978
  692845
  697633
  697685
  709468
  651370
  653880
  663777
  664616
  667057
  678607
  695805
  696577
  700831
  711938
  713641
  714254
  556685
  557030
  603621
  605684
  618821
  626528
  638430
  592708
  592987
  600518
  621718
  622179
  631851
  632251
]
4.14 ms
(2.20%)
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
  385662
  415036
  422106
  441892
  482884
  502788
  505480
  526423
  534133
  534183
  536392
  537215
  546089
  549472
  551608
  556685
  557030
  557051
  560305
  563721
  577084
  592379
  592708
  592987
  593967
  600518
  603621
  604958
  605684
  618821
  621718
  622179
  626528
  631311
  631851
  632251
  638430
  648672
  651333
  651370
  653863
  653880
  657825
  663777
  664616
  665969
  665978
  667057
  675193
  677511
  678607
  679549
  692735
  692845
  693273
  695700
  695773
  695805
  696577
  697199
  697633
  697685
  700831
  701188
  702302
  704673
  704685
  705111
  709468
  711938
  712952
  713641
  714254
  728686
  729170
  731358
  732592
  732781
  733963
  735207
  736023
  739724
  740016
  740095
  742101
  748073
  749816
  749940
  750553
  750618
  753534
  754343
  756680
  758035
  758901
  762954
  764378
  764699
  766702
  767318
  769304
  781319
  783664
  788199
  788592
  789563
  791968
  792754
  793650
  794354
  795748
  795752
  796621
  798862
  804854
  812812
  813565
  813901
  818942
  827854
]
2.27 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur friend"
]
2.05 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск friend"
]
1.66 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск friend"
]

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.