GET https://search.jues.net/search/embeds/7?q=my%20hairy%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.51 ms
(87.46%)
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
  187974
  423809
  441955
  442447
  455997
  456022
  456037
  458163
  460248
  471020
  475462
  477069
  485423
  488989
  492140
  493262
  495837
  513382
  517834
  521656
  523515
  525728
  539774
  542918
  554686
  554712
  555485
  556057
  556677
  568752
  585050
  585553
  586903
  588427
  592087
  592958
  593208
  593798
  596284
  596562
  606345
  609556
  610115
  627623
  628507
  628692
  628751
  631073
  632949
  636968
  637538
  640254
  643164
  644037
  666709
  666716
  685758
  689436
  696136
  702452
  715264
  717660
  720904
  722046
  723642
  724696
  725251
  725428
  726723
  726986
  728469
  729039
  729041
  729243
  729974
  730280
  732980
  738028
  738377
  739108
  742278
  744159
  744416
  744500
  753772
  756320
  760641
  761282
  769338
  769506
  780730
  783545
  788629
  788633
  791550
  793068
  793912
  794380
  794414
  795059
  795310
  795335
  798934
  800357
  801533
  801561
  801759
  802040
  802276
  808166
  812548
  818561
  823713
  824054
  824077
  824783
  826225
  826620
  826834
  827952
]
13.31 ms
(6.99%)
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
  696136
  722046
  554686
  554712
  596284
  628751
  631073
  632949
  640254
  585553
  609556
  610115
  628507
  637538
  588427
  593208
  627623
  636968
  643164
  780730
  783545
  793912
  794414
  795059
  795310
  801561
  725251
  738028
  742278
  761282
  793068
  795335
  800357
  801759
  802040
  812548
  729041
  732980
  738377
  739108
  744159
  744416
  725428
  753772
  769338
  726723
  729039
  756320
  717660
  788629
  788633
  798934
  724696
  456037
  539774
  525728
  488989
  542918
  556057
  568752
  555485
  666716
  666709
  685758
  606345
  596562
  628692
  729974
  726986
  423809
  585050
  477069
  460248
  493262
  556677
  689436
  586903
  808166
  791550
  728469
  475462
  521656
  187974
  441955
  826225
  715264
  593798
  592087
  801533
  802276
  744500
  729243
  644037
  702452
  442447
  485423
  824783
  456022
  471020
  492140
  458163
  495837
  592958
  720904
  794380
  760641
  730280
  769506
  513382
  824077
  723642
  826620
  826834
  818561
  824054
  823713
  827952
  455997
  517834
  523515
]
2.74 ms
(1.44%)
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
  187974
  423809
  441955
  442447
  455997
  456022
  456037
  458163
  460248
  471020
  475462
  477069
  485423
  488989
  492140
  493262
  495837
  513382
  517834
  521656
  523515
  525728
  539774
  542918
  554686
  554712
  555485
  556057
  556677
  568752
  585050
  585553
  586903
  588427
  592087
  592958
  593208
  593798
  596284
  596562
  606345
  609556
  610115
  627623
  628507
  628692
  628751
  631073
  632949
  636968
  637538
  640254
  643164
  644037
  666709
  666716
  685758
  689436
  696136
  702452
  715264
  717660
  720904
  722046
  723642
  724696
  725251
  725428
  726723
  726986
  728469
  729039
  729041
  729243
  729974
  730280
  732980
  738028
  738377
  739108
  742278
  744159
  744416
  744500
  753772
  756320
  760641
  761282
  769338
  769506
  780730
  783545
  788629
  788633
  791550
  793068
  793912
  794380
  794414
  795059
  795310
  795335
  798934
  800357
  801533
  801561
  801759
  802040
  802276
  808166
  812548
  818561
  823713
  824054
  824077
  824783
  826225
  826620
  826834
  827952
]
2.05 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "my hairy wife"
]
2.00 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "my волосатая жен"
]
1.99 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "my волосатая жен"
]

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.