Query Metrics
7
Database Queries
7
Different statements
197.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.99 ms (88.10%) |
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 390192 398712 401820 402015 417564 422286 424916 443565 443619 446086 451033 459580 459965 460387 461693 462895 466555 467599 468217 469675 469689 470529 470678 475945 476853 479507 483403 483437 500084 502136 504295 508423 508854 510759 510762 511597 512227 514280 516662 520754 522003 522640 523788 524888 533678 533690 539412 543412 543923 544196 544766 545139 546802 548757 549783 550280 552005 552251 557473 557937 557954 558790 559629 560335 564145 564390 565749 571134 571373 572315 575298 577690 579635 585694 587661 588165 591907 593853 595757 600725 601507 602504 603870 605525 606908 614829 614830 619885 620055 625089 625682 627706 639219 642521 647951 653601 669700 694166 712631 714193 715116 715518 730372 745257 745906 748454 749063 762468 765221 765841 773965 784186 784511 785394 790679 793448 797871 798099 811770 812564 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (7.11%) |
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 605525 784186 798099 784511 785394 745906 749063 765221 773965 614829 715518 790679 462895 424916 468217 469689 508423 533690 500084 483437 558790 575298 714193 564145 593853 600725 745257 762468 466555 390192 398712 401820 512227 564390 571373 544766 647951 653601 669700 588165 585694 601507 602504 625089 625682 627706 504295 552005 524888 479507 557954 587661 591907 620055 470678 443619 459965 446086 460387 502136 510762 523788 543923 545139 543412 550280 571134 579635 712631 546802 557473 577690 642521 606908 748454 639219 461693 470529 508854 510759 522640 422286 476853 475945 516662 520754 467599 560335 565749 715116 603870 793448 811770 797871 812564 765841 730372 417564 451033 511597 483403 402015 522003 559629 614830 619885 552251 459580 694166 469675 443565 533678 514280 539412 544196 557937 572315 549783 548757 595757 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.39%) |
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 390192 398712 401820 402015 417564 422286 424916 443565 443619 446086 451033 459580 459965 460387 461693 462895 466555 467599 468217 469675 469689 470529 470678 475945 476853 479507 483403 483437 500084 502136 504295 508423 508854 510759 510762 511597 512227 514280 516662 520754 522003 522640 523788 524888 533678 533690 539412 543412 543923 544196 544766 545139 546802 548757 549783 550280 552005 552251 557473 557937 557954 558790 559629 560335 564145 564390 565749 571134 571373 572315 575298 577690 579635 585694 587661 588165 591907 593853 595757 600725 601507 602504 603870 605525 606908 614829 614830 619885 620055 625089 625682 627706 639219 642521 647951 653601 669700 694166 712631 714193 715116 715518 730372 745257 745906 748454 749063 762468 765221 765841 773965 784186 784511 785394 790679 793448 797871 798099 811770 812564 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur friends"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск friends"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск friends"
]
|
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.