GET https://search.jues.net/search/embeds/8?q=mouth%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.94 ms
(56.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mouth пов"
]
141.95 ms
(37.78%)
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
  418357
  438495
  446817
  447581
  450166
  451642
  452664
  455291
  457008
  460464
  461728
  461797
  462616
  466820
  471311
  473763
  475957
  479948
  481356
  481601
  483816
  488974
  489180
  496239
  496243
  500994
  504460
  506068
  506144
  514245
  517130
  522697
  527819
  528287
  530213
  530908
  533669
  542182
  542412
  546572
  546742
  546912
  548815
  551639
  552368
  553262
  554501
  557922
  561281
  562141
  563104
  563674
  564008
  567635
  571106
  571362
  571375
  573291
  574659
  578247
  584450
  585257
  585758
  588060
  589011
  591207
  591229
  592703
  599000
  599360
  602665
  609756
  616995
  618137
  623948
  629315
  634229
  635041
  650134
  666457
  667909
  673217
  678901
  680572
  682259
  682645
  683490
  693564
  707616
  718958
  726067
  729402
  758448
  760476
  763046
  764247
  764627
  764654
  771068
  773324
  773664
  777914
  779247
  779566
  780932
  781291
  790079
  790844
  791270
  791983
  793699
  794090
  796008
  797343
  799498
  800880
  808908
  817258
  821312
  826330
]
14.91 ms
(3.97%)
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
  438495
  418357
  826330
  817258
  821312
  446817
  450166
  451642
  452664
  455291
  457008
  460464
  479948
  481356
  483816
  461728
  461797
  462616
  466820
  473763
  447581
  471311
  481601
  489180
  506068
  533669
  500994
  527819
  530213
  530908
  496239
  496243
  504460
  506144
  514245
  517130
  522697
  528287
  475957
  488974
  542412
  571362
  574659
  551639
  552368
  554501
  563674
  567635
  571106
  584450
  542182
  546742
  546912
  548815
  557922
  561281
  563104
  564008
  571375
  578247
  667909
  682259
  682645
  693564
  650134
  678901
  680572
  718958
  666457
  673217
  683490
  707616
  546572
  553262
  562141
  573291
  585257
  591207
  609756
  618137
  629315
  585758
  599000
  599360
  602665
  616995
  623948
  634229
  635041
  589011
  588060
  591229
  592703
  777914
  779566
  781291
  790844
  794090
  796008
  800880
  779247
  780932
  791270
  791983
  793699
  808908
  729402
  764247
  773664
  790079
  797343
  799498
  760476
  764627
  773324
  726067
  763046
  771068
  758448
  764654
]
2.60 ms
(0.69%)
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
  418357
  438495
  446817
  447581
  450166
  451642
  452664
  455291
  457008
  460464
  461728
  461797
  462616
  466820
  471311
  473763
  475957
  479948
  481356
  481601
  483816
  488974
  489180
  496239
  496243
  500994
  504460
  506068
  506144
  514245
  517130
  522697
  527819
  528287
  530213
  530908
  533669
  542182
  542412
  546572
  546742
  546912
  548815
  551639
  552368
  553262
  554501
  557922
  561281
  562141
  563104
  563674
  564008
  567635
  571106
  571362
  571375
  573291
  574659
  578247
  584450
  585257
  585758
  588060
  589011
  591207
  591229
  592703
  599000
  599360
  602665
  609756
  616995
  618137
  623948
  629315
  634229
  635041
  650134
  666457
  667909
  673217
  678901
  680572
  682259
  682645
  683490
  693564
  707616
  718958
  726067
  729402
  758448
  760476
  763046
  764247
  764627
  764654
  771068
  773324
  773664
  777914
  779247
  779566
  780932
  781291
  790079
  790844
  791270
  791983
  793699
  794090
  796008
  797343
  799498
  800880
  808908
  817258
  821312
  826330
]
2.01 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth pov"
]
1.72 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth пов"
]
1.64 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.