Query Metrics
7
Database Queries
7
Different statements
246.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.49 ms (89.95%) |
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 49767 50344 360205 385608 390397 397673 423128 446139 463644 466670 506444 513057 522561 524648 527665 534619 535359 539099 540055 540101 540104 540117 540708 552283 555826 560164 561202 567891 568375 569024 570893 572734 577679 581180 582514 584360 608047 614385 617242 618072 619646 622283 623236 632282 635057 649905 652563 661353 661357 661387 666991 669930 695594 696685 698709 700177 702370 704669 714042 715963 717600 718703 719899 719907 721918 731147 734028 738950 739718 741078 749572 757026 760856 765796 768765 775130 777601 779324 779820 780201 780734 781482 784104 784264 785103 785454 787145 788892 789066 789069 795992 797920 802927 808304 808710 809987 811853 812245 813329 813545 814096 817620 819148 819240 820442 820920 821477 823038 823155 825633 826343 828016 828021 828114 828139 828140 828144 828270 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (5.98%) |
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 731147 788892 826343 828270 828144 581180 777601 787145 797920 789066 820442 821477 811853 397673 813545 535359 567891 572734 661353 661387 584360 608047 614385 618072 619646 623236 779324 780734 809987 768765 784104 739718 617242 635057 775130 779820 781482 785454 813329 360205 539099 819148 828016 828355 540055 540104 540117 561202 570893 652563 702370 715963 695594 568375 808304 784264 795992 812245 749572 632282 423128 828140 700177 719899 666991 828251 466670 704669 741078 669930 808710 50344 385608 446139 552283 390397 738950 765796 717600 802927 49767 828139 814096 817620 823155 760856 534619 560164 524648 522561 527665 582514 569024 714042 649905 577679 463644 555826 661357 780201 734028 513057 540708 506444 696685 718703 698709 721918 622283 789069 757026 719907 785103 828114 819240 825633 820920 823038 828021 540101 ] |
||||||||||||||||||||||||||||||
|
2.45 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 49767 50344 360205 385608 390397 397673 423128 446139 463644 466670 506444 513057 522561 524648 527665 534619 535359 539099 540055 540101 540104 540117 540708 552283 555826 560164 561202 567891 568375 569024 570893 572734 577679 581180 582514 584360 608047 614385 617242 618072 619646 622283 623236 632282 635057 649905 652563 661353 661357 661387 666991 669930 695594 696685 698709 700177 702370 704669 714042 715963 717600 718703 719899 719907 721918 731147 734028 738950 739718 741078 749572 757026 760856 765796 768765 775130 777601 779324 779820 780201 780734 781482 784104 784264 785103 785454 787145 788892 789066 789069 795992 797920 802927 808304 808710 809987 811853 812245 813329 813545 814096 817620 819148 819240 820442 820920 821477 823038 823155 825633 826343 828016 828021 828114 828139 828140 828144 828270 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на cock улиц"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public cock"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на cock улиц"
]
|
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.