Query Metrics
7
Database Queries
7
Different statements
144.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.17 ms (81.60%) |
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 383961 401721 414710 423567 450735 452367 452489 458719 476592 480637 497363 503743 506025 516186 521128 521587 528743 530375 531200 531209 531210 531252 532999 533063 534604 535342 537196 540230 540738 544852 549879 550201 550451 557238 567259 580670 591715 593506 599082 600365 602186 605637 608294 612275 612321 612386 615916 617135 618565 624578 625250 629924 632084 632274 633787 637469 648702 649174 673594 673653 673655 673656 674662 674758 681288 684117 697314 706945 707328 714743 714748 716307 717628 720245 721780 721999 724504 724522 725565 726533 729776 732347 736281 743769 752162 758434 768079 779618 784161 786523 791692 795276 797580 797634 798770 798846 799049 802288 802327 804192 804209 804215 804272 804639 807898 808570 809534 810616 811335 811362 811369 812814 814536 814821 815132 824193 825810 826425 828722 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (10.65%) |
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 784161 795276 802288 804192 804272 804639 811362 812814 458719 814821 815132 450735 476592 531200 497363 503743 521587 534604 550451 707328 674662 648702 673656 697314 593506 599082 612321 618565 615916 625250 798770 798846 799049 802327 791692 807898 811369 725565 736281 797580 811335 758434 612386 629924 632274 717628 721780 721999 797634 804215 452489 383961 516186 521128 823726 549879 814536 452367 540230 540738 544852 580670 673594 714748 716307 674758 681288 714743 567259 637469 624578 591715 605637 617135 786523 810616 724522 732347 752162 726533 729776 608294 779618 808570 423567 401721 612275 531210 530375 537196 528743 531209 506025 480637 550201 649174 684117 720245 673653 673655 706945 557238 632084 633787 602186 809534 724504 804209 414710 828722 743769 768079 824193 825810 826425 533063 600365 531252 532999 535342 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.06%) |
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 383961 401721 414710 423567 450735 452367 452489 458719 476592 480637 497363 503743 506025 516186 521128 521587 528743 530375 531200 531209 531210 531252 532999 533063 534604 535342 537196 540230 540738 544852 549879 550201 550451 557238 567259 580670 591715 593506 599082 600365 602186 605637 608294 612275 612321 612386 615916 617135 618565 624578 625250 629924 632084 632274 633787 637469 648702 649174 673594 673653 673655 673656 674662 674758 681288 684117 697314 706945 707328 714743 714748 716307 717628 720245 721780 721999 724504 724522 725565 726533 729776 732347 736281 743769 752162 758434 768079 779618 784161 786523 791692 795276 797580 797634 798770 798846 799049 802288 802327 804192 804209 804215 804272 804639 807898 808570 809534 810616 811335 811362 811369 812814 814536 814821 815132 824193 825810 826425 828722 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love xxx"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love xxx"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love xxx"
]
|
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.