Query Metrics
7
Database Queries
7
Different statements
323.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
292.11 ms (90.28%) |
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 148101 357943 394417 397014 401873 403600 413163 431022 431376 443724 457490 463630 469072 469338 494797 512793 514042 528084 530290 530329 531072 542979 548848 549965 561589 563014 566014 568034 568051 569394 570800 579227 580512 581878 591048 591944 596128 606826 608049 608432 612052 613096 616709 625435 640863 643092 665940 673654 676581 677319 685680 688594 694508 695618 698235 721748 722700 725571 725574 726289 734677 738521 740330 751486 753461 759463 760658 762062 769377 771243 774203 774256 775254 775943 779224 780340 781486 782677 786371 787101 787155 787165 789201 789295 790534 793294 795180 796206 796440 796920 796986 797700 797768 798942 800874 801223 801378 801424 801592 801871 802188 802414 802692 805110 805690 806181 806229 807491 810343 812518 815698 815944 817918 818242 818488 818608 821726 823163 825924 ] |
||||||||||||||||||||||||||||||
|
19.39 ms (5.99%) |
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 677319 580512 606826 608432 616709 789201 801378 801424 775943 782677 786371 797768 801871 802692 725574 751486 797700 762062 738521 760658 787165 802414 806229 443724 357943 397014 805110 818488 561589 581878 665940 579227 775254 725571 771243 698235 790534 591944 542979 569394 673654 625435 787155 793294 801223 802188 796206 608049 779224 780340 818608 818242 570800 694508 759463 780126 548848 514042 494797 403600 463630 817918 825924 815698 815944 821726 823163 530329 530290 549965 568034 568051 722700 676581 685680 695618 688594 643092 596128 640863 612052 798942 801592 781486 810343 726289 769377 774256 787101 789295 795180 734677 774203 753461 613096 796440 796920 800874 148101 401873 796986 812518 563014 457490 431022 566014 591048 807491 806181 721748 469072 469338 413163 512793 740330 528084 394417 431376 531072 805690 ] |
||||||||||||||||||||||||||||||
|
4.32 ms (1.33%) |
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 148101 357943 394417 397014 401873 403600 413163 431022 431376 443724 457490 463630 469072 469338 494797 512793 514042 528084 530290 530329 531072 542979 548848 549965 561589 563014 566014 568034 568051 569394 570800 579227 580512 581878 591048 591944 596128 606826 608049 608432 612052 613096 616709 625435 640863 643092 665940 673654 676581 677319 685680 688594 694508 695618 698235 721748 722700 725571 725574 726289 734677 738521 740330 751486 753461 759463 760658 762062 769377 771243 774203 774256 775254 775943 779224 780340 781486 782677 786371 787101 787155 787165 789201 789295 790534 793294 795180 796206 796440 796920 796986 797700 797768 798942 800874 801223 801378 801424 801592 801871 802188 802414 802692 805110 805690 806181 806229 807491 810343 812518 815698 815944 817918 818242 818488 818608 821726 823163 825924 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom beauty"
]
|
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.