GET https://search.jues.net/search/embeds/8?q=mom%20panties

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.79 ms
(85.50%)
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
  474789
  490169
  516985
  518956
  535258
  539965
  541175
  542344
  543176
  549965
  557139
  560150
  568716
  570170
  570875
  578002
  582419
  591120
  596128
  601757
  601860
  603113
  603383
  605262
  605265
  609206
  610580
  611343
  615352
  615395
  617677
  632929
  635721
  636119
  637454
  638956
  640682
  643405
  644016
  653902
  669874
  676581
  699764
  714408
  717003
  717225
  721782
  723098
  724122
  725635
  726113
  726667
  735436
  740457
  745036
  748509
  751200
  751593
  752194
  752915
  753573
  753673
  755474
  755495
  757525
  759611
  760148
  760158
  760816
  762062
  762621
  763874
  767759
  769401
  770137
  770234
  771358
  771683
  771944
  777654
  781835
  784235
  784587
  785157
  785688
  785750
  785756
  788121
  788684
  789216
  792132
  793486
  794272
  797700
  800680
  800684
  801346
  801617
  802034
  802718
  802856
  804969
  805584
  806096
  807210
  811484
  812639
  813412
  815496
  816066
  816718
  819779
  820113
  820392
  821156
  821268
  821379
  822229
  823163
  823557
]
12.68 ms
(7.93%)
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
  819779
  821268
  823557
  815496
  816066
  820392
  823163
  816718
  820113
  821156
  821379
  822229
  539965
  535258
  516985
  518956
  474789
  490169
  549965
  560150
  570875
  578002
  582419
  542344
  543176
  570170
  541175
  557139
  669874
  714408
  653902
  676581
  699764
  717003
  568716
  591120
  603383
  596128
  605262
  611343
  615395
  601860
  609206
  635721
  636119
  643405
  603113
  605265
  617677
  637454
  644016
  777654
  781835
  785157
  785750
  792132
  793486
  800680
  802718
  812639
  813412
  785688
  785756
  789216
  794272
  801346
  801617
  802856
  806096
  745036
  752915
  760158
  771944
  784235
  797700
  800684
  802034
  804969
  805584
  807210
  811484
  724122
  740457
  748509
  752194
  760148
  762062
  763874
  767759
  753573
  755495
  760816
  770137
  770234
  771358
  725635
  735436
  751593
  753673
  757525
  759611
  726113
  726667
  751200
  755474
  762621
  769401
  771683
  601757
  610580
  615352
  632929
  638956
  640682
  717225
  721782
  723098
  784587
  788121
  788684
]
3.04 ms
(1.90%)
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
  474789
  490169
  516985
  518956
  535258
  539965
  541175
  542344
  543176
  549965
  557139
  560150
  568716
  570170
  570875
  578002
  582419
  591120
  596128
  601757
  601860
  603113
  603383
  605262
  605265
  609206
  610580
  611343
  615352
  615395
  617677
  632929
  635721
  636119
  637454
  638956
  640682
  643405
  644016
  653902
  669874
  676581
  699764
  714408
  717003
  717225
  721782
  723098
  724122
  725635
  726113
  726667
  735436
  740457
  745036
  748509
  751200
  751593
  752194
  752915
  753573
  753673
  755474
  755495
  757525
  759611
  760148
  760158
  760816
  762062
  762621
  763874
  767759
  769401
  770137
  770234
  771358
  771683
  771944
  777654
  781835
  784235
  784587
  785157
  785688
  785750
  785756
  788121
  788684
  789216
  792132
  793486
  794272
  797700
  800680
  800684
  801346
  801617
  802034
  802718
  802856
  804969
  805584
  806096
  807210
  811484
  812639
  813412
  815496
  816066
  816718
  819779
  820113
  820392
  821156
  821268
  821379
  822229
  823163
  823557
]
2.10 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom трусик нижн бел"
]
2.03 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom panties"
]
1.80 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom трусик нижн бел"
]
1.55 ms
(0.97%)
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.