Query Metrics
7
Database Queries
7
Different statements
393.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.79 ms (53.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая creampie"
]
|
||||||||||||||||||||||||||||||
|
157.48 ms (40.04%) |
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 151445 392466 400181 410558 410606 435700 439651 439724 439791 439817 440744 443514 443550 443990 444645 444882 444883 446023 449320 451826 456408 458220 459136 465153 466376 468779 470344 471951 473807 476299 477473 477772 479204 480861 481142 482191 485172 492050 494779 498033 498990 499731 501458 503110 505795 512680 513510 514003 514989 515893 516889 518006 518949 519582 520826 520851 521204 524408 524535 525626 526148 530028 530487 530572 531163 532735 532838 533372 533378 534372 537648 537864 540577 543604 556661 558194 558572 561671 561848 561998 564901 569094 569179 569544 578729 594353 595132 597208 599345 599941 599990 599994 600268 600332 600340 600355 601101 601903 603509 604409 607525 609238 618359 619003 623617 623933 632663 633123 633987 634118 642063 647994 654464 666546 696233 720072 783990 807687 809272 820762 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (4.33%) |
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 633987 603509 623617 807687 783990 410606 443514 439724 439817 400181 456408 477473 479204 439791 449320 516889 518949 519582 524408 485172 515893 561998 601903 597208 618359 392466 410558 443990 444882 444883 451826 465153 476299 446023 498033 526148 532838 512680 498990 533378 501458 514989 530572 578729 561848 569179 720072 696233 569094 600332 600340 607525 599345 604409 599941 599990 599994 809272 480861 151445 435700 458220 468779 477772 440744 443550 471951 473807 470344 513510 520851 564901 619003 601101 444645 466376 520826 531163 525626 514003 532735 540577 521204 530028 530487 482191 558194 558572 561671 569544 647994 666546 556661 595132 594353 600268 600355 634118 459136 439651 492050 494779 518006 481142 499731 503110 533372 524535 543604 654464 623933 642063 633123 609238 632663 820762 534372 505795 537648 537864 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (0.99%) |
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 151445 392466 400181 410558 410606 435700 439651 439724 439791 439817 440744 443514 443550 443990 444645 444882 444883 446023 449320 451826 456408 458220 459136 465153 466376 468779 470344 471951 473807 476299 477473 477772 479204 480861 481142 482191 485172 492050 494779 498033 498990 499731 501458 503110 505795 512680 513510 514003 514989 515893 516889 518006 518949 519582 520826 520851 521204 524408 524535 525626 526148 530028 530487 530572 531163 532735 532838 533372 533378 534372 537648 537864 540577 543604 556661 558194 558572 561671 561848 561998 564901 569094 569179 569544 578729 594353 595132 597208 599345 599941 599990 599994 600268 600332 600340 600355 601101 601903 603509 604409 607525 609238 618359 619003 623617 623933 632663 633123 633987 634118 642063 647994 654464 666546 696233 720072 783990 807687 809272 820762 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая creampie"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette creampie"
]
|
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.