GET https://search.jues.net/search/embeds/6?q=mature%20pov%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.36 ms
(83.49%)
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
  418669
  419131
  421043
  421839
  421845
  421889
  421902
  422152
  422194
  422196
  423499
  423571
  423886
  424121
  424695
  431494
  439763
  442352
  444041
  447094
  447276
  448442
  449228
  449723
  450767
  455318
  457980
  458438
  458697
  460659
  460673
  461843
  461848
  464335
  467913
  472867
  473511
  474129
  475258
  477881
  481345
  481866
  488749
  492309
  507885
  507893
  509328
  510217
  513541
  514888
  517405
  517443
  518151
  518507
  518958
  519825
  521049
  521358
  522424
  523345
  523769
  527663
  530863
  531423
  531491
  531500
  531510
  536724
  544120
  555930
  561379
  565785
  566065
  569146
  569546
  569919
  572916
  573145
  574364
  576264
  576520
  581876
  584559
  584693
  585476
  590254
  592854
  595043
  600302
  604197
  604304
  604835
  609816
  611950
  621966
  630351
  636371
  640696
  654688
  695867
  746673
  751572
  765752
  766896
  772535
  784481
  784804
  786523
  787121
  788184
  797447
  798509
  801409
  801742
  807177
  808675
  811220
  820973
  820995
]
17.09 ms
(10.16%)
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
  421839
  531500
  595043
  640696
  460673
  442352
  461848
  424695
  475258
  421043
  514888
  517405
  523769
  517443
  531423
  531510
  746673
  584693
  695867
  801742
  630351
  798509
  423571
  423499
  820973
  820995
  458438
  472867
  473511
  488749
  447276
  449228
  449723
  464335
  481866
  447094
  457980
  458697
  507893
  509328
  521049
  521358
  527663
  536724
  510217
  522424
  523345
  531491
  513541
  518958
  519825
  518151
  530863
  474129
  481345
  492309
  544120
  566065
  573145
  584559
  565785
  569546
  561379
  569146
  569919
  576264
  576520
  654688
  555930
  572916
  574364
  581876
  592854
  609816
  636371
  604197
  621966
  585476
  590254
  600302
  604304
  604835
  786523
  788184
  787121
  797447
  801409
  808675
  811220
  772535
  784481
  784804
  807177
  766896
  751572
  765752
  611950
  423886
  444041
  467913
  418669
  421902
  422152
  431494
  460659
  477881
  421889
  422194
  422196
  424121
  448442
  450767
  419131
  439763
  455318
  465885
  421845
  461843
  507885
  518507
]
3.78 ms
(2.25%)
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
  418669
  419131
  421043
  421839
  421845
  421889
  421902
  422152
  422194
  422196
  423499
  423571
  423886
  424121
  424695
  431494
  439763
  442352
  444041
  447094
  447276
  448442
  449228
  449723
  450767
  455318
  457980
  458438
  458697
  460659
  460673
  461843
  461848
  464335
  467913
  472867
  473511
  474129
  475258
  477881
  481345
  481866
  488749
  492309
  507885
  507893
  509328
  510217
  513541
  514888
  517405
  517443
  518151
  518507
  518958
  519825
  521049
  521358
  522424
  523345
  523769
  527663
  530863
  531423
  531491
  531500
  531510
  536724
  544120
  555930
  561379
  565785
  566065
  569146
  569546
  569919
  572916
  573145
  574364
  576264
  576520
  581876
  584559
  584693
  585476
  590254
  592854
  595043
  600302
  604197
  604304
  604835
  609816
  611950
  621966
  630351
  636371
  640696
  654688
  695867
  746673
  751572
  765752
  766896
  772535
  784481
  784804
  786523
  787121
  788184
  797447
  798509
  801409
  801742
  807177
  808675
  811220
  820973
  820995
]
2.07 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature pov mom"
]
1.71 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature пов mom"
]
1.48 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature пов mom"
]

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.