Query Metrics
7
Database Queries
7
Different statements
147.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.10 ms (84.33%) |
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 398986 399017 402538 443417 456677 458628 462170 463321 463661 473928 474057 478787 491658 492384 499050 501227 514976 520492 526480 527165 527521 536809 539707 540412 543657 552397 554114 554180 556060 563598 563873 575681 582214 586730 597735 601222 602415 605900 608088 609293 613293 613350 615651 617336 618782 622334 627111 628846 628909 628957 636522 642679 649263 650230 659009 659459 661709 668613 676446 676527 676979 677022 677046 677058 677379 678195 680171 688521 696194 700681 704638 709020 710391 711249 712931 713838 714254 715235 718649 719376 719817 721122 721792 723538 724791 724891 729845 736659 743355 744631 747912 747952 748639 749501 749878 756473 758893 761076 762702 762754 765084 766188 773089 773132 777327 781580 784759 785274 785441 788095 789549 789754 792460 792579 800619 806892 807555 810548 811537 813116 ] |
||||||||||||||||||||||||||||||
|
11.57 ms (7.86%) |
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 718649 402538 473928 478787 499050 501227 463661 462170 491658 520492 492384 800619 713838 719817 628846 762754 762702 443417 463321 700681 710391 618782 761076 602415 526480 398986 399017 723538 456677 458628 536809 514976 527165 539707 527521 540412 474057 543657 554180 563873 552397 554114 582214 650230 659009 661709 668613 676446 676979 677379 678195 680171 688521 649263 712931 719376 721122 659459 676527 677022 677046 677058 696194 704638 709020 714254 715235 556060 563598 575681 586730 605900 613293 613350 628909 628957 636522 597735 617336 622334 642679 601222 608088 784759 785441 789549 792460 810548 811537 813116 789754 806892 807555 724891 729845 743355 756473 758893 773089 788095 792579 724791 747912 747952 748639 749878 736659 749501 766188 773132 744631 765084 609293 615651 627111 711249 721792 777327 781580 785274 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.16%) |
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 398986 399017 402538 443417 456677 458628 462170 463321 463661 473928 474057 478787 491658 492384 499050 501227 514976 520492 526480 527165 527521 536809 539707 540412 543657 552397 554114 554180 556060 563598 563873 575681 582214 586730 597735 601222 602415 605900 608088 609293 613293 613350 615651 617336 618782 622334 627111 628846 628909 628957 636522 642679 649263 650230 659009 659459 661709 668613 676446 676527 676979 677022 677046 677058 677379 678195 680171 688521 696194 700681 704638 709020 710391 711249 712931 713838 714254 715235 718649 719376 719817 721122 721792 723538 724791 724891 729845 736659 743355 744631 747912 747952 748639 749501 749878 756473 758893 761076 762702 762754 765084 766188 773089 773132 777327 781580 784759 785274 785441 788095 789549 789754 792460 792579 800619 806892 807555 810548 811537 813116 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 19 лет"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 19 лет"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"19 лет"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.