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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.92 ms
(84.90%)
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
  98190
  383448
  397904
  400883
  404084
  404404
  416925
  435698
  438011
  442596
  445340
  449219
  452908
  453520
  472298
  480541
  482975
  490816
  493972
  494720
  499120
  514180
  515658
  515688
  516227
  517553
  520939
  523148
  526884
  527500
  531282
  535313
  537411
  537417
  539376
  541406
  545820
  545909
  547751
  552937
  556788
  564859
  565425
  570933
  571940
  572764
  585479
  585507
  588323
  588326
  588339
  588340
  588354
  588362
  589142
  591330
  592056
  595131
  596732
  596894
  596928
  600750
  600795
  600808
  600814
  601166
  621390
  625631
  633674
  634569
  637763
  644598
  678834
  678838
  680625
  689469
  692654
  697382
  697736
  698614
  698616
  702063
  714558
  716231
  718339
  718739
  718764
  723661
  723952
  724818
  725509
  728601
  733039
  734202
  736071
  739258
  750071
  751352
  758420
  759972
  760677
  760764
  760882
  770671
  778210
  782068
  782553
  787109
  788508
  790408
  803383
  803425
  805123
  805348
  805350
  810646
  813404
  816132
  824200
  827361
]
15.10 ms
(8.97%)
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
  723952
  750071
  514180
  585507
  689469
  634569
  810646
  827361
  770671
  803383
  760764
  678838
  751352
  788508
  601166
  452908
  516227
  816132
  813404
  692654
  588323
  824200
  625631
  572764
  787109
  564859
  547751
  499120
  494720
  442596
  570933
  714558
  637763
  702063
  588354
  600750
  596732
  782068
  805348
  723661
  718339
  527500
  760677
  541406
  526884
  739258
  539376
  697382
  588339
  449219
  585479
  782553
  760882
  591330
  556788
  596894
  718739
  758420
  552937
  480541
  697736
  621390
  416925
  805350
  790408
  383448
  588362
  595131
  545909
  698616
  759972
  515658
  644598
  600808
  445340
  571940
  803425
  718764
  733039
  680625
  400883
  404084
  716231
  596928
  435698
  472298
  438011
  493972
  520939
  545820
  588326
  592056
  589142
  734202
  728601
  778210
  805123
  404404
  535313
  698614
  725509
  537417
  600795
  98190
  588340
  517553
  482975
  453520
  397904
  490816
  523148
  515688
  565425
  633674
  724818
  736071
  537411
  678834
  600814
  531282
]
3.15 ms
(1.87%)
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
  98190
  383448
  397904
  400883
  404084
  404404
  416925
  435698
  438011
  442596
  445340
  449219
  452908
  453520
  472298
  480541
  482975
  490816
  493972
  494720
  499120
  514180
  515658
  515688
  516227
  517553
  520939
  523148
  526884
  527500
  531282
  535313
  537411
  537417
  539376
  541406
  545820
  545909
  547751
  552937
  556788
  564859
  565425
  570933
  571940
  572764
  585479
  585507
  588323
  588326
  588339
  588340
  588354
  588362
  589142
  591330
  592056
  595131
  596732
  596894
  596928
  600750
  600795
  600808
  600814
  601166
  621390
  625631
  633674
  634569
  637763
  644598
  678834
  678838
  680625
  689469
  692654
  697382
  697736
  698614
  698616
  702063
  714558
  716231
  718339
  718739
  718764
  723661
  723952
  724818
  725509
  728601
  733039
  734202
  736071
  739258
  750071
  751352
  758420
  759972
  760677
  760764
  760882
  770671
  778210
  782068
  782553
  787109
  788508
  790408
  803383
  803425
  805123
  805348
  805350
  810646
  813404
  816132
  824200
  827361
]
2.08 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office amateur"
]
1.95 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш любительск"
]
1.43 ms
(0.85%)
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.