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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.63 ms
(82.23%)
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
  146508
  233369
  382794
  392489
  403419
  411619
  421917
  422152
  423837
  424473
  428137
  428148
  439738
  439765
  439795
  443704
  444002
  445107
  448055
  457441
  460294
  462584
  464481
  465371
  465844
  465948
  466080
  466129
  466180
  466748
  468076
  470590
  473317
  474394
  474495
  475807
  475867
  477989
  479477
  483411
  483650
  484659
  486964
  490210
  491078
  491969
  492434
  496865
  502814
  504414
  505069
  505254
  509043
  509427
  510425
  510750
  517554
  517599
  519072
  520911
  524384
  524780
  525844
  525890
  528452
  533732
  538970
  539450
  546981
  549787
  549840
  555017
  555989
  557571
  560392
  560867
  563075
  563084
  563163
  563171
  563187
  563206
  563401
  564337
  569983
  573468
  590410
  601938
  605973
  612404
  618861
  620754
  714324
  725206
  733323
  738309
  741771
  742742
  747069
  751560
  752647
  754361
  758804
  759397
  761711
  761743
  762379
  765255
  765374
  765860
  766537
  767078
  779069
  794864
  796194
  797336
  799802
  803880
  807304
  807331
]
16.79 ms
(11.54%)
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
  742742
  767078
  612404
  477989
  428148
  466129
  479477
  517554
  564337
  555989
  557571
  448055
  492434
  510425
  439738
  555017
  569983
  560392
  549787
  573468
  765860
  421917
  491969
  465948
  465844
  470590
  475807
  423837
  462584
  563206
  146508
  443704
  468076
  605973
  794864
  752647
  807304
  759397
  754361
  758804
  803880
  524780
  466180
  466748
  483650
  457441
  601938
  392489
  546981
  741771
  444002
  473317
  509427
  563163
  560867
  563171
  563075
  733323
  538970
  525844
  439765
  439795
  509043
  620754
  533732
  563401
  714324
  779069
  796194
  797336
  738309
  751560
  765255
  765374
  761711
  233369
  382794
  422152
  428137
  411619
  464481
  445107
  460294
  517599
  483411
  505069
  505254
  590410
  524384
  528452
  475867
  465371
  403419
  504414
  474394
  491078
  496865
  502814
  525890
  486964
  490210
  520911
  563187
  799802
  761743
  807331
  766537
  762379
  747069
  539450
  563084
  549840
  618861
  725206
  424473
  474495
  466080
  510750
  519072
  484659
]
2.66 ms
(1.83%)
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
  146508
  233369
  382794
  392489
  403419
  411619
  421917
  422152
  423837
  424473
  428137
  428148
  439738
  439765
  439795
  443704
  444002
  445107
  448055
  457441
  460294
  462584
  464481
  465371
  465844
  465948
  466080
  466129
  466180
  466748
  468076
  470590
  473317
  474394
  474495
  475807
  475867
  477989
  479477
  483411
  483650
  484659
  486964
  490210
  491078
  491969
  492434
  496865
  502814
  504414
  505069
  505254
  509043
  509427
  510425
  510750
  517554
  517599
  519072
  520911
  524384
  524780
  525844
  525890
  528452
  533732
  538970
  539450
  546981
  549787
  549840
  555017
  555989
  557571
  560392
  560867
  563075
  563084
  563163
  563171
  563187
  563206
  563401
  564337
  569983
  573468
  590410
  601938
  605973
  612404
  618861
  620754
  714324
  725206
  733323
  738309
  741771
  742742
  747069
  751560
  752647
  754361
  758804
  759397
  761711
  761743
  762379
  765255
  765374
  765860
  766537
  767078
  779069
  794864
  796194
  797336
  799802
  803880
  807304
  807331
]
1.97 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian bathroom mature"
]
1.67 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск ван mature"
]
1.26 ms
(0.87%)
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.