GET https://search.jues.net/search/embeds/8?q=russian%20mom%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.94 ms
(89.02%)
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
  390218
  391565
  398955
  400861
  415814
  422264
  433362
  441821
  443387
  443948
  444679
  448714
  451324
  453184
  454869
  455318
  456693
  458072
  460601
  462489
  462707
  463159
  464915
  465331
  465342
  474780
  474781
  477984
  478376
  478937
  483362
  490741
  493195
  495617
  506225
  516478
  516787
  516829
  518004
  521121
  523608
  524944
  542090
  547741
  547763
  547791
  547802
  551821
  557969
  563102
  564645
  565859
  566659
  568367
  578821
  580363
  588958
  590223
  591383
  598862
  604334
  611521
  623216
  627064
  630448
  655295
  660137
  680037
  690625
  693396
  704892
  705317
  711745
  719977
  722302
  728243
  741222
  745461
  751603
  757918
  759997
  763079
  763726
  763729
  763745
  765849
  765859
  765863
  765934
  766165
  768603
  771370
  777499
  778784
  779803
  782553
  785482
  786238
  786309
  786368
  787178
  787357
  789276
  790553
  794041
  797361
  799217
  799419
  801654
  803137
  803518
  805137
  805154
  805736
  808342
  814147
  816105
  816124
  817725
  825673
]
16.82 ms
(7.00%)
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
  704892
  690625
  551821
  590223
  604334
  623216
  591383
  598862
  680037
  400861
  542090
  547791
  557969
  547802
  564645
  578821
  580363
  660137
  565859
  433362
  453184
  441821
  462707
  465342
  422264
  454869
  474780
  456693
  415814
  464915
  465331
  495617
  506225
  516829
  521121
  483362
  518004
  523608
  563102
  478376
  391565
  443948
  547741
  568367
  611521
  751603
  789276
  765859
  763079
  785482
  444679
  398955
  448714
  817725
  816124
  814147
  566659
  547763
  693396
  705317
  719977
  722302
  588958
  627064
  777499
  786238
  790553
  797361
  778784
  786368
  787357
  799419
  801654
  805137
  766165
  794041
  805736
  808342
  741222
  765849
  765934
  745461
  757918
  765863
  768603
  759997
  763726
  763729
  763745
  728243
  771370
  711745
  779803
  782553
  786309
  787178
  799217
  803137
  805154
  478937
  451324
  458072
  390218
  462489
  463159
  443387
  455318
  460601
  474781
  516478
  524944
  490741
  493195
  825673
  655295
  803518
  477984
  630448
  516787
  816105
]
2.79 ms
(1.16%)
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
  390218
  391565
  398955
  400861
  415814
  422264
  433362
  441821
  443387
  443948
  444679
  448714
  451324
  453184
  454869
  455318
  456693
  458072
  460601
  462489
  462707
  463159
  464915
  465331
  465342
  474780
  474781
  477984
  478376
  478937
  483362
  490741
  493195
  495617
  506225
  516478
  516787
  516829
  518004
  521121
  523608
  524944
  542090
  547741
  547763
  547791
  547802
  551821
  557969
  563102
  564645
  565859
  566659
  568367
  578821
  580363
  588958
  590223
  591383
  598862
  604334
  611521
  623216
  627064
  630448
  655295
  660137
  680037
  690625
  693396
  704892
  705317
  711745
  719977
  722302
  728243
  741222
  745461
  751603
  757918
  759997
  763079
  763726
  763729
  763745
  765849
  765859
  765863
  765934
  766165
  768603
  771370
  777499
  778784
  779803
  782553
  785482
  786238
  786309
  786368
  787178
  787357
  789276
  790553
  794041
  797361
  799217
  799419
  801654
  803137
  803518
  805137
  805154
  805736
  808342
  814147
  816105
  816124
  817725
  825673
]
1.82 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mom amateur"
]
1.77 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mom любительск"
]
1.71 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск 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.