GET https://search.jues.net/search/embeds/4?q=brunette%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.15 ms
(82.08%)
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
  6858
  233027
  382212
  384775
  387080
  388687
  389117
  389516
  391908
  393330
  396052
  398714
  398784
  400719
  401295
  401374
  401952
  405242
  409651
  411405
  420015
  422635
  424164
  426672
  427158
  435215
  435528
  435555
  438540
  440217
  444666
  447234
  447503
  448763
  448765
  451579
  459491
  459991
  461414
  461851
  466022
  466030
  466178
  470096
  470192
  470630
  473905
  474918
  475605
  477649
  482834
  483240
  486051
  487133
  489593
  491334
  491542
  494119
  494616
  495719
  501730
  511701
  511873
  513667
  515537
  519657
  520622
  521396
  522241
  522242
  522714
  537963
  547811
  549777
  554983
  558101
  561291
  561709
  563993
  570198
  572141
  572997
  573423
  573675
  574918
  598010
  598688
  626880
  653479
  654784
  655950
  657360
  659168
  663345
  670985
  673126
  675630
  689121
  715377
  720113
  722819
  722923
  728974
  729786
  730269
  731835
  740561
  742818
  743099
  743285
  745744
  754758
  758734
  781481
  788433
  791586
  791764
  792338
  809971
  810766
]
16.33 ms
(11.25%)
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
  474918
  422635
  451579
  511701
  515537
  521396
  486051
  489593
  522714
  424164
  573423
  558101
  598688
  382212
  384775
  396052
  438540
  447234
  459991
  475605
  477649
  387080
  466030
  398784
  401374
  435215
  435555
  233027
  511873
  494616
  520622
  483240
  400719
  655950
  657360
  659168
  663345
  675630
  689121
  715377
  722923
  653479
  654784
  670985
  673126
  626880
  791764
  781481
  788433
  809971
  792338
  810766
  731835
  745744
  754758
  728974
  729786
  758734
  730269
  743099
  740561
  743285
  720113
  722819
  791586
  6858
  427158
  561291
  487133
  519657
  448763
  522241
  411405
  470096
  549777
  388687
  389516
  401295
  447503
  401952
  466178
  448765
  470192
  389117
  466022
  501730
  537963
  494119
  482834
  495719
  522242
  491334
  491542
  435528
  470630
  513667
  554983
  570198
  573675
  563993
  572141
  547811
  561709
  572997
  574918
  598010
  742818
  393330
  426672
  391908
  440217
  444666
  459491
  461414
  461851
  473905
  398714
  405242
  409651
  420015
]
2.90 ms
(2.00%)
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
  6858
  233027
  382212
  384775
  387080
  388687
  389117
  389516
  391908
  393330
  396052
  398714
  398784
  400719
  401295
  401374
  401952
  405242
  409651
  411405
  420015
  422635
  424164
  426672
  427158
  435215
  435528
  435555
  438540
  440217
  444666
  447234
  447503
  448763
  448765
  451579
  459491
  459991
  461414
  461851
  466022
  466030
  466178
  470096
  470192
  470630
  473905
  474918
  475605
  477649
  482834
  483240
  486051
  487133
  489593
  491334
  491542
  494119
  494616
  495719
  501730
  511701
  511873
  513667
  515537
  519657
  520622
  521396
  522241
  522242
  522714
  537963
  547811
  549777
  554983
  558101
  561291
  561709
  563993
  570198
  572141
  572997
  573423
  573675
  574918
  598010
  598688
  626880
  653479
  654784
  655950
  657360
  659168
  663345
  670985
  673126
  675630
  689121
  715377
  720113
  722819
  722923
  728974
  729786
  730269
  731835
  740561
  742818
  743099
  743285
  745744
  754758
  758734
  781481
  788433
  791586
  791764
  792338
  809971
  810766
]
2.16 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette russian"
]
1.59 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая русск"
]
1.58 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.