GET https://search.jues.net/search/embeds/4?q=white%20fuck%20black

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.06 ms
(80.61%)
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
  30783
  384524
  384542
  385784
  390024
  390098
  390413
  401321
  404829
  411227
  411477
  411807
  415097
  419751
  420305
  423633
  423981
  427897
  429764
  430168
  430535
  435497
  438638
  441237
  442979
  445345
  446331
  447124
  447855
  448692
  449868
  454925
  458916
  459085
  461059
  461747
  464451
  465012
  466616
  466968
  468213
  472914
  472951
  473216
  474852
  475698
  477358
  478033
  479472
  480636
  481602
  483118
  484811
  486403
  491204
  492126
  495014
  496302
  496318
  496527
  499174
  500669
  502562
  503828
  504876
  506496
  506667
  508856
  509543
  511777
  512613
  513290
  515843
  516021
  517204
  517330
  518181
  518405
  518733
  520730
  522284
  522903
  523091
  524440
  525303
  526073
  527750
  528035
  528815
  528921
  532441
  533063
  533799
  534166
  537833
  548580
  555807
  565102
  565277
  576698
  576721
  577377
  584212
  591582
  595764
  596436
  603724
  604595
  631908
  632927
  675144
  675431
  675660
  675696
  729911
  755030
  810822
  810832
  825039
]
21.46 ms
(12.81%)
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
  385784
  30783
  825039
  548580
  631908
  446331
  459085
  404829
  504876
  415097
  486403
  518181
  584212
  604595
  411807
  442979
  499174
  430535
  441237
  411477
  472914
  438638
  472951
  492126
  430168
  465012
  448692
  461747
  474852
  555807
  675660
  591582
  513290
  496302
  528035
  491204
  390098
  503828
  518405
  528815
  506667
  468213
  675144
  755030
  475698
  518733
  502562
  523091
  509543
  496318
  423981
  528921
  515843
  401321
  390024
  537833
  810822
  729911
  517330
  466968
  595764
  458916
  447124
  522903
  435497
  576698
  481602
  478033
  526073
  449868
  483118
  596436
  632927
  384542
  461059
  525303
  516021
  500669
  427897
  447855
  576721
  675431
  484811
  513476
  524440
  511777
  527750
  464451
  675696
  577377
  466616
  522284
  423633
  454925
  534166
  532441
  533799
  496527
  520730
  480636
  420305
  477358
  508856
  565277
  479472
  390413
  512613
  495014
  384524
  603724
  810832
  506496
  517204
  419751
  429764
  533063
  473216
  565102
  445345
  411227
]
3.41 ms
(2.04%)
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
  30783
  384524
  384542
  385784
  390024
  390098
  390413
  401321
  404829
  411227
  411477
  411807
  415097
  419751
  420305
  423633
  423981
  427897
  429764
  430168
  430535
  435497
  438638
  441237
  442979
  445345
  446331
  447124
  447855
  448692
  449868
  454925
  458916
  459085
  461059
  461747
  464451
  465012
  466616
  466968
  468213
  472914
  472951
  473216
  474852
  475698
  477358
  478033
  479472
  480636
  481602
  483118
  484811
  486403
  491204
  492126
  495014
  496302
  496318
  496527
  499174
  500669
  502562
  503828
  504876
  506496
  506667
  508856
  509543
  511777
  512613
  513290
  515843
  516021
  517204
  517330
  518181
  518405
  518733
  520730
  522284
  522903
  523091
  524440
  525303
  526073
  527750
  528035
  528815
  528921
  532441
  533063
  533799
  534166
  537833
  548580
  555807
  565102
  565277
  576698
  576721
  577377
  584212
  591582
  595764
  596436
  603724
  604595
  631908
  632927
  675144
  675431
  675660
  675696
  729911
  755030
  810822
  810832
  825039
]
2.33 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white fuck black"
]
1.86 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white секс black"
]
1.72 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white секс black"
]
1.72 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.