GET https://search.jues.net/search/embeds/3?q=amateur%20student

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.32 ms
(84.08%)
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
  388544
  398008
  462406
  480065
  495308
  511615
  530553
  532414
  547898
  550276
  555555
  555708
  563565
  567240
  577989
  592538
  594441
  609578
  615628
  623056
  629727
  630379
  631222
  642085
  643149
  651535
  652424
  667178
  675157
  675178
  677542
  680667
  680669
  682227
  683698
  691326
  693875
  695788
  700056
  700151
  713734
  715036
  718134
  718143
  724455
  724834
  724971
  727309
  729348
  729676
  729705
  730707
  733657
  734671
  735245
  735831
  736680
  738021
  738729
  740624
  740837
  741500
  743555
  747302
  750106
  751306
  752951
  753494
  753543
  754047
  754869
  754873
  755577
  759337
  760521
  761824
  763977
  766056
  766098
  766163
  768708
  772262
  772560
  776235
  778825
  779854
  781640
  782146
  783359
  783563
  785366
  786796
  786886
  787890
  788045
  788552
  789591
  790172
  790237
  791223
  791869
  792014
  792873
  793026
  793128
  793920
  797812
  798860
  803980
  807160
  807319
  809599
  810205
  812668
  816807
  817497
  821772
  825377
]
16.01 ms
(9.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
  555555
  783563
  789591
  782146
  790237
  740837
  766056
  797812
  741500
  729676
  752951
  729348
  754869
  754873
  738021
  743555
  783359
  788045
  790172
  791869
  398008
  594441
  462406
  550276
  675157
  691326
  683698
  700056
  651535
  652424
  667178
  675178
  677542
  682227
  693875
  567240
  577989
  592538
  615628
  623056
  631222
  643149
  727309
  630379
  700151
  480065
  530553
  713734
  695788
  609578
  754047
  761824
  495308
  816807
  821772
  532414
  563565
  547898
  555708
  680669
  718143
  718134
  642085
  629727
  785366
  792873
  776235
  778825
  786796
  729705
  736680
  766098
  772262
  772560
  793128
  793920
  809599
  751306
  759337
  766163
  738729
  753494
  753543
  734671
  735831
  740624
  760521
  768708
  724834
  747302
  768119
  715036
  781640
  793026
  388544
  825377
  817497
  807319
  680667
  694097
  511615
  779854
  787890
  788552
  791223
  792014
  798860
  807160
  812668
  786886
  803980
  730707
  733657
  810205
  735245
  724455
  724971
  750106
  755577
  763977
]
3.03 ms
(1.74%)
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
  388544
  398008
  462406
  480065
  495308
  511615
  530553
  532414
  547898
  550276
  555555
  555708
  563565
  567240
  577989
  592538
  594441
  609578
  615628
  623056
  629727
  630379
  631222
  642085
  643149
  651535
  652424
  667178
  675157
  675178
  677542
  680667
  680669
  682227
  683698
  691326
  693875
  695788
  700056
  700151
  713734
  715036
  718134
  718143
  724455
  724834
  724971
  727309
  729348
  729676
  729705
  730707
  733657
  734671
  735245
  735831
  736680
  738021
  738729
  740624
  740837
  741500
  743555
  747302
  750106
  751306
  752951
  753494
  753543
  754047
  754869
  754873
  755577
  759337
  760521
  761824
  763977
  766056
  766098
  766163
  768708
  772262
  772560
  776235
  778825
  779854
  781640
  782146
  783359
  783563
  785366
  786796
  786886
  787890
  788045
  788552
  789591
  790172
  790237
  791223
  791869
  792014
  792873
  793026
  793128
  793920
  797812
  798860
  803980
  807160
  807319
  809599
  810205
  812668
  816807
  817497
  821772
  825377
]
2.43 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск student"
]
2.19 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск student"
]
2.04 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur student"
]

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.