GET https://search.jues.net/search/embeds/9?q=amateur%20screaming

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.82 ms
(85.32%)
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
  397396
  417841
  420534
  420853
  422074
  426101
  429715
  432690
  432732
  441430
  441511
  441519
  441848
  445340
  447007
  452636
  453690
  454145
  454534
  454926
  457531
  461139
  461778
  462757
  463810
  464155
  464578
  464811
  464837
  465267
  470425
  471300
  472692
  473222
  473476
  478712
  478833
  480714
  482769
  482925
  486204
  487382
  488337
  488948
  490171
  490250
  490477
  490518
  492495
  493172
  494648
  495364
  495607
  496149
  496616
  500884
  500938
  500955
  503271
  503644
  510990
  511348
  512506
  513508
  513552
  514024
  520790
  522053
  522216
  526402
  526466
  529082
  529616
  533948
  534801
  534848
  535431
  539889
  541629
  542161
  546752
  547865
  548907
  549697
  551903
  554552
  556445
  560844
  561988
  563082
  574643
  576516
  589278
  592956
  593787
  595549
  602553
  608725
  615903
  623388
  623968
  628614
  642723
  665923
  671396
  680422
  708276
  720132
  735195
  750668
  751432
  761481
  761496
  787556
  793472
  794135
  796168
  801259
  803148
]
18.63 ms
(8.74%)
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
  750668
  751432
  720132
  787556
  441430
  457531
  441511
  441848
  426101
  482769
  488337
  520790
  534801
  534848
  503271
  529082
  494648
  464578
  560844
  574643
  708276
  602781
  623968
  796168
  803148
  793472
  761481
  761496
  397396
  452636
  461778
  461139
  500938
  500955
  495364
  513508
  500884
  522216
  526402
  487382
  490477
  512506
  680422
  554552
  539889
  542161
  546752
  593787
  595549
  589278
  602553
  623388
  608725
  490250
  490518
  522053
  671396
  432732
  488948
  492495
  561988
  576516
  592956
  801259
  453690
  417841
  420534
  447007
  463810
  454145
  473476
  490171
  511348
  510990
  529616
  549697
  547865
  665923
  551903
  556445
  628614
  642723
  794135
  735195
  462757
  473222
  471300
  429715
  464811
  482925
  503644
  514024
  533948
  495607
  441519
  432690
  445340
  465267
  486204
  454926
  478833
  526466
  496616
  535431
  464837
  480714
  548907
  563082
  541629
  615903
  472692
  420853
  478712
  464155
  470425
  513552
  496149
  493172
  422074
  454534
]
4.27 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
  397396
  417841
  420534
  420853
  422074
  426101
  429715
  432690
  432732
  441430
  441511
  441519
  441848
  445340
  447007
  452636
  453690
  454145
  454534
  454926
  457531
  461139
  461778
  462757
  463810
  464155
  464578
  464811
  464837
  465267
  470425
  471300
  472692
  473222
  473476
  478712
  478833
  480714
  482769
  482925
  486204
  487382
  488337
  488948
  490171
  490250
  490477
  490518
  492495
  493172
  494648
  495364
  495607
  496149
  496616
  500884
  500938
  500955
  503271
  503644
  510990
  511348
  512506
  513508
  513552
  514024
  520790
  522053
  522216
  526402
  526466
  529082
  529616
  533948
  534801
  534848
  535431
  539889
  541629
  542161
  546752
  547865
  548907
  549697
  551903
  554552
  556445
  560844
  561988
  563082
  574643
  576516
  589278
  592956
  593787
  595549
  602553
  608725
  615903
  623388
  623968
  628614
  642723
  665923
  671396
  680422
  708276
  720132
  735195
  750668
  751432
  761481
  761496
  787556
  793472
  794135
  796168
  801259
  803148
]
2.40 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur screaming"
]
2.17 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.15 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск крича вперв"
]
1.67 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.