GET https://search.jues.net/search/embeds/5?q=boy%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.95 ms
(84.77%)
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
  4252
  13954
  24855
  69063
  157194
  157617
  172291
  172752
  185401
  187928
  193837
  233369
  233710
  285923
  287436
  330715
  351216
  382613
  383224
  383377
  383912
  384488
  386787
  387296
  389440
  390929
  391077
  391483
  391590
  391910
  392076
  392600
  392750
  393441
  395643
  395901
  395934
  395988
  396424
  396907
  397222
  397619
  397874
  400151
  400820
  404598
  405114
  408218
  409774
  411397
  411752
  411762
  411790
  411854
  413650
  418957
  419846
  426389
  428512
  428522
  432338
  442997
  443806
  446249
  446291
  446384
  453633
  454178
  455448
  457218
  460736
  460744
  461504
  462466
  464391
  464561
  466026
  469402
  469486
  470029
  470917
  471402
  473954
  474398
  475080
  477985
  484640
  484643
  489457
  489958
  514757
  518928
  519153
  526749
  535722
  542781
  550434
  563207
  564542
  598988
  601904
  629837
  654777
  663987
  665508
  697704
  721498
  723112
  725401
  728451
  746890
  760851
  768079
  780560
  788571
  788872
  789532
  792215
  806959
  818660
]
14.91 ms
(9.10%)
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
  396907
  400151
  405114
  408218
  413650
  428512
  475080
  519153
  157194
  389440
  442997
  443806
  446291
  462466
  470029
  471402
  390929
  400820
  454178
  514757
  526749
  484640
  550434
  535722
  654777
  768079
  601904
  489958
  383224
  193837
  185401
  172752
  393441
  391590
  392076
  395901
  395934
  285923
  330715
  69063
  4252
  13954
  387296
  396424
  397222
  418957
  426389
  419846
  411752
  818660
  446249
  469486
  457218
  453633
  469402
  474398
  542781
  721498
  665508
  697704
  663987
  723112
  563207
  598988
  629837
  788571
  792215
  780560
  788872
  789532
  746890
  725401
  728451
  806959
  233710
  411762
  473954
  477985
  24855
  233369
  397874
  432338
  455448
  351216
  391483
  392600
  397619
  411397
  461504
  172291
  187928
  382613
  518928
  404598
  409774
  411790
  464561
  464391
  489457
  564542
  391077
  411854
  428522
  446384
  460744
  466026
  460736
  470917
  484643
  760851
  383377
  384488
  383912
  386787
  157617
  391910
  392750
  395643
  395988
  287436
]
2.50 ms
(1.53%)
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
  4252
  13954
  24855
  69063
  157194
  157617
  172291
  172752
  185401
  187928
  193837
  233369
  233710
  285923
  287436
  330715
  351216
  382613
  383224
  383377
  383912
  384488
  386787
  387296
  389440
  390929
  391077
  391483
  391590
  391910
  392076
  392600
  392750
  393441
  395643
  395901
  395934
  395988
  396424
  396907
  397222
  397619
  397874
  400151
  400820
  404598
  405114
  408218
  409774
  411397
  411752
  411762
  411790
  411854
  413650
  418957
  419846
  426389
  428512
  428522
  432338
  442997
  443806
  446249
  446291
  446384
  453633
  454178
  455448
  457218
  460736
  460744
  461504
  462466
  464391
  464561
  466026
  469402
  469486
  470029
  470917
  471402
  473954
  474398
  475080
  477985
  484640
  484643
  489457
  489958
  514757
  518928
  519153
  526749
  535722
  542781
  550434
  563207
  564542
  598988
  601904
  629837
  654777
  663987
  665508
  697704
  721498
  723112
  725401
  728451
  746890
  760851
  768079
  780560
  788571
  788872
  789532
  792215
  806959
  818660
]
2.03 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен парен"
]
2.03 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy boy"
]
1.79 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.04%)
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.