Query Metrics
7
Database Queries
7
Different statements
210.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.13 ms (87.68%) |
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 417448 419096 422495 423846 427843 433898 434216 435503 435719 435724 435806 436948 439469 440779 441756 441818 444939 446821 449466 449545 450715 451281 451419 452749 453890 454452 454470 454471 455567 458371 459942 459966 461034 462281 463471 463725 465501 480508 480697 483043 483179 483786 486882 489876 492462 495356 496750 497748 497811 498387 498550 505298 506741 509434 509594 512111 518600 519706 520535 520951 521170 524576 525234 525301 526259 528097 533200 545439 555065 555898 571277 575298 580168 580886 581264 584983 585936 587260 587876 591160 591958 594219 595318 600540 602072 602575 605683 607679 612779 615255 617106 619630 627507 642162 649249 652683 691464 700685 707617 718091 722934 726815 727923 728720 739089 758335 759502 762332 765269 777003 784507 784976 784981 791975 793627 795304 796919 809876 812533 812842 ] |
||||||||||||||||||||||||||||||
|
15.98 ms (7.61%) |
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 449545 458371 525301 498387 496750 575298 580886 581264 700685 718091 612779 602072 784976 791975 796919 758335 759502 765269 784507 784981 812533 812842 726815 762332 739089 795304 423846 453890 422495 462281 451419 480697 436948 441818 444939 454471 459942 459966 417448 451281 518600 524576 483043 526259 602575 627507 520951 555898 509594 691464 652683 545439 591958 591160 600540 605683 619630 594219 617106 463725 433898 439469 454452 571277 649249 642162 585936 607679 595318 777003 497811 584983 452749 463471 483179 450715 486882 495356 528097 722934 555065 580168 587260 587876 615255 793627 727923 728720 707617 809876 435719 435724 435806 440779 419096 427843 455567 480508 520535 525234 498550 521170 483786 489876 497748 509434 506741 519706 434216 435503 441756 446821 461034 454470 465501 492462 449466 512111 533200 505298 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.60%) |
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 417448 419096 422495 423846 427843 433898 434216 435503 435719 435724 435806 436948 439469 440779 441756 441818 444939 446821 449466 449545 450715 451281 451419 452749 453890 454452 454470 454471 455567 458371 459942 459966 461034 462281 463471 463725 465501 480508 480697 483043 483179 483786 486882 489876 492462 495356 496750 497748 497811 498387 498550 505298 506741 509434 509594 512111 518600 519706 520535 520951 521170 524576 525234 525301 526259 528097 533200 545439 555065 555898 571277 575298 580168 580886 581264 584983 585936 587260 587876 591160 591958 594219 595318 600540 602072 602575 605683 607679 612779 615255 617106 619630 627507 642162 649249 652683 691464 700685 707617 718091 722934 726815 727923 728720 739089 758335 759502 762332 765269 777003 784507 784976 784981 791975 793627 795304 796919 809876 812533 812842 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск cowgirl"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.63%) |
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.