Query Metrics
7
Database Queries
7
Different statements
207.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.57 ms (87.97%) |
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 65277 79031 389033 389788 396863 397808 441994 447139 468408 478091 493805 497382 498604 530462 532708 543571 545449 547380 547469 547479 548443 566845 576590 580119 588357 601509 604240 624159 626930 643671 644861 646624 655247 656801 661959 677203 680435 695892 698230 699225 699404 706133 707089 709922 710736 713163 714711 718041 720449 720742 722998 727731 727741 729073 729115 730340 740241 742342 745135 748362 752587 752709 756351 757716 758807 759759 759921 760901 761085 761119 761185 761614 762085 762216 762805 764147 764757 766087 766703 766822 766910 766915 767235 775211 778246 778298 778731 778882 783433 784170 784821 791601 791681 793206 793838 794124 794781 794853 795300 795702 795707 796149 796178 798633 800569 800807 801090 804899 805310 805509 806622 807126 809816 810125 811710 813015 818635 826241 ] |
||||||||||||||||||||||||||||||
|
15.23 ms (7.34%) |
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 548443 543571 547380 706133 547469 580119 588357 624159 793838 795702 796149 791601 791681 800807 730340 766087 800569 805509 810125 758807 766915 759759 752709 718041 795707 809816 532708 656801 680435 397808 793206 796178 804899 644861 791945 396863 826241 447139 497382 530462 545449 547479 566845 720742 655247 709922 714711 576590 643671 626930 778246 778298 813015 752587 767235 794853 811710 761085 762216 762805 742342 727741 729115 745135 757716 764757 740241 761119 775211 778731 778882 79031 604240 784821 646624 677203 601509 389788 441994 818635 478091 468408 699404 661959 805310 807126 795300 798633 729073 759921 761614 783433 794124 794781 801090 806622 766703 760901 762085 764183 761185 766822 756351 764147 784170 493805 748362 389033 720449 722998 766910 695892 707089 713163 727731 698230 699225 710736 498604 65277 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.14%) |
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 65277 79031 389033 389788 396863 397808 441994 447139 468408 478091 493805 497382 498604 530462 532708 543571 545449 547380 547469 547479 548443 566845 576590 580119 588357 601509 604240 624159 626930 643671 644861 646624 655247 656801 661959 677203 680435 695892 698230 699225 699404 706133 707089 709922 710736 713163 714711 718041 720449 720742 722998 727731 727741 729073 729115 730340 740241 742342 745135 748362 752587 752709 756351 757716 758807 759759 759921 760901 761085 761119 761185 761614 762085 762216 762805 764147 764757 766087 766703 766822 766910 766915 767235 775211 778246 778298 778731 778882 783433 784170 784821 791601 791681 793206 793838 794124 794781 794853 795300 795702 795707 796149 796178 798633 800569 800807 801090 804899 805310 805509 806622 807126 809816 810125 811710 813015 818635 826241 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в попу домашние"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.