GET https://search.jues.net/search/embeds/10?q=sperm%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.45 ms
(57.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм teen"
]
136.19 ms
(37.56%)
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
  384498
  396802
  410936
  412753
  417554
  418369
  426323
  447146
  447486
  448876
  459735
  460402
  463863
  476962
  497426
  501286
  507514
  510397
  517843
  523197
  526776
  527629
  529109
  530026
  530584
  531106
  544835
  559403
  561813
  562637
  565274
  585990
  590935
  592638
  597233
  598498
  605399
  609898
  611047
  629686
  633870
  635402
  644883
  646092
  648538
  651996
  653487
  660338
  678769
  692051
  693176
  709239
  715055
  716042
  717249
  717654
  717726
  720366
  722219
  723197
  723526
  730332
  735312
  736610
  741637
  742266
  743395
  750144
  750943
  751675
  753219
  753909
  757477
  758683
  758983
  760356
  760589
  761682
  763863
  765419
  765585
  767304
  769068
  771862
  771904
  771932
  772861
  772872
  773448
  773507
  775198
  775208
  776046
  776286
  779683
  781366
  781565
  783569
  784541
  787242
  787318
  789417
  790288
  791239
  791640
  791782
  791805
  792433
  792806
  795470
  796218
  797625
  800576
  809697
  813399
  823711
  823851
  825993
  827531
]
11.25 ms
(3.10%)
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
  501286
  523197
  460402
  562637
  561813
  565274
  653487
  678769
  544835
  597233
  605399
  609898
  463863
  476962
  412753
  418369
  426323
  447146
  448876
  447486
  526776
  527629
  497426
  646092
  715055
  635402
  590935
  779683
  790288
  791805
  772861
  789417
  757477
  772872
  384498
  592638
  611047
  791782
  556732
  417554
  723526
  827531
  459735
  530584
  722219
  651996
  692051
  648538
  693176
  629686
  775208
  795470
  796218
  800576
  776046
  776286
  783569
  784541
  791239
  791640
  792806
  809697
  735312
  758683
  760356
  760589
  761682
  767304
  773448
  792433
  741637
  750943
  765419
  771862
  771904
  771932
  730332
  742266
  750144
  753219
  763863
  773507
  717249
  775198
  787318
  396802
  823851
  559403
  813399
  736610
  517843
  507514
  529109
  510397
  531106
  598498
  585990
  410936
  530026
  660338
  633870
  758983
  723197
  644883
  717726
  716042
  720366
  797625
  781366
  769068
  781565
  751675
  717654
  825993
  823711
  709239
  787242
  743395
  753909
  765585
]
2.16 ms
(0.60%)
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
  384498
  396802
  410936
  412753
  417554
  418369
  426323
  447146
  447486
  448876
  459735
  460402
  463863
  476962
  497426
  501286
  507514
  510397
  517843
  523197
  526776
  527629
  529109
  530026
  530584
  531106
  544835
  559403
  561813
  562637
  565274
  585990
  590935
  592638
  597233
  598498
  605399
  609898
  611047
  629686
  633870
  635402
  644883
  646092
  648538
  651996
  653487
  660338
  678769
  692051
  693176
  709239
  715055
  716042
  717249
  717654
  717726
  720366
  722219
  723197
  723526
  730332
  735312
  736610
  741637
  742266
  743395
  750144
  750943
  751675
  753219
  753909
  757477
  758683
  758983
  760356
  760589
  761682
  763863
  765419
  765585
  767304
  769068
  771862
  771904
  771932
  772861
  772872
  773448
  773507
  775198
  775208
  776046
  776286
  779683
  781366
  781565
  783569
  784541
  787242
  787318
  789417
  790288
  791239
  791640
  791782
  791805
  792433
  792806
  795470
  796218
  797625
  800576
  809697
  813399
  823711
  823851
  825993
  827531
]
1.89 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm teen"
]
1.83 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм teen"
]
1.81 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.