Query Metrics
7
Database Queries
7
Different statements
165.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.92 ms (86.25%) |
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 46283 382420 389926 393097 396847 397690 401802 419893 461683 490787 517789 521252 523349 526114 530928 540190 542461 548285 555193 555249 555290 555326 555779 556986 557228 557579 563712 568153 581374 587479 607805 620438 620955 622801 623557 625776 625872 627622 627623 628611 630767 638842 640240 642935 644773 648261 653102 654647 677738 691521 694512 696137 699418 700832 704772 708293 708583 714400 714584 716968 718069 718150 719138 720333 721160 724461 725447 726641 729056 730289 732980 734270 734590 734771 737933 738028 739098 742278 744140 746668 746900 748800 751232 754872 761524 768932 773408 780605 788629 788633 788659 794429 794743 795310 798769 800385 800726 808296 811140 816652 819412 820085 821283 821299 821511 821984 822158 822622 823322 823516 823517 823653 823946 823968 824797 825664 826739 827507 827546 ] |
||||||||||||||||||||||||||||||
|
12.36 ms (7.46%) |
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 389926 397690 816652 819412 822158 824797 821299 823946 827507 827546 820085 821283 821984 823322 823516 823968 821511 822622 823517 823653 825664 490787 540190 521252 523349 530928 568153 555249 555326 557228 563712 581374 542461 548285 555779 557579 648261 653102 696137 704772 708293 708583 714584 719138 677738 700832 714400 721160 654647 691521 694512 699418 718150 720333 555193 555290 556986 587479 607805 620438 622801 625776 623557 627622 620955 628611 640240 644773 597860 627623 630767 638842 780605 788659 795310 800726 725447 738028 742278 744140 746900 761524 794429 800385 811140 732980 734590 768932 724461 734771 739098 748800 734270 754872 773408 726641 730289 737933 746668 751232 625872 642935 716968 718069 788629 788633 794743 798769 808296 46283 396847 401802 382420 393097 419893 526114 517789 729056 826739 461683 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.58%) |
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 46283 382420 389926 393097 396847 397690 401802 419893 461683 490787 517789 521252 523349 526114 530928 540190 542461 548285 555193 555249 555290 555326 555779 556986 557228 557579 563712 568153 581374 587479 607805 620438 620955 622801 623557 625776 625872 627622 627623 628611 630767 638842 640240 642935 644773 648261 653102 654647 677738 691521 694512 696137 699418 700832 704772 708293 708583 714400 714584 716968 718069 718150 719138 720333 721160 724461 725447 726641 729056 730289 732980 734270 734590 734771 737933 738028 739098 742278 744140 746668 746900 748800 751232 754872 761524 768932 773408 780605 788629 788633 788659 794429 794743 795310 798769 800385 800726 808296 811140 816652 819412 820085 821283 821299 821511 821984 822158 822622 823322 823516 823517 823653 823946 823968 824797 825664 826739 827507 827546 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy sperm"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая сперм"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.87%) |
1 |
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.