Query Metrics
7
Database Queries
7
Different statements
152.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.17 ms (85.31%) |
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 93524 96955 395275 397188 401614 401757 404946 406404 410651 417094 418623 440902 446999 447662 453820 464929 467953 468453 472272 486589 496750 502781 509859 519444 525081 532365 533164 547220 549089 552653 568093 575625 576934 584246 585457 588162 589067 593599 600146 604311 613240 618074 618363 623289 632568 638585 661950 662203 665959 665980 677053 678554 679660 702046 711937 712698 715892 717837 722925 723566 726221 727266 728151 729644 730355 731350 731463 731565 733661 734483 736830 740839 747430 747740 747815 749688 750760 760895 761711 761748 761814 764125 765428 765717 766634 766740 766762 767276 767289 767318 768261 771039 771288 773097 773314 775484 775614 775896 789465 790496 791364 792139 792571 798675 799091 799348 799974 805655 806649 807353 809306 811552 813984 814008 816016 820167 820901 825941 827899 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (8.28%) |
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 519444 96955 677053 588162 761748 805655 809306 486589 820167 820901 773314 791364 397188 417094 576934 665959 792139 765428 731565 723566 730355 761814 765717 767276 766762 740839 575625 679660 767289 764125 816016 502781 547220 638585 618074 775484 771288 733661 731350 533164 661950 600146 726221 604311 775896 736830 827899 447662 768261 395275 702046 799348 734483 790496 813984 814008 665980 789465 792571 767318 728151 799974 806649 729644 750760 761711 93524 585457 593599 404946 440902 532365 549089 717837 584246 771039 766740 632568 715892 722925 825941 712698 678554 618363 798675 727266 772133 773097 613240 623289 775614 472272 418623 552653 568093 749688 401757 410651 446999 468453 589067 747740 799091 525081 453820 464929 496750 467953 711937 662203 807353 811552 747430 747815 760895 731463 766634 401614 509859 406404 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.62%) |
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 93524 96955 395275 397188 401614 401757 404946 406404 410651 417094 418623 440902 446999 447662 453820 464929 467953 468453 472272 486589 496750 502781 509859 519444 525081 532365 533164 547220 549089 552653 568093 575625 576934 584246 585457 588162 589067 593599 600146 604311 613240 618074 618363 623289 632568 638585 661950 662203 665959 665980 677053 678554 679660 702046 711937 712698 715892 717837 722925 723566 726221 727266 728151 729644 730355 731350 731463 731565 733661 734483 736830 740839 747430 747740 747815 749688 750760 760895 761711 761748 761814 764125 765428 765717 766634 766740 766762 767276 767289 767318 768261 771039 771288 773097 773314 775484 775614 775896 789465 790496 791364 792139 792571 798675 799091 799348 799974 805655 806649 807353 809306 811552 813984 814008 816016 820167 820901 825941 827899 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best анал"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best of anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
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.