Query Metrics
7
Database Queries
7
Different statements
188.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.22 ms (85.47%) |
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 6768 427117 455165 455361 456357 460398 461075 469643 472742 479712 481052 483968 500885 511087 512142 514627 528600 544783 545584 547656 548143 549051 555642 576744 581585 584469 587301 588121 588236 588798 596548 602780 603198 621823 632428 635858 646052 652522 682399 691178 697234 699317 699950 703604 709504 714281 715246 716720 717886 718326 719449 720311 720323 724306 728326 728406 730030 730402 731285 732189 735207 736428 736678 738181 738836 739417 741787 742875 743464 744791 749442 750789 753074 755144 760981 765142 766495 766971 769258 771602 773572 777649 778145 778790 779846 780288 781100 781622 782115 783379 784267 785229 786090 787050 788992 791374 791454 791513 793221 794792 795247 795765 797364 797416 798798 799477 800462 800739 801037 809808 810012 810535 811151 812860 817990 818058 819261 823704 825201 827436 ] |
||||||||||||||||||||||||||||||
|
17.70 ms (9.38%) |
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 799477 810012 456357 427117 512142 6768 823704 481052 511087 544783 545584 699317 714281 682399 703604 720311 588121 603198 621823 588798 793221 778790 785229 738181 809808 460398 817990 827436 819261 818058 825201 472742 479712 514627 469643 576744 584469 547656 548143 549051 555642 581585 652522 716720 718326 697234 709504 720323 699950 715246 719449 587301 588236 596548 632428 635858 779846 780288 781622 784267 786090 787050 791454 795247 795765 800462 801037 811151 778145 788992 791374 797416 730402 735207 736428 755144 769258 773572 782115 783379 797364 798798 800739 810535 812860 728406 744791 760981 765142 724306 736678 739417 750789 771602 728326 730030 732189 741787 742875 766495 731285 738836 743464 749442 753074 766971 602780 717886 777649 781100 791513 794792 455361 461075 455165 528600 483968 500885 646052 691178 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.53%) |
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 6768 427117 455165 455361 456357 460398 461075 469643 472742 479712 481052 483968 500885 511087 512142 514627 528600 544783 545584 547656 548143 549051 555642 576744 581585 584469 587301 588121 588236 588798 596548 602780 603198 621823 632428 635858 646052 652522 682399 691178 697234 699317 699950 703604 709504 714281 715246 716720 717886 718326 719449 720311 720323 724306 728326 728406 730030 730402 731285 732189 735207 736428 736678 738181 738836 739417 741787 742875 743464 744791 749442 750789 753074 755144 760981 765142 766495 766971 769258 771602 773572 777649 778145 778790 779846 780288 781100 781622 782115 783379 784267 785229 786090 787050 788992 791374 791454 791513 793221 794792 795247 795765 797364 797416 798798 799477 800462 800739 801037 809808 810012 810535 811151 812860 817990 818058 819261 823704 825201 827436 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend amateur"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend любительск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
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.