GET https://search.jues.net/search/embeds/8?q=mom--and--son

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.69 ms
(87.01%)
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
  55266
  384581
  394251
  394376
  395584
  396952
  397999
  399518
  401978
  402599
  402972
  403600
  407187
  407684
  407710
  413128
  414946
  428454
  428457
  428472
  428822
  428858
  428892
  429584
  429824
  433681
  435931
  437322
  437583
  439569
  440292
  440645
  442418
  443182
  444707
  446276
  448166
  451271
  454040
  454048
  458731
  465316
  466429
  476336
  481794
  481805
  486251
  492096
  492304
  493168
  507088
  511790
  513145
  523323
  523779
  526449
  527249
  530409
  531995
  532028
  532060
  543773
  549661
  550642
  553433
  557958
  568367
  575289
  581723
  591049
  591155
  591258
  593598
  594813
  596427
  606619
  624288
  633412
  639170
  649440
  659197
  661991
  682181
  701247
  702312
  710587
  714752
  716324
  717689
  717797
  718549
  718560
  718920
  719443
  720602
  725363
  725578
  726588
  726606
  726831
  728291
  736393
  741893
  748892
  749773
  756714
  756863
  758443
  768851
  769547
  779534
  781824
  793930
  810472
  813752
  813918
  813920
  815353
  823803
  824810
]
16.89 ms
(7.91%)
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
  481794
  543773
  591258
  591155
  769547
  756714
  428892
  428472
  414946
  523323
  492096
  395584
  402599
  444707
  407187
  440292
  813752
  815353
  454040
  481805
  465316
  486251
  530409
  513145
  476336
  553433
  575289
  581723
  649440
  710587
  718920
  702312
  718560
  661991
  594813
  591049
  593598
  633412
  639170
  726588
  748892
  756863
  758443
  726606
  725578
  768851
  793930
  402972
  428454
  458731
  507088
  511790
  394376
  403600
  523779
  557958
  682181
  624288
  466429
  437583
  527249
  384581
  55266
  396952
  428457
  429584
  407684
  429824
  813920
  824810
  813918
  823803
  446276
  454048
  451271
  448166
  492304
  493168
  526449
  531995
  532060
  549661
  568367
  550642
  659197
  719443
  701247
  714752
  717689
  717797
  718549
  596427
  606619
  781824
  810472
  725363
  726831
  728291
  741893
  736393
  749773
  716324
  720602
  779534
  428858
  440645
  428822
  437322
  413128
  532028
  394251
  397999
  399518
  401978
  439569
  407710
  433681
  442418
  435931
  443182
]
4.13 ms
(1.93%)
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
  55266
  384581
  394251
  394376
  395584
  396952
  397999
  399518
  401978
  402599
  402972
  403600
  407187
  407684
  407710
  413128
  414946
  428454
  428457
  428472
  428822
  428858
  428892
  429584
  429824
  433681
  435931
  437322
  437583
  439569
  440292
  440645
  442418
  443182
  444707
  446276
  448166
  451271
  454040
  454048
  458731
  465316
  466429
  476336
  481794
  481805
  486251
  492096
  492304
  493168
  507088
  511790
  513145
  523323
  523779
  526449
  527249
  530409
  531995
  532028
  532060
  543773
  549661
  550642
  553433
  557958
  568367
  575289
  581723
  591049
  591155
  591258
  593598
  594813
  596427
  606619
  624288
  633412
  639170
  649440
  659197
  661991
  682181
  701247
  702312
  710587
  714752
  716324
  717689
  717797
  718549
  718560
  718920
  719443
  720602
  725363
  725578
  726588
  726606
  726831
  728291
  736393
  741893
  748892
  749773
  756714
  756863
  758443
  768851
  769547
  779534
  781824
  793930
  810472
  813752
  813918
  813920
  815353
  823803
  824810
]
2.07 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom--and--son"
]
1.79 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom son"
]
1.45 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom son"
]

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.