Query Metrics
7
Database Queries
7
Different statements
179.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.19 ms (86.57%) |
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 266134 390041 393097 395863 402518 435931 445892 446701 453497 457640 460433 460699 486125 487372 497443 508231 514586 519601 521841 523233 534123 542819 543359 545816 552025 552102 562429 563022 569411 577155 578430 580396 588006 591422 596985 597634 601183 614006 618214 635822 638828 647097 650506 650967 656323 656852 661896 669692 671454 677222 682001 687354 702995 705642 705784 713085 714309 714479 716586 718142 721249 721867 723155 725643 727543 727708 728998 729891 730188 731216 733556 736054 737465 739956 740789 741082 744234 744368 745002 745553 747241 749394 750636 756415 758584 758590 760933 762757 767672 777920 778135 779039 781747 784757 786474 792444 792653 794406 795066 796797 797638 798929 801065 801362 803158 803258 803696 807379 811036 811533 814841 817737 817951 818907 819159 819166 823212 825987 827263 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (7.92%) |
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 807379 741082 731216 796797 825987 827263 728998 745553 618214 266134 552025 635822 777920 794406 762757 747241 749394 778135 446701 569411 714479 596985 638828 786474 739956 744234 736054 758584 705642 803158 542819 760933 811036 727543 650506 661896 682001 779039 578430 390041 814841 756415 737465 395863 723155 563022 591422 798929 803258 817951 818907 819166 823212 647097 650967 792444 811533 781747 792653 801362 725643 784757 795066 803696 727708 733556 713085 716586 445892 801065 745002 523233 656323 721249 677222 721867 577155 601183 597634 460699 453497 486125 402518 435931 460433 487372 497443 545816 562429 588006 744368 758590 457640 514586 521841 817737 543359 705784 656852 750636 730188 740789 718142 393097 508231 669692 671454 702995 797638 729891 767672 714309 714349 819159 534123 519601 552102 687354 580396 614006 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.82%) |
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 266134 390041 393097 395863 402518 435931 445892 446701 453497 457640 460433 460699 486125 487372 497443 508231 514586 519601 521841 523233 534123 542819 543359 545816 552025 552102 562429 563022 569411 577155 578430 580396 588006 591422 596985 597634 601183 614006 618214 635822 638828 647097 650506 650967 656323 656852 661896 669692 671454 677222 682001 687354 702995 705642 705784 713085 714309 714479 716586 718142 721249 721867 723155 725643 727543 727708 728998 729891 730188 731216 733556 736054 737465 739956 740789 741082 744234 744368 745002 745553 747241 749394 750636 756415 758584 758590 760933 762757 767672 777920 778135 779039 781747 784757 786474 792444 792653 794406 795066 796797 797638 798929 801065 801362 803158 803258 803696 807379 811036 811533 814841 817737 817951 818907 819159 819166 823212 825987 827263 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck her husband"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс her husband"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс her husband"
]
|
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.