Query Metrics
7
Database Queries
7
Different statements
143.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.79 ms (82.17%) |
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 395395 396757 403229 406125 415053 416242 420494 430814 443396 453816 454118 456221 471990 478655 480419 480727 487154 495673 502302 509084 510512 519487 523709 524719 527508 528379 530494 532442 537319 539489 542146 542706 548744 552110 552467 552508 552609 554366 561713 562272 564630 567726 571050 571074 577553 579178 583027 587977 592431 592459 595572 595646 598395 600081 600242 600501 600610 604147 605380 607800 609896 613443 613850 625901 637965 643681 654394 659410 666723 672408 677342 677957 679713 683787 687185 696500 704658 708551 717867 717898 718710 723932 727690 728287 730098 730372 731971 732878 733856 733889 733896 733907 736291 737786 740407 742224 747439 749723 750426 750637 751307 751722 752685 758557 761474 763536 772449 773664 775231 775780 775849 777502 779054 788800 791385 796981 800568 802765 813128 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (10.84%) |
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 605380 637965 779054 800568 813128 775231 802765 737786 750637 772449 773664 747439 750426 752685 723932 733856 740407 742224 727690 728287 751307 751722 736291 758557 761474 609896 613443 777502 791385 796981 420494 403229 395395 396757 415053 524719 510512 523709 519487 530494 552508 552467 659410 732878 406125 443396 416242 430814 595572 454118 453816 471990 480727 487154 456221 478655 480419 495673 502302 509084 527508 537319 528379 539489 532442 552110 562272 567726 542706 552609 561713 564630 571050 577553 583027 542146 548744 579178 654394 677342 696500 704658 717867 717898 674534 677957 679713 683787 687185 666723 672408 708551 554366 571074 587977 592459 595646 598395 613850 604147 600501 592431 600081 600242 600610 775780 775849 733889 733896 733907 749723 730098 731971 763536 730372 607800 625901 643681 718710 788800 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.93%) |
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 395395 396757 403229 406125 415053 416242 420494 430814 443396 453816 454118 456221 471990 478655 480419 480727 487154 495673 502302 509084 510512 519487 523709 524719 527508 528379 530494 532442 537319 539489 542146 542706 548744 552110 552467 552508 552609 554366 561713 562272 564630 567726 571050 571074 577553 579178 583027 587977 592431 592459 595572 595646 598395 600081 600242 600501 600610 604147 605380 607800 609896 613443 613850 625901 637965 643681 654394 659410 666723 672408 677342 677957 679713 683787 687185 696500 704658 708551 717867 717898 718710 723932 727690 728287 730098 730372 731971 732878 733856 733889 733896 733907 736291 737786 740407 742224 747439 749723 750426 750637 751307 751722 752685 758557 761474 763536 772449 773664 775231 775780 775849 777502 779054 788800 791385 796981 800568 802765 813128 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen sweet"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen милая"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen милая"
]
|
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.