GET https://search.jues.net/search/embeds/9?q=fucked%20hard%2018

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
245.43 ms
(90.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
  287315
  382347
  386771
  396100
  396389
  396825
  399858
  400465
  400935
  417955
  418099
  418490
  421068
  429289
  434842
  441912
  442625
  445711
  446698
  448006
  449511
  453668
  454355
  455023
  456061
  457955
  457982
  459752
  464096
  464856
  465964
  466142
  469765
  473316
  473522
  475563
  477197
  477738
  478264
  479580
  485255
  487013
  489439
  494123
  495023
  504809
  505230
  506122
  509263
  509588
  511209
  512429
  513678
  514792
  517676
  521452
  524568
  534434
  534470
  540422
  541727
  550411
  551229
  551443
  551649
  552128
  556331
  560045
  569118
  570379
  570382
  570538
  572519
  584463
  586802
  593163
  593276
  598804
  599169
  602620
  603013
  603800
  610576
  613305
  617111
  619406
  621374
  624835
  652284
  657221
  699583
  729759
  732153
  733896
  734981
  739905
  740092
  745364
  755108
  755331
  760375
  762327
  769209
  770563
  776521
  777924
  778614
  780278
  783446
  784286
  784910
  794906
  802947
  805005
  806903
  807551
  809720
  809891
  819611
  825119
]
16.60 ms
(6.11%)
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
  603013
  603800
  777924
  780278
  783446
  784910
  805005
  729759
  740092
  769209
  770563
  784286
  802947
  732153
  745364
  755108
  762327
  734981
  755331
  739905
  809891
  473316
  469765
  504809
  396100
  400935
  825119
  456061
  540422
  541727
  556331
  550411
  657221
  699583
  652284
  806903
  733896
  445711
  287315
  464856
  475563
  477738
  442625
  524568
  521452
  386771
  382347
  396825
  396389
  400465
  399858
  429289
  434842
  418490
  819611
  453668
  477197
  487013
  465964
  494123
  534434
  534470
  506122
  517676
  509588
  473522
  551229
  551649
  560045
  584463
  552128
  570538
  551443
  570382
  572519
  569118
  570379
  586802
  593163
  624835
  610576
  619406
  621374
  593276
  602620
  598804
  599169
  778614
  776521
  760375
  613305
  617111
  794906
  807551
  809720
  446698
  454355
  457955
  457982
  466142
  478264
  479580
  417955
  464096
  512429
  513678
  514792
  489439
  495023
  505230
  418099
  421068
  441912
  448006
  455023
  459752
  449511
  485255
  509263
  511209
]
2.96 ms
(1.09%)
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
  287315
  382347
  386771
  396100
  396389
  396825
  399858
  400465
  400935
  417955
  418099
  418490
  421068
  429289
  434842
  441912
  442625
  445711
  446698
  448006
  449511
  453668
  454355
  455023
  456061
  457955
  457982
  459752
  464096
  464856
  465964
  466142
  469765
  473316
  473522
  475563
  477197
  477738
  478264
  479580
  485255
  487013
  489439
  494123
  495023
  504809
  505230
  506122
  509263
  509588
  511209
  512429
  513678
  514792
  517676
  521452
  524568
  534434
  534470
  540422
  541727
  550411
  551229
  551443
  551649
  552128
  556331
  560045
  569118
  570379
  570382
  570538
  572519
  584463
  586802
  593163
  593276
  598804
  599169
  602620
  603013
  603800
  610576
  613305
  617111
  619406
  621374
  624835
  652284
  657221
  699583
  729759
  732153
  733896
  734981
  739905
  740092
  745364
  755108
  755331
  760375
  762327
  769209
  770563
  776521
  777924
  778614
  780278
  783446
  784286
  784910
  794906
  802947
  805005
  806903
  807551
  809720
  809891
  819611
  825119
]
2.11 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucked hard 18"
]
1.73 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucked hard 18"
]
1.67 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucked hard 18"
]

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.