Query Metrics
7
Database Queries
7
Different statements
218.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.34 ms (90.01%) |
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 101841 385919 391346 392805 396596 396967 399422 421618 426393 433751 441770 442421 452534 456290 459963 462228 469850 472874 476889 488299 494662 520066 528688 529664 534132 534763 538169 545731 549098 559194 559474 564781 565177 588221 592946 593725 594111 598048 627778 633917 634315 636889 659247 670210 675393 677726 690304 699602 701267 702397 705175 706475 708182 708674 708762 709880 714090 714104 716001 716529 720193 722543 724068 724084 724898 727399 729460 731695 736967 747384 748386 750436 750951 751801 752615 752921 752960 753155 755426 755925 756152 757955 759675 761995 762986 764947 765507 766102 768462 768914 769779 770342 770378 772650 776161 776227 778448 782828 783996 784393 786823 786986 788521 791851 793586 795571 796873 797088 800625 801078 801799 808453 809984 812132 819585 821667 821798 823787 824345 825442 ] |
||||||||||||||||||||||||||||||
|
11.54 ms (5.29%) |
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 765507 752960 770342 770378 634315 699602 702397 797088 812132 433751 101841 391346 472874 462228 488299 385919 392805 396596 396967 399422 421618 441770 426393 442421 819585 823787 825442 821667 821798 824345 456290 459963 476889 452534 534132 534763 494662 528688 520066 529664 538169 469850 559194 564781 545731 559474 565177 677726 690304 714090 714104 716529 722543 701267 705175 706475 708674 708762 716001 720193 659247 670210 675393 549098 598048 633917 592946 593725 627778 636889 588221 594111 776161 778448 782828 783996 786986 791851 796873 800625 809984 776227 786823 795571 808453 724898 727399 729460 736967 748386 750951 751801 752921 766102 772650 784393 793586 801078 801799 761995 764947 724068 731695 752615 755925 768462 769779 724084 755426 756152 757955 759675 762986 768914 747384 750436 753155 708182 709880 788521 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.32%) |
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 101841 385919 391346 392805 396596 396967 399422 421618 426393 433751 441770 442421 452534 456290 459963 462228 469850 472874 476889 488299 494662 520066 528688 529664 534132 534763 538169 545731 549098 559194 559474 564781 565177 588221 592946 593725 594111 598048 627778 633917 634315 636889 659247 670210 675393 677726 690304 699602 701267 702397 705175 706475 708182 708674 708762 709880 714090 714104 716001 716529 720193 722543 724068 724084 724898 727399 729460 731695 736967 747384 748386 750436 750951 751801 752615 752921 752960 753155 755426 755925 756152 757955 759675 761995 762986 764947 765507 766102 768462 768914 769779 770342 770378 772650 776161 776227 778448 782828 783996 784393 786823 786986 788521 791851 793586 795571 796873 797088 800625 801078 801799 808453 809984 812132 819585 821667 821798 823787 824345 825442 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx little"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx little"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx little"
]
|
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.