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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.74 ms
(86.02%)
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
  30967
  32860
  194216
  238031
  324241
  381808
  384872
  400397
  402789
  414252
  422475
  458932
  464071
  486229
  515670
  523744
  533432
  533612
  534805
  535881
  536882
  545502
  557462
  564466
  567840
  585157
  585256
  606247
  609578
  611364
  613445
  621327
  621559
  627798
  631259
  631816
  646783
  667579
  667850
  669210
  672275
  676993
  677058
  683839
  689296
  696201
  698495
  705895
  710511
  712303
  725706
  728003
  738259
  739294
  739487
  739566
  740565
  744717
  744767
  747308
  749597
  750604
  755095
  759595
  761693
  762820
  765335
  765753
  768796
  770122
  773129
  774632
  774936
  776506
  778262
  778287
  778450
  780112
  780851
  782323
  783438
  783993
  784402
  785280
  785486
  786096
  787531
  788766
  789454
  789688
  789825
  791474
  793734
  796686
  799471
  800478
  800637
  802739
  803102
  803625
  804013
  806097
  806118
  806753
  809262
  811892
  813145
  813629
  817369
  818720
  819907
  821401
  821927
  823108
  824623
  825910
  826244
  826652
  826920
  827901
]
16.61 ms
(8.73%)
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
  806118
  762820
  824623
  755095
  823108
  785486
  789825
  800478
  750604
  611364
  789454
  827901
  621559
  826244
  784402
  712303
  669210
  774632
  194216
  667850
  400397
  806753
  381808
  744767
  725706
  780851
  533432
  698495
  739487
  826920
  826652
  676993
  631816
  783438
  793734
  811892
  803102
  765753
  778262
  778287
  780112
  621327
  796686
  533612
  825910
  786096
  613445
  821927
  557462
  631259
  486229
  818720
  535881
  609578
  787531
  813145
  813629
  738259
  773129
  819907
  821401
  534805
  536882
  564466
  802739
  770122
  774936
  324241
  789688
  806097
  803625
  782323
  567840
  667579
  778450
  785280
  783993
  788766
  791474
  728003
  739566
  30967
  765335
  744717
  585256
  458932
  515670
  689296
  384872
  749597
  747308
  523744
  606247
  759595
  768796
  740565
  710511
  238031
  804013
  809262
  799471
  761693
  414252
  545502
  683839
  705895
  585157
  402789
  422475
  739294
  646783
  800637
  464071
  672275
  776506
  677058
  627798
  32860
  817369
  696201
]
3.14 ms
(1.65%)
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
  30967
  32860
  194216
  238031
  324241
  381808
  384872
  400397
  402789
  414252
  422475
  458932
  464071
  486229
  515670
  523744
  533432
  533612
  534805
  535881
  536882
  545502
  557462
  564466
  567840
  585157
  585256
  606247
  609578
  611364
  613445
  621327
  621559
  627798
  631259
  631816
  646783
  667579
  667850
  669210
  672275
  676993
  677058
  683839
  689296
  696201
  698495
  705895
  710511
  712303
  725706
  728003
  738259
  739294
  739487
  739566
  740565
  744717
  744767
  747308
  749597
  750604
  755095
  759595
  761693
  762820
  765335
  765753
  768796
  770122
  773129
  774632
  774936
  776506
  778262
  778287
  778450
  780112
  780851
  782323
  783438
  783993
  784402
  785280
  785486
  786096
  787531
  788766
  789454
  789688
  789825
  791474
  793734
  796686
  799471
  800478
  800637
  802739
  803102
  803625
  804013
  806097
  806118
  806753
  809262
  811892
  813145
  813629
  817369
  818720
  819907
  821401
  821927
  823108
  824623
  825910
  826244
  826652
  826920
  827901
]
1.92 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass girls"
]
1.71 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп девушк"
]
1.67 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.82%)
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.