Query Metrics
7
Database Queries
7
Different statements
327.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
289.32 ms (88.39%) |
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 396302 455433 463255 476733 478348 485301 490125 496828 498331 501134 502365 504735 506197 508552 510934 511428 512081 513015 516150 517100 526864 529825 530415 530559 535661 536208 537086 537959 538261 538505 538709 539350 539680 540134 540401 542656 542874 545930 546418 550356 551252 552378 553136 553550 553692 557879 557906 558317 559811 560003 560734 560755 562115 562215 563463 563691 564666 566267 566841 569221 570677 576426 576450 576603 579658 581589 582518 582910 583625 584093 584185 585036 585043 645745 646127 652706 653319 653571 659477 660601 661522 661540 667152 667435 670316 671534 672206 673154 673910 678224 678250 678261 683026 698161 700267 709046 713767 722944 816131 818241 819090 820069 824204 824255 825020 825133 825174 825370 825478 825656 826288 826461 826628 826631 826737 826851 826953 827084 827526 827741 ] |
||||||||||||||||||||||||||||||
|
23.49 ms (7.18%) |
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 496828 506197 508552 511428 513015 485301 504735 512081 517100 526864 396302 818241 825020 825174 825370 825656 585036 585043 826628 826631 826737 816131 824255 826851 826953 827084 827741 824204 819090 820069 825133 825478 826288 826461 827526 476733 455433 490125 498331 502365 530559 536208 538261 538709 540401 501134 529825 535661 537086 537959 538505 539350 510934 516150 539680 540134 530415 463255 478348 545930 546418 550356 557906 560755 562115 563691 564666 576426 583625 584093 584185 542874 553692 558317 559811 560003 566267 566841 570677 576450 581589 542656 551252 552378 553136 553550 557879 560734 562215 563463 569221 576603 579658 582518 582910 645745 646127 652706 653571 661540 667152 667435 670316 671534 672206 673154 673910 678224 678250 678261 683026 698161 700267 709046 713767 722944 653319 659477 660601 661522 ] |
||||||||||||||||||||||||||||||
|
7.27 ms (2.22%) |
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 396302 455433 463255 476733 478348 485301 490125 496828 498331 501134 502365 504735 506197 508552 510934 511428 512081 513015 516150 517100 526864 529825 530415 530559 535661 536208 537086 537959 538261 538505 538709 539350 539680 540134 540401 542656 542874 545930 546418 550356 551252 552378 553136 553550 553692 557879 557906 558317 559811 560003 560734 560755 562115 562215 563463 563691 564666 566267 566841 569221 570677 576426 576450 576603 579658 581589 582518 582910 583625 584093 584185 585036 585043 645745 646127 652706 653319 653571 659477 660601 661522 661540 667152 667435 670316 671534 672206 673154 673910 678224 678250 678261 683026 698161 700267 709046 713767 722944 816131 818241 819090 820069 824204 824255 825020 825133 825174 825370 825478 825656 826288 826461 826628 826631 826737 826851 826953 827084 827526 827741 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny webcam"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.