GET https://search.jues.net/search/embeds/9?q=dick%20for%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.23 ms
(88.11%)
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
  397115
  402045
  413136
  427264
  430621
  430979
  431749
  439713
  439798
  486540
  491963
  491978
  510299
  515317
  518960
  522154
  524862
  524866
  530604
  531902
  532110
  533282
  538165
  538329
  539610
  554153
  556636
  556655
  573398
  578348
  584338
  591120
  597728
  599286
  603196
  617190
  633505
  640863
  641359
  641631
  646755
  651665
  666612
  668562
  669224
  669704
  672410
  675006
  677319
  694214
  699025
  710881
  714457
  714475
  715493
  719006
  723380
  725260
  727436
  730702
  733540
  733613
  736847
  736898
  737067
  737724
  740967
  743019
  744582
  753656
  756063
  756920
  757562
  759057
  759889
  760763
  770076
  771379
  771380
  771557
  772513
  774105
  774119
  774357
  777534
  778360
  780645
  787144
  787764
  792484
  793457
  797853
  798626
  799230
  800085
  800257
  802982
  803289
  807630
  809248
  810454
  810642
  811236
  811424
  812091
  813048
  814884
  815860
  816116
  816534
  816563
  816783
  816929
  817940
  818469
  818609
  822279
  822471
  822589
  825862
]
11.36 ms
(6.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
  573398
  599286
  641631
  603196
  777534
  793457
  813048
  787144
  787764
  797853
  798626
  807630
  733613
  737067
  737724
  759057
  774105
  800257
  802982
  810454
  812091
  725260
  736898
  774357
  770076
  771380
  774119
  715493
  778360
  780645
  803289
  810642
  817940
  822279
  538165
  578348
  584338
  669704
  694214
  710881
  646755
  677319
  554153
  591120
  640863
  641359
  800085
  809248
  811236
  772513
  792484
  799230
  733540
  753656
  756063
  736847
  771557
  427264
  815860
  816563
  822471
  816783
  822589
  651665
  719006
  672410
  666612
  811424
  743019
  744582
  633505
  723380
  491978
  431749
  491963
  522154
  669224
  756920
  771379
  759889
  518960
  556636
  675006
  430621
  510299
  486540
  524862
  524866
  556655
  714475
  699025
  617190
  714457
  430979
  439798
  439713
  814884
  816116
  816534
  538329
  539610
  531902
  533282
  530604
  532110
  668562
  597728
  730702
  740967
  727436
  757562
  760763
  402045
  413136
  515317
  397115
  816929
  818469
  818609
  825862
]
2.68 ms
(1.54%)
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
  397115
  402045
  413136
  427264
  430621
  430979
  431749
  439713
  439798
  486540
  491963
  491978
  510299
  515317
  518960
  522154
  524862
  524866
  530604
  531902
  532110
  533282
  538165
  538329
  539610
  554153
  556636
  556655
  573398
  578348
  584338
  591120
  597728
  599286
  603196
  617190
  633505
  640863
  641359
  641631
  646755
  651665
  666612
  668562
  669224
  669704
  672410
  675006
  677319
  694214
  699025
  710881
  714457
  714475
  715493
  719006
  723380
  725260
  727436
  730702
  733540
  733613
  736847
  736898
  737067
  737724
  740967
  743019
  744582
  753656
  756063
  756920
  757562
  759057
  759889
  760763
  770076
  771379
  771380
  771557
  772513
  774105
  774119
  774357
  777534
  778360
  780645
  787144
  787764
  792484
  793457
  797853
  798626
  799230
  800085
  800257
  802982
  803289
  807630
  809248
  810454
  810642
  811236
  811424
  812091
  813048
  814884
  815860
  816116
  816534
  816563
  816783
  816929
  817940
  818469
  818609
  822279
  822471
  822589
  825862
]
2.09 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick for mom"
]
1.64 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член mom"
]
1.59 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 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.