Query Metrics
7
Database Queries
7
Different statements
152.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.93 ms (85.18%) |
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 76853 114536 401103 444586 464449 477200 483871 485835 490050 490638 492968 494672 496213 498890 499301 500021 501072 501209 502028 503775 505633 508268 509361 511821 513378 520327 521386 524116 525151 527735 528146 533459 535343 535626 535742 536912 539349 541096 543467 545623 546266 549380 550911 551737 551815 554185 555632 557306 557908 558268 559098 560988 561300 561488 562106 562289 562821 564680 566334 567570 568739 568782 569965 578163 581158 583298 583716 585873 589015 589331 591534 591561 591696 592308 593966 596967 597872 598362 600828 602389 602438 603061 604050 606717 609275 612483 612847 613732 614637 615851 618220 618995 619414 622294 625547 630825 633095 633424 634917 642130 642813 645706 647911 657312 660022 663432 663854 664676 668768 673152 673575 680854 684937 686710 687437 726463 785245 787257 796794 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (8.66%) |
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 686710 597872 554185 511821 560988 603061 612483 645706 527735 503775 543467 524116 521386 663854 633095 562106 490638 501072 598362 642813 613732 614637 600828 630825 528146 625547 591534 401103 500021 533459 551815 549380 492968 541096 664676 585873 485835 619414 633424 606717 551737 508268 796794 499301 604050 618220 539349 668768 596967 785245 787257 509361 562289 568739 567570 546266 555632 562821 657312 673575 589331 592308 535742 602438 477200 647911 76853 520327 609275 583716 564680 561300 591561 557306 726463 593966 602389 642130 535626 498890 513378 525151 505633 663432 684937 494672 615851 444586 526388 545623 581158 680854 464449 536912 496213 622294 114536 612847 673152 569965 591696 483871 558268 660022 583298 687437 490050 557908 561488 589015 535343 578163 559098 566334 618995 501209 550911 568782 634917 502028 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (2.01%) |
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 76853 114536 401103 444586 464449 477200 483871 485835 490050 490638 492968 494672 496213 498890 499301 500021 501072 501209 502028 503775 505633 508268 509361 511821 513378 520327 521386 524116 525151 527735 528146 533459 535343 535626 535742 536912 539349 541096 543467 545623 546266 549380 550911 551737 551815 554185 555632 557306 557908 558268 559098 560988 561300 561488 562106 562289 562821 564680 566334 567570 568739 568782 569965 578163 581158 583298 583716 585873 589015 589331 591534 591561 591696 592308 593966 596967 597872 598362 600828 602389 602438 603061 604050 606717 609275 612483 612847 613732 614637 615851 618220 618995 619414 622294 625547 630825 633095 633424 634917 642130 642813 645706 647911 657312 660022 663432 663854 664676 668768 673152 673575 680854 684937 686710 687437 726463 785245 787257 796794 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пизда ебут"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин секс"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.87%) |
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.