Query Metrics
7
Database Queries
7
Different statements
154.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.20 ms (88.77%) |
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 382187 387426 402134 408624 418801 465104 545862 545967 551594 582013 592441 596142 602226 602600 603441 625841 632282 633692 640115 664604 670783 684677 684678 688696 689879 699485 708639 723364 726452 735542 738100 738249 738513 740554 740930 741150 741224 742333 743148 743164 744125 744195 744342 744555 745567 745660 745665 747708 748268 748313 748894 749049 749071 749388 749572 751395 751436 752319 752503 752893 753574 753576 753604 753643 753650 753658 754364 754400 754478 754529 754530 754640 754725 754979 754980 754984 755251 756148 756512 757509 758324 759073 760427 760587 760704 761206 766432 768430 768848 768920 769538 770081 771629 771756 774113 775152 777424 779368 780247 783388 785401 786186 787601 788238 790478 790758 791038 802237 803109 803140 804826 805718 806581 810761 812200 812219 812245 812358 812466 813712 ] |
||||||||||||||||||||||||||||||
|
8.75 ms (5.66%) |
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 812245 744195 744555 748313 749572 752319 752893 753574 753650 753658 754725 754984 756148 766432 735542 738513 741224 742333 743148 745567 745665 749071 753576 753604 754400 754478 754530 754979 754980 755251 759073 760427 760587 761206 768848 768920 774113 738249 740554 744125 745660 747708 748268 748894 751436 752503 753643 754529 754640 756512 757509 760704 768430 769538 770081 726452 738100 740930 741150 744342 749049 749388 751395 754364 758324 771629 771756 602226 603441 625841 632282 633692 640115 699485 708639 723364 775152 777424 779368 780247 783388 785401 786186 787601 788238 790478 790758 791038 802237 803109 804826 805718 806581 810761 812200 812219 812466 382187 408624 387426 402134 418801 813712 465104 582013 551594 545967 684677 688696 670783 664604 684678 689879 545862 596142 602600 592441 803140 812358 743164 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.46%) |
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 382187 387426 402134 408624 418801 465104 545862 545967 551594 582013 592441 596142 602226 602600 603441 625841 632282 633692 640115 664604 670783 684677 684678 688696 689879 699485 708639 723364 726452 735542 738100 738249 738513 740554 740930 741150 741224 742333 743148 743164 744125 744195 744342 744555 745567 745660 745665 747708 748268 748313 748894 749049 749071 749388 749572 751395 751436 752319 752503 752893 753574 753576 753604 753643 753650 753658 754364 754400 754478 754529 754530 754640 754725 754979 754980 754984 755251 756148 756512 757509 758324 759073 760427 760587 760704 761206 766432 768430 768848 768920 769538 770081 771629 771756 774113 775152 777424 779368 780247 783388 785401 786186 787601 788238 790478 790758 791038 802237 803109 803140 804826 805718 806581 810761 812200 812219 812245 812358 812466 813712 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло соло"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo solo"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло соло"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.