GET https://search.jues.net/search/embeds/3?q=mom%20deep

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.86 ms
(81.45%)
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
  413033
  419758
  435917
  458764
  483547
  484283
  485242
  488639
  493464
  507512
  509983
  510396
  510951
  511830
  517928
  520028
  523402
  523851
  525089
  530275
  530495
  530941
  531089
  531155
  531182
  531419
  531420
  532735
  532751
  532755
  532812
  532995
  533372
  533373
  533773
  535054
  536233
  537114
  537670
  537672
  537863
  543652
  550128
  550194
  558194
  565557
  569929
  574715
  582323
  583500
  584325
  599847
  599863
  599957
  599965
  599994
  600002
  600019
  600171
  600185
  600215
  600249
  600268
  600271
  600289
  600321
  600334
  600340
  600355
  601535
  601613
  609165
  617153
  622938
  629045
  632571
  632659
  632671
  634218
  634543
  634774
  635215
  636295
  636299
  636300
  636304
  636306
  636308
  636320
  637434
  638298
  639258
  639334
  639810
  640767
  640800
  642002
  642032
  642063
  644373
  646771
  646786
  646841
  646899
  646901
  646904
  647954
  648220
  648235
  648241
  648815
  648853
  651631
  669058
  683261
  704531
  716878
  716887
  788136
  805146
]
13.15 ms
(7.20%)
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
  584325
  647954
  646904
  648815
  599957
  600340
  644373
  600215
  640800
  599994
  600002
  600334
  640767
  805146
  413033
  525089
  484283
  488639
  485242
  520028
  523851
  458764
  537672
  535054
  517928
  530941
  531089
  531419
  532735
  536233
  537670
  550128
  558194
  582323
  565557
  550194
  648220
  669058
  646771
  683261
  716878
  646786
  600185
  642002
  600321
  600268
  600355
  636304
  636299
  637434
  788136
  601535
  632659
  716887
  435917
  419758
  493464
  509983
  510951
  483547
  532995
  530275
  533372
  533373
  523402
  533773
  537114
  583500
  648235
  651631
  646841
  646899
  648853
  600171
  642063
  599863
  609165
  617153
  629045
  632671
  639810
  599847
  599965
  600249
  600289
  634543
  636295
  600019
  600271
  601613
  632571
  704531
  507512
  511830
  532751
  510396
  531182
  537863
  530495
  543652
  569929
  574715
  638298
  642032
  634774
  636320
  635215
  636308
  531155
  531420
  532812
  646901
  648241
  622938
  636306
  639258
  639334
  636300
  634218
  532755
]
11.09 ms
(6.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
3.41 ms
(1.87%)
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
  413033
  419758
  435917
  458764
  483547
  484283
  485242
  488639
  493464
  507512
  509983
  510396
  510951
  511830
  517928
  520028
  523402
  523851
  525089
  530275
  530495
  530941
  531089
  531155
  531182
  531419
  531420
  532735
  532751
  532755
  532812
  532995
  533372
  533373
  533773
  535054
  536233
  537114
  537670
  537672
  537863
  543652
  550128
  550194
  558194
  565557
  569929
  574715
  582323
  583500
  584325
  599847
  599863
  599957
  599965
  599994
  600002
  600019
  600171
  600185
  600215
  600249
  600268
  600271
  600289
  600321
  600334
  600340
  600355
  601535
  601613
  609165
  617153
  622938
  629045
  632571
  632659
  632671
  634218
  634543
  634774
  635215
  636295
  636299
  636300
  636304
  636306
  636308
  636320
  637434
  638298
  639258
  639334
  639810
  640767
  640800
  642002
  642032
  642063
  644373
  646771
  646786
  646841
  646899
  646901
  646904
  647954
  648220
  648235
  648241
  648815
  648853
  651631
  669058
  683261
  704531
  716878
  716887
  788136
  805146
]
2.64 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom deep"
]
1.89 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom deep"
]
1.72 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom deep"
]

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.