GET https://search.jues.net/search/embeds/9?q=red%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.60 ms
(86.83%)
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
  47707
  100616
  365995
  383563
  387377
  389093
  392986
  395842
  396051
  396190
  396287
  396592
  400513
  400851
  400858
  402777
  403314
  404644
  410677
  414172
  418853
  421836
  421838
  421855
  421859
  422209
  422499
  423033
  423042
  428108
  434201
  439807
  440469
  443199
  446695
  447038
  448800
  452234
  454508
  456628
  458013
  458538
  459651
  459666
  466907
  468691
  468693
  468694
  468695
  469537
  470076
  472159
  472431
  473511
  474034
  474895
  477631
  478505
  483574
  483738
  484763
  486393
  490419
  491230
  498305
  498963
  500686
  508204
  509823
  511391
  511819
  513696
  516485
  520211
  521220
  527914
  529122
  530371
  532968
  534839
  535057
  538773
  541409
  560107
  561023
  565119
  568357
  571399
  575601
  576291
  582443
  592512
  596684
  597059
  601772
  604341
  605382
  620891
  622583
  639816
  643011
  644923
  689521
  691209
  693941
  698550
  717929
  721369
  727751
  733868
  741187
  770141
  775172
  789225
  801917
  803122
  804765
  811993
  821532
  826248
]
15.10 ms
(7.92%)
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
  770141
  698550
  721369
  775172
  789225
  803122
  389093
  100616
  396190
  392986
  402777
  468695
  47707
  396287
  396592
  410677
  428108
  443199
  418853
  423042
  826248
  821532
  447038
  458538
  474895
  484763
  468691
  478505
  448800
  483738
  498305
  509823
  511819
  511391
  532968
  538773
  520211
  529122
  468693
  565119
  689521
  693941
  717929
  691209
  582443
  596684
  605382
  620891
  597059
  643011
  601772
  622583
  592512
  604341
  804765
  801917
  733868
  727751
  741187
  811993
  400851
  404644
  423033
  400858
  421836
  422499
  365995
  387377
  421838
  421855
  454508
  470076
  400513
  403314
  516485
  527914
  483574
  491230
  521220
  383563
  440469
  535057
  530371
  561023
  639816
  414172
  421859
  459651
  422209
  439807
  500686
  395842
  396051
  434201
  644923
  452234
  468694
  469537
  473511
  486393
  446695
  456628
  458013
  459666
  466907
  474034
  477631
  490419
  498963
  508204
  513696
  534839
  472159
  472431
  541409
  571399
  576291
  560107
  568357
  575601
]
2.64 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
  47707
  100616
  365995
  383563
  387377
  389093
  392986
  395842
  396051
  396190
  396287
  396592
  400513
  400851
  400858
  402777
  403314
  404644
  410677
  414172
  418853
  421836
  421838
  421855
  421859
  422209
  422499
  423033
  423042
  428108
  434201
  439807
  440469
  443199
  446695
  447038
  448800
  452234
  454508
  456628
  458013
  458538
  459651
  459666
  466907
  468691
  468693
  468694
  468695
  469537
  470076
  472159
  472431
  473511
  474034
  474895
  477631
  478505
  483574
  483738
  484763
  486393
  490419
  491230
  498305
  498963
  500686
  508204
  509823
  511391
  511819
  513696
  516485
  520211
  521220
  527914
  529122
  530371
  532968
  534839
  535057
  538773
  541409
  560107
  561023
  565119
  568357
  571399
  575601
  576291
  582443
  592512
  596684
  597059
  601772
  604341
  605382
  620891
  622583
  639816
  643011
  644923
  689521
  691209
  693941
  698550
  717929
  721369
  727751
  733868
  741187
  770141
  775172
  789225
  801917
  803122
  804765
  811993
  821532
  826248
]
2.13 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red anal"
]
1.96 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red анал"
]
1.55 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red анал"
]

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.