GET https://search.jues.net/search/embeds/10?q=home%20rus

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.52 ms
(87.40%)
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
  400497
  418519
  421878
  422474
  426238
  426987
  431759
  435433
  436656
  439577
  439586
  439627
  439710
  439768
  439791
  439808
  440893
  443085
  445200
  446851
  447287
  448074
  452179
  455197
  462351
  462526
  462840
  463305
  467405
  470506
  475195
  476015
  478969
  484583
  490253
  491114
  492705
  495109
  496585
  503819
  504000
  504183
  505750
  506438
  506794
  506982
  506986
  506997
  507638
  507711
  509513
  509561
  509664
  509970
  510425
  512086
  512843
  513426
  513521
  514324
  515736
  516443
  516524
  516718
  516819
  517118
  517833
  517969
  518336
  519128
  519494
  520011
  520700
  520870
  521192
  521664
  521855
  522986
  524131
  525555
  526101
  526173
  526917
  527064
  527257
  527906
  528607
  543334
  544035
  546761
  547919
  548733
  552643
  554210
  557941
  558983
  559561
  561241
  561273
  561382
  564992
  569386
  571832
  574520
  575261
  580113
  580236
  597015
  601848
  603636
  620836
  621275
  625677
  626311
  627632
  655591
  662395
  746083
  775819
  797241
]
16.21 ms
(7.94%)
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
  515736
  517969
  519494
  526101
  527064
  491114
  496585
  506438
  506982
  521855
  528607
  426987
  422474
  462526
  521192
  571832
  557941
  462840
  439577
  445200
  455197
  478969
  522986
  509664
  527906
  503819
  443085
  490253
  580113
  548733
  559561
  561273
  575261
  580236
  655591
  662395
  558983
  603636
  625677
  746083
  775819
  797241
  431759
  436656
  446851
  448074
  400497
  439710
  463305
  426238
  439791
  439808
  452179
  467405
  475195
  504000
  516443
  516524
  520700
  524131
  495109
  506986
  506997
  510425
  512086
  526173
  492705
  516819
  517118
  519128
  506794
  507638
  509561
  513521
  514324
  525555
  527257
  546761
  621275
  513426
  507711
  505750
  470506
  569386
  544035
  552643
  554210
  626311
  601848
  435433
  439627
  439768
  462351
  418519
  447287
  421878
  439586
  440893
  476015
  517833
  521664
  526917
  484583
  504183
  509970
  518336
  520011
  512843
  509513
  516718
  520870
  564992
  627632
  620836
  597015
  561382
  574520
  561241
  543334
  547919
]
2.77 ms
(1.36%)
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
  400497
  418519
  421878
  422474
  426238
  426987
  431759
  435433
  436656
  439577
  439586
  439627
  439710
  439768
  439791
  439808
  440893
  443085
  445200
  446851
  447287
  448074
  452179
  455197
  462351
  462526
  462840
  463305
  467405
  470506
  475195
  476015
  478969
  484583
  490253
  491114
  492705
  495109
  496585
  503819
  504000
  504183
  505750
  506438
  506794
  506982
  506986
  506997
  507638
  507711
  509513
  509561
  509664
  509970
  510425
  512086
  512843
  513426
  513521
  514324
  515736
  516443
  516524
  516718
  516819
  517118
  517833
  517969
  518336
  519128
  519494
  520011
  520700
  520870
  521192
  521664
  521855
  522986
  524131
  525555
  526101
  526173
  526917
  527064
  527257
  527906
  528607
  543334
  544035
  546761
  547919
  548733
  552643
  554210
  557941
  558983
  559561
  561241
  561273
  561382
  564992
  569386
  571832
  574520
  575261
  580113
  580236
  597015
  601848
  603636
  620836
  621275
  625677
  626311
  627632
  655591
  662395
  746083
  775819
  797241
]
1.82 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home rus"
]
1.68 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "home русск"
]
1.44 ms
(0.71%)
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.