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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.49 ms
(84.78%)
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
  391116
  391485
  392589
  396430
  397912
  422280
  437619
  443870
  449352
  452768
  455569
  461119
  464566
  475945
  479074
  483437
  483961
  495043
  505460
  516664
  517613
  523788
  525030
  530599
  533690
  535602
  536907
  539623
  542693
  543955
  544462
  546635
  558790
  568110
  579635
  583338
  593823
  594553
  595829
  600725
  606379
  606893
  606926
  610704
  612926
  613813
  614798
  614830
  616527
  620955
  622620
  623804
  625131
  632780
  633553
  635794
  635854
  638111
  640149
  642596
  644421
  644619
  650875
  651423
  653388
  654212
  671824
  682057
  702380
  709347
  710419
  710953
  711231
  718828
  723950
  728502
  728506
  729562
  731401
  731423
  732819
  733024
  738377
  742506
  742542
  745002
  746057
  748385
  749063
  755877
  758288
  759562
  760188
  764842
  765296
  773105
  773965
  775896
  778360
  779086
  782735
  787092
  787628
  792139
  792249
  797361
  798099
  802313
  804525
  805117
  817952
  819692
  819817
  819826
  820134
  824611
  826530
  826768
  828075
  828180
]
12.68 ms
(8.71%)
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
  828075
  483961
  728502
  824611
  644619
  391485
  391116
  671824
  606926
  765296
  443870
  516664
  593823
  632780
  517613
  682057
  819817
  760188
  820134
  748385
  702380
  539623
  612926
  775896
  650875
  579635
  437619
  505460
  464566
  819826
  728506
  742542
  828180
  595829
  723950
  711231
  792139
  787092
  826768
  543955
  764842
  616527
  746057
  614798
  583338
  779086
  742506
  633553
  778360
  782735
  654212
  620955
  759562
  495043
  653388
  826530
  817952
  546635
  709347
  792249
  738377
  710419
  802313
  731401
  755877
  558790
  635854
  710953
  804525
  625131
  392589
  622620
  819692
  542693
  544462
  642596
  606379
  610704
  758288
  535602
  600725
  749063
  773965
  397912
  568110
  613813
  606893
  638111
  731423
  623804
  525030
  475945
  523788
  461119
  536907
  651423
  640149
  729562
  733024
  773105
  594553
  479074
  732819
  797361
  805117
  422280
  455569
  530599
  745002
  718828
  644421
  614830
  452768
  533690
  396430
  635794
  787628
  483437
  798099
  449352
]
3.16 ms
(2.17%)
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
  391116
  391485
  392589
  396430
  397912
  422280
  437619
  443870
  449352
  452768
  455569
  461119
  464566
  475945
  479074
  483437
  483961
  495043
  505460
  516664
  517613
  523788
  525030
  530599
  533690
  535602
  536907
  539623
  542693
  543955
  544462
  546635
  558790
  568110
  579635
  583338
  593823
  594553
  595829
  600725
  606379
  606893
  606926
  610704
  612926
  613813
  614798
  614830
  616527
  620955
  622620
  623804
  625131
  632780
  633553
  635794
  635854
  638111
  640149
  642596
  644421
  644619
  650875
  651423
  653388
  654212
  671824
  682057
  702380
  709347
  710419
  710953
  711231
  718828
  723950
  728502
  728506
  729562
  731401
  731423
  732819
  733024
  738377
  742506
  742542
  745002
  746057
  748385
  749063
  755877
  758288
  759562
  760188
  764842
  765296
  773105
  773965
  775896
  778360
  779086
  782735
  787092
  787628
  792139
  792249
  797361
  798099
  802313
  804525
  805117
  817952
  819692
  819817
  819826
  820134
  824611
  826530
  826768
  828075
  828180
]
1.76 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "my friends wife"
]
1.65 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "my friends жен"
]
1.48 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "my friends жен"
]
1.44 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.