Query Metrics
7
Database Queries
7
Different statements
198.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.71 ms (86.81%) |
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 88505 361665 387886 389585 398112 398331 403890 404101 414072 420866 423637 433928 434877 449283 464239 469194 480469 483702 532070 535207 535871 546086 552988 559311 583194 595746 610599 634066 638956 642992 642996 662437 666414 683840 687398 691388 695552 695882 696334 698144 698381 699519 702470 703011 706704 712257 717782 718232 725521 726578 728694 729056 734330 735006 735430 735493 735520 735535 736349 739598 739920 739967 740280 741677 744695 744834 747488 748297 748306 748429 748963 750633 751843 756200 756849 760573 761447 762045 764782 766317 767474 767483 768876 773152 776084 777738 777829 777834 777883 778222 778862 780165 781515 783169 783246 783290 783928 783945 784663 785553 785650 787282 788537 791866 792993 794695 802166 802264 803026 805261 808048 809640 809917 809939 811538 814964 816169 824860 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (7.50%) |
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 747488 767474 781515 809640 728694 735430 739920 744834 748297 773295 726578 729056 735520 751843 756200 725521 739598 748963 762045 739967 744695 761441 761447 764782 766317 638956 703011 717782 718232 777829 783246 788537 809939 423637 480469 449283 389585 387886 398331 403890 420866 434877 816169 824860 814964 464239 535207 535871 532070 552988 559311 583194 546086 666414 691388 695882 696334 699519 702470 662437 695552 698144 712257 683840 687398 698381 706704 634066 595746 610599 642996 776084 780165 783290 785553 794695 805261 777738 778222 778862 792993 734330 756849 767483 783169 783928 783945 785650 787282 791866 802264 803026 811538 735493 736349 740280 748306 741677 735535 760573 768876 773152 735006 748429 750633 642992 777834 777883 784663 802166 808048 809917 361665 414072 433928 469194 398112 483702 88505 404101 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.76%) |
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 88505 361665 387886 389585 398112 398331 403890 404101 414072 420866 423637 433928 434877 449283 464239 469194 480469 483702 532070 535207 535871 546086 552988 559311 583194 595746 610599 634066 638956 642992 642996 662437 666414 683840 687398 691388 695552 695882 696334 698144 698381 699519 702470 703011 706704 712257 717782 718232 725521 726578 728694 729056 734330 735006 735430 735493 735520 735535 736349 739598 739920 739967 740280 741677 744695 744834 747488 748297 748306 748429 748963 750633 751843 756200 756849 760573 761447 762045 764782 766317 767474 767483 768876 773152 776084 777738 777829 777834 777883 778222 778862 780165 781515 783169 783246 783290 783928 783945 784663 785553 785650 787282 788537 791866 792993 794695 802166 802264 803026 805261 808048 809640 809917 809939 811538 814964 816169 824860 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"female on female"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"female female"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"female female"
]
|
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.