GET https://search.jues.net/search/embeds/2?q=doggystyle%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
240.73 ms
(89.82%)
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
  28242
  213604
  237362
  382766
  382770
  393855
  394160
  395668
  403136
  407382
  414807
  420324
  422287
  425207
  429905
  449270
  457521
  466422
  469114
  470359
  471460
  476086
  478641
  479877
  484011
  504229
  514237
  515961
  524688
  526236
  526508
  528142
  531075
  533241
  536419
  536441
  539940
  540132
  543296
  545030
  545213
  551723
  552844
  553115
  555859
  555954
  557201
  563301
  567833
  573382
  574469
  576087
  580928
  581170
  583547
  584463
  584768
  585175
  585571
  586047
  588221
  588618
  589487
  591596
  592319
  594557
  597665
  602485
  607432
  609614
  619167
  636057
  639702
  642176
  646052
  659262
  672701
  675581
  676657
  678180
  679297
  687259
  687355
  688403
  695158
  697219
  700379
  709181
  710541
  716669
  717202
  724396
  726920
  727778
  728702
  737644
  740037
  742727
  743806
  747239
  747673
  748035
  750940
  756804
  759908
  759921
  761012
  761018
  765715
  769474
  791567
  794071
  796158
  803532
  808084
  808480
  810931
  811435
  811528
  825117
]
13.36 ms
(4.98%)
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
  607432
  395668
  407382
  659262
  687355
  700379
  716669
  636057
  808084
  726920
  737644
  724396
  728702
  740037
  765715
  697219
  717202
  584463
  555859
  592319
  414807
  449270
  479877
  528142
  466422
  457521
  514237
  574469
  646052
  675581
  676657
  553115
  588618
  796158
  803532
  759921
  748035
  747239
  710541
  403136
  382766
  515961
  540132
  545030
  555954
  672701
  597665
  585571
  642176
  588221
  808480
  811435
  794071
  750940
  743806
  811528
  28242
  237362
  476086
  429905
  382770
  393855
  394160
  478641
  469114
  580928
  584768
  576087
  581170
  543296
  552844
  557201
  687259
  688403
  695158
  545213
  551723
  585175
  602485
  810931
  761018
  759908
  761012
  769474
  531075
  484011
  526236
  470359
  504229
  524688
  213604
  422287
  420324
  425207
  825117
  471460
  526508
  533241
  536441
  536419
  539940
  563301
  567833
  583547
  678180
  679297
  573382
  586047
  589487
  591596
  594557
  619167
  639702
  609614
  791567
  747673
  727778
  742727
  756804
  709181
]
6.09 ms
(2.27%)
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
  28242
  213604
  237362
  382766
  382770
  393855
  394160
  395668
  403136
  407382
  414807
  420324
  422287
  425207
  429905
  449270
  457521
  466422
  469114
  470359
  471460
  476086
  478641
  479877
  484011
  504229
  514237
  515961
  524688
  526236
  526508
  528142
  531075
  533241
  536419
  536441
  539940
  540132
  543296
  545030
  545213
  551723
  552844
  553115
  555859
  555954
  557201
  563301
  567833
  573382
  574469
  576087
  580928
  581170
  583547
  584463
  584768
  585175
  585571
  586047
  588221
  588618
  589487
  591596
  592319
  594557
  597665
  602485
  607432
  609614
  619167
  636057
  639702
  642176
  646052
  659262
  672701
  675581
  676657
  678180
  679297
  687259
  687355
  688403
  695158
  697219
  700379
  709181
  710541
  716669
  717202
  724396
  726920
  727778
  728702
  737644
  740037
  742727
  743806
  747239
  747673
  748035
  750940
  756804
  759908
  759921
  761012
  761018
  765715
  769474
  791567
  794071
  796158
  803532
  808084
  808480
  810931
  811435
  811528
  825117
]
2.09 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle brunette"
]
1.94 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle черноволосая"
]
1.92 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle черноволосая"
]
1.91 ms
(0.71%)
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.