GET https://search.jues.net/search/embeds/3?q=mature%20brunette%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.88 ms
(81.83%)
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
  88591
  154972
  187450
  265692
  382274
  391926
  391959
  392015
  392019
  394630
  429867
  435512
  435535
  435551
  449024
  452940
  454019
  454517
  455373
  465143
  466384
  468142
  469158
  471701
  473447
  475769
  476163
  476186
  479364
  480662
  480680
  483523
  490598
  495040
  500789
  513633
  513635
  513639
  513640
  513672
  516491
  517332
  517397
  517539
  517797
  517799
  517870
  518214
  519361
  520904
  520908
  529988
  530740
  533694
  533756
  536323
  538498
  544108
  547492
  550456
  554226
  554997
  555008
  555009
  555023
  555040
  555045
  557490
  557969
  558315
  559355
  561034
  561036
  570936
  573270
  576545
  580246
  585498
  586570
  586914
  591003
  591013
  592965
  593042
  593184
  599236
  601553
  602782
  605129
  605709
  606134
  628698
  642243
  652881
  660415
  664559
  669046
  669057
  670367
  670372
  671043
  709746
  752767
  757860
  766398
  780653
  781779
  781920
  796816
  803396
  804427
  804435
  804452
  807723
  809351
  812229
  816184
  819238
  824684
  827394
]
17.00 ms
(11.60%)
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
  601553
  819238
  454019
  454517
  544108
  555009
  669046
  660415
  602782
  605129
  599236
  780653
  796816
  812229
  804435
  804452
  391959
  520908
  520904
  452940
  529988
  555008
  555023
  517797
  469158
  518214
  382274
  816184
  824684
  827394
  533756
  517539
  533694
  536323
  530740
  652881
  592965
  606134
  642243
  585498
  593042
  593184
  781920
  803396
  807723
  809351
  757860
  766398
  709746
  187450
  265692
  519361
  468142
  554226
  555040
  429867
  154972
  392019
  88591
  435512
  435535
  435551
  449024
  471701
  473447
  479364
  538498
  500789
  466384
  557969
  573270
  558315
  580246
  550456
  557490
  664559
  555045
  586570
  605709
  628698
  752767
  391926
  392015
  480680
  455373
  394630
  475769
  480662
  465143
  513633
  495040
  513639
  513640
  483523
  517397
  517799
  476186
  490598
  476163
  547492
  559355
  561034
  561036
  670367
  671043
  670372
  669057
  554997
  570936
  576545
  586914
  591003
  591013
  804427
  781779
  517332
  517870
  513635
  513672
  516491
]
2.65 ms
(1.81%)
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
  88591
  154972
  187450
  265692
  382274
  391926
  391959
  392015
  392019
  394630
  429867
  435512
  435535
  435551
  449024
  452940
  454019
  454517
  455373
  465143
  466384
  468142
  469158
  471701
  473447
  475769
  476163
  476186
  479364
  480662
  480680
  483523
  490598
  495040
  500789
  513633
  513635
  513639
  513640
  513672
  516491
  517332
  517397
  517539
  517797
  517799
  517870
  518214
  519361
  520904
  520908
  529988
  530740
  533694
  533756
  536323
  538498
  544108
  547492
  550456
  554226
  554997
  555008
  555009
  555023
  555040
  555045
  557490
  557969
  558315
  559355
  561034
  561036
  570936
  573270
  576545
  580246
  585498
  586570
  586914
  591003
  591013
  592965
  593042
  593184
  599236
  601553
  602782
  605129
  605709
  606134
  628698
  642243
  652881
  660415
  664559
  669046
  669057
  670367
  670372
  671043
  709746
  752767
  757860
  766398
  780653
  781779
  781920
  796816
  803396
  804427
  804435
  804452
  807723
  809351
  812229
  816184
  819238
  824684
  827394
]
1.91 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature brunette solo"
]
1.71 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature черноволосая соло"
]
1.67 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature черноволосая соло"
]

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.