GET https://search.jues.net/search/embeds/8?q=young%20threesome%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.58 ms
(83.30%)
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
  282010
  381940
  393076
  395552
  395719
  395738
  395915
  397269
  397364
  397369
  401933
  403911
  404754
  404811
  404957
  405012
  405531
  407067
  407414
  408306
  409682
  410657
  411201
  411547
  411787
  416351
  418423
  421271
  422626
  423893
  425582
  429898
  430072
  430095
  433747
  434000
  434055
  434611
  437810
  447930
  448644
  451826
  451867
  453918
  458031
  463764
  464129
  464328
  468626
  469073
  469909
  470527
  471628
  473831
  473871
  474631
  477210
  477439
  477580
  478647
  479847
  485037
  489082
  491678
  491885
  491999
  495220
  496900
  501797
  502703
  505048
  510588
  517229
  518289
  519061
  522095
  523335
  523389
  528441
  530663
  531120
  532982
  532984
  533929
  534316
  536681
  537919
  539010
  541650
  542192
  551579
  553280
  554513
  557163
  559950
  565281
  571198
  576347
  576393
  578473
  586628
  589148
  590861
  590865
  596168
  597813
  605122
  620851
  623199
  623205
  650380
  663495
  663992
  685682
  710524
  717852
  719343
  728452
  775809
  805420
]
18.12 ms
(10.44%)
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
  430072
  433747
  416351
  422626
  468626
  518289
  532984
  685682
  576347
  395552
  404811
  405012
  491885
  496900
  464328
  395915
  408306
  411547
  458031
  477580
  536681
  533929
  597813
  728452
  381940
  418423
  429898
  405531
  469909
  491999
  451826
  479847
  464129
  519061
  539010
  551579
  576393
  717852
  719343
  590861
  407414
  395738
  425582
  397369
  453918
  530663
  532982
  502703
  663495
  554513
  590865
  805420
  409682
  430095
  470527
  485037
  471628
  523335
  403911
  522095
  393076
  523389
  478647
  559950
  517229
  437810
  282010
  447930
  395719
  448644
  489082
  463764
  589148
  623199
  542192
  605122
  528441
  541650
  586628
  571198
  473871
  650380
  596168
  620851
  477210
  410657
  451867
  495220
  477439
  397364
  434000
  474631
  578473
  663992
  557163
  423893
  411787
  421271
  473831
  411201
  397269
  434055
  434611
  531120
  537919
  469073
  565281
  623205
  775809
  401933
  404957
  407067
  501797
  491678
  510588
  505048
  553280
  534316
  710524
  404754
]
3.20 ms
(1.84%)
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
  282010
  381940
  393076
  395552
  395719
  395738
  395915
  397269
  397364
  397369
  401933
  403911
  404754
  404811
  404957
  405012
  405531
  407067
  407414
  408306
  409682
  410657
  411201
  411547
  411787
  416351
  418423
  421271
  422626
  423893
  425582
  429898
  430072
  430095
  433747
  434000
  434055
  434611
  437810
  447930
  448644
  451826
  451867
  453918
  458031
  463764
  464129
  464328
  468626
  469073
  469909
  470527
  471628
  473831
  473871
  474631
  477210
  477439
  477580
  478647
  479847
  485037
  489082
  491678
  491885
  491999
  495220
  496900
  501797
  502703
  505048
  510588
  517229
  518289
  519061
  522095
  523335
  523389
  528441
  530663
  531120
  532982
  532984
  533929
  534316
  536681
  537919
  539010
  541650
  542192
  551579
  553280
  554513
  557163
  559950
  565281
  571198
  576347
  576393
  578473
  586628
  589148
  590861
  590865
  596168
  597813
  605122
  620851
  623199
  623205
  650380
  663495
  663992
  685682
  710524
  717852
  719343
  728452
  775809
  805420
]
2.30 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young threesome teen"
]
1.76 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young секс втро teen"
]
1.49 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young секс втро teen"
]

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.