GET https://search.jues.net/search/embeds/2?q=beauty%20get%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.83 ms
(79.80%)
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
  218026
  386156
  386796
  397481
  404809
  413818
  413960
  415874
  417045
  419872
  428978
  431446
  435959
  446337
  446531
  448038
  457143
  467597
  473900
  475099
  475414
  477743
  481151
  483555
  484230
  487726
  488023
  489120
  490097
  491256
  491510
  496269
  503802
  504906
  507690
  508870
  510371
  512514
  515896
  516686
  519497
  521575
  524628
  527412
  529089
  530637
  531235
  531263
  533471
  533833
  536675
  537661
  537685
  540217
  542070
  542923
  546720
  551245
  561980
  569258
  574184
  574576
  576689
  576980
  590866
  598447
  598510
  599677
  600026
  600293
  601585
  603102
  615832
  617423
  621410
  623011
  635106
  635188
  638967
  644379
  646007
  648252
  648868
  650188
  650476
  653459
  676623
  677307
  678522
  679029
  681014
  683424
  705160
  707368
  714549
  746499
  750325
  750725
  755101
  755416
  788576
  790019
  792555
  795593
  799743
  800293
  805554
  805779
  807907
]
17.81 ms
(12.27%)
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
  644379
  615832
  599677
  800293
  750325
  536675
  413960
  705160
  598447
  714549
  477743
  446531
  386156
  475099
  542070
  457143
  504906
  473900
  648252
  635188
  519497
  475414
  537685
  481151
  551245
  417045
  218026
  413818
  487726
  533833
  574576
  707368
  799743
  805554
  788576
  805779
  807907
  792555
  750725
  542923
  404809
  386796
  755416
  576980
  490097
  488023
  569258
  512514
  531235
  650188
  648868
  529089
  415874
  503802
  508870
  600293
  601585
  790019
  491510
  507690
  574184
  435959
  428978
  467597
  527412
  683424
  795593
  576689
  621410
  598510
  446337
  531263
  650476
  489120
  491256
  561980
  646007
  679029
  681014
  755101
  540217
  533471
  676623
  600026
  496269
  537661
  419872
  515896
  516686
  623011
  431446
  653459
  635106
  617423
  483555
  677307
  678522
  746499
  524628
  603102
  638967
  546720
  484230
  530637
  590866
  397481
  448038
  510371
  521575
]
3.49 ms
(2.41%)
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
  218026
  386156
  386796
  397481
  404809
  413818
  413960
  415874
  417045
  419872
  428978
  431446
  435959
  446337
  446531
  448038
  457143
  467597
  473900
  475099
  475414
  477743
  481151
  483555
  484230
  487726
  488023
  489120
  490097
  491256
  491510
  496269
  503802
  504906
  507690
  508870
  510371
  512514
  515896
  516686
  519497
  521575
  524628
  527412
  529089
  530637
  531235
  531263
  533471
  533833
  536675
  537661
  537685
  540217
  542070
  542923
  546720
  551245
  561980
  569258
  574184
  574576
  576689
  576980
  590866
  598447
  598510
  599677
  600026
  600293
  601585
  603102
  615832
  617423
  621410
  623011
  635106
  635188
  638967
  644379
  646007
  648252
  648868
  650188
  650476
  653459
  676623
  677307
  678522
  679029
  681014
  683424
  705160
  707368
  714549
  746499
  750325
  750725
  755101
  755416
  788576
  790019
  792555
  795593
  799743
  800293
  805554
  805779
  807907
]
2.32 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty get anal"
]
2.03 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty get анал"
]
1.86 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty get анал"
]

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.