GET https://search.jues.net/search/embeds/10?q=couple%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.96 ms
(82.79%)
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
  150495
  239112
  389893
  400539
  416859
  416894
  423978
  427490
  427591
  434781
  438533
  439899
  440347
  440701
  440992
  444403
  444601
  446833
  453422
  455179
  455377
  456581
  456954
  456964
  459530
  461174
  462022
  463051
  463070
  463360
  463379
  466907
  468858
  472042
  474041
  474910
  479128
  482583
  482774
  482951
  483346
  489178
  493528
  495433
  495844
  496686
  498763
  499720
  501518
  502454
  504171
  507189
  507456
  509545
  518479
  518537
  520921
  521364
  522963
  523069
  524540
  524888
  525544
  526352
  526362
  529512
  532384
  533665
  537449
  537815
  544021
  545848
  552697
  553923
  553931
  558582
  560447
  564372
  578126
  579974
  588037
  588277
  589110
  590306
  592114
  593664
  593840
  594500
  595114
  595806
  598227
  598466
  599536
  604254
  608037
  610666
  619630
  622856
  625294
  631503
  632308
  635050
  642525
  644397
  670062
  679657
  680422
  691724
  712281
  720438
  722996
  741756
  741762
  742670
  743564
  750904
  752170
  753058
  770606
  814987
]
18.92 ms
(10.73%)
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
  482774
  622856
  455377
  498763
  592114
  770606
  722996
  389893
  239112
  416894
  456954
  518479
  518537
  525544
  691724
  598227
  741756
  741762
  752170
  750904
  644397
  502454
  489178
  456964
  466907
  670062
  753058
  608037
  439899
  520921
  537815
  590306
  742670
  479128
  529512
  400539
  427490
  427591
  440701
  444403
  416859
  438533
  444601
  440992
  440347
  814987
  456581
  463051
  482583
  459530
  463070
  482951
  446833
  455179
  472042
  493528
  504171
  507456
  521364
  532384
  533665
  495433
  499720
  507189
  522963
  523069
  495844
  501518
  509545
  524888
  526352
  496686
  524540
  526362
  537449
  461174
  483346
  545848
  553931
  558582
  560447
  564372
  544021
  578126
  579974
  679657
  680422
  720438
  552697
  553923
  593840
  588277
  593664
  594500
  595806
  599536
  604254
  642525
  595114
  619630
  631503
  632308
  588037
  589110
  598466
  625294
  743564
  610666
  635050
  712281
  150495
  462022
  463360
  463379
  474041
  474910
  434781
  468858
  423978
  453422
]
2.91 ms
(1.65%)
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
  150495
  239112
  389893
  400539
  416859
  416894
  423978
  427490
  427591
  434781
  438533
  439899
  440347
  440701
  440992
  444403
  444601
  446833
  453422
  455179
  455377
  456581
  456954
  456964
  459530
  461174
  462022
  463051
  463070
  463360
  463379
  466907
  468858
  472042
  474041
  474910
  479128
  482583
  482774
  482951
  483346
  489178
  493528
  495433
  495844
  496686
  498763
  499720
  501518
  502454
  504171
  507189
  507456
  509545
  518479
  518537
  520921
  521364
  522963
  523069
  524540
  524888
  525544
  526352
  526362
  529512
  532384
  533665
  537449
  537815
  544021
  545848
  552697
  553923
  553931
  558582
  560447
  564372
  578126
  579974
  588037
  588277
  589110
  590306
  592114
  593664
  593840
  594500
  595114
  595806
  598227
  598466
  599536
  604254
  608037
  610666
  619630
  622856
  625294
  631503
  632308
  635050
  642525
  644397
  670062
  679657
  680422
  691724
  712281
  720438
  722996
  741756
  741762
  742670
  743564
  750904
  752170
  753058
  770606
  814987
]
2.27 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "couple wife"
]
2.19 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "couple жен"
]
2.10 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "couple жен"
]
1.95 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.