GET https://search.jues.net/search/embeds/4?q=sex%20white%20couple

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.74 ms
(87.42%)
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
  386684
  388919
  392498
  395723
  399143
  402848
  403654
  416894
  417530
  420106
  421073
  421310
  422048
  424701
  425337
  428963
  430320
  434850
  435916
  438533
  439897
  440686
  440701
  440992
  441538
  441622
  442754
  443611
  444403
  446833
  449230
  451015
  453422
  453666
  455377
  456174
  456581
  460562
  461174
  461495
  462589
  463008
  465404
  465461
  465713
  468188
  470663
  470891
  471484
  471559
  471596
  472028
  472042
  472342
  474088
  474903
  474910
  474945
  475622
  476414
  479700
  479781
  480070
  480638
  481320
  481321
  481635
  482583
  482774
  482906
  482915
  482952
  483875
  485499
  486817
  486883
  489178
  489226
  490088
  493997
  495240
  495433
  495844
  497800
  498763
  501518
  504228
  504252
  508078
  509096
  509840
  510088
  510232
  510560
  510652
  510990
  512162
  512921
  514118
  516283
  519383
  520490
  521443
  521917
  521926
  522560
  523972
  524681
  525196
  525565
  525781
  525995
  527111
  527113
  528727
  531523
  533665
  537290
  748349
  815076
]
15.97 ms
(7.86%)
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
  430320
  471559
  480070
  476414
  481321
  465713
  474903
  510652
  485499
  508078
  489178
  521926
  402848
  440701
  444403
  438533
  441622
  420106
  416894
  527113
  482774
  523972
  527111
  495844
  501518
  510560
  461174
  417530
  474910
  428963
  439897
  462589
  455377
  465404
  442754
  468188
  475622
  482915
  483875
  510088
  482906
  498763
  512921
  519383
  441538
  440992
  456581
  482583
  446833
  472042
  495433
  422048
  434850
  453422
  461495
  443611
  489226
  509840
  521917
  482952
  479700
  388919
  451015
  504252
  392498
  533665
  510990
  463008
  524681
  520490
  424701
  395723
  472342
  504228
  521443
  399143
  403654
  421310
  815076
  456174
  481635
  748349
  421073
  510232
  435916
  465461
  531523
  516283
  525995
  537290
  525196
  471484
  386684
  425337
  495240
  453666
  490088
  486883
  471596
  449230
  474088
  509096
  486817
  512162
  514118
  525565
  525781
  493997
  522560
  440686
  479781
  497800
  528727
  470663
  474945
  480638
  460562
  470891
  472028
  481320
]
3.00 ms
(1.48%)
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
  386684
  388919
  392498
  395723
  399143
  402848
  403654
  416894
  417530
  420106
  421073
  421310
  422048
  424701
  425337
  428963
  430320
  434850
  435916
  438533
  439897
  440686
  440701
  440992
  441538
  441622
  442754
  443611
  444403
  446833
  449230
  451015
  453422
  453666
  455377
  456174
  456581
  460562
  461174
  461495
  462589
  463008
  465404
  465461
  465713
  468188
  470663
  470891
  471484
  471559
  471596
  472028
  472042
  472342
  474088
  474903
  474910
  474945
  475622
  476414
  479700
  479781
  480070
  480638
  481320
  481321
  481635
  482583
  482774
  482906
  482915
  482952
  483875
  485499
  486817
  486883
  489178
  489226
  490088
  493997
  495240
  495433
  495844
  497800
  498763
  501518
  504228
  504252
  508078
  509096
  509840
  510088
  510232
  510560
  510652
  510990
  512162
  512921
  514118
  516283
  519383
  520490
  521443
  521917
  521926
  522560
  523972
  524681
  525196
  525565
  525781
  525995
  527111
  527113
  528727
  531523
  533665
  537290
  748349
  815076
]
1.90 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex white couple"
]
1.61 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс white couple"
]
1.20 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс white couple"
]

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.