GET https://search.jues.net/search/embeds/6?q=brother%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.81 ms
(87.36%)
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
  394760
  397520
  397901
  398678
  399522
  400829
  411580
  417368
  417665
  422716
  425513
  426468
  427064
  427314
  432526
  433466
  435537
  436447
  436693
  441215
  443300
  443543
  446742
  447574
  448578
  449405
  450442
  453484
  453802
  454959
  455574
  456952
  459225
  459293
  459654
  463121
  465116
  466865
  469452
  472122
  473229
  473567
  476329
  478821
  482262
  484500
  485264
  485268
  487502
  489370
  489409
  489630
  490566
  490623
  490752
  494008
  496537
  499021
  500010
  504747
  504751
  504764
  507648
  508309
  508743
  510007
  510665
  513459
  515889
  516438
  516492
  516670
  518081
  518335
  521470
  521979
  521984
  522044
  522311
  523374
  523476
  524106
  526518
  527079
  527687
  529161
  532027
  535763
  536913
  542087
  548842
  551798
  557669
  565094
  565861
  567366
  569962
  571392
  572898
  574745
  577899
  587171
  591940
  599435
  600395
  600977
  605758
  608821
  609432
  618389
  725408
  727027
  737098
  737124
  748662
  756736
  775372
  796135
  797119
  804833
]
15.86 ms
(7.88%)
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
  449405
  456952
  400829
  422716
  484500
  490566
  394760
  441215
  529161
  551798
  797119
  737098
  433466
  476329
  399522
  482262
  489370
  521984
  397520
  485268
  485264
  523374
  567366
  600977
  725408
  417368
  427064
  436447
  436693
  417665
  463121
  398678
  426468
  454959
  469452
  453484
  490623
  521979
  510665
  489630
  522311
  513459
  504764
  518081
  532027
  557669
  571392
  587171
  609432
  618389
  727027
  748662
  608821
  459225
  397901
  425513
  450442
  446742
  478821
  432526
  473567
  459654
  472122
  500010
  527687
  487502
  504747
  516670
  510007
  518335
  523476
  499021
  507648
  516492
  522044
  524106
  435537
  443300
  443543
  427314
  447574
  448578
  459293
  465116
  490752
  515889
  521470
  535763
  574745
  542087
  565094
  565861
  572898
  548842
  599435
  737124
  804833
  796135
  453802
  411580
  473229
  527079
  494008
  496537
  508309
  489409
  508743
  455574
  504751
  526518
  516438
  536913
  466865
  577899
  569962
  591940
  600395
  605758
  775372
  756736
]
2.97 ms
(1.47%)
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
  394760
  397520
  397901
  398678
  399522
  400829
  411580
  417368
  417665
  422716
  425513
  426468
  427064
  427314
  432526
  433466
  435537
  436447
  436693
  441215
  443300
  443543
  446742
  447574
  448578
  449405
  450442
  453484
  453802
  454959
  455574
  456952
  459225
  459293
  459654
  463121
  465116
  466865
  469452
  472122
  473229
  473567
  476329
  478821
  482262
  484500
  485264
  485268
  487502
  489370
  489409
  489630
  490566
  490623
  490752
  494008
  496537
  499021
  500010
  504747
  504751
  504764
  507648
  508309
  508743
  510007
  510665
  513459
  515889
  516438
  516492
  516670
  518081
  518335
  521470
  521979
  521984
  522044
  522311
  523374
  523476
  524106
  526518
  527079
  527687
  529161
  532027
  535763
  536913
  542087
  548842
  551798
  557669
  565094
  565861
  567366
  569962
  571392
  572898
  574745
  577899
  587171
  591940
  599435
  600395
  600977
  605758
  608821
  609432
  618389
  725408
  727027
  737098
  737124
  748662
  756736
  775372
  796135
  797119
  804833
]
1.86 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brother sex"
]
1.81 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "brother секс"
]
1.54 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "brother секс"
]

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.