Query Metrics
7
Database Queries
7
Different statements
179.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.93 ms (84.70%) |
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 51420 80529 203480 213144 382385 392270 399717 406121 409861 416233 416364 419371 421254 422028 425715 427447 428958 430436 430556 432077 433211 437864 442318 442841 443704 446718 447240 449635 452513 454147 461025 464442 467559 467721 470604 472320 473598 473970 474923 475202 483961 490491 494036 500622 504189 505843 514644 514645 518558 521985 522212 522227 523857 525249 529234 529293 531513 532149 534296 538333 540106 543954 548012 551577 552588 556045 557410 559111 566370 575043 575116 584054 588129 588285 594886 597559 602629 604680 633257 650157 655358 657680 658314 663446 663516 675588 682984 685168 690002 691640 701208 702349 713407 715160 716966 724115 725280 725427 729179 730696 730810 731504 749881 753125 753310 762803 764845 776686 782558 782631 783133 784243 785695 787901 795473 796181 796310 798405 803867 814450 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (10.09%) |
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 416364 430436 443704 454147 474923 409861 428958 467559 470604 437864 446718 467721 473970 392270 416233 442841 447240 452513 464442 504189 514644 518558 521985 522227 505843 522212 500622 382385 532149 543954 663516 702349 663446 685168 716966 691640 776686 796181 785695 762803 782558 796310 730810 749881 731504 730696 713407 203480 80529 814450 483961 584054 575043 557410 682984 690002 715160 701208 588129 604680 633257 782631 787901 798405 803867 725427 783133 795473 725280 753125 753310 764845 729179 724115 784243 419371 427447 433211 472320 449635 531513 525249 461025 548012 559111 566370 575116 552588 650157 657680 658314 655358 675588 551577 556045 588285 602629 594886 597559 425715 422028 421254 432077 442318 475202 399717 406121 473598 430556 514645 523857 538333 494036 529234 534296 529293 213144 51420 490491 540106 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.53%) |
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 51420 80529 203480 213144 382385 392270 399717 406121 409861 416233 416364 419371 421254 422028 425715 427447 428958 430436 430556 432077 433211 437864 442318 442841 443704 446718 447240 449635 452513 454147 461025 464442 467559 467721 470604 472320 473598 473970 474923 475202 483961 490491 494036 500622 504189 505843 514644 514645 518558 521985 522212 522227 523857 525249 529234 529293 531513 532149 534296 538333 540106 543954 548012 551577 552588 556045 557410 559111 566370 575043 575116 584054 588129 588285 594886 597559 602629 604680 633257 650157 655358 657680 658314 663446 663516 675588 682984 685168 690002 691640 701208 702349 713407 715160 716966 724115 725280 725427 729179 730696 730810 731504 749881 753125 753310 762803 764845 776686 782558 782631 783133 784243 785695 787901 795473 796181 796310 798405 803867 814450 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"даёт другому"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"друг"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.