Query Metrics
7
Database Queries
7
Different statements
139.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.64 ms (81.72%) |
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 542095 548680 551251 551416 551419 552932 553142 553505 557365 558831 558842 558959 560767 562244 564024 564409 566630 567200 567764 567769 569991 571619 571634 571635 571637 571647 572988 572999 573003 573015 573016 573017 573022 573031 573037 573045 573063 573070 573089 573090 573100 573119 573568 573638 573655 573674 573681 573682 573690 573699 573712 573780 573812 573816 573852 573877 573882 573891 574523 574571 574784 574810 574818 574896 574914 575085 575114 575159 575202 575214 575452 575454 575475 575478 575483 575520 575740 575805 575812 576028 576054 576057 576076 576351 576406 579611 584554 587376 597079 597512 598956 613333 621300 622826 622829 623691 624616 624829 625013 652590 670272 670383 672812 678698 679380 679385 682336 691414 691462 693278 693380 693385 701501 714948 718784 721459 730724 751576 751611 802908 ] |
||||||||||||||||||||||||||||||
|
15.98 ms (11.49%) |
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 558842 564024 566630 567200 567764 567769 571637 571647 572999 573003 573017 573045 573070 573812 573852 575159 575740 575805 542095 551419 558831 558959 562244 573016 573063 573674 573681 573682 573712 573877 575085 575114 575202 575454 576057 576406 551416 560767 571619 573031 573089 573090 573119 573568 573638 573655 573690 573699 573882 574523 574784 574810 574818 574914 575214 575452 575475 575520 575812 576028 576054 584554 652590 678698 682336 691414 693380 718784 670383 679380 693278 701501 721459 670272 672812 679385 691462 693385 714948 548680 551251 552932 553142 553505 557365 564409 569991 571634 571635 572988 573015 573022 573037 573100 573780 573816 573891 574571 574896 575478 575483 576076 576351 579611 597512 622826 587376 597079 598956 625013 622829 623691 624616 624829 613333 621300 730724 751576 751611 802908 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.87%) |
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 542095 548680 551251 551416 551419 552932 553142 553505 557365 558831 558842 558959 560767 562244 564024 564409 566630 567200 567764 567769 569991 571619 571634 571635 571637 571647 572988 572999 573003 573015 573016 573017 573022 573031 573037 573045 573063 573070 573089 573090 573100 573119 573568 573638 573655 573674 573681 573682 573690 573699 573712 573780 573812 573816 573852 573877 573882 573891 574523 574571 574784 574810 574818 574896 574914 575085 575114 575159 575202 575214 575452 575454 575475 575478 575483 575520 575740 575805 575812 576028 576054 576057 576076 576351 576406 579611 584554 587376 597079 597512 598956 613333 621300 622826 622829 623691 624616 624829 625013 652590 670272 670383 672812 678698 679380 679385 682336 691414 691462 693278 693380 693385 701501 714948 718784 721459 730724 751576 751611 802908 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn russian"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn русск"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn русск"
]
|
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.