GET https://search.jues.net/search/embeds/3?q=teen%20kissing

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.90 ms
(85.93%)
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
  2779
  6698
  13767
  17037
  366283
  388952
  401088
  401139
  415535
  430807
  447487
  448930
  457953
  462854
  473550
  486145
  491800
  502390
  510660
  521876
  525366
  527498
  552161
  552184
  552192
  552193
  552208
  552243
  559083
  562317
  563618
  567387
  567738
  568355
  571643
  573792
  575070
  586542
  590989
  592071
  593171
  595375
  597535
  605335
  612173
  624228
  630289
  634045
  649536
  652949
  654332
  654465
  664245
  665658
  671301
  671736
  671914
  672485
  672492
  675801
  676498
  676914
  677343
  678554
  678981
  679084
  679107
  679130
  679388
  679698
  680096
  684052
  688560
  690012
  692013
  704842
  706754
  712959
  715920
  716559
  716871
  719171
  721412
  722214
  722684
  722705
  722816
  722839
  725171
  727770
  729035
  730852
  742928
  742931
  743197
  746478
  748322
  748738
  753473
  753477
  754260
  755178
  759543
  760586
  760963
  767327
  769750
  769755
  769829
  772110
  779135
  785770
  786334
  787953
  793892
  802627
  810812
  811832
  812115
  821091
]
15.94 ms
(8.62%)
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
  592071
  590989
  595375
  605335
  760963
  448930
  462854
  430807
  447487
  457953
  502390
  6698
  527498
  486145
  552184
  559083
  573792
  563618
  567738
  649536
  652949
  664245
  671914
  676498
  690012
  722214
  665658
  672485
  679107
  679130
  680096
  684052
  716559
  722684
  722816
  671301
  676914
  678554
  679084
  688560
  552243
  586542
  634045
  624228
  793892
  810812
  811832
  725171
  742928
  748322
  767327
  746478
  753473
  769750
  748738
  769755
  769829
  727770
  729035
  760586
  706754
  715920
  722839
  785770
  366283
  473550
  2779
  17037
  401139
  415535
  521876
  510660
  13767
  388952
  401088
  821091
  491800
  525366
  552161
  571643
  552193
  552208
  575070
  654465
  671736
  678981
  704842
  719171
  672492
  677343
  679388
  679698
  692013
  716871
  722705
  654332
  675801
  712959
  721412
  552192
  562317
  567387
  568355
  612173
  630289
  593171
  597535
  779135
  812115
  802627
  742931
  743197
  772110
  786334
  787953
  753477
  730852
  754260
  755178
  759543
]
2.68 ms
(1.45%)
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
  2779
  6698
  13767
  17037
  366283
  388952
  401088
  401139
  415535
  430807
  447487
  448930
  457953
  462854
  473550
  486145
  491800
  502390
  510660
  521876
  525366
  527498
  552161
  552184
  552192
  552193
  552208
  552243
  559083
  562317
  563618
  567387
  567738
  568355
  571643
  573792
  575070
  586542
  590989
  592071
  593171
  595375
  597535
  605335
  612173
  624228
  630289
  634045
  649536
  652949
  654332
  654465
  664245
  665658
  671301
  671736
  671914
  672485
  672492
  675801
  676498
  676914
  677343
  678554
  678981
  679084
  679107
  679130
  679388
  679698
  680096
  684052
  688560
  690012
  692013
  704842
  706754
  712959
  715920
  716559
  716871
  719171
  721412
  722214
  722684
  722705
  722816
  722839
  725171
  727770
  729035
  730852
  742928
  742931
  743197
  746478
  748322
  748738
  753473
  753477
  754260
  755178
  759543
  760586
  760963
  767327
  769750
  769755
  769829
  772110
  779135
  785770
  786334
  787953
  793892
  802627
  810812
  811832
  812115
  821091
]
2.05 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen kissing"
]
1.98 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen kissing"
]
1.73 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen kissing"
]

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.