GET https://search.jues.net/search/embeds/6?q=anal%20ass%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.01 ms
(56.56%)
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
  69513
  338371
  378309
  393087
  393677
  396397
  396412
  396563
  396574
  396706
  396709
  397330
  401666
  402243
  412991
  418864
  422335
  448215
  452872
  457329
  464214
  464347
  467109
  467120
  469581
  472647
  478498
  483561
  489953
  491271
  493657
  521579
  524755
  530629
  530849
  531155
  531279
  531298
  531556
  532245
  532913
  533007
  533384
  534226
  534277
  536366
  537203
  537654
  537941
  541202
  541668
  542590
  543852
  543918
  556043
  558436
  558437
  559162
  566035
  567343
  570175
  572189
  577313
  589551
  592255
  600415
  607814
  611261
  613122
  623290
  624190
  630526
  630550
  631984
  632261
  632690
  633792
  633796
  634115
  634528
  636032
  637567
  645284
  646901
  647830
  647879
  650474
  651647
  656117
  656321
  673971
  676023
  678053
  678128
  712770
  713052
  714663
  716189
  716288
  720357
  721870
  725596
  725636
  728368
  728738
  732262
  732271
  732346
  737847
  739947
  749341
  761086
  765355
  793075
  805438
  806225
  817044
  817065
  817786
  827874
]
141.15 ms
(37.65%)
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
  69513
  338371
  378309
  393087
  393677
  396397
  396412
  396563
  396574
  396706
  396709
  397330
  401666
  402243
  412991
  418864
  422335
  448215
  452872
  457329
  464214
  464347
  467109
  467120
  469581
  472647
  478498
  483561
  489953
  491271
  493657
  521579
  524755
  530629
  530849
  531155
  531279
  531298
  531556
  532245
  532913
  533007
  533384
  534226
  534277
  536366
  537203
  537654
  537941
  541202
  541668
  542590
  543852
  543918
  556043
  558436
  558437
  559162
  566035
  567343
  570175
  572189
  577313
  589551
  592255
  600415
  607814
  611261
  613122
  623290
  624190
  630526
  630550
  631984
  632261
  632690
  633792
  633796
  634115
  634528
  636032
  637567
  645284
  646901
  647830
  647879
  650474
  651647
  656117
  656321
  673971
  676023
  678053
  678128
  712770
  713052
  714663
  716189
  716288
  720357
  721870
  725596
  725636
  728368
  728738
  732262
  732271
  732346
  737847
  739947
  749341
  761086
  765355
  793075
  805438
  806225
  817044
  817065
  817786
  827874
]
15.40 ms
(4.11%)
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
  713052
  636032
  765355
  739947
  634528
  448215
  558436
  542590
  572189
  338371
  600415
  714663
  607814
  531155
  630526
  716189
  728368
  732346
  396412
  632261
  678053
  631984
  827874
  646901
  378309
  532913
  537203
  541202
  678128
  632690
  633796
  532245
  645284
  651647
  393087
  536366
  673971
  728738
  402243
  530629
  806225
  533007
  676023
  633792
  521579
  566035
  647830
  412991
  422335
  464347
  577313
  613122
  491271
  611261
  397330
  725596
  489953
  531279
  534226
  656117
  624190
  396709
  817044
  817786
  720357
  556043
  650474
  637567
  793075
  721870
  543918
  817065
  467120
  478498
  531298
  537941
  716288
  725636
  732271
  396563
  396574
  541668
  592255
  483561
  749341
  630550
  530849
  534277
  712770
  623290
  737847
  393677
  656321
  589551
  732262
  634115
  537654
  543852
  559162
  567343
  558437
  647879
  533384
  69513
  396706
  418864
  457329
  467109
  452872
  524755
  531556
  805438
  761086
  396397
  401666
  472647
  493657
  469581
  464214
  570175
]
1.83 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal ass bbc"
]
1.54 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал жоп bbc"
]
1.48 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал жоп bbc"
]

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.