GET https://search.jues.net/search/embeds/9?q=cum%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.13 ms
(88.65%)
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
  392624
  494539
  529851
  545075
  546181
  546321
  546852
  557077
  576768
  585375
  601239
  602876
  603946
  610191
  612511
  615199
  618489
  620485
  626846
  629740
  629776
  629979
  634599
  636224
  636963
  641888
  643804
  648872
  662918
  688902
  696127
  697187
  699316
  700219
  703720
  703736
  703737
  703750
  706008
  706018
  707473
  710141
  712569
  714359
  718400
  718620
  721991
  722123
  725394
  727984
  730079
  730949
  734940
  742868
  743609
  744576
  746986
  747619
  747962
  747977
  750134
  750458
  755113
  757687
  758015
  761307
  761341
  762584
  764983
  767489
  771914
  771931
  773601
  778314
  779753
  781113
  782318
  782661
  783167
  785996
  786681
  788347
  790265
  792898
  793028
  793164
  793754
  794465
  794972
  795261
  795876
  796137
  797524
  797584
  805628
  810859
  817001
  817955
  819798
  824716
  824824
  825352
  825356
  825389
  825660
  825837
  826080
  826229
  826372
  826376
  826575
  827108
  827632
  828193
  828235
  828237
  828439
  828560
  828763
  828778
]
9.43 ms
(5.61%)
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
  529851
  545075
  546321
  546852
  576768
  699316
  703720
  703737
  703750
  710141
  648872
  688902
  700219
  706008
  662918
  696127
  697187
  712569
  714359
  718400
  546181
  585375
  601239
  615199
  603946
  620485
  629740
  602876
  610191
  612511
  629776
  636963
  618489
  634599
  636224
  643804
  742868
  750134
  782318
  795261
  764983
  743609
  747619
  747977
  767489
  758015
  629979
  703736
  706018
  788347
  794465
  826372
  707473
  392624
  817001
  824824
  825389
  827108
  825352
  828193
  827632
  722123
  786681
  793754
  797584
  779753
  781113
  750458
  793164
  730949
  761341
  762584
  773601
  734940
  747962
  727984
  730079
  744576
  746986
  755113
  771914
  771931
  778314
  785996
  557077
  826229
  826376
  826575
  825837
  817955
  824716
  826080
  825356
  825660
  828778
  828237
  828235
  828763
  828439
  494539
  718620
  721991
  782661
  795876
  790265
  796137
  725394
  783167
  793028
  794972
  797524
  805628
  810859
  757687
  761307
  792898
  828560
  819798
  641888
  626846
]
2.80 ms
(1.66%)
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
  392624
  494539
  529851
  545075
  546181
  546321
  546852
  557077
  576768
  585375
  601239
  602876
  603946
  610191
  612511
  615199
  618489
  620485
  626846
  629740
  629776
  629979
  634599
  636224
  636963
  641888
  643804
  648872
  662918
  688902
  696127
  697187
  699316
  700219
  703720
  703736
  703737
  703750
  706008
  706018
  707473
  710141
  712569
  714359
  718400
  718620
  721991
  722123
  725394
  727984
  730079
  730949
  734940
  742868
  743609
  744576
  746986
  747619
  747962
  747977
  750134
  750458
  755113
  757687
  758015
  761307
  761341
  762584
  764983
  767489
  771914
  771931
  773601
  778314
  779753
  781113
  782318
  782661
  783167
  785996
  786681
  788347
  790265
  792898
  793028
  793164
  793754
  794465
  794972
  795261
  795876
  796137
  797524
  797584
  805628
  810859
  817001
  817955
  819798
  824716
  824824
  825352
  825356
  825389
  825660
  825837
  826080
  826229
  826372
  826376
  826575
  827108
  827632
  828193
  828235
  828237
  828439
  828560
  828763
  828778
]
1.86 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum любительск"
]
1.71 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum amateur"
]
1.65 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum любительск"
]
1.64 ms
(0.98%)
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.