GET https://search.jues.net/search/embeds/5?q=%D0%BF%D0%B8%D0%B7%D0%B4%20%D0%B0%20%D1%87%D0%BB%D0%B5%D0%BD

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.33 ms
(85.33%)
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
  382650
  383354
  386781
  391110
  395848
  406217
  409822
  410079
  410814
  411132
  412841
  413617
  414940
  415036
  418375
  419426
  421550
  423563
  423853
  424179
  425479
  425565
  428374
  434837
  435688
  435743
  440951
  441289
  441689
  441691
  441714
  443225
  445057
  452740
  453467
  453478
  453549
  455367
  455554
  456019
  456248
  456317
  457958
  459015
  459832
  463178
  463244
  463358
  465675
  468590
  475260
  475708
  475872
  476489
  482746
  485605
  485948
  487090
  490214
  491526
  491537
  491543
  492622
  494098
  494382
  496923
  499705
  499818
  501839
  502373
  504440
  505853
  506848
  507840
  510740
  512038
  517243
  519928
  523244
  523728
  524155
  524382
  524393
  525228
  525402
  526792
  527305
  527616
  527623
  528756
  536201
  551204
  551419
  552932
  555774
  556714
  562242
  562304
  567753
  569840
  571127
  571780
  573633
  576221
  576833
  578181
  578360
  583536
  585973
  606289
  622535
  677691
  679566
  685757
  694618
  700685
  713386
  719418
  734155
  749015
]
17.99 ms
(9.63%)
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
  423563
  435743
  434837
  443225
  428374
  414940
  463358
  492622
  453478
  456019
  456317
  476489
  494098
  506848
  551419
  555774
  424179
  475260
  455554
  501839
  524382
  524393
  487090
  510740
  491537
  494382
  504440
  505853
  452740
  576221
  418375
  459015
  551204
  573633
  713386
  382650
  567753
  719418
  734155
  571780
  485605
  578181
  441691
  441289
  499818
  445057
  556714
  576833
  578360
  677691
  552932
  585973
  383354
  453549
  459832
  525402
  496923
  536201
  409822
  435688
  455367
  468590
  523728
  523244
  526792
  517243
  524155
  499705
  583536
  527616
  606289
  423853
  391110
  412841
  419426
  410814
  465675
  485948
  475872
  507840
  410079
  463178
  525228
  386781
  425479
  441689
  421550
  440951
  482746
  463244
  456248
  490214
  700685
  395848
  406217
  413617
  441714
  453467
  457958
  475708
  411132
  512038
  519928
  527623
  491526
  528756
  491543
  527305
  502373
  679566
  685757
  569840
  571127
  749015
  425565
  415036
  694618
  562242
  562304
  622535
]
2.48 ms
(1.33%)
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
  382650
  383354
  386781
  391110
  395848
  406217
  409822
  410079
  410814
  411132
  412841
  413617
  414940
  415036
  418375
  419426
  421550
  423563
  423853
  424179
  425479
  425565
  428374
  434837
  435688
  435743
  440951
  441289
  441689
  441691
  441714
  443225
  445057
  452740
  453467
  453478
  453549
  455367
  455554
  456019
  456248
  456317
  457958
  459015
  459832
  463178
  463244
  463358
  465675
  468590
  475260
  475708
  475872
  476489
  482746
  485605
  485948
  487090
  490214
  491526
  491537
  491543
  492622
  494098
  494382
  496923
  499705
  499818
  501839
  502373
  504440
  505853
  506848
  507840
  510740
  512038
  517243
  519928
  523244
  523728
  524155
  524382
  524393
  525228
  525402
  526792
  527305
  527616
  527623
  528756
  536201
  551204
  551419
  552932
  555774
  556714
  562242
  562304
  567753
  569840
  571127
  571780
  573633
  576221
  576833
  578181
  578360
  583536
  585973
  606289
  622535
  677691
  679566
  685757
  694618
  700685
  713386
  719418
  734155
  749015
]
2.07 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пизд а член"
]
1.80 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин член"
]
1.54 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вагин член"
]
1.51 ms
(0.81%)
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.