Query Metrics
7
Database Queries
7
Different statements
194.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.79 ms (86.11%) |
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 419312 422495 423846 427843 434216 435503 435719 435724 435806 436765 436948 439469 440779 441603 441662 441756 441818 444939 446821 449545 450715 451281 451419 452749 452754 453820 453890 454452 454471 455567 458371 459942 459966 462281 463471 463725 467970 480508 480697 483043 483179 483786 486882 487636 489876 495356 496750 497748 497811 498387 498550 506741 509434 509594 514979 518600 519706 520535 520951 521170 524576 525234 525301 526259 528097 545439 555065 565676 571277 575298 580168 580886 581264 584983 585936 587260 587876 591160 591958 594219 595318 600540 602072 605683 607679 612779 615255 617106 619630 627507 642162 649249 652683 691464 700685 707617 718091 722934 726815 727923 728720 739089 758335 759502 762332 765269 784507 784976 784981 791975 793627 795304 796919 797888 809876 812533 812842 814272 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (8.95%) |
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 514979 797888 441603 436765 419312 441662 814272 452754 487636 453820 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 565676 627507 520951 509594 691464 652683 545439 591958 591160 600540 605683 619630 594219 617106 463725 439469 454452 571277 649249 642162 585936 607679 595318 497811 584983 452749 463471 483179 450715 467970 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 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.43%) |
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 419312 422495 423846 427843 434216 435503 435719 435724 435806 436765 436948 439469 440779 441603 441662 441756 441818 444939 446821 449545 450715 451281 451419 452749 452754 453820 453890 454452 454471 455567 458371 459942 459966 462281 463471 463725 467970 480508 480697 483043 483179 483786 486882 487636 489876 495356 496750 497748 497811 498387 498550 506741 509434 509594 514979 518600 519706 520535 520951 521170 524576 525234 525301 526259 528097 545439 555065 565676 571277 575298 580168 580886 581264 584983 585936 587260 587876 591160 591958 594219 595318 600540 602072 605683 607679 612779 615255 617106 619630 627507 642162 649249 652683 691464 700685 707617 718091 722934 726815 727923 728720 739089 758335 759502 762332 765269 784507 784976 784981 791975 793627 795304 796919 797888 809876 812533 812842 814272 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cowgirl amateur"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cowgirl любительск"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cowgirl любительск"
]
|
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.