Query Metrics
7
Database Queries
7
Different statements
155.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.17 ms (84.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 269276 392579 396382 397618 398865 399427 403074 411435 413439 433639 434623 438028 447157 449853 454455 458394 460005 473586 473596 476405 492268 493242 499000 509513 511369 517020 521480 523496 527243 532049 533470 542736 547557 557413 558187 560516 561157 561163 563851 565093 574184 579518 589923 590619 597865 605011 605065 605366 606764 607985 608753 626342 633225 645922 649310 650087 650101 651960 659345 671928 674259 685916 700934 709511 710135 714323 715970 717433 721761 724464 727081 729165 734714 736918 743877 744754 747735 751801 756813 756865 759493 760941 761895 761910 762643 763640 763678 763841 764138 765211 766120 766488 767060 767071 767223 769163 769472 771168 778937 778992 779377 779535 779912 784029 784228 788932 789286 794307 794864 796564 798983 801507 802024 809924 810187 813124 813764 814284 817326 827888 ] |
||||||||||||||||||||||||||||||
|
13.90 ms (8.92%) |
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 788932 767223 784029 744754 761895 769163 764138 771168 763841 709511 715970 779535 397618 433639 827888 533470 560516 563851 714323 671928 685916 645922 650101 659345 674259 561157 579518 605065 606764 607985 589923 779377 794307 796564 798983 801507 813124 756865 766120 724464 765211 767060 729165 760941 727081 736918 761910 763678 700934 789286 476405 473586 458394 447157 473596 527243 565093 511369 759493 547557 574184 493242 509513 269276 411435 813764 651960 633225 794864 734714 769472 767071 762643 434623 398865 521480 499000 558187 590619 597865 778937 460005 523496 403074 814284 817326 717433 784228 747735 743877 492268 557413 710135 721761 649310 626342 608753 751801 756813 766488 763640 605011 778992 779912 438028 392579 413439 396382 399427 449853 454455 532049 517020 561163 542736 650087 605366 802024 809924 810187 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (2.63%) |
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 269276 392579 396382 397618 398865 399427 403074 411435 413439 433639 434623 438028 447157 449853 454455 458394 460005 473586 473596 476405 492268 493242 499000 509513 511369 517020 521480 523496 527243 532049 533470 542736 547557 557413 558187 560516 561157 561163 563851 565093 574184 579518 589923 590619 597865 605011 605065 605366 606764 607985 608753 626342 633225 645922 649310 650087 650101 651960 659345 671928 674259 685916 700934 709511 710135 714323 715970 717433 721761 724464 727081 729165 734714 736918 743877 744754 747735 751801 756813 756865 759493 760941 761895 761910 762643 763640 763678 763841 764138 765211 766120 766488 767060 767071 767223 769163 769472 771168 778937 778992 779377 779535 779912 784029 784228 788932 789286 794307 794864 796564 798983 801507 802024 809924 810187 813124 813764 814284 817326 827888 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sex sister"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step секс sister"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step секс sister"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.