GET https://search.jues.net/search/embeds/9?q=rus%20young%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.66 ms
(89.06%)
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
  187843
  315513
  397916
  400494
  400844
  400865
  400995
  401006
  411327
  421854
  421863
  421945
  422158
  422199
  424432
  424458
  424475
  428136
  436742
  437632
  439585
  439590
  439612
  439616
  439639
  439679
  439739
  439745
  439754
  439757
  440988
  441004
  443775
  443812
  446240
  451239
  454217
  463171
  465346
  465963
  466014
  466265
  466877
  467457
  467518
  467525
  468906
  470772
  470791
  471405
  474627
  474661
  474680
  476251
  477389
  481277
  481925
  482358
  484406
  484484
  484632
  484651
  484654
  484671
  485696
  486577
  490438
  496874
  498491
  500384
  502749
  502750
  507785
  510908
  511534
  512261
  512988
  513518
  513525
  514436
  518835
  519752
  522498
  522525
  525955
  533586
  540801
  540802
  542724
  542748
  544494
  545717
  549639
  552550
  557569
  557595
  559579
  561273
  563007
  563413
  566196
  569930
  572347
  574407
  574410
  588818
  588860
  589665
  590481
  591069
  595875
  596786
  605359
  620757
  621335
  621396
  621489
  621767
  623413
  811133
]
15.36 ms
(6.95%)
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
  439754
  474627
  421863
  465963
  507785
  620757
  595875
  484654
  446240
  514436
  482358
  533586
  542724
  549639
  563413
  574407
  542748
  544494
  545717
  566196
  557569
  559579
  561273
  588818
  588860
  590481
  591069
  400865
  428136
  443812
  470772
  400494
  439639
  440988
  467457
  471405
  424432
  439590
  439739
  466877
  467518
  397916
  401006
  421945
  439679
  439745
  466265
  470791
  481925
  443775
  451239
  500384
  502749
  513525
  490438
  512261
  512988
  525955
  485696
  519752
  522498
  540801
  484484
  486577
  498491
  484632
  484406
  605359
  421854
  436742
  466014
  424458
  411327
  474680
  484651
  522525
  563007
  621489
  596786
  441004
  623413
  481277
  187843
  315513
  468906
  511534
  572347
  569930
  574410
  552550
  557595
  589665
  621767
  621396
  811133
  621335
  400995
  422199
  437632
  476251
  439585
  454217
  463171
  400844
  422158
  439616
  439757
  467525
  474661
  477389
  424475
  439612
  465346
  518835
  496874
  502750
  513518
  540802
  484671
  510908
]
2.78 ms
(1.26%)
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
  187843
  315513
  397916
  400494
  400844
  400865
  400995
  401006
  411327
  421854
  421863
  421945
  422158
  422199
  424432
  424458
  424475
  428136
  436742
  437632
  439585
  439590
  439612
  439616
  439639
  439679
  439739
  439745
  439754
  439757
  440988
  441004
  443775
  443812
  446240
  451239
  454217
  463171
  465346
  465963
  466014
  466265
  466877
  467457
  467518
  467525
  468906
  470772
  470791
  471405
  474627
  474661
  474680
  476251
  477389
  481277
  481925
  482358
  484406
  484484
  484632
  484651
  484654
  484671
  485696
  486577
  490438
  496874
  498491
  500384
  502749
  502750
  507785
  510908
  511534
  512261
  512988
  513518
  513525
  514436
  518835
  519752
  522498
  522525
  525955
  533586
  540801
  540802
  542724
  542748
  544494
  545717
  549639
  552550
  557569
  557595
  559579
  561273
  563007
  563413
  566196
  569930
  572347
  574407
  574410
  588818
  588860
  589665
  590481
  591069
  595875
  596786
  605359
  620757
  621335
  621396
  621489
  621767
  623413
  811133
]
1.84 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rus young doggy"
]
1.64 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск young рак"
]
1.42 ms
(0.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.13 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск young рак"
]

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.