Query Metrics
7
Database Queries
7
Different statements
156.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.45 ms (78.76%) |
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 188395 385752 386734 390623 390950 391959 397781 410651 413183 416294 417836 419320 424436 424658 424875 428113 429899 445395 446079 446131 452832 460171 461282 466012 466392 466884 467940 472001 473832 475056 482231 485311 486192 503836 504020 508807 511027 512809 526089 529369 533594 535384 538870 544323 544478 547423 547428 554866 555288 555337 555387 555425 559139 560077 562147 564304 568060 577039 583953 595772 596844 604313 605157 609887 612816 640677 643767 644285 644296 651635 656200 660732 665790 665936 670904 677724 680215 681075 683003 694222 695871 696120 698423 705710 707408 720714 722212 726942 727560 731328 731463 733217 733416 738528 744463 758256 767287 769291 776312 787274 792533 798705 800052 800288 800712 805222 805777 807394 814178 814926 815054 815943 816545 817119 817154 817632 818468 820586 823746 825304 ] |
||||||||||||||||||||||||||||||
|
24.25 ms (15.47%) |
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 504020 555425 665936 670904 640677 609887 643767 800052 787274 744463 720714 460171 461282 188395 390950 419320 466392 475056 473832 424436 424658 386734 529369 535384 526089 559139 568060 544323 555337 726942 769291 731328 391959 429899 547423 776312 385752 390623 817632 823746 816545 820586 815943 817119 818468 538870 554866 555288 694222 722212 656200 680215 677724 681075 696120 596844 605157 800712 798705 807394 733416 758256 562147 446131 508807 555387 428113 814926 651635 544478 792533 424875 814178 815054 452832 472001 482231 485311 533594 547428 564304 583953 683003 660732 665790 695871 698423 577039 644285 612816 604313 595772 805222 805777 800288 767287 727560 733217 731463 738528 644296 705710 707408 445395 413183 416294 466012 503836 486192 397781 410651 417836 825304 817154 446079 466884 512809 511027 467940 560077 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.40%) |
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 188395 385752 386734 390623 390950 391959 397781 410651 413183 416294 417836 419320 424436 424658 424875 428113 429899 445395 446079 446131 452832 460171 461282 466012 466392 466884 467940 472001 473832 475056 482231 485311 486192 503836 504020 508807 511027 512809 526089 529369 533594 535384 538870 544323 544478 547423 547428 554866 555288 555337 555387 555425 559139 560077 562147 564304 568060 577039 583953 595772 596844 604313 605157 609887 612816 640677 643767 644285 644296 651635 656200 660732 665790 665936 670904 677724 680215 681075 683003 694222 695871 696120 698423 705710 707408 720714 722212 726942 727560 731328 731463 733217 733416 738528 744463 758256 767287 769291 776312 787274 792533 798705 800052 800288 800712 805222 805777 807394 814178 814926 815054 815943 816545 817119 817154 817632 818468 820586 823746 825304 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal milf hairy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал milf волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал milf волосатая"
]
|
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.