GET https://search.jues.net/search/embeds/9?q=girl%20first

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.41 ms
(89.80%)
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
  78620
  391725
  393693
  395407
  395664
  395920
  396843
  404122
  408532
  418512
  421637
  437778
  441559
  444201
  445730
  446175
  454828
  461301
  463845
  469640
  485020
  499457
  511638
  517032
  527491
  528421
  529027
  529058
  535332
  547078
  558496
  563834
  566019
  566244
  566971
  575948
  585499
  588898
  594258
  596255
  597241
  598111
  603779
  609875
  610522
  621288
  622403
  633241
  635236
  635578
  644436
  653139
  653178
  653615
  654240
  657127
  664760
  666465
  672052
  672686
  672891
  676517
  678238
  681490
  681881
  686997
  687896
  697491
  698248
  699961
  701967
  702162
  704540
  705829
  708919
  714527
  715196
  715773
  717954
  719235
  723159
  723964
  727852
  728362
  728369
  731874
  732354
  745915
  746788
  747624
  750334
  757549
  760214
  761659
  765657
  766851
  766969
  775931
  777888
  781052
  782711
  782959
  785777
  790542
  790632
  793075
  794647
  794917
  795506
  796183
  797863
  803543
  805525
  810511
  810896
  813906
  816625
  817244
  817461
  817479
]
12.55 ms
(5.38%)
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
  817244
  610522
  596255
  782711
  785777
  766851
  454828
  529058
  393693
  395664
  441559
  421637
  445730
  558496
  566244
  719235
  588898
  597241
  621288
  760214
  727852
  745915
  747624
  757549
  701967
  529027
  527491
  391725
  395920
  396843
  408532
  444201
  813906
  816625
  463845
  528421
  499457
  535332
  547078
  566019
  672891
  676517
  687896
  704540
  715196
  653178
  657127
  664760
  666465
  672052
  681881
  686997
  653139
  697491
  698248
  723159
  622403
  635236
  635578
  644436
  633241
  594258
  603779
  790632
  793075
  796183
  797863
  810511
  777888
  781052
  782959
  790542
  794647
  805525
  723964
  761659
  794917
  803543
  810896
  732354
  766969
  728369
  728362
  731874
  746788
  750334
  765657
  609875
  699961
  705829
  714527
  715773
  717954
  775931
  795506
  404122
  446175
  461301
  418512
  395407
  702162
  672686
  78620
  437778
  817461
  817479
  485020
  469640
  511638
  517032
  575948
  563834
  566971
  654240
  681490
  678238
  653615
  708919
  585499
  598111
]
4.36 ms
(1.87%)
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
  78620
  391725
  393693
  395407
  395664
  395920
  396843
  404122
  408532
  418512
  421637
  437778
  441559
  444201
  445730
  446175
  454828
  461301
  463845
  469640
  485020
  499457
  511638
  517032
  527491
  528421
  529027
  529058
  535332
  547078
  558496
  563834
  566019
  566244
  566971
  575948
  585499
  588898
  594258
  596255
  597241
  598111
  603779
  609875
  610522
  621288
  622403
  633241
  635236
  635578
  644436
  653139
  653178
  653615
  654240
  657127
  664760
  666465
  672052
  672686
  672891
  676517
  678238
  681490
  681881
  686997
  687896
  697491
  698248
  699961
  701967
  702162
  704540
  705829
  708919
  714527
  715196
  715773
  717954
  719235
  723159
  723964
  727852
  728362
  728369
  731874
  732354
  745915
  746788
  747624
  750334
  757549
  760214
  761659
  765657
  766851
  766969
  775931
  777888
  781052
  782711
  782959
  785777
  790542
  790632
  793075
  794647
  794917
  795506
  796183
  797863
  803543
  805525
  810511
  810896
  813906
  816625
  817244
  817461
  817479
]
2.03 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl first"
]
1.73 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк first"
]
1.57 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк first"
]

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.