GET https://search.jues.net/search/embeds/4?q=office%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.89 ms
(82.21%)
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
  394704
  395240
  396404
  421283
  430777
  434122
  440620
  440623
  449760
  464404
  476091
  483484
  485548
  490812
  493108
  501505
  511503
  514102
  517080
  520943
  521166
  526221
  531902
  535414
  538329
  539151
  539458
  542678
  551703
  553968
  554434
  554529
  559593
  559602
  563494
  563522
  568148
  570765
  585446
  586410
  588370
  594788
  594797
  594861
  594880
  595774
  596227
  600819
  601119
  601249
  601257
  601261
  601263
  601264
  601274
  601278
  603347
  606322
  606682
  606740
  611950
  612188
  615729
  619425
  619483
  623871
  645849
  668528
  671551
  681118
  681686
  690314
  705530
  709331
  721772
  723460
  725374
  740967
  742553
  745696
  746062
  748197
  751778
  755461
  755469
  756497
  757562
  760549
  760795
  762020
  765025
  770100
  777843
  787244
  799058
  803731
  805206
  805568
  811220
  811493
  811813
  813573
  815078
  815283
  815290
  815308
  815397
  815399
  815657
  815676
  815810
  815980
  816040
  816055
  816579
  817869
  818391
  820108
  822388
  823567
]
17.13 ms
(11.18%)
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
  705530
  553968
  601278
  594880
  619425
  601274
  606682
  623871
  760795
  430777
  434122
  421283
  493108
  517080
  483484
  440620
  542678
  681686
  668528
  585446
  615729
  511503
  514102
  521166
  526221
  815399
  815657
  816055
  822388
  815308
  818391
  823567
  815397
  815676
  815980
  816579
  490812
  538329
  539458
  531902
  539151
  551703
  563494
  559593
  559602
  645849
  681118
  721772
  671551
  690314
  723460
  563522
  586410
  594797
  606322
  601257
  601261
  601249
  601263
  601264
  612188
  805206
  805568
  811493
  777843
  725374
  746062
  755461
  787244
  803731
  811813
  740967
  762020
  770100
  745696
  748197
  751778
  755469
  756497
  757562
  742553
  760549
  765025
  606740
  709331
  799058
  394704
  570765
  464404
  449760
  554529
  595774
  619483
  440623
  820108
  601119
  813573
  815290
  554434
  568148
  594861
  594788
  603347
  588370
  596227
  600819
  811220
  611950
  476091
  396404
  395240
  520943
  485548
  501505
  535414
  815283
  816040
  815078
  815810
  817869
]
2.84 ms
(1.85%)
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
  394704
  395240
  396404
  421283
  430777
  434122
  440620
  440623
  449760
  464404
  476091
  483484
  485548
  490812
  493108
  501505
  511503
  514102
  517080
  520943
  521166
  526221
  531902
  535414
  538329
  539151
  539458
  542678
  551703
  553968
  554434
  554529
  559593
  559602
  563494
  563522
  568148
  570765
  585446
  586410
  588370
  594788
  594797
  594861
  594880
  595774
  596227
  600819
  601119
  601249
  601257
  601261
  601263
  601264
  601274
  601278
  603347
  606322
  606682
  606740
  611950
  612188
  615729
  619425
  619483
  623871
  645849
  668528
  671551
  681118
  681686
  690314
  705530
  709331
  721772
  723460
  725374
  740967
  742553
  745696
  746062
  748197
  751778
  755461
  755469
  756497
  757562
  760549
  760795
  762020
  765025
  770100
  777843
  787244
  799058
  803731
  805206
  805568
  811220
  811493
  811813
  813573
  815078
  815283
  815290
  815308
  815397
  815399
  815657
  815676
  815810
  815980
  816040
  816055
  816579
  817869
  818391
  820108
  822388
  823567
]
1.97 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office mom"
]
1.83 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш mom"
]
1.80 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секретарш mom"
]
1.69 ms
(1.10%)
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.