GET https://search.jues.net/search/embeds/10?q=hairy%20ffm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.76 ms
(87.73%)
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
  395818
  401318
  404876
  406592
  412583
  415109
  417801
  418934
  419880
  425050
  425523
  426551
  426565
  428372
  429143
  429409
  429572
  430556
  431352
  433074
  434638
  435728
  437868
  442673
  442829
  444003
  445436
  445471
  447706
  451951
  452061
  454210
  458719
  460673
  462535
  466885
  470247
  470248
  470441
  471380
  471522
  471626
  472505
  473204
  477890
  480340
  481163
  484684
  484727
  486198
  486944
  490265
  491790
  492128
  492534
  492602
  494694
  499816
  502043
  508662
  509345
  510254
  512891
  513025
  517008
  519727
  519933
  522556
  523537
  527008
  527669
  529213
  530513
  531413
  531425
  531431
  531511
  531513
  534377
  541614
  541640
  541643
  541698
  541874
  541886
  541888
  550571
  551763
  560219
  562885
  563093
  573309
  576623
  578326
  583533
  584488
  586497
  593849
  600979
  601669
  603703
  608395
  610686
  615012
  617137
  623644
  623818
  625183
  625342
  639760
  643364
  647642
  649953
  650806
  650851
  682153
  688007
  688586
  724305
  727812
]
16.46 ms
(8.08%)
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
  523537
  541698
  573309
  688007
  615012
  404876
  431352
  419880
  430556
  508662
  519727
  415109
  480340
  492534
  471626
  491790
  531425
  560219
  682153
  617137
  724305
  512891
  486198
  429143
  454210
  462535
  477890
  563093
  688586
  583533
  586497
  593849
  625342
  601669
  727812
  425523
  452061
  406592
  484684
  447706
  531431
  531513
  576623
  442829
  608395
  490265
  527669
  502043
  417801
  412583
  433074
  625183
  531511
  517008
  458719
  460673
  445471
  471522
  451951
  429572
  541886
  428372
  395818
  426565
  434638
  472505
  541874
  647642
  466885
  470248
  473204
  499816
  418934
  442673
  527008
  470441
  562885
  600979
  603703
  470247
  425050
  471380
  513025
  444003
  494694
  509345
  531413
  584488
  623644
  484727
  486944
  435728
  481163
  529213
  550571
  610686
  639760
  530513
  534377
  492128
  623818
  510254
  541643
  522556
  519933
  541888
  426551
  578326
  541614
  541640
  551763
  643364
  401318
  492602
  429409
  437868
  445436
  649953
  650806
  650851
]
2.32 ms
(1.14%)
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
  395818
  401318
  404876
  406592
  412583
  415109
  417801
  418934
  419880
  425050
  425523
  426551
  426565
  428372
  429143
  429409
  429572
  430556
  431352
  433074
  434638
  435728
  437868
  442673
  442829
  444003
  445436
  445471
  447706
  451951
  452061
  454210
  458719
  460673
  462535
  466885
  470247
  470248
  470441
  471380
  471522
  471626
  472505
  473204
  477890
  480340
  481163
  484684
  484727
  486198
  486944
  490265
  491790
  492128
  492534
  492602
  494694
  499816
  502043
  508662
  509345
  510254
  512891
  513025
  517008
  519727
  519933
  522556
  523537
  527008
  527669
  529213
  530513
  531413
  531425
  531431
  531511
  531513
  534377
  541614
  541640
  541643
  541698
  541874
  541886
  541888
  550571
  551763
  560219
  562885
  563093
  573309
  576623
  578326
  583533
  584488
  586497
  593849
  600979
  601669
  603703
  608395
  610686
  615012
  617137
  623644
  623818
  625183
  625342
  639760
  643364
  647642
  649953
  650806
  650851
  682153
  688007
  688586
  724305
  727812
]
1.65 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая жмж секс втро"
]
1.58 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy ffm"
]
1.53 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.72%)
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.