GET https://search.jues.net/search/embeds/6?q=face%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.81 ms
(85.41%)
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
  383119
  395326
  421653
  426467
  427163
  430585
  434007
  486852
  534461
  539486
  542721
  555030
  555411
  572501
  574382
  592523
  593250
  612488
  619088
  619941
  629637
  631765
  632065
  636261
  641064
  649743
  650095
  650937
  668959
  671231
  678608
  687359
  695843
  696096
  699899
  703814
  705141
  710817
  716929
  719780
  721252
  724697
  726725
  739915
  740018
  742836
  752176
  754122
  755166
  757285
  762246
  763036
  763064
  763122
  765770
  766518
  768023
  772836
  772922
  773395
  774662
  774880
  775496
  775600
  776464
  779036
  779949
  780325
  782584
  782767
  782771
  783201
  783225
  783381
  785984
  787495
  787887
  788840
  789165
  789835
  790824
  791017
  791049
  791785
  792113
  792197
  792398
  793878
  794193
  794492
  794493
  795265
  798623
  799747
  799871
  800994
  801578
  802859
  803443
  804517
  804910
  806854
  807008
  808529
  810051
  811443
  816159
  816604
  816800
  816810
  817938
  817966
  820646
  821132
  823498
  825074
  825175
  825510
  827578
]
12.97 ms
(8.04%)
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
  806854
  421653
  816810
  820646
  817966
  817938
  816604
  534461
  539486
  555030
  542721
  705141
  721252
  650937
  695843
  696096
  649743
  668959
  678608
  719780
  619088
  636261
  612488
  641064
  592523
  619941
  775496
  798623
  799871
  775600
  789835
  792398
  801578
  807008
  739915
  752176
  754122
  762246
  783381
  788840
  789165
  791785
  794193
  803443
  724697
  763064
  763122
  740018
  765770
  768023
  772922
  774880
  776464
  779036
  779949
  790824
  791049
  792197
  793878
  800994
  808529
  395326
  427163
  426467
  434007
  821132
  486852
  699899
  572501
  774662
  782584
  787887
  383119
  430585
  825175
  816800
  823498
  825074
  827578
  816159
  825510
  574382
  555411
  650095
  671231
  710817
  703814
  716929
  687359
  631765
  593250
  629637
  632065
  780325
  782767
  782771
  785984
  787495
  794492
  794493
  799747
  802859
  804517
  810051
  811443
  783201
  783225
  791017
  792113
  795265
  804910
  726725
  742836
  755166
  757285
  763036
  766518
  772836
  773395
  773517
]
2.81 ms
(1.74%)
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
  383119
  395326
  421653
  426467
  427163
  430585
  434007
  486852
  534461
  539486
  542721
  555030
  555411
  572501
  574382
  592523
  593250
  612488
  619088
  619941
  629637
  631765
  632065
  636261
  641064
  649743
  650095
  650937
  668959
  671231
  678608
  687359
  695843
  696096
  699899
  703814
  705141
  710817
  716929
  719780
  721252
  724697
  726725
  739915
  740018
  742836
  752176
  754122
  755166
  757285
  762246
  763036
  763064
  763122
  765770
  766518
  768023
  772836
  772922
  773395
  774662
  774880
  775496
  775600
  776464
  779036
  779949
  780325
  782584
  782767
  782771
  783201
  783225
  783381
  785984
  787495
  787887
  788840
  789165
  789835
  790824
  791017
  791049
  791785
  792113
  792197
  792398
  793878
  794193
  794492
  794493
  795265
  798623
  799747
  799871
  800994
  801578
  802859
  803443
  804517
  804910
  806854
  807008
  808529
  810051
  811443
  816159
  816604
  816800
  816810
  817938
  817966
  820646
  821132
  823498
  825074
  825175
  825510
  827578
]
2.61 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "face girl"
]
1.80 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "face девушк"
]
1.70 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "face девушк"
]

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.