GET https://search.jues.net/search/embeds/10?q=girls%20out

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.66 ms
(84.27%)
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
  4429
  68412
  382713
  395310
  398053
  398475
  422287
  426334
  426664
  429492
  432086
  439373
  444746
  446800
  452743
  453339
  454040
  456365
  456860
  458104
  459269
  460850
  461389
  461922
  463469
  465559
  466304
  467584
  469148
  473375
  484312
  489840
  494221
  496120
  497732
  499305
  503359
  505589
  506224
  507568
  510352
  511015
  514779
  520152
  530255
  534011
  538515
  541576
  542923
  546373
  547659
  550154
  559701
  559783
  561876
  569471
  572108
  579847
  581742
  587885
  589185
  591619
  592304
  595138
  595434
  599539
  601964
  603650
  607658
  608160
  612464
  638357
  650258
  650692
  662438
  668493
  673326
  673398
  695182
  699338
  703564
  711542
  717641
  733555
  736483
  737445
  737504
  737877
  743128
  756302
  758876
  759747
  760439
  765083
  766082
  772421
  773251
  780033
  780300
  780810
  784839
  788423
  788697
  789109
  795205
  795250
  797330
  799042
  800425
  802949
  808578
  809403
  809743
  812660
  813077
  815784
  817902
  822851
  823247
  825874
]
15.80 ms
(9.46%)
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
  703564
  784839
  797330
  459269
  426664
  507568
  514779
  429492
  822851
  823247
  825874
  454040
  458104
  452743
  505589
  550154
  579847
  668493
  673326
  650258
  673398
  695182
  650692
  591619
  592304
  607658
  612464
  599539
  780300
  788697
  802949
  812660
  780810
  789109
  809403
  737504
  765083
  772421
  809743
  813077
  733555
  766082
  756302
  759747
  736483
  737877
  795205
  795250
  456860
  398475
  460850
  463469
  446800
  466304
  395310
  68412
  4429
  398053
  422287
  432086
  817902
  469148
  534011
  499305
  465559
  473375
  569471
  542923
  572108
  547659
  559783
  561876
  581742
  699338
  711542
  662438
  587885
  603650
  589185
  595434
  608160
  638357
  595138
  780033
  800425
  737445
  743128
  758876
  760439
  788423
  773251
  601964
  717641
  799042
  808578
  426334
  461922
  439373
  510352
  496120
  489840
  382713
  444746
  815784
  453339
  456365
  484312
  467584
  497732
  511015
  520152
  538515
  494221
  503359
  506224
  530255
  461389
  541576
  546373
  559701
]
3.16 ms
(1.90%)
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
  4429
  68412
  382713
  395310
  398053
  398475
  422287
  426334
  426664
  429492
  432086
  439373
  444746
  446800
  452743
  453339
  454040
  456365
  456860
  458104
  459269
  460850
  461389
  461922
  463469
  465559
  466304
  467584
  469148
  473375
  484312
  489840
  494221
  496120
  497732
  499305
  503359
  505589
  506224
  507568
  510352
  511015
  514779
  520152
  530255
  534011
  538515
  541576
  542923
  546373
  547659
  550154
  559701
  559783
  561876
  569471
  572108
  579847
  581742
  587885
  589185
  591619
  592304
  595138
  595434
  599539
  601964
  603650
  607658
  608160
  612464
  638357
  650258
  650692
  662438
  668493
  673326
  673398
  695182
  699338
  703564
  711542
  717641
  733555
  736483
  737445
  737504
  737877
  743128
  756302
  758876
  759747
  760439
  765083
  766082
  772421
  773251
  780033
  780300
  780810
  784839
  788423
  788697
  789109
  795205
  795250
  797330
  799042
  800425
  802949
  808578
  809403
  809743
  812660
  813077
  815784
  817902
  822851
  823247
  825874
]
2.47 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls out"
]
1.77 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк out"
]
1.59 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк out"
]

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.