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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.64 ms
(82.19%)
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
  14806
  69611
  182352
  388653
  388690
  389675
  391690
  396562
  399058
  399090
  399414
  401728
  405444
  405508
  416090
  417825
  418897
  420116
  420499
  429171
  429198
  429823
  430379
  433553
  433823
  434327
  445730
  450111
  453202
  457296
  465125
  469593
  477082
  478773
  485170
  491977
  495412
  499174
  499668
  499717
  513290
  514289
  516746
  517937
  519862
  521754
  526095
  533559
  536632
  536930
  537832
  540393
  542583
  542590
  545475
  546977
  547082
  547364
  554440
  555807
  557243
  565098
  565335
  566242
  573238
  574507
  575197
  575734
  576346
  576395
  579358
  581726
  584685
  591041
  595764
  596436
  597997
  599295
  599996
  600380
  602061
  603724
  603792
  604507
  604526
  605129
  605244
  606392
  607215
  617618
  622682
  631193
  635948
  648279
  671721
  684312
  695464
  708667
  709885
  711899
  714464
  718947
  720186
  722527
  725115
  725676
  744668
  744978
  759578
  785552
  789790
  790983
  795515
  810122
  810688
  814512
  822419
  823030
  828006
]
21.77 ms
(12.20%)
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
  401728
  514289
  417825
  418897
  822419
  821926
  485170
  445730
  540393
  536930
  537832
  565098
  708667
  547364
  566242
  605244
  789790
  744668
  795515
  725676
  810122
  420499
  14806
  405508
  420116
  429198
  389675
  828006
  182352
  576395
  574507
  554440
  714464
  573238
  575734
  595764
  597997
  596436
  600380
  622682
  69611
  388653
  429171
  429823
  433823
  814512
  823030
  450111
  457296
  477082
  495412
  517937
  519862
  526095
  536632
  516746
  546977
  565335
  584685
  547082
  711899
  671721
  695464
  718947
  720186
  722527
  545475
  591041
  605129
  606392
  602061
  617618
  603792
  790983
  810688
  785552
  725115
  759578
  744978
  604526
  607215
  635948
  709885
  399090
  416090
  465125
  469593
  478773
  391690
  433553
  434327
  430379
  491977
  499717
  399058
  453202
  555807
  388690
  396562
  399414
  513290
  499174
  499668
  521754
  648279
  405444
  533559
  575197
  557243
  581726
  542583
  542590
  579358
  684312
  576346
  604507
  599996
  599295
  603724
  631193
]
3.18 ms
(1.78%)
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
  14806
  69611
  182352
  388653
  388690
  389675
  391690
  396562
  399058
  399090
  399414
  401728
  405444
  405508
  416090
  417825
  418897
  420116
  420499
  429171
  429198
  429823
  430379
  433553
  433823
  434327
  445730
  450111
  453202
  457296
  465125
  469593
  477082
  478773
  485170
  491977
  495412
  499174
  499668
  499717
  513290
  514289
  516746
  517937
  519862
  521754
  526095
  533559
  536632
  536930
  537832
  540393
  542583
  542590
  545475
  546977
  547082
  547364
  554440
  555807
  557243
  565098
  565335
  566242
  573238
  574507
  575197
  575734
  576346
  576395
  579358
  581726
  584685
  591041
  595764
  596436
  597997
  599295
  599996
  600380
  602061
  603724
  603792
  604507
  604526
  605129
  605244
  606392
  607215
  617618
  622682
  631193
  635948
  648279
  671721
  684312
  695464
  708667
  709885
  711899
  714464
  718947
  720186
  722527
  725115
  725676
  744668
  744978
  759578
  785552
  789790
  790983
  795515
  810122
  810688
  814512
  822419
  823030
  828006
]
1.98 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small black"
]
1.74 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая black"
]
1.43 ms
(0.80%)
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.