Query Metrics
7
Database Queries
7
Different statements
157.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.52 ms (83.14%) |
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 425641 428877 433981 435647 438513 438694 439011 453652 455242 460563 477202 479421 487466 495097 496424 509770 512144 514416 514583 521603 524179 525296 530554 533464 533892 537042 538455 556066 556113 558638 562009 562085 562409 564843 567204 567232 572274 583265 585797 587968 588480 590982 602714 610499 610522 625544 626122 626193 635367 637183 638490 639551 645599 645626 659061 659416 659430 661350 667813 676192 689169 694715 698027 698028 698248 701904 702257 703564 705043 706471 709510 710467 717490 718933 722230 724074 724898 725675 727095 730750 731038 732131 736690 736745 739550 740533 740996 741932 749113 749740 750916 751846 753623 755649 756436 757175 764606 765343 765625 767454 767611 770595 771043 777278 778870 778975 781519 783735 784228 785678 792690 792878 795479 798788 799342 801443 801669 802910 814181 817151 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (9.79%) |
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 590982 639551 730750 562085 701904 635367 638490 637183 588480 509770 530554 487466 533892 587968 784228 724074 731038 753623 732131 739550 428877 453652 556066 740533 741932 749113 736745 765625 702257 433981 514416 538455 799342 802910 777278 438513 755649 736690 727095 750916 718933 795479 785678 495097 477202 512144 533464 567204 659430 706471 698248 610499 438694 514583 705043 698027 556113 435647 659061 717490 756436 770595 781519 767611 771043 778975 792690 583265 722230 724898 751846 765343 740996 778870 479421 455242 572274 792878 801443 725675 425641 439011 817151 667813 798788 801669 783735 757175 767454 764606 749740 460563 524179 525296 562009 564843 562409 659416 645599 661350 710467 689169 698028 558638 610522 625544 703564 496424 694715 585797 626193 602714 709510 676192 814181 537042 521603 567232 645626 626122 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.65%) |
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 425641 428877 433981 435647 438513 438694 439011 453652 455242 460563 477202 479421 487466 495097 496424 509770 512144 514416 514583 521603 524179 525296 530554 533464 533892 537042 538455 556066 556113 558638 562009 562085 562409 564843 567204 567232 572274 583265 585797 587968 588480 590982 602714 610499 610522 625544 626122 626193 635367 637183 638490 639551 645599 645626 659061 659416 659430 661350 667813 676192 689169 694715 698027 698028 698248 701904 702257 703564 705043 706471 709510 710467 717490 718933 722230 724074 724898 725675 727095 730750 731038 732131 736690 736745 739550 740533 740996 741932 749113 749740 750916 751846 753623 755649 756436 757175 764606 765343 765625 767454 767611 770595 771043 777278 778870 778975 781519 783735 784228 785678 792690 792878 795479 798788 799342 801443 801669 802910 814181 817151 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"parents homemade"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"parents домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"parents домашн любительск"
]
|
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.