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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.05 ms
(85.61%)
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
  382184
  383063
  388604
  395922
  400209
  402145
  404644
  407666
  407703
  407709
  409080
  411340
  413182
  417863
  417990
  418996
  421236
  422261
  422345
  422352
  425976
  428895
  433605
  434044
  434251
  437310
  438429
  439549
  439695
  439798
  442469
  443692
  443747
  443942
  443946
  443970
  446087
  446204
  450158
  450399
  451127
  454257
  454432
  454446
  454964
  456061
  457194
  460204
  461727
  462489
  464388
  465331
  466145
  467663
  472299
  472652
  473492
  474778
  474799
  477726
  479038
  482251
  482255
  492366
  493179
  493195
  495229
  496112
  505399
  506127
  506833
  511016
  513376
  513722
  514813
  516476
  517003
  517526
  518046
  518267
  518847
  518856
  518859
  521997
  524262
  524272
  524626
  525273
  526394
  526742
  532044
  549236
  549739
  551923
  555158
  557924
  563141
  563432
  565982
  608350
  609825
  622667
  625493
  659986
  661991
  665492
  697909
  720258
  721724
  729635
  736399
  748210
  756209
  761275
  769487
  800190
  801235
  806084
  808675
  812885
]
13.33 ms
(8.71%)
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
  407709
  456061
  563141
  477726
  450399
  521997
  428895
  439695
  439798
  505399
  472299
  625493
  437310
  454964
  383063
  382184
  407703
  411340
  438429
  443942
  407666
  443970
  417990
  418996
  422261
  422352
  434251
  439549
  442469
  446087
  460204
  474778
  482255
  518856
  495229
  506127
  514813
  517526
  526394
  525273
  496112
  524272
  524626
  526742
  532044
  461727
  467663
  472652
  473492
  492366
  549236
  557924
  551923
  697909
  721724
  555158
  801235
  812885
  736399
  769487
  608350
  609825
  800190
  404644
  409080
  422345
  443747
  482251
  395922
  450158
  413182
  443692
  454257
  465331
  518267
  513376
  518046
  493179
  517003
  518859
  446204
  457194
  462489
  474799
  443946
  466145
  513722
  493195
  400209
  661991
  402145
  388604
  417863
  433605
  425976
  421236
  434044
  451127
  454432
  454446
  479038
  464388
  506833
  511016
  518847
  524262
  516476
  565982
  659986
  665492
  720258
  549739
  563432
  622667
  806084
  808675
  748210
  761275
  729635
  756209
]
2.69 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
  382184
  383063
  388604
  395922
  400209
  402145
  404644
  407666
  407703
  407709
  409080
  411340
  413182
  417863
  417990
  418996
  421236
  422261
  422345
  422352
  425976
  428895
  433605
  434044
  434251
  437310
  438429
  439549
  439695
  439798
  442469
  443692
  443747
  443942
  443946
  443970
  446087
  446204
  450158
  450399
  451127
  454257
  454432
  454446
  454964
  456061
  457194
  460204
  461727
  462489
  464388
  465331
  466145
  467663
  472299
  472652
  473492
  474778
  474799
  477726
  479038
  482251
  482255
  492366
  493179
  493195
  495229
  496112
  505399
  506127
  506833
  511016
  513376
  513722
  514813
  516476
  517003
  517526
  518046
  518267
  518847
  518856
  518859
  521997
  524262
  524272
  524626
  525273
  526394
  526742
  532044
  549236
  549739
  551923
  555158
  557924
  563141
  563432
  565982
  608350
  609825
  622667
  625493
  659986
  661991
  665492
  697909
  720258
  721724
  729635
  736399
  748210
  756209
  761275
  769487
  800190
  801235
  806084
  808675
  812885
]
1.69 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom son natural"
]
1.47 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom son натуральная натуральные"
]
1.30 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom son натуральная натуральные"
]

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.