GET https://search.jues.net/search/embeds/10?q=game%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.79 ms
(85.16%)
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
  394962
  402859
  404899
  411757
  412772
  418426
  420354
  420383
  429824
  457079
  459305
  460894
  461796
  465055
  465205
  469982
  470555
  470558
  472575
  475973
  476018
  477751
  480357
  482274
  485337
  488441
  492304
  496661
  498485
  504515
  510175
  522861
  531698
  531706
  531720
  545635
  545644
  546573
  549308
  550264
  552101
  552580
  552589
  552593
  562960
  568703
  571190
  574358
  574374
  574663
  580193
  580338
  583009
  604544
  606989
  607631
  616625
  619667
  631615
  638477
  648570
  656197
  659396
  660299
  660462
  661590
  666777
  668437
  668696
  669391
  672896
  678313
  687245
  692732
  701501
  702627
  705737
  715788
  721042
  722382
  722864
  724604
  727335
  728226
  734693
  743471
  750891
  751150
  754104
  754174
  757244
  761129
  766853
  767247
  770612
  774214
  776617
  784429
  786479
  788299
  789666
  790076
  790209
  794045
  794440
  797262
  799420
  802594
  804864
  806043
  811081
  811350
  811757
  812109
  812982
  815723
  819320
  821376
  825044
]
16.09 ms
(8.79%)
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
  776617
  734693
  797262
  741836
  757244
  794045
  461796
  504515
  420354
  429824
  459305
  492304
  546573
  580193
  580338
  583009
  571190
  722382
  552593
  604544
  619667
  607631
  631615
  790076
  799420
  812982
  728226
  743471
  750891
  767247
  770612
  482274
  480357
  488441
  812109
  815723
  678313
  660299
  786479
  457079
  522861
  789666
  754174
  402859
  472575
  531698
  470558
  545635
  545644
  552589
  574358
  660462
  656197
  574374
  788299
  727335
  794440
  766853
  606989
  715788
  475973
  412772
  469982
  465205
  819320
  825044
  552580
  701501
  804864
  811081
  724604
  702627
  394962
  420383
  821376
  498485
  485337
  552101
  666777
  668437
  669391
  659396
  687245
  806043
  774214
  754104
  751150
  761129
  705737
  722864
  790209
  802594
  470555
  404899
  411757
  460894
  476018
  510175
  418426
  465055
  477751
  496661
  531706
  531720
  549308
  574663
  562960
  661590
  668696
  648570
  692732
  672896
  721042
  550264
  568703
  616625
  638477
  811350
  811757
  784429
]
3.23 ms
(1.77%)
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
  394962
  402859
  404899
  411757
  412772
  418426
  420354
  420383
  429824
  457079
  459305
  460894
  461796
  465055
  465205
  469982
  470555
  470558
  472575
  475973
  476018
  477751
  480357
  482274
  485337
  488441
  492304
  496661
  498485
  504515
  510175
  522861
  531698
  531706
  531720
  545635
  545644
  546573
  549308
  550264
  552101
  552580
  552589
  552593
  562960
  568703
  571190
  574358
  574374
  574663
  580193
  580338
  583009
  604544
  606989
  607631
  616625
  619667
  631615
  638477
  648570
  656197
  659396
  660299
  660462
  661590
  666777
  668437
  668696
  669391
  672896
  678313
  687245
  692732
  701501
  702627
  705737
  715788
  721042
  722382
  722864
  724604
  727335
  728226
  734693
  743471
  750891
  751150
  754104
  754174
  757244
  761129
  766853
  767247
  770612
  774214
  776617
  784429
  786479
  788299
  789666
  790076
  790209
  794045
  794440
  797262
  799420
  802594
  804864
  806043
  811081
  811350
  811757
  812109
  812982
  815723
  819320
  821376
  825044
]
2.22 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "игр секс"
]
1.86 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "game sex"
]
1.74 ms
(0.95%)
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.