GET https://search.jues.net/search/embeds/7?q=russian%20mature%20blonde

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.27 ms
(82.45%)
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
  388562
  389462
  390218
  397421
  398932
  400844
  400859
  400865
  411726
  419517
  419539
  421571
  421592
  421660
  424194
  424413
  424414
  424460
  429561
  433371
  440339
  443119
  443700
  443776
  443779
  448558
  451520
  451526
  451877
  452297
  454270
  455130
  455966
  457437
  457449
  458701
  458891
  460754
  460919
  462136
  462140
  463790
  464537
  465824
  466198
  466239
  466890
  467402
  467525
  468307
  468831
  470298
  470416
  470713
  474401
  474495
  474634
  474808
  475088
  475266
  476487
  476936
  477721
  477729
  477940
  478006
  479979
  481396
  481400
  481830
  483380
  483600
  484568
  484592
  484596
  484618
  484655
  484659
  484672
  484693
  487944
  488500
  489075
  490396
  490916
  491144
  493178
  494315
  500184
  503869
  506050
  510750
  510877
  510880
  511554
  515596
  519729
  524967
  526524
  526525
  526885
  529998
  534682
  534704
  538001
  547924
  550219
  555112
  555114
  555129
  555130
  555133
  555139
  563078
  563190
  564113
  567338
  573728
  590394
  600394
]
16.13 ms
(10.53%)
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
  563078
  550219
  573728
  555130
  555139
  555133
  600394
  400865
  419539
  474634
  440339
  467402
  457449
  474495
  419517
  451520
  452297
  457437
  470416
  433371
  454270
  466198
  510750
  524967
  526525
  506050
  511554
  484596
  484655
  493178
  484568
  484659
  534682
  534704
  538001
  429561
  466239
  462136
  397421
  474808
  475088
  421660
  466890
  460919
  479979
  468307
  481396
  443776
  489075
  483600
  491144
  424460
  443779
  451877
  465824
  390218
  451526
  490396
  388562
  455966
  481400
  564113
  547924
  555112
  590394
  443119
  458891
  468831
  476487
  477940
  421571
  398932
  424414
  464537
  411726
  470713
  481830
  503869
  484592
  487944
  500184
  515596
  519729
  477721
  567338
  484672
  478006
  470298
  490916
  555114
  555129
  463790
  474401
  475266
  400844
  421592
  467525
  477729
  526885
  510880
  529998
  483380
  494315
  526524
  484618
  510877
  484693
  563190
  455130
  389462
  424413
  400859
  460754
  424194
  443700
  476936
  458701
  462140
  488500
  448558
]
4.06 ms
(2.65%)
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
  388562
  389462
  390218
  397421
  398932
  400844
  400859
  400865
  411726
  419517
  419539
  421571
  421592
  421660
  424194
  424413
  424414
  424460
  429561
  433371
  440339
  443119
  443700
  443776
  443779
  448558
  451520
  451526
  451877
  452297
  454270
  455130
  455966
  457437
  457449
  458701
  458891
  460754
  460919
  462136
  462140
  463790
  464537
  465824
  466198
  466239
  466890
  467402
  467525
  468307
  468831
  470298
  470416
  470713
  474401
  474495
  474634
  474808
  475088
  475266
  476487
  476936
  477721
  477729
  477940
  478006
  479979
  481396
  481400
  481830
  483380
  483600
  484568
  484592
  484596
  484618
  484655
  484659
  484672
  484693
  487944
  488500
  489075
  490396
  490916
  491144
  493178
  494315
  500184
  503869
  506050
  510750
  510877
  510880
  511554
  515596
  519729
  524967
  526524
  526525
  526885
  529998
  534682
  534704
  538001
  547924
  550219
  555112
  555114
  555129
  555130
  555133
  555139
  563078
  563190
  564113
  567338
  573728
  590394
  600394
]
1.86 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mature blonde"
]
1.77 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mature беловолосая"
]
1.63 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.93%)
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.