GET https://search.jues.net/search/embeds/4?q=home%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.55 ms
(88.60%)
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
  157493
  381785
  392607
  395556
  400506
  403166
  405699
  419269
  421892
  422278
  423799
  424182
  426483
  427646
  428044
  433359
  436485
  444248
  445145
  446646
  451082
  453873
  453985
  454466
  455396
  456964
  458835
  459441
  460856
  461341
  462236
  464440
  465324
  468409
  469908
  470649
  478365
  479864
  483227
  485489
  485947
  486327
  491114
  494806
  495623
  500152
  500265
  502230
  503986
  507865
  509561
  509715
  519767
  520823
  522781
  522834
  523869
  525803
  526101
  527837
  528201
  534943
  537631
  547636
  548185
  551170
  556670
  560867
  565018
  566892
  576229
  602803
  604699
  605485
  614897
  618293
  625456
  629354
  634968
  635367
  642263
  642490
  644051
  659061
  666463
  671681
  680466
  688140
  696381
  698773
  702515
  707319
  710270
  718768
  718862
  729933
  731038
  732131
  737338
  739991
  740646
  745622
  755698
  757388
  761806
  762277
  762986
  771043
  778975
  780321
  780876
  784228
  785548
  789276
  791572
  794101
  795098
  801233
  802820
  804883
]
12.34 ms
(6.56%)
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
  566892
  671681
  696381
  702515
  556670
  614897
  635367
  605485
  780321
  784228
  791572
  780876
  740646
  762277
  804883
  731038
  755698
  732131
  737338
  762986
  739991
  757388
  629354
  644051
  707319
  710270
  785548
  794101
  381785
  424182
  436485
  446646
  460856
  423799
  527837
  400506
  444248
  465324
  456964
  507865
  560867
  551170
  565018
  618293
  602803
  462236
  453985
  520823
  523869
  509715
  522781
  526101
  491114
  403166
  479864
  534943
  548185
  666463
  688140
  718862
  659061
  698773
  680466
  547636
  576229
  625456
  634968
  642490
  604699
  642263
  801233
  802820
  729933
  789276
  745622
  771043
  761806
  718768
  778975
  795098
  461341
  470649
  392607
  469908
  486327
  500152
  522834
  478365
  421892
  433359
  509561
  157493
  395556
  405699
  422278
  419269
  428044
  426483
  427646
  445145
  454466
  458835
  468409
  451082
  453873
  455396
  464440
  483227
  485489
  485947
  459441
  495623
  500265
  502230
  537631
  494806
  503986
  519767
  525803
  528201
]
2.62 ms
(1.39%)
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
  157493
  381785
  392607
  395556
  400506
  403166
  405699
  419269
  421892
  422278
  423799
  424182
  426483
  427646
  428044
  433359
  436485
  444248
  445145
  446646
  451082
  453873
  453985
  454466
  455396
  456964
  458835
  459441
  460856
  461341
  462236
  464440
  465324
  468409
  469908
  470649
  478365
  479864
  483227
  485489
  485947
  486327
  491114
  494806
  495623
  500152
  500265
  502230
  503986
  507865
  509561
  509715
  519767
  520823
  522781
  522834
  523869
  525803
  526101
  527837
  528201
  534943
  537631
  547636
  548185
  551170
  556670
  560867
  565018
  566892
  576229
  602803
  604699
  605485
  614897
  618293
  625456
  629354
  634968
  635367
  642263
  642490
  644051
  659061
  666463
  671681
  680466
  688140
  696381
  698773
  702515
  707319
  710270
  718768
  718862
  729933
  731038
  732131
  737338
  739991
  740646
  745622
  755698
  757388
  761806
  762277
  762986
  771043
  778975
  780321
  780876
  784228
  785548
  789276
  791572
  794101
  795098
  801233
  802820
  804883
]
1.82 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home doggy"
]
1.76 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "home рак"
]
1.47 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "home рак"
]

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.