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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.68 ms
(88.47%)
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
  397883
  418277
  421836
  421873
  424120
  424124
  426864
  440645
  443711
  443747
  448975
  455318
  456000
  456062
  460601
  462082
  462489
  463159
  463173
  464548
  465367
  465970
  466368
  466890
  468355
  477114
  478377
  486578
  490741
  492619
  493195
  506084
  512001
  513374
  515720
  516478
  516480
  516485
  516787
  516792
  518335
  519415
  519672
  519838
  522711
  523834
  523836
  524944
  536434
  537020
  538005
  538603
  540746
  544103
  547762
  547909
  555093
  558610
  560319
  562708
  567076
  568715
  569299
  569411
  572203
  582548
  597590
  601950
  605369
  605475
  605649
  609697
  613052
  619091
  623280
  623790
  663297
  678855
  680037
  692582
  707470
  739622
  744494
  748812
  757135
  757883
  763738
  765794
  765803
  765813
  765830
  765840
  765854
  765870
  777747
  778752
  779534
  779607
  779609
  786384
  786385
  786428
  786781
  787528
  788428
  791759
  796495
  803142
  805129
  807324
  807331
  807594
  808468
  811071
  813416
  816691
  817733
  818057
  818368
  819894
]
12.90 ms
(6.80%)
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
  779607
  440645
  443711
  456062
  536434
  663297
  707470
  786385
  765813
  538005
  680037
  477114
  582548
  555093
  609697
  623790
  597590
  605649
  418277
  519415
  462489
  463159
  455318
  460601
  516478
  524944
  490741
  493195
  512001
  519672
  572203
  547762
  547909
  619091
  397883
  424120
  443747
  464548
  421836
  456000
  465970
  466890
  421873
  448975
  463173
  478377
  424124
  426864
  466368
  468355
  516485
  506084
  519838
  523836
  486578
  516480
  516792
  518335
  523834
  544103
  558610
  562708
  678855
  567076
  605369
  788428
  757883
  601950
  522711
  817733
  818057
  819894
  538603
  560319
  569411
  692582
  613052
  605475
  796495
  805129
  807324
  778752
  779609
  786781
  787528
  808468
  757135
  807331
  807594
  811071
  813416
  739622
  765854
  765870
  748812
  744494
  765830
  765840
  763738
  765794
  765803
  623280
  777747
  779534
  786384
  786428
  791759
  803142
  513374
  515720
  465367
  516787
  569299
  537020
  818368
  816691
  462082
  492619
  540746
  568715
]
2.40 ms
(1.26%)
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
  397883
  418277
  421836
  421873
  424120
  424124
  426864
  440645
  443711
  443747
  448975
  455318
  456000
  456062
  460601
  462082
  462489
  463159
  463173
  464548
  465367
  465970
  466368
  466890
  468355
  477114
  478377
  486578
  490741
  492619
  493195
  506084
  512001
  513374
  515720
  516478
  516480
  516485
  516787
  516792
  518335
  519415
  519672
  519838
  522711
  523834
  523836
  524944
  536434
  537020
  538005
  538603
  540746
  544103
  547762
  547909
  555093
  558610
  560319
  562708
  567076
  568715
  569299
  569411
  572203
  582548
  597590
  601950
  605369
  605475
  605649
  609697
  613052
  619091
  623280
  623790
  663297
  678855
  680037
  692582
  707470
  739622
  744494
  748812
  757135
  757883
  763738
  765794
  765803
  765813
  765830
  765840
  765854
  765870
  777747
  778752
  779534
  779607
  779609
  786384
  786385
  786428
  786781
  787528
  788428
  791759
  796495
  803142
  805129
  807324
  807331
  807594
  808468
  811071
  813416
  816691
  817733
  818057
  818368
  819894
]
2.18 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom russian homemade"
]
1.51 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom русск домашн любительск"
]
1.43 ms
(0.75%)
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.