Query Metrics
7
Database Queries
7
Different statements
143.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.56 ms (83.40%) |
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 398561 422619 422774 422894 424056 428451 434553 445101 449360 452513 454147 454953 457119 457121 463741 465685 491678 510582 510589 510590 511254 511270 511837 518929 523540 527011 532107 537113 540084 540086 544804 545628 550742 551012 551121 557537 557840 558369 560056 564402 565179 565984 565985 565994 565997 566016 567560 570759 572739 574644 589684 592734 595165 600912 601159 601160 602132 605974 607025 609506 614529 615964 619592 621048 622367 623513 623522 632171 640306 641465 641663 642910 645530 646339 648955 653253 658108 669535 673051 680519 680856 695565 695941 698853 712884 726647 729856 732644 735413 737422 749602 752155 752198 758836 771981 773499 775584 781097 782422 784678 785708 786333 794122 795416 799931 801193 805226 807755 807892 814048 817045 817834 820185 821523 821536 821923 822599 823295 824856 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (9.82%) |
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 821923 732644 735413 523540 592734 551012 510589 457121 680519 428451 491678 463741 422774 595165 565997 510590 820185 572739 574644 567560 653253 607025 807892 454953 623522 601159 527011 540086 648955 695565 799931 784678 729856 785708 794122 758836 619592 454147 452513 814048 821536 817834 600912 622367 642910 640306 588107 801193 712884 422894 564402 565179 673051 551121 589684 398561 511270 511837 570759 824856 645530 565985 614529 775584 752198 807755 726647 737422 511254 518929 752155 540084 566016 605974 558369 695941 786333 817045 823295 545628 632171 424056 601160 623513 510582 560056 565994 544804 680856 609506 773499 641663 782422 465685 550742 557537 445101 457119 669535 646339 602132 781097 422619 434553 795416 557840 771981 658108 805226 449360 565984 537113 821523 822599 698853 749602 641465 532107 621048 615964 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.18%) |
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 398561 422619 422774 422894 424056 428451 434553 445101 449360 452513 454147 454953 457119 457121 463741 465685 491678 510582 510589 510590 511254 511270 511837 518929 523540 527011 532107 537113 540084 540086 544804 545628 550742 551012 551121 557537 557840 558369 560056 564402 565179 565984 565985 565994 565997 566016 567560 570759 572739 574644 589684 592734 595165 600912 601159 601160 602132 605974 607025 609506 614529 615964 619592 621048 622367 623513 623522 632171 640306 641465 641663 642910 645530 646339 648955 653253 658108 669535 673051 680519 680856 695565 695941 698853 712884 726647 729856 732644 735413 737422 749602 752155 752198 758836 771981 773499 775584 781097 782422 784678 785708 786333 794122 795416 799931 801193 805226 807755 807892 814048 817045 817834 820185 821523 821536 821923 822599 823295 824856 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy tits asian"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy сиськ азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy сиськ азиатк"
]
|
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.