GET https://search.jues.net/search/embeds/6?q=moans

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.91 ms
(86.23%)
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
  285233
  290304
  417317
  419319
  419590
  425319
  427237
  429234
  429603
  432552
  435267
  439301
  445192
  445987
  453323
  456103
  456452
  461617
  467739
  471780
  471944
  473106
  476601
  478140
  479452
  480070
  480183
  482070
  483636
  485234
  487635
  488128
  488153
  489265
  489829
  492005
  493059
  493193
  495617
  499177
  499194
  503389
  504717
  505878
  506415
  507327
  507685
  508962
  509439
  510183
  511985
  516487
  516493
  516501
  516532
  517363
  518548
  518555
  518627
  520861
  520918
  522241
  522645
  524091
  525261
  525399
  525474
  527157
  527251
  527836
  528203
  528212
  528657
  539369
  545722
  548381
  548441
  548984
  556704
  559945
  560097
  560758
  560791
  564744
  568115
  572882
  577529
  580620
  582828
  592958
  603742
  608227
  609078
  612437
  613576
  614768
  621186
  626684
  628515
  629580
  644154
  659217
  668807
  673845
  680819
  696484
  706567
  714468
  726986
  732681
  741733
  745309
  761875
  762064
  762191
  782452
  789310
  800156
  807687
  814832
]
17.02 ms
(8.64%)
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
  696484
  706567
  564744
  612437
  609078
  603742
  644154
  608227
  626684
  789310
  782452
  732681
  800156
  745309
  761875
  741733
  762191
  726986
  629580
  429603
  478140
  480070
  456103
  461617
  425319
  479452
  417317
  445192
  445987
  516487
  516501
  495617
  518555
  524091
  527836
  489265
  516532
  493059
  499177
  504717
  505878
  427237
  453323
  487635
  489829
  492005
  511985
  517363
  507327
  527251
  528657
  520918
  527157
  508962
  510183
  471944
  545722
  548381
  568115
  577529
  572882
  560758
  668807
  673845
  548441
  556704
  559945
  560791
  592958
  628515
  614768
  621186
  467739
  290304
  432552
  476601
  480183
  518548
  507685
  522645
  499194
  516493
  525399
  419319
  429234
  483636
  525474
  548984
  659217
  807687
  762064
  714468
  471780
  482070
  503389
  522241
  528212
  528203
  488128
  488153
  493193
  525261
  539369
  285233
  419590
  814832
  485234
  473106
  506415
  560097
  680819
  580620
  613576
  435267
  439301
  456452
  518627
  520861
  509439
  582828
]
2.88 ms
(1.46%)
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
  285233
  290304
  417317
  419319
  419590
  425319
  427237
  429234
  429603
  432552
  435267
  439301
  445192
  445987
  453323
  456103
  456452
  461617
  467739
  471780
  471944
  473106
  476601
  478140
  479452
  480070
  480183
  482070
  483636
  485234
  487635
  488128
  488153
  489265
  489829
  492005
  493059
  493193
  495617
  499177
  499194
  503389
  504717
  505878
  506415
  507327
  507685
  508962
  509439
  510183
  511985
  516487
  516493
  516501
  516532
  517363
  518548
  518555
  518627
  520861
  520918
  522241
  522645
  524091
  525261
  525399
  525474
  527157
  527251
  527836
  528203
  528212
  528657
  539369
  545722
  548381
  548441
  548984
  556704
  559945
  560097
  560758
  560791
  564744
  568115
  572882
  577529
  580620
  582828
  592958
  603742
  608227
  609078
  612437
  613576
  614768
  621186
  626684
  628515
  629580
  644154
  659217
  668807
  673845
  680819
  696484
  706567
  714468
  726986
  732681
  741733
  745309
  761875
  762064
  762191
  782452
  789310
  800156
  807687
  814832
]
2.05 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "moans"
]
1.86 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "moans"
]
1.85 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "moans"
]
1.46 ms
(0.74%)
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.