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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.43 ms
(83.26%)
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
  403911
  405181
  415074
  416015
  416192
  416785
  417828
  418353
  423427
  425326
  425398
  425633
  427533
  435695
  442680
  443383
  445455
  446396
  448149
  449857
  449884
  451064
  451149
  454640
  454676
  457349
  457758
  457963
  457978
  458928
  460444
  465008
  465054
  465070
  468009
  469507
  470451
  470550
  474479
  476514
  477114
  478994
  485150
  489679
  492108
  501875
  502763
  503702
  505279
  510885
  514297
  515378
  516607
  517052
  517464
  518723
  519283
  519765
  520077
  522669
  524226
  524690
  524867
  525061
  528197
  528813
  529265
  532776
  535486
  536616
  540167
  541872
  542678
  543344
  552270
  563988
  563992
  567304
  570896
  570899
  575676
  578067
  578401
  579633
  579869
  580180
  581165
  582035
  582617
  584531
  585376
  586890
  590784
  592377
  595667
  600453
  604505
  606836
  616315
  623920
  623931
  629888
  629893
  631170
  649619
  674978
  680271
  703364
  716394
  752661
  766590
  784158
  788260
  788262
  788268
  792558
  799721
  806591
  808865
  825864
]
15.66 ms
(9.92%)
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
  469507
  570899
  578401
  579869
  580180
  575676
  766590
  629893
  788268
  792558
  457349
  457758
  465008
  477114
  448149
  485150
  524690
  505279
  501875
  458928
  474479
  524867
  563988
  590784
  418353
  435695
  423427
  825864
  470550
  478994
  510885
  522669
  532776
  540167
  468009
  578067
  606836
  616315
  600453
  623931
  752661
  446396
  460444
  449857
  415074
  425326
  457978
  454676
  489679
  528813
  529265
  535486
  543344
  552270
  806591
  784158
  799721
  451149
  502763
  518723
  519283
  525061
  514297
  528197
  425398
  449884
  454640
  519765
  581165
  703364
  808865
  788260
  416192
  416785
  470451
  427533
  451064
  503702
  515378
  516607
  520077
  563992
  579633
  586890
  604505
  592377
  476514
  524226
  465054
  465070
  425633
  680271
  716394
  582617
  631170
  517464
  443383
  674978
  582035
  584531
  623920
  788262
  442680
  416015
  417828
  536616
  541872
  542678
  570896
  649619
  567304
  585376
  629888
  595667
  445455
  405181
  457963
  492108
  403911
  517052
]
2.80 ms
(1.78%)
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
  403911
  405181
  415074
  416015
  416192
  416785
  417828
  418353
  423427
  425326
  425398
  425633
  427533
  435695
  442680
  443383
  445455
  446396
  448149
  449857
  449884
  451064
  451149
  454640
  454676
  457349
  457758
  457963
  457978
  458928
  460444
  465008
  465054
  465070
  468009
  469507
  470451
  470550
  474479
  476514
  477114
  478994
  485150
  489679
  492108
  501875
  502763
  503702
  505279
  510885
  514297
  515378
  516607
  517052
  517464
  518723
  519283
  519765
  520077
  522669
  524226
  524690
  524867
  525061
  528197
  528813
  529265
  532776
  535486
  536616
  540167
  541872
  542678
  543344
  552270
  563988
  563992
  567304
  570896
  570899
  575676
  578067
  578401
  579633
  579869
  580180
  581165
  582035
  582617
  584531
  585376
  586890
  590784
  592377
  595667
  600453
  604505
  606836
  616315
  623920
  623931
  629888
  629893
  631170
  649619
  674978
  680271
  703364
  716394
  752661
  766590
  784158
  788260
  788262
  788268
  792558
  799721
  806591
  808865
  825864
]
2.19 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.17 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "коспл секс"
]
2.08 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cosplay sex"
]
1.53 ms
(0.97%)
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.