GET https://search.jues.net/search/embeds/10?q=ass%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.15 ms
(55.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп красивая"
]
147.63 ms
(38.44%)
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
  8497
  51420
  58408
  159380
  203946
  384445
  394391
  398774
  401559
  402729
  415387
  416320
  418530
  421235
  424265
  424950
  425054
  425676
  429929
  431463
  434014
  435399
  445024
  449031
  452193
  463379
  464821
  464939
  472192
  475831
  476062
  500781
  510629
  510655
  510847
  514051
  516301
  518208
  521017
  526226
  527369
  537045
  539262
  539446
  557486
  582484
  584320
  585227
  587191
  589402
  589435
  592490
  593237
  604285
  605164
  614878
  627202
  627359
  628067
  633475
  636161
  636943
  638507
  642097
  647032
  648527
  653239
  653883
  656582
  661674
  669256
  670461
  676517
  695759
  698575
  702330
  708603
  713430
  716099
  723750
  724096
  724121
  724433
  725183
  735026
  735186
  739042
  742657
  750670
  753610
  754529
  754682
  754786
  759696
  772352
  774632
  774799
  776477
  777761
  779120
  780735
  784137
  784581
  787880
  788762
  789489
  789592
  789926
  791525
  791557
  791886
  793885
  797045
  797235
  803810
  804695
  805186
  811075
  811543
  813500
]
15.75 ms
(4.10%)
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
  647032
  661674
  592490
  585227
  789592
  791557
  804695
  784581
  725183
  791525
  803810
  724433
  759696
  723750
  797045
  754786
  754682
  797235
  415387
  463379
  431463
  518208
  527369
  539262
  779120
  811075
  777761
  421235
  537045
  648527
  698575
  713430
  589402
  739042
  789926
  787880
  384445
  394391
  398774
  510655
  557486
  628067
  774799
  418530
  472192
  510847
  500781
  589435
  780735
  724096
  754529
  203946
  402729
  813500
  753610
  774632
  789489
  159380
  425676
  452193
  656582
  695759
  604285
  638507
  627359
  636943
  805186
  750670
  784137
  735026
  742657
  724121
  772352
  636161
  708603
  776477
  791886
  793885
  58408
  435399
  539446
  627202
  51420
  653883
  669256
  593237
  811543
  735186
  424950
  8497
  434014
  476062
  584320
  587191
  605164
  449031
  475831
  416320
  464939
  401559
  424265
  429929
  425054
  464821
  510629
  514051
  526226
  516301
  521017
  788762
  633475
  445024
  653239
  670461
  676517
  702330
  716099
  582484
  614878
  642097
]
2.74 ms
(0.71%)
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
  8497
  51420
  58408
  159380
  203946
  384445
  394391
  398774
  401559
  402729
  415387
  416320
  418530
  421235
  424265
  424950
  425054
  425676
  429929
  431463
  434014
  435399
  445024
  449031
  452193
  463379
  464821
  464939
  472192
  475831
  476062
  500781
  510629
  510655
  510847
  514051
  516301
  518208
  521017
  526226
  527369
  537045
  539262
  539446
  557486
  582484
  584320
  585227
  587191
  589402
  589435
  592490
  593237
  604285
  605164
  614878
  627202
  627359
  628067
  633475
  636161
  636943
  638507
  642097
  647032
  648527
  653239
  653883
  656582
  661674
  669256
  670461
  676517
  695759
  698575
  702330
  708603
  713430
  716099
  723750
  724096
  724121
  724433
  725183
  735026
  735186
  739042
  742657
  750670
  753610
  754529
  754682
  754786
  759696
  772352
  774632
  774799
  776477
  777761
  779120
  780735
  784137
  784581
  787880
  788762
  789489
  789592
  789926
  791525
  791557
  791886
  793885
  797045
  797235
  803810
  804695
  805186
  811075
  811543
  813500
]
1.89 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп красивая"
]
1.46 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass beautiful"
]

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.