GET https://search.jues.net/search/embeds/10?q=office%20big%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.78 ms
(87.11%)
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
  31723
  34296
  150798
  233346
  265654
  382554
  387334
  392880
  395291
  423383
  442271
  446721
  448796
  453303
  453893
  457180
  460976
  462558
  482877
  506002
  509837
  511485
  512046
  515603
  520932
  523002
  530508
  548154
  556965
  558539
  563514
  578100
  581190
  583564
  584484
  585453
  585525
  587155
  588669
  593112
  594892
  594942
  594987
  601251
  601262
  601285
  605990
  607229
  613122
  619235
  621686
  623991
  626577
  633172
  637521
  648206
  648437
  650490
  660301
  665122
  667523
  667846
  679632
  682516
  684018
  692654
  695598
  695730
  708438
  714429
  714620
  716111
  716190
  717692
  722673
  724171
  724174
  725513
  726602
  727006
  727239
  732970
  735875
  740985
  741001
  741009
  741077
  743861
  750948
  759867
  760823
  771291
  772879
  774196
  774524
  777792
  780728
  781893
  782407
  788866
  789605
  790000
  790001
  794786
  796243
  796957
  799710
  801416
  802467
  803495
  806352
  812912
  814874
  814922
  815095
  815395
  815772
  816085
  818435
  824473
]
13.66 ms
(7.40%)
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
  716111
  556965
  583564
  585453
  601251
  601262
  619235
  585525
  794786
  799710
  788866
  741077
  735875
  759867
  726602
  743861
  760823
  724171
  771291
  727006
  727239
  732970
  772879
  637521
  714429
  722673
  777792
  781893
  233346
  392880
  453893
  265654
  382554
  520932
  395291
  457180
  725513
  724174
  782407
  558539
  423383
  462558
  633172
  796957
  34296
  448796
  511485
  150798
  660301
  442271
  548154
  515603
  584484
  815095
  815395
  446721
  506002
  593112
  594987
  806352
  774196
  523002
  815772
  824473
  460976
  714620
  692654
  578100
  613122
  780728
  750948
  482877
  31723
  387334
  814874
  816085
  818435
  814922
  453303
  530508
  512046
  509837
  563514
  581190
  648206
  650490
  665122
  682516
  695598
  648437
  667523
  684018
  695730
  667846
  679632
  708438
  716190
  717692
  588669
  621686
  587155
  594892
  594942
  605990
  607229
  601285
  626577
  623991
  789605
  790001
  774524
  790000
  740985
  741001
  741009
  796243
  801416
  802467
  803495
  812912
]
2.84 ms
(1.54%)
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
  31723
  34296
  150798
  233346
  265654
  382554
  387334
  392880
  395291
  423383
  442271
  446721
  448796
  453303
  453893
  457180
  460976
  462558
  482877
  506002
  509837
  511485
  512046
  515603
  520932
  523002
  530508
  548154
  556965
  558539
  563514
  578100
  581190
  583564
  584484
  585453
  585525
  587155
  588669
  593112
  594892
  594942
  594987
  601251
  601262
  601285
  605990
  607229
  613122
  619235
  621686
  623991
  626577
  633172
  637521
  648206
  648437
  650490
  660301
  665122
  667523
  667846
  679632
  682516
  684018
  692654
  695598
  695730
  708438
  714429
  714620
  716111
  716190
  717692
  722673
  724171
  724174
  725513
  726602
  727006
  727239
  732970
  735875
  740985
  741001
  741009
  741077
  743861
  750948
  759867
  760823
  771291
  772879
  774196
  774524
  777792
  780728
  781893
  782407
  788866
  789605
  790000
  790001
  794786
  796243
  796957
  799710
  801416
  802467
  803495
  806352
  812912
  814874
  814922
  815095
  815395
  815772
  816085
  818435
  824473
]
2.02 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office big ass"
]
1.88 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш большая большие жоп"
]
1.82 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секретарш большая большие жоп"
]
1.57 ms
(0.85%)
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.