Query Metrics
7
Database Queries
7
Different statements
163.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.16 ms (81.21%) |
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 386548 396337 400311 402859 413507 418507 418655 418664 421782 429216 429242 432521 438276 445271 458030 460529 466970 478256 489156 492665 493934 508863 517441 529820 531449 532416 533708 544880 549415 552194 553775 553776 555808 558655 564621 566045 569979 570836 574144 576210 577900 579204 582727 583711 615651 616072 627111 644666 647762 648670 650731 650765 652024 659064 672706 673607 676538 677041 677726 683724 685237 693006 693509 698341 698862 700055 707506 709065 709179 711249 716527 718649 720313 723744 733090 734877 738583 739709 740417 743047 748639 748651 749501 749659 749878 750722 752860 756473 756967 764692 765084 766188 767399 768417 769424 772575 773132 773903 773907 777327 781580 785274 785492 786713 787345 787354 789139 792579 795707 796418 801140 801718 810184 812537 814092 814453 818823 821798 824133 824460 ] |
||||||||||||||||||||||||||||||
|
18.88 ms (11.51%) |
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 750722 756473 769424 773907 787345 787354 789139 792579 801140 801718 733090 739709 740417 748639 748651 749878 764692 772575 723744 734877 749501 756967 766188 768417 773132 767399 773903 738583 743047 749659 752860 765084 615651 616072 627111 644666 698341 700055 711249 718649 777327 781580 785274 785492 786713 795707 796418 810184 812537 438276 466970 458030 386548 396337 400311 402859 418655 418664 421782 432521 445271 418507 413507 429216 429242 814092 814453 824133 818823 821798 824460 492665 478256 460529 489156 508863 533708 517441 529820 531449 532416 493934 558655 564621 579204 583711 553776 566045 577900 582727 555808 650731 676538 677041 677726 683724 693006 698862 709065 716527 647762 650765 652024 659064 672706 673607 685237 707506 709179 648670 693509 720313 544880 549415 552194 553775 569979 570836 574144 576210 ] |
||||||||||||||||||||||||||||||
|
4.50 ms (2.74%) |
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 386548 396337 400311 402859 413507 418507 418655 418664 421782 429216 429242 432521 438276 445271 458030 460529 466970 478256 489156 492665 493934 508863 517441 529820 531449 532416 533708 544880 549415 552194 553775 553776 555808 558655 564621 566045 569979 570836 574144 576210 577900 579204 582727 583711 615651 616072 627111 644666 647762 648670 650731 650765 652024 659064 672706 673607 676538 677041 677726 683724 685237 693006 693509 698341 698862 700055 707506 709065 709179 711249 716527 718649 720313 723744 733090 734877 738583 739709 740417 743047 748639 748651 749501 749659 749878 750722 752860 756473 756967 764692 765084 766188 767399 768417 769424 772575 773132 773903 773907 777327 781580 785274 785492 786713 787345 787354 789139 792579 795707 796418 801140 801718 810184 812537 814092 814453 818823 821798 824133 824460 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"year"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"year"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"year"
]
|
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.