Query Metrics
7
Database Queries
7
Different statements
206.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.31 ms (87.69%) |
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 432514 441563 453653 453952 454470 456421 457872 458066 458091 459506 461654 462868 464253 464711 469887 470823 478222 480656 480819 481781 482511 482843 482927 489487 489725 490645 490903 491183 493657 500037 500057 505034 508687 508968 510195 520087 520240 521837 530458 536089 536099 543311 543611 552695 555514 556028 564561 565401 566339 567881 571722 572687 573745 581310 582872 582947 584111 584362 588689 595576 599322 602592 604576 605464 608122 608723 611385 614530 614675 614831 614834 615688 616258 618591 623657 624120 624426 626713 649730 672887 707579 723122 724335 725714 726465 726478 726518 726753 726956 727707 730494 736775 736797 737441 749978 755501 757206 757502 758124 759891 761208 768812 771275 779247 780759 781006 781586 781873 782588 790499 791933 799130 801229 803394 803537 803832 806886 807373 811175 812849 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (7.57%) |
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 595576 614675 614834 616258 626713 781006 781873 803832 779247 780759 803394 758124 790499 799130 803537 806886 725714 727707 736775 759891 726465 726956 730494 736797 755501 757206 724335 726518 757502 768812 737441 749978 771275 608122 614530 723122 781586 807373 458091 480819 478222 481781 432514 457872 458066 462868 469887 470823 453653 464711 441563 464253 500057 505034 490903 521837 500037 520087 482927 489487 489725 491183 493657 508687 604576 482511 480656 482843 490645 453952 454470 508968 536099 530458 520240 536089 510195 543311 543611 555514 566339 556028 564561 565401 571722 552695 567881 572687 573745 582872 584362 649730 672887 581310 582947 584111 588689 602592 611385 599322 608723 615688 623657 624120 624426 605464 618591 812849 791933 801229 811175 782588 726478 761208 726753 614831 707579 459506 456421 461654 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.57%) |
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 432514 441563 453653 453952 454470 456421 457872 458066 458091 459506 461654 462868 464253 464711 469887 470823 478222 480656 480819 481781 482511 482843 482927 489487 489725 490645 490903 491183 493657 500037 500057 505034 508687 508968 510195 520087 520240 521837 530458 536089 536099 543311 543611 552695 555514 556028 564561 565401 566339 567881 571722 572687 573745 581310 582872 582947 584111 584362 588689 595576 599322 602592 604576 605464 608122 608723 611385 614530 614675 614831 614834 615688 616258 618591 623657 624120 624426 626713 649730 672887 707579 723122 724335 725714 726465 726478 726518 726753 726956 727707 730494 736775 736797 737441 749978 755501 757206 757502 758124 759891 761208 768812 771275 779247 780759 781006 781586 781873 782588 790499 791933 799130 801229 803394 803537 803832 806886 807373 811175 812849 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хочу хочу"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хоч хоч"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.67%) |
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.