GET https://search.jues.net/search/embeds/4?q=%D0%B2%20%D0%B3%D0%BE%D0%BB%D0%BE%D0%B2%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.13 ms
(47.89%)
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
  238875
  278236
  382341
  384181
  395405
  396781
  398984
  409188
  411781
  414975
  420781
  421990
  424866
  425176
  427850
  429141
  430742
  439055
  439341
  440894
  443312
  445192
  445507
  454045
  454494
  458560
  458581
  459600
  460230
  460646
  461544
  463197
  471960
  472031
  473217
  473244
  473393
  473893
  477568
  484269
  486227
  487620
  488566
  491472
  495483
  499421
  504732
  509368
  510111
  515638
  517145
  519534
  520474
  521580
  522371
  524207
  527247
  530548
  537244
  537995
  543288
  543484
  543521
  547745
  547999
  548052
  552726
  554514
  555231
  559445
  560297
  560298
  561165
  562499
  562713
  565139
  566285
  566897
  568329
  568718
  569118
  569589
  569788
  570892
  570988
  574415
  574477
  574995
  577927
  579949
  588868
  589258
  590217
  590308
  590624
  596517
  598914
  599438
  599475
  602676
  602934
  606683
  610765
  613041
  617121
  617672
  618690
  618795
  621537
  630648
  634276
  639051
  642934
  651765
  653227
  659658
  680653
  682999
  758501
  800049
]
212.30 ms
(47.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в голов"
]
12.84 ms
(2.87%)
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
  651765
  653227
  659658
  570988
  590308
  590624
  596517
  606683
  630648
  617121
  618795
  588868
  590217
  617672
  610765
  460230
  463197
  238875
  278236
  395405
  439055
  473217
  460646
  420781
  445507
  504732
  522371
  491472
  510111
  524207
  487620
  519534
  499421
  427850
  429141
  454045
  458581
  543288
  552726
  566897
  570892
  574415
  555231
  565139
  682999
  548052
  566285
  599475
  621537
  599438
  602934
  613041
  758501
  800049
  396781
  421990
  424866
  459600
  461544
  430742
  537995
  562499
  398984
  411781
  440894
  443312
  471960
  458560
  473244
  477568
  484269
  509368
  517145
  520474
  530548
  537244
  527247
  521580
  486227
  543484
  560297
  561165
  568718
  579949
  547745
  547999
  554514
  568329
  569589
  569788
  577927
  543521
  560298
  562713
  574477
  574995
  680653
  559445
  569118
  639051
  602676
  618690
  634276
  598914
  589258
  642934
  382341
  384181
  425176
  472031
  409188
  414975
  439341
  473393
  473893
  454494
  445192
  495483
  488566
  515638
]
2.67 ms
(0.60%)
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
  238875
  278236
  382341
  384181
  395405
  396781
  398984
  409188
  411781
  414975
  420781
  421990
  424866
  425176
  427850
  429141
  430742
  439055
  439341
  440894
  443312
  445192
  445507
  454045
  454494
  458560
  458581
  459600
  460230
  460646
  461544
  463197
  471960
  472031
  473217
  473244
  473393
  473893
  477568
  484269
  486227
  487620
  488566
  491472
  495483
  499421
  504732
  509368
  510111
  515638
  517145
  519534
  520474
  521580
  522371
  524207
  527247
  530548
  537244
  537995
  543288
  543484
  543521
  547745
  547999
  548052
  552726
  554514
  555231
  559445
  560297
  560298
  561165
  562499
  562713
  565139
  566285
  566897
  568329
  568718
  569118
  569589
  569788
  570892
  570988
  574415
  574477
  574995
  577927
  579949
  588868
  589258
  590217
  590308
  590624
  596517
  598914
  599438
  599475
  602676
  602934
  606683
  610765
  613041
  617121
  617672
  618690
  618795
  621537
  630648
  634276
  639051
  642934
  651765
  653227
  659658
  680653
  682999
  758501
  800049
]
1.99 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в голов"
]
1.66 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в голову"
]
1.51 ms
(0.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.