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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.83 ms
(84.71%)
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
  14232
  32549
  41516
  120074
  191487
  249637
  325432
  382468
  383011
  384938
  385202
  386093
  389234
  389425
  389620
  389640
  390299
  390831
  391224
  396006
  396410
  396718
  398029
  398053
  401509
  405508
  411227
  412949
  415739
  416165
  416437
  417495
  418897
  419426
  420383
  425942
  429358
  430285
  432381
  432418
  432461
  432522
  432601
  432631
  433418
  433823
  434207
  437517
  441237
  442979
  443116
  444473
  445730
  446335
  448692
  448705
  450111
  453373
  453381
  456685
  458202
  458986
  461718
  461738
  461830
  465476
  465700
  466324
  466642
  467049
  468064
  468213
  468687
  474852
  475983
  482143
  483587
  485170
  486647
  495412
  503036
  508802
  516746
  518794
  521845
  528921
  547074
  547364
  547650
  548588
  563478
  565375
  584214
  591041
  604500
  606657
  607152
  636574
  640798
  715533
  718264
  719243
  720305
  721060
  732292
  735678
  737550
  740965
  741296
  741307
  741527
  753962
  770644
  775974
  790983
  806089
  807621
  808775
  814512
  815852
]
15.12 ms
(8.78%)
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
  432631
  432461
  415739
  418897
  419426
  453381
  485170
  445730
  483587
  503036
  521845
  461718
  475983
  547650
  584214
  719243
  547364
  753962
  808775
  741296
  741307
  735678
  732292
  740965
  721060
  806089
  382468
  390299
  417495
  458202
  461738
  468064
  482143
  401509
  405508
  383011
  465700
  508802
  191487
  412949
  441237
  448692
  474852
  468213
  249637
  442979
  390831
  432522
  528921
  411227
  416165
  458986
  386093
  384938
  385202
  120074
  396006
  325432
  32549
  14232
  389234
  389620
  389640
  391224
  396410
  396718
  398053
  398029
  420383
  432601
  416437
  433418
  437517
  443116
  444473
  425942
  433823
  432381
  815852
  814512
  450111
  453373
  465476
  466642
  468687
  446335
  456685
  467049
  486647
  495412
  516746
  518794
  547074
  565375
  548588
  563478
  718264
  720305
  636574
  591041
  607152
  640798
  790983
  807621
  741527
  770644
  737550
  604500
  606657
  715533
  775974
  389425
  429358
  430285
  432418
  448705
  41516
  434207
  461830
  466324
]
3.82 ms
(2.22%)
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
  14232
  32549
  41516
  120074
  191487
  249637
  325432
  382468
  383011
  384938
  385202
  386093
  389234
  389425
  389620
  389640
  390299
  390831
  391224
  396006
  396410
  396718
  398029
  398053
  401509
  405508
  411227
  412949
  415739
  416165
  416437
  417495
  418897
  419426
  420383
  425942
  429358
  430285
  432381
  432418
  432461
  432522
  432601
  432631
  433418
  433823
  434207
  437517
  441237
  442979
  443116
  444473
  445730
  446335
  448692
  448705
  450111
  453373
  453381
  456685
  458202
  458986
  461718
  461738
  461830
  465476
  465700
  466324
  466642
  467049
  468064
  468213
  468687
  474852
  475983
  482143
  483587
  485170
  486647
  495412
  503036
  508802
  516746
  518794
  521845
  528921
  547074
  547364
  547650
  548588
  563478
  565375
  584214
  591041
  604500
  606657
  607152
  636574
  640798
  715533
  718264
  719243
  720305
  721060
  732292
  735678
  737550
  740965
  741296
  741307
  741527
  753962
  770644
  775974
  790983
  806089
  807621
  808775
  814512
  815852
]
2.07 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black boy"
]
1.81 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black парен"
]
1.71 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black парен"
]

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.