GET https://search.jues.net/search/embeds/6?q=big%20curvy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.05 ms
(81.45%)
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
  385854
  386700
  387033
  394535
  395549
  396961
  397662
  405116
  411807
  416169
  419664
  421303
  421773
  427135
  430244
  431803
  445492
  445778
  445955
  446920
  448062
  448104
  448145
  450098
  451672
  453648
  454755
  457569
  458985
  459338
  459838
  460157
  460362
  460369
  464308
  464352
  465467
  468545
  468702
  468837
  469618
  478933
  480414
  481386
  487011
  492933
  493470
  500635
  501717
  503565
  503736
  504185
  504812
  505692
  509656
  510107
  510856
  522104
  522628
  523441
  523864
  525503
  531435
  532721
  532993
  533040
  537591
  548859
  553283
  564054
  564367
  567663
  573311
  577037
  577531
  577594
  589349
  593469
  596392
  601928
  603507
  607403
  607509
  607667
  607714
  607716
  608033
  612383
  615971
  618687
  634416
  695173
  701613
  716540
  723986
  734324
  757105
  760182
  760211
  761066
  769502
  782008
  784925
  792812
  793662
  797461
  798872
  799639
  801348
  801941
  808537
  809076
  810226
  810249
  811152
  812749
  814981
  814983
  814986
  815714
]
15.88 ms
(10.96%)
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
  577594
  701613
  615971
  784925
  797461
  808537
  734324
  798872
  811152
  427135
  385854
  504812
  387033
  396961
  405116
  430244
  480414
  459838
  468545
  532993
  537591
  567663
  695173
  573311
  577037
  634416
  596392
  603507
  612383
  601928
  810249
  607403
  419664
  445492
  394535
  450098
  454755
  421303
  814986
  814981
  814983
  468702
  468837
  460157
  493470
  577531
  548859
  564367
  607667
  607714
  607509
  801348
  809076
  799639
  757105
  760211
  782008
  793662
  812749
  760182
  723986
  761066
  769502
  801941
  446920
  445955
  481386
  504185
  492933
  815714
  448145
  510856
  533040
  531435
  553283
  589349
  593469
  608033
  810226
  460369
  465467
  395549
  522104
  411807
  501717
  451672
  464308
  448062
  503736
  523441
  716540
  460362
  509656
  386700
  416169
  445778
  453648
  478933
  448104
  458985
  459338
  469618
  457569
  487011
  503565
  505692
  525503
  510107
  522628
  532721
  500635
  523864
  564054
  618687
  607716
  792812
  421773
  431803
  464352
  397662
]
2.42 ms
(1.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big curvy"
]
2.39 ms
(1.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.38 ms
(1.64%)
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
  385854
  386700
  387033
  394535
  395549
  396961
  397662
  405116
  411807
  416169
  419664
  421303
  421773
  427135
  430244
  431803
  445492
  445778
  445955
  446920
  448062
  448104
  448145
  450098
  451672
  453648
  454755
  457569
  458985
  459338
  459838
  460157
  460362
  460369
  464308
  464352
  465467
  468545
  468702
  468837
  469618
  478933
  480414
  481386
  487011
  492933
  493470
  500635
  501717
  503565
  503736
  504185
  504812
  505692
  509656
  510107
  510856
  522104
  522628
  523441
  523864
  525503
  531435
  532721
  532993
  533040
  537591
  548859
  553283
  564054
  564367
  567663
  573311
  577037
  577531
  577594
  589349
  593469
  596392
  601928
  603507
  607403
  607509
  607667
  607714
  607716
  608033
  612383
  615971
  618687
  634416
  695173
  701613
  716540
  723986
  734324
  757105
  760182
  760211
  761066
  769502
  782008
  784925
  792812
  793662
  797461
  798872
  799639
  801348
  801941
  808537
  809076
  810226
  810249
  811152
  812749
  814981
  814983
  814986
  815714
]
2.09 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие curvy"
]
1.71 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие curvy"
]

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.