Query Metrics
7
Database Queries
7
Different statements
388.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
363.42 ms (93.51%) |
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 68383 94546 94669 100535 123416 129916 130022 306275 334472 348234 383517 387160 388296 391864 392874 398628 402666 403334 403966 404237 411467 426872 442696 453641 461384 462541 479000 512182 521976 523302 523314 523935 533054 542569 542964 550949 552049 558450 565042 567467 572744 573408 575695 595765 595831 601829 603172 603213 604536 606511 606565 620672 622111 622172 622656 623508 623517 624239 628350 640219 643927 645207 670062 670958 672396 672766 676344 683371 683435 691830 691878 695932 697971 703209 705541 707560 707970 714814 715649 721140 722520 727856 736439 742194 752154 753167 755109 756219 756766 757548 759326 760576 775816 775919 775947 775988 784148 788270 788745 788820 788930 789981 789983 792757 798815 801231 801271 804447 807148 810350 810661 816938 817348 817929 818537 818539 821680 822154 822219 822300 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (3.87%) |
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 595831 640219 620672 622172 622656 623508 788930 801271 788820 742194 760576 623517 775816 775919 788270 398628 348234 392874 403966 462541 479000 129916 402666 426872 461384 521976 523314 572744 558450 542964 565042 672766 573408 622111 595765 601829 624239 603172 775988 784148 756219 759326 442696 306275 523935 523302 68383 383517 123416 100535 130022 388296 403334 411467 816938 817348 822300 818537 821680 817929 818539 822154 822219 512182 533054 575695 542569 567467 552049 672396 691830 691878 695932 707970 714814 715649 722520 645207 670958 683371 683435 697971 707560 670062 676344 550949 628350 606511 603213 788745 789981 810661 789983 801231 753167 807148 727856 755109 756766 736439 752154 757548 604536 606565 643927 703209 705541 721140 775947 792757 798815 804447 810350 387160 391864 404237 453641 94546 94669 334472 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.65%) |
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 68383 94546 94669 100535 123416 129916 130022 306275 334472 348234 383517 387160 388296 391864 392874 398628 402666 403334 403966 404237 411467 426872 442696 453641 461384 462541 479000 512182 521976 523302 523314 523935 533054 542569 542964 550949 552049 558450 565042 567467 572744 573408 575695 595765 595831 601829 603172 603213 604536 606511 606565 620672 622111 622172 622656 623508 623517 624239 628350 640219 643927 645207 670062 670958 672396 672766 676344 683371 683435 691830 691878 695932 697971 703209 705541 707560 707970 714814 715649 721140 722520 727856 736439 742194 752154 753167 755109 756219 756766 757548 759326 760576 775816 775919 775947 775988 784148 788270 788745 788820 788930 789981 789983 792757 798815 801231 801271 804447 807148 810350 810661 816938 817348 817929 818537 818539 821680 822154 822219 822300 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group girls"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group девушк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group девушк"
]
|
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.