Query Metrics
7
Database Queries
7
Different statements
212.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.28 ms (88.25%) |
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 14967 95748 187819 233333 233915 337889 387823 389726 395310 395659 396033 396636 401993 410563 418058 433143 453361 457599 460449 461677 462004 463849 464903 465958 466419 467146 467947 476806 479774 480737 483613 486076 486213 487682 497647 505183 508873 510064 514794 520787 525038 526273 527109 528475 531326 535528 537404 537464 537980 546952 555004 559996 563989 585094 598493 604264 606283 609343 610034 620480 623420 628500 637075 647275 650312 658837 662181 668663 671612 676127 680146 680472 687583 691561 692816 694288 695109 697545 699209 704178 705471 709594 713877 714429 714674 716784 717235 718930 726143 726602 740473 742360 751925 756001 756104 756237 756321 759759 759867 760616 761552 766637 767159 770497 772472 776992 780687 782559 782628 783145 785051 788133 791853 792678 793232 795295 803730 814804 820840 828595 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (7.04%) |
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 756321 410563 463849 465958 467146 95748 433143 389726 401993 457599 462004 453361 508873 514794 483613 395310 337889 396033 396636 466419 480737 486076 467947 487682 497647 520787 527109 535528 505183 537464 525038 531326 537980 510064 526273 528475 537404 464903 668663 692816 662181 680472 687583 704178 598493 628500 620480 788133 785051 766637 742360 795295 418058 476806 461677 460449 486213 559996 609343 585094 814804 820840 546952 563989 650312 691561 709594 713877 658837 676127 699209 714674 718930 647275 671612 680146 694288 705471 716784 717235 555004 610034 637075 604264 606283 776992 782628 791853 792678 803730 756001 756104 756237 761552 770497 793232 759867 726602 759759 751925 767159 772472 726143 740473 760616 697545 714429 780687 782559 783145 187819 387823 395659 233333 233915 828595 695109 14967 479774 623420 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.27%) |
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 14967 95748 187819 233333 233915 337889 387823 389726 395310 395659 396033 396636 401993 410563 418058 433143 453361 457599 460449 461677 462004 463849 464903 465958 466419 467146 467947 476806 479774 480737 483613 486076 486213 487682 497647 505183 508873 510064 514794 520787 525038 526273 527109 528475 531326 535528 537404 537464 537980 546952 555004 559996 563989 585094 598493 604264 606283 609343 610034 620480 623420 628500 637075 647275 650312 658837 662181 668663 671612 676127 680146 680472 687583 691561 692816 694288 695109 697545 699209 704178 705471 709594 713877 714429 714674 716784 717235 718930 726143 726602 740473 742360 751925 756001 756104 756237 756321 759759 759867 760616 761552 766637 767159 770497 772472 776992 780687 782559 782628 783145 785051 788133 791853 792678 793232 795295 803730 814804 820840 828595 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big but anal"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.