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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.14 ms
(88.27%)
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
  388012
  401226
  409258
  414946
  428472
  431691
  432837
  442783
  445424
  449760
  450803
  451086
  464404
  465834
  477335
  479019
  484768
  489971
  492096
  495384
  496713
  501657
  507834
  509503
  512895
  513116
  514795
  515031
  516209
  516886
  516966
  517278
  520021
  522168
  523323
  523762
  525469
  529170
  529305
  529895
  531052
  531666
  534686
  535487
  535790
  537539
  537562
  537698
  537722
  537874
  538918
  541160
  543934
  547297
  547323
  547331
  547885
  549960
  550007
  550384
  556799
  561559
  561771
  567981
  568241
  569746
  571184
  574180
  579912
  593165
  597209
  598274
  598390
  601520
  601647
  618377
  626563
  629846
  630281
  633426
  639683
  646865
  684150
  687127
  689336
  699654
  700288
  713035
  714384
  718511
  722191
  726210
  729570
  747924
  747939
  751485
  752185
  755183
  769978
  774078
  775341
  787362
  787634
  797952
  802567
  804770
  806837
  811315
  813486
  815537
  817043
  817091
  818427
  818467
  818869
  819054
  819247
  819249
  823618
  825004
]
11.63 ms
(6.22%)
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
  431691
  432837
  442783
  450803
  451086
  479019
  401226
  409258
  428472
  445424
  464404
  465834
  414946
  449760
  509503
  507834
  516966
  520021
  523762
  529170
  484768
  489971
  512895
  516886
  517278
  523323
  529305
  492096
  513116
  515031
  516209
  522168
  525469
  477335
  388012
  818467
  818869
  817091
  819054
  819247
  815537
  819249
  825004
  817043
  818427
  823618
  496713
  514795
  537698
  537874
  495384
  531052
  531666
  535487
  537722
  538918
  501657
  529895
  534686
  535790
  537539
  537562
  547323
  547331
  549960
  550007
  568241
  569746
  574180
  543934
  579912
  541160
  547297
  550384
  556799
  567981
  646865
  684150
  687127
  700288
  714384
  713035
  718511
  689336
  699654
  722191
  547885
  561559
  561771
  571184
  597209
  601647
  633426
  639683
  598390
  593165
  598274
  601520
  626563
  629846
  630281
  618377
  775341
  797952
  802567
  806837
  811315
  787634
  804770
  813486
  769978
  787362
  747939
  726210
  755183
  729570
  747924
  751485
  752185
  774078
]
3.40 ms
(1.82%)
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
  388012
  401226
  409258
  414946
  428472
  431691
  432837
  442783
  445424
  449760
  450803
  451086
  464404
  465834
  477335
  479019
  484768
  489971
  492096
  495384
  496713
  501657
  507834
  509503
  512895
  513116
  514795
  515031
  516209
  516886
  516966
  517278
  520021
  522168
  523323
  523762
  525469
  529170
  529305
  529895
  531052
  531666
  534686
  535487
  535790
  537539
  537562
  537698
  537722
  537874
  538918
  541160
  543934
  547297
  547323
  547331
  547885
  549960
  550007
  550384
  556799
  561559
  561771
  567981
  568241
  569746
  571184
  574180
  579912
  593165
  597209
  598274
  598390
  601520
  601647
  618377
  626563
  629846
  630281
  633426
  639683
  646865
  684150
  687127
  689336
  699654
  700288
  713035
  714384
  718511
  722191
  726210
  729570
  747924
  747939
  751485
  752185
  755183
  769978
  774078
  775341
  787362
  787634
  797952
  802567
  804770
  806837
  811315
  813486
  815537
  817043
  817091
  818427
  818467
  818869
  819054
  819247
  819249
  823618
  825004
]
1.94 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom beauty"
]
1.77 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom beauty"
]
1.71 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom beauty"
]

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.