GET https://search.jues.net/search/embeds/5?q=amateur%20teacher

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.22 ms
(78.84%)
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
  385897
  400726
  400775
  426814
  429443
  432376
  432452
  432472
  432486
  432517
  432527
  433039
  433042
  433061
  433452
  433561
  433596
  434195
  434565
  437577
  437784
  438699
  442553
  444030
  446995
  448706
  454412
  455553
  457660
  457840
  459306
  466309
  466560
  476707
  478393
  479598
  479999
  481443
  485950
  489768
  497118
  497319
  499261
  500026
  500151
  500594
  503770
  505930
  506223
  507077
  509094
  511303
  513531
  515620
  515712
  518953
  520611
  521060
  522078
  524597
  524670
  524673
  525879
  528591
  531491
  532496
  535521
  539282
  539561
  547746
  548213
  550299
  552360
  552791
  552799
  552976
  555687
  555691
  557980
  560302
  562044
  562951
  564696
  569245
  569793
  571776
  575224
  577584
  579225
  581124
  584071
  584167
  585033
  586136
  595763
  599527
  602803
  602834
  603977
  608124
  608815
  612437
  614495
  619832
  626216
  644847
  648761
  654914
  668803
  701508
  709533
  717274
  719014
  725568
  730688
  732905
  760859
  778941
  804007
  826130
]
22.73 ms
(14.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
  515620
  528591
  500151
  515712
  385897
  499261
  552360
  668803
  709533
  524670
  701508
  612437
  400726
  826130
  446995
  509094
  532496
  560302
  557980
  581124
  717274
  547746
  608815
  626216
  433452
  438699
  455553
  432472
  433561
  400775
  432376
  432527
  500026
  507077
  505930
  525879
  485950
  497319
  506223
  520611
  437784
  429443
  585033
  518953
  555691
  579225
  569245
  619832
  608124
  730688
  432486
  432517
  448706
  479598
  481443
  433596
  434565
  444030
  479999
  432452
  433061
  434195
  478393
  466560
  513531
  489768
  497118
  599527
  725568
  804007
  522078
  614495
  732905
  433042
  459306
  548213
  584167
  603977
  602834
  503770
  437577
  644847
  454412
  500594
  539282
  552791
  577584
  552799
  550299
  564696
  719014
  552976
  571776
  575224
  586136
  778941
  760859
  466309
  426814
  457660
  433039
  521060
  511303
  524673
  524597
  442553
  457840
  476707
  531491
  535521
  539561
  562044
  569793
  562951
  584071
  654914
  648761
  555687
  595763
  602803
]
3.04 ms
(1.98%)
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
  385897
  400726
  400775
  426814
  429443
  432376
  432452
  432472
  432486
  432517
  432527
  433039
  433042
  433061
  433452
  433561
  433596
  434195
  434565
  437577
  437784
  438699
  442553
  444030
  446995
  448706
  454412
  455553
  457660
  457840
  459306
  466309
  466560
  476707
  478393
  479598
  479999
  481443
  485950
  489768
  497118
  497319
  499261
  500026
  500151
  500594
  503770
  505930
  506223
  507077
  509094
  511303
  513531
  515620
  515712
  518953
  520611
  521060
  522078
  524597
  524670
  524673
  525879
  528591
  531491
  532496
  535521
  539282
  539561
  547746
  548213
  550299
  552360
  552791
  552799
  552976
  555687
  555691
  557980
  560302
  562044
  562951
  564696
  569245
  569793
  571776
  575224
  577584
  579225
  581124
  584071
  584167
  585033
  586136
  595763
  599527
  602803
  602834
  603977
  608124
  608815
  612437
  614495
  619832
  626216
  644847
  648761
  654914
  668803
  701508
  709533
  717274
  719014
  725568
  730688
  732905
  760859
  778941
  804007
  826130
]
1.92 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur teacher"
]
1.83 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск teacher"
]
1.41 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск teacher"
]

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.