Query Metrics
7
Database Queries
7
Different statements
251.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.10 ms (89.46%) |
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 417263 421323 428385 429077 433676 439800 447751 457972 459484 461769 462115 462372 462854 470062 470080 477097 481780 487682 490086 492482 492553 494693 502762 502763 503688 503756 513557 518005 521438 522223 524225 534480 537236 541727 552227 552494 561819 561901 576042 576294 578299 590023 590461 591224 592111 594421 596991 597030 597077 597233 597568 597965 598783 600083 600123 613202 619974 621259 621733 623303 630289 634504 634804 640457 647340 652284 652519 652602 654078 677375 678783 679652 685819 702172 716032 720762 720805 722751 722847 725713 731511 733872 733873 733892 733910 735866 740009 743380 745682 748701 751565 752565 753442 757564 758963 758984 760409 761614 764519 765353 766402 767235 767326 769749 769760 769814 769816 770440 778842 783194 789782 791681 799045 800000 801274 805536 808318 813166 813584 826475 ] |
||||||||||||||||||||||||||||||
|
15.06 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 600083 791681 808318 733892 761614 767235 783194 735866 745682 748701 758963 725713 764519 769749 561819 722751 597030 596991 447751 462854 494693 490086 492482 621259 716032 613202 487682 590461 591224 462115 461769 417263 459484 524225 513557 502762 518005 537236 751565 521438 743380 826475 534480 578299 720805 722847 679652 594421 630289 592111 597077 731511 740009 758984 767326 813166 757564 765353 769814 753442 769760 770440 752565 769816 720762 778842 799045 805536 433676 470080 477097 541727 652284 597568 760409 766402 429077 503756 421323 647340 462372 457972 481780 503688 600123 597233 439800 502763 492553 813584 470062 576294 561901 576042 654078 678783 702172 652519 652602 677375 685819 552227 598783 619974 621733 623303 634504 590023 597965 634804 640457 800000 801274 789782 733872 733873 733910 522223 552494 428385 ] |
||||||||||||||||||||||||||||||
|
4.45 ms (1.77%) |
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 417263 421323 428385 429077 433676 439800 447751 457972 459484 461769 462115 462372 462854 470062 470080 477097 481780 487682 490086 492482 492553 494693 502762 502763 503688 503756 513557 518005 521438 522223 524225 534480 537236 541727 552227 552494 561819 561901 576042 576294 578299 590023 590461 591224 592111 594421 596991 597030 597077 597233 597568 597965 598783 600083 600123 613202 619974 621259 621733 623303 630289 634504 634804 640457 647340 652284 652519 652602 654078 677375 678783 679652 685819 702172 716032 720762 720805 722751 722847 725713 731511 733872 733873 733892 733910 735866 740009 743380 745682 748701 751565 752565 753442 757564 758963 758984 760409 761614 764519 765353 766402 767235 767326 769749 769760 769814 769816 770440 778842 783194 789782 791681 799045 800000 801274 805536 808318 813166 813584 826475 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen russian hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen русск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen русск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.64%) |
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.