GET https://search.jues.net/search/embeds/2?q=hottie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.00 ms
(85.56%)
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
  118472
  191728
  198408
  210619
  229704
  363076
  386904
  387815
  388149
  390275
  396519
  398724
  398738
  403281
  451543
  453443
  460962
  467225
  467366
  533947
  556605
  570507
  577659
  583630
  599445
  600602
  611978
  620766
  626882
  628261
  628359
  629050
  639126
  652639
  654783
  655679
  656348
  658245
  658698
  660277
  660970
  661327
  664304
  665909
  670278
  671335
  671792
  673462
  676445
  676793
  676914
  677379
  696050
  696052
  696975
  700259
  711924
  720770
  720879
  722764
  727798
  731711
  731880
  738757
  742107
  743174
  743913
  744042
  746709
  747450
  747578
  747864
  753600
  754286
  754355
  754434
  756173
  757347
  757525
  758033
  759841
  759903
  763877
  767761
  772765
  774134
  774295
  776063
  776328
  782154
  783213
  785448
  786045
  789450
  789459
  789806
  796004
  799995
  800539
  802481
  802890
  804116
  804904
  805485
  805568
  806398
  808231
  809192
  810217
  810220
  810922
  811204
  814698
  816475
  817157
  818280
  818793
  820225
  822178
]
12.17 ms
(8.13%)
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
  731711
  767761
  776328
  786045
  796004
  802890
  804904
  811204
  198408
  118472
  386904
  818280
  826136
  467225
  533947
  577659
  652639
  654783
  658698
  660277
  671335
  711924
  660970
  664304
  655679
  658245
  722764
  611978
  620766
  626882
  789450
  802481
  809192
  776063
  785448
  789459
  800539
  746709
  743913
  754355
  757525
  763877
  747864
  754286
  628359
  696975
  398724
  210619
  403281
  451543
  191728
  363076
  387815
  398738
  818793
  820225
  817157
  822178
  656348
  661327
  673462
  676793
  665909
  720879
  583630
  599445
  600602
  628261
  805568
  747450
  783213
  805485
  727798
  742107
  759841
  753600
  754434
  758033
  731880
  738757
  744042
  756173
  743174
  759903
  629050
  804116
  810922
  390275
  229704
  388149
  396519
  671792
  816475
  814698
  453443
  467366
  460962
  570507
  677379
  696050
  670278
  676445
  696052
  676914
  700259
  720770
  556605
  639126
  799995
  806398
  810217
  808231
  810220
  747578
  757347
  772765
  774134
  774295
  782154
  789806
]
3.24 ms
(2.16%)
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
  118472
  191728
  198408
  210619
  229704
  363076
  386904
  387815
  388149
  390275
  396519
  398724
  398738
  403281
  451543
  453443
  460962
  467225
  467366
  533947
  556605
  570507
  577659
  583630
  599445
  600602
  611978
  620766
  626882
  628261
  628359
  629050
  639126
  652639
  654783
  655679
  656348
  658245
  658698
  660277
  660970
  661327
  664304
  665909
  670278
  671335
  671792
  673462
  676445
  676793
  676914
  677379
  696050
  696052
  696975
  700259
  711924
  720770
  720879
  722764
  727798
  731711
  731880
  738757
  742107
  743174
  743913
  744042
  746709
  747450
  747578
  747864
  753600
  754286
  754355
  754434
  756173
  757347
  757525
  758033
  759841
  759903
  763877
  767761
  772765
  774134
  774295
  776063
  776328
  782154
  783213
  785448
  786045
  789450
  789459
  789806
  796004
  799995
  800539
  802481
  802890
  804116
  804904
  805485
  805568
  806398
  808231
  809192
  810217
  810220
  810922
  811204
  814698
  816475
  817157
  818280
  818793
  820225
  822178
]
1.83 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hottie"
]
1.53 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hottie"
]
1.15 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hottie"
]

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.