GET https://search.jues.net/search/embeds/9?q=chubby%20natural

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.06 ms
(85.34%)
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
  6813
  20431
  25646
  25650
  79781
  110772
  116623
  152762
  186592
  207824
  210355
  233330
  325228
  332778
  382193
  382743
  382947
  383267
  383493
  383671
  384430
  385267
  385751
  385933
  388555
  389829
  392107
  394521
  397173
  397771
  400034
  400820
  401007
  406307
  414349
  444917
  452651
  454440
  472119
  472665
  473391
  474087
  476230
  486024
  489922
  491765
  492972
  501724
  507056
  507096
  509261
  512125
  519143
  520664
  520667
  520698
  526051
  527424
  528710
  551111
  556604
  561890
  564398
  567758
  569298
  570759
  571828
  582433
  582444
  589730
  591626
  593047
  601096
  602210
  604396
  608153
  609083
  627147
  629600
  629956
  631610
  634839
  635501
  644849
  667250
  667869
  697496
  701212
  715275
  733037
  744218
  763546
  772119
  774440
  793950
  794188
  794226
  795976
  796799
  797241
  800925
  800932
  803738
  807784
  818692
  819327
  819348
  823777
  823978
  824088
  825062
  825398
  826017
  826217
  826283
  826388
  826481
  826497
  826602
  826603
]
17.82 ms
(9.16%)
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
  629956
  635501
  793950
  794226
  796799
  800925
  800932
  803738
  807784
  233330
  414349
  210355
  382947
  6813
  385933
  400034
  385267
  406307
  644849
  589730
  491765
  454440
  509261
  512125
  520698
  526051
  528710
  507096
  520664
  520667
  474087
  476230
  567758
  582444
  561890
  569298
  570759
  571828
  582433
  551111
  564398
  667250
  667869
  608153
  604396
  627147
  593047
  609083
  797241
  389829
  452651
  383671
  401007
  400820
  472119
  444917
  472665
  507056
  486024
  519143
  492972
  527424
  385751
  207824
  394521
  25646
  823777
  489922
  397771
  501724
  556604
  715275
  602210
  629600
  591626
  601096
  631610
  795976
  772119
  733037
  794188
  110772
  186592
  697496
  701212
  634839
  744218
  763546
  473391
  383267
  383493
  382743
  384430
  116623
  152762
  392107
  325228
  332778
  382193
  20431
  25650
  79781
  388555
  397173
  819327
  819348
  823978
  824088
  825062
  826017
  826217
  826283
  774440
  826481
  826497
  826388
  826602
  826603
  825398
  818692
]
2.96 ms
(1.52%)
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
  6813
  20431
  25646
  25650
  79781
  110772
  116623
  152762
  186592
  207824
  210355
  233330
  325228
  332778
  382193
  382743
  382947
  383267
  383493
  383671
  384430
  385267
  385751
  385933
  388555
  389829
  392107
  394521
  397173
  397771
  400034
  400820
  401007
  406307
  414349
  444917
  452651
  454440
  472119
  472665
  473391
  474087
  476230
  486024
  489922
  491765
  492972
  501724
  507056
  507096
  509261
  512125
  519143
  520664
  520667
  520698
  526051
  527424
  528710
  551111
  556604
  561890
  564398
  567758
  569298
  570759
  571828
  582433
  582444
  589730
  591626
  593047
  601096
  602210
  604396
  608153
  609083
  627147
  629600
  629956
  631610
  634839
  635501
  644849
  667250
  667869
  697496
  701212
  715275
  733037
  744218
  763546
  772119
  774440
  793950
  794188
  794226
  795976
  796799
  797241
  800925
  800932
  803738
  807784
  818692
  819327
  819348
  823777
  823978
  824088
  825062
  825398
  826017
  826217
  826283
  826388
  826481
  826497
  826602
  826603
]
2.20 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby natural"
]
1.81 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby натуральная натуральные"
]
1.81 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby натуральная натуральные"
]

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.