Query Metrics
7
Database Queries
7
Different statements
145.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.38 ms (84.00%) |
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 15440 84130 118017 123199 394710 401035 407810 416436 423912 442663 450933 451222 451853 457045 465504 475849 479204 479738 483735 494283 498550 500186 508378 509009 510250 510359 520083 520936 521696 527190 527842 530588 530818 535533 537321 539800 542587 543003 543142 546738 551488 556088 556677 562618 567619 583027 584431 586219 590784 591914 592240 592276 594219 596632 607697 623311 626104 635022 637986 638696 639530 644045 665394 666416 667058 673797 693507 720196 721714 725423 727977 731497 733761 734580 736209 738641 741155 747572 749004 754063 756623 757654 759749 762283 764438 765880 766135 766919 767379 768609 773680 774303 778487 782289 791783 793572 795229 795236 795986 796004 800790 800823 800899 803543 806828 808742 811680 813735 814703 817553 823363 823467 824062 826443 827174 828583 828701 828760 ] |
||||||||||||||||||||||||||||||
|
12.62 ms (8.66%) |
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 623311 800790 394710 457045 542587 479204 483735 766919 756623 586219 813735 814703 551488 693507 721714 666416 667058 592240 591914 637986 800899 734580 773680 795229 795236 800823 747572 754063 757654 759749 727977 795986 796004 806828 764438 590784 510250 828760 639530 15440 84130 826443 827174 817553 823363 823467 824062 824287 828701 828583 530588 510359 530818 543142 638696 644045 733761 741155 749004 782289 793572 811680 725423 736209 762283 768609 765880 767379 767592 720196 118017 791783 123199 407810 416436 442663 479738 535533 537321 494283 539800 527190 521696 475849 584431 562618 583027 546738 556677 665394 673797 596632 607697 635022 592276 594219 778487 808742 738641 766135 731497 774303 626104 423912 465504 401035 450933 451222 451853 508378 520083 498550 500186 509009 527842 520936 543003 567619 556088 803543 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (2.32%) |
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 15440 84130 118017 123199 394710 401035 407810 416436 423912 442663 450933 451222 451853 457045 465504 475849 479204 479738 483735 494283 498550 500186 508378 509009 510250 510359 520083 520936 521696 527190 527842 530588 530818 535533 537321 539800 542587 543003 543142 546738 551488 556088 556677 562618 567619 583027 584431 586219 590784 591914 592240 592276 594219 596632 607697 623311 626104 635022 637986 638696 639530 644045 665394 666416 667058 673797 693507 720196 721714 725423 727977 731497 733761 734580 736209 738641 741155 747572 749004 754063 756623 757654 759749 762283 764438 765880 766135 766919 767379 768609 773680 774303 778487 782289 791783 793572 795229 795236 795986 796004 800790 800823 800899 803543 806828 808742 811680 813735 814703 817553 823363 823467 824062 826443 827174 828583 828701 828760 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding big ass"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.14%) |
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.