Query Metrics
7
Database Queries
7
Different statements
234.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.47 ms (88.89%) |
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 383238 416525 421759 427526 428241 428742 430103 431038 431416 434326 434352 434367 439243 439320 439322 439359 441069 443256 443845 444743 451246 454633 460804 463815 468186 473066 479684 480844 483727 486510 491299 492000 493418 493553 493807 494808 495126 497641 506683 536542 537915 538505 538759 541484 545369 547488 550282 550288 555056 558171 559296 560925 561748 563243 568074 569765 572339 579519 580174 580183 583377 583716 584093 584351 584834 584922 586567 587434 588427 588899 593965 595016 596864 598675 600280 602268 611572 615636 622454 652958 657508 661424 665238 672385 679073 720158 724206 730073 730118 730860 738535 738925 740272 740476 743029 746758 748631 750447 753601 753971 754202 754476 766262 769167 775475 782951 790062 790231 792606 793135 796853 798225 801624 810962 812039 816131 821602 825133 826851 826953 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (6.89%) |
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 497641 593965 473066 430103 439243 416525 428241 444743 439322 495126 536542 537915 479684 492000 547488 555056 561748 568074 545369 550288 584351 541484 579519 580174 583377 665238 661424 550282 580183 595016 598675 587434 588899 600280 615636 596864 611572 792606 810962 766262 790231 427526 431416 434352 443256 434367 439320 454633 468186 439359 431038 451246 460804 483727 491299 493418 493807 486510 560925 463815 602268 816131 821602 826851 826953 825133 538505 563243 584093 584834 652958 672385 679073 657508 559296 584922 622454 586567 588427 812039 775475 793135 798225 738535 743029 746758 754202 790062 796853 801624 730860 738925 740476 748631 740272 753601 753971 769167 730073 754476 724206 730118 750447 720158 782951 383238 421759 428742 434326 441069 443845 480844 493553 494808 506683 538759 558171 569765 572339 583716 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.27%) |
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 383238 416525 421759 427526 428241 428742 430103 431038 431416 434326 434352 434367 439243 439320 439322 439359 441069 443256 443845 444743 451246 454633 460804 463815 468186 473066 479684 480844 483727 486510 491299 492000 493418 493553 493807 494808 495126 497641 506683 536542 537915 538505 538759 541484 545369 547488 550282 550288 555056 558171 559296 560925 561748 563243 568074 569765 572339 579519 580174 580183 583377 583716 584093 584351 584834 584922 586567 587434 588427 588899 593965 595016 596864 598675 600280 602268 611572 615636 622454 652958 657508 661424 665238 672385 679073 720158 724206 730073 730118 730860 738535 738925 740272 740476 743029 746758 748631 750447 753601 753971 754202 754476 766262 769167 775475 782951 790062 790231 792606 793135 796853 798225 801624 810962 812039 816131 821602 825133 826851 826953 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo skinny"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд худые"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.64%) |
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.