Query Metrics
7
Database Queries
7
Different statements
154.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.78 ms (84.90%) |
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 395699 407797 412132 425523 450224 464213 466138 469823 474505 483366 494036 496805 500482 500622 504189 506820 513927 529234 534692 538968 540792 543359 545075 545946 547085 547132 547147 547172 550002 558696 560017 562058 566370 567953 568172 576678 578722 582001 582840 584211 588285 590848 594547 595070 597106 602667 602700 612037 616556 621780 621782 635735 637543 642458 652627 653355 655693 656834 663446 666007 666037 668135 673924 674606 675347 675694 685130 689068 689779 689930 690081 691373 694180 701214 702155 712644 714546 716380 718150 724681 728918 730129 731126 731157 732842 733058 736239 737969 738113 739346 740789 742953 742986 746057 746307 748430 754235 760949 766008 766451 767690 772010 773454 773960 782815 795311 795321 796774 797033 798843 800828 800916 800996 802376 804545 810034 810304 813715 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (8.55%) |
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 766008 395699 690081 560017 474505 685130 566370 494036 529234 666007 668135 694180 621782 621780 545075 547147 567953 675694 731126 728918 773454 738113 724681 538968 550002 673924 689068 653355 689779 691373 702155 716380 597106 602667 602700 800996 795321 798843 810034 742986 804545 732842 733058 737969 742953 748430 772010 730129 739346 746057 760949 795311 810304 576678 407797 412132 483366 450224 500482 562058 595070 466138 469823 506820 513927 655693 504189 500622 578722 543359 689930 718150 802376 425523 540792 588285 663446 547172 568172 584211 594547 776489 731157 773960 736239 740789 3371 813715 464213 534692 496805 545946 582840 547085 547132 582001 666037 674606 714546 652627 656834 675347 701214 712644 558696 590848 616556 642458 612037 635735 637543 782815 796774 800828 746307 766451 767690 797033 800916 754235 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.73%) |
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 395699 407797 412132 425523 450224 464213 466138 469823 474505 483366 494036 496805 500482 500622 504189 506820 513927 529234 534692 538968 540792 543359 545075 545946 547085 547132 547147 547172 550002 558696 560017 562058 566370 567953 568172 576678 578722 582001 582840 584211 588285 590848 594547 595070 597106 602667 602700 612037 616556 621780 621782 635735 637543 642458 652627 653355 655693 656834 663446 666007 666037 668135 673924 674606 675347 675694 685130 689068 689779 689930 690081 691373 694180 701214 702155 712644 714546 716380 718150 724681 728918 730129 731126 731157 732842 733058 736239 737969 738113 739346 740789 742953 742986 746057 746307 748430 754235 760949 766008 766451 767690 772010 773454 773960 782815 795311 795321 796774 797033 798843 800828 800916 800996 802376 804545 810034 810304 813715 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жена и друг порно"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен друг порн"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.