GET https://search.jues.net/search/embeds/4?q=blonde%20bondage

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.44 ms
(83.04%)
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
  385923
  395756
  404904
  410640
  411849
  417084
  419378
  419847
  421249
  421326
  422402
  423635
  423743
  425977
  428192
  429559
  429568
  430416
  431133
  436452
  441195
  443981
  444676
  445414
  446054
  446090
  446460
  447132
  448052
  448064
  448068
  448887
  451804
  458379
  461624
  463757
  466861
  467493
  468462
  468856
  470416
  470527
  473967
  475454
  475634
  475927
  476028
  476176
  476721
  476957
  477131
  477185
  477867
  479694
  481285
  481359
  481792
  482541
  482788
  483382
  483627
  484471
  485319
  486694
  486763
  487907
  489973
  490684
  491266
  495282
  495629
  496086
  497005
  504652
  505132
  506536
  508198
  509024
  510254
  510501
  510710
  512397
  513948
  514152
  514824
  515122
  515378
  515750
  516685
  517144
  517196
  517367
  519002
  519108
  522072
  522101
  522499
  523291
  523608
  524628
  525159
  526827
  527645
  530637
  533186
  537912
  543858
  550315
  554256
  554272
  555114
  558248
  568482
  569742
  579546
  695184
  775186
  785384
  815648
  827610
]
16.16 ms
(10.36%)
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
  410640
  421249
  429568
  419847
  444676
  485319
  466861
  448064
  489973
  497005
  515750
  537912
  569742
  775186
  475454
  476721
  477131
  429559
  423743
  448052
  448068
  468462
  446090
  513948
  490684
  522499
  495282
  506536
  517367
  519002
  484471
  487907
  523608
  525159
  514824
  505132
  543858
  550315
  510254
  785384
  447132
  554272
  463757
  423635
  443981
  417084
  422402
  827610
  448887
  473967
  481792
  527645
  533186
  558248
  554256
  436452
  476176
  479694
  395756
  421326
  468856
  481285
  446460
  514152
  516685
  483382
  495629
  504652
  510710
  512397
  515122
  524628
  483627
  404904
  430416
  441195
  411849
  445414
  815648
  482541
  482788
  458379
  477185
  509024
  515378
  517196
  486694
  695184
  419378
  428192
  481359
  425977
  431133
  461624
  470416
  476028
  475634
  486763
  491266
  510501
  517144
  522072
  523291
  526827
  385923
  530637
  477867
  446054
  519108
  496086
  522101
  555114
  568482
  579546
  451804
  476957
  467493
  475927
  470527
  508198
]
2.66 ms
(1.71%)
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
  385923
  395756
  404904
  410640
  411849
  417084
  419378
  419847
  421249
  421326
  422402
  423635
  423743
  425977
  428192
  429559
  429568
  430416
  431133
  436452
  441195
  443981
  444676
  445414
  446054
  446090
  446460
  447132
  448052
  448064
  448068
  448887
  451804
  458379
  461624
  463757
  466861
  467493
  468462
  468856
  470416
  470527
  473967
  475454
  475634
  475927
  476028
  476176
  476721
  476957
  477131
  477185
  477867
  479694
  481285
  481359
  481792
  482541
  482788
  483382
  483627
  484471
  485319
  486694
  486763
  487907
  489973
  490684
  491266
  495282
  495629
  496086
  497005
  504652
  505132
  506536
  508198
  509024
  510254
  510501
  510710
  512397
  513948
  514152
  514824
  515122
  515378
  515750
  516685
  517144
  517196
  517367
  519002
  519108
  522072
  522101
  522499
  523291
  523608
  524628
  525159
  526827
  527645
  530637
  533186
  537912
  543858
  550315
  554256
  554272
  555114
  558248
  568482
  569742
  579546
  695184
  775186
  785384
  815648
  827610
]
2.10 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.04 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde bondage"
]
1.84 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая бдсм"
]
1.64 ms
(1.05%)
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.