GET https://search.jues.net/search/embeds/8?q=russian%20old%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.06 ms
(82.46%)
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
  74434
  106162
  153922
  213429
  233862
  306275
  388570
  389256
  389629
  389895
  390427
  390807
  391704
  391705
  392030
  392671
  395910
  396554
  400819
  402955
  404127
  411726
  417428
  419543
  443178
  443728
  443953
  462500
  465617
  466920
  469673
  470302
  473322
  473549
  474793
  490791
  495372
  501461
  501891
  503917
  505501
  506211
  507370
  522587
  522699
  524023
  538431
  541250
  545543
  570067
  570068
  575514
  575729
  586378
  587431
  595654
  602859
  612509
  614523
  618774
  621593
  624829
  636270
  702624
  715077
  717713
  721369
  723932
  731161
  734850
  735524
  736866
  736911
  741114
  741127
  741476
  741502
  741602
  742209
  743341
  743679
  749911
  749919
  751900
  752685
  753279
  753482
  753677
  754017
  754201
  759583
  761290
  761474
  762984
  765907
  766575
  769746
  769786
  775941
  778955
  779913
  785941
  786196
  788443
  788473
  797247
  800305
  800377
  800517
  800568
  803244
  804894
  804959
  804995
  805162
  805169
  808857
  810533
  812510
  821976
]
16.13 ms
(11.08%)
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
  624829
  636270
  587431
  595654
  602859
  618774
  775941
  779913
  786196
  788443
  800568
  804995
  810533
  800517
  804894
  808857
  741127
  743341
  759583
  762984
  769786
  797247
  800305
  800377
  805162
  805169
  812510
  736866
  741476
  752685
  766575
  723932
  734850
  741602
  753482
  754201
  769746
  735524
  749911
  749919
  751900
  753677
  754017
  731161
  736911
  741114
  741502
  742209
  753279
  761290
  761474
  765907
  612509
  614523
  621593
  702624
  715077
  717713
  721369
  778955
  803244
  804959
  390427
  443728
  466920
  469673
  106162
  389256
  404127
  462500
  465617
  473549
  390807
  391704
  400819
  306275
  411726
  417428
  443178
  503917
  538431
  495372
  490791
  505501
  522587
  522699
  501891
  507370
  524023
  541250
  785941
  788473
  743679
  233862
  74434
  391705
  392030
  392671
  388570
  395910
  821976
  396554
  153922
  213429
  402955
  389629
  419543
  570067
  570068
  586378
  389895
  470302
  501461
  506211
  443953
  473322
  545543
  474793
  575514
  575729
]
2.56 ms
(1.76%)
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
  74434
  106162
  153922
  213429
  233862
  306275
  388570
  389256
  389629
  389895
  390427
  390807
  391704
  391705
  392030
  392671
  395910
  396554
  400819
  402955
  404127
  411726
  417428
  419543
  443178
  443728
  443953
  462500
  465617
  466920
  469673
  470302
  473322
  473549
  474793
  490791
  495372
  501461
  501891
  503917
  505501
  506211
  507370
  522587
  522699
  524023
  538431
  541250
  545543
  570067
  570068
  575514
  575729
  586378
  587431
  595654
  602859
  612509
  614523
  618774
  621593
  624829
  636270
  702624
  715077
  717713
  721369
  723932
  731161
  734850
  735524
  736866
  736911
  741114
  741127
  741476
  741502
  741602
  742209
  743341
  743679
  749911
  749919
  751900
  752685
  753279
  753482
  753677
  754017
  754201
  759583
  761290
  761474
  762984
  765907
  766575
  769746
  769786
  775941
  778955
  779913
  785941
  786196
  788443
  788473
  797247
  800305
  800377
  800517
  800568
  803244
  804894
  804959
  804995
  805162
  805169
  808857
  810533
  812510
  821976
]
2.03 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian old young"
]
1.67 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск old young"
]
1.65 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск old young"
]
1.49 ms
(1.02%)
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.