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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.59 ms
(86.75%)
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
  383701
  386649
  395623
  396249
  404346
  404471
  408468
  415534
  417031
  419441
  420147
  420335
  425740
  426159
  426683
  426826
  427301
  430110
  433770
  436728
  436756
  437804
  441417
  445005
  446077
  453782
  455386
  455709
  459308
  460816
  463118
  464309
  465081
  466142
  469009
  472471
  472817
  475083
  479754
  479759
  484502
  485564
  485882
  487432
  488079
  490571
  492376
  494990
  500861
  508128
  512349
  515529
  517098
  518086
  520994
  522839
  526019
  526378
  528929
  531599
  533009
  536516
  557485
  557507
  559835
  562239
  565943
  566277
  566654
  570241
  570600
  573871
  598466
  610199
  611236
  614601
  615691
  615899
  620455
  622212
  623411
  627580
  629293
  631710
  634829
  642124
  659803
  659849
  660892
  669535
  673030
  680919
  687313
  688202
  698386
  704073
  717256
  718968
  722858
  728359
  729674
  733541
  740127
  740627
  750500
  751625
  758243
  760490
  770989
  777602
  777671
  781806
  788092
  796463
  798711
  800483
  801234
  804490
  821713
  822489
]
15.82 ms
(8.24%)
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
  615691
  427301
  536516
  526378
  570241
  557507
  669535
  704073
  614601
  620455
  610199
  796463
  733541
  615899
  777602
  777671
  395623
  425740
  533009
  464309
  475083
  420147
  437804
  485564
  426159
  417031
  508128
  404346
  426826
  436756
  821713
  463118
  494990
  531599
  559835
  562239
  718968
  573871
  622212
  436728
  445005
  455709
  460816
  430110
  526019
  500861
  515529
  722858
  634829
  446077
  517098
  404471
  520994
  472817
  557485
  565943
  687313
  566654
  642124
  798711
  804490
  800483
  770989
  788092
  698386
  383701
  570600
  688202
  717256
  781806
  750500
  751625
  629293
  419441
  433770
  479754
  492376
  396249
  426683
  472471
  522839
  441417
  453782
  518086
  680919
  627580
  740627
  740127
  408468
  415534
  420335
  459308
  469009
  484502
  566277
  631710
  598466
  801234
  728359
  623411
  466142
  479759
  465081
  455386
  490571
  485882
  487432
  488079
  528929
  512349
  386649
  822489
  660892
  659803
  673030
  659849
  729674
  758243
  760490
  611236
]
2.98 ms
(1.55%)
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
  383701
  386649
  395623
  396249
  404346
  404471
  408468
  415534
  417031
  419441
  420147
  420335
  425740
  426159
  426683
  426826
  427301
  430110
  433770
  436728
  436756
  437804
  441417
  445005
  446077
  453782
  455386
  455709
  459308
  460816
  463118
  464309
  465081
  466142
  469009
  472471
  472817
  475083
  479754
  479759
  484502
  485564
  485882
  487432
  488079
  490571
  492376
  494990
  500861
  508128
  512349
  515529
  517098
  518086
  520994
  522839
  526019
  526378
  528929
  531599
  533009
  536516
  557485
  557507
  559835
  562239
  565943
  566277
  566654
  570241
  570600
  573871
  598466
  610199
  611236
  614601
  615691
  615899
  620455
  622212
  623411
  627580
  629293
  631710
  634829
  642124
  659803
  659849
  660892
  669535
  673030
  680919
  687313
  688202
  698386
  704073
  717256
  718968
  722858
  728359
  729674
  733541
  740127
  740627
  750500
  751625
  758243
  760490
  770989
  777602
  777671
  781806
  788092
  796463
  798711
  800483
  801234
  804490
  821713
  822489
]
1.75 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие девушк"
]
1.73 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big girls"
]
1.64 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие девушк"
]
1.54 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.