GET https://search.jues.net/search/embeds/6?q=russian%20wife%20compilation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.07 ms
(88.28%)
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
  423848
  426629
  426698
  429954
  430433
  437960
  439559
  439795
  443191
  445320
  445421
  446762
  451535
  452617
  453623
  455125
  456857
  460289
  462949
  464530
  464532
  465348
  465354
  465380
  466241
  466331
  470280
  470617
  470774
  471997
  472510
  472588
  473939
  474113
  475918
  476264
  477131
  479050
  479087
  480707
  480910
  483376
  483385
  484152
  487763
  488692
  489187
  490474
  492050
  492343
  492701
  493402
  493546
  494231
  496940
  499183
  502868
  502973
  509430
  509853
  510456
  513527
  518622
  519299
  519333
  519702
  520745
  521481
  525984
  527168
  527842
  528452
  534076
  540727
  553480
  553637
  571509
  578828
  581471
  593596
  595547
  597482
  599082
  599536
  603468
  603933
  607026
  609235
  619903
  624006
  649523
  691330
  692042
  694115
  695691
  697892
  731124
  731229
  735332
  736289
  738347
  738367
  739531
  741712
  742382
  749909
  754081
  758222
  758236
  758244
  764019
  766503
  771822
  778607
  787488
  792275
  796747
  805149
  809749
  810386
]
16.49 ms
(7.17%)
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
  426698
  446762
  571509
  758222
  739531
  464530
  488692
  493546
  534076
  691330
  578828
  754081
  619903
  581471
  607026
  487763
  456857
  470617
  477131
  496940
  519702
  525984
  509853
  609235
  455125
  519333
  472588
  553480
  453623
  439795
  437960
  492701
  470774
  466241
  464532
  520745
  695691
  597482
  624006
  787488
  792275
  731124
  736289
  796747
  766503
  731229
  742382
  758244
  738347
  749909
  603468
  810386
  443191
  472510
  513527
  484152
  502973
  599082
  490474
  521481
  527842
  518622
  471997
  502868
  480707
  483385
  771822
  475918
  465348
  473939
  470280
  474113
  479050
  519299
  527168
  510456
  465354
  492050
  445320
  499183
  649523
  423848
  426629
  540727
  553637
  697892
  692042
  694115
  599536
  595547
  778607
  805149
  809749
  735332
  738367
  758236
  764019
  741712
  445421
  451535
  476264
  429954
  452617
  603933
  466331
  492343
  480910
  483376
  430433
  509430
  489187
  465380
  479087
  494231
  439559
  462949
  528452
  593596
  460289
  493402
]
2.81 ms
(1.22%)
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
  423848
  426629
  426698
  429954
  430433
  437960
  439559
  439795
  443191
  445320
  445421
  446762
  451535
  452617
  453623
  455125
  456857
  460289
  462949
  464530
  464532
  465348
  465354
  465380
  466241
  466331
  470280
  470617
  470774
  471997
  472510
  472588
  473939
  474113
  475918
  476264
  477131
  479050
  479087
  480707
  480910
  483376
  483385
  484152
  487763
  488692
  489187
  490474
  492050
  492343
  492701
  493402
  493546
  494231
  496940
  499183
  502868
  502973
  509430
  509853
  510456
  513527
  518622
  519299
  519333
  519702
  520745
  521481
  525984
  527168
  527842
  528452
  534076
  540727
  553480
  553637
  571509
  578828
  581471
  593596
  595547
  597482
  599082
  599536
  603468
  603933
  607026
  609235
  619903
  624006
  649523
  691330
  692042
  694115
  695691
  697892
  731124
  731229
  735332
  736289
  738347
  738367
  739531
  741712
  742382
  749909
  754081
  758222
  758236
  758244
  764019
  766503
  771822
  778607
  787488
  792275
  796747
  805149
  809749
  810386
]
2.27 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife compilation"
]
2.01 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен подборк"
]
1.81 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.