Query Metrics
7
Database Queries
7
Different statements
156.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.12 ms (81.63%) |
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 388869 389798 405897 411967 413503 429630 430400 437086 438756 439038 439456 442058 444803 447232 454793 456965 458472 459875 470265 477448 484269 487454 487674 492723 505501 505656 509880 510006 511798 512922 513746 515607 527763 538300 540428 542921 549081 552345 557660 558059 558236 558295 560252 560588 564361 565045 569994 571351 573788 575207 578185 579192 580823 585286 587054 588712 591091 595671 598535 599139 599240 599418 599496 599527 601829 601893 605465 616100 618841 629315 632082 632656 635880 642389 643424 651923 674413 677098 681271 682912 683247 683660 690683 692604 692654 702835 705516 705537 710534 713630 714442 715221 719197 723277 725711 728191 730390 752790 754111 759541 770269 772565 772832 780868 781178 781961 783481 788428 794609 796168 800073 801239 801615 805033 805595 807898 809238 811627 812675 818463 ] |
||||||||||||||||||||||||||||||
|
18.48 ms (11.77%) |
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 710534 677098 692604 692654 705537 714442 719197 558236 605465 629315 585286 598535 599139 599240 599496 601829 618841 635880 591091 599527 587054 588712 632082 796168 801239 780868 788428 794609 809238 772565 772832 800073 805595 811627 725711 728191 759541 752790 770269 730390 754111 616100 705516 715221 781961 801615 438756 439456 459875 442058 456965 470265 388869 444803 458472 429630 509880 512922 538300 505501 513746 487674 492723 389798 405897 439038 430400 411967 413503 437086 818463 447232 454793 484269 540428 505656 515607 511798 510006 527763 477448 487454 557660 558059 560252 560588 571351 558295 565045 578185 542921 549081 564361 573788 575207 690683 681271 683660 702835 651923 674413 682912 683247 713630 723277 552345 569994 579192 580823 599418 595671 601893 632656 642389 643424 783481 805033 812675 781178 807898 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.83%) |
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 388869 389798 405897 411967 413503 429630 430400 437086 438756 439038 439456 442058 444803 447232 454793 456965 458472 459875 470265 477448 484269 487454 487674 492723 505501 505656 509880 510006 511798 512922 513746 515607 527763 538300 540428 542921 549081 552345 557660 558059 558236 558295 560252 560588 564361 565045 569994 571351 573788 575207 578185 579192 580823 585286 587054 588712 591091 595671 598535 599139 599240 599418 599496 599527 601829 601893 605465 616100 618841 629315 632082 632656 635880 642389 643424 651923 674413 677098 681271 682912 683247 683660 690683 692604 692654 702835 705516 705537 710534 713630 714442 715221 719197 723277 725711 728191 730390 752790 754111 759541 770269 772565 772832 780868 781178 781961 783481 788428 794609 796168 800073 801239 801615 805033 805595 807898 809238 811627 812675 818463 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"way"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"way"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"way"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.