GET https://search.jues.net/search/embeds/9?q=morning%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
199.63 ms
(89.29%)
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
  397763
  400539
  417871
  420014
  421821
  422297
  423748
  424280
  428083
  429685
  434841
  437403
  438629
  440485
  440691
  440706
  442021
  442568
  444690
  445096
  445712
  449416
  449647
  451330
  451907
  452783
  455442
  455759
  456964
  458249
  461912
  464613
  465074
  466108
  470704
  471607
  472042
  472990
  474895
  475116
  478940
  479450
  479794
  481315
  481626
  484869
  486374
  487633
  488528
  490397
  492614
  495868
  498944
  502373
  505391
  505515
  506061
  507519
  508598
  509522
  509545
  509881
  517281
  517458
  519806
  520296
  521512
  522074
  522098
  523069
  523147
  525051
  526362
  527709
  527992
  534603
  536431
  537457
  552875
  564695
  566743
  568163
  590673
  592064
  599330
  599455
  599727
  602571
  604230
  606197
  609676
  610831
  611021
  615853
  620820
  627646
  631573
  718699
  723681
  731121
  735286
  741714
  741762
  747850
  750078
  759121
  761078
  764688
  766321
  770606
  772781
  776160
  782464
  789225
  792884
  803672
  804165
  807653
  813035
  818088
]
14.90 ms
(6.67%)
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
  599455
  602571
  611021
  620820
  631573
  590673
  604230
  606197
  609676
  615853
  627646
  792884
  776160
  803672
  813035
  735286
  766321
  772781
  782464
  761078
  723681
  750078
  759121
  731121
  741714
  610831
  789225
  807653
  420014
  429685
  434841
  438629
  440706
  466108
  481626
  437403
  455442
  458249
  461912
  428083
  451330
  471607
  397763
  422297
  440485
  449416
  449647
  470704
  442568
  479450
  481315
  509881
  523147
  492614
  505391
  506061
  507519
  490397
  502373
  522098
  527709
  552875
  804165
  747850
  770606
  534603
  498944
  564695
  566743
  592064
  472990
  599330
  417871
  517458
  505515
  478940
  568163
  599727
  741762
  536431
  488528
  456964
  421821
  519806
  718699
  764688
  424280
  400539
  445096
  440691
  442021
  444690
  423748
  818088
  451907
  465074
  474895
  479794
  445712
  452783
  455759
  464613
  475116
  472042
  484869
  487633
  525051
  495868
  521512
  523069
  527992
  508598
  509545
  509522
  517281
  520296
  522074
  526362
  537457
  486374
]
2.40 ms
(1.07%)
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
  397763
  400539
  417871
  420014
  421821
  422297
  423748
  424280
  428083
  429685
  434841
  437403
  438629
  440485
  440691
  440706
  442021
  442568
  444690
  445096
  445712
  449416
  449647
  451330
  451907
  452783
  455442
  455759
  456964
  458249
  461912
  464613
  465074
  466108
  470704
  471607
  472042
  472990
  474895
  475116
  478940
  479450
  479794
  481315
  481626
  484869
  486374
  487633
  488528
  490397
  492614
  495868
  498944
  502373
  505391
  505515
  506061
  507519
  508598
  509522
  509545
  509881
  517281
  517458
  519806
  520296
  521512
  522074
  522098
  523069
  523147
  525051
  526362
  527709
  527992
  534603
  536431
  537457
  552875
  564695
  566743
  568163
  590673
  592064
  599330
  599455
  599727
  602571
  604230
  606197
  609676
  610831
  611021
  615853
  620820
  627646
  631573
  718699
  723681
  731121
  735286
  741714
  741762
  747850
  750078
  759121
  761078
  764688
  766321
  770606
  772781
  776160
  782464
  789225
  792884
  803672
  804165
  807653
  813035
  818088
]
2.04 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "morning wife"
]
1.68 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "morning жен"
]
1.47 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "morning жен"
]
1.45 ms
(0.65%)
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.