GET https://search.jues.net/search/embeds/8?q=amateur%20deep

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.93 ms
(84.85%)
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
  398274
  400881
  404112
  418689
  437767
  441453
  441517
  441583
  449297
  449310
  456077
  462578
  467057
  468408
  478101
  508197
  524954
  527956
  529605
  531839
  531887
  532369
  534555
  536439
  537474
  541509
  554934
  555820
  575954
  575993
  578761
  583276
  603391
  615295
  635752
  639357
  641318
  663224
  695906
  697249
  708389
  717162
  722377
  724059
  724109
  725747
  727859
  734414
  735517
  737458
  739389
  739624
  740876
  741828
  742560
  743490
  743615
  745795
  745959
  752712
  752732
  754070
  757538
  761199
  761594
  761758
  762041
  763032
  763460
  764693
  765756
  766288
  767052
  767630
  768297
  769161
  769423
  769896
  772927
  773737
  776968
  777315
  778082
  778659
  778734
  779563
  783271
  783744
  785004
  786051
  786421
  786496
  788476
  789436
  790399
  790502
  792175
  792335
  793765
  794370
  794717
  794900
  797210
  801263
  801802
  802295
  804526
  804565
  805053
  807304
  809751
  810579
  810602
  813467
  813953
  814521
  816167
  817708
  819947
  825758
]
14.71 ms
(8.98%)
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
  615295
  641318
  462578
  404112
  441453
  813953
  814521
  816167
  819947
  467057
  532369
  534555
  537474
  508197
  468408
  541509
  575954
  555820
  790399
  793765
  801802
  804526
  777315
  779563
  783744
  788476
  790502
  794370
  802295
  734414
  752732
  794717
  794900
  797210
  807304
  809751
  810579
  727859
  767630
  741828
  742560
  745795
  762041
  763460
  767052
  725747
  743615
  765756
  766288
  769423
  769896
  778659
  778734
  786421
  786496
  789436
  792335
  801263
  804565
  805053
  437767
  398274
  400881
  536439
  697249
  663224
  695906
  708389
  639357
  813467
  441517
  817708
  418689
  441583
  825758
  456077
  449297
  449310
  478101
  527956
  524954
  531887
  529605
  531839
  554934
  575993
  578761
  583276
  717162
  722377
  635752
  603391
  776968
  778082
  783271
  792175
  785004
  724109
  735517
  737458
  739624
  743490
  745959
  754070
  761199
  761594
  761758
  763032
  786051
  810602
  740876
  752712
  757538
  764693
  768297
  769161
  772927
  773737
  724059
  739389
]
2.54 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
  398274
  400881
  404112
  418689
  437767
  441453
  441517
  441583
  449297
  449310
  456077
  462578
  467057
  468408
  478101
  508197
  524954
  527956
  529605
  531839
  531887
  532369
  534555
  536439
  537474
  541509
  554934
  555820
  575954
  575993
  578761
  583276
  603391
  615295
  635752
  639357
  641318
  663224
  695906
  697249
  708389
  717162
  722377
  724059
  724109
  725747
  727859
  734414
  735517
  737458
  739389
  739624
  740876
  741828
  742560
  743490
  743615
  745795
  745959
  752712
  752732
  754070
  757538
  761199
  761594
  761758
  762041
  763032
  763460
  764693
  765756
  766288
  767052
  767630
  768297
  769161
  769423
  769896
  772927
  773737
  776968
  777315
  778082
  778659
  778734
  779563
  783271
  783744
  785004
  786051
  786421
  786496
  788476
  789436
  790399
  790502
  792175
  792335
  793765
  794370
  794717
  794900
  797210
  801263
  801802
  802295
  804526
  804565
  805053
  807304
  809751
  810579
  810602
  813467
  813953
  814521
  816167
  817708
  819947
  825758
]
2.02 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur deep"
]
1.88 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск deep"
]
1.85 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск deep"
]
1.82 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.