GET https://search.jues.net/search/embeds/9?q=%D0%B2%D0%B8%D0%B4%D0%BE%20%D0%BF%D0%BE%D1%80%D0%BD%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.37 ms
(87.92%)
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
  80470
  241603
  381424
  391364
  392674
  398001
  399267
  399352
  399621
  401359
  406574
  407538
  408206
  410848
  411133
  416593
  421211
  422418
  424903
  426364
  426739
  427418
  427452
  429575
  437999
  442392
  442991
  446310
  448076
  448237
  448262
  452751
  454462
  454537
  457669
  457778
  458367
  459308
  461316
  464904
  466158
  466495
  466630
  466646
  467381
  468855
  468984
  469083
  469231
  470068
  470123
  471457
  471526
  472335
  472930
  473132
  475586
  475641
  476877
  477197
  477992
  478326
  478992
  479470
  484152
  484754
  485796
  488525
  489725
  489825
  491656
  491768
  491980
  491984
  493083
  496153
  497836
  498776
  498832
  500057
  501238
  502962
  504345
  504812
  504946
  505850
  508058
  509459
  512005
  514447
  517850
  519176
  521440
  521595
  523872
  524271
  524697
  524779
  525774
  528274
  541422
  557557
  584983
  604978
  607412
  622472
  717131
  720609
  729227
  736797
  741114
  754176
  761992
  788815
  794975
  797749
  797760
  804452
  808647
  810531
]
14.15 ms
(7.17%)
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
  788815
  794975
  797749
  810531
  736797
  761992
  754176
  729227
  741114
  604978
  607412
  622472
  717131
  720609
  797760
  804452
  808647
  381424
  398001
  399621
  407538
  411133
  426739
  446310
  464904
  466158
  469231
  475586
  475641
  477992
  429575
  466630
  468855
  469083
  473132
  401359
  422418
  427418
  437999
  452751
  461316
  470123
  392674
  399267
  427452
  454462
  454537
  457669
  468984
  472335
  421211
  448237
  457778
  466495
  470068
  472930
  478992
  479470
  500057
  501238
  504345
  504812
  509459
  512005
  514447
  523872
  496153
  498776
  502962
  517850
  521440
  484152
  491980
  493083
  497836
  498832
  504946
  521595
  524271
  528274
  484754
  488525
  489725
  489825
  491656
  505850
  508058
  519176
  524697
  524779
  541422
  491768
  525774
  557557
  80470
  241603
  391364
  399352
  406574
  416593
  426364
  408206
  442991
  442392
  410848
  424903
  584983
  448076
  448262
  471457
  477197
  485796
  491984
  458367
  459308
  466646
  467381
  471526
  476877
  478326
]
2.61 ms
(1.32%)
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
  80470
  241603
  381424
  391364
  392674
  398001
  399267
  399352
  399621
  401359
  406574
  407538
  408206
  410848
  411133
  416593
  421211
  422418
  424903
  426364
  426739
  427418
  427452
  429575
  437999
  442392
  442991
  446310
  448076
  448237
  448262
  452751
  454462
  454537
  457669
  457778
  458367
  459308
  461316
  464904
  466158
  466495
  466630
  466646
  467381
  468855
  468984
  469083
  469231
  470068
  470123
  471457
  471526
  472335
  472930
  473132
  475586
  475641
  476877
  477197
  477992
  478326
  478992
  479470
  484152
  484754
  485796
  488525
  489725
  489825
  491656
  491768
  491980
  491984
  493083
  496153
  497836
  498776
  498832
  500057
  501238
  502962
  504345
  504812
  504946
  505850
  508058
  509459
  512005
  514447
  517850
  519176
  521440
  521595
  523872
  524271
  524697
  524779
  525774
  528274
  541422
  557557
  584983
  604978
  607412
  622472
  717131
  720609
  729227
  736797
  741114
  754176
  761992
  788815
  794975
  797749
  797760
  804452
  808647
  810531
]
2.23 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "видо порно"
]
1.72 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вид порн"
]
1.47 ms
(0.74%)
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.