GET https://search.jues.net/search/embeds/9?q=cum-in-mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.92 ms
(83.00%)
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
  391808
  393218
  400465
  403434
  417263
  417283
  421932
  422167
  425287
  428764
  429365
  434936
  435799
  436465
  436490
  444212
  445682
  446762
  449344
  450379
  452732
  453603
  453835
  453838
  456507
  457276
  459008
  459411
  461782
  465630
  467799
  469757
  471332
  471960
  475503
  477849
  477853
  482923
  483036
  483278
  484885
  486166
  486751
  489257
  489260
  490498
  493024
  493286
  494013
  495457
  496230
  496627
  497858
  497993
  498723
  499020
  499987
  500008
  500178
  504703
  505304
  505359
  505360
  505864
  506217
  506649
  509084
  509099
  512413
  513561
  513581
  513747
  514573
  516952
  520699
  522124
  522714
  525027
  526810
  533125
  533703
  534463
  534603
  536682
  540422
  541099
  542079
  542104
  544509
  545852
  547539
  552352
  553332
  554219
  557740
  559319
  560793
  563555
  564892
  565086
  578240
  580144
  582380
  645264
  645446
  650060
  664468
  666404
  674340
  679166
  692074
  696225
  702286
  704208
  711565
  712540
  716856
  814556
  817298
  823456
]
17.46 ms
(10.58%)
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
  435799
  436465
  452732
  453603
  467799
  444212
  461782
  475503
  417263
  417283
  421932
  422167
  425287
  429365
  434936
  445682
  469757
  500178
  513747
  482923
  483036
  483278
  493286
  495457
  522124
  493024
  496627
  498723
  499020
  504703
  506217
  506649
  509099
  486166
  486751
  497858
  497993
  500008
  505359
  505864
  520699
  522714
  489260
  578240
  560793
  645446
  716856
  494013
  499987
  489257
  512413
  393218
  391808
  400465
  403434
  428764
  436490
  817298
  814556
  823456
  449344
  453835
  457276
  459008
  465630
  446762
  450379
  453838
  456507
  459411
  471332
  471960
  477849
  477853
  490498
  505360
  534603
  540422
  509084
  534463
  505304
  513561
  513581
  516952
  525027
  533703
  536682
  496230
  514573
  526810
  533125
  484885
  541099
  542079
  542104
  544509
  554219
  559319
  580144
  547539
  553332
  582380
  557740
  563555
  564892
  565086
  650060
  674340
  679166
  702286
  692074
  704208
  645264
  664468
  666404
  696225
  711565
  712540
  545852
  552352
]
2.90 ms
(1.76%)
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
  391808
  393218
  400465
  403434
  417263
  417283
  421932
  422167
  425287
  428764
  429365
  434936
  435799
  436465
  436490
  444212
  445682
  446762
  449344
  450379
  452732
  453603
  453835
  453838
  456507
  457276
  459008
  459411
  461782
  465630
  467799
  469757
  471332
  471960
  475503
  477849
  477853
  482923
  483036
  483278
  484885
  486166
  486751
  489257
  489260
  490498
  493024
  493286
  494013
  495457
  496230
  496627
  497858
  497993
  498723
  499020
  499987
  500008
  500178
  504703
  505304
  505359
  505360
  505864
  506217
  506649
  509084
  509099
  512413
  513561
  513581
  513747
  514573
  516952
  520699
  522124
  522714
  525027
  526810
  533125
  533703
  534463
  534603
  536682
  540422
  541099
  542079
  542104
  544509
  545852
  547539
  552352
  553332
  554219
  557740
  559319
  560793
  563555
  564892
  565086
  578240
  580144
  582380
  645264
  645446
  650060
  664468
  666404
  674340
  679166
  692074
  696225
  702286
  704208
  711565
  712540
  716856
  814556
  817298
  823456
]
2.08 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum-in-mouth"
]
1.82 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum mouth"
]
1.76 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum mouth"
]

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.