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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.84 ms
(87.52%)
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
  388032
  391083
  391913
  397397
  402034
  411324
  412578
  438005
  438032
  438044
  438321
  443686
  443955
  444132
  448903
  451547
  454205
  454547
  455889
  459600
  459687
  461088
  462099
  462508
  466079
  466123
  466155
  466496
  469898
  470024
  470503
  470570
  470610
  470701
  470785
  471336
  471572
  471771
  474181
  474257
  474792
  475878
  475968
  476637
  476840
  477933
  479030
  482324
  483373
  485392
  485595
  485821
  485978
  486467
  489225
  495188
  495520
  496506
  498247
  501809
  506039
  509437
  509502
  511873
  513507
  518882
  521661
  523603
  523876
  524703
  528378
  532765
  542936
  543945
  543977
  544531
  545971
  557045
  557998
  558013
  558178
  562312
  563195
  569564
  576120
  581384
  590421
  598502
  600047
  655406
  673454
  683256
  687819
  692288
  716378
  741646
  741714
  742368
  742375
  743893
  770585
  777779
  778613
  781689
  813963
  819961
  820225
  820309
  823552
  824806
  825329
  825359
  825362
  825428
  825429
  826195
  826378
  826682
  826686
  826689
]
16.86 ms
(7.50%)
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
  451547
  562312
  461088
  471771
  778613
  391083
  470570
  485392
  489225
  454547
  466496
  495520
  518882
  557045
  655406
  569564
  411324
  448903
  397397
  459600
  471572
  476637
  476840
  477933
  402034
  438032
  438321
  443955
  444132
  470024
  475878
  412578
  459687
  470610
  470701
  501809
  511873
  483373
  509502
  521661
  485595
  486467
  495188
  498247
  524703
  485821
  523603
  523876
  532765
  471336
  563195
  542936
  543945
  544531
  576120
  581384
  543977
  545971
  557998
  692288
  673454
  683256
  558013
  558178
  590421
  598502
  781689
  777779
  741646
  742368
  770585
  742375
  743893
  741714
  443686
  470785
  474792
  475968
  455889
  462508
  466123
  466155
  388032
  438005
  438044
  462099
  474181
  479030
  482324
  391913
  454205
  469898
  470503
  466079
  474257
  506039
  509437
  528378
  485978
  513507
  496506
  716378
  600047
  687819
  813963
  823552
  824806
  825359
  825428
  825429
  826682
  826378
  826686
  826689
  819961
  820225
  820309
  825329
  825362
  826195
]
3.49 ms
(1.55%)
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
  388032
  391083
  391913
  397397
  402034
  411324
  412578
  438005
  438032
  438044
  438321
  443686
  443955
  444132
  448903
  451547
  454205
  454547
  455889
  459600
  459687
  461088
  462099
  462508
  466079
  466123
  466155
  466496
  469898
  470024
  470503
  470570
  470610
  470701
  470785
  471336
  471572
  471771
  474181
  474257
  474792
  475878
  475968
  476637
  476840
  477933
  479030
  482324
  483373
  485392
  485595
  485821
  485978
  486467
  489225
  495188
  495520
  496506
  498247
  501809
  506039
  509437
  509502
  511873
  513507
  518882
  521661
  523603
  523876
  524703
  528378
  532765
  542936
  543945
  543977
  544531
  545971
  557045
  557998
  558013
  558178
  562312
  563195
  569564
  576120
  581384
  590421
  598502
  600047
  655406
  673454
  683256
  687819
  692288
  716378
  741646
  741714
  742368
  742375
  743893
  770585
  777779
  778613
  781689
  813963
  819961
  820225
  820309
  823552
  824806
  825329
  825359
  825362
  825428
  825429
  826195
  826378
  826682
  826686
  826689
]
2.03 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short hair русск"
]
1.97 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short hair russian"
]
1.81 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.