Query Metrics
7
Database Queries
7
Different statements
159.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.04 ms (84.16%) |
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 381867 389923 390614 397079 399857 415230 416969 420136 424385 447426 450038 453353 467113 478842 482088 487206 488235 499353 509904 521089 521832 524196 527568 528424 528945 529803 541454 541480 544858 553541 554131 566791 584837 586006 588898 596643 598439 598798 616994 617536 618449 618808 623200 623204 624244 635250 640792 644674 646851 651716 651934 651944 655151 661933 672492 673032 674001 674216 675342 675370 682496 691450 691472 694612 695319 697079 700666 703945 703970 704025 708043 720762 722850 727844 728378 730595 739012 740787 741556 743197 746070 747384 748715 753446 762203 763798 764879 766867 767181 767227 768346 768852 769735 769742 769760 769805 770582 770849 770984 771834 772667 772730 776284 776317 779226 789672 790437 793896 797843 799045 800321 804915 807097 807669 812351 814440 818025 824090 827858 827942 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (9.65%) |
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 521832 509904 499353 521089 524196 544858 623200 596643 618449 623204 644674 399857 415230 527568 487206 381867 389923 390614 420136 824090 827858 467113 478842 528424 584837 655151 700666 661933 672492 691472 704025 708043 651716 674001 674216 695319 722850 635250 640792 618808 624244 586006 617536 776284 779226 793896 800321 807097 776317 790437 812351 727844 740787 743197 753446 770582 772730 797843 804915 807669 730595 746070 762203 764879 768346 769742 770849 728378 741556 770984 748715 766867 767181 769735 769760 771834 772667 739012 747384 763798 767227 768852 769805 697079 703945 720762 789672 799045 397079 528945 488235 447426 646851 598439 482088 424385 616994 416969 818025 814440 827942 453353 450038 529803 541454 541480 566791 703970 651934 673032 675342 675370 691450 651944 682496 694612 553541 554131 588898 598798 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.86%) |
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 381867 389923 390614 397079 399857 415230 416969 420136 424385 447426 450038 453353 467113 478842 482088 487206 488235 499353 509904 521089 521832 524196 527568 528424 528945 529803 541454 541480 544858 553541 554131 566791 584837 586006 588898 596643 598439 598798 616994 617536 618449 618808 623200 623204 624244 635250 640792 644674 646851 651716 651934 651944 655151 661933 672492 673032 674001 674216 675342 675370 682496 691450 691472 694612 695319 697079 700666 703945 703970 704025 708043 720762 722850 727844 728378 730595 739012 740787 741556 743197 746070 747384 748715 753446 762203 763798 764879 766867 767181 767227 768346 768852 769735 769742 769760 769805 770582 770849 770984 771834 772667 772730 776284 776317 779226 789672 790437 793896 797843 799045 800321 804915 807097 807669 812351 814440 818025 824090 827858 827942 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red head teen"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая teen"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая teen"
]
|
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.