GET https://search.jues.net/search/embeds/3?q=homemade%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.47 ms
(84.35%)
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
  4225
  220876
  395449
  397077
  400969
  402369
  411508
  417100
  435657
  442464
  444163
  444644
  446916
  447687
  450765
  453778
  459529
  464047
  464475
  464485
  467682
  470399
  477420
  478749
  478764
  484007
  496805
  503713
  514769
  514775
  516453
  517375
  518024
  521361
  522509
  525140
  532832
  543623
  543970
  551803
  553256
  557111
  557529
  559443
  561209
  565879
  566701
  569655
  572210
  574251
  584689
  585761
  591901
  592799
  602671
  626366
  628812
  655505
  670749
  673513
  674266
  674590
  696526
  698199
  700635
  703503
  709496
  709894
  712617
  714327
  716002
  722071
  727153
  727716
  729959
  730941
  734932
  743670
  744049
  748120
  752135
  753693
  758890
  759361
  760164
  760397
  761501
  766365
  767993
  770742
  771139
  772859
  775407
  776241
  777897
  780469
  787882
  793554
  793626
  801055
  801945
  804946
  808251
  810632
  813083
  817989
  818392
  818748
  820214
  823554
  823600
  823724
  824125
  824877
  825176
  825208
  825278
  827254
  827264
  827634
]
15.28 ms
(9.18%)
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
  517375
  543623
  551803
  626366
  823724
  823554
  818392
  801055
  793626
  808251
  766365
  787882
  817989
  825176
  825278
  557529
  777897
  780469
  727153
  748120
  759361
  734932
  771139
  767993
  770742
  417100
  532832
  522509
  496805
  572210
  561209
  574251
  709894
  655505
  670749
  674266
  712617
  674590
  696526
  700635
  714327
  557111
  566701
  585761
  591901
  628812
  592799
  776241
  775407
  743670
  772859
  698199
  703503
  709496
  569655
  602671
  464485
  516453
  730941
  744049
  722071
  442464
  444644
  453778
  450765
  478764
  467682
  478749
  400969
  514769
  753693
  752135
  761501
  827264
  559443
  464047
  395449
  411508
  444163
  459529
  464475
  470399
  446916
  518024
  584689
  543970
  553256
  565879
  435657
  447687
  477420
  503713
  484007
  514775
  521361
  525140
  673513
  758890
  760397
  220876
  820214
  823600
  825208
  827254
  824125
  824877
  818748
  827634
  716002
  793554
  810632
  801945
  804946
  729959
  813083
  760164
  727716
  4225
  397077
  402369
]
3.51 ms
(2.11%)
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
  4225
  220876
  395449
  397077
  400969
  402369
  411508
  417100
  435657
  442464
  444163
  444644
  446916
  447687
  450765
  453778
  459529
  464047
  464475
  464485
  467682
  470399
  477420
  478749
  478764
  484007
  496805
  503713
  514769
  514775
  516453
  517375
  518024
  521361
  522509
  525140
  532832
  543623
  543970
  551803
  553256
  557111
  557529
  559443
  561209
  565879
  566701
  569655
  572210
  574251
  584689
  585761
  591901
  592799
  602671
  626366
  628812
  655505
  670749
  673513
  674266
  674590
  696526
  698199
  700635
  703503
  709496
  709894
  712617
  714327
  716002
  722071
  727153
  727716
  729959
  730941
  734932
  743670
  744049
  748120
  752135
  753693
  758890
  759361
  760164
  760397
  761501
  766365
  767993
  770742
  771139
  772859
  775407
  776241
  777897
  780469
  787882
  793554
  793626
  801055
  801945
  804946
  808251
  810632
  813083
  817989
  818392
  818748
  820214
  823554
  823600
  823724
  824125
  824877
  825176
  825208
  825278
  827254
  827264
  827634
]
2.26 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade sleeping"
]
1.97 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск спящ"
]
1.54 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.