Query Metrics
7
Database Queries
7
Different statements
164.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.86 ms (85.80%) |
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 3371 3826 73503 79331 150487 388215 391956 392558 398239 516061 529620 530615 537621 590654 617642 629441 632483 638114 638524 652551 652554 671464 681795 683359 689405 690494 690925 692052 692113 692154 693437 693700 694164 699162 701050 704422 704432 706752 710819 712520 714034 717675 720987 722438 725766 725902 728149 730815 730826 730974 732827 733507 734657 738664 740206 744223 744376 745857 745882 748844 749743 749997 750779 759051 759506 759531 760219 760529 761277 761342 762019 765802 766303 767635 768029 768286 768841 775407 776679 777877 779981 780076 780797 782784 783427 783975 785735 786158 787177 789097 790978 791310 791795 791800 793557 794145 795347 799468 799856 800480 803008 804917 810047 810318 811819 812264 818431 819079 819269 819998 823605 825188 825658 825867 826019 826988 827264 827471 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (7.68%) |
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 745882 768841 693437 590654 762019 530615 692154 3826 819079 818431 712520 690494 786158 791310 730974 766303 3371 819998 827471 690925 699162 694164 704432 638524 804917 812264 760219 732827 745857 748844 759051 768029 725766 744376 791795 825867 720987 629441 787177 749997 790978 765802 728149 799468 392558 826019 652551 706752 692052 783427 785735 800480 810047 738664 750779 759531 733507 388215 398239 827264 516061 681795 693700 791800 810318 775407 795347 730826 768748 789097 794145 744223 749743 701050 776679 793557 79331 150487 73503 826988 825658 823605 825188 692113 714034 652554 671464 722438 617642 779981 780076 803008 740206 761277 780797 391956 819269 537621 529620 704422 683359 689405 710819 717675 632483 777877 782784 783975 811819 734657 760529 767635 799856 730815 768286 759506 725902 761342 638114 721975 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.92%) |
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 3371 3826 73503 79331 150487 388215 391956 392558 398239 516061 529620 530615 537621 590654 617642 629441 632483 638114 638524 652551 652554 671464 681795 683359 689405 690494 690925 692052 692113 692154 693437 693700 694164 699162 701050 704422 704432 706752 710819 712520 714034 717675 720987 722438 725766 725902 728149 730815 730826 730974 732827 733507 734657 738664 740206 744223 744376 745857 745882 748844 749743 749997 750779 759051 759506 759531 760219 760529 761277 761342 762019 765802 766303 767635 768029 768286 768841 775407 776679 777877 779981 780076 780797 782784 783427 783975 785735 786158 787177 789097 790978 791310 791795 791800 793557 794145 795347 799468 799856 800480 803008 804917 810047 810318 811819 812264 818431 819079 819269 819998 823605 825188 825658 825867 826019 826988 827264 827471 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple секс"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple sex"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple секс"
]
|
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.