GET https://search.jues.net/search/embeds/5?q=short%20hair%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.96 ms
(52.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
165.82 ms
(41.69%)
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
  2208
  233049
  346210
  366011
  388203
  391473
  391952
  397878
  423766
  424072
  424181
  426694
  433364
  438025
  439926
  443360
  448671
  451500
  453595
  453629
  460901
  461471
  461773
  461971
  462001
  462156
  462182
  464553
  469216
  469896
  469906
  469912
  470922
  470932
  471110
  472605
  473315
  473965
  475095
  475880
  477936
  478765
  479127
  480557
  484447
  485376
  492991
  494195
  494667
  496705
  502523
  506435
  506691
  516668
  518561
  519300
  522450
  523593
  528279
  533756
  543818
  546135
  551878
  560397
  564038
  572899
  576040
  595480
  616711
  622823
  623493
  644881
  650502
  654431
  654670
  654717
  656042
  658403
  660251
  662432
  686494
  700957
  711037
  714470
  716841
  721413
  721471
  742387
  742402
  749907
  778575
  819760
  820280
  824453
  825319
  825322
  825325
  825327
  825355
  825392
  825394
  825432
  825849
  826305
  826377
  826588
  826590
  826683
  826684
  826829
  826832
  827139
  827140
  827144
  827597
  827616
  827655
  827692
  827705
  827722
]
13.71 ms
(3.45%)
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
  516668
  492991
  616711
  438025
  472605
  485376
  462001
  564038
  560397
  622823
  391473
  460901
  473315
  477936
  388203
  397878
  448671
  473965
  424181
  461471
  469912
  471110
  424072
  461773
  475095
  480557
  451500
  494195
  506435
  496705
  506691
  572899
  439926
  528279
  522450
  426694
  469216
  346210
  469906
  502523
  484447
  433364
  479127
  462156
  461971
  464553
  576040
  714470
  721471
  595480
  778575
  749907
  742402
  742387
  623493
  711037
  716841
  470922
  475880
  233049
  391952
  443360
  478765
  2208
  423766
  453629
  366011
  469896
  453595
  470932
  518561
  519300
  523593
  819760
  825394
  644881
  825325
  826684
  826683
  826590
  820280
  824453
  825319
  825322
  826829
  826832
  827139
  827140
  827144
  827597
  827616
  827722
  827705
  827692
  825392
  826305
  825327
  825355
  825432
  825849
  826377
  826588
  827655
  462182
  533756
  494667
  543818
  551878
  546135
  650502
  656042
  660251
  662432
  686494
  700957
  721413
  654431
  654670
  654717
  658403
]
3.29 ms
(0.83%)
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
  2208
  233049
  346210
  366011
  388203
  391473
  391952
  397878
  423766
  424072
  424181
  426694
  433364
  438025
  439926
  443360
  448671
  451500
  453595
  453629
  460901
  461471
  461773
  461971
  462001
  462156
  462182
  464553
  469216
  469896
  469906
  469912
  470922
  470932
  471110
  472605
  473315
  473965
  475095
  475880
  477936
  478765
  479127
  480557
  484447
  485376
  492991
  494195
  494667
  496705
  502523
  506435
  506691
  516668
  518561
  519300
  522450
  523593
  528279
  533756
  543818
  546135
  551878
  560397
  564038
  572899
  576040
  595480
  616711
  622823
  623493
  644881
  650502
  654431
  654670
  654717
  656042
  658403
  660251
  662432
  686494
  700957
  711037
  714470
  716841
  721413
  721471
  742387
  742402
  749907
  778575
  819760
  820280
  824453
  825319
  825322
  825325
  825327
  825355
  825392
  825394
  825432
  825849
  826305
  826377
  826588
  826590
  826683
  826684
  826829
  826832
  827139
  827140
  827144
  827597
  827616
  827655
  827692
  827705
  827722
]
1.75 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short hair russian"
]
1.67 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short hair русск"
]
1.53 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short hair русск"
]

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.