Query Metrics
7
Database Queries
7
Different statements
150.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.21 ms (81.69%) |
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 117844 118472 365056 382578 388364 390587 391746 392100 411643 415313 415988 428224 429961 439038 439052 439138 440041 441113 441233 446002 447159 448791 456239 459201 465497 467195 469120 471671 479549 483704 486767 487422 509422 512072 512935 512941 514258 515435 515488 516045 519312 519697 529795 529799 530942 531193 531854 531869 531880 534550 534585 536140 536404 538925 538990 541325 544833 547463 547484 547486 547847 548443 554851 554857 571961 572654 573204 573206 575601 576545 581006 583711 597163 597169 597239 599834 599906 605026 605133 605155 605725 605745 610061 614328 615921 620017 620901 628485 629934 634071 640530 642742 648869 651090 658789 660373 660405 660412 669056 669080 671018 671045 671052 672950 686106 705466 713142 715786 717535 725121 727325 728385 742279 752597 760507 782842 786911 788926 789028 805642 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (11.60%) |
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 788926 392100 519697 547847 388364 382578 544833 512072 529795 671045 786911 447159 519312 547486 554851 660405 660412 669056 573206 391746 597169 760507 728385 118472 439052 515488 534550 456239 415313 548443 597163 531854 538990 554857 583711 725121 752597 117844 547484 620017 620901 516045 509422 642742 597239 429961 459201 531869 415988 536140 547463 572654 605155 610061 531193 599834 390587 471671 789028 448791 671052 469120 536404 541325 512941 467195 486767 411643 715786 571961 742279 439138 439038 428224 441113 465497 512935 529799 530942 514258 531880 581006 648869 713142 717535 658789 660373 671018 672950 686106 576545 599906 634071 614328 479549 483704 605745 782842 628485 573204 575601 669080 605133 615921 605026 629934 446002 534585 538925 705466 727325 805642 441233 651090 440041 640530 365056 515435 605725 487422 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.85%) |
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 117844 118472 365056 382578 388364 390587 391746 392100 411643 415313 415988 428224 429961 439038 439052 439138 440041 441113 441233 446002 447159 448791 456239 459201 465497 467195 469120 471671 479549 483704 486767 487422 509422 512072 512935 512941 514258 515435 515488 516045 519312 519697 529795 529799 530942 531193 531854 531869 531880 534550 534585 536140 536404 538925 538990 541325 544833 547463 547484 547486 547847 548443 554851 554857 571961 572654 573204 573206 575601 576545 581006 583711 597163 597169 597239 599834 599906 605026 605133 605155 605725 605745 610061 614328 615921 620017 620901 628485 629934 634071 640530 642742 648869 651090 658789 660373 660405 660412 669056 669080 671018 671045 671052 672950 686106 705466 713142 715786 717535 725121 727325 728385 742279 752597 760507 782842 786911 788926 789028 805642 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal fisting sex"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фистинг секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал фистинг секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.06%) |
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.