GET https://search.jues.net/search/embeds/9?q=young%20girl%20hardcore

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.46 ms
(83.11%)
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
  395674
  401032
  404175
  406171
  407146
  410657
  410936
  411201
  411787
  420358
  443773
  445015
  445327
  461056
  461086
  462079
  465805
  470852
  475166
  491270
  500725
  506529
  508156
  515136
  515202
  523585
  524792
  529855
  530010
  530275
  530765
  531120
  531165
  532766
  532804
  534028
  536584
  536752
  537659
  539203
  540304
  541250
  544498
  545959
  550094
  551898
  568564
  568916
  569740
  575445
  580770
  590900
  595363
  595520
  598470
  598731
  604968
  611336
  617363
  623205
  623598
  623838
  624424
  624835
  627818
  631952
  631968
  639718
  648877
  650830
  652927
  656761
  662222
  663353
  673299
  679380
  683567
  683955
  684949
  687205
  688220
  692337
  695898
  698124
  701508
  703897
  705808
  710909
  714477
  719141
  719203
  721445
  721798
  722462
  726461
  727642
  728384
  729230
  732312
  744511
  747345
  752058
  753482
  753677
  754409
  759326
  759435
  775988
  775994
  784257
  790101
  790222
  799292
  799768
  803244
  805727
  807918
  811008
  811611
  818462
]
14.69 ms
(9.73%)
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
  656761
  673299
  687205
  714477
  662222
  695898
  722462
  611336
  627818
  623838
  775988
  728384
  759326
  752058
  759435
  803244
  747345
  475166
  465805
  461056
  683567
  688220
  679380
  703897
  604968
  631952
  590900
  624424
  595363
  799292
  790101
  753482
  726461
  744511
  623598
  721798
  805727
  807918
  811008
  541250
  536584
  532766
  575445
  404175
  407146
  532804
  530765
  506529
  544498
  401032
  500725
  508156
  663353
  754409
  818462
  550094
  719203
  648877
  684949
  545959
  617363
  727642
  799768
  753677
  705808
  775994
  790222
  529855
  623205
  410936
  491270
  524792
  445327
  530010
  650830
  443773
  395674
  461086
  784257
  530275
  539203
  410657
  531120
  531165
  534028
  536752
  537659
  639718
  411787
  470852
  710909
  698124
  652927
  406171
  445015
  462079
  420358
  411201
  683955
  598731
  631968
  515136
  540304
  551898
  568916
  701508
  580770
  595520
  732312
  811611
  515202
  729230
  523585
  568564
  719141
  692337
  721445
  569740
  598470
  624835
]
2.89 ms
(1.91%)
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
  395674
  401032
  404175
  406171
  407146
  410657
  410936
  411201
  411787
  420358
  443773
  445015
  445327
  461056
  461086
  462079
  465805
  470852
  475166
  491270
  500725
  506529
  508156
  515136
  515202
  523585
  524792
  529855
  530010
  530275
  530765
  531120
  531165
  532766
  532804
  534028
  536584
  536752
  537659
  539203
  540304
  541250
  544498
  545959
  550094
  551898
  568564
  568916
  569740
  575445
  580770
  590900
  595363
  595520
  598470
  598731
  604968
  611336
  617363
  623205
  623598
  623838
  624424
  624835
  627818
  631952
  631968
  639718
  648877
  650830
  652927
  656761
  662222
  663353
  673299
  679380
  683567
  683955
  684949
  687205
  688220
  692337
  695898
  698124
  701508
  703897
  705808
  710909
  714477
  719141
  719203
  721445
  721798
  722462
  726461
  727642
  728384
  729230
  732312
  744511
  747345
  752058
  753482
  753677
  754409
  759326
  759435
  775988
  775994
  784257
  790101
  790222
  799292
  799768
  803244
  805727
  807918
  811008
  811611
  818462
]
2.04 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young girl hardcore"
]
2.03 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young девушк хардкор"
]
1.90 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young девушк хардкор"
]

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.