GET https://search.jues.net/search/embeds/9?q=white%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
201.57 ms
(87.30%)
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
  45985
  143235
  152157
  187990
  198644
  236765
  270290
  359062
  383469
  389643
  390914
  393108
  395320
  395754
  399518
  399622
  399627
  399632
  401251
  401489
  401501
  402116
  402128
  402137
  403458
  404261
  404555
  404706
  405224
  406080
  406378
  406387
  406435
  407374
  407500
  407890
  408223
  409220
  409882
  411871
  411884
  413128
  413456
  415346
  415592
  415710
  415790
  416165
  417022
  417206
  420253
  420262
  420834
  424985
  425630
  427550
  428456
  428798
  430621
  432169
  432876
  437833
  439186
  442201
  442661
  443185
  445046
  447793
  448719
  453293
  466963
  467549
  468155
  469476
  471963
  472180
  472913
  475589
  477098
  482346
  482668
  483394
  485912
  488536
  494738
  497404
  499327
  499834
  502724
  504579
  504927
  510299
  512063
  515574
  518814
  518960
  522127
  526078
  533957
  544824
  637503
  724241
  724973
  726162
  726425
  728795
  736949
  743497
  743822
  751821
  756798
  758417
  760031
  760127
  765854
  769575
  770107
  777814
  807911
  808450
]
18.43 ms
(7.98%)
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
  758417
  807911
  808450
  751821
  765854
  769575
  770107
  726425
  743497
  756798
  760031
  726162
  743822
  760127
  724241
  724973
  728795
  736949
  637503
  777814
  143235
  401251
  402116
  404261
  407890
  447793
  453293
  468155
  475589
  45985
  399622
  405224
  415710
  417022
  471963
  472913
  395320
  467549
  477098
  399627
  413128
  415790
  417206
  448719
  406378
  420834
  472180
  483394
  485912
  499327
  504579
  512063
  515574
  522127
  526078
  494738
  499834
  502724
  518814
  411884
  416165
  482668
  544824
  488536
  497404
  518960
  420262
  482346
  466963
  430621
  469476
  427550
  510299
  504927
  533957
  383469
  198644
  236765
  152157
  187990
  393108
  395754
  359062
  270290
  389643
  390914
  399518
  399632
  402137
  401489
  401501
  402128
  403458
  404706
  406435
  406080
  406387
  404555
  407500
  408223
  409220
  425630
  428798
  407374
  420253
  428456
  432169
  437833
  439186
  442201
  442661
  409882
  413456
  415592
  424985
  432876
  445046
  415346
  443185
  411871
]
3.25 ms
(1.41%)
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
  45985
  143235
  152157
  187990
  198644
  236765
  270290
  359062
  383469
  389643
  390914
  393108
  395320
  395754
  399518
  399622
  399627
  399632
  401251
  401489
  401501
  402116
  402128
  402137
  403458
  404261
  404555
  404706
  405224
  406080
  406378
  406387
  406435
  407374
  407500
  407890
  408223
  409220
  409882
  411871
  411884
  413128
  413456
  415346
  415592
  415710
  415790
  416165
  417022
  417206
  420253
  420262
  420834
  424985
  425630
  427550
  428456
  428798
  430621
  432169
  432876
  437833
  439186
  442201
  442661
  443185
  445046
  447793
  448719
  453293
  466963
  467549
  468155
  469476
  471963
  472180
  472913
  475589
  477098
  482346
  482668
  483394
  485912
  488536
  494738
  497404
  499327
  499834
  502724
  504579
  504927
  510299
  512063
  515574
  518814
  518960
  522127
  526078
  533957
  544824
  637503
  724241
  724973
  726162
  726425
  728795
  736949
  743497
  743822
  751821
  756798
  758417
  760031
  760127
  765854
  769575
  770107
  777814
  807911
  808450
]
2.11 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white mom"
]
2.06 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white mom"
]
1.58 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white mom"
]

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.