GET https://search.jues.net/search/embeds/4?q=milf%20bdsm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.59 ms
(83.53%)
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
  6806
  6997
  108127
  108221
  382421
  391044
  433668
  441838
  444641
  448666
  456426
  460961
  481920
  488337
  490267
  495067
  500311
  501348
  504060
  506238
  520933
  521567
  521693
  523189
  526536
  529829
  530523
  531114
  532047
  532485
  532508
  533692
  534209
  536684
  537256
  538035
  543094
  543250
  543738
  543855
  547861
  549404
  549413
  549960
  557435
  559177
  564791
  569699
  569709
  569722
  569746
  570927
  579876
  583823
  590713
  599595
  600809
  603269
  623656
  634616
  640531
  667338
  681074
  683012
  685305
  714228
  716904
  719025
  719537
  720286
  729907
  732611
  737590
  738487
  739858
  741234
  742538
  742693
  742697
  743752
  746352
  746917
  754462
  754750
  755076
  757455
  758996
  768515
  771345
  773877
  784721
  788508
  790487
  796202
  796748
  798835
  801214
  801826
  804943
  805306
  810334
  810604
  810816
  812727
  815031
  815701
  816482
  816498
  817069
  817133
  817149
  817153
  817159
  817175
  817284
  817736
  817757
  818605
  826809
  827073
]
14.52 ms
(9.50%)
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
  817069
  817153
  817133
  826809
  460961
  534209
  549960
  559177
  569746
  549404
  564791
  685305
  667338
  599595
  801826
  812727
  798835
  729907
  746352
  784721
  741234
  746917
  755076
  771345
  754750
  743752
  754462
  773877
  790487
  801214
  433668
  382421
  441838
  817284
  815031
  488337
  495067
  520933
  500311
  569722
  570927
  549413
  590713
  796202
  757455
  481920
  532508
  501348
  603269
  719537
  683012
  742693
  742697
  788508
  6806
  391044
  108127
  108221
  6997
  444641
  815701
  817757
  816498
  817175
  817736
  827073
  816482
  818605
  817149
  817159
  456426
  532485
  537256
  529829
  532047
  506238
  533692
  538035
  521567
  521693
  543250
  569709
  583823
  543094
  557435
  543738
  547861
  569699
  720286
  716904
  714228
  600809
  634616
  810816
  737590
  758996
  796748
  804943
  810604
  732611
  768515
  742538
  805306
  810334
  536684
  526536
  523189
  531114
  543855
  579876
  640531
  448666
  490267
  504060
  530523
  719025
  681074
  623656
  738487
  739858
]
2.77 ms
(1.81%)
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
  6806
  6997
  108127
  108221
  382421
  391044
  433668
  441838
  444641
  448666
  456426
  460961
  481920
  488337
  490267
  495067
  500311
  501348
  504060
  506238
  520933
  521567
  521693
  523189
  526536
  529829
  530523
  531114
  532047
  532485
  532508
  533692
  534209
  536684
  537256
  538035
  543094
  543250
  543738
  543855
  547861
  549404
  549413
  549960
  557435
  559177
  564791
  569699
  569709
  569722
  569746
  570927
  579876
  583823
  590713
  599595
  600809
  603269
  623656
  634616
  640531
  667338
  681074
  683012
  685305
  714228
  716904
  719025
  719537
  720286
  729907
  732611
  737590
  738487
  739858
  741234
  742538
  742693
  742697
  743752
  746352
  746917
  754462
  754750
  755076
  757455
  758996
  768515
  771345
  773877
  784721
  788508
  790487
  796202
  796748
  798835
  801214
  801826
  804943
  805306
  810334
  810604
  810816
  812727
  815031
  815701
  816482
  816498
  817069
  817133
  817149
  817153
  817159
  817175
  817284
  817736
  817757
  818605
  826809
  827073
]
2.29 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf bdsm"
]
1.94 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf бдсм"
]
1.73 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf бдсм"
]

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.