GET https://search.jues.net/search/embeds/6?q=cumshot%20huge

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.74 ms
(82.35%)
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
  395375
  409667
  418067
  420615
  421704
  424332
  424377
  424397
  425904
  427261
  427311
  428719
  433904
  434420
  437839
  443092
  444313
  446019
  446989
  448300
  450441
  455351
  458981
  458984
  461673
  464994
  475404
  475780
  477809
  487547
  489812
  493019
  493402
  493471
  495361
  496033
  496793
  498346
  498790
  499178
  499395
  501707
  502208
  505392
  506358
  507291
  508425
  508521
  509332
  509557
  510505
  511079
  512351
  512734
  514129
  514268
  514443
  517143
  517572
  517575
  522626
  523065
  523828
  524587
  524867
  526799
  531107
  531144
  539662
  540794
  551886
  555728
  556797
  558568
  558814
  560272
  560791
  561296
  568655
  575531
  577468
  577903
  579935
  579940
  579958
  582697
  582802
  583257
  589173
  593279
  597144
  598266
  598420
  598667
  601604
  602698
  603376
  603641
  604338
  605151
  605703
  620244
  625441
  631504
  677917
  707740
  724637
  759135
  774799
  786815
  803596
]
15.46 ms
(10.29%)
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
  458981
  524867
  539662
  517143
  493471
  582802
  558814
  583257
  555728
  558568
  575531
  560791
  577468
  579940
  579958
  601604
  593279
  597144
  598266
  604338
  589173
  774799
  759135
  786815
  724637
  602698
  803596
  425904
  443092
  420615
  433904
  434420
  448300
  446989
  475780
  489812
  498346
  509557
  526799
  487547
  493019
  499395
  508521
  512351
  517572
  509332
  514268
  395375
  421704
  424397
  428719
  437839
  464994
  458984
  461673
  506358
  527940
  498790
  495361
  501707
  551886
  568655
  707740
  677917
  579935
  605703
  620244
  598667
  475404
  477809
  446019
  502208
  511079
  514443
  522626
  512734
  496793
  424332
  455351
  517575
  499178
  531107
  560272
  577903
  582697
  598420
  427311
  424377
  493402
  524587
  540794
  507291
  523065
  427261
  450441
  531144
  508425
  561296
  603641
  418067
  510505
  409667
  444313
  505392
  514129
  523828
  556797
  631504
  625441
  603376
  605151
  496033
]
3.16 ms
(2.10%)
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
  395375
  409667
  418067
  420615
  421704
  424332
  424377
  424397
  425904
  427261
  427311
  428719
  433904
  434420
  437839
  443092
  444313
  446019
  446989
  448300
  450441
  455351
  458981
  458984
  461673
  464994
  475404
  475780
  477809
  487547
  489812
  493019
  493402
  493471
  495361
  496033
  496793
  498346
  498790
  499178
  499395
  501707
  502208
  505392
  506358
  507291
  508425
  508521
  509332
  509557
  510505
  511079
  512351
  512734
  514129
  514268
  514443
  517143
  517572
  517575
  522626
  523065
  523828
  524587
  524867
  526799
  531107
  531144
  539662
  540794
  551886
  555728
  556797
  558568
  558814
  560272
  560791
  561296
  568655
  575531
  577468
  577903
  579935
  579940
  579958
  582697
  582802
  583257
  589173
  593279
  597144
  598266
  598420
  598667
  601604
  602698
  603376
  603641
  604338
  605151
  605703
  620244
  625441
  631504
  677917
  707740
  724637
  759135
  774799
  786815
  803596
]
2.26 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.25 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot huge"
]
1.81 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot огромные"
]
1.60 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot огромные"
]

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.