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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.34 ms
(82.73%)
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
  393865
  400134
  400143
  400166
  401799
  402999
  403600
  407154
  408293
  409144
  413889
  425998
  428454
  428822
  430833
  430835
  430839
  430979
  432524
  432601
  432834
  437583
  438031
  438324
  455281
  456736
  464661
  470871
  472913
  478107
  481346
  481874
  486008
  486023
  486539
  500578
  510287
  512063
  515802
  518062
  518735
  524109
  529202
  531923
  532130
  533959
  533965
  535010
  539830
  540549
  546754
  548848
  551069
  551070
  559678
  561568
  565050
  565631
  579761
  580300
  587685
  587693
  596011
  599703
  601234
  604157
  617677
  664660
  668948
  674743
  684308
  688313
  690091
  693256
  696171
  698312
  699536
  702904
  706266
  709408
  710310
  710575
  710604
  714457
  714475
  715662
  724295
  727622
  730524
  739965
  756920
  760616
  763280
  769163
  770006
  772322
  775129
  785180
  786455
  788161
  788610
  788961
  789750
  790017
  790596
  791182
  793171
  797632
  799230
  799936
  803217
  803762
  804620
  805700
  806741
  807452
  807454
  813268
  820148
  823263
]
14.48 ms
(10.38%)
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
  409144
  486008
  804620
  402999
  428454
  668948
  696171
  709408
  706266
  587693
  596011
  617677
  775129
  788961
  790596
  799230
  730524
  500578
  599703
  403600
  432834
  455281
  456736
  601234
  408293
  400143
  393865
  478107
  481874
  437583
  407154
  430835
  510287
  533959
  535010
  486023
  539830
  551070
  813268
  472913
  428822
  512063
  559678
  565631
  481346
  524109
  565050
  579761
  561568
  715662
  664660
  587685
  788610
  786455
  702904
  693256
  674743
  803762
  785180
  791182
  756920
  788161
  789750
  793171
  805700
  772322
  790017
  425998
  515802
  551069
  698312
  799936
  432601
  432524
  531923
  532130
  546754
  684308
  688313
  604157
  727622
  797632
  438324
  400134
  438031
  470871
  518735
  518062
  400166
  464661
  540549
  548848
  714475
  580300
  699536
  714457
  401799
  413889
  430979
  430833
  430839
  529202
  533965
  486539
  820148
  823263
  710575
  690091
  710310
  710604
  807452
  769163
  770006
  724295
  739965
  760616
  763280
  803217
  806741
  807454
]
2.44 ms
(1.75%)
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
  393865
  400134
  400143
  400166
  401799
  402999
  403600
  407154
  408293
  409144
  413889
  425998
  428454
  428822
  430833
  430835
  430839
  430979
  432524
  432601
  432834
  437583
  438031
  438324
  455281
  456736
  464661
  470871
  472913
  478107
  481346
  481874
  486008
  486023
  486539
  500578
  510287
  512063
  515802
  518062
  518735
  524109
  529202
  531923
  532130
  533959
  533965
  535010
  539830
  540549
  546754
  548848
  551069
  551070
  559678
  561568
  565050
  565631
  579761
  580300
  587685
  587693
  596011
  599703
  601234
  604157
  617677
  664660
  668948
  674743
  684308
  688313
  690091
  693256
  696171
  698312
  699536
  702904
  706266
  709408
  710310
  710575
  710604
  714457
  714475
  715662
  724295
  727622
  730524
  739965
  756920
  760616
  763280
  769163
  770006
  772322
  775129
  785180
  786455
  788161
  788610
  788961
  789750
  790017
  790596
  791182
  793171
  797632
  799230
  799936
  803217
  803762
  804620
  805700
  806741
  807452
  807454
  813268
  820148
  823263
]
2.31 ms
(1.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty step mom"
]
1.72 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty step mom"
]
1.60 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty step mom"
]
1.53 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.