GET https://search.jues.net/search/embeds/10?q=mature%20anal%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.67 ms
(84.65%)
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
  388219
  400936
  410959
  414339
  418363
  419861
  420547
  421352
  422049
  423940
  425206
  429768
  433147
  437470
  451256
  451935
  452041
  456437
  469552
  473172
  473912
  474649
  476089
  479004
  500363
  510395
  515972
  517842
  519567
  520770
  522859
  522901
  529290
  530010
  530028
  530491
  530533
  530784
  530941
  531088
  531089
  531136
  531259
  532754
  532768
  532839
  533014
  536588
  540405
  540577
  541614
  541833
  541846
  541884
  542189
  542956
  545608
  550194
  561114
  567581
  571241
  576690
  582323
  583960
  584001
  587013
  590411
  592440
  592456
  597204
  599847
  599863
  599864
  599888
  599902
  599961
  599965
  600019
  600185
  600289
  600295
  600296
  600321
  600355
  601625
  604868
  617428
  624155
  629888
  631178
  632571
  632636
  632641
  633124
  636304
  637434
  639752
  642002
  642658
  643027
  646229
  646771
  646786
  646849
  646899
  647860
  649596
  666852
  676014
  678493
  679457
  681691
  683261
  683831
  698133
  703833
  775958
  804464
  814031
  825812
]
20.57 ms
(10.38%)
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
  561114
  567581
  571241
  584001
  592440
  599864
  601625
  592456
  624155
  629888
  599902
  600295
  604868
  775958
  423940
  456437
  420547
  452041
  510395
  522859
  522901
  517842
  519567
  647860
  599847
  520770
  541614
  541833
  515972
  533014
  500363
  542956
  698133
  679457
  388219
  400936
  410959
  422049
  421352
  429768
  814031
  473912
  479004
  473172
  532754
  532768
  530941
  531089
  536588
  540577
  530028
  540405
  474649
  541884
  576690
  582323
  541846
  545608
  550194
  583960
  678493
  646771
  666852
  676014
  683261
  646229
  646786
  683831
  600185
  642002
  642658
  587013
  590411
  600321
  639752
  600355
  632636
  636304
  643027
  633124
  637434
  617428
  631178
  703833
  804464
  433147
  437470
  451935
  532839
  646849
  649596
  646899
  597204
  600289
  632571
  632641
  451256
  529290
  542189
  476089
  469552
  531088
  531136
  530784
  531259
  681691
  600296
  599863
  599961
  599888
  599965
  600019
  418363
  414339
  419861
  425206
  825812
  530010
  530491
  530533
]
2.68 ms
(1.36%)
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
  388219
  400936
  410959
  414339
  418363
  419861
  420547
  421352
  422049
  423940
  425206
  429768
  433147
  437470
  451256
  451935
  452041
  456437
  469552
  473172
  473912
  474649
  476089
  479004
  500363
  510395
  515972
  517842
  519567
  520770
  522859
  522901
  529290
  530010
  530028
  530491
  530533
  530784
  530941
  531088
  531089
  531136
  531259
  532754
  532768
  532839
  533014
  536588
  540405
  540577
  541614
  541833
  541846
  541884
  542189
  542956
  545608
  550194
  561114
  567581
  571241
  576690
  582323
  583960
  584001
  587013
  590411
  592440
  592456
  597204
  599847
  599863
  599864
  599888
  599902
  599961
  599965
  600019
  600185
  600289
  600295
  600296
  600321
  600355
  601625
  604868
  617428
  624155
  629888
  631178
  632571
  632636
  632641
  633124
  636304
  637434
  639752
  642002
  642658
  643027
  646229
  646771
  646786
  646849
  646899
  647860
  649596
  666852
  676014
  678493
  679457
  681691
  683261
  683831
  698133
  703833
  775958
  804464
  814031
  825812
]
1.93 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature anal group"
]
1.91 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature анал group"
]
1.54 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature анал group"
]

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.