GET https://search.jues.net/search/embeds/10?q=mom%20natural

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.87 ms
(85.09%)
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
  387422
  395909
  397203
  407681
  409113
  429564
  443682
  606531
  607600
  630125
  632926
  636028
  642727
  644030
  699313
  700804
  703437
  709285
  709980
  715475
  715536
  717621
  718835
  723459
  724290
  726169
  726328
  726620
  726649
  726661
  728150
  728503
  730485
  731915
  733510
  733518
  734829
  735241
  735250
  735919
  736092
  736484
  736623
  737535
  738593
  739762
  741610
  742086
  742902
  744170
  744191
  744194
  744201
  744773
  744915
  745017
  745058
  746207
  747145
  747901
  748689
  751478
  753039
  753074
  754189
  754977
  755193
  756281
  756920
  758926
  760133
  760309
  761217
  763225
  766615
  768363
  769626
  770100
  771111
  771610
  771842
  772998
  774727
  774739
  776763
  777378
  779616
  781956
  782276
  782489
  782496
  783278
  785298
  787352
  787571
  787724
  788160
  791966
  795503
  796578
  797369
  798759
  799965
  800066
  800881
  801407
  801955
  802450
  802722
  802833
  804494
  804583
  807783
  807824
  808534
  808552
  810277
  819975
  823477
  823790
]
11.87 ms
(8.36%)
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
  798759
  799965
  800066
  802450
  802722
  741610
  742086
  744170
  744194
  744201
  745058
  753039
  756920
  760133
  761217
  782276
  782489
  783278
  785298
  787571
  787724
  791966
  796578
  797369
  800881
  801407
  801955
  808552
  810277
  726169
  726620
  728150
  733510
  736623
  737535
  738593
  744773
  746207
  754189
  754977
  758926
  760309
  770100
  771842
  772998
  726328
  726649
  726661
  728503
  733518
  734829
  735250
  736484
  744915
  745017
  747145
  768363
  724290
  730485
  731915
  735919
  739762
  742902
  747901
  748689
  751478
  755193
  763225
  771111
  735241
  736092
  753074
  756281
  766615
  769626
  771610
  606531
  607600
  630125
  632926
  636028
  642727
  644030
  699313
  700804
  703437
  709285
  709980
  715475
  715536
  717621
  718835
  723459
  774727
  774739
  776763
  777378
  779616
  781956
  782496
  787352
  788160
  795503
  802833
  804494
  804583
  807783
  807824
  808534
  409113
  395909
  387422
  407681
  443682
  397203
  429564
  819975
  744191
  823477
  823790
]
2.43 ms
(1.71%)
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
  387422
  395909
  397203
  407681
  409113
  429564
  443682
  606531
  607600
  630125
  632926
  636028
  642727
  644030
  699313
  700804
  703437
  709285
  709980
  715475
  715536
  717621
  718835
  723459
  724290
  726169
  726328
  726620
  726649
  726661
  728150
  728503
  730485
  731915
  733510
  733518
  734829
  735241
  735250
  735919
  736092
  736484
  736623
  737535
  738593
  739762
  741610
  742086
  742902
  744170
  744191
  744194
  744201
  744773
  744915
  745017
  745058
  746207
  747145
  747901
  748689
  751478
  753039
  753074
  754189
  754977
  755193
  756281
  756920
  758926
  760133
  760309
  761217
  763225
  766615
  768363
  769626
  770100
  771111
  771610
  771842
  772998
  774727
  774739
  776763
  777378
  779616
  781956
  782276
  782489
  782496
  783278
  785298
  787352
  787571
  787724
  788160
  791966
  795503
  796578
  797369
  798759
  799965
  800066
  800881
  801407
  801955
  802450
  802722
  802833
  804494
  804583
  807783
  807824
  808534
  808552
  810277
  819975
  823477
  823790
]
1.99 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom natural"
]
1.71 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom натуральная натуральные"
]
1.56 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom натуральная натуральные"
]

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.