Query Metrics
7
Database Queries
7
Different statements
170.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.17 ms (85.24%) |
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 476825 479988 482003 494756 496841 500953 504655 506049 507921 514724 515368 516648 517309 519040 519920 520113 520299 522334 522380 522936 523216 526112 526857 527036 527583 529515 530201 530259 532684 534713 535226 537063 539071 539216 539614 540384 541434 542488 542820 543913 545060 545076 546876 550189 550214 552121 552393 552726 553705 554458 554835 555417 555766 555958 556695 557726 559247 559928 559985 560171 561419 564913 565573 566528 566723 568106 569787 571320 571454 571743 571817 572509 574415 574993 575441 575694 577535 577950 578971 580974 581175 581217 581552 581729 581854 583692 584401 584948 587493 590932 591125 591157 593739 594036 595054 596559 601351 601413 602763 603232 605714 609179 612684 617030 617075 617650 618473 630257 631285 635752 638049 645976 649989 650955 652669 654673 655465 670470 676664 772417 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (8.60%) |
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 539614 500953 522334 530259 539216 552726 555766 557726 559247 566528 571817 572509 583692 546876 550189 566723 574415 574993 542488 552393 553705 554458 561419 569787 571320 575694 577950 649989 652669 655465 676664 645976 654673 670470 545060 550214 571454 601413 630257 591125 596559 602763 609179 618473 635752 587493 593739 617075 638049 590932 591157 601351 603232 605714 612684 631285 617030 617650 526857 772417 514724 520299 522380 532684 519040 519920 515368 516648 575441 577535 581552 541434 545076 650955 578971 595054 594036 476825 479988 482003 522936 529515 530201 534713 504655 507921 537063 540384 517309 523216 527036 539071 494756 496841 506049 520113 526112 527583 535226 542820 543913 552121 554835 555958 556695 560171 564913 565573 568106 580974 581175 581217 581729 581854 584948 555417 559928 559985 571743 584401 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (2.00%) |
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 476825 479988 482003 494756 496841 500953 504655 506049 507921 514724 515368 516648 517309 519040 519920 520113 520299 522334 522380 522936 523216 526112 526857 527036 527583 529515 530201 530259 532684 534713 535226 537063 539071 539216 539614 540384 541434 542488 542820 543913 545060 545076 546876 550189 550214 552121 552393 552726 553705 554458 554835 555417 555766 555958 556695 557726 559247 559928 559985 560171 561419 564913 565573 566528 566723 568106 569787 571320 571454 571743 571817 572509 574415 574993 575441 575694 577535 577950 578971 580974 581175 581217 581552 581729 581854 583692 584401 584948 587493 590932 591125 591157 593739 594036 595054 596559 601351 601413 602763 603232 605714 609179 612684 617030 617075 617650 618473 630257 631285 635752 638049 645976 649989 650955 652669 654673 655465 670470 676664 772417 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосёт и себя дрочит"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосет дрочк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
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.