Query Metrics
7
Database Queries
7
Different statements
170.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.06 ms (85.43%) |
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 384562 386567 402032 404470 428877 451608 457001 465123 466817 486830 507481 511199 525367 528334 531879 538448 542167 554121 567984 570145 575344 579528 579650 584691 590105 598302 601955 603919 604287 610109 616429 616473 616505 617552 618712 624994 630239 633999 646964 647682 648744 651800 658728 663250 664634 666697 668713 673102 677921 683092 683560 684513 692103 697108 698496 702006 702047 702971 705385 708680 711637 714175 716115 717130 718491 718492 719210 720090 720407 720536 722127 722833 730301 735866 740185 744283 745765 749522 750626 760597 767793 774295 774883 775679 778032 779114 779365 781370 781978 783194 787997 788111 789455 789926 790514 791681 792578 793257 795157 795628 796027 796055 797728 800702 801419 801839 802106 802879 804100 806025 809503 810147 810414 811428 814285 819110 823813 824164 826883 ] |
||||||||||||||||||||||||||||||
|
14.96 ms (8.75%) |
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 601955 603919 697108 698496 702971 705385 714175 718492 720536 775679 779114 781370 793257 795157 801419 801839 802879 804100 811428 402032 384562 466817 404470 386567 428877 814285 819110 824164 827961 823813 826883 486830 451608 465123 457001 511199 525367 528334 538448 507481 531879 567984 575344 542167 554121 570145 584691 579650 648744 658728 663250 666697 668713 692103 702006 711637 718491 720407 722127 722833 646964 651800 664634 673102 684513 708680 717130 720090 647682 677921 683092 683560 702047 716115 719210 579528 610109 616505 617552 630239 633999 590105 604287 616429 618712 624994 598302 616473 774883 781978 787997 788111 790514 795628 806025 778032 779365 791681 796027 796055 800702 809503 810147 744283 745765 750626 760597 774295 783194 789455 789926 792578 797728 802106 810414 730301 735866 740185 749522 767793 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.61%) |
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 384562 386567 402032 404470 428877 451608 457001 465123 466817 486830 507481 511199 525367 528334 531879 538448 542167 554121 567984 570145 575344 579528 579650 584691 590105 598302 601955 603919 604287 610109 616429 616473 616505 617552 618712 624994 630239 633999 646964 647682 648744 651800 658728 663250 664634 666697 668713 673102 677921 683092 683560 684513 692103 697108 698496 702006 702047 702971 705385 708680 711637 714175 716115 717130 718491 718492 719210 720090 720407 720536 722127 722833 730301 735866 740185 744283 745765 749522 750626 760597 767793 774295 774883 775679 778032 779114 779365 781370 781978 783194 787997 788111 789455 789926 790514 791681 792578 793257 795157 795628 796027 796055 797728 800702 801419 801839 802106 802879 804100 806025 809503 810147 810414 811428 814285 819110 823813 824164 826883 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hard"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy hard"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy hard"
]
|
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.