GET https://search.jues.net/search/embeds/3?q=18%20%D0%BD%D0%B0%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.72 ms
(84.29%)
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
  191715
  252068
  282652
  383773
  386253
  396176
  398242
  399255
  400436
  403042
  403928
  404552
  411710
  418868
  419843
  422643
  422922
  422934
  463093
  469612
  484474
  512174
  515220
  522861
  529039
  530360
  542972
  547670
  549387
  549933
  550014
  550094
  550102
  552032
  559128
  559150
  561589
  571672
  573910
  574451
  580776
  581705
  582333
  586185
  586624
  588267
  597223
  599791
  601596
  606595
  613465
  614244
  614393
  618962
  618970
  619417
  619419
  619452
  623842
  624790
  628301
  635948
  646270
  663908
  665128
  665468
  667317
  667525
  673260
  681213
  681699
  682573
  683567
  684949
  686076
  687232
  693059
  696309
  701325
  705404
  712827
  712837
  714053
  714455
  714780
  716236
  717834
  719930
  720821
  721699
  735820
  741502
  743811
  745999
  746079
  748142
  748158
  748163
  748982
  755746
  759578
  759590
  761290
  762984
  775385
  788734
  799002
  800074
  805847
  807493
  813717
  817958
  819043
  819621
  822694
  823030
  823309
  823417
  824233
]
16.71 ms
(9.73%)
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
  624790
  396176
  403042
  813717
  819043
  821926
  512174
  550014
  686076
  693059
  788734
  755746
  549387
  721699
  618970
  762984
  717834
  799002
  463093
  559150
  542972
  714455
  701325
  720821
  571672
  741502
  399255
  530360
  552032
  681699
  716236
  682573
  687232
  549933
  586185
  586624
  613465
  618962
  619417
  588267
  805847
  745999
  628301
  469612
  606595
  748163
  386253
  282652
  522861
  646270
  614244
  748982
  761290
  403928
  398242
  819621
  824233
  817958
  561589
  696309
  614393
  748142
  719930
  422922
  599791
  191715
  411710
  667317
  705404
  714053
  663908
  665468
  574451
  743811
  252068
  404552
  422934
  822694
  823030
  823309
  823417
  515220
  550094
  559128
  580776
  582333
  547670
  667525
  673260
  683567
  714780
  665128
  712837
  681213
  684949
  712827
  619452
  746079
  800074
  759578
  735820
  748158
  759590
  635948
  775385
  807493
  419843
  484474
  529039
  581705
  550102
  601596
  400436
  619419
  623842
  418868
  383773
  422643
  573910
  597223
]
2.38 ms
(1.39%)
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
  191715
  252068
  282652
  383773
  386253
  396176
  398242
  399255
  400436
  403042
  403928
  404552
  411710
  418868
  419843
  422643
  422922
  422934
  463093
  469612
  484474
  512174
  515220
  522861
  529039
  530360
  542972
  547670
  549387
  549933
  550014
  550094
  550102
  552032
  559128
  559150
  561589
  571672
  573910
  574451
  580776
  581705
  582333
  586185
  586624
  588267
  597223
  599791
  601596
  606595
  613465
  614244
  614393
  618962
  618970
  619417
  619419
  619452
  623842
  624790
  628301
  635948
  646270
  663908
  665128
  665468
  667317
  667525
  673260
  681213
  681699
  682573
  683567
  684949
  686076
  687232
  693059
  696309
  701325
  705404
  712827
  712837
  714053
  714455
  714780
  716236
  717834
  719930
  720821
  721699
  735820
  741502
  743811
  745999
  746079
  748142
  748158
  748163
  748982
  755746
  759578
  759590
  761290
  762984
  775385
  788734
  799002
  800074
  805847
  807493
  813717
  817958
  819043
  819621
  822694
  823030
  823309
  823417
  824233
]
2.24 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 ная"
]
1.95 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 на"
]
1.91 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 на"
]
1.78 ms
(1.04%)
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.