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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.99 ms
(77.77%)
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
  334847
  382184
  382918
  383063
  385376
  395142
  395556
  395924
  397217
  397999
  398243
  400134
  401978
  403003
  403907
  407682
  407709
  407710
  417990
  421236
  421875
  422243
  422255
  428539
  428895
  429528
  433977
  437361
  439549
  439695
  439698
  442469
  443158
  443182
  443184
  444044
  444468
  445709
  446622
  446968
  448459
  450147
  450995
  455957
  456605
  457200
  458018
  458378
  458928
  460156
  460195
  460658
  460677
  463624
  464423
  464446
  464556
  466709
  472299
  474498
  477110
  477987
  486896
  495225
  496292
  502812
  502813
  505973
  506136
  511016
  513707
  513784
  517282
  518341
  518847
  520916
  521473
  521490
  523031
  523829
  524262
  524284
  524289
  524486
  524652
  524655
  526728
  532004
  532056
  533425
  537126
  538002
  550223
  550643
  554897
  557551
  562952
  563423
  563432
  566928
  579209
  608415
  610587
  619717
  622665
  663772
  665492
  689002
  699604
  723945
  723955
  724045
  724456
  727891
  743431
  744184
  744563
  753148
  769536
]
25.05 ms
(15.58%)
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
  505973
  382918
  395142
  395924
  395556
  398243
  397999
  401978
  407682
  428539
  429528
  407710
  437361
  443182
  445709
  450147
  457200
  446622
  460156
  464446
  464556
  486896
  450995
  458018
  464423
  466709
  513784
  524289
  532004
  524652
  506136
  532056
  460195
  554897
  579209
  550223
  550643
  716936
  663772
  689002
  562952
  563423
  608415
  622665
  723955
  724045
  727891
  744184
  724456
  743431
  744563
  769536
  723945
  753148
  699604
  448459
  477987
  400134
  334847
  474498
  477110
  521473
  523031
  496292
  518341
  526728
  521490
  524655
  513707
  460658
  472299
  421236
  458378
  517282
  502812
  557551
  665492
  610587
  524486
  428895
  439695
  524284
  523829
  385376
  444468
  443158
  446968
  455957
  456605
  458928
  537126
  511016
  518847
  524262
  533425
  460677
  563432
  566928
  619717
  422243
  463624
  421875
  433977
  439698
  444044
  443184
  538002
  502813
  495225
  520916
  383063
  382184
  397217
  403003
  403907
  407709
  422255
  417990
  439549
  442469
]
3.53 ms
(2.19%)
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
  334847
  382184
  382918
  383063
  385376
  395142
  395556
  395924
  397217
  397999
  398243
  400134
  401978
  403003
  403907
  407682
  407709
  407710
  417990
  421236
  421875
  422243
  422255
  428539
  428895
  429528
  433977
  437361
  439549
  439695
  439698
  442469
  443158
  443182
  443184
  444044
  444468
  445709
  446622
  446968
  448459
  450147
  450995
  455957
  456605
  457200
  458018
  458378
  458928
  460156
  460195
  460658
  460677
  463624
  464423
  464446
  464556
  466709
  472299
  474498
  477110
  477987
  486896
  495225
  496292
  502812
  502813
  505973
  506136
  511016
  513707
  513784
  517282
  518341
  518847
  520916
  521473
  521490
  523031
  523829
  524262
  524284
  524289
  524486
  524652
  524655
  526728
  532004
  532056
  533425
  537126
  538002
  550223
  550643
  554897
  557551
  562952
  563423
  563432
  566928
  579209
  608415
  610587
  619717
  622665
  663772
  665492
  689002
  699604
  723945
  723955
  724045
  724456
  727891
  743431
  744184
  744563
  753148
  769536
]
2.17 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public mom son"
]
1.77 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на mom улиц son"
]
1.54 ms
(0.96%)
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.