Query Metrics
7
Database Queries
7
Different statements
154.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.07 ms (82.24%) |
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 421828 422292 428602 440909 446701 455201 459887 459927 490386 495980 506179 512343 516642 521487 522062 524744 545684 546885 547551 547833 556625 557256 562868 565333 570972 574030 574328 590607 591213 602725 608071 619070 619523 620278 621405 627777 650996 658764 661554 662147 663541 666434 672833 675600 678720 680026 682065 698250 705075 712176 712652 713970 714591 714860 714919 717920 721598 724485 726722 729177 731444 731659 731670 735996 736119 736260 736275 738206 740104 740756 741523 742054 744462 745072 745682 746243 747421 750852 752172 757388 757551 758031 758314 758572 760517 761461 777996 779473 781029 781607 788098 788605 790367 793142 793489 794763 794958 795709 796134 796211 796904 797020 800569 801107 802274 802937 803565 805108 807534 807742 809604 809645 810100 810110 810379 811246 812660 812802 813264 824685 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (9.61%) |
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 809645 731444 729177 698250 713970 781029 794763 797020 459927 490386 547551 661554 714919 717920 602725 620278 779473 793489 788605 796134 805108 758572 760517 790367 810100 813264 726722 731659 740756 627777 705075 777996 788098 803565 521487 422292 824685 524744 574328 714591 658764 662147 682065 712652 663541 712176 590607 619070 781607 796904 758314 793142 800569 810110 724485 740104 747421 745682 744462 735996 758031 761461 608071 796211 802937 811246 459887 440909 591213 428602 455201 516642 557256 547833 556625 545684 565333 650996 678720 680026 721598 666434 672833 714860 621405 801107 812660 795709 810379 812802 794958 807534 736260 736275 742054 757551 736119 745072 746243 752172 738206 750852 731670 741523 757388 619523 802274 807742 809604 421828 522062 495980 446701 506179 512343 546885 562868 570972 574030 675600 ] |
||||||||||||||||||||||||||||||
|
4.86 ms (3.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom fucked"
]
|
||||||||||||||||||||||||||||||
|
2.94 ms (1.91%) |
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 421828 422292 428602 440909 446701 455201 459887 459927 490386 495980 506179 512343 516642 521487 522062 524744 545684 546885 547551 547833 556625 557256 562868 565333 570972 574030 574328 590607 591213 602725 608071 619070 619523 620278 621405 627777 650996 658764 661554 662147 663541 666434 672833 675600 678720 680026 682065 698250 705075 712176 712652 713970 714591 714860 714919 717920 721598 724485 726722 729177 731444 731659 731670 735996 736119 736260 736275 738206 740104 740756 741523 742054 744462 745072 745682 746243 747421 750852 752172 757388 757551 758031 758314 758572 760517 761461 777996 779473 781029 781607 788098 788605 790367 793142 793489 794763 794958 795709 796134 796211 796904 797020 800569 801107 802274 802937 803565 805108 807534 807742 809604 809645 810100 810110 810379 811246 812660 812802 813264 824685 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom fucked"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom fucked"
]
|
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.