Query Metrics
7
Database Queries
7
Different statements
211.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.14 ms (87.53%) |
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 145677 415869 424566 448914 468229 471012 477247 479749 495165 506057 510912 517878 522978 524065 529774 530710 531591 532447 533813 535396 536085 538770 539598 544022 553248 554991 559973 562153 564749 571755 580381 602277 602989 604883 606675 607573 610088 613647 617563 619902 620518 626369 628563 628727 631806 632296 635129 640306 641043 642953 644441 672755 685758 704701 706001 710360 712140 712146 714499 718015 723242 736587 738110 739408 739481 749681 750877 752235 752240 753120 759087 759155 760549 765363 766298 766304 766436 770704 776831 777781 777790 777840 780418 781944 782055 782645 784641 787268 787331 787373 788422 789234 790403 792796 794423 796049 799044 800736 803378 803404 805981 807063 809600 810649 810802 810806 811125 811337 811813 812048 814193 818751 824531 824634 824837 824856 825437 826698 826701 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (7.77%) |
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 766298 631806 704701 712146 723242 780418 782055 805981 807063 766304 811125 477247 506057 522978 824856 825437 824634 538770 564749 580381 672755 706001 571755 626369 604910 619902 602989 790403 781944 685758 811337 510912 628727 471012 562153 826698 824531 824837 536085 524065 529774 604883 632296 787331 810806 787373 753120 800736 145677 415869 814193 479749 530710 535396 532447 544022 554991 714499 710360 712140 718015 606675 607573 617563 628563 640306 610088 613647 620518 641043 642953 777790 782645 788422 796049 799044 810649 810802 812048 776831 777840 803404 752235 752240 770704 784641 787268 789234 792796 811813 738110 750877 759155 736587 739481 765363 739408 766436 749681 759087 760549 602277 635129 777781 803378 809600 468229 553248 448914 517878 559973 424566 794423 644441 826701 818751 539598 495165 531591 533813 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.31%) |
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 145677 415869 424566 448914 468229 471012 477247 479749 495165 506057 510912 517878 522978 524065 529774 530710 531591 532447 533813 535396 536085 538770 539598 544022 553248 554991 559973 562153 564749 571755 580381 602277 602989 604883 606675 607573 610088 613647 617563 619902 620518 626369 628563 628727 631806 632296 635129 640306 641043 642953 644441 672755 685758 704701 706001 710360 712140 712146 714499 718015 723242 736587 738110 739408 739481 749681 750877 752235 752240 753120 759087 759155 760549 765363 766298 766304 766436 770704 776831 777781 777790 777840 780418 781944 782055 782645 784641 787268 787331 787373 788422 789234 790403 792796 794423 796049 799044 800736 803378 803404 805981 807063 809600 810649 810802 810806 811125 811337 811813 812048 814193 818751 824531 824634 824837 824856 825437 826698 826701 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло большие pussy"
]
|
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.