GET https://search.jues.net/search/embeds/8?q=%D0%B1%D0%B5%D0%BB%D0%BE%D0%BA%D1%83%D1%80%D0%B0%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.26 ms
(86.39%)
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
  80470
  95742
  131623
  187824
  213614
  269974
  316911
  366296
  381951
  382604
  383326
  384373
  387325
  387785
  387848
  388189
  389015
  389487
  390545
  390956
  391683
  393105
  393496
  396549
  396656
  404777
  407378
  408502
  410623
  410754
  413768
  416036
  416142
  416242
  416707
  429046
  432723
  440747
  442627
  443300
  447574
  447693
  448557
  450313
  453106
  453750
  459261
  461713
  464687
  466774
  467208
  467603
  467616
  468610
  473775
  474596
  474670
  474772
  475873
  481464
  482627
  482730
  484279
  485106
  485361
  489127
  490310
  491010
  494086
  496964
  520665
  532675
  558307
  558948
  561649
  565045
  574089
  576078
  579011
  592289
  596184
  602723
  637632
  638047
  642109
  647983
  654275
  693719
  699631
  702620
  715698
  717107
  717919
  734681
  742234
  743773
  747579
  753024
  753169
  753595
  754185
  754350
  754496
  754809
  755396
  755889
  756696
  759402
  759519
  768587
  773598
  782127
  782647
  783124
  785154
  786795
  802676
  804762
  805313
  806479
]
14.04 ms
(7.76%)
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
  693719
  702620
  717107
  717919
  558948
  596184
  592289
  602723
  637632
  638047
  642109
  804762
  805313
  782647
  785154
  734681
  747579
  753169
  759519
  786795
  753595
  754350
  754496
  743773
  753024
  754185
  754809
  755889
  756696
  759402
  768587
  742234
  755396
  773598
  782127
  783124
  802676
  806479
  213614
  269974
  391683
  80470
  95742
  384373
  383326
  131623
  187824
  393105
  393496
  366296
  316911
  381951
  382604
  389487
  389015
  387848
  387325
  390956
  390545
  387785
  388189
  396549
  396656
  404777
  410623
  416036
  416707
  407378
  408502
  413768
  416142
  429046
  440747
  443300
  416242
  432723
  410754
  442627
  482627
  482730
  447574
  448557
  450313
  453106
  453750
  466774
  467603
  490310
  447693
  467208
  468610
  475873
  484279
  485106
  485361
  459261
  461713
  467616
  473775
  474670
  489127
  491010
  494086
  496964
  520665
  532675
  464687
  474596
  474772
  481464
  576078
  558307
  565045
  574089
  561649
  715698
  647983
  654275
  699631
  579011
]
2.96 ms
(1.64%)
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
  80470
  95742
  131623
  187824
  213614
  269974
  316911
  366296
  381951
  382604
  383326
  384373
  387325
  387785
  387848
  388189
  389015
  389487
  390545
  390956
  391683
  393105
  393496
  396549
  396656
  404777
  407378
  408502
  410623
  410754
  413768
  416036
  416142
  416242
  416707
  429046
  432723
  440747
  442627
  443300
  447574
  447693
  448557
  450313
  453106
  453750
  459261
  461713
  464687
  466774
  467208
  467603
  467616
  468610
  473775
  474596
  474670
  474772
  475873
  481464
  482627
  482730
  484279
  485106
  485361
  489127
  490310
  491010
  494086
  496964
  520665
  532675
  558307
  558948
  561649
  565045
  574089
  576078
  579011
  592289
  596184
  602723
  637632
  638047
  642109
  647983
  654275
  693719
  699631
  702620
  715698
  717107
  717919
  734681
  742234
  743773
  747579
  753024
  753169
  753595
  754185
  754350
  754496
  754809
  755396
  755889
  756696
  759402
  759519
  768587
  773598
  782127
  782647
  783124
  785154
  786795
  802676
  804762
  805313
  806479
]
2.21 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "белокурая"
]
2.16 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая"
]
1.50 ms
(0.83%)
1
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.