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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.08 ms
(80.55%)
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
  233298
  385826
  392082
  395430
  428184
  441251
  450664
  455998
  458024
  460027
  460032
  471088
  489729
  493023
  496159
  500720
  502721
  505755
  507746
  511485
  513582
  513623
  515603
  515623
  516772
  517050
  520931
  521171
  528465
  530401
  532425
  533721
  534962
  535745
  541907
  544525
  546851
  550506
  555170
  557606
  562567
  567308
  569052
  570855
  585521
  588327
  588357
  588417
  589137
  595224
  600794
  602429
  604307
  605280
  605846
  605990
  607117
  617073
  623991
  630567
  643188
  649246
  655550
  660301
  670386
  671922
  674197
  679632
  692654
  694044
  695724
  695941
  701660
  715952
  716190
  717692
  724171
  725160
  726977
  727006
  727239
  732852
  735875
  740985
  741009
  741084
  745461
  745485
  746048
  746179
  747101
  755498
  757439
  758061
  760637
  760877
  762150
  769306
  769528
  771370
  786573
  787771
  789175
  789281
  793375
  794786
  795980
  799710
  802243
  803495
  804825
  805075
  805204
  805354
  808319
  810080
  810527
  811105
  812846
  819952
]
25.64 ms
(13.67%)
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
  623991
  392082
  534962
  569052
  541907
  715952
  546851
  588357
  799710
  802243
  805204
  793375
  805075
  812846
  811105
  747101
  760877
  724171
  727006
  727239
  789281
  810080
  513623
  428184
  489729
  550506
  570855
  562567
  655550
  671922
  674197
  679632
  716190
  717692
  557606
  589137
  605990
  588417
  595224
  787771
  725160
  740985
  760637
  803495
  769306
  762150
  496159
  528465
  649246
  670386
  695724
  617073
  515603
  516772
  471088
  460027
  567308
  585521
  458024
  385826
  819952
  794786
  735875
  769528
  233298
  460032
  493023
  517050
  530401
  533721
  513582
  555170
  701660
  643188
  604307
  630567
  805354
  741009
  741084
  745485
  795980
  804825
  745461
  746179
  758061
  726977
  771370
  395430
  450664
  505755
  532425
  755498
  507746
  441251
  502721
  786573
  789175
  810527
  808319
  757439
  455998
  588327
  500720
  535745
  544525
  660301
  694044
  692654
  602429
  600794
  605280
  605846
  607117
  520931
  521171
  511485
  695941
  732852
  746048
  515623
]
3.33 ms
(1.77%)
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
  233298
  385826
  392082
  395430
  428184
  441251
  450664
  455998
  458024
  460027
  460032
  471088
  489729
  493023
  496159
  500720
  502721
  505755
  507746
  511485
  513582
  513623
  515603
  515623
  516772
  517050
  520931
  521171
  528465
  530401
  532425
  533721
  534962
  535745
  541907
  544525
  546851
  550506
  555170
  557606
  562567
  567308
  569052
  570855
  585521
  588327
  588357
  588417
  589137
  595224
  600794
  602429
  604307
  605280
  605846
  605990
  607117
  617073
  623991
  630567
  643188
  649246
  655550
  660301
  670386
  671922
  674197
  679632
  692654
  694044
  695724
  695941
  701660
  715952
  716190
  717692
  724171
  725160
  726977
  727006
  727239
  732852
  735875
  740985
  741009
  741084
  745461
  745485
  746048
  746179
  747101
  755498
  757439
  758061
  760637
  760877
  762150
  769306
  769528
  771370
  786573
  787771
  789175
  789281
  793375
  794786
  795980
  799710
  802243
  803495
  804825
  805075
  805204
  805354
  808319
  810080
  810527
  811105
  812846
  819952
]
1.94 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur office"
]
1.93 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск секретарш"
]
1.90 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск секретарш"
]
1.73 ms
(0.92%)
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.