GET https://search.jues.net/search/embeds/5?q=%D0%B2%20%D0%BA%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D0%B5

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.89 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.25 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в кровате"
]
3 15.47 ms
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
  398742
  437178
  62253
  403478
  452662
  538233
  508719
  581209
  571922
  443129
  475973
  480851
  504262
  230243
  398927
  404112
  415039
  409696
  450835
  453526
  527517
  538146
  570245
  681437
  652924
  570015
  629942
  393469
  425590
  461188
  461590
  398757
  400906
  409730
  486487
  511395
  527634
  506691
  507835
  424675
  517187
  439490
  617146
  430264
  68529
  160525
  395672
  275727
  266633
  39497
  387259
  537683
  549414
  574285
  650913
  685277
  688230
  591299
  634519
  85250
  48159
  323899
  403292
  66264
  191059
  377287
  420334
  516803
  526482
  503535
  497120
  393333
  391543
  343350
  61563
  388344
  387539
  387886
  432390
  433299
  469732
  480013
  458776
  505971
  522093
  506791
  531940
  528885
  543227
  551703
  549263
  571808
  582959
  656068
  656372
  659682
  667921
  598353
  621026
  58408
  400653
  436953
  463247
  387868
  469886
  475829
  28386
  397005
  406045
  415344
  383360
  426875
  504028
  498178
  505786
  506235
  482853
  509246
  416959
  396797
]
4 2.81 ms
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
  28386
  39497
  48159
  58408
  61563
  62253
  66264
  68529
  85250
  160525
  191059
  230243
  266633
  275727
  323899
  343350
  377287
  383360
  387259
  387539
  387868
  387886
  388344
  391543
  393333
  393469
  395672
  396797
  397005
  398742
  398757
  398927
  400653
  400906
  403292
  403478
  404112
  406045
  409696
  409730
  415039
  415344
  416959
  420334
  424675
  425590
  426875
  430264
  432390
  433299
  436953
  437178
  439490
  443129
  450835
  452662
  453526
  458776
  461188
  461590
  463247
  469732
  469886
  475829
  475973
  480013
  480851
  482853
  486487
  497120
  498178
  503535
  504028
  504262
  505786
  505971
  506235
  506691
  506791
  507835
  508719
  509246
  511395
  516803
  517187
  522093
  526482
  527517
  527634
  528885
  531940
  537683
  538146
  538233
  543227
  549263
  549414
  551703
  570015
  570245
  571808
  571922
  574285
  581209
  582959
  591299
  598353
  617146
  621026
  629942
  634519
  650913
  652924
  656068
  656372
  659682
  667921
  681437
  685277
  688230
]
5 190.14 ms
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
  28386
  39497
  48159
  58408
  61563
  62253
  66264
  68529
  85250
  160525
  191059
  230243
  266633
  275727
  323899
  343350
  377287
  383360
  387259
  387539
  387868
  387886
  388344
  391543
  393333
  393469
  395672
  396797
  397005
  398742
  398757
  398927
  400653
  400906
  403292
  403478
  404112
  406045
  409696
  409730
  415039
  415344
  416959
  420334
  424675
  425590
  426875
  430264
  432390
  433299
  436953
  437178
  439490
  443129
  450835
  452662
  453526
  458776
  461188
  461590
  463247
  469732
  469886
  475829
  475973
  480013
  480851
  482853
  486487
  497120
  498178
  503535
  504028
  504262
  505786
  505971
  506235
  506691
  506791
  507835
  508719
  509246
  511395
  516803
  517187
  522093
  526482
  527517
  527634
  528885
  531940
  537683
  538146
  538233
  543227
  549263
  549414
  551703
  570015
  570245
  571808
  571922
  574285
  581209
  582959
  591299
  598353
  617146
  621026
  629942
  634519
  650913
  652924
  656068
  656372
  659682
  667921
  681437
  685277
  688230
]
6 1.76 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в кроват"
]
7 1.70 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.