Query Metrics
7
Database Queries
7
Different statements
160.06 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.02 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женская мастурбация в анус"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.77 ms |
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 824766 546057 624751 182110 100685 414082 803092 529597 671652 707895 781564 783428 443106 583665 653503 456699 661034 668305 600450 804639 390640 667324 819425 822108 827487 820171 817352 477620 555769 566739 555779 576496 657561 661411 682379 692094 671446 589621 590038 642004 632026 790009 734380 810085 727293 767745 723934 734966 758977 725608 745807 802152 233443 736971 820839 813635 823719 821434 826804 469224 500320 539030 548973 568530 583460 541722 656557 656812 658845 661676 663842 671094 656144 663211 683284 686139 687810 715887 722378 655163 656826 656938 672937 674307 679563 680801 691584 707819 715700 720369 548969 554827 576534 600423 641714 612976 634027 590372 623275 624409 634261 639950 590692 785855 793266 800528 777633 782436 782782 783102 791181 801309 803101 734443 736809 752752 760436 765097 788529 794541 ] |
||||||||||||||||||||||||||||||
| 4 | 2.84 ms |
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 100685 182110 233443 390640 414082 443106 456699 469224 477620 500320 529597 539030 541722 546057 548969 548973 554827 555769 555779 566739 568530 576496 576534 583460 583665 589621 590038 590372 590692 600423 600450 612976 623275 624409 624751 632026 634027 634261 639950 641714 642004 653503 655163 656144 656557 656812 656826 656938 657561 658845 661034 661411 661676 663211 663842 667324 668305 671094 671446 671652 672937 674307 679563 680801 682379 683284 686139 687810 691584 692094 707819 707895 715700 715887 720369 722378 723934 725608 727293 734380 734443 734966 736809 736971 745807 752752 758977 760436 765097 767745 777633 781564 782436 782782 783102 783428 785855 788529 790009 791181 793266 794541 800528 801309 802152 803092 803101 804639 810085 813635 817352 819425 820171 820839 821434 822108 823719 824766 826804 827487 ] |
||||||||||||||||||||||||||||||
| 5 | 135.05 ms |
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 100685 182110 233443 390640 414082 443106 456699 469224 477620 500320 529597 539030 541722 546057 548969 548973 554827 555769 555779 566739 568530 576496 576534 583460 583665 589621 590038 590372 590692 600423 600450 612976 623275 624409 624751 632026 634027 634261 639950 641714 642004 653503 655163 656144 656557 656812 656826 656938 657561 658845 661034 661411 661676 663211 663842 667324 668305 671094 671446 671652 672937 674307 679563 680801 682379 683284 686139 687810 691584 692094 707819 707895 715700 715887 720369 722378 723934 725608 727293 734380 734443 734966 736809 736971 745807 752752 758977 760436 765097 767745 777633 781564 782436 782782 783102 783428 785855 788529 790009 791181 793266 794541 800528 801309 802152 803092 803101 804639 810085 813635 817352 819425 820171 820839 821434 822108 823719 824766 826804 827487 ] |
||||||||||||||||||||||||||||||
| 6 | 1.90 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женск мастурбац анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.80 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.