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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.32 ms
(57.86%)
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
  425415
  441409
  441472
  441829
  443541
  452553
  468676
  473825
  485234
  494316
  506283
  507789
  528346
  533672
  537283
  542340
  549126
  567946
  576865
  579494
  580606
  582096
  583086
  584074
  584191
  590839
  593779
  604178
  615058
  615829
  618055
  634735
  639377
  642563
  644149
  652276
  655239
  656489
  661678
  664712
  665631
  667167
  668387
  675638
  681709
  685074
  685097
  693857
  693918
  710033
  710393
  711278
  713159
  714427
  715028
  717070
  719370
  719916
  720052
  722148
  722268
  722372
  722445
  724519
  726135
  726888
  730392
  732710
  732988
  734966
  734970
  735591
  736348
  743654
  743732
  744365
  745227
  745878
  748481
  750156
  750854
  756354
  757795
  758593
  758824
  759603
  762809
  764911
  765060
  766863
  771912
  773419
  773424
  775043
  775119
  775382
  778198
  779730
  781327
  785296
  789774
  790039
  793872
  794936
  796921
  797093
  798033
  802207
  813748
  817246
  817470
  818097
  823645
  823839
  823947
  825028
  825227
  825534
  825732
]
134.23 ms
(36.41%)
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
  425415
  441409
  441472
  441829
  443541
  452553
  468676
  473825
  485234
  494316
  506283
  507789
  528346
  533672
  537283
  542340
  549126
  567946
  576865
  579494
  580606
  582096
  583086
  584074
  584191
  590839
  593779
  604178
  615058
  615829
  618055
  634735
  639377
  642563
  644149
  652276
  655239
  656489
  661678
  664712
  665631
  667167
  668387
  675638
  681709
  685074
  685097
  693857
  693918
  710033
  710393
  711278
  713159
  714427
  715028
  717070
  719370
  719916
  720052
  722148
  722268
  722372
  722445
  724519
  726135
  726888
  730392
  732710
  732988
  734966
  734970
  735591
  736348
  743654
  743732
  744365
  745227
  745878
  748481
  750156
  750854
  756354
  757795
  758593
  758824
  759603
  762809
  764911
  765060
  766863
  771912
  773419
  773424
  775043
  775119
  775382
  778198
  779730
  781327
  785296
  789774
  790039
  793872
  794936
  796921
  797093
  798033
  802207
  813748
  817246
  817470
  818097
  823645
  823839
  823947
  825028
  825227
  825534
  825732
]
13.84 ms
(3.75%)
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
  507789
  665631
  732710
  615829
  452553
  825732
  722372
  773419
  818097
  825709
  722445
  506283
  710033
  817470
  825227
  726135
  825534
  473825
  576865
  590839
  567946
  656489
  655239
  693918
  714427
  715028
  744365
  745878
  710393
  441829
  823947
  825028
  722268
  735591
  764911
  775119
  528346
  593779
  759603
  720052
  675638
  441409
  468676
  549126
  425415
  661678
  685074
  693857
  584191
  604178
  642563
  797093
  732988
  771912
  618055
  681709
  823839
  719370
  793872
  790039
  773424
  743732
  748481
  765060
  441472
  823645
  778198
  796921
  785296
  798033
  789774
  794936
  766863
  734970
  537283
  494316
  533672
  542340
  584074
  583086
  685097
  652276
  664712
  668387
  667167
  582096
  634735
  639377
  644149
  615058
  711278
  443541
  580606
  579494
  713159
  775043
  775382
  779730
  726888
  750854
  734966
  745227
  758824
  730392
  736348
  762809
  724519
  743654
  719916
  485234
  817246
  813748
  717070
  722148
  781327
  750156
  802207
  758593
  757795
  756354
]
2.25 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur screaming"
]
1.79 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск крича вперв"
]
1.60 ms
(0.43%)
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.